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