Retail Integration Mappings Report Release:15.0.0 (Retail Warehouse Management System)
Application Retail Warehouse Management System
Target Name Space http://www.oracle.com/retail/integration/base/bo/ASNOutDesc/v1
Version 1.2
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:ASNOutDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ASNOutDesc in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
schedule_nbr number8 0 1 Contains the Schedule identifier number. NA NA RIB or/and RSB or/and RSL Fill column length. Yes Populated with NULL
auto_receive varchar21 0 1 Contains the flag to enable auto_receiving at SIM NA NA RIB or/and RSB or/and RSL Fill column length. Yes Populated with NULL
to_location varchar210 0 1 Contains the location that the shipment will be delivered to. ship_dest = manifest dest_id varchar2 10 Yes *
to_loc_type varchar21 0 1 This field contains the location type of the to_location field. Valid values are 'S' = store, 'E' = finisher, and 'W' = warehouse. RWMS publishes data on this field but does not use it. calculated Fill table column name. varchar2 1 Yes based on ship_dest.dest_id. Warehouse, Store or Finisher.
to_store_type varchar21 0 1 Indicates the store type of the to_location. This will only be populated if to_loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. RWMS publishes data on this field but does not use it. ship_dest store_type varchar2 'C' = company store, 'F' = franchise store. RWMS publishes data on this field but does not use it. Yes Indicates the store type of the to_location. This will only be populated if to_loc_type is 'S'. Valid values are
to_stockholding_ind varchar21 0 1 Indicates if the to_location is stockholding or not. Only populated if to_loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. RWMS publishes data on this field but does not use it. ship_dest stockholding_ind varchar2 'Y' = yes, 'N' = no. RWMS publishes data on this field but does not use it. Yes Only populated if to_loc_type is 'S'.
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 Gets dc_dest_id from transshipment_setup table
from_loc_type varchar21 0 1 This field contains the location type of the from_location field. Valid values are 'S' = store and 'W' = warehouse. RWMS publishes data on this field but does not use it. NA NA varchar2 1 Yes Always W
from_store_type varchar21 0 1 Indicates the store type of the from_location. This will only be populated if from_location is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. Publications from RWMS will always be NULL for this field. RWMS publishes data on this field but does not use it. NA NA varchar2 1 Yes Populated with NULL
from_stockholding_ind varchar21 0 1 Indicates if the from_location is stockholding or not. Only populated if from_location is 'S'. Valid values are: 'Y' = yes, 'N' = no. Publications from RWMS will always be NULL for this field. RWMS publishes data on this field but does not use it. NA NA varchar2 1 Yes Populated with NULL
asn_nbr varchar230 0 1 Holds the bill of lading number associated with a shipment. computed * varchar2 30 Yes bol_to_upload.bol_nbr concatenated with transshipment.dc_dest_id
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 C or T
container_qty number6 0 1 Contains the number of boxes associated with the shipment. container_item container_qty number 6 No Number of containers of this unit. Will be 1 normally, but greater than 1 to represent unlabeled containers. E.g. unit_qty= 100, container qty= 10 means 10 unlabeled (not in the container table) containers of casepack 10.
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 Gets the bol_nbr from bol_to_upload table.
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 Currently system date + (ship_dest.lead_time/24) Yes Calculated
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 Populated with NULL
ship_address4 varchar2240 0 1 Not used by RMS. n/a n/a varchar2 240 No Populated with NULL
ship_address5 varchar2240 0 1 Not used by RMS. n/a n/a varchar2 240 No Populated with NULL
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 0 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 *
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 by RWMS.
carrier_code varchar24 0 1 Contains the courier that will deliver the shipment. container or trailer carrier_code varchar2 4 Yes If trailer nbr = NA then container.carrier_code otherwise trailer.carrier code
carrier_service_code varchar26 0 1 Contains the service level code for the courier that will deliver the shipment. container service_code varchar2 6 Yes If trailer nbr = NA the container.service_code otherwise NULL

XML-Schema Name:ASNOutDistro Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ASNOutDistro in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
distro_nbr varchar212 1 1 Specifies the transfer or allocation number associated with the shipment/item/carton. container_item distro_nbr varchar2 12 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 If NULL populate with V
cust_order_nbr varchar248 0 1 This is the customer order number that was generated by OMS and contains multiple fulfillment numbers. stock_order cust_order_nbr varchar2 12 Yes If NULL populated with NONE
fulfill_order_nbr varchar248 0 1 Based on a customer order - OMS will generate fulfillments to specific locations based on availability. RMS will generate Transfers based on the fulfillment request. stck_order fulfill_order_nbr varchar2 48 Yes For Consumer Direct orders, this number will be part of the order publish/consume. For non-Consumer Direct orders this number will default to the distro number.
consumer_direct varchar21 0 1 Not used by RMS. stock_order consumer_direct varchar2 1 No If Null populate with N
ASNOutCtn * 1 unbounded Description is not available.
comments varchar22000 0 1 Not used by RMS. n/a n/a varchar2 2000 No Not used by RWMS. Populated with NULL

XML-Schema Name:ASNOutCtn Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ASNOutCtn in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's 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 Gets container_id from container table.
container_weight number12_4 0 1 Not used by RMS. container container_weight number 12 No Gets container_weight from container table.
container_length number12_4 0 1 Not used by RMS. container container_length number 12 No Gets container_length from container table.
container_width number12_4 0 1 Not used by RMS. container container_width number 12 No Gets container_width from container table.
container_height number12_4 0 1 Not used by RMS. container container_height number 12 No Gets container_height from container table.
container_cube number12_2 0 1 Not used by RMS. container container_cube number 12 No Gets container_cube from container table.
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 Contains the date to be included in the RMS publication to the RIB for communication to the warehouse. For transfers, the value is always NULL. For allocations, the value is alloc_detail.in_store_date. container in_store_date RIBDate * No *
tracking_nbr varchar2120 0 1 This is a unique tracking number that is used to track containers through carriers system. container tracking_id varchar2 25 No *
freight_charge number20_4 0 1 Not used by RMS. container 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 Contains any comments about the shipment container. n/a n/a varchar2 2000 No Not used by RWMS.
weight number12_4 0 1 Actual weight shipped for the container. container container_weight number 12 No Gets container_weight from container table.
weight_uom varchar24 0 1 Unit of measurement for weight (e.g. pounds, kilograms) that was shipped. scp scp_name varchar2 4 No If container_weight is null then get NULL else get the configuration parameter
carrier_shipment_nbr varchar2120 0 1 This field represents the shipment number that manifest systems use to group multi-container shipments for a carrier. Typically a 1 of 4 type message. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
original_item_id varchar225 0 1 The ID of the item being replaced. Populated only when this record is for a substitute item on a customer order. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:ASNOutItem Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ASNOutItem in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's 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. calculated Fill table column name. number 12 Yes Fill this description.
gross_cost number20_4 0 1 Contains the gross cost. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes NULL is passed
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 NULL is passed
lot_nbr varchar220 0 1 Not used by RMS. container lot_nbr varchar2 12 No *
final_location varchar210 0 1 Not used by RMS. * * varchar2 10 No NULL is passed
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 NULL is passed
to_disposition varchar24 0 1 Not used by RMS. * * varchar2 4 No NULL is passed
voucher_number varchar216 0 1 Contains the voucher number. * * varchar2 16 No NULL is passed.
voucher_expiration_date xs:dateTime 0 1 Not used by RMS. * * RIBDate * No NULL is passed
container_qty number6 0 1 Not used by RMS. conainer_item container_qty number 6 No *
comments varchar22000 0 1 Contains any comment about the item in the shipment. n/a n/a varchar2 2000 No Not used by RWMS. Populated with NULL
unit_cost number20_4 0 1 Contains the unit cost of the item in the shipment. n/a n/a number 20 No NULL is passed
base_cost number20_4 0 1 This value will be used to get the base cost (BC) from RFM for a transfer, which will flow into RMS. NA NA RIB or/and RSB or/and RSL Fill column length. No Not used in RWMS
weight number12_4 0 1 Actual weight shipped. calculated * number 12 * NULL is passed if not a catch weight item. If catch weight item then weight is taken from container_item.item_weight, container.container_weight or calculated based on unit_qty * uom_conv_factor..
weight_uom varchar24 0 1 Unit of measurement for weight (e.g. pounds, kilograms) shipped. calculated * varchar2 4 * NULL is passed if not a catch weight item. If catch weight item then populated with value of scp "sys_weight_uom"
ASNOutUIN * 0 unbounded Collection of Universal Identification Numbers.

XML-Schema Name:ASNOutUIN Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ASNOutUIN in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
uin varchar2128 1 1 Universal Identification Number Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.