1. Tables and Views for Project Management
  2. PJS_PAST_COMMITMENT_SUM

PJS_PAST_COMMITMENT_SUM

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

Details

  • Schema: FUSION

  • Object owner: PJS

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Columns

Name Datatype Length Precision Not-null Comments Status
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
TXN_ACCUM_HEADER_ID NUMBER 18 TXN_ACCUM_HEADER_ID
PLANNED_FLAG VARCHAR2 1 PLANNED_FLAG
RECORD_ID NUMBER 18 Yes RECORD_ID
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
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
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.
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
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
TOT_CMT_QUANTITY NUMBER Yes Quantity of the commitment transaction. 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
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
PROJECT_CURRENCY_CODE VARCHAR2 15 The currency in which the cost was incurred. 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
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
BU_ID NUMBER 18 Yes The ID of the business unit that incurred the commitment, the customer may interface the name or the identifier.
PROJFUNC_CURRENCY_CODE VARCHAR2 15 Project functional currency of the commitment transaction.
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.
EXPENDITURE_CATEGORY_ID NUMBER 18 The expenditure category Identifier of the commitment cost.
BUDGET_PERIOD_ID NUMBER 18 Identifier of Budget Period for which the funding is made.
REVENUE_CATEGORY VARCHAR2 120 Revenue category of the commitment transaction. Active
CHANGED_FLAG VARCHAR2 1 Changed status of the commitment transaction. Active
STAMP_ID NUMBER 18 Stamp ID.
CONTRACT_ID NUMBER 18 Unique identifier of the award.
FUNDING_SOURCE_ID NUMBER 18 Identifier of the award funding source.

Indexes

Index Uniqueness Tablespace Columns
PJS_PAST_COMMITMENT_SUM_N1 Non Unique Default PROJECT_ID
PJS_PAST_COMMITMENT_SUM_U1 Unique Default RECORD_ID