The following table lists the format for importing pick demand status update data from a WMS. Each record is a caret-delimited row in the import file.
|
Position |
Field Name |
Required |
Description |
|
1 |
WMSSTAT |
Yes |
This is WMSSTAT to indicate the record is a pick demand status update record. |
|
2 |
Location Prefix |
Yes |
This is the location prefix. |
|
3 |
Pick Demand Number |
Yes |
This is the Apprise pick demand number. |
|
4 |
Original Sequence Number |
No |
If this is blank, all trailer records are updated. |
|
5 |
WMS Status |
No |
This is the pick demand status stored in oe-pick-ticket-trl.wms-status. |
|
6 |
WMS Transaction Date |
No |
This is the date the transaction occurred in the WMS. This defaults to the current date. |
|
7 |
WMS Transaction Time |
No |
This is the time the transaction occurred in the WMS. This defaults to the current time. |
|
8 |
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. |
|
9 |
WMS Pick Demand Number |
No |
This is used when inquiring in Apprise to provide visibility for the WMS pick demand number. This is informational only. |