P 2 K_AM_FORM_TABLE_USAGES
Back to current versionRestore this version

Alias: MFT#

Unique Keys: _
Child Table:
_
Parent Table: _

Form Table Usages

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
MFN_IDNumber(10)IDYlink to P2K_AM_FUNCTIONS
MFT_IDNumber(10)ID link to P2K_AM_FORM_TABLE_USAGES
MVD_IDNumber(10)ID link to P2K_AM_VIEW_DETAILS
MTD_IDNumber(10)ID link to P2K_AM_TABLE_DETAILS
JOIN_CLAUSEVarchar2(200)VARCHAR200
KEEP_GLOBAL_CONTEXTVarchar2(1)TOGGLE
SEQUENCENumber(5)NUMBER5
WHERE_CLAUSEVarchar2(2000)VARCHAR2000
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
FORM_TABLE_USAGEVarchar2(2)X_LEXICON_USAGEY
CREATE_ALLOWEDVarchar2(1)TOGGLE
RETRIEVE_ALLOWEDVarchar2(1)TOGGLE
UPDATE_ALLOWEDVarchar2(1)TOGGLE
DELETE_ALLOWEDVarchar2(1)TOGGLE
PRE_DEFINED_WHERE_CLAUSEVarchar2(200)VARCHAR200
PRE_DEFINED_SORT_ORDERVarchar2(200)VARCHAR200
NOTES_ATTATCHEDVarchar2(1)TOGGLE
PRE_DEFINED_DATA_SOURCEVarchar2(200)VARCHAR200
MDAO_IDNumber(10)IDYlink to P2K_AM_DATA_ACCESS_OBJECTS
MWC_IDNumber(10)ID link to P2K_AM_WHERE_CLAUSES
FORM_TABLE_ALIASVarchar2(16)CODE

User Fields: Allowed
Audit Logging: Not Allowed