Retail Integration Bus Mappings Report Release:13.2.0 (Retail Merchandizing System)
Application Retail Merchandizing System
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.

XML-Schema Name:PODesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For PODesc
Table Name Column Name API Type Column Length API Required API Description
doc_type varchar21 1 1 Indicates the type of document this message is for. Valid value is 'P' for purchase order. n/a n/a null null Yes Indicates the type of document this message is for. Valid value is P for purchase order.
order_no varchar210 1 1 Description is not available. ordhead order_no varchar2 10 Yes Contains the number to uniquely identify an order within the system.
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. ordhead order_type varchar2 Yes Indicates the type of order and the Open To Buy bucket that will be updated. Valid values include N/B (non basic), ARB (automatic reorder of basic), and BRB (buyer reorder of basic).
order_type_desc varchar2250 1 1 Not used in RWMS. order_types order_types_desc null null Yes The description for the order type.
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. ordhead dept number 4 No Contains the department number for orders limited to a single department and is null for orders including items in more than one department.
dept_name varchar2120 0 1 Not used in RWMS. deps dept_name varchar2 120 No Contains the name of the department.
buyer number4 0 1 Description is not available. ordhead buyer number 4 No Contains the number associated with the buyer for the order.
buyer_name varchar2120 0 1 Description is not available. buyer buyer_name varchar2 120 No Contains the name of the authorized buyer.
supplier varchar210 1 1 Contains the vendor number who will provide the merchandise specified in the order. ordhead supplier varchar2 10 Yes Contains the number for the vendor who will provide the merchandise specified in the order.
promotion number10 0 1 Contains the ad number associated with the order to provide a link between the order dialog and the promotions dialog. ordhead promotion number 10 No Contains the ad number associated with the order to provide a link between the order dialog and the promotions dialog.
prom_desc varchar2160 0 1 Contains a description of the promotion. This value comes from RPM. rpm_promo description null null Yes Contains a description of the promotion. This value comes from RPM.
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'. ordhead qc_ind varchar2 1 Yes Determines whether quality control is required when items for this order are received. Valid values are Y and N.
not_before_date xs:dateTime 0 1 Description is not available. ordhead not_before_date RIBDate * No Contains the first date that delivery of the order will be accepted.
not_after_date xs:dateTime 0 1 Description is not available. ordhead not_after_date RIBDate * No Contains the last date that delivery of the order will be accepted.
otb_eow_date xs:dateTime 0 1 This field contains the OTB budget bucket the order amount should be placed into. ordhead otb_eow_date RIBDate * No This field contains the OTB budget bucket into which the order amount should be placed.
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. ordhead earliest_ship_date RIBDate * No Represents the earliest earliest ship date of all the items on the order.
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. ordhead latest_ship_date RIBDate * No The date after which the items on the purchase order cannot be shipped by the supplier. Represents the latest ship date of all the items on the order.
close_date xs:dateTime 0 1 Not used in RWMS. ordhead close_date RIBDate * No Contains the date when the order is closed.
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. ordhead terms varchar2 15 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 varchar250 1 1 Indicates the Alphanumeric representation of Term Name which acts as the Term code in Oracle Financials. terms terms_code varchar2 50 Yes The alphanumeric representation of Term Name, which acts as the Term Code in Oracle financials applications.
freight_terms varchar230 0 1 Description is not available. ordhead freight_terms varchar2 30 No Indicator that references the freight terms related to the order.
cust_order varchar21 1 1 This field indicates whether or not the order is generated for a customer. ordhead cust_order varchar2 1 Yes This field indicates whether the order is generated for a customer.
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). ordhead payment_method varchar2 6 No Indicates how the purchase order will be paid. Valid options are LC (letter of credit), WT (wire transfer), and OA (Open Account).
payment_method_desc varchar240 0 1 Indicates how the purchase order will be paid. Valid options are 'LC' - Letter of Credit, 'WT' - Wire Transfer, 'OA' - Open Account. ordhead payment_method_desc varchar2 40 No Indicates how the purchase order will be paid. Valid options are LC (letter of credit), WT (wire transfer), and OA (open account).
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 ordhead backhaul_type varchar2 6 No This field contains the type of backhaul allowance applied to the order, for example, C (calculated) or F (flat) rate.
backhaul_type_desc varchar240 0 1 Not used in RWMS. code_detail code_desc varchar2 40 No The description of the backhaul type.
backhaul_allowance number20_4 0 1 Not used in RWMS. ordhead backhaul_allowance number 20 No This field contains the backhaul allowance value.
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. ordhead ship_method varchar2 6 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 varchar240 0 1 Description is not available. code_detail code_desc varchar2 40 No Contains the description for the shipping method.
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). ordhead purchase_type varchar2 6 No Indicates what is included in the supplier's cost of the item. Valid values include C (cost), CI (cost and insurance), CIF (cost, insurance, and freight), and FOB (free on board).
purchase_type_desc varchar240 0 1 Description is not available. code_detail code_desc varchar2 40 No Contains the description for the purchase type.
status varchar21 1 1 Indicates the current status of the order. Valid values include 'W' - Worksheet, 'S' - Submitted, 'A' - Approved, 'C' - Closed ordhead status null null Yes Indicates the current status of the order. Valid values are W (worksheet), S (submitted), A (approved), and C (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. ordhead ship_pay_method null No Code indicating the payment terms for freight charges associated with the order. Valid values include 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), and PP (prepaid by seller).
ship_pay_method_desc varchar240 0 1 Not used in RWMS. code_detail code_desc null null No Contains the description of the given shipment payment method.
fob_trans_res varchar22 0 1 Contains the code indicating the type of the location that is responsible for the transportation of the order. ordhead fob_trans_desc varchar2 2 No Contains the code indicating the type of the location responsible for the transportation of the order.
fob_trans_res_code_desc varchar240 0 1 Not used in RWMS. code_detail code_desc varchar2 40 No Contains the description for fob_trans_res_code.
fob_trans_res_desc varchar2250 0 1 User entered field describing the code for the location responsible for the transportation of the order. ordhead fob_trans_res_desc varchar2 250 No User entered field describing the code for the location responsible for the transportation of the order.
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. ordhead fob_title_pass varchar2 2 No Indicator used to determine where the title for goods is passed from the vendor to the purchaser. Examples are city, factory, and origin.
fob_title_pass_code_desc varchar240 0 1 Not used in RWMS. code_detail code_desc varchar2 40 No Contains the description for fob_title_pass_code.
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. ordhead fob_title_pass_desc varchar2 250 No User entered field describing the code where the title of the merchandise is to be passed. This could be a city name, factory name, or place of origin.
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. ordhead vendor_order_no varchar2 15 No Contains the vendor's unique number to identify the order. The vendor may have originated the order through the EDI process, or this number can be associated to an Oracle Retail order when the order is created online.
exchange_rate number20_10 0 1 The rate of exchange used for the purchase order between the order and primary currencies. ordhead exchange_rate number 20 No The rate of exchange used for the purchase order between the order and primary currencies.
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. ordhead factory varchar2 10 No The factory at which the items on the purchase order are made. This field is available only when the system is running Import functionality.
factory_desc varchar2240 0 1 Not used in RWMS. partner partner_desc varchar2 240 No Contains the description of the factory.
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. ordhead agent varchar2 10 No The agent that is used in the purchase of the items on the purchase order. This field is available only when the system is running Import functionality.
agent_desc varchar2240 0 1 Not used in RWMS. partner partner_desc varchar2 240 No Contains the description of the partner.
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. ordhead discharge_port varchar2 5 No The port at which the items on the purchase order will enter the country of import. This field is available only when the system is running Import functionality.
discharge_port_desc varchar2150 0 1 Not used in RWMS. outloc outloc_desc varchar2 150 No Contains the description of the discharge port.
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. ordhead lading_port varchar2 5 No The port from which the items on the purchase order are shipped. This field is available only when the system is running Import functionality.
lading_port_desc varchar2150 0 1 Not used in RWMS. outloc outloc_desc varchar2 150 No Contains the description of the lading port.
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'. ordhead bill_to_id varchar2 5 No Indicates the ID of the bill-to-address, which is stored in the OUTLOC table under the outloc_type BT.
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. ordhead freight_contract_no varchar2 10 No The number of the contract with a shipper that will give specific freight rates. This field is available only when the system is running Import functionality.
po_type varchar24 0 1 Not used in RWMS. ordhead po_type varchar2 4 No Contains the value associated with the PO_TYPE for the order.
po_type_desc varchar2120 0 1 Description is not available. po_type po_type_desc varchar2 120 No Contains a description for the specific PO_TYPE.
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. ordhead pre_mark_ind varchar2 1 Yes This field indicates whether a supplier has agreed to break an order into separate boxes so that the boxes can be sent directly to stores.
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. ordhead currency_code varchar2 3 Yes Contains the currency code for the order. When creating an order, this field always defaults to the currency of the supplier, but it can be overwritten.
contract_no number6 0 1 Not used in RWMS. ordhead contract_no null null No Contains the contract number associated with this order.
pickup_loc varchar2250 0 1 Contains the location at which the order will be picked up, if the order is a 'Pickup' order. ordhead pickup_loc varchar2 250 No Contains the location at which the order will be picked up, if the order is a Pickup order.
pickup_no varchar225 0 1 Not used in RWMS. ordhead pickup_no varchar2 25 No Contains the reference number for the Pickup order.
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'. ordhead pickup_date RIBDate * No Contains the date when the order can be picked up from the supplier. This field is required only if the purchase type of the order is Pickup.
app_datetime xs:dateTime 0 1 This column will hold the date and time of the receiving appointment at the warehouse. ordhead app_datetime RIBDate * No This column contains the date and time of the receiving appointment at the warehouse.
comment_desc varchar22000 0 1 Description is not available. ordhead comment_desc varchar2 2000 No Miscellaneous comments attached to the purchase order.
PODtl * 0 unbounded Description is not available.
ExtOfPODesc:ExtOfPODesc * 0 1 Provide an extension hook to customize PODesc. NA NA NA NA NA NA
LocOfPODesc:LocOfPODesc * 0 1 Provide an extension hook to localize PODesc. NA NA NA NA NA NA

XML-Schema Name:PODtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For PODtl
Table Name Column Name API Type Column Length API Required API Description
item varchar225 1 1 Description is not available. ordloc item varchar2 25 Yes Unique alphanumeric value to identify the item.
ref_item varchar225 0 1 Not used in RWMS. ordsku ref_item varchar2 25 No Unique alphanumeric value to identify the reference item.
physical_location_type varchar21 1 1 This field contains the type of location in the location field. Valid values are 'S' -Store, 'W' -Warehouse ordloc loc_type varchar2 1 Yes This field contains the type of location in the location field. Valid values are S (store) and W (warehouse).
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. ordloc location null null Yes This field contains the actual physical location to which the item will be ordered. This field may indicate a store or a physical warehouse.
physical_qty_ordered number12_4 0 1 Description is not available. ordloc qty_ordered number 12 No Contains the total number of items ordered for the SKU to this location.
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. ordloc unit_cost number 20 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. ordsku country_code varchar2 3 No The identifier of the country into which the items on the order are being imported.
supp_pack_size number12_4 0 1 Description is not available. ordsku order_casepack number 12 No Supplier pack size for this order/item.
earliest_ship_date xs:dateTime 0 1 The date before which the item can not be shipped by the supplier. ordsku earliest_ship_date RIBDate * No The earliest date on which the the item can be shipped by the supplier.
latest_ship_date xs:dateTime 0 1 The date after which the item can not be shipped by the supplier. ordsku latest_ship_date RIBDate * No The latest date the item can be shipped by the supplier.
pickup_loc varchar2250 0 1 Contains the location at which the order will be picked up, if the order is a 'Pickup' order. ordsku pickup_loc varchar2 250 No Contains the location at which the order will be picked up, if the order is a Pickup order.
pickup_no varchar225 0 1 Not used in RWMS. ordsku pickup_no varchar2 25 No Contains the reference number for the Pickup order.
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. item_supp_country packing_method varchar2 6 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 varchar26 0 1 This column will be used to determine how order quantities will be rounded to Case, Layer and Pallet. item_supp_country round_lvl varchar2 6 No This column is used to determine how order quantities are rounded to case, layer, and pallet.
door_ind varchar21 0 1 Description is not available. N/A N/A null null No Not used by RMS.
priority_level number1 0 1 Description is not available. n/a n/a null null No Not used by RMS.
new_item varchar21 0 1 Description is not available. n/a n/a null null No Not used by RMS.
quarantine varchar21 0 1 Description is not available. n/a n/a null null No Not used by RMS.
rcvd_unit_qty number12_4 0 1 Description is not available. n/a n/a null null No Not used by RMS.
tsf_po_link_id number10 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. ordloc tsf_po_link_no number 10 No A reference number to link the item on the transfer to any purchase orders that have been created. Linking allows the From location (such as warehouse) on the transfer to fulfill the transfer quantity to the To location (such as store) on the transfer.
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 ordloc cost_source null null No Indicates the basis for the cost of the Item/Location on the order. Valid values are 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), and ALLW (cost based on an allowance).
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. ordloc est_in_stock_date null null No Date on which the item on the PO is expected to be available to ship from the PO location to another location.
ExtOfPODesc:ExtOfPODtl * 0 1 Provide an extension hook to customize PODtl. NA NA NA NA NA NA
LocOfPODesc:LocOfPODtl * 0 1 Provide an extension hook to localize PODtl. NA NA NA NA NA NA

XML-Schema Name:POVirtualDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For POVirtualDtl
Table Name Column Name API Type Column Length API Required API Description
location_type varchar21 1 1 This field contains the type of location in the location field. Valid values are S - Store, W - Warehouse ordloc loc_type null null Yes This field contains the type of location in the location field. Valid values are S (store) and W (warehouse)
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) ordloc location null null Yes If populated, this field contains the location to which all items on the order will be delivered (indicating a single location order).
qty_ordered number12_4 0 1 Contains the total number of items ordered for the SKU to this location. ordloc qty_ordered number 12 No Contains the total number of items ordered for the SKU to this location.
ExtOfPODesc:ExtOfPOVirtualDtl * 0 1 Provide an extension hook to customize POVirtualDtl. NA NA NA NA NA NA
LocOfPODesc:LocOfPOVirtualDtl * 0 1 Provide an extension hook to localize POVirtualDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfPOVirtualDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfPOVirtualDtl
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfPOVirtualDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfPOVirtualDtl
Table Name Column Name API Type Column Length API Required API Description
InPODesc:InPOVirtualDtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrPODesc:BrPOVirtualDtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfPODtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfPODtl
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfPODtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfPODtl
Table Name Column Name API Type Column Length API Required API Description
InPODesc:InPODtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrPODesc:BrPODtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfPODesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfPODesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfPODesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfPODesc
Table Name Column Name API Type Column Length API Required API Description
InPODesc:InPODesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrPODesc:BrPODesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA