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 |
GroupName | VARCHAR(255) | Name of the Value List |
GroupId | SMALLINT | Id number of the Value List |
Item | VARCHAR(255) | Character string that belongs to the list |
ItemOrder | SMALLINT | Order of the string in the list |
SF_TimeStamp | SMALLINT | Version of the row (incremented with each update) |
Notes:
GroupName is the name of the Value List. For each distinct list, the GroupName is set to the list name only once, in the first row of the list. In all other rows of the list the GroupName is set to NULL.
GroupId is the id number of the list. All rows in the list, including the GroupName row (the first row) contain the same value of GroupId.
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 GroupName row).
ItemOrder is the number that keeps track of the order of rows in the list. The first row in each list has its ItemOrder set to -1; it is this row that carries the name of the list in its GroupName column. The list item rows are numbered beginning with 0.
The following is a partial sample of contents of SF_SYSStandardValues table:
GroupName GroupId Item 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