About shipping information

Post date: Nov 14, 2013 11:11:51 PM

There are some inconsistency within some tables:

The table "D_UNIFIED_CUST_SHIPMENT_ITEMS" does not contain any value for attributes "promised_ship_day" and "promised_arrival_day". The variable "ship_day" is somehow corresponding to "Charged Day" in IWB. The "order_day" is consistent with IWB.

For example:

The queried data show:

seller_id 385199957

buyer_id 106-5922040-3849036

Order Id 002-2092729-1563466

order_day 29-Mar-13

promised_ship_day ????

ship_day 30-Mar-13

Ship Method -1

customer_ship_option Std Cont US Street Addr

promised_arrival_day ????

Appeared on IWB as

So, the ship_day in the table is corresponding to Charged day in the IWB.

Max EDD is not in this table!!!!!

But this table is pretty fast, taking only 2 min

Now let's test D_CUST_SHIPMENT_ITEM_PKGS

I might take much longer using this table.

This table does contain:

,dcsip.ship_day

,dcsip.PROMISED_DELIVERY_DATETIME

,dcsip.ACTUAL_DELIVERY_DATETIME

,dcsip.CLOCK_STOP_EVENT_DATETIME

but not order_entry_day.

takes 11 min to run

ship_day: 30Mar2013

Now consider D_OUTBOUND_SHIPMENT_PACKAGES

This table does not have order_id

Need to verify the max EDD and ship_day

Here is the summary:

c