DW_CONTRACT_LINE_CF

This table stored the contract line level details.

Details

Module: Project Billing

Key Columns

CONTRACT_LINE_ID, MAJOR_VERSION

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CONTRACT_LINE_ID NUMBER 38 0 True Unique identifier of the contract line. DW_CONTRACT_LINE_TL CONTRACT_LINE_ID
MAJOR_VERSION NUMBER 38 0 True Major Version Number of the Contract.    
SOURCE_RECORD_ID VARCHAR2 128     This column is for Oracle Internal use only. System generated Unique Identifier.    
CONTRACT_HEADER_ID NUMBER 38 0   ID of the contract to which this line belongs. DW_CONTRACT_HEADER_D CONTRACT_HEADER_ID
VERSION_TYPE VARCHAR2 16     Version Type can have 3 values: Current, Amendment, and History. If the version type is not Current then no update is allowed on the entity.    
LINE_NUMBER VARCHAR2 256     Sequential line number.    
CONTRACT_BUSINESS_UNIT_ID NUMBER 38 0   Indicates the identifier of the business unit associated to the row. DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
CONTRACT_ORGANIZATION_ID NUMBER 38 0   Identifies the Business Unit (that has the Projects function enabled) that will be responsible for developing this contract. Only applies to a contract type with project lines. DW_INTERNAL_ORG_D ORGANIZATION_ID
CONTRACT_LEGAL_ENTITY_ID NUMBER 38 0   Legal entity identifier for Contract. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
CONTRACT_LEDGER_ID NUMBER 38 0   Ledger identifier of Contract DW_LEDGER_D LEDGER_ID
LINE_TYPE_ID NUMBER 38 0   Line type id refers to Line Types setup. DW_CONTRACT_LINE_TYPE_TL LINE_TYPE_ID
START_DATE DATE       The beginning of the active period, one second after midnight on the date indicated.    
END_DATE DATE       The end of the active period, one second before midnight on the date indicated.    
FISCAL_PERIOD_TYPE VARCHAR2 16     The GL period in which the transaction is posted. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
FISCAL_PERIOD_SET_NAME VARCHAR2 16     GL Calendar Name for Provider business unit. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
BILL_PLAN_ID NUMBER 38 0   Bill plan identifier. Refers to BILL_PLAN_ID in PJB_BILL_PLANS_B. DW_CONTRACT_BILL_PLAN_D BILL_PLAN_ID
REVENUE_PLAN_ID NUMBER 38 0   Revenue plan identifier. Refers to PJB_BILL_PLANS_B. DW_CONTRACT_BILL_PLAN_D BILL_PLAN_ID
PERCENT_COMPLETE NUMBER       Invoice classification    
LINE_AMOUNT NUMBER       Usually roll up of sublines if any sub lines are present Line Type id determine whether it can be directly updated by the user.    
BILL_TO_PARTY_ID NUMBER 38 0   Party identifier. DW_PARTY_D PARTY_ID
BILL_TO_CUSTOMER_ACCOUNT_ID NUMBER 38 0   Bill to Account (Customer Account) for Sell Intent contracts DW_CUSTOMER_ACCOUNT_D CUSTOMER_ACCOUNT_ID
BILL_TO_SITE_USE_ID NUMBER 38 0   Bill to Site (Customer Account Site Use) for Sell Intent contracts DW_CUSTOMER_SITE_USES_D CUSTOMER_SITE_USE_ID
BILL_TO_LOCATION VARCHAR2 256     Site use identifier    
BILL_TO_LOCATION_ID NUMBER 38 0   Location Identifier DW_CUSTOMER_LOCATION_D CUSTOMER_LOCATION_ID
BILL_TO_CONTACT_ID NUMBER 38 0   Bill to Contact (Customer Account Contact) DW_PARTY_D PARTY_ID
SHIP_TO_PARTY_ID NUMBER 38 0   Ship to Party ID. DW_PARTY_D PARTY_ID
SHIP_TO_CUSTOMER_ACCOUNT_ID NUMBER 38 0   Ship to Account (Customer Account) for Sell Intent contracts. DW_CUSTOMER_ACCOUNT_D CUSTOMER_ACCOUNT_ID
SHIP_TO_LOCATION VARCHAR2 256     Site use identifier    
SHIP_TO_LOCATION_ID NUMBER 38 0   Ship to Site (Customer Account Site Use) Location identifier for Sell Intent contracts. DW_CUSTOMER_LOCATION_D CUSTOMER_LOCATION_ID
SHIP_TO_SITE_USE_ID NUMBER 38 0   Ship to Site (Customer Account Site Use) Use identifier for Sell Intent contracts. DW_CUSTOMER_SITE_USES_D CUSTOMER_SITE_USE_ID
IB_PROVIDER_BUSINESS_UNIT_ID NUMBER 38 0   Provider business unit that belongs to contract LE ***** DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
IB_RCVR_BUSINESS_UNIT_ID NUMBER 38 0   Receiver business unit that belongs to the bill to contact LE of the bill plan DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
IB_RECEIVER_PROJECT_ID NUMBER 38 0   Receiver project defined on contract line ***** DW_PROJECT_D PROJECT_ID
IB_RECEIVER_TASK_ID NUMBER 38 0   Receiver task defined on contract line ***** DW_PROJECT_ELEMENT_D PROJ_ELEMENT_ID
IB_RECEIVER_EXPENDITURE_ORG_ID NUMBER 38 0   Receiver expenditure org defined on contract line ***** DW_INTERNAL_ORG_D ORGANIZATION_ID
IB_RECEIVER_EXPENDITURE_TYPE_ID NUMBER 38 0   Receiver expenditure type defined on contract line ***** DW_PROJECT_EXPENDITURE_TYPE_D EXPENDITURE_TYPE_ID
IB_EXP_TYPE_ORIG_EI_FLAG VARCHAR2 16     If the flag is 'Y', set the Expenditure Type on the internal AP invoice line to the Expenditure Type on the original provider expenditure item DW_Y_N_D_TL CODE
IB_EXP_ORG_SOURCE VARCHAR2 32     Optional Y/N flag. If the flag is 'Y', set Expenditure Org on the IC AP invoice line to Task-owning Org of the expenditure item DW_Y_N_D_TL CODE
STATUS_CODE VARCHAR2 32     User status of the contract. DW_OKC_STATUS_LKP_TL OKC_STATUS_CODE
TRN_CODE VARCHAR2 32     Line Termination Code. Refers to LOOKUP_CODE in FND_LOOKUPS where LOOKUP_TYPE IS OKC_TERMINATION_REASON. DW_CONTRACT_TRN_CODE_LKP_TL OKC_TRN_CODE
UOM_CODE VARCHAR2 16     Unit of measure YR(Year) or Ea(Each). DW_PROJECT_UNIT_OF_MEASURE_TL UOM_CODE
CONTRACT_CURRENCY_CODE VARCHAR2 16     Contract's transaction currency. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global Currency Code. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
GLOBAL_RATE_TYPE VARCHAR2 32     Rate type used to convert costs from the contract currency to the Global currency. DW_CONVERSION_RATE_TYPE_D CONVERSION_TYPE
GLOBAL_RATE_DATE DATE       Rate date used to convert costs from the contract currency to the Global currency.    
GLOBAL_EXCHANGE_RATE NUMBER       Exchange rate used to convert costs from the contract currency to the Global currency.    
GLOBAL_LINE_AMOUNT NUMBER       Global Line Amount    
CREATION_DATE DATE       Who column: indicates the date and time of the creation of the row.    
CREATED_BY VARCHAR2 128     indicates the user who created the row.    
DATE_TERMINATED DATE       Date contract was terminated.    
LAST_REV_RECOG_DATE DATE       Last Revenue Recognition Date.    
AT_RISK_YN VARCHAR2 16     At Risk indicatior DW_Y_N_D_TL CODE
CUST_PO_NUMBER VARCHAR2 64     Free form text referring to Customer PO Number, Wire or Check.    
NUM_OF_ITEM NUMBER       Number of line items.    
INTER_COMPANY_FLAG VARCHAR2 16     InterCompany Flag    
INTER_PROJECT_FLAG VARCHAR2 16     InterProject Flag    

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