WMS Material Cancellation Import Format

The following table lists the format for importing material cancellation data from a WMS. Each record is a caret-delimited row in the import file.

Position

Field Name

Required

Description

1

MFGCANCEL

Yes

This is MFGCANCEL to indicate the record is a material cancellation record.

2

Location Prefix

Yes

This is the location prefix.

3

Work Order Number

Yes

This is the work order number.

4

Sequence Number

No

This is the operation sequence number. If it is blank, it indicates the record is for all sequence numbers.

5

WMS Transaction Date

No

This is the date the transaction occurred in the WMS. This defaults to the current date.

6

WMS Transaction Time

No

This is the time the transaction occurred in the WMS. This defaults to the current time.

7

WMS Import Key

No

This is a key value used to differentiate between WMS transactions. If this is imported, it must be a unique value that was not previously associated with a WMS transaction.