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

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