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 | Y | |
| FIELD_NUMBER | Number(5) | NUMBER5 | Y | |
| FIELD_NAME | Varchar2(200) | VARCHAR200 | Y | |
| FIELD_START_BYTE | Number(5) | NUMBER5 | Y | |
| FIELD_END_BYTE | Number(5) | NUMBER5 | Y | |
| FIELD_TYPE | Varchar2(2) | X_FIELD_TYPE | Y | |
| CREATE_DATE | Date() | DATE | Y | |
| CREATE_USER | Varchar2(30) | VARCHAR30 | Y | |
| CHANGE_DATE | Date() | DATE | Y | |
| CHANGE_USER | Varchar2(30) | VARCHAR30 | Y | |
| FORMAT_MASK | Varchar2(50) | EDIT MASK | ||
| CONSTANT_VALUE | Varchar2(2000) | VARCHAR2000 | ||
| VARIABLE | Varchar2(6) | X_INF_VARIABLE_NAME | ||
| INTERFACE_VARIABLE | Varchar2(6) | X_INF_VARIABLE_NAME | ||
| DERIVATION_EXPRESSION | Varchar2(2000) | VARCHAR2000 | ||
| SORT_SEQUENCE | Number(10) | NUMBER10 | ||
| 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 | ||
| XML_TAG | Varchar2(4000) | VARCHAR4000 | ||
| XML_TAG_OPTION | Varchar2(2) | X_XML_TAG_OPTION | ||
| ADD_TO_UK | Varchar2(1) | TOGGLE | ||
| COMMENTS | Varchar2(4000) | VARCHAR4000 |
User Fields: Allowed
Audit Logging: Allowed
