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
Start VARCHAR(N) First account number in the range
Finish VARCHAR(N) Last account number in the range
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 Start Finish 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