Retail Integration Mappings Report Release:15.0.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.
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 SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
schedule_nbr number8 0 1 Contains the Schedule identifier number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
auto_receive varchar21 0 1 Contains the flag to enable auto_receiving at SIM Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
to_location varchar210 0 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.
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL LOC_TYPE_CUSTOMER "C" Return Yes Delivery
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes for Delivery sim sets empty value and for Transfer value set as STORE_TYPE_COMPANY "C"
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes possibles value are "Y" or "N"
from_location varchar210 1 1 For transfer and allocation shipments, this field will hold the location from which the shipment was sourced. FUL_ORD_DLV,RETURN,TRANSFER STORE_ID NUMBER 10 Yes the identifier of the store that will send the items on the Delivery/Return/Transfer.
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Possible value LOC_TYPE_STORE "S"
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes possible value STORE_TYPE_COMPANY "C"
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes possible value "Y"
asn_nbr varchar230 0 1 Holds the bill of lading number associated with a shipment. FUL_ORD_DLV,RETURN,TRANSFER FUL_ORD_DLV.ID,RETURN.EXTERNAL_ID,RETURN.ID,TRANSFER.EXTERNAL_ID,TRANSFER.ID NUMBER,VARCHAR2 12,128 Yes External id is from rms
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No SIM specifies the ASN type as C (container)
container_qty number6 0 1 Contains the number of boxes associated with the shipment. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. 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. FUL_ORD_DLV,TRANSFER, RETURN FUL_ORD_DLV.ID,RETURN.EXTERNAL_ID,RETURN.ID,TRANSFER.EXTERNAL_ID,TRANSFER.ID NUMBER,VARCHAR2 12,128 No Unique identifier of a Fulfillmentorder delivery/return/transfer
shipment_date xs:dateTime 0 1 This field contains the date the transfer or PO was shipped. FUL_ORD_DLV,TRANSFER, RETURN FUL_ORD_DLV.DISPATCH_DATE,TRANSFER.SHIPPED_DATE,RETURN.SHIPPED_DATE DATE Fill column length. No The date this delivery was dispatched/ship date of a return/the date the transfer 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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. 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 ADDRESS_LINE_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). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Populated by SIM with an empty value.
ship_address3 varchar2240 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Populated by SIM with an empty value.
ship_address4 varchar2240 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Populated by SIM with an empty value.
ship_address5 varchar2240 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. 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 CITY VARCHAR2 120 Yes supplier city id for address type
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 STATE VARCHAR2 3 No supplier state for address type
ship_zip varchar230 0 1 Not used by RMS. ADDRESS POSTAL_CODE VARCHAR2 30 No supplier post info depending on address type
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 COUNTRY_ID VARCHAR2 3 Yes supplier country id depending on address type
trailer_nbr varchar212 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Populated by SIM with an empty value.
seal_nbr varchar212 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Populated by SIM with an empty value.
transshipment_nbr varchar230 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. 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 TRANSFER.TRANSFER_COMMENT,RETURN.COMMENTS VARCHAR2 2000 No Comment or short description entered by the creator or processor of the return/transfer.
carrier_code varchar24 0 1 Contains the courier that will deliver the shipment. SHIPMENT_BOL,SHIPMENT_CARRIER SHIPMENT_BOL.THIRD_PARTY_NAME,SHIPMENT_CARRIER.CODE VARCHAR2 240,4 Yes this field contains the name of the third party/Unique code identifier for a carrier
carrier_service_code varchar26 0 1 Contains the service level code for the courier that will deliver the shipment. SHIPMENT_CARRIER_SERVICE CODE VARCHAR2 6 Yes Unique identifier that represents the delivery service

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 SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
distro_nbr varchar212 1 1 Specifies the transfer or allocation number associated with the shipment/item/carton. FUL_ORD_DLV,TRANSFER, RETURN ID, EXTERNAL_ID NUMBER,VARCHAR2 12,128 Yes Specifies the Fulfillmentorder delivery/transfer/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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. 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'
cust_order_nbr varchar248 0 1 This is the customer order number that was generated by OMS and contains multiple fulfillment numbers. TRANSFER, FUL_ORD CUST_ORDER_ID VARCHAR2 128 Yes Customer order external identifier
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. TRANSFER,FUL_ORD FUL_ORD_EXTERNAL_ID, EXTERNAL_ID VARCHAR2 128 No Fulfillment order external identifier
consumer_direct varchar21 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Populated by SIM with value Y/N depending on the value of CUST_ORDER_ID or FUL_ORD_EXTERNAL_ID of Transfer
ASNOutCtn * 1 unbounded Description is not available.
comments varchar22000 0 1 Not used by RMS. Fill application table name. null RIB or/and RSB or/and RSL null No Fill this description.

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 SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
final_location varchar210 0 1 Not used by RMS. RETURN,TRANSFER RETURN.SOURCE_ID,TRANSFER.RECEIVING_STORE_ID VARCHAR2,NUMBER 128,10 Yes 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. FUL_ORD_DLV,RETURN,TRANSFER FUL_ORD_DLV.ID, RETURN.ID, TRANSFER.EXTERNAL_ID NUMBER,VARCHAR2 12,128 Yes Unique SIM identifier of Delivery,Return or Transfer
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. Fill application table name. null null null null Populated by SIM with an empty value.
container_width number12_4 0 1 Not used by RMS. Fill application table name. null null null null Populated by SIM with an empty value.
container_height number12_4 0 1 Not used by RMS. Fill application table name. null null null null Populated by SIM with an empty value.
container_cube number12_2 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. 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. Fill application table name. null null null null Populated by SIM with an empty value.
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Populated by SIM with a NULL value.
tracking_nbr varchar2120 0 1 This is a unique tracking number that is used to track containers through carriers system. SHIPMENT_BOL TRACKING_NUMBER VARCHAR2 128 No Holds the tracking number for the transaction.
freight_charge number20_4 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Populated by SIM with 0.
master_container_id varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Populated by SIM with an empty value.
ASNOutItem * 1 unbounded Description is not available.
comments varchar22000 0 1 Contains any comments about the shipment container. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
weight number12_4 0 1 Actual weight shipped for the container. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used by SIM
weight_uom varchar24 0 1 Unit of measurement for weight (e.g. pounds, kilograms) that was shipped. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used by SIM
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 Populated by SIM with an empty value.
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 SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
item_id varchar225 1 1 Unique identifier for the item. TRANSFER_LINE_ITEM, RETURN_LINE_ITEM,FUL_ORD_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,FUL_ORD_DLV_LINE_ITEM TRANSFER_LINE_ITEM.TRANSFER_QUANTITY, QUANTITY NUMBER (20,4),(12,4) No Quantity
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 Fill this description.
priority_level number1 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Populated by SIM with an value 0.
order_line_nbr number4 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Populated by SIM with an value 0
lot_nbr varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Populated by SIM with an empty value.
final_location varchar210 0 1 Not used by RMS. TRANSFER, RETURN TRANSFER.RECEIVING_STORE_ID,RETURN.SOURCE_ID NUMBER,VARCHAR2 10,128 Yes supplier or warehouse reference identifier/the identifier of the store that will receive the items on the transfer.
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Populated by SIM with an empty value.
to_disposition varchar24 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Populated by SIM with an empty value.
voucher_number varchar216 0 1 Contains the voucher number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Populated by SIM with an empty value.
voucher_expiration_date xs:dateTime 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Populated by SIM with a null value.
container_qty number6 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No SIM sets the constant value 1.
comments varchar22000 0 1 Contains any comment about the item in the shipment. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Not used by SIM
unit_cost number20_4 0 1 Contains the unit cost of the item in the shipment. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. 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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
weight number12_4 0 1 Actual weight shipped. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Not used by SIM
weight_uom varchar24 0 1 Unit of measurement for weight (e.g. pounds, kilograms) shipped. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Not used by SIM
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 SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM'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.