 |
Retail Integration Bus Mappings Report
Release: 13.0.1 |
 |
|
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:ASNOutDesc.xsd |
| Tag Name | Table Name | Column Name | API Req | Description |
| to_location | shipment . | to_loc | Yes | Contains the location that the shipment will be delivered to. |
| from_location | shipment | from_loc | Yes | For transfer and allocation shipments, this field will hold the location from which the shipment was sourced. |
| asn_nbr | shipment | bol_no | No | Holds the bill of lading number associated with a shipment. |
| asn_type | n/a | n/a | No | Not used by RMS. C for container, T for tare. |
| container_qty | shipment | no_boxes | No | Contains the number of boxes associated with the shipment. Default to 1. |
| bol_nbr | shipment | ext_ref_no_out | Yes | Holds the transaction sequence number on the message from the transfer shipment confirmation process. |
| shipment_date | shipment | ship_date | No | This field contains the date the transfer or PO was shipped. |
| est_arr_date | shipment | est_arr_date | No | 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. |
| ship_address1 | n/a | n/a | No | Not used by RMS. |
| ship_address2 | n/a | n/a | No | Not used by RMS. |
| ship_address3 | n/a | n/a | No | Not used by RMS. |
| ship_address4 | n/a | n/a | No | Not used by RMS. |
| ship_address5 | n/a | n/a | No | Not used by RMS. |
| ship_city | n/a | n/a | No | Not used by RMS. |
| ship_state | n/a | n/a | No | Not used by RMS. |
| ship_zip | n/a | n/a | No | Not used by RMS. |
| ship_country_id | n/a | n/a | No | Not used by RMS. |
| trailer_nbr | n/a | n/a | Yes | Not used by RMS. |
| seal_nbr | n/a | n/a | No | Not used by RMS. |
| carrier_code | shipment | courier | No | Contains the courier that will deliver the shipment. |
| transshipment_nbr | n/a | n/a | No | Not used by RMS. |
| ASNOutDistro | * | * | * | * |
| comments | shipment | comments | No | Contains any miscellaneous comments about the shipment. |
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:ASNOutDistro |
| Tag Name | Table Name | Column Name | API Req | Description |
| distro_nbr | shipsku | distro_no | Yes | Specifies the transfer or allocation number associated with the shipment/item/carton. |
| distro_doc_type | n/a | n/a | Yes | Specifies what the distro_nbr field corresponds to in RMS: V, D, and T specify transfer, A specifies Allocation. |
| customer_order_nbr | n/a | n/a | No | Not used by RMS. |
| consumer_direct | n/a | n/a | No | Not used by RMS. |
| ASNOutCtn | * | * | * | * |
| comments | n/a | n/a | No | Not used by RMS. |
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:ASNOutCtn |
| Tag Name | Table Name | Column Name | API Req | Description |
| final_location | shipment | to_loc | No | Not used by RMS. |
| container_id | shipsku | carton | Yes | 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. |
| container_weight | n/a | n/a | No | Not used by RMS. |
| container_length | n/a | n/a | No | Not used by RMS. |
| container_width | n/a | n/a | No | Not used by RMS. |
| container_height | n/a | n/a | No | Not used by RMS. |
| container_cube | n/a | n/a | No | Not used by RMS. |
| expedite_flag | n/a | n/a | No | Not used by RMS. |
| in_store_date | n/a | n/a | No | Not used by RMS. |
| rma_nbr | n/a | n/a | No | Not used by RMS. |
| tracking_nbr | n/a | n/a | No | Not used by RMS. |
| freight_charge | n/a | n/a | No | Not used by RMS. |
| master_container_id | n/a | n/a | No | Not used by RMS. |
| ASNOutItem | * | * | * | * |
| comments | n/a | n/a | No | Not used by RMS. |
| weight | shipsku | weight_expected | No | Actual weight shipped for the container. |
| weight_uom | shipsku | weight_expected_uom | No | Unit of measurement for weight (e.g. pounds, kilograms) that was shipped. |
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:ASNOutItem |
| Tag Name | Table Name | Column Name | API Req | Description |
| item_id | shipsku | item | Yes | Unique identifier for the item. |
| unit_qty | shipsku | qty_expected | Yes | Contains the number of items expected to be received based on the supplier's advance shipment notification for this item/shipment combination. |
| priority_level | n/a | n/a | No | Not used by RMS. |
| order_line_nbr | n/a | n/a | No | Not used by RMS. |
| lot_nbr | n/a | n/a | No | Not used by RMS. |
| final_location | shipment | to_loc | No | Not used by RMS. |
| from_disposition | inv_status_codes | inv_status_code | No | 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. |
| to_disposition | n/a | n/a | No | Not used by RMS. |
| voucher_number | n/a | n/a | No | Not used by RMS. |
| voucher_expiration_date | n/a | n/a | No | Not used by RMS. |
| container_qty | n/a | n/a | No | Not used by RMS. Default to 1. |
| comments | n/a | n/a | No | Not used by RMS. |
| unit_cost | n/a | n/a | No | Not used by RMS. |
| weight | shipsku | weight_expected | No | Actual weight shipped. |
| weight_uom | shipsku | weight_expected_uom | No | Unit of measurement for weight (e.g. pounds, kilograms) shipped. |