 |
Retail Integration Bus Mappings Report
|
 |
|
| Application Name: Retail Warehouse Management System |
|
XML-Schema or Node Name:ASNOutDesc.xsd |
| Tag Name | Table Name | Column Name | API Req | Description |
| to_location | ship_dest | dest_id | Yes | * |
| from_location | transshipment_setup | dc_dest_id | Yes | * |
| asn_nbr | computed | * | No | * |
| asn_type | calculated | * | No | * |
| container_qty | computed | * | No | * |
| bol_nbr | bol_to_upload | bol_nbr | Yes | * |
| shipment_date | manifest | ship_ts | No | * |
| est_arr_date | ship_dest | lead_time | No | * |
| ship_address1 | ship_dest | address1 | No | * |
| ship_address2 | ship_dest | address2 | No | * |
| 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 | ship_dest | city | No | * |
| ship_state | ship_dest | state | No | * |
| ship_zip | ship_dest | zip | No | * |
| ship_country_id | ship_dest | country_code | No | * |
| trailer_nbr | manifest | trailer_id | Yes | * |
| seal_nbr | manifest | seal_nbr | No | * |
| carrier_code | trailer | carrier_code | Yes | * |
| transshipment_nbr | manifest | transshipment_nbr | No | * |
| ASNOutDistro | * | * | * | * |
| comments | n/a | n/a | No | Not used in RWMS. |
| Application Name: Retail Warehouse Management System |
|
XML-Schema or Node Name:ASNOutDistro |
| Tag Name | Table Name | Column Name | API Req | Description |
| distro_nbr | container_item | distro_nbr | Yes | * |
| distro_doc_type | stock_order | document_type | Yes | * |
| customer_order_nbr | stock_order | cust_order_nbr | Yes | * |
| consumer_direct | stock_order | consumer_direct | No | * |
| ASNOutCtn | * | * | * | * |
| comments | n/a | n/a | No | Not used in RWMS. |
| Application Name: Retail Warehouse Management System |
|
XML-Schema or Node Name:ASNOutCtn |
| Tag Name | Table Name | Column Name | API Req | Description |
| final_location | container | dest_id | No | * |
| 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 | * | tracking_nbr | No | * |
| freight_charge | * | freight_charge | No | * |
| master_container_id | container | master_container_id | No | * |
| ASNOutItem | * | * | * | * |
| comments | n/a | n/a | No | Not used in RWMS. |
| weight | * | * | * | * |
| weight_uom | * | * | * | * |
| Application Name: Retail Warehouse Management System |
|
XML-Schema or Node Name:ASNOutItem |
| Tag Name | Table Name | Column Name | API Req | Description |
| item_id | container_item | item_id | Yes | * |
| unit_qty | container_item | unit_qty | Yes | * |
| priority_level | container_item | priority_level | No | * |
| order_line_nbr | * | * | No | * |
| lot_nbr | container | lot_nbr | No | * |
| final_location | * | * | No | * |
| from_disposition | * | * | No | * |
| to_disposition | * | * | No | * |
| voucher_number | * | * | No | * |
| voucher_expiration_date | * | * | No | * |
| container_qty | computed | * | No | * |
| comments | n/a | n/a | No | Not used in RWMS. |
| unit_cost | n/a | n/a | No | * |
| weight | * | * | * | * |
| weight_uom | * | * | * | * |