CST_CONSIGNED_PRICE_UPDATES_GT
Temporary table to snapshot the price changes for consigned purchase orders that are yet to be processed by the acquisition cost processor.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: TEMP3
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CMR_PO_DISTRIBUTION_ID | NUMBER | 18 | Yes | Internal Identifier of the PO Distribution. | |
| EFFECTIVE_DATE | TIMESTAMP | Yes | Price is effective for ownership changes that happen on or after this date. | ||
| TAX_EXCLUSIVE_PRICE | NUMBER | PO line price exclusive of all taxes | |||
| PROCESSED_CLEARED_POD_FLAG | VARCHAR2 | 1 | Indicates that the price update belongs to an accrual cleared PO distribution that has already been processed by the current run of acquisition cost processor. | ||
| TRANSFER_TO_OWNED_TXN_ID | NUMBER | 18 | Inventory transfer to owned transaction identifier with positive quantity to indicate quantity is moved to inventory from consigned. | ||
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Indicates the Trade In Transit Receipt of the Transfer to Owned transaction. |