Dispatch: Update Undeliverd Load to a Deliverd Load: Difference between revisions

From KeystoneIntranet
Jump to navigation Jump to search
Intra>User
m (1 revision imported)
(No difference)

Revision as of 00:01, 10 January 2017

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=149"