# DW_CONTRACT_BILL_PLAN_D

This table stores Contract Bill Plan Details.

## Details

Module: Project Billing

## Key Columns

MAJOR_VERSION, BILL_PLAN_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
BILL_PLAN_ID | NUMBER | 38 | 0 | True | Contract Bill Plan ID |  |
MAJOR_VERSION | NUMBER | 38 | 0 | True | Major Version denotes version number of a record. |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. System generated Unique Identifier. |  |
VERSION_TYPE | VARCHAR2 | 16 |  |  | VERSION TYPE denotes if the record is Current or History or Amendment record. Valid values are 'C' for current, 'H' for history, and 'A' for Amendment. |  |
BILL_METHOD_ID | NUMBER | 38 | 0 |  | Identifier of the billing method |  |
BILL_SET_NUM | NUMBER |  |  |  | Billing set number is used to group invoices together. |  |
DOC_NUMBER | VARCHAR2 | 256 |  |  | BillPlanBasePEODocNumber |  |
LABOR_FORMAT_NAME | VARCHAR2 | 32 |  |  | The implementation-defined labour format name that uniquely identifies the invoice format |  |
NON_LABOR_FORMAT_NAME | VARCHAR2 | 32 |  |  | The implementation-defined Non labour format name that uniquely identifies the invoice format |  |
EVENT_FORMAT_NAME | VARCHAR2 | 32 |  |  | The implementation-defined event name that uniquely identifies the invoice format |  |
PAYMENT_TERM_ID | NUMBER | 38 | 0 |  | How often invoice should be created. |  |
INVOICE_CURRENCY_OPT_CODE | VARCHAR2 | 32 |  |  | Currency option for the bill plan. This should be either contract currency or bill transaction currency |  |
INVOICE_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Invoice in third currency for Billing Currency Type 'USER' |  |
BILL_TYPE_CLASS_CODE | VARCHAR2 | 32 |  |  | Bill Type Class Code introduced to resolve UI issue. |  |
ON_HOLD_FLAG | VARCHAR2 | 16 |  |  | This column is used to indicate if a bill plan record is on hold. When in hold, no billing downstream processing can occur for the bill plan or revenue plan. Allowed values are, 'Y' or 'N'. |  |
CONTRACT_HEADER_ID | NUMBER | 38 | 0 |  | Contract ID |  |
BILL_TO_PARTY_ID | NUMBER | 38 | 0 |  | Party identifier. |  |
BILL_TO_CUST_ACCT_ID | NUMBER | 38 | 0 |  | Customer site that the invoices should be sent to and is responsible for the payment. |  |
BILL_TO_SITE_USE_ID | NUMBER | 38 | 0 |  | Customer site that the invoices should be sent to and is responsible for the payment. |  |
BILL_TO_LOCATION | VARCHAR2 | 256 |  |  | Site use identifier |  |
BILL_TO_LOCATION_ID | NUMBER | 38 | 0 |  | Location Identifier |  |
BILL_TO_CONTACT_ID | NUMBER | 38 | 0 |  | Contact person from the Bill-To Customer Site |  |
LOC_NUMBER | VARCHAR2 | 256 |  |  | Letter of credit number. |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.