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