Wednesday, July 8, 2009

[OM] Ship Confirm and Interface - Fields Change

Some useful info on the field value change for Ship Confirm action:

wsh_delivery_details (WDD)
shipped_quantity updated
released_status = C (from Y)

wsh_new_deliveries (WND)
status_code = CL (from OP)
confirmed_by updated (Shipped-by Person Oracle id)
confirmed_date updated
itinerary_complete = Y (from blank)

wsh_delivery_assignments (WDA)
No-change

After Interface Trip Stop:
WDD
oe_interfaced_flag = Y (from N)
inv_interfaced_flag = Y (from N)

WND
No-change

0 comments: