? 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";
|