Alias:DUD#
Description: Contract specific information.User Fields: Allowed
Audit Logging: Allowed
Table Columns#
| Column name | Data Type / Size | Domain | Description | Mandatory | |
|---|---|---|---|---|---|
| ID | Number(10) | ID | Id | Mandatory | |
| DUN_ID | Number(10) | ID | Id | Mandatory | |
| EFFECTIVE | Date() | EFFECTIVE | Effective Date | Mandatory | |
| DCR_ID | Number(10) | ID | ILU | ||
| EXPIRY | Date() | EXPIRY | Expiry Date | Mandatory | |
| UNIT_STATUS | Varchar2(2) | X_UNIT_STATUS | Status of unit | Mandatory | |
| CREATE_DATE | Date() | DATE | Mandatory | ||
| CREATE_USER | Varchar2(30) | VARCHAR30 | Mandatory | ||
| CHANGE_DATE | Date() | DATE | Mandatory | ||
| CHANGE_USER | Varchar2(30) | VARCHAR30 | Mandatory | ||
| DESCRIPTION | Varchar2(50) | DESCRIPTION | Description | ||
| AGREEMENT_START_DATE | Date() | DATE | Agreement Start | ||
| AGREEMENT_END_DATE | Date() | DATE | Agreement End | ||
| UNIT_NAME | Varchar2(50) | DESCRIPTION | Unit Name | ||
| UNIT_LOCAL | Varchar2(50) | DESCRIPTION | Unit Local | ||
| UNIT_SUB_LOCAL | Varchar2(50) | DESCRIPTION | Unit Sub Local | ||
| UNIT_TEXT | Varchar2(4000) | VARCHAR4000 | Unit Text |
