Retail Integration Bus Mappings Report Release:13.1.1 (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.

XML-Schema Name:PODesc Version:13.1.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim 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. RK_ORDERS TBD VARCHAR2 * No Not Yet Available
order_no varchar210 1 1 Description is not available. RK_ORDERS ORDER_ID VARCHAR2 128 No Not Yet Available
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. NA NA NA NA NA NA
order_type_desc varchar2250 1 1 Not used in RWMS. null null null null null
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. null number 4 null null
dept_name varchar2120 0 1 Not used in RWMS. null varchar2 120 null null
buyer number4 0 1 Description is not available. null number 4 null null
buyer_name varchar2120 0 1 Description is not available. null varchar2 120 null null
supplier varchar210 1 1 Contains the vendor number who will provide the merchandise specified in the order. RK_ORDERS SOURCE_ID VARCHAR2 128 Yes Not Yet Available
promotion number10 0 1 Contains the ad number associated with the order to provide a link between the order dialog and the promotions dialog. null number 10 null null
prom_desc varchar2160 0 1 Contains a description of the promotion. This value comes from RPM. null null null null null
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'. null varchar2 1 null null
not_before_date xs:dateTime 0 1 Description is not available. RK_ORDERS NOT_BEFORE_DATE RIBDate * No Not Yet Available
not_after_date xs:dateTime 0 1 Description is not available. RK_ORDERS NOT_AFTER_DATE RIBDate * No Not Yet Available
otb_eow_date xs:dateTime 0 1 This field contains the OTB budget bucket the order amount should be placed into. null RIBDate * null null
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. null RIBDate * null null
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. null RIBDate * null null
close_date xs:dateTime 0 1 Not used in RWMS. null RIBDate * null null
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. null varchar2 15 null null
terms_code varchar250 1 1 Indicates the Alphanumeric representation of Term Name which acts as the Term code in Oracle Financials. null varchar2 50 null null
freight_terms varchar230 0 1 Description is not available. null varchar2 30 null null
cust_order varchar21 1 1 This field indicates whether or not the order is generated for a customer. null varchar2 1 null null
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). null varchar2 6 null null
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. null varchar2 40 null null
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 null varchar2 6 null null
backhaul_type_desc varchar240 0 1 Not used in RWMS. null varchar2 40 null null
backhaul_allowance number20_4 0 1 Not used in RWMS. null number 20 null null
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. null varchar2 6 null null
ship_method_desc varchar240 0 1 Description is not available. null varchar2 40 null null
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). null varchar2 6 null null
purchase_type_desc varchar240 0 1 Description is not available. null varchar2 40 null null
status varchar21 1 1 Indicates the current status of the order. Valid values include 'W' - Worksheet, 'S' - Submitted, 'A' - Approved, 'C' - Closed RK_ORDERS STATUS VARCHAR2 4 No Not Yet Available
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. null null null null null
ship_pay_method_desc varchar240 0 1 Not used in RWMS. null null null null null
fob_trans_res varchar22 0 1 Contains the code indicating the type of the location that is responsible for the transportation of the order. null varchar2 2 null null
fob_trans_res_code_desc varchar240 0 1 Not used in RWMS. null varchar2 40 null null
fob_trans_res_desc varchar2250 0 1 User entered field describing the code for the location responsible for the transportation of the order. null varchar2 250 null null
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. null varchar2 2 null null
fob_title_pass_code_desc varchar240 0 1 Not used in RWMS. null varchar2 40 null null
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. null varchar2 250 null null
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. NA NA NA NA NA NA
exchange_rate number20_10 0 1 The rate of exchange used for the purchase order between the order and primary currencies. null number 20 null null
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. null varchar2 10 null null
factory_desc varchar2240 0 1 Not used in RWMS. null varchar2 240 null null
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. null varchar2 10 null null
agent_desc varchar2240 0 1 Not used in RWMS. null varchar2 240 null null
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. null varchar2 5 null null
discharge_port_desc varchar2150 0 1 Not used in RWMS. null varchar2 150 null null
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. null varchar2 5 null null
lading_port_desc varchar2150 0 1 Not used in RWMS. null varchar2 150 null null
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'. null varchar2 5 null null
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. null varchar2 10 null null
po_type varchar24 0 1 Not used in RWMS. null varchar2 4 null null
po_type_desc varchar2120 0 1 Description is not available. null varchar2 120 null null
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. null varchar2 1 null null
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. null varchar2 3 null null
contract_no number6 0 1 Not used in RWMS. null null null null null
pickup_loc varchar2250 0 1 Contains the location at which the order will be picked up, if the order is a 'Pickup' order. null varchar2 250 null null
pickup_no varchar225 0 1 Not used in RWMS. null varchar2 25 null null
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'. null RIBDate * null null
app_datetime xs:dateTime 0 1 This column will hold the date and time of the receiving appointment at the warehouse. null RIBDate * null null
comment_desc varchar22000 0 1 Description is not available. RK_ORDERS COMMENT_DESC VARCHAR2 300 No Not Yet Available
PODtl * 0 unbounded Description is not available.
ExtOfPODesc:ExtOfPODesc * 0 1 Provide an extension hook to customize PODesc. NA NA NA NA NA NA

XML-Schema Name:PODtl Version:13.1.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For PODtl
Table Name Column Name API Type Column Length API Required API Description
item varchar225 1 1 Description is not available. RK_ORDER_ITM ID_ITM VARCHAR2 128 No Not Yet Available
ref_item varchar225 0 1 Not used in RWMS. null varchar2 25 null null
physical_location_type varchar21 1 1 This field contains the type of location in the location field. Valid values are 'S' -Store, 'W' -Warehouse null varchar2 1 null null
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. RK_ORDER_ITM ID_STR_RT NUMBER 128 No Not Yet Available
physical_qty_ordered number12_4 0 1 Description is not available. RK_ORDER_ITM QUANTITY_EXPECTED NUMBER 20,4 No Not Yet Available
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 NUMBER 75 No Not Yet Available
origin_country_id varchar23 0 1 The identifier of the country into which the items on the order are being imported. null varchar2 3 null null
supp_pack_size number12_4 0 1 Description is not available. null number 12 null null
earliest_ship_date xs:dateTime 0 1 The date before which the item can not be shipped by the supplier. null RIBDate * null null
latest_ship_date xs:dateTime 0 1 The date after which the item can not be shipped by the supplier. null RIBDate * null null
pickup_loc varchar2250 0 1 Contains the location at which the order will be picked up, if the order is a 'Pickup' order. null varchar2 250 null null
pickup_no varchar225 0 1 Not used in RWMS. null varchar2 25 null null
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. null varchar2 6 null null
round_lvl varchar26 0 1 This column will be used to determine how order quantities will be rounded to Case, Layer and Pallet. null varchar2 6 null null
door_ind varchar21 0 1 Description is not available. null null null null null
priority_level number1 0 1 Description is not available. null null null null null
new_item varchar21 0 1 Description is not available. null null null null null
quarantine varchar21 0 1 Description is not available. null null null null null
rcvd_unit_qty number12_4 0 1 Description is not available. RK_ORDER_ITM QUANTITY_RECEIVED NUMBER 20,4 No Not Yet Available
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. null number 10 null null
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 null null null null null
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. null null null null null
ExtOfPODesc:ExtOfPODtl * 0 1 Provide an extension hook to customize PODtl. NA NA NA NA NA NA

XML-Schema Name:POVirtualDtl Version:13.1.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim 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 null null null null null
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) null null null null null
qty_ordered number12_4 0 1 Contains the total number of items ordered for the SKU to this location. null number 12 null null
ExtOfPODesc:ExtOfPOVirtualDtl * 0 1 Provide an extension hook to customize POVirtualDtl. NA NA NA NA NA NA

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

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

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