Retail Integration Mappings Report Release:15.0.0 (Store Inventory Management)
Application Store Inventory Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/PODesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:PODesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PODesc in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
doc_type varchar21 1 1 Indicates the type of document this message is for. Valid value is 'P' for purchase order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Not used in SIM
order_no varchar212 1 1 Contains the number to uniquely identify an order within the system. PURCHASE_ORDER EXTERNAL_ID VARCHAR2 128 Yes Unique Identifier of the purchase order
order_type varchar29 1 1 Indicates the type of order and which Open To Buy bucket will be updated. Valid values include: 'N/B' - Non Basic 'ARB' - Automatic Reorder of Basic 'BRB' - Buyer Reorder of Basic. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Indicates the type of order and which Open To Buy bucket will be updated. Valid values include: 'N/B' - Non Basic 'ARB' - Automatic Reorder of Basic 'BRB' - Buyer Reorder of Basic.
order_type_desc varchar2250 1 1 The description for the order type. Not used in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
dept number4 0 1 Contains the department number for orders limited to a single department and will be Null for orders involving items in more than one department. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Not used in SIM
dept_name varchar2120 0 1 Not used in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Not used in SIM
buyer number4 0 1 Contains the number associated with the buyer for the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
buyer_name varchar2120 0 1 Contains the name of the authorized buyer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
supplier varchar210 1 1 Contains the vendor number who will provide the merchandise specified in the order. PURCHASE_ORDER SUPPLIER_ID VARCHAR2 128 Yes The supplier ID of the order or where the inventory will be coming from.
promotion number10 0 1 Contains the ad number associated with the order to provide a link between the order dialog and the promotions dialog. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
prom_desc varchar2160 0 1 Contains a description of the promotion. This value comes from RPM. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
qc_ind varchar21 1 1 Determines whether or not quality control will be required when items for this order are received. Valid values are 'Y' and 'N'. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
not_before_date xs:dateTime 0 1 Contains the first date that delivery of the order will be accepted. RK_ORDERS NOT_BEFORE_DATE Date Fill column length. No The date before which the items on the purchase order can not be delivered by the supplier.
not_after_date xs:dateTime 0 1 Contains the last date that delivery of the order will be accepted. PURCHASE_ORDER NOT_AFTER_DATE Date Fill column length. No latest date that the inventory would arrive at the store for the order.
otb_eow_date xs:dateTime 0 1 This field contains the OTB budget bucket the order amount should be placed into. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
earliest_ship_date xs:dateTime 0 1 The date before which the items on the purchase order can not be shipped by the supplier. Represents the earliest earliest ship date of all the items on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
latest_ship_date xs:dateTime 0 1 The date after which the items on the purchase order can not be shipped by the supplier. Represents the greatest latest ship date of all the items on the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
close_date xs:dateTime 0 1 Contains the date when the order is closed. PURCHASE_ORDER COMPLETE_DATE DATE Fill column length. No the date of when all items were received on the order.
terms varchar215 1 1 Indicator identifying the sales terms for the order. These terms specify when payment is due and if any discounts exist for early payment. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
terms_code varchar250 1 1 Indicates the Alphanumeric representation of Term Name which acts as the Term code in Oracle Financials. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
freight_terms varchar230 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
cust_order varchar21 1 1 This field indicates whether or not the order is generated for a customer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Not used in SIM
payment_method varchar26 0 1 Indicates how the purchase order will be paid. Valid options are LC (Letter of Credit), WT (Wire Transfer), OA (Open Account). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
payment_method_desc varchar2250 0 1 Indicates how the purchase order will be paid. Valid options are 'LC' - Letter of Credit, 'WT' - Wire Transfer, 'OA' - Open Account. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
backhaul_type varchar26 0 1 This field contains the type of backhaul allowance that will be applied to the order. Some examples are 'C'alculated or 'F'lat rate Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
backhaul_type_desc varchar2250 0 1 The description of the backhaul type. Not used in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
backhaul_allowance number20_4 0 1 This field contains the backhaul allowance value. Not used in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
ship_method varchar26 0 1 The method used to ship the items on the purchase order from the country of origin to the country of import. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
ship_method_desc varchar2250 0 1 Contains the description for the shipping method. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
purchase_type varchar26 0 1 Indicates what's included in the supplier's cost of the item. Valid values include C (Cost), CI (Cost and Insurance), CIF (Cost, Insurance and Freight), FOB (Free on Board). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
purchase_type_desc varchar2250 0 1 Contains the description for the purchase type. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
status varchar21 1 1 Indicates the current status of the order. Valid values include 'W' - Worksheet, 'S' - Submitted, 'A' - Approved, 'C' - Closed PURCHASE_ORDER STATUS NUMBER 4 Yes the status of the purchase order.valid values 0 = unknown 100 = approved 1000 = closed.
ship_pay_method varchar22 0 1 Code indicating the payment terms for freight charges associated with the order. Valid values inlude: 'CC' - Collect, 'CF' - Collect Freight Credited Back to Customer, 'DF' - Defined by Buyer and Seller, 'MX' - Mixed, 'PC' - Prepaid but Charged to Customer, 'PO' - Prepaid Only, 'PP' - Prepaid by Seller. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
ship_pay_method_desc varchar2250 0 1 Contains the description of the given shipment payment method. Not used in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
fob_trans_res varchar22 0 1 Contains the code indicating the type of the location that is responsible for the transportation of the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
fob_trans_res_code_desc varchar2250 0 1 Not used in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
fob_trans_res_desc varchar2250 0 1 User entered field describing the code for the location responsible for the transportation of the order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
fob_title_pass varchar22 0 1 Indicator used to determine where the title for goods is passed from the vendor to the purchaser. Examples include city, factory, or origin. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
fob_title_pass_code_desc varchar2250 0 1 Contains the description for fob_title_pass_code. Not used in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
fob_title_pass_desc varchar2250 0 1 User entered field describing the code where the title of the merchandise is to be passed. Could be a city name, factory name, or place of origin. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
vendor_order_no varchar215 0 1 Contains the vendor's unique identifying number for an order. These orders may have originated by the vendor through the EDI process or this number can be associated to a Retek order when the order is created on-line. PURCHASE_ORDER EXTERNAL_ID RIB or/and RSB or/and RSL VARCHAR2(128 BYTE) Yes Fill this description.
exchange_rate number20_10 0 1 The rate of exchange used for the purchase order between the order and primary currencies. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
factory varchar210 0 1 The factory at which the items on the purchase order are made. This field is only available when the system is running Import functionality. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
factory_desc varchar2240 0 1 Contains the description of the factory. Not used in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
agent varchar210 0 1 The agent that is used in the purchase of the items on the purchase order. This field is only available when the system is running Import functionality. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
agent_desc varchar2240 0 1 Not used in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
discharge_port varchar25 0 1 The port at which the items on the purchase order will enter the country of import. This field is only available when the system is running Import functionality. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
discharge_port_desc varchar2150 0 1 Contains the description of the discharge port. Not used in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Not used in SIM
lading_port varchar25 0 1 The port from which the items on the purchase order are shipped. This field is only available when the system is running Import functionality. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
lading_port_desc varchar2150 0 1 Contains the description of the lading port. Not used in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
bill_to_id varchar25 0 1 Indicates the ID of the bill-to-address, which will be stored on the OUTLOC table under the outloc_type 'BT'. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
freight_contract_no varchar210 0 1 The number of the contract with a shipper that will give specific freight rates. This field is only available when the system is running Import functionality. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
po_type varchar24 0 1 Contains the value associated with the PO_TYPE for the order. Not used in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
po_type_desc varchar2120 0 1 Contains a description for the specific PO_TYPE. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
pre_mark_ind varchar21 1 1 This field indicated whether or not a supplier has agreed to break an order into separate boxes so that the boxes can be sent directly to stores. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
currency_code varchar23 1 1 Contains the currency code for the order. When creating an order within Retek, this field will always default to the currency of the supplier, but it can be overwritten. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes This is used to calculated Unit Cost for the Item.
contract_no number6 0 1 Contains the contract number associated with this order. Not used in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
pickup_loc varchar2250 0 1 Contains the location at which the order will be picked up, if the order is a 'Pickup' order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
pickup_no varchar225 0 1 Contains the reference number for the Pickup order. Not used in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
pickup_date xs:dateTime 0 1 Contains the date when the order can be picked up from the Supplier. This field is only required if the Purchase Type of the order is 'Pickup'. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
app_datetime xs:dateTime 0 1 This column will hold the date and time of the receiving appointment at the warehouse. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
comment_desc varchar22000 0 1 Miscellaneous comments attached to the purchase order. PURCHASE_ORDER COMMENTS VARCHAR2 2000 No description and/or comments associated with the purchase order as defined by the user.
cust_order_nbr varchar248 0 1 This field holds the master customer order number from OMS. PURCHASE_ORDER CUST_ORDER_ID VARCHAR2 128 No Customer order external identifier
fulfill_order_nbr varchar248 0 1 This field holds the number from OMS related to the fulfillment details. One or more fulfillment orders could relate back to a single customer order in OMS. PURCHASE_ORDER FUL_ORD_EXTERNAL_ID VARCHAR2 128 No Fulfillment order external identifier
PODtl * 0 unbounded Description is not available.

XML-Schema Name:PODtl Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PODtl in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
item varchar225 1 1 Description is not available. SUPPLIER_ITEM_COUNTRY ITEM_ID VARCHAR2 25 Yes the unique identifier for the item.
ref_item varchar225 0 1 Unique alphanumeric value to identify the reference item. Not used in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
physical_location_type varchar21 1 1 This field contains the type of location in the location field. Valid values are 'S' -Store, 'W' -Warehouse Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
physical_location number10 1 1 This field contains the actual physical location that item will be ordered to. This field may contain a store or a physical warehouse. PURCHASE_ORDER STORE_ID NUMBER 10 Yes the unique identifier of the location for which the inventory will be delivered to for the order.
physical_store_type varchar21 0 1 Indicates the store type of the physical_location store. Only populated if physical_location_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes possible values STORE_TYPE_COMPANY("C"), STORE_TYPE_FRANCHISE("F"),
physical_stockholding_ind varchar21 0 1 Indicates if the physical_location store is stock-holding or not. Only populated if physical_location_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes possible values are "Y" or "N"
physical_qty_ordered number12_4 0 1 Description is not available. PURCHASE_ORDER_LINE_ITEM QUANTITY_EXPECTED NUMBER 20,4 No the number of single units expected to be delivered to the store.
transaction_uom varchar24 0 1 Holds the original transaction unit of measure to be passed on to the store system. It is only used for customer direct orders coming from the order management system. All quantities on the payload are expressed in item.s standard unit of measure. PURCHASE_ORDER_LINE_ITEM PREFERRED_UOM VARCHAR2 4 No Preferred unit of measure of the line item.
unit_cost number20_4 0 1 This field contains the unit cost for the Item/Location on the order, including discounts (deal/bracket/allowance), but not landed cost components. This field is stored in order currency. RK_ORDER_ITM UNIT_COST VARCHAR2 75 No This field contains the unit cost for the Item/Location on the order, including discounts (deal/bracket/allowance), but not landed cost components. This field is stored in order currency.
origin_country_id varchar23 0 1 The identifier of the country into which the items on the order are being imported. SUPPLIER_ITEM_COUNTRY COUNTRY_ID VARCHAR2 3 Yes the unique code of the country for the supplier that produces the item.
supp_pack_size number12_4 0 1 Supplier pack size for this order/item. Description is not available. PURCHASE_ORDER_LINE_ITEM CASE_SIZE NUMBER 10,2 No the size of the pack coming from the supplier.
earliest_ship_date xs:dateTime 0 1 The date before which the item can not be shipped by the supplier. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
latest_ship_date xs:dateTime 0 1 The date after which the item can not be shipped by the supplier. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
pickup_loc varchar2250 0 1 Contains the location at which the order will be picked up, if the order is a 'Pickup' order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
pickup_no varchar225 0 1 Not used in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
packing_method varchar26 0 1 This field indicates whether the packing method of the item in the container is flat or hanging. Valid values for this field are stored in the 'PKMT' code. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
round_lvl varchar26 0 1 This column will be used to determine how order quantities will be rounded to Case, Layer and Pallet. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
door_ind varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
priority_level number1 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
new_item varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
quarantine varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
rcvd_unit_qty number12_4 0 1 Not used by RMS. PURCHASE_ORDER_LINE_ITEM QUANTITY_RECEIVED NUMBER 20,4 No the number of single units received by sim to the current date.
tsf_po_link_id number12 0 1 A reference number to link the item on the transfer to any purchase orders that have been created to allow the from location (ie warehouse) on the transfer to fulfill the transfer quantity to the to location (ie store) on the transfer. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
POVirtualDtl * 0 unbounded Description is not available.
cost_source varchar24 0 1 Indicates the basis for the cost of the Item/Location on the order. Valid values include 'NORM' - Normal Supplier Cost, 'DEAL' - Cost Based on a Deal, 'BRKT' - Cost Based on a Bracket, 'MANL' - User Specified or Manual Override Cost, 'CONT' - Costs retrieved from the Contract, 'ALLW' - Cost Based on an Allowance Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
est_in_stock_date xs:dateTime 0 1 Date that the item on the PO is expected to be available to ship from the PO location to another location. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.

XML-Schema Name:POVirtualDtl Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for POVirtualDtl in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
location_type varchar21 1 1 This field contains the type of location in the location field. Valid values are S - Physical Store, V - Virtual Store, W Warehouse Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.
location number10 1 1 This field contains the location all items on the order will be delivered to if populated. (i.e. it will mean a single location order) Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
qty_ordered number12_4 0 1 Contains the total number of items ordered for the SKU to this location. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM.