DW_CONTRACT_HEADER_D_TL
This table stores the translated records of the Contract Headers.
Details
Module: Project Billing
Key Columns
MAJOR_VERSION, LANGUAGE, CONTRACT_HEADER_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| CONTRACT_HEADER_ID | NUMBER | 38 | 0 | True | Contract Header identifier. | ||
| MAJOR_VERSION | NUMBER | 38 | 0 | True | Major Version Number . | ||
| LANGUAGE | VARCHAR2 | 16 | True | Indicates the code of the language into which the contents of the translatable columns are translated. | |||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. System Generated unique identifier | ||||
| VERSION_TYPE | VARCHAR2 | 16 | Version Type can have 3 values: Current, Amendment, and History. If the version type is not Current then no update is allowed on the entity. | ||||
| CONTRACT_NAME | VARCHAR2 | 512 | Cognomen | ||||
| DESCRIPTION | VARCHAR2 | 999 | Description | ||||
| VERSION_DESCRIPTION | VARCHAR2 | 999 | User entered free format text verison description. |