P 2 K_CM_INTERFACE_FIELDS
Back to current versionRestore this version

Alias: DIFD#

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

Interface Fields

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
DIF_IDNumber(10)IDYlink to P2K_CM_INTERFACE_FORMATS
RECORD_NUMBERNumber(5)NUMBER5Y
FIELD_NUMBERNumber(5)NUMBER5Y
FIELD_NAMEVarchar2(200)VARCHAR200Y
FIELD_START_BYTENumber(5)NUMBER5Y
FIELD_END_BYTENumber(5)NUMBER5Y
FIELD_TYPEVarchar2(2)X_FIELD_TYPEY
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
FORMAT_MASKVarchar2(50)EDIT MASK
CONSTANT_VALUEVarchar2(2000)VARCHAR2000
VARIABLEVarchar2(6)X_INF_VARIABLE_NAME
INTERFACE_VARIABLEVarchar2(6)X_INF_VARIABLE_NAME
DERIVATION_EXPRESSIONVarchar2(2000)VARCHAR2000
SORT_SEQUENCENumber(10)NUMBER10
PRINT_ZERO_RULEVarchar2(2)X_PRINT_ZERO_RULE
ACCUM_OPTIONVarchar2(2)X_ACCUM_OPTION
TOTAL_OPTIONVarchar2(2)X_TOTAL_OPTION
RECORD_TYPEVarchar2(2)X_RECORD_TYPE
RECORD_IDENTIFIERVarchar2(50)VARCHAR50
XML_TAGVarchar2(4000)VARCHAR4000
XML_TAG_OPTIONVarchar2(2)X_XML_TAG_OPTION
ADD_TO_UKVarchar2(1)TOGGLE New in 408
COMMENTSVarchar2(4000)VARCHAR4000

User Fields: Allowed
Audit Logging: Allowed

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation