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 |
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