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
SF_MasterName VARCHAR(8) Reseved, presently set to "SF_GL"
SF_Description VARCHAR(255) Reserved, presently set to NULL
SF_Level TINYINT Level of the component
SF_LevelName VARCHAR(255) Name of the component
SF_FieldSize TINYINT Size of the component (in characters)
SF_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.

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

SF_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:

SF_MasterName SF_Description SF_Level SF_LevelName    SF_FieldSize SF_Last SF_TimeStamp
------------- -------------- -------- --------------- ------------ ------- ------------
SF_GL         NULL           1        Operating Unit  2                    0
SF_GL         NULL           2        GL Account      3            Y       0