Installed SEQUELEX Objects

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