CST_FDC_TXN_PREPROCESS_GT
Global temporary table used in the cost preprocessor. It holds the PO related fiscal doc inventory transaction information that came in from the Inventory transaction interface and needs to be processed by the cost preprocessor to derive the transaction cost.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Single column FK: Identifies the transaction whose incoming cost needs to be computed. | |
| PRIMARY_QTY | NUMBER | Transaction Quantity in Primary unit of measure. | ||
| PRIMARY_UOM | VARCHAR2 | 25 | Inventory Items Primary UOM Code. | |
| SECONDARY_QTY | NUMBER | Secondary Transaction Quantity. | ||
| SECONDARY_UOM | VARCHAR2 | 25 | Secondary unit of measure of the item. | |
| PARENT_DELIVERY_TXN_ID | NUMBER | 18 | Identifies the parent delivery transaction if this is a PO adjustment or return transaction. | |
| CMR_PO_DISTRIBUTION_ID | NUMBER | 18 | Single column FK: Identifies the PO distribution associated with the transaction. | |
| CMR_PO_LINE_LOCATION_ID | NUMBER | 18 | Single column FK: Identifies the PO schedule associated with the transaction. | |
| CMR_ROOT_RCV_TXN_ID | NUMBER | 18 | Single column FK: Identifies the root receipt transaction associated with the transaction. | |
| ROOT_RCV_TXN_ID | NUMBER | 18 | Identifies the root receipt transaction associated with the transaction. | |
| PO_PRICE_FLAG | VARCHAR2 | 1 | Indicates if the transaction cost can directly be obtained from the PO price. This is the case when there are no invoices for the associated PO. | |
| TRANSACTION_SOURCE_TYPE_ID | NUMBER | 18 | Transaction source type identifier. | |
| TRANSACTION_ACTION_ID | NUMBER | 18 | Transaction action identifer. | |
| ROOT_RCPT_CURR_CONV_RATE | NUMBER | Currency conversion rate specified on the root receive transaction associated with this delivery. This rate is used for currency conversion for deliveries against POs whose invoices are matched to receipts. | ||
| FISCAL_DOC_HEADER_ID | NUMBER | 18 | Fiscal document header identifier. | |
| FISCAL_DOC_LINE_ID | NUMBER | 18 | Fiscal document line identifer. | |
| FISCAL_DOC_SCHEDULE_ID | NUMBER | 18 | Fiscal document schedule identifer. |