1. Tables and Views for SCM
  2. CSE_TRANSACTIONS_GT

CSE_TRANSACTIONS_GT

This is an inprocess data staging table used in the processing of source transactions from other fusion source applications to installed base.

Details

  • Schema: FUSION

  • Object owner: CSE

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Comments
GTT_TXN_ID NUMBER 18 Temporary Transaction Identifier. The primary key of the entity.
GTT_GROUP_ID NUMBER 18 Grouping Identifier. The grouping key for the processing.
TRANSACTION_ID NUMBER 18 Transaction Identifier. The primary key column.
SRC_SYSTEM_TYPE VARCHAR2 30 Type of the Source System. Internal or External.
SRC_SYSTEM_ID NUMBER 18 Source System Identifier. Application Identifier when the source system type is Internal.
SRC_TRANSACTION_DATE TIMESTAMP Source Transaction Date. Date when the transaction was performed in the source system.
SRC_TRANSACTION_ID NUMBER Source Transaction Identifier. The unique transaction identifier in the source system.
SRC_TRANSACTION_TYPE_ID VARCHAR2 30 The transaction type identifier for the recorded transaction.
SRC_TRANSACTION_TYPE VARCHAR2 240 Source Transaction type. The type of transaction performed in the source system.
SRC_TRANSACTION_QTY NUMBER Source Transaction Quantity. The quantity transacted in the source system.
SRC_TRANSACTION_UOM_CODE VARCHAR2 3 The unit of measure code captured for the quantity transacted in the source system.
SECONDARY_QUANTITY NUMBER This is the secondary quantity captured when the item supports dual units of measure.
SECONDARY_UOM_CODE VARCHAR2 3 The unit of measure code for the secondary quantity. This is captured only when the item supports dual units of measure.
ITEM_ID NUMBER 18 Inventory Item Identifier. The item transaction in the source system.
ITEM_REVISION VARCHAR2 18 The item revision for which the transaction is performed.
ITEM_ORGANIZATION_ID NUMBER 18 Item Organization Identifier. The foreign key to the maintenance organization.
REFERENCED_TRANSACTION_ID NUMBER 18 An upgrade or replace transaction that is referenced here. This will give room for a cancel transaction to cancel out the referenced transaction. Only a cancel transaction will have this value populated.
PJC_PROJECT_ID NUMBER 18 The foreign key reference to the Project. Assets created from supply chain transactions that are performed in the context of a project will have this value populated.
PJC_TASK_ID NUMBER 18 The foreign key reference to the Project Task. Assets created from supply chain transactions that are performed in the context of a project task will have this value populated.
PJC_EXPENDITURE_TYPE_ID NUMBER 18 The expenditure type that is captured along with the project and task to categorize the exenditure.
PJC_EXPENDITURE_DATE DATE The data at which the project expenditure is captured.
PJC_EXPENDITURE_ORG_ID NUMBER 18 The expenditure organization in which the project and task is collecting the cost for.
TXN_GROUP_ID NUMBER 18 The transaction group identifier that is used by the inventory transaction processor to group transaction that are involved in the lot splits, merges, and translations.
SOURCE_LOT_TXN_FLAG VARCHAR2 1 Flag indicating that the transaction interfaced to genealogy in the group of transactions (grouped by txn_group_id) for the lot merge/split, is of the source lot.
CREATION_MODE VARCHAR2 30 The means used to create this transaction. Either using the REST API, User Interface, Open Interface, or from Integration.
ASSET_GROUP_NUMBER VARCHAR2 30 The asset group in which the assets should be included. An asset group number is captured in the sales order line and is passed through to installed base.

Indexes

Index Uniqueness Columns
CSE_TRANSACTIONS_GT_N01 Non Unique GTT_GROUP_ID, GTT_TXN_ID