ForceField MWG Order Type and what it Means
All Open:
all new orders that have not been uploaded
ORDHEAD.ORDSTAT = 'new'
New:
new orders that are completed but not uploaded
ORDHEAD.ORDSTAT = 'new'
AND has at least one line item, or ORDHEAD.STDINSTR = "No Product"
Call:
new orders that have not been completed yet
ORDHEAD.ORDSTAT = 'new'
AND has no line items
AND ORDHEAD.STDINSTR <> "No Product"
Hold:
new orders that are on hold (cannot be uploaded)
ORDHEAD.ORDSTAT = 'new'
AND a required field value is missing
(does not apply to FUI MWG since they have no required fields:
REQUIRE_TERMS=false
REQUIRE_SHIPVIA=false
REQUIRE_CUSTPO=false
)