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.
