Setup Table
STEPforward maintains a number of setup parameters used throughout the system for quick identification of such attributes as the length of the GL account prefix and number components, fiscal period properties, transaction zero-balancing etc. The setup parameters are stored as key-value pairs of character strings in SF_SYSSetup table of the following structure:
Column | Generalized data type | Use |
SF_ParameterKey | VARCHAR(20) | Name of parameter |
SF_Value | VARCHAR(20) | Value of parameter |
The following is a sample of contents of SF_SYSSetup table:
SF_ParameterKey SF_Value
-------------------- --------------------
FiscalPeriodSize 1
CrossYear No
BalancedEntity 0
GLTotalLength 5
GLPrefixLength 2
GLNumberLength 3
CrossPeriod Yes
PeriodBalancing 360
FiscalPeriod MONTH
FirstFiscalPeriod 19880101
FiscalYearEnd 19921231
FiscalPeriodsInYear 12
CrossEntity Yes
P&L Yes
EntityBalancing 108