Account Structure Table

GL accounts in STEPforward have a hierarchical structure made of the multi-level prefix and the single-level number. The basic info on this structure is stored in table SF_SYSAccountStructure with the following contents:

Column Generalized data type Use
MasterName VARCHAR(8) Reseved, presently set to "SF_GL"
Description VARCHAR(255) Reserved, presently set to NULL
SF_Level TINYINT Level of the component
LevelName VARCHAR(255) Name of the component
FieldSize TINYINT Size of the component (in characters)
Last CHAR(1) Flag to mark the last level (account number)
SF_TimeStamp SMALLINT Version of the row (incremented with each update)

Notes:

The table contains one row for each structural level of GL account used by STEPforward.

SF_Level is the level of the account component. Prefix components (segments) are numbered beginning with 1 and follow the order of entries in the Account Prototype editor. The last (highest) level number is assigned to the Account Number component.

LevelName is the character name assigned to the account component, as entered in the Account Prototype editor.

Last is set to Y for the last level (Account Number). For the Prefix components, this flag is an empty string.

The following example shows contents of SF_SYSAccountStructure table:

MasterName Description SF_Level LevelName       FieldSize Last SF_TimeStamp
---------- ----------- -------- --------------- --------- ---- ------------
SF_GL      NULL        1        Operating Unit  2              0
SF_GL      NULL        2        GL Account      3         Y    0