CMR_CONSIGNED_PO_PRICE_DTLS_GT
Global temporary table (session) used in the process of copying relevant purchase order data from Fusion Purchasing.
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ORIGINAL_RECEIPT_TXN_ID | NUMBER | 18 | Reference of the original consigned purchase order receipt transaction identifier. | ||
| TRANSACTION_DATE | TIMESTAMP | Yes | Transaction date of the transfer to owned or return transaction. | ||
| TRANSFER_TO_OWNED_TXN_ID | VARCHAR2 | 30 | Yes | Inventory transfer to owned transaction identifier with positive quantity to indicate the quantity is moved to inventory from consigned. | |
| CONSUMPTION_UNIT_PRICE | NUMBER | Transfer to owned transaction unit price. | |||
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Yes | Stores a value that uniquely identifies transfer to owned transaction. |