DW_PROJECT_FUNDING_CF

This table stores contract project linkage records.

Details

Module: Project Billing

Key Columns

MAJOR_VERSION, LINK_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
LINK_ID NUMBER 38 0 True Contract Project linkage ID
MAJOR_VERSION NUMBER 38 0 True Major Version
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. System Generated Unique Identifier
VERSION_TYPE VARCHAR2 16 Version Type
CONTRACT_HEADER_ID NUMBER 38 0 Contract Header ID DW_CONTRACT_HEADER_D CONTRACT_HEADER_ID
CONTRACT_LINE_ID NUMBER 38 0 Contract Line ID DW_CONTRACT_LINE_CF CONTRACT_LINE_ID
CONTRACT_BUSINESS_UNIT_ID NUMBER 38 0 Identifier of the business unit associated to the row. DW_BUSINESS_UNIT_D BUSINESS_UNIT_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
PROJECT_ID NUMBER 38 0 Project ID DW_PROJECT_D PROJECT_ID
PROJECT_ELEMENT_ID NUMBER 38 0 Project element ID DW_PROJECT_ELEMENT_D PROJ_ELEMENT_ID
PROJECT_BUSINESS_UNIT_ID NUMBER 38 0 Indicates the identifier of the business unit associated to the row. DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
PROJECT_LEGAL_ENTITY_ID NUMBER 38 0 Legal entity assigned to the project. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
PROJECT_ORGANIZATION_ID NUMBER 38 0 The identifier of the organization that is responsible for the project work DW_INTERNAL_ORG_D ORGANIZATION_ID
PROJECT_UNIT_ID NUMBER 38 0 Project unit assigned to the project. DW_INTERNAL_ORG_D ORGANIZATION_ID
PROJECT_LEDGER_ID NUMBER 38 0 Ledger of Project Organization DW_LEDGER_D LEDGER_ID
LINE_START_DATE DATE Contract Line start date
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. DW_CONTRACT_BILL_PLAN_D BILL_PLAN_ID
REVENUE_PLAN_ID NUMBER 38 0 Revenue plan identifier. DW_CONTRACT_BILL_PLAN_D BILL_PLAN_ID
FUNDING_AMOUNT NUMBER Funding Amount
PERCENT_COMPLETE NUMBER Percent Complete
BILLING_TYPE_CODE VARCHAR2 32 Billing Type Code DW_PJB_BILLING_TYPE_LKP_TL BILLING_TYPE_CODE
LAST_REV_RECOG_DATE DATE last revenue recognize date
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_FUNDING_AMOUNT NUMBER Global Funding Amount
ACTIVE_FLAG VARCHAR2 16 Active Flag DW_Y_N_D_TL CODE
INTER_COMPANY_FLAG VARCHAR2 16 Flag to identify Inter Company contract DW_Y_N_D_TL CODE
INTER_PROJECT_FLAG VARCHAR2 16 Flag to identify Inter project contract DW_Y_N_D_TL CODE
CREATION_DATE TIMESTAMP indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 128 indicates the user who created the row. DW_USER_D USERNAME
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
UNDER_AMEND_VERSION_FLAG VARCHAR2 16 Y or NULL - if under amendment with versioning, N if version wasn't created for amendment Always NULL if the contract is not UA