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/ASNOutDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. ASNOutDesc ASNOutDistro ASNOutCtn ASNOutItem ExtOfASNOutItem ExtOfASNOutCtn ExtOfASNOutDistro ExtOfASNOutDesc

XML-Schema Name:ASNOutDesc Version:13.1 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 to_location varchar210 1 1 Contains the location that the shipment will be delivered to. DO_CTL_INV ID_PRTY_TO_ICD null null Yes Contains the location that the shipment will be delivered to. from_location varchar210 1 1 For transfer and allocation shipments, this field will hold the location from which the shipment was sourced. DO_CTL_INV ID_PRTY_FM_ICD null null Yes For transfer and return to warehouse shipments, this field will hold the location from which the shipment was sourced. asn_nbr varchar230 0 1 Holds the bill of lading number associated with a shipment. DO_CTL_INV ASN_NUM null null No Holds the bill of lading number associated with a shipment 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. n/a n/a null null No Specifies the type of ASN. 'C' - Container, 'I' - Item container_qty number6 0 1 Contains the number of boxes associated with the shipment. n/a n/a null null No Contains the number of boxes associated with the shipment bol_nbr varchar217 1 1 Holds the transaction sequence number on the message from the transfer shipment confirmation process. DO_CTL_INV ID_ICD null null No Holds the transaction or return sequence number on the message from the transfer shipment confirmation process. shipment_date xs:dateTime 0 1 This field contains the date the transfer or PO was shipped. DO_CTL_INV DC_SPRC_ACT_SHP null null No This field contains the date 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. n/a n/a null null No Populated with null value by SIM 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) n/a n/a null null No Populated with an empty value by SIM 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) n/a n/a null null No Populated with an empty value by SIM ship_address3 varchar2240 0 1 Not used by RMS. n/a n/a null null No Populated with an empty value by SIM ship_address4 varchar2240 0 1 Not used by RMS. n/a n/a null null No Populated with an empty value by SIM ship_address5 varchar2240 0 1 Not used by RMS. n/a n/a null null No Populated with an empty value by SIM 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) n/a n/a null null No Populated with an empty value by SIM 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) n/a n/a null null No Populated with an empty value by SIM ship_zip varchar230 0 1 Not used by RMS. n/a n/a null null No Populated with an empty value by SIM 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) n/a n/a null null No Populated with an empty value by SIM trailer_nbr varchar212 1 1 Not used by RMS. n/a n/a null null No Populated with an empty value by SIM seal_nbr varchar212 0 1 Not used by RMS. n/a n/a null null No Populated with an empty value by SIM carrier_code varchar24 1 1 Contains the courier that will deliver the shipment. n/a n/a null null No Populated with an empty value by SIM transshipment_nbr varchar230 0 1 Not used by RMS. n/a n/a null null No Populated with an empty value by SIM ASNOutDistro * 0 unbounded Description is not available. comments varchar22000 0 1 Contains any miscellaneous comments about the shipment. DO_CTL_INV COMMENT_DESC VARCHAR2 300 No Not Yet Available ExtOfASNOutDesc:ExtOfASNOutDesc * 0 1 Provide an extension hook to customize ASNOutDesc. NA NA NA NA NA NA

XML-Schema Name:ASNOutDistro Version:13.1 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. DO_CTL_INV ID_ICD null null 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. n/a n/a null null Yes Specifiy the distro doc type for the transfer or return. 'T' - Transfer, 'C' - Customer Order, 'D' - distro, 'V'-Vendor customer_order_nbr varchar210 1 1 Not used by RMS. n/a n/a null null No Populated with empty value by SIM consumer_direct varchar21 0 1 Not used by RMS. n/a n/a null null No Populated with empty value by SIM ASNOutCtn * 1 unbounded Description is not available. comments varchar22000 0 1 Not used by RMS. n/a n/a null null No Not used by SIM ExtOfASNOutDesc:ExtOfASNOutDistro * 0 1 Provide an extension hook to customize ASNOutDistro. NA NA NA NA NA NA

XML-Schema Name:ASNOutCtn Version:13.1 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. DO_CTL_INV ID_PRTY_TO_ICD VARCHAR2 128 No Not Yet Available 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. DO_CTL_INV ID_ICD VARCHAR2 128 Yes Not Yet Available container_weight number12_4 0 1 Not used by RMS. n/a n/a null null No Populated with empty value by SIM container_length number12_4 0 1 Not used by RMS. null null null null null container_width number12_4 0 1 Not used by RMS. null null null null null container_height number12_4 0 1 Not used by RMS. null null null null null container_cube number12_2 0 1 Not used by RMS. null null null null null 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 null 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 null null null null rma_nbr varchar220 0 1 Not used by RMS. null null null null null tracking_nbr varchar225 0 1 Not used by RMS. null null null null null freight_charge number20_4 0 1 Not used by RMS. null null null null null master_container_id varchar220 0 1 Not used by RMS. null null null null null ASNOutItem * 1 unbounded Description is not available. comments varchar22000 0 1 Not used by RMS. null null null null null weight number12_4 0 1 Actual weight shipped for the container. null null null null null weight_uom varchar24 0 1 Unit of measurement for weight (e.g. pounds, kilograms) that was shipped. null null null null null ExtOfASNOutDesc:ExtOfASNOutCtn * 0 1 Provide an extension hook to customize ASNOutCtn. NA NA NA NA NA NA

XML-Schema Name:ASNOutItem Version:13.1 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. 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 advance shipment notification for this item/shipment combination. TR_LTM_ICD_MR QU_ITM NUMBER 20,4 No Not Yet Available priority_level number1 0 1 Not used by RMS. null null null null null order_line_nbr number4 0 1 Not used by RMS. null null null null null lot_nbr varchar212 0 1 Not used by RMS. null null null null null final_location varchar210 0 1 Not used by RMS. DO_CTL_INV ID_PRTY_TO_ICD VARCHAR2 128 No Not Yet Available 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. null varchar2 4 null null to_disposition varchar24 0 1 Not used by RMS. null null null null null voucher_number varchar216 0 1 This type can hold a number of digits count r_number. null null null null null voucher_expiration_date xs:dateTime 0 1 Not used by RMS. null null null null null container_qty number6 0 1 Not used by RMS. null null null null null comments varchar22000 0 1 Not used by RMS. null null null null null unit_cost number20_4 0 1 Not used by RMS. null null null null null weight number12_4 0 1 Actual weight shipped. null null null null null weight_uom varchar24 0 1 Unit of measurement for weight (e.g. pounds, kilograms) shipped. null null null null null ExtOfASNOutDesc:ExtOfASNOutItem * 0 1 Provide an extension hook to customize ASNOutItem. NA NA NA NA NA NA

XML-Schema Name:ExtOfASNOutItem Version:13.1 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:ExtOfASNOutCtn Version:13.1 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:ExtOfASNOutDistro Version:13.1 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:ExtOfASNOutDesc Version:13.1 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