CMR_CST_STAGING_INT
This table stages cost accounting transactions to be consumed by receipt accounting to create logical transactions for transfer order flows and consigned transfer to owned transactions.
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
CMR_CST_STAGING_INT_PK |
CMR_CST_STAGING_INT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CMR_CST_STAGING_INT_ID | NUMBER | 18 | Yes | This is a database sequence generated number to identify a certain instance of the cmr cst staging interface. | |
| ORIGINAL_RECEIPT_TXN_ID | NUMBER | 18 | Reference of the original receipt transaction ID (Deliver transaction ID) on the inter org receipt transactions. This is required to find the purchase order delivery to which the inter org receipt is linked to. | ||
| TRANSACTION_DATE | TIMESTAMP | Yes | The date when this transaction happened. | ||
| INV_TRANSACTION_ID | NUMBER | 18 | Yes | Stores a value that uniquely identifies a certain instance of an object within the external system. Equivalent to external_system_ref_id in cst_inv_transactions table. | |
| CONSUMPTION_UNIT_PRICE | NUMBER | Transfer to owned transaction unit price. | |||
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Yes | Reference of the inventory transaction id. | |
| SOURCE_TXN_TYPE | VARCHAR2 | 3 | Yes | There are two source transaction types. One is TOL, meaning transfer to logical. The other one is TTO, meaning transfer to consigned. | |
| INVENTORY_ORG_ID | NUMBER | 18 | Yes | This identifies the inventory orgnization to which the item belongs. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | This identifies the inventory item. | |
| TXN_SOURCE_DOC_NUMBER | VARCHAR2 | 240 | This identifies the transaction source document number. | ||
| INV_TRANSFER_ORDER_HEADER_ID | NUMBER | 18 | Transfer order header unique identifier. | ||
| INV_TRANSFER_ORDER_LINE_ID | NUMBER | 18 | Transfer order line identifier and every transfer order related transaction must have this. | ||
| TRANSFER_INVENTORY_ORG_ID | NUMBER | 18 | Transfer opposing inventory organization id. | ||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | Yes | The unit of measure code in which primary transaction quantity is specified | |
| SECONDARY_TRANSACTION_UOM_CODE | VARCHAR2 | 3 | The unit of measure code in which secondary transaction quantity is specified | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CMR_CST_STAGING_INT_N1 | Non Unique | Default | SOURCE_TXN_TYPE |
| CMR_CST_STAGING_INT_U1 | Unique | Default | CMR_CST_STAGING_INT_ID |
| CMR_CST_STAGING_INT_U2 | Unique | Default | CST_INV_TRANSACTION_ID |