 |
Retail Integration Bus Mappings Report
|
 |
|
| Application Name: Retail Warehouse Management System |
|
XML-Schema or Node Name:ASNInDesc.xsd |
| Tag Name | Table Name | Column Name | API Req | Description |
| to_location | n/a | n/a | Yes | Not used in RWMS |
| from_location | n/a | n/a | Yes | Not used in RWMS |
| asn_nbr | asn | asn_nbr | Yes | * |
| asn_type | asn | asn_type | Yes | * |
| container_qty | asn | container_qty | Yes | * |
| bol_nbr | asn | bol_nbr | No | * |
| shipment_date | n/a | n/a | Yes | Not used in RWMS. |
| est_arr_date | n/a | n/a | No | Not used in RWMS. |
| ship_address1 | n/a | n/a | No | Not used in RWMS. |
| ship_address2 | n/a | n/a | No | Not used in RWMS. |
| ship_address3 | n/a | n/a | No | Not used in RWMS. |
| ship_address4 | n/a | n/a | No | Not used in RWMS. |
| ship_address5 | n/a | n/a | No | Not used in RWMS. |
| ship_city | n/a | n/a | No | Not used in RWMS. |
| ship_state | n/a | n/a | No | Not used in RWMS. |
| ship_zip | n/a | n/a | No | Not used in RWMS. |
| ship_country_id | n/a | n/a | No | Not used in RWMS. |
| trailer_nbr | n/a | n/a | No | Not used in RWMS. |
| seal_nbr | n/a | n/a | No | Not used in RWMS. |
| carrier_code | asn | carrier_code | No | * |
| vendor_nbr | po | vendor_nbr | Yes | * |
| ship_pay_method | n/a | n/a | No | Not used in RWMS. |
| ASNInPO | * | * | * | * |
| comments | * | * | * | * |
| Application Name: Retail Warehouse Management System |
|
XML-Schema or Node Name:ASNInPO |
| Tag Name | Table Name | Column Name | API Req | Description |
| po_nbr | po_detail | po_nbr | Yes | * |
| doc_type | po | doc_type | Yes | * |
| not_after_date | po | deliv_not_after_date | No | * |
| comments | * | * | * | * |
| ASNInCtn | * | * | * | * |
| ASNInItem | * | * | * | * |
| Application Name: Retail Warehouse Management System |
|
XML-Schema or Node Name:ASNInCtn |
| Tag Name | Table Name | Column Name | API Req | Description |
| final_location | container | dest_id | Yes | * |
| container_id | container | container_id | Yes | * |
| container_weight | container | container_weight | No | * |
| container_length | container | container_length | No | * |
| container_width | container | container_width | No | * |
| container_height | container | container_height | No | * |
| container_cube | container | container_cube | No | * |
| expedite_flag | container | expedite_flag | No | * |
| in_store_date | container | in_store_date | No | * |
| rma_nbr | container | rma_nbr | No | * |
| tracking_nbr | n/a | n/a | No | Not used in RWMS |
| freight_charge | container | freight_charge | No | * |
| master_container_id | n/a | n/a | No | Not used in RWMS |
| ASNInItem | * | * | * | * |
| comments | * | * | * | * |
| Application Name: Retail Warehouse Management System |
|
XML-Schema or Node Name:ASNInItem |
| Tag Name | Table Name | Column Name | API Req | Description |
| final_location | asn_item | dest_id | Yes | * |
| item_id | po_detail | item_id | Yes | * |
| unit_qty | asn_item | unit_qty | Yes | * |
| priority_level | container_item | priority_level | No | * |
| vpn | * | * | * | * |
| order_line_nbr | n/a | n/a | No | Not used in RWMS. |
| lot_nbr | n/a | n/a | Yes | Not used in RWMS. |
| ref_item | n/a | n/a | No | Not used in RWMS. |
| distro_nbr | container_item | distro_nbr | Yes | * |
| distro_doc_type | n/a | n/a | No | Not used in RWMS. |
| container_qty | container_item | container_qty | No | * |
| comments | * | * | * | * |
| final_location | asn_item | dest_id | Yes | * |
| item_id | po_detail | item_id | Yes | * |
| unit_qty | asn_item | unit_qty | Yes | * |
| priority_level | container_item | priority_level | No | * |
| vpn | * | * | * | * |
| order_line_nbr | n/a | n/a | No | Not used in RWMS. |
| lot_nbr | n/a | n/a | Yes | Not used in RWMS. |
| ref_item | n/a | n/a | No | Not used in RWMS. |
| distro_nbr | container_item | distro_nbr | Yes | * |
| distro_doc_type | n/a | n/a | No | Not used in RWMS. |
| container_qty | container_item | container_qty | No | * |
| comments | * | * | * | * |