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
ParameterKey VARCHAR(20) Name of parameter
Value VARCHAR(20) Value of parameter

The following is a sample of contents of SF_SYSSetup table:

ParameterKey         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