1. Tables and Views for Project Management
  2. PJF_PERIODS_CLOSE_TMP

PJF_PERIODS_CLOSE_TMP

PJF_PERIODS_CLOSE_TMP stores both invencory and receiving transactions when the period is about to change to close or close pending and this is a temporary table.

Details

  • Schema: FUSION

  • Object owner: PJF

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

PJF_PERIODS_CLOSE_TMP_PK

LINE_NUMBER, TXN_SOURCE_DOC_TYPE

Columns

Name Datatype Length Precision Not-null Comments Status
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
LINE_NUMBER NUMBER 18 Yes The sequence number from SCM consumer of the request id Active
PROJECT_ID NUMBER 18 The project_id of the SCM transaction Active
TASK_ID NUMBER 18 The task_id of the SCM transaction Active
EXPENDITURE_TYPE_ID NUMBER 18 The expenditure type id of the SCM transaction Active
SUPPLIER_ID NUMBER 18 The supplier id of the SCM transaction Active
SUPPLIER_NAME VARCHAR2 360 The supplier name of the scm transaction Active
TRANSACTION_NUMBER VARCHAR2 50 The transaction number of the scm transaction Active
TRANSACTION_DATE DATE The transaction date of the scm transaction Active
INVENTORY_ITEM_ID NUMBER 18 INVENTORY_ITEM_ID Active
INVENTORY_ITEM_DESC VARCHAR2 240 The inventory item description of the scm transaction Active
LEDGER_AMOUNT NUMBER The ledger amount of the scm transaction Active
CURRENCY_CODE VARCHAR2 15 The currency code of the scm transaction Active
ACCOUNTING_STATUS VARCHAR2 1 The accounting status of the scm transaction Active
INVENTORY_ORG_ID NUMBER 18 The inventory organization id of the scm transaction Active
TXN_SOURCE_DOC_TYPE VARCHAR2 50 Yes TXN_SOURCE_DOC_TYPE Active
TXN_SOURCE_DOC_NUMBER VARCHAR2 50 TXN_SOURCE_DOC_NUMBER Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated 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
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active

Foreign Keys

Table Foreign Table Foreign Key Column
PJF_PERIODS_CLOSE_TMP pjf_bu_impl_all INVENTORY_ORG_ID

Indexes

Index Uniqueness Tablespace Columns Status
PJF_PERIODS_CLOSE_TMP_U1 Unique FUSION_TS_TX_IDX LINE_NUMBER, TXN_SOURCE_DOC_TYPE Active
PJF_PERIODS_CLOSE_TMP_U2 Unique FUSION_TS_TX_IDX REQUEST_ID, LINE_NUMBER, TXN_SOURCE_DOC_TYPE