1. Tables and Views for Project Management
  2. PJC_COMMITMENT_TXNS

PJC_COMMITMENT_TXNS

This table holds commitment txns from requistions, purchase orders and accounts payable invoices.

Details

  • Schema: FUSION

  • Object owner: PJC

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

PJC_COMMITMENT_TXNS_PK

COMMITMENT_TXN_ID

Columns

Name Datatype Length Precision Not-null Comments Status
COMMITMENT_TXN_ID NUMBER 18 Yes System generated unique ID of a commitment transaction. This is exposed to the user as commitment transaction number in UI.
BU_ID NUMBER 18 Yes The ID of the business unit that incurred the commitment, the customer may interface the name or the identifier.
TRANSACTION_SOURCE_ID NUMBER 18 Yes The ID of the application in which the transaction originated.For third party integrations, the customer may interface the name or the identifier.
DOCUMENT_ID NUMBER 18 Yes The ID of the document with which the commitment transaction is captured. For third party integration, the customer may interface the name or the identifier.
DOC_ENTRY_ID NUMBER 18 Yes The ID of the document entry with which the commitment transaction is captured. For third party integration, the customer may interface the name or the identifier.
CMT_LINE_ID NUMBER 18 System generated unique ID of a commitment transaction line.
PROJECT_ID NUMBER 18 Yes The ID of the project to which the commitment cost is charged, the customer may interface the name, number or the identifier. Active
TASK_ID NUMBER 18 Yes The ID of the task to which the commitment cost is charged, the customer may interface the name, number or the identifier. Active
PROJECT_TYPE_ID NUMBER 18 The ID of the project type of the project to which the commitment cost is charged, the customer may interface the name or the identifier.
LINE_TYPE VARCHAR2 1 Yes Identifies the commitment transaction line type as purchase order, purchase requisition, supplier invoice or third-party.possible vlaues I,P,R,E. Active
COMMITMENT_TYPE VARCHAR2 10 Yes This column contains the vlaues to identify if current transaction is from internal source or external source. Possible values are 'INT' , 'EXT'
CMT_NUMBER VARCHAR2 64 Yes Unique identifier of the original commitment transaction. For example, purchase requisition number, purchase order number, supplier invoice number and external commitment transaction number. Active
CMT_DISTRIBUTION_ID NUMBER 18 System generated unique ID of a commitment transaction distribution. Active
CMT_DIST_NUM NUMBER Unique identifier of a commitment transaction distribution.
EXPENDITURE_TYPE_ID NUMBER 18 Yes The ID of the expenditure type of the commitment cost, the customer may interface the name or the identifier.
EXPENDITURE_CATEGORY VARCHAR2 30 The expenditure category of the commitment cost, the customer may interface the name of the identifier. Active
EXPENDITURE_CATEGORY_ID NUMBER 18 The expenditure category Identifier of the commitment cost.
EXP_TYPE_COST_RATE_FLAG VARCHAR2 1 Identifies whether the expenditure type associated to the commitment cost is enabled for defining cost rates or not.
DESCRIPTION VARCHAR2 255 Describes the inventory item. Active
EXPENDITURE_ITEM_DATE DATE Yes The date on which the commitment cost was incurred. Active
PA_PERIOD VARCHAR2 20 The period in which the transaction was accounted in projects sub-ledger. Active
GL_PERIOD VARCHAR2 15 The period in which the transaction was accounted in general ledger. Active
RECVR_PA_PERIOD_NAME VARCHAR2 15 Receiver PA Period Name
RECVR_GL_PERIOD_NAME VARCHAR2 15 Receiver GL Period Name
CMT_LINE_NUMBER NUMBER Unique identifier of a commitment transaction line. Active
CMT_CREATION_DATE DATE Date on which the commitment transaction is created. Active
CMT_APPROVED_DATE DATE Date on which the commitment transaction is approved. Active
CMT_REQUESTOR_NAME VARCHAR2 2000 The requestor who has requested the material. For third party integrations, the customer may interface the name or the ID. Active
CMT_BUYER_NAME VARCHAR2 2000 The buyer who has created the purchase order. For third party integrations, the customer may interface the name or the ID. Active
CMT_APPROVED_STATUS VARCHAR2 1 Identifies whether the commitment transaction is approved or not. Active
CMT_PROMISED_DATE DATE Date by which the supplier has agreed to deliver the materials. Active
CMT_NEED_BY_DATE DATE Date on which the material is required to be received. Active
CMT_HEADER_ID NUMBER 18 Unique ID of a commitment transaction header from the source application. Active
ORGANIZATION_ID NUMBER 18 Yes The ID of the organization to which the commitment cost is charged, the customer may interface the name or the identifier. Active
VENDOR_ID NUMBER 18 The customer must indicate the supplier from whom the customer received the invoice. For third party integrations, the customer may interface the name or the ID. Active
REVENUE_CATEGORY VARCHAR2 30 Revenue category of the commitment transaction. Active
SYSTEM_LINKAGE_FUNCTION VARCHAR2 30 Expenditure Type Class for the transaction. Active
SRC_SYSTEM_LINKAGE_FUNCTION VARCHAR2 30 Populated only for BTC transactions with the system linkage value for the transactions grouped for creating the BTC transaction.
UOM_CODE VARCHAR2 30 The customer may provide a unit of measure. For third party integrations, the customer may interface the name or the code. Active
UNIT_PRICE NUMBER Unit price of the item associated to the commitment transaction. Active
CMT_IND_COMPILED_SET_ID NUMBER 18 Commitment Compiled Set ID Active
TOT_CMT_QUANTITY NUMBER Yes Quantity of the commitment transaction. Active
QUANTITY_ORDERED NUMBER Ordered quantity in the purchase order. Active
AMOUNT_ORDERED NUMBER Ordered amount in the purchase order. Active
ORIGINAL_QUANTITY_ORDERED NUMBER Original ordered quantity in the purchase order. Active
ORIGINAL_AMOUNT_ORDERED NUMBER Original ordered amount in the purchase order. Active
QUANTITY_CANCELLED NUMBER Quantity that has been cancelled in a purchase order. Active
AMOUNT_CANCELLED NUMBER Amount that has been cancelled in a purchase order. Active
QUANTITY_DELIVERED NUMBER Purchase order quantity that has been delivered. Active
AMOUNT_DELIVERED NUMBER Purchase order amount that has been delivered. Active
QUANTITY_INVOICED NUMBER Number of quantity that has been invoiced in a purchase order. Active
AMOUNT_INVOICED NUMBER Amount that has been invoiced in a purchase order. Active
QUANTITY_OUTSTANDING_DELIVERY NUMBER Quantity that is yet to be delivered in a purchase order.
AMOUNT_OUTSTANDING_DELIVERY NUMBER Amount that is yet to be delivered in a purchase order. Active
QUANTITY_OUTSTANDING_INVOICE NUMBER Purchase order quantity that is yet to be matched against an invoice..
AMOUNT_OUTSTANDING_INVOICE NUMBER Purchas order amount that is yet to be matched against an invoice. Active
QUANTITY_OVERBILLED NUMBER Quantity that has been overbilled by the vendor. Active
AMOUNT_OVERBILLED NUMBER Amount that has been overbilled by the vendor. Active
ADDITIONAL_INFO1 VARCHAR2 15 User entered original transaction additional information. Active
ADDITIONAL_INFO2 VARCHAR2 15 User entered original transaction additional information. Active
ADDITIONAL_INFO3 VARCHAR2 15 User entered original transaction additional information. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
BURDEN_SUM_SOURCE_RUN_ID NUMBER 18 Used for Separate Line Burdening Active
BURDEN_SUM_DEST_RUN_ID NUMBER 18 Used for Separate Line Burdening Active
BURDEN_SUM_REJECTION_CODE VARCHAR2 30 Used for Separate Line Burdening Active
DENOM_CURRENCY_CODE VARCHAR2 15 The currency in which the cost was incurred. Active
DENOM_RAW_COST NUMBER The incurred cost. Active
DENOM_BRDND_COST NUMBER The sum of the raw cost and the burden cost in the transaction currency. Active
RAW_COST_RATE NUMBER The rate at which the commitment transaction raw cost is incurred.
ACCT_CURRENCY_CODE VARCHAR2 15 Ledger currency of the commitment transaction. Active
ACCT_RAW_COST NUMBER The incurred cost charged to the ledger. Active
ACCT_BRDND_COST NUMBER The sum of the raw cost and the burden cost in the ledger currency. Active
ACCT_RATE_DATE DATE The date on which the currencies were exchanged. Active
ACCT_RATE_TYPE VARCHAR2 30 The rate type applied to the currency exchange. Active
ACCT_EXCHANGE_RATE NUMBER The rate at which the currencies were exchanged. Active
TRANSACTION_STATUS_CODE VARCHAR2 1 Identifies the reason for the rejection of the commitment transaction. Active
INVENTORY_ITEM_ID NUMBER 18 The inventory item associated with the incurred cost. For third party integrations, the customer may interface the name or the identifier. Check if the inventory item is valid. Active
PRJ_RAW_COST NUMBER The incurred cost in project currency. Active
PRJ_BRDND_COST NUMBER The sum of the raw cost and the burden cost in the project currency. Active
PRJ_CURRENCY_CODE VARCHAR2 15 Project functional currency of the commitment transaction. Active
PRJ_RATE_DATE DATE The date on which the currencies were exchanged. Active
PRJ_RATE_TYPE VARCHAR2 30 The rate type applied to the currency exchange. Active
PRJ_EXCHANGE_RATE NUMBER The rate at which the currencies were exchanged. Active
GL_DATE DATE The date on which the transaction was accounted in general ledger.
PA_DATE DATE The date on which the transaction was accounted in projects sub-ledger.
RECVR_GL_DATE DATE Receiver GL Date
RECVR_PA_DATE DATE Receiver PA Date
PROJFUNC_CURRENCY_CODE VARCHAR2 15 Project functional currency of the commitment transaction.
PROJFUNC_RATE_DATE DATE The date on which the currencies were exchanged.
PROJFUNC_RATE_TYPE VARCHAR2 30 The rate type applied to the currency exchange.
PROJFUNC_BRDND_COST NUMBER The sum of the raw cost and the burden cost in the project functional currency.
PROJFUNC_RAW_COST NUMBER The incurred cost in project functional currency.
PROJFUNC_EXCHANGE_RATE NUMBER The rate at which the currencies were exchanged.
WORK_TYPE_ID NUMBER 18 Work type of the commitment transaction.
CAPITALIZABLE_FLAG VARCHAR2 1 Identifies whether the commitment transaction is capitalizable or not.
BILLABLE_FLAG VARCHAR2 1 Identifier whether the commitment transaction is billable or not.
ORIGINAL_TXN_REFERENCE VARCHAR2 120 Unique identification of each third-party commitment transaction record.
RESOURCE_CLASS VARCHAR2 30 Commitment Resource Flag
INTERFACE_ID NUMBER 18 INTERFACE_ID
RECVR_ORG_ID NUMBER 18 Receiver Business Unit
CONTRACT_ID NUMBER 18 Unique identifier of the contract.
RESERVED_ATTRIBUTE1 VARCHAR2 150 Unique identifier of the funding source.
CONTRACT_LINE_ID NUMBER 18 Unique identifier of the contract Line.
FUNDING_ALLOCATION_ID NUMBER 18 Specifies the name of the project funding override.
BUDGET_PERIOD_ID NUMBER 18 Identifier of Budget Period for which the funding is made.
TXN_ACCUM_HEADER_ID NUMBER 18 Transaction Accum Header for given transaction
PLANNED_FLAG VARCHAR2 1 Indicates if the commitment transaction has been planned for.

Foreign Keys

Table Foreign Table Foreign Key Column
PJC_COMMITMENT_TXNS pjf_projects_all_b PROJECT_ID
PJC_COMMITMENT_TXNS pjf_proj_elements_b TASK_ID
PJC_COMMITMENT_TXNS pjf_exp_types_b EXPENDITURE_TYPE_ID
PJC_COMMITMENT_TXNS pjf_system_linkages SYSTEM_LINKAGE_FUNCTION
PJC_COMMITMENT_TXNS pjf_bu_impl_all BU_ID

Indexes

Index Uniqueness Tablespace Columns
PJC_COMMITMENT_TXNS_N1 Non Unique Default BU_ID, PROJECT_ID, TRANSACTION_STATUS_CODE, COMMITMENT_TYPE
PJC_COMMITMENT_TXNS_N2 Non Unique Default BUDGET_PERIOD_ID
PJC_COMMITMENT_TXNS_N3 Non Unique Default TRANSACTION_STATUS_CODE, INTERFACE_ID
PJC_COMMITMENT_TXNS_N4 Non Unique PJC_COMMITMENT_TXNS_N4 INVENTORY_ITEM_ID
PJC_COMMITMENT_TXNS_U1 Unique Default COMMITMENT_TXN_ID