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   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 2048     The requestor who has requested the material. For third party integrations, the customer may interface the name or the ID.    
BUYER_NAME VARCHAR2 2048     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.