TDD_LOV

List-Of-Values.


Columns

No Name Domain Dty Len Scale Nulls Foreign Key Description
1 TDD_VERSION TDD_VERSION I 4   N   Version stamp. The last version is always the number one (1). All old versions will have a negative version number. TDD_VERSION will have the corresponding date when the version was updated/deleted.
2 LOV_TAB_NAME DV_SQLID C 30   N TDD_TABLE.TAB_NAME Table name.
3 LOV_COL_NAME DV_SQLID C 30   N TDD_COLUMN.COL_NAME Column name.
4 LOV_SEQ DV_SEQ I 2   N   Orders (sequences) the data correctly.
5 LOV_SEL_COLUMNS DV_TEXT_LONG C 240   Y   Columns, in a ',' (comma) separated list, to display in the List-Of-Values popup. If not specified all columns are shown.
6 LOV_SEL_WHERE DV_TEXT_LONG C 240   Y   Optional where clause. The WHERE is added automatically.
7 LOV_SEL_ORDER DV_TEXT_LONG C 240   Y   Optional ORDER BY clause. The ORDER BY is added automatically.

Dependents

None


Updated 31 Oct 2002.