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