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
)


Article Details

Article ID:
159
Category:
Date added:
2013-01-16 17:46:47
Views:
549
Rating (Votes):
(628)