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