Cust.vwOrdersHeld

Will display all the held orders on the system at the time it is run.

Output

Field Name	Notes

Field Name	Notes
UID	Order UID - a unique identifier for each order
Site	The site code as defined in the sites table normally 2 digit site identifier
Order Type	See code list (2)
CustomerCode
CustomerName
Doc Ref	Unique Document Reference Number usually provider by the customer but could be the same as the UID when "use UID" is used at order entry stage
Order Date	The date the order is entered on the system
Held Reason	Usually self explanatory
Receiving Customer	If the order is a type T (Transfer) then the receiving customer code is shown
EDI	Y or N field indicating whether this order came from EDI system (or VCIS order)

Conditions

Status of Order is not 99 (Cancelled)

If Held by User (VCIS User ) then it will not display the order in the Held orders report.