P 2 K_AM_LOV_QUERIES

Alias: MLQ#

(P2K_AM_LOV_QUERIES)

Unique Keys: LOV_CODE

ERD: ERD-AM33

Lists-Of-Values (LOV) Query Definitions

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
LOV_CODEVarchar2(16)CODEY
LOV_TITLEVarchar2(50)DESCRIPTIONY
CREATE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
DESCRIPTIONVarchar2(50)DESCRIPTION
VIEW_XNumber(9)AMT5V4
VIEW_YNumber(9)AMT5V4
VIEW_WIDTHNumber(9)AMT5V4
VIEW_HEIGHTNumber(9)AMT5V4
LOV_QUERY_TEXTVarchar2(2000)VARCHAR2000

User Fields: Not Allowed
Audit Logging: Not Allowed


Notes #

Click to create a new notes page