Close Window

How to:
Procedure on how to add or modify the shipper information for Walmart DC 6003.
Skill required to complete this article: Software ~ Order Fulfillment Pick-To-Light and level is Intermediate.
? First step is to check if the store exists or not in the database, if it exists, we just need to modify the shipper_info table.
? Secondly, is to ask customer the following details from shipper_info table:
? Example ticket: TS-00374022 (INC19810321) 

Example query:

select first 1 * from shipper_info;

consignee_id       137
contact_name       DIV-11
name               WAL-MART STORE 0137
address_1          111 N PERKINS RD
address_2
address_3
city               STILLWATER
country_id         US
postal_code        74075
state_prov         OK
telephone
def_ser_lv         20
priority_svl_lvl   24
service_value      6
service_code       NAS
manual_sort_1      PNC
manual_sort_2      4N
manual_sort_3      ILH
last_updated_by    0
date_last_updated  1131985166
status             0





So, we need the following

consignee_id
contact_name
name 
address_1
address_2
address_3
city
country_id,
postal_code
state_prov
telephone
def_ser_lv
priority_svl_lvl





These below details need to populate from the database 

service_code
manual_sort_1
manual_sort_2
manual_sort_3
last_updated_by
date_last_updated
status

Additionally, we would also be needing Delivery service information, All we need is service_indicator and shipment type from the customer.

If you want to know the type of delivery code provided by customer, below is an example query:

> select first 1 * from delivery_service;

service_indicator                  20
service_icon                          0
show_black_square               0
shipment_type                      Ground
service_titles
service_details
last_updated_by                    0
date_last_updated                  0
status                                      1



service_indicator                    shipment_type

20                     Ground
19                                   Express Saver (3 Days)
22                                   Two Day
24                                   Standard Overnight
23                                   Priority Overnight
99                                   Dummy International


Customer will provide the necessary details:

This the example for service indicator (def_ser_lv =20) and shipment type (priority_svl_lvl=24)

Login onto site and enter database


SPECIALTY:us06003s1110d0a/u/intelligrated/appdata/rtsinc/ep2log/log % dbaccess $DB_SQL -

Database selected.

> select consignee_id from shipper_info where def_ser_lv = 20 and priority_svl_lvl = 24;


consignee_id

137
1370
1371
1372
1373
1374
1375
1376
1377
1378
1379
138
1380
1381
3912

Make a unload in rtsinc /upgrade.

We need to unload one of the consignee stores into the new store we are creating. For example, I’m creating here for store 8386, I want all the details that are in the store 3912. I save these details into shipper_info_8386.unl file

> unload to shipper_info_8386.unl select * from shipper_info where consignee_id = "3912";


 I have to VI the shipper_info_8386.unl and change the details provided by the customer. 

Once the shipper_info_8386.unl is modified we need to load this file into database. 

Install instructions.

On each server, go to the rtsinc /upgrade

1. SPECIALTY:us06003s1110d0a/u/intelligrated/rtsinc/upgrade % dbaccess $DB_SQL -

2. load from shipper_info_8386.unl insert into shipper_info;


Backout Instructions :-

1. dbaccess $DB_SQL -
    delete from shipper_info where consignee_id = "8386";
 Related Articles
No Related Articles Available.
 Article Info
 Article ID:  KB-11474
 Published on  12/19/2022
 Last Modified on  12/19/2022
 Last Modified by  Paul Menkes
 Original URL:  https://dashboard.intelligrated.com//Knowledgebase/Article.aspx?article=e9cbf8e4-45f6-4d53-a2e7-6448a544d696
Close Window