This table stores Contract Bill Plan Details.
Module: Project Billing
BILL_PLAN_ID, MAJOR_VERSION
| 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, 2024, Oracle and/or its affiliates.