1. Tables and Views for Procurement
  2. POI_TRANSACTIONS

POI_TRANSACTIONS

This table contains information about the transactions within a batch. These are the transactions that will be classified and have been copied to this table from data set at the onset of classification process.

Details

  • Schema: FUSION

  • Object owner: POI

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

POI_TRANSACTIONS_PK

TXN_ID

Columns

Name Datatype Length Precision Not-null Comments
SOURCE_TABLE VARCHAR2 30 Source table of transaction data.
DATASOURCE_NUM_ID NUMBER 18 Identifies the data source number.
TXN_ID NUMBER 18 Yes Uniquely identifies the transaction data.
BATCH_ID NUMBER 18 Identifies the batch in processing the transactions.
TXN_CLSF_STATUS VARCHAR2 30 Yes Classification status for the transaction.
CLSF_LEVEL NUMBER 18 Classification level if exists for the transaction from the payload.
GENERATED_CODE NUMBER 18 Generated category code on the transaction.
MANUAL_CODE NUMBER 18 Manual category code from the payload.
SOURCE VARCHAR2 30 Transaction type of the spend data.
CLSF_ADDITIONAL_DESC VARCHAR2 255 Classification additional description from payload.
SOURCE_TXN_ID VARCHAR2 255 Identifies the source transaction from payload.
DATA_SOURCE_TXN_ID NUMBER Identifies the data source transaction from payload.
EXISTING_CODE NUMBER 18 Category code entered in the payload.
TXN_AMOUNT NUMBER Spend amount on the transaction from payload.
ITEM_TEXT VARCHAR2 4000 Concatenated text of transaction description, line description, item description, item code, supplier name, supplier site, operating unit, UOM, and currency.
FACT_INTEGRATION_ID VARCHAR2 320 Identifies the fact table from payload.
FACT_TABLE VARCHAR2 30 Associated fact table linked to the transaction from payload.
TXN_DESC VARCHAR2 2000 Description of the transaction from payload.
LINE_DESC VARCHAR2 2000 Line description of spend transaction from payload.
ITEM_CODE VARCHAR2 300 Item code in the transaction from payload.
ITEM_DESCRIPTION VARCHAR2 2000 Item description in the transaction.
SUPPLIER_NAME VARCHAR2 360 Supplier name in the transaction.
SUPPLIER_SITE VARCHAR2 240 Supplier site value in the transaction.
OPERATING_UNIT VARCHAR2 400 Operating unit of transaction from payload.
UOM VARCHAR2 400 Item unit of measure from payload.
LINE_QUANTITY NUMBER Transaction quantity on the line from payload.
CURRENCY VARCHAR2 215 Transactional currency on the line from payload.
UNIT_PRICE NUMBER Unit price of transactional item from payload.
LINE_AMOUNT NUMBER Transaction amount from payload.
COST_CENTER VARCHAR2 320 Cost center associated with the operating unit of transaction.
EBS_CATEGORY_CODE NUMBER 18 Oracle application category code from payload.
UNSPSC_CATEGORY_CODE NUMBER 18 UNPSC category code from payload.
CUSTOM_CATEGORY_CODE1 NUMBER 18 Category code segment1 value populated from payload.
CUSTOM_CATEGORY_CODE2 NUMBER 18 Category code segment2 value populated from payload.
CUSTOM_CATEGORY_CODE3 NUMBER 18 Category code segment2 value populated from payload.
RULE_DRIVEN VARCHAR2 30 Rule derived on the transaction from payload.
TXN_NUM VARCHAR2 320 Transaction number of spend data from payload.
LINE_NUM NUMBER Spend data line nnumber from payload.
TXN_DATE DATE Transaction date of spend data from payload.
BU_ID NUMBER 18 Business unit identifier of transactions.
SHIP_TO_LOCATION VARCHAR2 240 ShipTo location name referencing to HR_LOCATIONS_ALL_F_VL.location_name.
NATURAL_ACCOUNT VARCHAR2 25 Account code in chart of accounts that represents the natural account qualifier.
NATURAL_ACCOUNT_DESC VARCHAR2 1000 Description of the code in chart of accounts with natural account qualifier.
PROC_CAT_HIERARCHY1 VARCHAR2 240 Procurement category hierarchy level 1 value.
PROC_CAT_HIERARCHY2 VARCHAR2 240 Procurement category hierarchy level 2 value.
PROC_CAT_HIERARCHY3 VARCHAR2 240 Procurement category hierarchy level 3 value.
PROC_CAT_HIERARCHY4 VARCHAR2 240 Procurement category hierarchy level 4 value.
PROC_CAT_HIERARCHY5 VARCHAR2 240 Procurement category hierarchy level 5 value.
PROC_CAT_HIERARCHY6 VARCHAR2 240 Procurement category hierarchy level 6 value.
PROC_CAT_HIERARCHY7 VARCHAR2 240 Procurement category hierarchy level 7 value.
PROC_CAT_HIERARCHY8 VARCHAR2 240 Procurement category hierarchy level 8 value.
PROC_CAT_HIERARCHY9 VARCHAR2 240 Procurement category hierarchy level 9 value.
PROC_CAT_HIERARCHY10 VARCHAR2 240 Procurement category hierarchy level 10 value.
LEGAL_ENTITY VARCHAR2 400 Name of the legal entity defined in the system referencing to XLE_ENTITY_PROFILES.NAME.
LINE_TYPE VARCHAR2 80 Value that determines the nature of invoice line such as item, tax.
INVOICE_TYPE VARCHAR2 80 Value that determines the nature of invoice such as standard, credit.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.
DS_ATTRIBUTE1 VARCHAR2 4000 Additional attribute used for spend classification.
DS_ATTRIBUTE2 VARCHAR2 4000 Additional attribute used for spend classification.
DS_ATTRIBUTE3 VARCHAR2 4000 Additional attribute used for spend classification.
DS_ATTRIBUTE4 VARCHAR2 4000 Additional attribute used for spend classification.
DS_ATTRIBUTE5 VARCHAR2 4000 Additional attribute used for spend classification.
DS_ATTRIBUTE6 VARCHAR2 4000 Additional attribute used for spend classification.
DS_ATTRIBUTE7 VARCHAR2 4000 Additional attribute used for spend classification.
DS_ATTRIBUTE8 VARCHAR2 4000 Additional attribute used for spend classification.
DS_ATTRIBUTE9 VARCHAR2 4000 Additional attribute used for spend classification.
DS_ATTRIBUTE10 VARCHAR2 4000 Additional attribute used for spend classification.
DS_ATTRIBUTE11 VARCHAR2 4000 Additional attribute used for spend classification.
DS_ATTRIBUTE12 VARCHAR2 4000 Additional attribute used for spend classification.
DS_ATTRIBUTE13 VARCHAR2 4000 Additional attribute used for spend classification.
DS_ATTRIBUTE14 VARCHAR2 4000 Additional attribute used for spend classification.
DS_ATTRIBUTE15 VARCHAR2 4000 Additional attribute used for spend classification.
DS_ATTRIBUTE16 VARCHAR2 4000 Additional attribute used for spend classification.
DS_ATTRIBUTE17 VARCHAR2 4000 Additional attribute used for spend classification.
DS_ATTRIBUTE18 VARCHAR2 4000 Additional attribute used for spend classification.
DS_ATTRIBUTE19 VARCHAR2 4000 Additional attribute used for spend classification.
DS_ATTRIBUTE20 VARCHAR2 4000 Additional attribute used for spend classification.

Indexes

Index Uniqueness Tablespace Columns
POI_TRANSACTIONS_N1 Non Unique Default SOURCE_TABLE, SOURCE, DATASOURCE_NUM_ID, SOURCE_TXN_ID
POI_TRANSACTIONS_N2 Non Unique Default BATCH_ID, SOURCE_TABLE, MANUAL_CODE
POI_TRANSACTIONS_N3 Non Unique Default BATCH_ID, CLSF_LEVEL
POI_TRANSACTIONS_N4 Non Unique Default BATCH_ID, TXN_CLSF_STATUS
POI_TRANSACTIONS_N5 Non Unique Default BATCH_ID, EXISTING_CODE
POI_TRANSACTIONS_N6 Non Unique Default BATCH_ID, GENERATED_CODE
POI_TRANSACTIONS_N7 Non Unique Default TO_NUMBER("SOURCE_TXN_ID")
poi_transactions_U1 Unique Default TXN_ID