Retail Integration Bus Mappings Report Release:13.1

(Retail Warehouse Management System)

Application Retail Warehouse Management System Target Name Space http://www.oracle.com/retail/integration/base/bo/ASNInDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. ASNInDesc ASNInPO ASNInCtn ASNInItem ExtOfASNInItem ExtOfASNInCtn ASNInItem ExtOfASNInItem ExtOfASNInPO ExtOfASNInDesc

XML-Schema Name:ASNInDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ASNInDesc Table Name Column Name API Type Column Length API Required API Description to_location varchar210 1 1 Not used in RWMS n/a n/a varchar2 10 Yes Not used in RWMS from_location varchar210 1 1 Not used in RWMS n/a n/a varchar2 10 Yes Not used in RWMS asn_nbr varchar230 1 1 Description is not available. asn asn_nbr varchar2 30 Yes * asn_type varchar21 1 1 This field is used to determine the ship origin. If asn_type is 'C', ship_origin will be set to '6' (ASN UCC-128) upon insert to the SHIPMENT table. Otherwise, SHIP_ORIGIN is defaulted to '0' (ASN Shipment). asn asn_type varchar2 1 Yes * container_qty number6 1 1 Description is not available. asn container_qty number 6 Yes * bol_nbr varchar217 0 1 Holds the transaction sequence number on the input message from the receiving PO or transfer process. asn bol_nbr varchar2 17 No * shipment_date xs:dateTime 1 1 Not used in RWMS. n/a n/a RIBDate * Yes Not used in RWMS. est_arr_date xs:dateTime 0 1 This field contains the estimated arrival date of a vendor PO shipment. It is updated by EDIUP856. It is used for vendor/lead time analysis. n/a n/a RIBDate * No Not used in RWMS. ship_address1 varchar2240 0 1 Not used in RWMS. n/a n/a varchar2 240 No Not used in RWMS. ship_address2 varchar2240 0 1 Not used in RWMS. n/a n/a varchar2 240 No Not used in RWMS. ship_address3 varchar2240 0 1 Not used in RWMS. n/a n/a varchar2 240 No Not used in RWMS. ship_address4 varchar2240 0 1 Not used in RWMS. n/a n/a varchar2 240 No Not used in RWMS. ship_address5 varchar2240 0 1 Not used in RWMS. n/a n/a varchar2 240 No Not used in RWMS. ship_city varchar2120 0 1 Not used in RWMS. n/a n/a varchar2 120 No Not used in RWMS. ship_state varchar23 0 1 Not used in RWMS. n/a n/a varchar2 3 No Not used in RWMS. ship_zip varchar230 0 1 Not used in RWMS. n/a n/a varchar2 30 No Not used in RWMS. ship_country_id varchar23 0 1 Not used in RWMS. n/a n/a varchar2 3 No Not used in RWMS. trailer_nbr varchar212 0 1 Not used in RWMS. n/a n/a varchar2 12 No Not used in RWMS. seal_nbr varchar212 0 1 Not used in RWMS. n/a n/a varchar2 12 No Not used in RWMS. carrier_code varchar24 0 1 Description is not available. asn carrier_code varchar2 4 No * vendor_nbr varchar210 1 1 This element is used to validate the order number(s) in ASNInPO (ASNInPO.po_nbr). The order number must be in the table ORDHEAD, in either the ORDER_NO column or VENDOR_ORDER_NO column. po vendor_nbr varchar2 10 Yes * ship_pay_method varchar22 0 1 Used to validate the order number(s) in ASNInPO (ASNInPO.po_nbr). The ship_pay_method in the message must match the value of the order's SHIP_PAY_METHOD in RMS (ORDHEAD table.) If the message field is blank, the ORDHEAD value must be NULL. n/a n/a varchar2 2 No Not used in RWMS. ASNInPO * 1 unbounded Description is not available. comments varchar22000 0 1 Description is not available. * * varchar2 2000 * * ExtOfASNInDesc:ExtOfASNInDesc * 0 1 Provide an extension hook to customize ASNInDesc. NA NA NA NA NA NA

XML-Schema Name:ASNInPO Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ASNInPO Table Name Column Name API Type Column Length API Required API Description po_nbr varchar210 1 1 Identifies the order number which relates to the goods delivered in the shipment. Validated against the ORDHEAD table, and also the SHIPMENT table if the message applies to an existing shipment. po_detail po_nbr varchar2 10 Yes * doc_type varchar21 1 1 Description is not available. po doc_type varchar2 1 Yes * not_after_date xs:dateTime 0 1 Description is not available. po deliv_not_after_date RIBDate * No * comments varchar22000 0 1 Description is not available. * * varchar2 2000 * * ASNInCtn * 0 unbounded Description is not available. ASNInItem * 0 unbounded Description is not available. ExtOfASNInDesc:ExtOfASNInPO * 0 1 Provide an extension hook to customize ASNInPO. NA NA NA NA NA NA

XML-Schema Name:ASNInCtn Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ASNInCtn Table Name Column Name API Type Column Length API Required API Description final_location varchar210 1 1 This will be the final destination of the carton. For a cross-dock order this will be the allocation location, otherwise it will be the direct to order location. container dest_id varchar2 10 Yes * container_id varchar220 1 1 Description is not available. container container_id varchar2 20 Yes * container_weight number12_4 0 1 Description is not available. container container_weight number 12 No * container_length number12_4 0 1 Description is not available. container container_length number 12 No * container_width number12_4 0 1 Description is not available. container container_width number 12 No * container_height number12_4 0 1 Description is not available. container container_height number 12 No * container_cube number12_2 0 1 Description is not available. container container_cube number 12 No * expedite_flag varchar21 0 1 Description is not available. container expedite_flag varchar2 1 No * in_store_date xs:dateTime 0 1 Description is not available. container in_store_date RIBDate * No * rma_nbr varchar220 0 1 Description is not available. container rma_nbr varchar2 20 No * tracking_nbr varchar225 0 1 Not used in RWMS n/a n/a varchar2 25 No Not used in RWMS freight_charge number12_4 0 1 Description is not available. container freight_charge number 20 No * master_container_id varchar220 0 1 Not used in RWMS n/a n/a varchar2 20 No Not used in RWMS ASNInItem * 1 unbounded Description is not available. comments varchar22000 0 1 Description is not available. * * varchar2 2000 * * ExtOfASNInDesc:ExtOfASNInCtn * 0 1 Provide an extension hook to customize ASNInCtn. NA NA NA NA NA NA

XML-Schema Name:ASNInItem Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ASNInItem Table Name Column Name API Type Column Length API Required API Description final_location varchar210 1 1 Required if the order's pre_mark_ind is 'Y'. Validated against the ALLOC_DETAIL table. There needs to be at least one allocation with the same ORDER_NO that is in the ASNIn message, and the same TO_LOC as the final_location. asn_item dest_id varchar2 10 Yes * item_id varchar225 0 1 Unique identifier for the item. Either vpn, item_id, or ref_item must be specified in the message. po_detail item_id varchar2 25 Yes * unit_qty number12_4 1 1 Contains the number of items expected to be received based on the supplier's ASN for this Item/Shipment combination. asn_item unit_qty number 12 Yes * priority_level number1 0 1 Description is not available. container_item priority_level number 1 No * vpn varchar230 0 1 Used to find the Retek item number, found on the ITEM_SUPPLIER table. Either vpn, item_id, or ref_item must be specified in the message. * * varchar2 30 * * order_line_nbr number4 0 1 Not used in RWMS. n/a n/a number 4 No Not used in RWMS. lot_nbr varchar212 0 1 Not used in RWMS. n/a n/a varchar2 12 Yes Not used in RWMS. ref_item varchar225 0 1 Contains a reference item to the item field. Either vpn, item_id, or ref_item must be specified in the message. n/a n/a varchar2 25 No Not used in RWMS. distro_nbr varchar210 1 1 Description is not available. container_item distro_nbr varchar2 10 Yes * distro_doc_type varchar21 0 1 Not used in RWMS. n/a n/a varchar2 1 No Not used in RWMS. container_qty number6 0 1 Description is not available. container_item container_qty number 6 No * comments varchar22000 0 1 Description is not available. * * varchar2 2000 * * ExtOfASNInDesc:ExtOfASNInItem * 0 1 Provide an extension hook to customize ASNInItem. NA NA NA NA NA NA

XML-Schema Name:ExtOfASNInItem Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfASNInItem Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfASNInCtn Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfASNInCtn Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ASNInItem Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ASNInItem Table Name Column Name API Type Column Length API Required API Description final_location varchar210 1 1 Required if the order's pre_mark_ind is 'Y'. Validated against the ALLOC_DETAIL table. There needs to be at least one allocation with the same ORDER_NO that is in the ASNIn message, and the same TO_LOC as the final_location. asn_item dest_id varchar2 10 Yes * item_id varchar225 0 1 Unique identifier for the item. Either vpn, item_id, or ref_item must be specified in the message. po_detail item_id varchar2 25 Yes * unit_qty number12_4 1 1 Contains the number of items expected to be received based on the supplier's ASN for this Item/Shipment combination. asn_item unit_qty number 12 Yes * priority_level number1 0 1 Description is not available. container_item priority_level number 1 No * vpn varchar230 0 1 Used to find the Retek item number, found on the ITEM_SUPPLIER table. Either vpn, item_id, or ref_item must be specified in the message. * * varchar2 30 * * order_line_nbr number4 0 1 Not used in RWMS. n/a n/a number 4 No Not used in RWMS. lot_nbr varchar212 0 1 Not used in RWMS. n/a n/a varchar2 12 Yes Not used in RWMS. ref_item varchar225 0 1 Contains a reference item to the item field. Either vpn, item_id, or ref_item must be specified in the message. n/a n/a varchar2 25 No Not used in RWMS. distro_nbr varchar210 1 1 Description is not available. container_item distro_nbr varchar2 10 Yes * distro_doc_type varchar21 0 1 Not used in RWMS. n/a n/a varchar2 1 No Not used in RWMS. container_qty number6 0 1 Description is not available. container_item container_qty number 6 No * comments varchar22000 0 1 Description is not available. * * varchar2 2000 * * ExtOfASNInDesc:ExtOfASNInItem * 0 1 Provide an extension hook to customize ASNInItem. NA NA NA NA NA NA

XML-Schema Name:ExtOfASNInItem Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfASNInItem Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfASNInPO Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfASNInPO Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfASNInDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfASNInDesc Table Name Column Name API Type Column Length API Required API Description