The following is a list of objects— user space objects (views, reports, tables, and so on), commands, and programs—added to the SEQUELEX example library during the installation of Sequel.
Object |
Type |
Attribute |
Size |
Text |
---|---|---|---|---|
SQDATE |
*CMD |
|
8192 |
Add/remove records from SQDATE conversion file |
SQXRELMOD |
*DTAARA |
|
8192 |
|
ARFILE |
*FILE |
PF |
385024 |
Acc - Accounts Receivable |
BS_RULES |
*FILE |
PF |
40960 |
Acc - Consolidated Income Statement |
BUDVACTPCT |
*FILE |
PF |
49152 |
Acc - Income Statement Budget |
CHAR2NUM |
*FILE |
PF |
36864 |
Char/Numeric Conversion File |
CUSTCOPY |
*FILE |
PF |
57344 |
Customer Master With CHAR Cusno Field |
CUSTMAST |
*FILE |
PF |
135168 |
Customer Master |
CUSTMAST2 |
*FILE |
PF |
98304 |
Create Step2 File for COLROW12R Report |
CVTDATE |
*FILE |
PF38 |
102400 |
Date - Julian offset - Month - Day |
CVTDATEL1 |
*FILE |
LF38 |
53248 |
Date - Julian offset - Month - Day |
DATAMART |
*FILE |
PF |
6328320 |
Management Summary Level Information |
DSPFFD |
*FILE |
PF |
57344 |
Output file for DSPFFD |
DSPOBJD |
*FILE |
PF |
65536 |
Output file for DSPOBJD |
GLMAST |
*FILE |
PF |
1089536 |
Acc - Balance Sheet |
INVDTOFSET |
*FILE |
PF |
36864 |
Year Offset for INVMAST Aging |
INVMAST |
*FILE |
PF |
36864 |
Invoice Master |
IS_RULES |
*FILE |
PF |
36864 |
Acc - Consolidated Income Statement |
KPW01 |
*FILE |
PF |
69632 |
Acc- generl ledger |
OPTFILE |
*FILE |
PF |
299008 |
Option File - drilldown |
ORDHEAD |
*FILE |
PF |
57344 |
Order Header |
ORDHEADADV |
*FILE |
PF |
49152 |
Copy of ORDHEAD for Aging |
ORDLINE |
*FILE |
PF |
69632 |
Open Orders - Order line items |
ORDTEOFSET |
*FILE |
PF |
36864 |
Offset Value for ORDHEADADV Aging |
PARTMAST |
*FILE |
PF |
65536 |
Product master |
PERIODS |
*FILE |
PF |
94208 |
Sales - Yearly Information |
PHONELOG |
*FILE |
PF |
86016 |
Customer Call Information |
PRODUCTS |
*FILE |
PF |
77824 |
Sales - Product Category |
REGIONLIST |
*FILE |
PF |
53248 |
Outfile from view SQLEXEC |
REGMAST |
*FILE |
PF |
36864 |
Region Master |
REGMGRLST |
*FILE |
PF |
36864 |
Region Manager List |
RUNTIME |
*FILE |
DSPF |
8192 |
|
SALESFACT |
*FILE |
PF |
430080 |
Sales - product sale information |
SALESHIST |
*FILE |
PF |
1875968 |
Sales History |
SALMAST |
*FILE |
PF |
36864 |
Sales Rep Master |
SOURCE |
*FILE |
PF38 |
204800 |
Example Source Information |
SPLOGOFSET |
*FILE |
PF |
61440 |
Offset for SUPLOG Aging |
SQDATE |
*FILE |
PF |
57344 |
Date data - work file |
SQXPOL |
*FILE |
PF |
126976 |
|
STATEREF |
*FILE |
PF |
53248 |
State references |
STORES |
*FILE |
PF |
53248 |
Sales - Store id and location |
TRIANGLES |
*FILE |
PF38 |
53248 |
Leg lengths for triangles |
TRW4B_5 |
*FILE |
PF |
36864 |
Customer with more than one order |
VENDMAST |
*FILE |
PF |
49152 |
Vendor Master |
ZIPLIST |
*FILE |
PF |
36864 |
File for CUSTADDR DBList |
RUNTIME |
*MSGF |
|
20480 |
|
AGE1 |
*PGM |
CLP |
36864 |
Age Advanced Training Files |
DATECALC |
*PGM |
RPG |
73728 |
|
RUNTIME1 |
*PGM |
CLP |
36864 |
Runtime SQL statement substitution (CHGVAR) |
RUNTIME2 |
*PGM |
CLP |
40960 |
Runtime SQL statement substitution |
RUNTIME3 |
*PGM |
CLP |
36864 |
Runtime SQL statement substitution (MSGF) |
RUNTIME4 |
*PGM |
CLP |
36864 |
EXECUTE & PRINT examples with SETVAR |
RUNTIME5 |
*PGM |
CLP |
45056 |
Example using SEQRTRNP API to return prompt values |
SQDATEC |
*PGM |
CLP |
40960 |
Date conversion |
QRYCVT1 |
*QRYDFN |
QRY |
45056 |
|
ACCUM |
*USRSPC |
SQLVIEW |
1232896 |
Accumulate AMTDU for Cstte, Ctype, and rowset |
ADV_DOTST |
*USRSPC |
SQLSCRIPTP |
4096 |
Advance Script of DOWHILE and DOLOOP |
ADV_VARTST |
*USRSPC |
SQLSCRIPTP |
4096 |
Advance Script to test Variable Input |
ADVTRRPT1 |
*USRSPC |
SQLVIEW |
12288 |
Current Month and YTD Sales by Item with CVTDATE |
ADVTRRPT1R |
*USRSPC |
SQLRPT |
12288 |
Current Month and Year-to-Date Sales by Item |
ADVTRRPT2 |
*USRSPC |
SQLVIEWP |
12288 |
Aging Report with Variable Summarization Levels |
ADVTRRPT2R |
*USRSPC |
SQLRPT |
12288 |
Aging Report with Variable summarization Levels |
ADVUPINVMS |
*USRSPC |
SQLVIEW |
12288 |
INVMAST File Dates |
ADVUPOHEAD |
*USRSPC |
SQLVIEW |
12288 |
ORDHEADADV File Dates |
ADVUPSPLOG |
*USRSPC |
SQLVIEW |
12288 |
SUPLOG File dates |
AGEINV |
*USRSPC |
SQLVIEW |
12288 |
Update INVMAST File Dates |
AGEORDER |
*USRSPC |
SQLVIEW |
20480 |
Order Placement Age Information for 2002 - day cnt |
AGEORDERR |
*USRSPC |
SQLRPT |
8192 |
Order Placement Count Report |
AGESCRIPT |
*USRSPC |
SQLSCRIPT |
4096 |
Script to age SEQUELEX training files |
AGINGCASE |
*USRSPC |
SQLTBLV |
12288 |
Aging Case Table 30-60-90-Over |
AGINGSTEP |
*USRSPC |
SQLTBLV |
8192 |
Aging Step Table 30-60-90-Over |
AGINGSTEP2 |
*USRSPC |
SQLVIEWP |
12288 |
View to drill into - from AGINGSTEP Table - DBLIST |
AGINGSTEP3 |
*USRSPC |
SQLTBLV |
8192 |
Table to drill into from AGINGSTEP Table |
AGINGTBLAP |
*USRSPC |
SQLAPP |
8192 |
AGING DrillDown - Table to View or Table - APP |
APP1 |
*USRSPC |
SQLAPP |
8192 |
Customer Mapquest Search |
APP2 |
*USRSPC |
SQLAPP |
8192 |
Drill Down Training Example |
AR |
*USRSPC |
SQLVIEW |
1261568 |
Aging of AR - Group by Region with KPI’s |
AUTOJOINEX |
*USRSPC |
SQLVIEW |
12288 |
Auto Join Template |
BAL_SHEET |
*USRSPC |
SQLVIEW |
77824 |
Consolidated Balance Sheet view |
BAL_SHEETR |
*USRSPC |
SQLRPTC |
1544192 |
Still have questions? We can help. Submit a case to Technical Support.