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 he installation ShowCase 10.
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 |
Consolidated Balance Sheet Report |
BAL_YEAR |
*USRSPC |
SQLVIEW |
12288 |
Historical Total Balance by admit year |
CENTER |
*USRSPC |
SQLVIEW |
12288 |
Center a string |
CHAR2NUM |
*USRSPC |
SQLVIEW |
12288 |
Convert left-justified character value to numeric |
COLROW |
*USRSPC |
SQLVIEWP |
12288 |
Create multi-column (down then across) report |
COLROW1 |
*USRSPC |
SQLVIEW |
12288 |
Create Step1 file for COLROW12R Report |
COLROW12R |
*USRSPC |
SQLRPT |
36864 |
12 cpi multi-up labels with blank row compression |
COLROW2 |
*USRSPC |
SQLVIEWP |
12288 |
Create Step2 File for COLROW12R Report |
COLROWSCPT |
*USRSPC |
SQLSCRIPTP |
36864 |
Script to Run COLROW12R Report |
COLROWVIEW |
*USRSPC |
SQLVIEWP |
12288 |
Create multi-column (down then across) report |
COMPYEAR |
*USRSPC |
SQLVIEW |
12288 |
1998/1999 Order Dollar Comparison |
COMPYEARR |
*USRSPC |
SQLRPT |
8192 |
1998/1999 Sales Comparison MTD |
CONSOL_BS |
*USRSPC |
SQLVIEW |
225280 |
Balance sheet 2006, 2007, 2008 colored |
CONSOL_IS |
*USRSPC |
SQLVIEW |
40960 |
Income Statement for 2 years with Variance - SUM |
COVERPAGE |
*USRSPC |
SQLVIEW |
12288 |
View for Coverpage Report |
COVERPAGER |
*USRSPC |
SQLRPT |
8192 |
Example of a Report With a Cover Page |
CRLIMCOMP |
*USRSPC |
SQLVIEW |
12288 |
Credit Limit versus Total Amount On Order |
CROREP |
*USRSPC |
SQLRPTC |
36864 |
Customer Credit Limit - graphics included |
CROVIEW |
*USRSPC |
SQLVIEW |
245760 |
cro charts Report |
CTVIEW |
*USRSPC |
SQLVIEW |
487424 |
Sales Detail for Client Table |
CTVIEWL |
*USRSPC |
SQLTBLC |
12288 |
Business Sales Detail Table |
CUMMAMTDU |
*USRSPC |
SQLVIEW |
12288 |
Cummulative sum of amtdu |
CUSTADDR |
*USRSPC |
SQLVIEWP |
12288 |
View for Mapquest Application - SUBSTRING |
CUSTLIST |
*USRSPC |
SQLVIEW |
446464 |
Customer Inquiry |
CUSTLISTP |
*USRSPC |
SQLVIEWP |
12288 |
Customer Inquiry with MULTIPLE state selection |
CUSTLISTP1 |
*USRSPC |
SQLVIEWP |
12288 |
Customer Inquiry - OMIT Leading and Trailing Text |
CUSTLISTR |
*USRSPC |
SQLRPT |
12288 |
Customer A/R Amounts |
CUSTORD |
*USRSPC |
SQLVIEWP |
12288 |
Customer Order Summary |
CUSTORDD |
*USRSPC |
SQLVIEWP |
12288 |
Customer Order Detail |
CUSTORDDR |
*USRSPC |
SQLRPT |
8192 |
Customer Order Detail for &&date1 and &&date2 |
CUSTORDER |
*USRSPC |
SQLVIEW |
12288 |
Customer Order Summary |
CUSTORDERR |
*USRSPC |
SQLRPT |
8192 |
Customer Order Summary |
CUSTORDR |
*USRSPC |
SQLRPT |
8192 |
Customer Order Summary - &&date1 to &&date2 |
CUSTORDS |
*USRSPC |
SQLSCRIPTP |
4096 |
Customer info, orders, and report |
CUSTYPE |
*USRSPC |
SQLVIEW |
12288 |
Customer state, type, region and amount |
CUSTYPETBL |
*USRSPC |
SQLTBLV |
8192 |
Customer table -- Amount by type & state |
CYPY |
*USRSPC |
SQLVIEW |
69632 |
Current Year-Prior Year Analysis |
DASHBOARD1 |
*USRSPC |
SQLDASH |
8192 |
Dashboard - KPI - Sales Example 1 |
DASHBOARD2 |
*USRSPC |
SQLDASH |
8192 |
Dashboard - KPI - Sales Example 2 |
DATAMART |
*USRSPC |
SQLVIEW |
12288 |
Summary Level Information with CASE - IF/THEN |
DATEEX |
*USRSPC |
SQLVIEWP |
12288 |
Date Variable Example to View Calendar *MDY |
DATEEX2 |
*USRSPC |
SQLVIEWP |
12288 |
Date Variable Example to View Calendar *EUR Format |
DATEVALID1 |
*USRSPC |
SQLVIEW |
12288 |
Use VALID DATE operator to find bad date records. |
DATEVALID2 |
*USRSPC |
SQLVIEW |
16384 |
Use VALID DATE single and multi field examples. |
DBLISTV |
*USRSPC |
SQLVIEWP |
12288 |
DBLIST with Filter based on second variable |
DDBEGIN |
*USRSPC |
SQLVIEW |
20480 |
Initial View for Drill Down Process |
DDCUSNO |
*USRSPC |
SQLVIEWP |
12288 |
Customers within a region - number type variable |
DDORDHEAD |
*USRSPC |
SQLVIEWP |
12288 |
Orders for a customer |
DDORDLINE |
*USRSPC |
SQLVIEWP |
12288 |
Line items for a specific order |
DDPRDNO1 |
*USRSPC |
SQLVIEWP |
12288 |
Product Variance Within a Region |
DDPRDNO2 |
*USRSPC |
SQLVIEWP |
12288 |
Line items for a specific product |
DDREGON |
*USRSPC |
SQLVIEW |
1232896 |
Customer summary by region |
DIST_INSRT |
*USRSPC |
SQLSCRIPTP |
36864 |
Insert single record into SCSERVER10/DISTANCE file. |
DISTINSRT |
*USRSPC |
SQLVIEWP |
12288 |
View used by DIST INSRT Script. |
DUPLEX |
*USRSPC |
SQLVIEW |
16384 |
Order Acknowledgements |
DUPLEXR |
*USRSPC |
SQLRPT |
8192 |
Forced Page Breaks for Duplex Printing |
EDIT |
*USRSPC |
SQLVIEW |
12288 |
Edit a numeric value and return a string |
EMAILFROM |
*USRSPC |
SQLSCRIPTP |
36864 |
Dynamically change the from address on an e-mail |
FIELDICT |
*USRSPC |
SQLVIEW |
12288 |
External Field Dictionary |
GENERIC |
*USRSPC |
SQLVIEWP |
12288 |
Generic file query |
GHBEXER1 |
*USRSPC |
SQLVIEW |
16384 |
Customers in name order - Order Only example |
GHBEXER1A |
*USRSPC |
SQLVIEW |
12288 |
Customer credit available |
GHBEXER2 |
*USRSPC |
SQLVIEW |
12288 |
Selected Products - Cost, Price, Margin |
GHBEXER3 |
*USRSPC |
SQLVIEW |
12288 |
Products on order for customers in CA, AZ, TX |
GHBEXER4 |
*USRSPC |
SQLVIEW |
12288 |
Summary of customer orders |
GHBEXER5 |
*USRSPC |
SQLVIEW |
12288 |
Customer order summary - Selling vs. List price |
GHBEXER5R |
*USRSPC |
SQLRPT |
12288 |
Total retail value Vs. Total selling price |
GHBEXER6R |
*USRSPC |
SQLRPT |
12288 |
Order summary by customer |
HREF1 |
*USRSPC |
SQLVIEW |
12288 |
SWI Drill Down Step 1 |
HREF2 |
*USRSPC |
SQLVIEWP |
12288 |
SWI Drill Down Step 2 |
HREF3 |
*USRSPC |
SQLVIEWP |
12288 |
SWI Drill Down Step 3 |
IMG |
*USRSPC |
SQLVIEW |
12288 |
Create HTML IMG tag for a graphic & size value |
IS_B2A |
*USRSPC |
SQLVIEW |
53248 |
Income statement actual and next year budget |
KPI_01 |
*USRSPC |
SQLVIEWP |
86016 |
Income statement for a rolling year |
LABELLAS10 |
*USRSPC |
SQLRPT |
36864 |
10 cpi multi-up laser labels |
LABELRPT10 |
*USRSPC |
SQLRPT |
36864 |
10 cpi multi-up labels with blank row compression |
LABELRPT15 |
*USRSPC |
SQLRPT |
36864 |
15 cpi multi-up labels with blank row compression |
LABELS |
*USRSPC |
SQLVIEWP |
12288 |
Create multi-column (across then down) report |
LABELSCPT |
*USRSPC |
SQLSCRIPTP |
36864 |
Script to Run LABELSR Report |
LABELSR |
*USRSPC |
SQLRPT |
36864 |
10 cpi multi-up labels with blank row compression |
LABELVIEW |
*USRSPC |
SQLVIEWP |
12288 |
Create multi-column (across then down) report |
LSTPAYMNT |
*USRSPC |
SQLVIEWP |
12288 |
Last Payments by State & Month |
LSTPAYMNTT |
*USRSPC |
SQLTBLV |
12288 |
Last Payment Totals by State & Month |
OBJCRTDATE |
*USRSPC |
SQLSCRIPTP |
4096 |
Library objects in creation date order |
OBJSIZE |
*USRSPC |
SQLVIEW |
16384 |
Object list in descending size order |
ORDERACK |
*USRSPC |
SQLVIEW |
20480 |
Order Acknowledgements |
ORDERAMT |
*USRSPC |
SQLVIEW |
12288 |
Sum of customer orders by customer |
ORDERINQ |
*USRSPC |
SQLVIEW |
16384 |
Order inquiry (a 4 file join) |
ORDERLIST |
*USRSPC |
SQLVIEW |
16384 |
Order Acknowledgement |
ORDERLISTR |
*USRSPC |
SQLRPT |
8192 |
Order Acknowledgment w/PDF Overlay |
ORDERPRINT |
*USRSPC |
SQLRPT |
12288 |
Order Acknowledgement |
ORDERPRNT |
*USRSPC |
SQLVIEW |
311296 |
Order Acknowledgement Laser View |
ORDERPRNTC |
*USRSPC |
SQLRPTC |
245760 |
Order Acknowledgement Laser Report |
ORDERS |
*USRSPC |
SQLVIEW |
20480 |
Open Order Template |
ORDERSUM |
*USRSPC |
SQLVIEW |
20480 |
Order summary - header info for each order by cust |
ORDERSUMP |
*USRSPC |
SQLVIEWP |
12288 |
Order summary - header info for each order by cust |
ORDHIST |
*USRSPC |
SQLVIEWP |
12288 |
Prior Year and YTD Order Information |
ORDHISTR |
*USRSPC |
SQLRPT |
12288 |
Monthly Order Dollar Totals for Prior and YTD |
PAYMENTS |
*USRSPC |
SQLVIEW |
20480 |
Monthly Payment Summary |
PCTCHG |
*USRSPC |
SQLVIEW |
12288 |
Calculate percent change between two numbers |
PICKLIST |
*USRSPC |
SQLVIEW |
12288 |
Picking list for Customer Orders |
PMBALANCE |
*USRSPC |
SQLVIEW |
12288 |
Product Status |
PROPER |
*USRSPC |
SQLVIEW |
12288 |
Proper case (1st char of each word) |
RECEIVABLE |
*USRSPC |
SQLVIEW |
12288 |
Sum of Customer Balance |
REGIADR |
*USRSPC |
SQLSCRIPTP |
4096 |
Insert a New Unique Email Recipient |
REGIONLIST |
*USRSPC |
SQLVIEW |
12288 |
Display Region Managers - List of Email Recipients |
REGIONSCRP |
*USRSPC |
SQLSCRIPT |
4096 |
Script To Email Customized Excel Files to Managers |
REGIONTAB |
*USRSPC |
SQLTBLV |
8192 |
Table Creates a Spreadsheet-Column for Each Month |
REGIONVIEW |
*USRSPC |
SQLVIEWP |
12288 |
Retrieve Sales Data |
REGUADR |
*USRSPC |
SQLVIEWP |
12288 |
Update Region Manager Email Addresses |
REGUAX |
*USRSPC |
SQLSCRIPTP |
4096 |
Script to Update Email Addresses |
REPORTOVR |
*USRSPC |
SQLSCRIPTP |
4096 |
Print Host Reports in non Duplex |
ROLLING6 |
*USRSPC |
SQLVIEWP |
12288 |
Rolling 6 Month Information |
ROLLING6R |
*USRSPC |
SQLRPT |
12288 |
Calls from &start to &finish |
ROLLING6T |
*USRSPC |
SQLTBLV |
12288 |
Rolling 6 month |
RUNTIME |
*USRSPC |
SQLVIEW |
12288 |
IL customers owing more than 0 |
SALES |
*USRSPC |
SQLVIEW |
122880 |
Sales Analysis Template |
SALESDET |
*USRSPC |
SQLVIEW |
12288 |
Business Sales Detail |
SALESINFO |
*USRSPC |
SQLVIEW |
12288 |
Sales Information - Revenue, Cost, Units, Margin |
SALESMN |
*USRSPC |
SQLVIEWP |
12288 |
Sales with Variable Month Comparison View |
SALESMONTH |
*USRSPC |
SQLVIEW |
12288 |
Sales Month Comparison View |
SALESQTR |
*USRSPC |
SQLVIEW |
12288 |
Sales Quarter Comparison View |
SPLIT |
*USRSPC |
SQLVIEW |
12288 |
Split string using a delimiter |
SQUSERS |
*USRSPC |
|
36864 |
Current Interactive/ViewPoint users |
STATECOUNT |
*USRSPC |
SQLVIEW |
12288 |
Number of customers in each state |
STRIPX |
*USRSPC |
SQLVIEW |
12288 |
Strip character from a string |
TOPAMTDU |
*USRSPC |
SQLVIEWP |
12288 |
Choose Top Customers Based on Amtdu |
TOPTEN |
*USRSPC |
SQLVIEW |
12288 |
Top Ten Customers Based on Amount Due |
TOPTENR |
*USRSPC |
SQLRPT |
12288 |
Top Ten Customers by Amount Due |
TRIANGLES |
*USRSPC |
SQLVIEW |
12288 |
Triangle measurements |
TRW4B5 |
*USRSPC |
SQLVIEW |
12288 |
Customer with more than one order |
TRW4B6 |
*USRSPC |
SQLVIEW |
12288 |
Order Information for Customer with > one order |
TRW4B6R |
*USRSPC |
SQLRPT |
8192 |
Order Infromation for Customer with > one order |
UDFDATE |
*USRSPC |
SQLVIEW |
12288 |
Convert date data type to various packed formats |
UNPACK |
*USRSPC |
SQLVIEW |
12288 |
Unpack decimal and binary values |
URLSTRING |
*USRSPC |
SQLVIEW |
12288 |
Convert Invalid Char to STD URL String |
USERCPUVW |
*USRSPC |
SQLVIEW |
12288 |
CPU usage by user |
WEEKLYVW |
*USRSPC |
SQLVIEW |
12288 |
Weekly totals for last 200 weeks |
WTVIEW |
*USRSPC |
SQLVIEW |
12288 |
Walk Through View |
Still have questions? We can help. Submit a case to Technical Support.