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
NameId SMALLINT Unique id number of the account group
Name VARCHAR(255) Name of the account group
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:

NameId Name                 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
NameId SMALLINT Unique id number of the account list
ListName VARCHAR(255) Name of the account list
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:

NameId ListName             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 NameId column in a view that is used by STEPforward whenever it loads data for the account groups:

create view SF_SYSVAccountGroups (Name, Description, SF_UserId, ListName, ListDescription, ListOrder, SF_TimeStamp) as select SF_Alias2.Name, SF_Alias2.Description, SF_Alias2.SF_UserId, SF_Alias1.ListName, SF_Alias3.Description, SF_Alias1.ListOrder, SF_Alias2.SF_TimeStamp from SF_SYSAccountGroups SF_Alias1,SF_SYSAccountGroupNames SF_Alias2,SF_SYSAccountRangeNames SF_Alias3 where SF_Alias1.NameId = SF_Alias2.NameId and SF_Alias1.ListName = SF_Alias3.Name

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

Name                 Description               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