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

XML-Schema Name:ASNInDesc Version:14.1.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ASNInDesc 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. NA NA NA NA NA NA
auto_receive varchar21 0 1 Contains the flag to enable auto receiving at SIM. Either Y or N
to_location varchar210 0 1 Contains the location that the shipment will be delivered to. RWMS does not utilize this field. STORE ID NUMBER 10 Yes a unique retailer assigned identifier for a location.
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 does not utilize this field. NA NA NA NA NA NA
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 does not utilize this field. NA NA NA NA NA NA
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 does not utilize this. field. NA NA NA NA NA NA
from_location varchar210 1 1 For transfer and allocation shipments, this field will hold the location from which the shipment was sourced. RWMS does not utilize this field. WAREHOUSE,PARTNER ID NUMBER,VARCHAR2 10 Yes Unique identifier of warehouse or Partner
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 does not utilize this field. NA NA NA NA NA NA
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. RWMS does not utilize this field. NA NA NA NA NA NA
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. RWMS does not utilize this field. NA NA NA NA NA NA
asn_nbr varchar230 1 1 Holds the advance shipping notice number associated with a shipment. TRANSFER,DSD,WHD TRANSFER.EXTERNAL_ID,DSD.ASN_ID,WHD.ASN_ID VARCHAR2 128 Yes the advanced shipping notification identifier that is associated with the direct delivery/Transfer/Warehouse delivery.
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). null Not used in SIM
container_qty number6 1 1 Description is not available. No Not used in SIM
bol_nbr varchar217 0 1 Holds the transaction sequence number on the input message from the receiving PO or transfer process. null Not used in SIM
shipment_date xs:dateTime 1 1 This field contains the date the transfer or PO was shipped. DSD,WHD CREATE_DATE DATE No the date the direct delivery/warehouse delivery record was created.
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. DSD,WHD EXPECTED_ARRIVAL_DATE DATE No the date the direct delivery/warehouse delivery is expected to arrive at the store.
ship_address1 varchar2240 0 1 Not used in RWMS. null Not used in SIM
ship_address2 varchar2240 0 1 Not used in RWMS. null Not used in SIM
ship_address3 varchar2240 0 1 Not used in RWMS. null Not used in SIM
ship_address4 varchar2240 0 1 Not used in RWMS. null Not used in SIM
ship_address5 varchar2240 0 1 Not used in RWMS. null Not used in SIM
ship_city varchar2120 0 1 Not used in RWMS. null null null null Not used in SIM
ship_state varchar23 0 1 Not used in RWMS. null null null null Not used in SIM
ship_zip varchar230 0 1 Not used in RWMS. null null null null Not used in SIM
ship_country_id varchar23 0 1 Not used in RWMS. null null null null Not used in SIM
trailer_nbr varchar212 0 1 Not used in RWMS. null null null null Not used in SIM
seal_nbr varchar212 0 1 Not used in RWMS. null Not used in SIM
carrier_code varchar24 0 1 Contains the courier that will deliver the shipment. null Not used in SIM
carrier_service_code varchar26 0 1 Contains the service level code for the courier that will deliver the shipment. NA NA NA NA NA NA
vendor_nbr varchar210 1 1 Contains the supplier who will provide the merchandise specified in the order. 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. SUPPLIER ID VARCHAR2 128 Yes a code to uniquely identify the supplier.
ship_pay_method varchar22 0 1 Indicates the payment terms for freight charges associated with the order. 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. null Not used in SIM
ASNInPO * 1 unbounded Description is not available.
comments varchar22000 0 1 Contains any comments about the shipment. DSD,WHD COMMENTS VARCHAR2 2000 No any user comments for this warehouse delivery/Direct delivery.

XML-Schema Name:ASNInPO Version:14.1.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ASNInPO 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
po_nbr varchar212 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. DSD,WHD_LINE_ITEM DSD.PURCHASE_ORDER_ID,WHD_LINE_ITEM.RECEIPT_DOCUMENT_ID NUMBER,VARCHAR2 12,128 No the unique identifier of the purchase order that this direct delivery is associated to.
doc_type varchar21 1 1 Description is not available. WHD_LINE_ITEM RECEIPT_DOCUMENT_TYPE VARCHAR2 128 No a code representing the type of receipt document associated to the warehouse delivery.
not_after_date xs:dateTime 0 1 Contains the last date that delivery of the order will be accepted. null Not used in SIM
comments varchar22000 0 1 Contains any comments about the shipment. WHD,DSD COMMENTS VARCHAR2 2000 No user comments for this warehouse delivery.
ASNInCtn * 0 unbounded Description is not available.
ASNInItem * 0 unbounded Description is not available.

XML-Schema Name:ASNInCtn Version:14.1.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ASNInCtn 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 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. null Not used in SIM
container_id varchar220 1 1 Holds the UCC-128 carton number. WHD_CARTON,DSD_CARTON EXTERNAL_ID VARCHAR2 128 Yes the unique identifier of the carton.
container_weight number12_4 0 1 Description is not available. null Not used in SIM
container_length number12_4 0 1 Description is not available. null Not used in SIM
container_width number12_4 0 1 Description is not available. null Not used in SIM
container_height number12_4 0 1 Description is not available. null Not used in SIM
container_cube number12_2 0 1 Description is not available. null Not used in SIM
expedite_flag varchar21 0 1 Description is not available. null Not used in SIM
in_store_date xs:dateTime 0 1 Description is not available. null Not used in 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. NA NA NA NA NA NA
tracking_nbr varchar2120 0 1 This is a unique tracking number that is used to track containers through carriers system. null Not used in SIM
freight_charge number12_4 0 1 Description is not available. null Not used in SIM
master_container_id varchar220 0 1 Not used in RWMS null Not used in SIM
ASNInItem * 1 unbounded Description is not available.
comments varchar22000 0 1 Contains any comments about the shipment container. null Not used by SIM

XML-Schema Name:ASNInItem Version:14.1.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ASNInItem 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 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. null Not used in SIM
item_id varchar225 0 1 Unique identifier for the item. Either vpn, item_id, or ref_item must be specified in the message. WHD_LINE_ITEM ITEM_ID VARCHAR2 25 Yes The unique identifier of the item that is contained in this carton
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. TRANSFER_LINE_ITEM,DSD_LINE_ITEM,WHD_LINE_ITEM TRANSFER_LINE_ITEM.RECEIVED_QUANTITY,DSD_LINE_ITEM.QUANTITY_SHIPPED,WHD_LINE_ITEM.QUANTITY_EXPECTED NUMBER 20,4 No the total number of units shipped on the ASN for this direct delivery/the total number of units expected in this warehouse delivery./received quantity of transfer line item
priority_level number1 0 1 Description is not available. null null null null Not used in SIM
vpn varchar230 0 1 Used to find the item number, found on the ITEM_SUPPLIER table. Either vpn, item_id, or ref_item must be specified in the message. null Not used in SIM
order_line_nbr number4 0 1 Not used in RWMS. null null null null Not used in SIM
lot_nbr varchar220 0 1 Not used in RWMS. null Not used in SIM
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. null Not used in SIM
distro_nbr varchar212 1 1 Specifies the transfer or allocation number associated with the shipment/item/carton. null null null null Not used in SIM
consumer_direct varchar21 0 1 This is a Y or N indicator to inform the consuming application if the distro is for a consmer direct order or not. Either Y or N
cust_order_nbr varchar248 0 1 This is the customer order number that was generated by OMS and contains multiple fulfillment numbers. WHD_LINE_ITEM CUST_ORDER_ID VARCHAR2 128 No 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. WHD_LINE_ITEM FUL_ORD_EXTERNAL_ID VARCHAR2 128 No Fulfillment order external identifier
distro_doc_type varchar21 0 1 Valid Document Type null null null null Not used in SIM
container_qty number6 0 1 Description is not available. null null null null Not used in SIM
comments varchar22000 0 1 Contains any comment about the item in the shipment. DSD_LINE_ITEM,WHD_LINE_ITEM COMMENTS VARCHAR2 2000 No any user defined comments for this item.
ASNInUIN * 0 unbounded Collection of Universal Identification Numbers. NA NA NA NA NA NA

XML-Schema Name:ASNInUIN Version:14.1.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ASNInUIN 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 NA NA NA NA NA NA

XML-Schema Name:ASNInItem Version:14.1.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ASNInItem 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 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. null Not used in SIM
item_id varchar225 0 1 Unique identifier for the item. Either vpn, item_id, or ref_item must be specified in the message. WHD_LINE_ITEM ITEM_ID VARCHAR2 25 Yes The unique identifier of the item that is contained in this carton
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. TRANSFER_LINE_ITEM,DSD_LINE_ITEM,WHD_LINE_ITEM TRANSFER_LINE_ITEM.RECEIVED_QUANTITY,DSD_LINE_ITEM.QUANTITY_SHIPPED,WHD_LINE_ITEM.QUANTITY_EXPECTED NUMBER 20,4 No the total number of units shipped on the ASN for this direct delivery/the total number of units expected in this warehouse delivery./received quantity of transfer line item
priority_level number1 0 1 Description is not available. null null null null Not used in SIM
vpn varchar230 0 1 Used to find the item number, found on the ITEM_SUPPLIER table. Either vpn, item_id, or ref_item must be specified in the message. null Not used in SIM
order_line_nbr number4 0 1 Not used in RWMS. null null null null Not used in SIM
lot_nbr varchar220 0 1 Not used in RWMS. null Not used in SIM
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. null Not used in SIM
distro_nbr varchar212 1 1 Specifies the transfer or allocation number associated with the shipment/item/carton. null null null null Not used in SIM
consumer_direct varchar21 0 1 This is a Y or N indicator to inform the consuming application if the distro is for a consmer direct order or not. Either Y or N
cust_order_nbr varchar248 0 1 This is the customer order number that was generated by OMS and contains multiple fulfillment numbers. WHD_LINE_ITEM CUST_ORDER_ID VARCHAR2 128 No 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. WHD_LINE_ITEM FUL_ORD_EXTERNAL_ID VARCHAR2 128 No Fulfillment order external identifier
distro_doc_type varchar21 0 1 Valid Document Type null null null null Not used in SIM
container_qty number6 0 1 Description is not available. null null null null Not used in SIM
comments varchar22000 0 1 Contains any comment about the item in the shipment. DSD_LINE_ITEM,WHD_LINE_ITEM COMMENTS VARCHAR2 2000 No any user defined comments for this item.
ASNInUIN * 0 unbounded Collection of Universal Identification Numbers. NA NA NA NA NA NA

XML-Schema Name:ASNInUIN Version:14.1.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ASNInUIN 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 NA NA NA NA NA NA