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