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.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
PERSON_ID NUMBER 18 Unique identifier of the person associated with the cost.
PERSON_TYPE VARCHAR2 30 The type of person associated with the cost.
PERSON_JOB_ID NUMBER 18 Unique identifier of the person's job on the date the commitment was incurred.
ASSIGNMENT_ID NUMBER 18 Unique identifier of the person assignment associated with the cost.
LD_ELEMENT_TYPE_ID NUMBER 18 Unique identifier of the pay element associated with the cost.
NET_ZERO_ADJUSTMENT_FLAG VARCHAR2 1 Indicates if the cost is net zero adjusted.
ADJUSTED_COMMITMENT_TXN_ID NUMBER 18 Unique identifier of the commitment adjusted by the cost.
LD_ORIG_TRANSACTION_REFERENCE VARCHAR2 120 Transaction reference number of the cost.
PROCESS_GROUP_ID NUMBER 18 Unique identifier of the group associated with the cost. Costs with the same group identifier are processed together and result in the same status.
RUN_ID NUMBER 18 Unique identifier of the allocation run associated with the cost.
BUDGETARY_CONTROL_VAL_STATUS VARCHAR2 30 Budgetary control validation status associated with the cost.
DATA_SET_ID NUMBER 18 Unique identifier of the budgetary control request associated with the cost.
PRBS_ELEMENT_ID NUMBER 18 Unique identifier of the planning resource breakdown structure element associated with the cost.
TOP_PRBS_ELEMENT_ID NUMBER 18 Unique identifier of the top resource derived for the cost using the planning resource breakdown structure.
PJS_SUMMARY_ID NUMBER 18 Unique identifier used by the system to group a set of performance data to be summarized.
REPROCESSED_COST_FLAG VARCHAR2 1 Indicates that the cost has been reprocessed.
PAYROLL_ID NUMBER 18 Unique identifier of the payroll associated with the cost.
RUN_ACTION_ID NUMBER 18 Unique identifier of the payroll run action used to get accounting information associated with the cost.
COST_ACTION_ID NUMBER 18 Unique identifier of the payroll cost action used to get accounting information associated with the cost.
PAYROLL_NAME VARCHAR2 80 Name of the payroll associated with the cost.
COST_ACTION_TYPE VARCHAR2 30 Type of the payroll action used to get accounting information associated with the cost.

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_N10 Non Unique Default ADJUSTED_COMMITMENT_TXN_ID
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_N5 Non Unique Default PERSON_ID, ASSIGNMENT_ID, LD_ELEMENT_TYPE_ID
PJC_COMMITMENT_TXNS_N6 Non Unique Default PJS_SUMMARY_ID
PJC_COMMITMENT_TXNS_N7 Non Unique Default REQUEST_ID, PROCESS_GROUP_ID
PJC_COMMITMENT_TXNS_N8 Non Unique Default DATA_SET_ID
PJC_COMMITMENT_TXNS_N9 Non Unique Default PROJECT_ID, LINE_TYPE, TRANSACTION_STATUS_CODE
PJC_COMMITMENT_TXNS_U1 Unique Default COMMITMENT_TXN_ID