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