Account Group Tables

Component tables

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

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

Column Generalized data type Use
SF_NameId SMALLINT Unique id number of the account group
SF_Name VARCHAR(255) Name of the account group
SF_Description VARCHAR(255) Description of the account group
SF_UserId VARCHAR(255) User-id of the user that last saved the group
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_SYSAccountGroupNames:

SF_NameId SF_Name                 SF_Description
--------- ----------------------- ----------------------------------------
1         CurrentAssets           Current Assets lists
2         FixedAssets             Fixed Assets lists
3         CurrentLiabilities      Current Liabilities
4         LongTermDebt            Long-term Debt
6         RetEarnings             Retained Earnings and Stock Redemption
7         LaundryOperations       Laundry operating account lists

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

Column Generalized data type Use
SF_NameId SMALLINT Unique id number of the account list
SF_ListName VARCHAR(255) Name of the account list
SF_ListOrder SMALLINT Order of the account list in the group
SF_TimeStamp SMALLINT Version of the row (incremented with each update)

The following partial example shows some rows from table SF_SYSAccountGroups:

SF_NameId SF_ListName          SF_ListOrder
--------- -------------------- ------------
1         AR                   1
1         INV                  2
1         CSV                  3
1         PREPX                4
1         BondClose            5
2         Land                 0
2         FAB                  1
2         FAM                  2
2         FAA                  3
2         FAO                  4
3         BL                   0
3         AP                   1
3         TP                   2
3         CPLTD                3
4         StockP               0
4         CLLTD                1
4         CPLTDY               2

Account Group 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 groups:

create view SF_SYSVAccountGroups (SF_Name, SF_Description, SF_UserId, SF_ListName, ListDescription, SF_ListOrder, SF_TimeStamp) as select SF_Alias2.SF_Name, SF_Alias2.SF_Description, SF_Alias2.SF_UserId, SF_Alias1.SF_ListName, SF_Alias3.SF_Description, SF_Alias1.SF_ListOrder, SF_Alias2.SF_TimeStamp from SF_SYSAccountGroups SF_Alias1,SF_SYSAccountGroupNames SF_Alias2,SF_SYSAccountRangeNames SF_Alias3 where SF_Alias1.SF_NameId = SF_Alias2.SF_NameId and SF_Alias1.SF_ListName = SF_Alias3.SF_Name

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

SF_Name              SF_Description            SF_ListName  ListDescription
-------------------- ------------------------- ------------ ------------------------------
CurrentAssets        Current Assets lists      AR           Accounts Receivable
CurrentAssets        Current Assets lists      INV          Inventory, Merchandise and Sup
CurrentAssets        Current Assets lists      CSV          Cash Surrender Value - Life In
CurrentAssets        Current Assets lists      PREPX        Prepaid Expenses
CurrentAssets        Current Assets lists      BondClose    Bond Closing Expenses Amortize
CurrentLiabilities   Current Liabilities       BL           Bank Indebtedness
CurrentLiabilities   Current Liabilities       AP           Accounts Payable
CurrentLiabilities   Current Liabilities       TP           Taxes Payable
CurrentLiabilities   Current Liabilities       CPLTD        Current Portion Long Term Debt
FixedAssets          Fixed Assets lists        Land         Land only
FixedAssets          Fixed Assets lists        FAB          Buildings
FixedAssets          Fixed Assets lists        FAM          Machinery & Equipment
FixedAssets          Fixed Assets lists        FAA          Automobiles & Trucks
FixedAssets          Fixed Assets lists        FAO          Office Equipment
LaundryOperations    Laundry operating account HRES         Human Resources
LaundryOperations    Laundry operating account Utilities    Utility accounts (water, gas e
LaundryOperations    Laundry operating account LaundryMisc  Miscellaneous laundry accounts
LongTermDebt         Long-term Debt            StockP       Stock Purchases
LongTermDebt         Long-term Debt            CLLTD        Capital Loans, LongTerm Debt
LongTermDebt         Long-term Debt            CPLTDY       Current Portion Long Term Debt
RetEarnings          Retained Earnings and Sto EQSR         Capital Stock Redemption
RetEarnings          Retained Earnings and Sto EQRT         Equity, Retained Earnings