Alias: MFI#

(P2K_AM_FORM_ITEMS)

Unique Keys: None

ERD: ERD-AM75

Form Items

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
MFG_IDNumber(10)IDYlink to P2K_AM_FORM_GROUPS
ITEM_NAMEVarchar2(200)VARCHAR200
ITEM_PROMPTVarchar2(200)VARCHAR200
ITEM_SEQUENCENumber(5)NUMBER5
ITEM_TYPEVarchar2(2)X_ITEM_TYPE
ITEM_HEIGHTNumber(10)NUMBER10
ITEM_WIDTHNumber(10)NUMBER10
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
MOB_IDNumber(10)ID link to P2K_AM_OBJECTS
FORM_ITEM_USAGEVarchar2(2)X_LEXICON_USAGEY
VALUE_FORMATVarchar2(2000)VARCHAR2000
MLOV_IDNumber(10)ID link to P2K_AM_LIST_OF_VALUES
ITEM_SIZEVarchar2(2)X_ITEM_SIZE
SORT_DIRECTIONVarchar2(2)X_SORT_DIRECTION
AGGREGATE_FUNCTIONVarchar2(2)X_AGGREGATE_FUNCTION

User Fields: Not Allowed
Audit Logging: Not Allowed