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

XML-Schema Name:ASNInDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ASNInDesc
Table Name Column Name API Type Column Length API Required API Description
to_location varchar210 1 1 Not used in RWMS DO_CTL_INV ID_PRTY_TO_ICD VARCHAR2 128 No Not Yet Available
from_location varchar210 1 1 Not used in RWMS DO_CTL_INV ID_PRTY_FM_ICD VARCHAR2 128 No Not Yet Available
asn_nbr varchar230 1 1 Description is not available. DO_CTL_INV ASN_NUM VARCHAR2 128 No Not Yet Available
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 null null null null
container_qty number6 1 1 Description is not available. null null null null null
bol_nbr varchar217 0 1 Holds the transaction sequence number on the input message from the receiving PO or transfer process. null varchar2 17 null null
shipment_date xs:dateTime 1 1 Not used in RWMS. DO_CTL_INV TS_CRT_ICD RIBDate * No Not Yet Available
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. DO_CTL_INV DC_DV_EXP_ICD RIBDate * No Not Yet Available
ship_address1 varchar2240 0 1 Not used in RWMS. null null null null null
ship_address2 varchar2240 0 1 Not used in RWMS. null null null null null
ship_address3 varchar2240 0 1 Not used in RWMS. null null null null null
ship_address4 varchar2240 0 1 Not used in RWMS. null null null null null
ship_address5 varchar2240 0 1 Not used in RWMS. null null null null null
ship_city varchar2120 0 1 Not used in RWMS. null null null null null
ship_state varchar23 0 1 Not used in RWMS. null null null null null
ship_zip varchar230 0 1 Not used in RWMS. null null null null null
ship_country_id varchar23 0 1 Not used in RWMS. null null null null null
trailer_nbr varchar212 0 1 Not used in RWMS. null null null null null
seal_nbr varchar212 0 1 Not used in RWMS. null null null null null
carrier_code varchar24 0 1 Description is not available. null varchar2 4 null null
vendor_nbr varchar210 1 1 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. DO_CTL_INV ID_PRTY_FM_ICD VARCHAR2 128 No Not Yet Available
ship_pay_method varchar22 0 1 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 varchar2 2 null null
ASNInPO * 1 unbounded Description is not available.
comments varchar22000 0 1 Description is not available. DO_CTL_INV COMMENT_DESC VARCHAR2 300 No Not Yet Available
ExtOfASNInDesc:ExtOfASNInDesc * 0 1 Provide an extension hook to customize ASNInDesc. NA NA NA NA NA NA

XML-Schema Name:ASNInPO Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ASNInPO
Table Name Column Name API Type Column Length API Required API Description
po_nbr varchar210 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. DO_CTL_INV ORDER_ID/REFERENCE_ID_ICD VARCHAR2 128 No Not Yet Available
doc_type varchar21 1 1 Description is not available. DO_CTL_INV ID_ORGR_ICD VARCHAR2 128 No Not Yet Available
not_after_date xs:dateTime 0 1 Description is not available. null RIBDate * null null
comments varchar22000 0 1 Description is not available. null null null null null
ASNInCtn * 0 unbounded Description is not available.
ASNInItem * 0 unbounded Description is not available.
ExtOfASNInDesc:ExtOfASNInPO * 0 1 Provide an extension hook to customize ASNInPO. NA NA NA NA NA NA

XML-Schema Name:ASNInCtn Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ASNInCtn
Table Name Column Name API Type Column Length API Required 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 varchar2 10 null null
container_id varchar220 1 1 Description is not available. RK_SHIP_CONT_ICD CONTAINER_ID VARCHAR2 128 No Not Yet Available
container_weight number12_4 0 1 Description is not available. null null null null null
container_length number12_4 0 1 Description is not available. null null null null null
container_width number12_4 0 1 Description is not available. null null null null null
container_height number12_4 0 1 Description is not available. null null null null null
container_cube number12_2 0 1 Description is not available. null null null null null
expedite_flag varchar21 0 1 Description is not available. null null null null null
in_store_date xs:dateTime 0 1 Description is not available. null null null null null
rma_nbr varchar220 0 1 Description is not available. null null null null null
tracking_nbr varchar225 0 1 Not used in RWMS null null null null null
freight_charge number12_4 0 1 Description is not available. null null null null null
master_container_id varchar220 0 1 Not used in RWMS null null null null null
ASNInItem * 1 unbounded Description is not available.
comments varchar22000 0 1 Description is not available. null null null null null
ExtOfASNInDesc:ExtOfASNInCtn * 0 1 Provide an extension hook to customize ASNInCtn. NA NA NA NA NA NA

XML-Schema Name:ASNInItem Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ASNInItem
Table Name Column Name API Type Column Length API Required 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 varchar2 10 null null
item_id varchar225 0 1 Unique identifier for the item. Either vpn, item_id, or ref_item must be specified in the message. TR_LTM_ICD_MR ID_ITM VARCHAR2 128 Yes Not Yet Available
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. TR_LTM_ICD_MR QU_ITM NUMBER 20,4 No Not Yet Available
priority_level number1 0 1 Description is not available. null null null null null
vpn varchar230 0 1 Used to find the Retek item number, found on the ITEM_SUPPLIER table. Either vpn, item_id, or ref_item must be specified in the message. null varchar2 30 null null
order_line_nbr number4 0 1 Not used in RWMS. null null null null null
lot_nbr varchar212 0 1 Not used in RWMS. null null null null null
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 varchar2 25 null null
distro_nbr varchar210 1 1 Description is not available. null null null null null
distro_doc_type varchar21 0 1 Not used in RWMS. null null null null null
container_qty number6 0 1 Description is not available. null null null null null
comments varchar22000 0 1 Description is not available. TR_LTM_ICD_MR COMMENT_DESC VARCHAR2 300 No Not Yet Available
ExtOfASNInDesc:ExtOfASNInItem * 0 1 Provide an extension hook to customize ASNInItem. NA NA NA NA NA NA

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

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

XML-Schema Name:ASNInItem Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ASNInItem
Table Name Column Name API Type Column Length API Required 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 varchar2 10 null null
item_id varchar225 0 1 Unique identifier for the item. Either vpn, item_id, or ref_item must be specified in the message. TR_LTM_ICD_MR ID_ITM VARCHAR2 128 Yes Not Yet Available
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. TR_LTM_ICD_MR QU_ITM NUMBER 20,4 No Not Yet Available
priority_level number1 0 1 Description is not available. null null null null null
vpn varchar230 0 1 Used to find the Retek item number, found on the ITEM_SUPPLIER table. Either vpn, item_id, or ref_item must be specified in the message. null varchar2 30 null null
order_line_nbr number4 0 1 Not used in RWMS. null null null null null
lot_nbr varchar212 0 1 Not used in RWMS. null null null null null
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 varchar2 25 null null
distro_nbr varchar210 1 1 Description is not available. null null null null null
distro_doc_type varchar21 0 1 Not used in RWMS. null null null null null
container_qty number6 0 1 Description is not available. null null null null null
comments varchar22000 0 1 Description is not available. TR_LTM_ICD_MR COMMENT_DESC VARCHAR2 300 No Not Yet Available
ExtOfASNInDesc:ExtOfASNInItem * 0 1 Provide an extension hook to customize ASNInItem. NA NA NA NA NA NA

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

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

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