CMR_TRANSACTIONS_S_GT
This table is used to temporarily store a subset of input data from CMR_TRANSACTIONS table to support internal processing.
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CMR_TRANSACTIONS_S_GT_PK |
TRANSACTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 18 | Yes | Transaction identifier and surrogate key column. | |
| CMR_PO_DISTRIBUTION_ID | NUMBER | 18 | Single column FK: Identifies entity in Receipt Accounting PO distributions. This value will exist for match-to-PO as well as match-to-receipt cases. For inter-organization flows, it will be NULL. | ||
| CMR_RCV_TRANSACTION_ID | NUMBER | 18 | Single Column FK: Identifies the receiving transaction. For trade event flow, it will be NULL. | ||
| TRADE_EVENT_ID | NUMBER | 18 | Trade Event Identifier and references to {CST_TRADE_EVENTS.TRADE_EVENT_ID}. | ||
| PARENT_TRANSACTION_ID | NUMBER | 18 | Yes | Parent receiving transaction identifier: -1 for receipt transaction, for return to vendor transaction it is the parent receipt's transaction ID. | |
| CMR_ROOT_RECEIVE_TXN_ID | NUMBER | 18 | Internal identifier that links the transaction with its first receiving transaction identifier. | ||
| TRANSACTION_TYPE | VARCHAR2 | 40 | Yes | Single column FK: Identifies the receiving event types associated with the transaction. | |
| TRANSACTION_DATE | DATE | Yes | The date when this transaction happened. | ||
| SHIP_TO_ORGANIZATION_ID | NUMBER | 18 | Yes | Inventory Organization where the item is stored. | |
| 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. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| TRANSFER_ORDER_DIST_ID | NUMBER | 18 | Stores transfer order identifier and maps to {CST_TRANSFER_ORDER_DISTS.DISTRIBUTION_ID}. | ||
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Costing Inventory transaction identifier and maps CST_INV_TRANSACTIONS.CST_INV_TRANSACTION_ID for Transfer Order based inter-organization flow with expense destination. | ||
| LOT_NUMBER | VARCHAR2 | 80 | This stores lot number information for inventory item. | ||
| SERIAL_NUMBER | VARCHAR2 | 80 | This stores serial number information for inventory item. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CMR_TRANSACTIONS_S_GT_U1 | Unique | CMR_PO_DISTRIBUTION_ID, CMR_RCV_TRANSACTION_ID, TRADE_EVENT_ID, CST_INV_TRANSACTION_ID, TRANSFER_ORDER_DIST_ID, TRANSACTION_TYPE, LOT_NUMBER, SERIAL_NUMBER |
| CMR_TRANSACTIONS_S_GT_U2 | Unique | TRANSACTION_ID |