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/ASNOutDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:ASNOutDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ASNOutDesc
Table Name Column Name API Type Column Length API Required API Description
to_location varchar210 1 1 Contains the location that the shipment will be delivered to. ship_dest dest_id varchar2 10 Yes *
from_location varchar210 1 1 For transfer and allocation shipments, this field will hold the location from which the shipment was sourced. transshipment_setup dc_dest_id varchar2 10 Yes *
asn_nbr varchar230 0 1 Holds the bill of lading number associated with a shipment. computed * varchar2 30 No *
asn_type varchar21 0 1 Not used by RMS. Set to C for container when ship to location is a store, T for tare when ship to location is a warehouse. calculated * varchar2 1 No *
container_qty number6 0 1 Contains the number of boxes associated with the shipment. computed * number 6 No *
bol_nbr varchar217 1 1 Holds the transaction sequence number on the message from the transfer shipment confirmation process. bol_to_upload bol_nbr varchar2 17 Yes *
shipment_date xs:dateTime 0 1 This field contains the date the transfer or PO was shipped. manifest ship_ts RIBDate * No *
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. ship_dest lead_time RIBDate * No *
ship_address1 varchar2240 0 1 Value of addr.add_1 for store/warehouse number in addr.key_value_1 and addr.module 'ST' (if to_loc_type is store) or 'WH' (if to_loc_type is warehouse) ship_dest address1 varchar2 240 No *
ship_address2 varchar2240 0 1 Value of addr.add_2 for store/warehouse number in addr.key_value_1 and addr.module 'ST' (if to_loc_type is store) or 'WH' (if to_loc_type is warehouse) ship_dest address2 varchar2 240 No *
ship_address3 varchar2240 0 1 Not used by RMS. n/a n/a varchar2 240 No Not used in RWMS.
ship_address4 varchar2240 0 1 Not used by RMS. n/a n/a varchar2 240 No Not used in RWMS.
ship_address5 varchar2240 0 1 Not used by RMS. n/a n/a varchar2 240 No Not used in RWMS.
ship_city varchar2120 0 1 Value of addr.city for store/warehouse number in addr.key_value_1 and addr.module 'ST' (if to_loc_type is store) or 'WH' (if to_loc_type is warehouse) ship_dest city varchar2 120 No *
ship_state varchar23 0 1 Value of addr.state for store/warehouse number in addr.key_value_1 and addr.module 'ST' (if to_loc_type is store) or 'WH' (if to_loc_type is warehouse) ship_dest state varchar2 3 No *
ship_zip varchar230 0 1 Not used by RMS. ship_dest zip varchar2 30 No *
ship_country_id varchar23 0 1 Value of addr.country_id for store/warehouse number in addr.key_value_1 and addr.module 'ST' (if to_loc_type is store) or 'WH' (if to_loc_type is warehouse) ship_dest country_code varchar2 3 No *
trailer_nbr varchar212 1 1 Not used by RMS. manifest trailer_id varchar2 12 Yes *
seal_nbr varchar212 0 1 Not used by RMS. manifest seal_nbr varchar2 12 No *
carrier_code varchar24 1 1 Contains the courier that will deliver the shipment. trailer carrier_code varchar2 4 Yes *
transshipment_nbr varchar230 0 1 Not used by RMS. manifest transshipment_nbr varchar2 30 No *
ASNOutDistro * 0 unbounded Description is not available.
comments varchar22000 0 1 Contains any miscellaneous comments about the shipment. n/a n/a varchar2 2000 No Not used in RWMS.
ExtOfASNOutDesc:ExtOfASNOutDesc * 0 1 Provide an extension hook to customize ASNOutDesc. NA NA NA NA NA NA

XML-Schema Name:ASNOutDistro Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ASNOutDistro
Table Name Column Name API Type Column Length API Required API Description
distro_nbr varchar210 1 1 Specifies the transfer or allocation number associated with the shipment/item/carton. container_item distro_nbr varchar2 10 Yes *
distro_doc_type varchar21 1 1 Specifies what the distro_nbr field corresponds to in RMS: V, D, and T specify transfer, A specifies Allocation. stock_order document_type varchar2 1 Yes *
customer_order_nbr varchar210 1 1 Not used by RMS. stock_order cust_order_nbr varchar2 10 Yes *
consumer_direct varchar21 0 1 Not used by RMS. stock_order consumer_direct varchar2 1 No *
ASNOutCtn * 1 unbounded Description is not available.
comments varchar22000 0 1 Not used by RMS. n/a n/a varchar2 2000 No Not used in RWMS.
ExtOfASNOutDesc:ExtOfASNOutDistro * 0 1 Provide an extension hook to customize ASNOutDistro. NA NA NA NA NA NA

XML-Schema Name:ASNOutCtn Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ASNOutCtn
Table Name Column Name API Type Column Length API Required API Description
final_location varchar210 0 1 Not used by RMS. container dest_id varchar2 10 No *
container_id varchar220 1 1 Identifies the UCC-128 carton number for shipments originating from the Advance Shipment Notification process as carton shipments. This field will be zero for all shipments that are not at a carton level. container container_id varchar2 20 Yes *
container_weight number12_4 0 1 Not used by RMS. container container_weight number 12 No *
container_length number12_4 0 1 Not used by RMS. container container_length number 12 No *
container_width number12_4 0 1 Not used by RMS. container container_width number 12 No *
container_height number12_4 0 1 Not used by RMS. container container_height number 12 No *
container_cube number12_2 0 1 Not used by RMS. container container_cube number 12 No *
expedite_flag varchar21 0 1 Indicates if the shipment should be expedited. For transfers, the value will be 'Y' if the transfer's freight_code is 'E'; otherwise 'N'. For allocations, the field is mapped to alloc_detail.rush_flag. container expedite_flag varchar2 1 No *
in_store_date xs:dateTime 0 1 For transfers, the value is always NULL. For allocations, the value is alloc_detail.in_store_date. container in_store_date RIBDate * No *
rma_nbr varchar220 0 1 Not used by RMS. container rma_nbr varchar2 20 No *
tracking_nbr varchar225 0 1 Not used by RMS. * tracking_nbr varchar2 25 No *
freight_charge number20_4 0 1 Not used by RMS. * freight_charge number 20 No *
master_container_id varchar220 0 1 Not used by RMS. container master_container_id varchar2 20 No *
ASNOutItem * 1 unbounded Description is not available.
comments varchar22000 0 1 Not used by RMS. n/a n/a varchar2 2000 No Not used in RWMS.
weight number12_4 0 1 Actual weight shipped for the container. * * number 12 * *
weight_uom varchar24 0 1 Unit of measurement for weight (e.g. pounds, kilograms) that was shipped. * * varchar2 4 * *
ExtOfASNOutDesc:ExtOfASNOutCtn * 0 1 Provide an extension hook to customize ASNOutCtn. NA NA NA NA NA NA

XML-Schema Name:ASNOutItem Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ASNOutItem
Table Name Column Name API Type Column Length API Required API Description
item_id varchar225 1 1 Unique identifier for the item. container_item 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 advance shipment notification for this item/shipment combination. container_item unit_qty number 12 Yes *
priority_level number1 0 1 Not used by RMS. container_item priority_level number 1 No *
order_line_nbr number4 0 1 Not used by RMS. * * number 4 No *
lot_nbr varchar212 0 1 Not used by RMS. container lot_nbr varchar2 12 No *
final_location varchar210 0 1 Not used by RMS. * * varchar2 10 No *
from_disposition varchar24 0 1 This value is used to determine if the inventory is available or unavailable, based on the code's INV_STATUS value on the INV_STATUS_CODES table. * * varchar2 4 No *
to_disposition varchar24 0 1 Not used by RMS. * * varchar2 4 No *
voucher_number varchar216 0 1 This type can hold a number of digits count r_number. * * varchar2 16 No *
voucher_expiration_date xs:dateTime 0 1 Not used by RMS. * * RIBDate * No *
container_qty number6 0 1 Not used by RMS. computed * number 6 No *
comments varchar22000 0 1 Not used by RMS. n/a n/a varchar2 2000 No Not used in RWMS.
unit_cost number20_4 0 1 Not used by RMS. n/a n/a number 20 No *
weight number12_4 0 1 Actual weight shipped. * * number 12 * *
weight_uom varchar24 0 1 Unit of measurement for weight (e.g. pounds, kilograms) shipped. * * varchar2 4 * *
ExtOfASNOutDesc:ExtOfASNOutItem * 0 1 Provide an extension hook to customize ASNOutItem. NA NA NA NA NA NA

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

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

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

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