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

XML-Schema Name:ASNOutDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ASNOutDesc
Table Name Column Name API Type Column Length API Required API Description
schedule_nbr number8 0 1 Contains the Schedule identifier number NA NA NA NA NA NA
auto_receive varchar21 0 1 Contains the flag to enable auto_receiving at SIM NA NA NA NA NA NA
to_location varchar210 1 1 Contains the location that the shipment will be delivered to. TRANSFER, RETURN RECEIVING_STORE_ID, SOURCE_ID VARCHAR2 128 Yes Contains the location to which the shipment will be delivered.
from_location varchar210 1 1 For transfer and allocation shipments, this field will hold the location from which the shipment was sourced. TRANSFER, RETURN SENDING_STORE_ID, STORE_ID NUMBER 10 Yes For transfer and return to warehouse/external finisher shipments, this field holds the location from which the shipment was sourced.
asn_nbr varchar230 0 1 Holds the bill of lading number associated with a shipment. TRANSFER, RETURN ID, EXTERNAL_ID NUMBER 12 No Unique identifier of a return/transfer OR external identifier.
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. No SIM specifies the ASN type as C (container)
container_qty number6 0 1 Contains the number of boxes associated with the shipment. No Contains the number of boxes associated with the shipment. SIM sets the constant value 1.
bol_nbr varchar217 1 1 Holds the transaction sequence number on the message from the transfer shipment confirmation process. TRANSFER, RETURN ID, EXTERNAL_ID NUMBER 12 No Unique identifier of a return/transfer OR external identifier.
shipment_date xs:dateTime 0 1 This field contains the date the transfer or PO was shipped. TRANSFER, RETURN SHIP_DATE DATE No This field contains the date on which the transfer or return was shipped.
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. No Populated by SIM with a null value.
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) ADDRESS_DETAIL ADD_1 VARCHAR2 240 Yes First Address.
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) No Populated by SIM with an empty value.
ship_address3 varchar2240 0 1 Not used by RMS. No Populated by SIM with an empty value.
ship_address4 varchar2240 0 1 Not used by RMS. No Populated by SIM with an empty value.
ship_address5 varchar2240 0 1 Not used by RMS. No Populated by SIM with an empty value.
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) ADDRESS_DETAIL CITY VARCHAR2 120 Yes
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) ADDRESS_DETAIL STATE VARCHAR2 3 No
ship_zip varchar230 0 1 Not used by RMS. No Populated by SIM with an NULL value.
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) ADDRESS_DETAIL COUNTRY_ID VARCHAR2 3 Yes
trailer_nbr varchar212 1 1 Not used by RMS. No Populated by SIM with an empty value.
seal_nbr varchar212 0 1 Not used by RMS. No Populated by SIM with an empty value.
carrier_code varchar24 1 1 Contains the courier that will deliver the shipment. No Populated by SIM with an empty value.
transshipment_nbr varchar230 0 1 Not used by RMS. No Populated by SIM with an empty value.
ASNOutDistro * 0 unbounded Description is not available.
comments varchar22000 0 1 Contains any miscellaneous comments about the shipment. TRANSFER, RETURN COMMENTS, TRANSFER_COMMENTS VARCHAR2 2000, 255 No Comment or short description entered by the creator or processor of the return/transfer.
ExtOfASNOutDesc:ExtOfASNOutDesc * 0 1 Provide an extension hook to customize ASNOutDesc. NA NA NA NA NA NA
LocOfASNOutDesc:LocOfASNOutDesc * 0 1 Provide an extension hook to localize ASNOutDesc. NA NA NA NA NA NA

XML-Schema Name:ASNOutDistro Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim 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. TRANSFER, RETURN ID, EXTERNAL_ID NUMBER 12 Yes Specifies the transfer or return number associated with the shipment/item/carton.
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. Yes Indicates the distro doc type for the transfer or return. Valid vaules are T (transfer), C (customer order), D (distro), V (vendor). SIM sets the value to 'T'
customer_order_nbr varchar210 1 1 Not used by RMS. n/a n/a null null No Populated by SIM with an empty value.
consumer_direct varchar21 0 1 Not used by RMS. No Populated by SIM with an empty value.
ASNOutCtn * 1 unbounded Description is not available.
comments varchar22000 0 1 Not used by RMS. TRANSFER, RETURN COMMENTS, TRANSFER_COMMENTS VARCHAR2 2000, 255 No
ExtOfASNOutDesc:ExtOfASNOutDistro * 0 1 Provide an extension hook to customize ASNOutDistro. NA NA NA NA NA NA
LocOfASNOutDesc:LocOfASNOutDistro * 0 1 Provide an extension hook to localize ASNOutDistro. NA NA NA NA NA NA

XML-Schema Name:ASNOutCtn Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ASNOutCtn
Table Name Column Name API Type Column Length API Required API Description
final_location varchar210 0 1 Not used by RMS. RETURN SOURCE_ID VARCHAR2 128 No Supplier reference identifier in case of Return To Vendor, Warehouse reference identifier in case of Return to Warehouse. For Store to Store Transfer, the column is TRANSFER.RECEIVING_STORE_ID.
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. TRANSFER, RETURN ID, EXTERNAL_ID NUMBER 12 Yes This transfer/return id is suffixed with string "-1"
container_weight number12_4 0 1 Not used by RMS. n/a n/a null null No Populated by SIM with an empty value.
container_length number12_4 0 1 Not used by RMS. null null null null Populated by SIM with an empty value.
container_width number12_4 0 1 Not used by RMS. null null null null Populated by SIM with an empty value.
container_height number12_4 0 1 Not used by RMS. null null null null Populated by SIM with an empty value.
container_cube number12_2 0 1 Not used by RMS. null Populated by SIM with an empty value.
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. null null null null Populated by SIM with an empty value.
in_store_date xs:dateTime 0 1 For transfers, the value is always NULL. For allocations, the value is alloc_detail.in_store_date. null Populated by SIM with a NULL value.
rma_nbr varchar220 0 1 Not used by RMS. null Populated by SIM with an empty value.
tracking_nbr varchar225 0 1 Not used by RMS. null Populated by SIM with an empty value.
freight_charge number20_4 0 1 Not used by RMS. null Populated by SIM with an empty value.
master_container_id varchar220 0 1 Not used by RMS. null Populated by SIM with an empty value.
ASNOutItem * 1 unbounded Description is not available.
comments varchar22000 0 1 Not used by RMS. null Not used in SIM
weight number12_4 0 1 Actual weight shipped for the container. null Not used by SIM
weight_uom varchar24 0 1 Unit of measurement for weight (e.g. pounds, kilograms) that was shipped. null Not used by SIM
ExtOfASNOutDesc:ExtOfASNOutCtn * 0 1 Provide an extension hook to customize ASNOutCtn. NA NA NA NA NA NA
LocOfASNOutDesc:LocOfASNOutCtn * 0 1 Provide an extension hook to localize ASNOutCtn. NA NA NA NA NA NA

XML-Schema Name:ASNOutItem Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim 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. TRANSFER_LINE_ITEM, RETURN_LINE_ITEM ITEM_ID VARCHAR2 25 Yes Item identifier
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. TRANSFER_LINE_ITEM, RETURN_LINE_ITEM TRANSFER_QUANTITY, QUANTITY NUMBER 20,4 No
gross_cost number20_4 0 1 Contains the gross_cost NA NA NA NA NA NA
priority_level number1 0 1 Not used by RMS. null Populated by SIM with an value 0.
order_line_nbr number4 0 1 Not used by RMS. null Populated by SIM with an value 0
lot_nbr varchar212 0 1 Not used by RMS. No Populated by SIM with an empty value.
final_location varchar210 0 1 Not used by RMS. TRANSFER, RETURN RECEIVING_STORE_ID, SOURCE_ID VARCHAR2 128 No Contains the location to which the shipment will be delivered.
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. No Populated by SIM with an empty value.
to_disposition varchar24 0 1 Not used by RMS. No Populated by SIM with an empty value.
voucher_number varchar216 0 1 This type can hold a number of digits count r_number. No Populated by SIM with an empty value.
voucher_expiration_date xs:dateTime 0 1 Not used by RMS. No Populated by SIM with a null value.
container_qty number6 0 1 Not used by RMS. No SIM sets the constant value 1.
comments varchar22000 0 1 Not used by RMS. No Not used by SIM
unit_cost number20_4 0 1 Not used by RMS. No Not used by SIM
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 NA NA NA NA
weight number12_4 0 1 Actual weight shipped. No Not used by SIM
weight_uom varchar24 0 1 Unit of measurement for weight (e.g. pounds, kilograms) shipped. No Not used by SIM
ExtOfASNOutDesc:ExtOfASNOutItem * 0 1 Provide an extension hook to customize ASNOutItem. NA NA NA NA NA NA
LocOfASNOutDesc:LocOfASNOutItem * 0 1 Provide an extension hook to localize ASNOutItem. NA NA NA NA NA NA

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

XML-Schema Name:LocOfASNOutItem Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfASNOutItem
Table Name Column Name API Type Column Length API Required API Description
InASNOutDesc:InASNOutItem * 0 unbounded India Localization. NA NA NA NA NA NA
BrASNOutDesc:BrASNOutItem * 0 unbounded Brazil Localization. NA NA NA NA NA NA

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

XML-Schema Name:LocOfASNOutCtn Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfASNOutCtn
Table Name Column Name API Type Column Length API Required API Description
InASNOutDesc:InASNOutCtn * 0 unbounded India Localization. NA NA NA NA NA NA
BrASNOutDesc:BrASNOutCtn * 0 unbounded Brazil Localization. NA NA NA NA NA NA

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

XML-Schema Name:LocOfASNOutDistro Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfASNOutDistro
Table Name Column Name API Type Column Length API Required API Description
InASNOutDesc:InASNOutDistro * 0 unbounded India Localization. NA NA NA NA NA NA
BrASNOutDesc:BrASNOutDistro * 0 unbounded Brazil Localization. NA NA NA NA NA NA

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

XML-Schema Name:LocOfASNOutDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfASNOutDesc
Table Name Column Name API Type Column Length API Required API Description
InASNOutDesc:InASNOutDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrASNOutDesc:BrASNOutDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA