Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Retail Merchandising System
Version 13.0.1
XML-Schema or Node Name:PODesc.xsd
Tag Name Table Name Column Name API Req Description
doc_type n/a n/a Yes Indicates the type of document this message is for. Valid value is 'P' for purchase order.
order_no ordhead order_no Yes Contains the number that uniquely identifies an order within the system.
order_type ordhead order_type 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 order_types order_types_desc Yes The description for the given order type.
dept ordhead dept No Contains the department number for orders limited to a single department and will be Null for orders involving items in more than one department.
dept_name deps dept_name No Contains the name of the department.
buyer ordhead buyer No Contains the number associated with the buyer for the order.
buyer_name buyer buyer_name No Contains the name of the authorized buyer.
supplier ordhead supplier Yes Contains the vendor number who will provide the merchandise specified in the order.
promotion ordhead promotion No Contains the ad number associated with the order to provide a link between the order dialog and the promotions dialog.
prom_desc rpm_promo description Yes Contains a description of the promotion. This value comes from RPM.
qc_ind ordhead qc_ind Yes Determines whether or not quality control will be required when items for this order are received. Valid values are 'Y' and 'N'.
not_before_date ordhead not_before_date No Contains the first date that delivery of the order will be accepted.
not_after_date ordhead not_after_date No Contains the last date that delivery of the order will be accepted.
otb_eow_date ordhead otb_eow_date No This field contains the OTB budget bucket the order amount should be placed into.
earliest_ship_date ordhead earliest_ship_date No 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.
latest_ship_date ordhead latest_ship_date No 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.
close_date ordhead close_date No Contains the date when the order is closed.
terms ordhead terms Yes Indicator identifying the sales terms for the order. These terms specify when payment is due and if any discounts exist for early payment.
terms_code terms terms_code Yes Indicates the Alphanumeric representation of Term Name which acts as the Term code in Oracle Financials.
freight_terms ordhead freight_terms No Indicator that references what freight terms are related to the order.
cust_order ordhead cust_order Yes This field indicates whether or not the order is generated for a customer.
payment_method ordhead payment_method No Indicates how the purchase order will be paid. Valid options are LC (Letter of Credit), WT (Wire Transfer), OA (Open Account).
payment_method_desc ordhead payment_method_desc No Indicates how the purchase order will be paid. Valid options are 'LC' - Letter of Credit, 'WT' - Wire Transfer, 'OA' - Open Account.
backhaul_type ordhead backhaul_type No This field contains the type of backhaul allowance that will be applied to the order. Some examples are 'C'alculated or 'F'lat rate
backhaul_type_desc code_detail code_desc No The description for the given backhaul type.
backhaul_allowance ordhead backhaul_allowance No This field will contain the backhaul allowance value.
ship_method ordhead ship_method No The method used to ship the items on the purchase order from the country of origin to the country of import.
ship_method_desc code_detail code_desc No Contains the description of the given shipping method.
purchase_type ordhead purchase_type No 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).
purchase_type_desc code_detail code_desc No Contains the description of the given purchase type.
status ordhead status Yes Indicates the current status of the order. Valid values include 'W' - Worksheet, 'S' - Submitted, 'A' - Approved, 'C' - Closed
ship_pay_method ordhead ship_pay_method No 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.
ship_pay_method_desc code_detail code_desc No Contains the description of the given shipment payment method.
fob_trans_res ordhead fob_trans_desc No Contains the code indicating the type of the location that is responsible for the transportation of the order.
fob_trans_res_code_desc code_detail code_desc No Contains the description of the given fob_trans_res_code
fob_trans_res_desc ordhead fob_trans_res_desc No User entered field describing the code for the location responsible for the transportation of the order.
fob_title_pass ordhead fob_title_pass No Indicator used to determine where the title for goods is passed from the vendor to the purchaser. Examples include city, factory, or origin.
fob_title_pass_code_desc code_detail code_desc No Contains the description of the given fob_title_pass_code.
fob_title_pass_desc ordhead fob_title_pass_desc No 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.
vendor_order_no ordhead vendor_order_no No 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.
exchange_rate ordhead exchange_rate No The rate of exchange used for the purchase order between the order and primary currencies.
factory ordhead factory No The factory at which the items on the purchase order are made. This field is only available when the system is running Import functionality.
factory_desc partner partner_desc No Contains the description of the given factory.
agent ordhead agent No 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.
agent_desc partner partner_desc No Contains the description of the given partner
discharge_port ordhead discharge_port No 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.
discharge_port_desc outloc outloc_desc No Contains the description of the given discharge port.
lading_port ordhead lading_port No The port from which the items on the purchase order are shipped. This field is only available when the system is running Import functionality.
lading_port_desc outloc outloc_desc No Contains the description of the given lading port.
bill_to_id ordhead bill_to_id No Indicates the ID of the bill-to-address, which will be stored on the OUTLOC table under the outloc_type 'BT'.
freight_contract_no ordhead freight_contract_no No 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.
po_type ordhead po_type No Contains the value associated with the PO_TYPE for the order.
po_type_desc po_type po_type_desc No Contains a description for the specific PO_TYPE
pre_mark_ind ordhead pre_mark_ind Yes 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.
currency_code ordhead currency_code Yes 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.
contract_no ordhead contract_no No Contains the contract number associated with this order.
pickup_loc ordhead pickup_loc No Contains the location at which the order will be picked up, if the order is a 'Pickup' order.
pickup_no ordhead pickup_no No Contains the reference number of the 'Pickup' order.
pickup_date ordhead pickup_date No 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'.
app_datetime ordhead app_datetime No This column will hold the date and time of the receiving appointment at the warehouse.
comment_desc ordhead comment_desc No Any miscellaneous comments attached to the purchase order.
PODtl * * * *

Application Name: Retail Merchandising System
Version 13.0.1
XML-Schema or Node Name:PODtl
Tag Name Table Name Column Name API Req Description
item ordloc item Yes Unique alphanumeric value that identifies the item.
ref_item ordsku ref_item No Unique alphanumeric value that identifies the reference item.
physical_location_type ordloc loc_type Yes This field contains the type of location in the location field. Valid values are 'S' -Store, 'W' -Warehouse
physical_location ordloc location Yes This field contains the actual physical location that item will be ordered to. This field may contain a store or a physical warehouse.
physical_qty_ordered ordloc qty_ordered No Contains the total number of items ordered for the SKU to this location.
unit_cost ordloc unit_cost 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 ordsku country_code No The identifier of the country into which the items on the order are being imported.
supp_pack_size ordsku order_casepack No Supplier pack size for this order/item.
earliest_ship_date ordsku earliest_ship_date No The date before which the item can not be shipped by the supplier.
latest_ship_date ordsku latest_ship_date No The date after which the item can not be shipped by the supplier.
pickup_loc ordsku pickup_loc No Contains the location at which the order will be picked up, if the order is a 'Pickup' order.
pickup_no ordsku pickup_no No Contains the reference number of the 'Pickup' order.
packing_method item_supp_country packing_method No 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.
round_lvl item_supp_country round_lvl No This column will be used to determine how order quantities will be rounded to Case, Layer and Pallet.
door_ind n/a n/a No Not used by RMS.
priority_level n/a n/a No Not used by RMS.
new_item n/a n/a No Not used by RMS.
quarantine n/a n/a No Not used by RMS.
rcvd_unit_qty n/a n/a No Not used by RMS.
tsf_po_link_id ordloc tsf_po_link_no No 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.
POVirtualDtl * * * *
cost_source ordloc cost_source No 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
est_in_stock_date ordloc est_in_stock_date No Date that the item on the PO is expected to be available to ship from the PO location to another location.

Application Name: Retail Merchandising System
Version 13.0.1
XML-Schema or Node Name:POVirtualDtl
Tag Name Table Name Column Name API Req Description
location_type ordloc loc_type Yes This field contains the type of location in the location field. Valid values are S - Store, W - Warehouse
location ordloc location Yes 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)
qty_ordered ordloc qty_ordered No Contains the total number of items ordered for the SKU to this location.