CST_TXN_PREPROCESS_S_GT
This table is used to temporarily store a subset of data from CST_TXN_PREPROCESS_GT table to support internal processing within the Cost Processor.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| TRANSACTION_SOURCE_TYPE_ID | NUMBER | 18 | Transaction source type identifier that is associated with this transaction type. | |
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Single column FK: Identifies the transaction whose incoming cost needs to be computed. | |
| TRANSACTION_ACTION_ID | NUMBER | 18 | Transaction action identifier maps inventory transaction action. | |
| PRIMARY_QTY | NUMBER | Transaction Quantity in Primary unit of measure. | ||
| PRIMARY_UOM | VARCHAR2 | 25 | Inventory Items Primary UOM Code. | |
| SECONDARY_QTY | NUMBER | Transaction quantity in secondary Unit of Measure. | ||
| SECONDARY_UOM | VARCHAR2 | 25 | Secondary unit of measure of the item. | |
| SOURCE_DOC_QTY | NUMBER | Transaction Quantity in source document unit of measure. | ||
| SOURCE_DOC_UOM | VARCHAR2 | 25 | Source document unit of measure code. | |
| 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_ROOT_RCV_TXN_ID | NUMBER | 18 | Single column FK: Identifies the root receipt transaction associated with the transaction. | |
| 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 PO's whose invoices are matched to receipts. | ||
| 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. | |
| MATCH_OPTION | VARCHAR2 | 25 | Purchase order invoicing match option against an order or receipt. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Inventory Item Identifier and References {EGP_SYSTEM_ITEMS_B.inventory_item_id}. | |
| PO_LINE_LOCATION_ID | NUMBER | 18 | Purchase order shipment schedule identifier. | |
| FISCAL_DOC_HEADER_ID | NUMBER | 18 | Fiscal document header unique identifier. | |
| RCV_TRANSACTION_TYPE | VARCHAR2 | 25 | Identifies the Receiving event types associated with the transaction. | |
| COST_PREPROCESSING_STATUS | VARCHAR2 | 30 | The status of cost processing of transactions. | |
| PO_CURRENCY_CODE | VARCHAR2 | 15 | Currency Code on the Purchase Order or the functional currency of destination organization in the transfer order. | |
| PO_CURRENCY_TYPE | VARCHAR2 | 30 | Currency type which should be used for currency conversions. | |
| PO_CURRENCY_RATE | NUMBER | User specified currency conversion rate. This will be populated for project specific purchase order deliver transactions. | ||
| PO_CURRENCY_DATE | TIMESTAMP | The date to be used to determine the currency conversion exchange rate for a currency. | ||
| LEDGER_CURRENCY_CODE | VARCHAR2 | 15 | Functional currency code and it is ledger currency code of profit center business unit. | |
| TRANSACTION_DATE | TIMESTAMP | Identifies the date and time when the transaction was performed. | ||
| ROW_UPDATED_FLAG | VARCHAR2 | 1 | Indicates if this row has been updated during the process. |