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