Alias:DUD#
Description: Contract specific information.User Fields: Allowed
Audit Logging: Allowed
This table contains date sensitive information pertinent to the definition of a unit. The unit must already be defined on P2K_CM_UNITS.
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 |
