WMS Confirmation Import Format

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

Position

Field Name

Required

Description

1

WMSCONF

Yes

This is WMSCONF to indicate the record is a WMS confirmation record.

2

Location Prefix

Yes

This is the location prefix.

3

Transaction Type

Yes

This is Pick Demand, PO, Container, Material Issue, Product, or Return.

4

Transaction Number

Yes

This is the transaction number.

5

Transaction Line Number

No

This is the operation sequence (only used when issuing material).

6

Transaction Sequence

No

This is blank to confirm all transactions for the transaction number.

7

WMS Transaction Date

No

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

8

WMS Transaction Time

No

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

9

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.