Dispatch: Update Undeliverd Load to a Deliverd Load

From KeystoneIntranet
Jump to navigation Jump to search

Change "Undelivered" Load to a "Delivered" Load

update ditprjld l
set trucK_no='74', depart_dt='10/18/07 13:05',STATUS_COL=1, STATUS_DATETIME='10/18/07 13:05'
where order_session_no=18204  and order_trans_no=16 and load_no=1

Assumptions:

  • Load has been delivered
  • Ticket in ARTPTKHD points to this load
  • Truck in ARTTRUCK is properly linked for GPS Status information
Retrieved from "http://in.compucrete.com/index.php?title=Dispatch:_Update_Undeliverd_Load_to_a_Deliverd_Load&oldid=150"