 |
Retail Integration Bus Mappings Report
Release: 13.0.0 |
 |
|
| Application Name: Retail Merchandising System |
Version 13.0.0 |
XML-Schema or Node Name:ASNInDesc.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 | n/a | n/a | Yes | Not used by RMS. |
| asn_nbr | shipment | asn | Yes | Holds the advance shipping notice number associated with a shipment. |
| asn_type | n/a | n/a | Yes | 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). |
| container_qty | n/a | n/a | Yes | Not used by RMS. |
| bol_nbr | shipment | ext_ref_no_in | No | Holds the transaction sequence number on the input message from the receiving PO or transfer process. |
| shipment_date | shipment | ship_date | Yes | 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 | No | 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. |
| vendor_nbr | ordhead | supplier | Yes | 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. |
| ship_pay_method | ordhead | ship_pay_method | No | 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. |
| ASNInPO | * | * | * | * |
| comments | n/a | n/a | No | Not used by RMS. |
| Application Name: Retail Merchandising System |
Version 13.0.0 |
XML-Schema or Node Name:ASNInPO |
| Tag Name | Table Name | Column Name | API Req | Description |
| po_nbr | shipment | order_no | Yes | 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. |
| doc_type | n/a | n/a | Yes | Not used by RMS. |
| not_after_date | ordhead | not_after_date | No | Contains the last date that delivery of the order will be accepted. |
| comments | n/a | n/a | No | Not used by RMS. |
| ASNInCtn | * | * | * | * |
| ASNInItem | * | * | * | * |
| Application Name: Retail Merchandising System |
Version 13.0.0 |
XML-Schema or Node Name:ASNInCtn |
| Tag Name | Table Name | Column Name | API Req | Description |
| final_location | carton | location | Yes | 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. |
| container_id | carton | carton | Yes | Holds the UCC-128 carton number. |
| 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. |
| ASNInItem | * | * | * | * |
| comments | n/a | n/a | No | Not used by RMS. |
| Application Name: Retail Merchandising System |
Version 13.0.0 |
XML-Schema or Node Name:ASNInItem |
| Tag Name | Table Name | Column Name | API Req | Description |
| final_location | alloc_detail | to_loc | Yes | 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. |
| item_id | shipsku | item | Yes | Unique identifier for the item. Either vpn, item_id, or ref_item must be specified in the message. |
| unit_qty | shipsku | qty_expected | Yes | Contains the number of items expected to be received based on the supplier's ASN for this Item/Shipment combination. |
| priority_level | n/a | n/a | No | Not used by RMS. |
| vpn | item_supplier | vpn | No | 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. |
| order_line_nbr | n/a | n/a | No | Not used by RMS. |
| lot_nbr | n/a | n/a | Yes | Not used by RMS. |
| ref_item | shipsku | ref_item | No | Contains a reference item to the item field. Either vpn, item_id, or ref_item must be specified in the message. |
| distro_nbr | n/a | n/a | Yes | Not used by RMS. |
| distro_doc_type | n/a | n/a | No | Not used by RMS. |
| container_qty | n/a | n/a | No | Not used by RMS. |
| comments | n/a | n/a | No | Not used by RMS. |