Demand Order

Demand Orders refer to existing Parts.

Notes on Quantity

As there may be multiple Demand Orders for a particular part for any given day, it is assumed the Quantity of all orders will be aggregated and only the total for the entire day reported in the Quantity field. Note that if a Quantity has already been reported for a particular part for a given day, and a subsequent Quantity is reported in the same Import, or any future import, only the latest Quantity will be retained.

Column Name
Type
Max Length
Required
Values

PartNumber

text

50

Yes

Must match a valid Part Number, Revision and Location in the parts data

Revision

text

10

No

Location

text

32

No

LineItem

text

50

No

DemandType

integer

Yes

  • 0 or SO = Sales Order

  • 1 or WO = Work Order

  • 2 or TO = Transfer Order

  • 3 or PO = Purchase Order

OrderDate

date

Yes

DueDate

date

Yes

Quantity

decimal

18.5

Yes

>= 0

Customer

text

100

No

CustomerIdentifier

text

100

No

Notes

text

250

No

OrderNumber

text

50

Yes

SourceErp

text

100

No

Last updated