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