1. Tables and Views for SCM
  2. CST_PURCHASE_ORDER_DTLS_GT

CST_PURCHASE_ORDER_DTLS_GT

Global temporary table used in the cost preprocessor. It holds the PO distribution information that came in from the PO interface and needs to be processed by the cost preprocessor.

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 Inventory Item Identifier.
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 code.
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.

Indexes

Index Uniqueness Columns
CST_PURCH_ORDER_DTLS_GT_N1 Non Unique CMR_PO_DISTRIBUTION_ID