This table stores information about project commitments.
Module: Project Costing
COMMITMENT_TXN_ID
| 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, 2024, Oracle and/or its affiliates.