Value List Table
Character strings for pop-up list buttons and combo boxes are maintained by STEPforward in the Value List editor and stored in SF_SYSStandardValues table that has the following structure:
Column | Generalized data type | Use |
SF_GroupName | VARCHAR(255) | Name of the Value List |
SF_GroupId | SMALLINT | Id number of the Value List |
SF_Item | VARCHAR(255) | Character string that belongs to the list |
SF_ItemOrder | SMALLINT | Order of the string in the list |
SF_TimeStamp | SMALLINT | Version of the row (incremented with each update) |
Notes:
SF_GroupName is the name of the Value List. For each distinct list, the SF_GroupName is set to the list name only once, in the first row of the list. In all other rows of the list the SF_GroupName is set to NULL.
SF_GroupId is the id number of the list. All rows in the list, including the SF_GroupName row (the first row) contain the same value of SF_GroupId.
SF_Item is the character string that makes one entry in the list. This column is set to NULL in the first row of the list (the SF_GroupName row).
SF_ItemOrder is the number that keeps track of the order of rows in the list. The first row in each list has its SF_ItemOrder set to -1; it is this row that carries the name of the list in its SF_GroupName column. The list item rows are numbered beginning with 0.
The following is a partial sample of contents of SF_SYSStandardValues table:
SF_GroupName SF_GroupId SF_Item SF_ItemOrder
--------------- ---------- ------------------------------------------------------- ------------
Tax Exempt 1 NULL -1
NULL 1 No 0
NULL 1 Yes 1
Product Group 6 NULL -1
NULL 6 Make A Selection 0
NULL 6 Rental - Flat Goods 1
NULL 6 Rental - Garments 2
NULL 6 Rental - Rugs/Misc 3
NULL 6 Sales - Paper 4
NULL 6 Sales - Merchandise 5
NULL 6 Handling Charges 6
Journal Formats 8 NULL -1
NULL 8 Make a selection, if "List all Source Documents" was pi 0
NULL 8 Paging for "Books of Original Entry" 1
NULL 8 Continuous, WITH sub-totals by Source Documents 2
NULL 8 Continuous, WITHOUT sub-totals by Source Documents 3
Deliver On 9 NULL -1
NULL 9 Select one 0
NULL 9 Next Monday 1
NULL 9 Next Tuesday 2
NULL 9 Next Wednesday 3
NULL 9 Next Thursday 4
NULL 9 Next Friday 5
NULL 9 Today 6