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. |