# DW_PROJECT_FUNDING_CF

This table stores contract project linkage records.

## Details

Module: Project Billing

## Key Columns

LINK_ID, MAJOR_VERSION

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

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