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