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