Account List Tables

Component tables

When Account List editor saves the account list, it stores it in two tables one of which carries the names and id numbers of the lists, and another one contains the account ranges that the lists are made of.

The first table is SF_SYSAccountRangeNames, and has the following structure:

Column Generalized data type Use
SF_NameId SMALLINT Unique id number of the account list
SF_Name VARCHAR(255) Name of the account list
SF_Description VARCHAR(255) Description of the account list
SF_UserId VARCHAR(255) User-id of the user that last saved the list
SF_DateChanged CHAR(8) Date of the last update of the row (CCYYMMDD)
SF_TimeChanged CHAR(6) Time of the last update of the row (HHMMSS)
SF_TimeStamp SMALLINT Version of the row (incremented with each update)

The following partial example shows some rows from table SF_SYSAccountRangeNames:

SF_NameId SF_Name    SF_Description
--------- ---------- ----------------------------------------
6         CSV        Cash Surrender Value - Life Insurance
8         FA         Fixed Assets
9         Land       Land only
14        CL         Current Liabilities
16        AP         Accounts Payable
18        CPLTD      Current Portion Long Term Debt
19        LTD        Long Term Debt
20        StockP     Stock Purchases
23        EQ         Equity
24        EQCS       Equity, Capital Stock
26        EQPL       Equity, Current Profit & Loss
27        AR         Accounts Receivable
31        FAC        Fixed Assets, Cost
32        FAD        Fixed Assets, Depreciation
33        TA         Total Assets
30        INV        Inventory, Merchandise and Supplies
28        InvM       Merchandise
35        FAM        Machinery & Equipment
36        FAB        Buildings
37        FAA        Automobiles & Trucks

The second table is SF_SYSAccountRanges, and has the following structure:

Column Generalized data type Use
SF_NameId SMALLINT Unique id number of the account list
SF_FromAccount VARCHAR(255) First account number in the range
SF_ToAccount VARCHAR(255) Last account number in the range
SF_TimeStamp SMALLINT Version of the row (incremented with each update)

The following partial example shows some rows from table SF_SYSAccountRanges:

SF_NameId SF_FromAccount SF_ToAccount
--------- -------------- ------------
1         100            200
2         105            110
30        130            150
31        260            260
31        261            261
31        263            263
32        262            262
32        264            264
32        268            268
32        272            272
33        100            299
35        263            264
36        261            262
37        267            268
38        271            272
39        190            190
41        380            380
42        300            305

Account List composite view

The above tables are joined together at their SF_NameId column in a view that is used by STEPforward whenever it loads data for the account lists:

create view SF_SYSVAccountRanges (SF_Name, SF_Description, SF_UserId, SF_FromAccount, SF_ToAccount, SF_TimeStamp) as select SF_Alias2.SF_Name, SF_Alias2.SF_Description, SF_Alias2.SF_UserId, SF_Alias1.SF_FromAccount, SF_Alias1.SF_ToAccount, SF_Alias2.SF_TimeStamp from SF_SYSAccountRanges SF_Alias1,SF_SYSAccountRangeNames SF_Alias2 where SF_Alias1.SF_NameId = SF_Alias2.SF_NameId

The virtual table created by the view is seen by STEPforward as containing the following sample data:

SF_Name    SF_Description                           SF_FromAccount SF_ToAccount
---------- ---------------------------------------- -------------- ------------
ADMIN      Administration & Selling                 800            802
ADMIN      Administration & Selling                 815            815
ADMIN      Administration & Selling                 900            900
ADMIN      Administration & Selling                 906            992
AP         Accounts Payable                         330            360
AR         Accounts Receivable                      113            114
BL         Bank Indebtedness                        300            305
BondClose  Bond Closing Expenses Amortized          200            200
CA         Current Assets                           100            200
CL         Current Liabilities                      300            399
CLLTD      Capital Loans, LongTerm Debt             430            434
CPLTD      Current Portion Long Term Debt           390            390
CPLTDY     Current Portion Long Term Debt due withi 439            439
CSV        Cash Surrender Value - Life Insurance    180            182
Cash       Cash and Equivalent                      105            110
Chart      Account Chart                            100            999
CostOfSale Cost of sales                            700            720
CostOfSale Cost of sales                            905            905
EQ         Equity                                   500            599
EQCS       Equity, Capital Stock                    510            510
EQPL       Equity, Current Profit & Loss            570            570
EQRT       Equity, Retained Earnings                560            570
EQSR       Capital Stock Redemption                 520            522