# DW_PROJECT_COMMITMENT_CF

This table stores information about project commitments.

## Details

Module: Project Costing

## Key Columns

COMMITMENT_TXN_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
COMMITMENT_TXN_ID | NUMBER | 38 | 0 | True | System generated unique ID of a commitment transaction. This is exposed to the user as commitment transaction number in UI. |  |
SOURCE_RECORD_ID | NUMBER | 38 | 0 |  | This column is for Oracle Internal use only. Source record identifier |  |
PROJECT_ID | NUMBER | 38 | 0 |  | Project to which the commitment cost is charged, the customer may interface the name, number or the identifier. | DW_PROJECT_D | PROJECT_ID
PROJECT_UNIT_ID | NUMBER | 38 | 0 |  | Project unit assigned to the project. | DW_INTERNAL_ORG_D_TL | ORGANIZATION_ID
PROJECT_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization that incurred the commitment, the customer may interface the name or the identifier. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
PROJECT_TYPE_ID | NUMBER | 38 | 0 |  | Project type of the project to which the commitment cost is charged, the customer may interface the name or the identifier. | DW_PROJECT_D | PROJECT_TYPE_ID
TASK_ID | NUMBER | 38 | 0 |  | Task to which the commitment cost is charged, the customer may interface the name, number or the identifier. | DW_PROJECT_ELEMENT_D | PROJ_ELEMENT_ID
TASK_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization that is responsible for the project work (carrying out organization) | DW_INTERNAL_ORG_D | ORGANIZATION_ID
HEADER_ID | NUMBER | 38 | 0 |  | Unique identifier of commitment transaction header from the source application. |  |
COMMITMENT_NUMBER | VARCHAR2 | 128 |  |  | Original commitment transaction number such as purchase requisition number, purchase order number, supplier invoice number and external commitment transaction number. |  |
LINE_ID | NUMBER | 38 | 0 |  | Unique identifier of a commitment transaction line. |  |
LINE_NUMBER | NUMBER |  |  |  | Commitment transaction line number |  |
DISTRIBUTION_ID | NUMBER | 38 | 0 |  | Unique identifier of a commitment transaction distribution. |  |
DISTRIBUTION_NUMBER | NUMBER |  |  |  | Commitment transaction distribution number |  |
ORIGINAL_TXN_REFERENCE | VARCHAR2 | 128 |  |  | Unique identifier of third-party commitment transaction record. |  |
TRANSACTION_SOURCE_ID | NUMBER | 38 | 0 |  | Identifier of source application in which the transaction originated.For third party integrations, the customer may interface the name or the identifier. | DW_PROJECT_TXN_SOURCE_TL | TRANSACTION_SOURCE_ID
TRANSACTION_STATUS_CODE | VARCHAR2 | 32 |  |  | Identifies the process status of commitment transaction. | DW_CMT_PROCESS_STATUS_LKP_TL | CMT_PROCESSING_STATUS
DOCUMENT_ID | NUMBER | 38 | 0 |  | Document identifier with which the commitment transaction is captured. For third party integration, the customer may interface the name or the identifier. | DW_PROJECT_TXN_DOCUMENT_TL | DOCUMENT_ID
DOCUMENT_ENTRY_ID | NUMBER | 38 | 0 |  | Document entry identifier with which the commitment transaction is captured. For third party integration, the customer may interface the name or the identifier. | DW_PROJECT_TXN_DOC_ENTRY_TL | DOCUMENT_ENTRY_ID
LINE_TYPE | VARCHAR2 | 32 |  |  | Identifies the commitment transaction line type as purchase order, purchase requisition, supplier invoice or third-party. | DW_CMT_LINE_TYPE_LKP_TL | CMT_LINE_TYPE
REQUISITION_FLAG | VARCHAR2 | 32 |  |  | Identifies the commitment transaction line type as purchase requisition. | DW_Y_N_D_TL | CODE
PURCHASE_ORDER_FLAG | VARCHAR2 | 32 |  |  | Identifies the commitment transaction line type as purchase order. | DW_Y_N_D_TL | CODE
SUPPLIER_INVOICE_FLAG | VARCHAR2 | 32 |  |  | Identifies the commitment transaction line type as supplier invoice. | DW_Y_N_D_TL | CODE
TRANSFER_ORDER_FLAG | VARCHAR2 | 32 |  |  | Identifies the commitment transaction line type as transfer order. | DW_Y_N_D_TL | CODE
COMMITMENT_TYPE | VARCHAR2 | 32 |  |  | This column contains the values to identify if current transaction is from internal source or external source. Possible values are 'INT' , 'EXT'. | DW_CMT_TYPE_LKP_TL | CMT_TYPE
APPROVED_STATUS | VARCHAR2 | 32 |  |  | Identifies whether the commitment transaction is approved or not. Possible values are, Y, N, ~NO VALUE~. NULLs in fusion are defaulted as ~NO VALUE~ |  |
CAPITALIZABLE_FLAG | VARCHAR2 | 32 |  |  | Identifies whether the commitment transaction is capitalizable or not. Possible values are, Y, N. | DW_Y_N_D_TL | CODE
BILLABLE_FLAG | VARCHAR2 | 32 |  |  | Identifier whether the commitment transaction is billable or not. Possible values are, Y, N | DW_Y_N_D_TL | CODE
RESOURCE_CLASS_CODE | VARCHAR2 | 32 |  |  | Commitment resource class type. Possible values are FINANCIAL_ELEMENTS, PEOPLE, MATERIAL_COST etc. | DW_RESOURCE_CLASS_D | RESOURCE_CLASS_CODE
INVENTORY_ITEM_ID | NUMBER | 38 | 0 |  | The inventory item associated with the incurred cost. For third party integrations, the customer may interface the name or the identifier. | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID ORGANIZATION_ID
INVENTORY_ITEM_DESCRIPTION | VARCHAR2 | 256 |  |  | Inventory item description. |  |
COMMITMENT_CREATION_DATE | DATE |  |  |  | Date on which the commitment transaction is created. |  |
APPROVED_DATE | DATE |  |  |  | Date on which the commitment transaction is approved. |  |
PROMISED_DATE | DATE |  |  |  | Date by which the supplier has agreed to deliver the materials. |  |
NEED_BY_DATE | DATE |  |  |  | Date on which the material is required to be received. |  |
CREATION_DATE | TIMESTAMP |  |  |  | Indicates the date and time of the creation of the row. |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Indicates the date and time of the last update of the row. |  |
CREATED_BY | VARCHAR2 | 128 |  |  | Indicates the user who created the row. | DW_USER_D | USERNAME
LAST_UPDATED_BY | VARCHAR2 | 128 |  |  | Indicates the user who last updated the row. | DW_USER_D | USERNAME
REQUESTOR_NAME | VARCHAR2 | 999 |  |  | The requestor who has requested the material. For third party integrations, the customer may interface the name or the ID. |  |
BUYER_NAME | VARCHAR2 | 999 |  |  | The buyer who has created the purchase order. For third party integrations, the customer may interface the name or the ID. |  |
SUPPLIER_ID | NUMBER | 38 | 0 |  | Supplier from whom the customer received the invoice. For third party integrations, the customer may interface the name or the ID. | DW_PARTY_D | SUPPLIER_ID
WORK_TYPE_ID | NUMBER | 38 | 0 |  | Work type of the commitment transaction. | DW_PROJECT_WORK_TYPE_TL | WORK_TYPE_ID
EXPENDITURE_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization to which the commitment cost is charged, the customer may interface the name or the identifier. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
EXPENDITURE_TYPE_ID | NUMBER | 38 | 0 |  | Expenditure type of the commitment cost, the customer may interface the name or the identifier. | DW_PROJECT_EXPENDITURE_TYPE_D | EXPENDITURE_TYPE_ID
EXPENDITURE_CLASS_CODE | VARCHAR2 | 32 |  |  | Expenditure Type Class for the transaction. | DW_PROJECT_SYSTEM_LINKAGE_TL | SYSTEM_LINKAGE_FUNCTION
EXPENDITURE_ITEM_DATE | DATE |  |  |  | The date on which the commitment cost was incurred. |  |
PRVDR_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Provider business unit identifier. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
PRVDR_LEDGER_ID | NUMBER | 38 | 0 |  | Provider business unit's primary ledger. | DW_LEDGER_D | LEDGER_ID
PRVDR_LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Provider buisness unit's legal entity. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
PRVDR_PA_DATE | DATE |  |  |  | The date on which the transaction was accounted in projects sub-ledger. |  |
PRVDR_PA_PERIOD_NAME | VARCHAR2 | 32 |  |  | The period in which the transaction was accounted in projects sub-ledger. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
PRVDR_PA_PERIOD_TYPE | VARCHAR2 | 16 |  |  | The PA period type for Provider business unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
PRVDR_PA_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | PA Calendar Name for Provider business unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
PRVDR_GL_DATE | DATE |  |  |  | The date on which the transaction was accounted in general ledger. |  |
PRVDR_GL_PERIOD_NAME | VARCHAR2 | 32 |  |  | The period in which the transaction was accounted in general ledger. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
PRVDR_GL_PERIOD_TYPE | VARCHAR2 | 32 |  |  | Provider ledger period type. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
PRVDR_GL_PERIOD_SET_NAME | VARCHAR2 | 32 |  |  | Provider ledger calendar name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
RECVR_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Receiver business unit identifier. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
RECVR_LEDGER_ID | NUMBER | 38 | 0 |  | Receiver business unit's primary ledger. | DW_LEDGER_D | LEDGER_ID
RECVR_LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Project's legal entity. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
RECVR_PA_DATE | DATE |  |  |  | Receiver PA Date |  |
RECVR_PA_PERIOD_NAME | VARCHAR2 | 32 |  |  | Receiver PA Period Name | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
RECVR_PA_PERIOD_TYPE | VARCHAR2 | 16 |  |  | The PA period type for Receiver business unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
RECVR_PA_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | PA Calendar Name for Receiver business unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
RECVR_GL_DATE | DATE |  |  |  | Receiver GL Date |  |
RECVR_GL_PERIOD_NAME | VARCHAR2 | 32 |  |  | Receiver GL Period Name | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
RECVR_GL_PERIOD_TYPE | VARCHAR2 | 32 |  |  | Receiver ledger period type. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
RECVR_GL_PERIOD_SET_NAME | VARCHAR2 | 32 |  |  | Receiver rledger calendar name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
UOM_CODE | VARCHAR2 | 32 |  |  | The customer may provide a unit of measure. For third party integrations, the customer may interface the name or the code. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
TOTAL_QUANTITY | NUMBER |  |  |  | Quantity of the commitment transaction. |  |
QUANTITY_ORDERED | NUMBER |  |  |  | Ordered quantity in the purchase order. |  |
ORIGINAL_QUANTITY_ORDERED | NUMBER |  |  |  | Original ordered quantity in the purchase order. |  |
QUANTITY_CANCELLED | NUMBER |  |  |  | Quantity that has been cancelled in a purchase order. |  |
QUANTITY_DELIVERED | NUMBER |  |  |  | Purchase order quantity that has been delivered. |  |
QUANTITY_INVOICED | NUMBER |  |  |  | Number of quantity that has been invoiced in a purchase order. |  |
QUANTITY_OUTSTANDING_DELIVERY | NUMBER |  |  |  | Quantity that is yet to be delivered in a purchase order. |  |
QUANTITY_OUTSTANDING_INVOICE | NUMBER |  |  |  | Purchase order quantity that is yet to be matched against an invoice.. |  |
QUANTITY_OVERBILLED | NUMBER |  |  |  | Quantity that has been overbilled by the vendor. |  |
UNIT_PRICE | NUMBER |  |  |  | Unit price of the item associated to the commitment transaction. |  |
AMOUNT_ORDERED | NUMBER |  |  |  | Ordered amount in the purchase order. |  |
ORIGINAL_AMOUNT_ORDERED | NUMBER |  |  |  | Original ordered amount in the purchase order. |  |
AMOUNT_CANCELLED | NUMBER |  |  |  | Amount that has been cancelled in a purchase order. |  |
AMOUNT_DELIVERED | NUMBER |  |  |  | Purchase order amount that has been delivered. |  |
AMOUNT_INVOICED | NUMBER |  |  |  | Amount that has been invoiced in a purchase order. |  |
AMOUNT_OUTSTANDING_DELIVERY | NUMBER |  |  |  | Amount that is yet to be delivered in a purchase order. |  |
AMOUNT_OUTSTANDING_INVOICE | NUMBER |  |  |  | Purchase order amount that is yet to be matched against an invoice. |  |
AMOUNT_OVERBILLED | NUMBER |  |  |  | Amount that has been overbilled by the vendor. |  |
TRANSACTION_CURRENCY_CODE | VARCHAR2 | 32 |  |  | The currency in which the cost was incurred. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
TRANSACTION_RAW_COST | NUMBER |  |  |  | The incurred cost in transaction currency. |  |
TRANSACTION_BURDENED_COST | NUMBER |  |  |  | The sum of the raw cost and the burden cost in transaction currency. |  |
TRANSACTION_BURDEN_COST | NUMBER |  |  |  | The burden cost in transaction currency. |  |
RAW_COST_RATE | NUMBER |  |  |  | The rate at which the commitment transaction raw cost is incurred. |  |
PRVDR_LEDGER_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Ledger currency of the commitment transaction. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
PRVDR_LEDGER_RAW_COST | NUMBER |  |  |  | The incurred cost charged to the ledger. |  |
PRVDR_LEDGER_BURDENED_COST | NUMBER |  |  |  | The sum of the raw cost and the burden cost in the ledger currency. |  |
PRVDR_LEDGER_BURDEN_COST | NUMBER |  |  |  | The burden cost in ledger currency. |  |
PRVDR_LEDGER_RATE_DATE | DATE |  |  |  | The date on which the currencies were exchanged. |  |
PRVDR_LEDGER_RATE_TYPE | VARCHAR2 | 32 |  |  | The rate type applied to the currency exchange. |  |
PRVDR_LEDGER_EXCHANGE_RATE | NUMBER |  |  |  | The rate at which the currencies were exchanged. |  |
PROJECT_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Project functional currency of the commitment transaction. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
PROJECT_RAW_COST | NUMBER |  |  |  | The incurred cost in project currency. |  |
PROJECT_BURDENED_COST | NUMBER |  |  |  | The sum of the raw cost and the burden cost in the project currency. |  |
PROJECT_BURDEN_COST | NUMBER |  |  |  | The burden cost in project currency. |  |
PROJECT_RATE_DATE | DATE |  |  |  | The date on which the currencies were exchanged. |  |
PROJECT_RATE_TYPE | VARCHAR2 | 32 |  |  | The rate type applied to the currency exchange. |  |
PROJECT_EXCHANGE_RATE | NUMBER |  |  |  | The rate at which the currencies were exchanged. |  |
RECVR_LEDGER_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Project functional currency of the commitment transaction. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
RECVR_LEDGER_RAW_COST | NUMBER |  |  |  | The incurred cost in project functional currency. |  |
RECVR_LEDGER_BURDENED_COST | NUMBER |  |  |  | The sum of the raw cost and the burden cost in the project functional currency. |  |
RECVR_LEDGER_BURDEN_COST | NUMBER |  |  |  | The burden cost in project function currency. |  |
RECVR_LEDGER_RATE_DATE | DATE |  |  |  | The date on which the currencies were exchanged. |  |
RECVR_LEDGER_RATE_TYPE | VARCHAR2 | 32 |  |  | The rate type applied to the currency exchange. |  |
RECVR_LEDGER_EXCHANGE_RATE | NUMBER |  |  |  | The rate at which the currencies were exchanged. |  |
GLOBAL_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Global currency code. |  |
GLOBAL_RATE_TYPE | VARCHAR2 | 32 |  |  | Global currency rate type. |  |
GLOBAL_RATE_DATE | DATE |  |  |  | Global currency rate date using provider ledger currency conversion rate date and expenditure item date i.e. NVL (PRVDR_LEDGER_RATE_DATE,EXPENDITURE_ITEM_DATE) |  |
GLOBAL_CURRENCY_EXCHANGE_RATE | NUMBER |  |  |  | Global currency conversion rate. |  |
GLOBAL_RAW_COST | NUMBER |  |  |  | The incurred cost in global currency. |  |
GLOBAL_BURDENED_COST | NUMBER |  |  |  | The sum of the raw cost and the burden cost in global currency. |  |
GLOBAL_BURDEN_COST | NUMBER |  |  |  | The burden cost in global currency. |  |
AWARD_BUDGET_PERIOD_ID | NUMBER | 38 | 0 |  | Identifier of Budget Period for which the funding is made. | DW_AWARD_BUDGET_PERIOD_D | AWARD_BUDGET_PERIO_ID
AWARD_FUNDING_SOURCE_ID | NUMBER | 38 | 0 |  | Unique identifier of the funding source. | DW_AWARD_FUNDING_SOURCE_D | FUNDING_SOURCE_ID
CONTRACT_HEADER_ID | NUMBER | 38 | 0 |  | Unique identifier of the contract. | DW_PROJECT_AWARD_D | AWARD_ID

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