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/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:15.0.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. 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 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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
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,STORE 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. TSF_DELV SOURCE_TYPE RIB or/and RSB or/and RSL NUMBER(4,0) Yes Fill this description.
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
asn_nbr varchar230 1 1 Holds the advance shipping notice number associated with a shipment. TSF_SHIP,DSD,TSF_DELV, TSF_SHIP.ASN,DSD.ASN_ID,TSF_DELV.ASN_ID VARCHAR2 128 Yes the advanced shipping notification identifier that is associated with the direct delivery/Transfer Shipments/Transfer 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). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
container_qty number6 1 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. No Number of Containers in the payload
bol_nbr varchar217 0 1 Holds the transaction sequence number on the input message from the receiving PO or transfer process. SHIPMENT_BOL ID RIB or/and RSB or/and RSL NUMBER(12,0) 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 Fill column length. 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,TSF_DELV EXPECTED_DATE DATE Fill column length. No the date the direct delivery/warehouse delivery is expected to arrive at the store.
ship_address1 varchar2240 0 1 Not used in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
ship_address2 varchar2240 0 1 Not used in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
ship_address3 varchar2240 0 1 Not used in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
ship_address4 varchar2240 0 1 Not used in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
ship_address5 varchar2240 0 1 Not used in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
ship_city varchar2120 0 1 Not used in RWMS. Fill application table name. null null null null Not used in SIM
ship_state varchar23 0 1 Not used in RWMS. Fill application table name. null null null null Not used in SIM
ship_zip varchar230 0 1 Not used in RWMS. Fill application table name. null null null null Not used in SIM
ship_country_id varchar23 0 1 Not used in RWMS. Fill application table name. null null null null Not used in SIM
trailer_nbr varchar212 0 1 Not used in RWMS. Fill application table name. null null null null Not used in SIM
seal_nbr varchar212 0 1 Not used in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
carrier_code varchar24 0 1 Contains the courier that will deliver the shipment. SHIPMENT_CARRIER CODE RIB or/and RSB or/and RSL VARCHAR2(4 BYTE) null Not used in SIM
carrier_service_code varchar26 0 1 Contains the service level code for the courier that will deliver the shipment. SHIPMENT_CARRIER_SERVICE CODE RIB or/and RSB or/and RSL VARCHAR2(6 BYTE) Yes Fill this description.
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
ASNInPO * 1 unbounded Description is not available.
comments varchar22000 0 1 Contains any comments about the shipment. NOTES TEXT VARCHAR2 2000 No any user comments for this Transfer delivery/Direct delivery.

XML-Schema Name:ASNInPO 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 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. TSF ORIGIN_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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
comments varchar22000 0 1 Contains any comments about the shipment. NOTES TEXT 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:15.0.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. N/A N/A RIB or/and RSB or/and RSL N/A null Not used in SIM
container_id varchar220 1 1 Holds the UCC-128 carton number. TSF_SHIP_CARTON, DSD_CARTON, RTV_SHIP_CARTON, TSF_DELV_CARTON EXTERNAL_ID VARCHAR2 128 Yes the unique identifier of the carton.
container_weight number12_4 0 1 Description is not available. TSF_SHIP_CARTON WEIGHT RIB or/and RSB or/and RSL NUMBER(12,4) null Not used in SIM
container_length number12_4 0 1 Description is not available. SHIPMENT_CARTON_DIM LENGTH RIB or/and RSB or/and RSL NUMBER(12,4) null
container_width number12_4 0 1 Description is not available. SHIPMENT_CARTON_DIM WIDTH RIB or/and RSB or/and RSL NUMBER(12,4) null
container_height number12_4 0 1 Description is not available. SHIPMENT_CARTON_DIM HEIGHT RIB or/and RSB or/and RSL NUMBER(12,4) null Not used in SIM
container_cube number12_2 0 1 Description is not available. N/A N/A RIB or/and RSB or/and RSL N/A null Not used in SIM
expedite_flag varchar21 0 1 Description is not available. N/A N/A RIB or/and RSB or/and RSL N/A null Not used in SIM
in_store_date xs:dateTime 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. 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. SHIPMENT_CARRIER MANIFEST_TYPE RIB VARCHAR2(4 BYTE) Yes Fill this description.
tracking_nbr varchar2120 0 1 This is a unique tracking number that is used to track containers through carriers system. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
freight_charge number12_4 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
master_container_id varchar220 0 1 Not used in RWMS Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
ASNInItem * 1 unbounded Description is not available.
comments varchar22000 0 1 Contains any comments about the shipment container. NOTES TEXT RIB or/and RSB or/and RSL VARCHAR2(2000 BYTE) null

XML-Schema Name:ASNInItem 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 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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. 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. TSF_DELV_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. TSF_LINE_ITEM,DSD_LINE_ITEM QUANTITY_RECEIVED 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. Fill application table name. 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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
order_line_nbr number4 0 1 Not used in RWMS. Fill application table name. null null null null Not used in SIM
lot_nbr varchar220 0 1 Not used in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. 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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
distro_nbr varchar212 1 1 Specifies the transfer or allocation number associated with the shipment/item/carton. Fill application table name. 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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes 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. TSF_DELV_LINE_ITEM,TSF FUL_ORD_EXTERNAL_ID VARCHAR2 128 No Fulfillment order external identifier
distro_doc_type varchar21 0 1 Valid Document Type Fill application table name. null null null null Not used in SIM
container_qty number6 0 1 Description is not available. Fill application table name. null null null null Not used in SIM
comments varchar22000 0 1 Contains any comment about the item in the shipment. NOTES TEXT VARCHAR2 2000 No any user defined comments for this item.
ASNInUIN * 0 unbounded Collection of Universal Identification Numbers.

XML-Schema Name:ASNInUIN 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 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 ITEM_UIN UIN RIB or/and RSB or/and RSL Yes

XML-Schema Name:ASNInItem 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 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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. 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. TSF_DELV_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. TSF_LINE_ITEM,DSD_LINE_ITEM QUANTITY_RECEIVED 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. Fill application table name. 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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
order_line_nbr number4 0 1 Not used in RWMS. Fill application table name. null null null null Not used in SIM
lot_nbr varchar220 0 1 Not used in RWMS. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. 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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. null Not used in SIM
distro_nbr varchar212 1 1 Specifies the transfer or allocation number associated with the shipment/item/carton. Fill application table name. 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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes 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. TSF_DELV_LINE_ITEM,TSF FUL_ORD_EXTERNAL_ID VARCHAR2 128 No Fulfillment order external identifier
distro_doc_type varchar21 0 1 Valid Document Type Fill application table name. null null null null Not used in SIM
container_qty number6 0 1 Description is not available. Fill application table name. null null null null Not used in SIM
comments varchar22000 0 1 Contains any comment about the item in the shipment. NOTES TEXT VARCHAR2 2000 No any user defined comments for this item.
ASNInUIN * 0 unbounded Collection of Universal Identification Numbers.

XML-Schema Name:ASNInUIN 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 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 ITEM_UIN UIN RIB or/and RSB or/and RSL Yes