!!!Alias: DIFD
Unique Keys: ___\\
Child Table: ___\\
Parent Table: ___\\
\\
Interface Fields

!!Table Columns
\\
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y|
|[DIF_ID]|Number(10)|[ID]|Y|link to [P2K_CM_INTERFACE_FORMATS]
|[RECORD_NUMBER]|Number(5)|[NUMBER5|NUMBERn]|Y|
|[FIELD_NUMBER]|Number(5)|[NUMBER5|NUMBERn]|Y|
|[FIELD_NAME]|Varchar2(200)|[VARCHAR200|VARCHARnn]|Y|
|[FIELD_START_BYTE]|Number(5)|[NUMBER5|NUMBERn]|Y|
|[FIELD_END_BYTE]|Number(5)|[NUMBER5|NUMBERn]|Y|
|[FIELD_TYPE]|Varchar2(2)|[X_FIELD_TYPE]|Y|
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[FORMAT_MASK]|Varchar2(50)|[EDIT MASK]| |
|[CONSTANT_VALUE]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[VARIABLE]|Varchar2(6)|[X_INF_VARIABLE_NAME]| |
|[INTERFACE_VARIABLE]|Varchar2(6)|[X_INF_VARIABLE_NAME]| |
|[DERIVATION_EXPRESSION]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[SORT_SEQUENCE]|Number(10)|[NUMBER10|NUMBERn]| |
|[PRINT_ZERO_RULE]|Varchar2(2)|[X_PRINT_ZERO_RULE]| |
|[ACCUM_OPTION]|Varchar2(2)|[X_ACCUM_OPTION]| |
|[TOTAL_OPTION]|Varchar2(2)|[X_TOTAL_OPTION]| |
|[RECORD_TYPE]|Varchar2(2)|[X_RECORD_TYPE]| |
|[RECORD_IDENTIFIER]|Varchar2(50)|[VARCHAR50|VARCHARnn]| |
|[XML_TAG]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[XML_TAG_OPTION]|Varchar2(2)|[X_XML_TAG_OPTION]| |
|[ADD_TO_UK]|Varchar2(1)|[TOGGLE]| | New in 408

User Fields: Allowed\\
Audit Logging: Allowed\\


[{If var='loginstatus' contains 'authenticated'

----
![Discussion|Edit:Internal.P2K_CM_INTERFACE_FIELDS] 	
[{InsertPage page='Internal.P2K_CM_INTERFACE_FIELDS' default='Click to create a new discussion page'}] 	

}]