Level Header Table
When Account Prototypes utility saves the account chart structure, it creates SF_SYSLevelHeader table to hold the groupings of GL account ranges set by the Account Headers utility of STEPforward. The table has the following structure:
Column | Generalized data type | Use |
SF_Level | SMALLINT | Level of nesting of the account range |
SF_Start | VARCHAR(N) | First account number in the range |
SF_Finish | VARCHAR(N) | Last account number in the range |
SF_Description | VARCHAR(60) | Free-formatted description of the group |
SF_TimeStamp | SMALLINT | Version of the row (incremented with each update) |
The following example shows some rows from SF_SYSLevelHeader table:
SF_Level SF_Start SF_Finish SF_Description
-------- -------- --------- ----------------------------------------
0 100 199 Current Assets
1 105 112 Cash
1 113 114 Accounts Receivable
1 130 150 Inventory
1 180 182 Cash Surrender Value - Life Insurance
0 260 279 Fixed Assets
0 300 399 Current Liabilities
0 400 499 Long Term Debt
0 500 599 Shareholders Equity
0 600 699 Revenue
0 700 799 Cost Of Sales
1 740 760 Cost Of Sales Harmonization
0 800 899 Direct Expenses
1 800 819 Human Resources
1 830 839 Automotive
1 850 859 Utilities
0 900 993 Overhead Expenses