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     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.    
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    

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