DW_CONTRACT_BILL_PLAN_D_TL
This table contains detailed description and instructions on how to bill the customer for the work performed. An invoice plan/revenue plan is defined in the context of a contract, and can be used by one or more contract lines.
Details
Module: Project Billing
Key Columns
BILL_PLAN_ID, LANGUAGE, MAJOR_VERSION
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| BILL_PLAN_ID | NUMBER | 38 | 0 | True | Bill Plan ID | ||
| LANGUAGE | VARCHAR2 | 64 | True | Translation language. | |||
| MAJOR_VERSION | NUMBER | 38 | 0 | True | Version | ||
| SOURCE_RECORD_ID | VARCHAR2 | 512 | This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of code type and code. | ||||
| BILL_PLAN_NAME | VARCHAR2 | 32 | Business name or value of the code. | ||||
| BILL_PLAN_DESC | VARCHAR2 | 256 | Code description. |