DW_CONTRACT_BILL_PLAN_D

This table stores Contract Bill Plan Details.

Details

Module: Project Billing

Key Columns

BILL_PLAN_ID, MAJOR_VERSION

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.