CST_PURCHASE_ORDER_DTLS_S_GT
This table is used to temporarily store a subset of data from CST_PURCHASE_ORDER_DTLS_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 | Not-null | Comments |
|---|---|---|---|---|---|
| CMR_PO_DISTRIBUTION_ID | NUMBER | 18 | Yes | Single column FK: Internal identifier of the purchase order distribution. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Value that identifies the inventory item associated with the transaction. | |
| PRICE_IN_PRIMARY_UOM | NUMBER | Price calculated per primary unit of the item as defined in the deliver to inventory organization. | |||
| PRICE | NUMBER | Price defined on Purchase Order. | |||
| QUANTITY_ORDERED | NUMBER | Yes | Quantity of the material ordered for this distribution. | ||
| UOM_CODE | VARCHAR2 | 3 | Yes | Primary unit of measure of the item. | |
| QUANTITY_CANCELLED | NUMBER | Quantity cancelled for this distribution. | |||
| SECONDARY_QUANTITY | NUMBER | Quantity ordered in the secondary unit of measure. | |||
| SECONDARY_UOM_CODE | VARCHAR2 | 3 | Secondary unit of measure of the item. | ||
| SECONDARY_QTY_CANCELLED | NUMBER | Quantity cancelled in the secondary unit of measure. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | Identifies the currency of the price. | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Conversion type that should be used for currency conversion. | ||
| CURRENCY_CONVERSION_DATE | TIMESTAMP | The date to be used to determine the exchange rates for currency conversion. | |||
| CURRENCY_CONVERSION_RATE | NUMBER | Optional user specified currency conversion rate. | |||
| DELIVER_TO_BU_FUNC_CURR_CODE | VARCHAR2 | 15 | Functional currency of the deliver to business unit. | ||
| NR_TAX_IN_PRIMARY_UOM | NUMBER | Non-Recoverable tax calculated per primary unit of the item as defined in the deliver to inventory organization. | |||
| NR_TAX | NUMBER | Unit Non-Recoverable tax calculated on Purchase Order. | |||
| CONV_FACTOR_TO_PRIMARY_UOM | NUMBER | Yes | Factor to be multiplied with the PO quantity to convert it into the primary unit of measure of the item as defined in the deliver to inventory organization. | ||
| MATCH_OPTION | VARCHAR2 | 25 | Indicates whether the invoice match should happen at the purchase order or the receipt. Valid values are P- Purchase Order, R- Receipt. | ||
| EVENT_DATE | TIMESTAMP | Yes | Date when the event in the EVENT_TYPE happened. | ||
| EVENT_TYPE | VARCHAR2 | 30 | Can be one of the following: PO Approval, Retroactive Price Update, Quantity Cancellation, PO Close. | ||
| DELIVER_TO_INVENTORY_ORG_ID | NUMBER | 18 | Inventory organization where the material is scheduled to be received. | ||
| ACTIVE_FLAG | VARCHAR2 | 1 | Indicates whether there is more recent information for this distribution. Only the most recent record will have this flag set to Y. | ||
| PROCESSED_BY_CA_FLAG | VARCHAR2 | 1 | Indicates whether the distribution was picked up by the cost accounting processor. | ||
| PO_LINE_LOCATION_ID | NUMBER | 18 | Purchase order shipment schedule identifier. | ||
| CMR_PO_LINE_LOCATION_ID | NUMBER | 18 | Internal Identifier of the purchase order schedule. | ||
| ACTIVE_FOR_CA_FLAG | VARCHAR2 | 1 | Marked by the PO interface processor to help the acquisition cost processor keep track of the latest record for the distribution. | ||
| CONSIGNED_FLAG | VARCHAR2 | 1 | Indicates whether the item will be purchased under consignment arrangement from supplier. | ||
| PO_EVENT_DATE | TIMESTAMP | Date when the event in the EVENT_TYPE happened. | |||
| ROW_UPDATED_FLAG | VARCHAR2 | 1 | Indicates if this row has been updated during the process. | ||
| TRADE_ORG_BU_FUNC_CURR_CODE | VARCHAR2 | 15 | Functional currency of the trade organization business unit. | ||
| SFO_PRIMARY_TRADE_RELATION_ID | NUMBER | 18 | Captures the primary trade relationship identifier of an orchestration agreement line. | ||
| TRADE_ORGANIZATION_ID | NUMBER | 18 | Captures the inventory organization where the trade buy-sell transactions defined by orchestration agreement are accounted. | ||
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Identifier of the source system that owns the purchase order entity. | ||
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Identifier of the purchase order distribution line in the source system. | ||
| TAX_EXCLUSIVE_PRICE | NUMBER | PO line price exclusive of all taxes. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_PURCHASE_ODR_DTLS_S_GT_N1 | Non Unique | CMR_PO_DISTRIBUTION_ID |