WMS Material Confirmation Import Format

The following tables list the format for importing material confirmation data from a WMS. Each record is a caret-delimited row in the import file.

Header Record

Position

Field Name

Required

Description

1

MFGHDR

Yes

This is MFGHDR to indicate the record is a header record.

2

Location Prefix

Yes

This is the location prefix.

3

Work Order Number

Yes

This is the work order number.

4

Operation Sequence

No

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

5

Confirm Date

No

This defaults to the current date.

6

Adjust Option

No

This is the inventory adjust option. It defaults to NO.

7

As Is Option

No

If this is YES, confirm as is.

8

WMS Transaction Date

No

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

9

WMS Transaction Time

No

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

10

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.

Trailer Record

Position

Field Name

Required

Description

1

MFGTRL

Yes

This is MFGTRL to indicate the record is a trailer record.

2

Operation Sequence

Yes

This is the operation sequence number.

3

Product Code

Yes

This is the product code.

4

Phantom Assembly Product Code

No

This is the phantom assembly product code.

5

Selected Quantity

Yes

This is the confirmed issued quantity.

6

Unit of Measure

No

If this is blank, it defaults to the recommended unit of measure.

7

Break-From Unit of Measure Code

No

This is the break-from unit of measure code.

8

Recommended Bin

Yes

This is the recommended bin.

9

Recommended Lot

No

This is the recommended lot for products tracked by lot.

10

Recommended Serial Number

No

This is the recommended serial number for products tracked by serial number.

11

Bin

No

If this is blank, it defaults to the recommended bin.

12

Lot

No

If this is blank, it defaults to the recommended lot.

13

Serial Number

No

If this is blank, it defaults to the recommended serial number.