The following tables list the format for importing pick demand confirmation data from a WMS. Each record is a caret-delimited row in the import file.
Position |
Field Name |
Required |
Description |
1 |
PICKHDR |
Yes |
This is PICKHDR to indicate the record is a header record. |
2 |
Location Prefix |
Yes |
This is the location prefix. |
3 |
Pick Demand Number |
Yes |
This is the Apprise pick demand number. |
4 |
Shipper ID |
No |
This is the shipper ID. |
5 |
Confirm Date |
No |
This defaults to the current date. |
6 |
As Is Option |
No |
If this is YES, confirm the pick demand as is. |
7 |
Packing Slip Option |
No |
This defaults to NO if the location option to adjust demands is Ask. |
8 |
Adjust Option |
No |
This defaults to NO if the location option to adjust demands is Ask. |
9 |
Invoice Option |
No |
This defaults to NO if the location option to adjust demands is Ask. |
10 |
Fully Confirmed |
No |
This is one of the following values:
|
11 |
Picked By |
No |
This is the user that picked the pick demand. |
12 |
Packed By |
No |
This is the user that packed the pick demand. |
13 |
Single Package |
No |
If this is YES, Package and Tag records are not required, and all trailer records are automatically packaged in a single new package. |
14 |
Use Package Unit of Measure |
No |
If this is YES, Package and Tag records are not required, and all trailer records are automatically packaged based on package units of measure. |
15 |
Laydown Bin |
No |
This is a bin to override the default package laydown bin. |
16 |
Route Number |
No |
This is the route number. |
17 |
Stop Number |
No |
This is the stop number. |
18 |
WMS Transaction Date |
No |
This is the date the transaction occurred in the WMS. This defaults to the current date. |
19 |
WMS Transaction Time |
No |
This is the time the transaction occurred in the WMS. This defaults to the current time. |
20 |
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. |
21 |
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. |
22 |
Freight Collection Terms |
No |
This is the freight collection terms. |
23 |
Load Number |
No |
This is the load number. |
Position |
Field Name |
Required |
Description |
1 |
PICKTRL |
Yes |
This is PICKTRL to indicate the record is a trailer record. |
2 |
Original Sequence |
Yes |
This is the line number on the pick ticket. |
3 |
Product Code |
No |
This defaults to the product code for the Original Sequence field (position 2). |
4 |
Picked Quantity |
Yes |
This is the quantity picked of the product. |
5 |
Unit of Measure Code |
No |
This defaults to the recommended unit of measure. |
6 |
Bin |
No |
This defaults to the recommended bin when it is blank. |
7 |
Lot |
No |
This is the lot of the picked product if the product is tracked by lot. |
8 |
Serial Number |
No |
This is the serial number of the picked product if the product is tracked by serial number. |
Position |
Field Name |
Required |
Description |
1 |
PICKPKG |
Yes |
This is PICKPKG to indicate the record is a package record. |
2 |
UCC128 Number |
Yes |
This is the UCC128 number for the package. |
3 |
Weight |
No |
This is the weight of the package. |
4 |
Weight Unit of Measure |
No |
This is the weight unit of measure for the package. |
5 |
Dimension Unit of Measure |
No |
This is the dimension unit of measure for the package. |
6 |
Cube Unit of Measure |
No |
This is the cube unit of measure for the package. |
7 |
Length |
No |
This is the length of the package. |
8 |
Width |
No |
This is the width of the package. |
9 |
Height |
No |
This is the height of the package. |
10 |
Pallet ID |
No |
This is the pallet ID of the package. |
11 |
Tracking Number |
No |
This is the shipper's tracking number for the package. |
12 |
Banding Number |
No |
This is the banding number for the package (if applicable). |
13 |
Bill of Lading Number |
No |
If the bill of lading number does not exist in Apprise, and a value is imported for this field, a new bill of lading is created in Apprise. |
14 |
Master Bill of Lading Number |
No |
This is the master bill of lading number for the package. |
15 |
Appointment Number |
No |
This is the appointment number for the package. |
16 |
PRO Number |
No |
This is the PRO number for the package. |
17 |
Seal Number |
No |
This is the seal number for the package. |
18 |
Carton Code |
No |
This is the carton code for the package. |
Position |
Field Name |
Required |
Description |
1 |
PICKTAG |
Yes |
This is PICKTAG to indicate the record is a tag record. |
2 |
Original Sequence |
Yes |
This is the line number on the pick ticket. |
3 |
Product Code |
No |
This defaults to the product code of the Trailer record. If a value is imported for this field, it must match the product code of the Trailer record. |
4 |
UCC128 Number |
Yes |
This is the UCC128 number. |
5 |
Picked Quantity |
Yes |
This is the picked quantity. |
6 |
Unit of Measure Code |
No |
This defaults to the unit of measure of the Trailer record. If a value is imported for this field, it must match the unit of measure of the Trailer record. |
7 |
Serial Number |
No |
This defaults to the serial number of the Trailer record. If a value is imported for this field, it must match the serial number of the Trailer record. |
Position |
Field Name |
Required |
Description |
1 |
PICKCHG |
Yes |
This is PICKCHG to indicate the record is a charge record. |
2 |
Type |
Yes |
This is the order entry additional charge type. It must be set up with the Allow Update at Pick Confirmation check box selected in Order Entry Additional Charge Maintenance. |
3 |
Sign |
No |
This defaults to +. |
4 |
Amount |
Yes |
This is the amount of the additional charge. |
5 |
Use Percent |
No |
This is YES if the additional charge is a percent. |
6 |
Percentage |
No |
This is the percentage of the additional charge. |
7 |
All Order |
No |
This indicates whether to update all related orders with this pick demand. |
8 |
Order Number |
No |
This specifies the specific order's charge to update. |
9 |
Comment |
No |
This is a comment for the additional charge. |
10 |
VAT Taxable |
No |
This is YES if the additional charge is VAT taxable. |
11 |
VAT Exempt Reason Code |
No |
This is the reason code to explain why the charge is exempt from VAT. |
12 |
VAT Amount Inclusive |
No |
This is the sum of the additional charge amount and the VAT amount. |
Position |
Field Name |
Required |
Description |
1 |
PICKNTE |
Yes |
This is PICKNTE to indicate the record is a note record. |
2 |
Sequence |
No |
This defaults to zero, which indicates the note is a header note. If this is a different value, it indicates the note is associated with a specific line number of the pick demand. |
3 |
Group |
No |
This defaults to the user's note group. |
4 |
Type |
No |
This defaults to the user's note type. |
5 |
Subject |
Yes |
This is the subject of the note. |
6 |
Body |
Yes |
This is the text of the note. |
Position |
Field Name |
Required |
Description |
1 |
PICKREM |
Yes |
This is PICKREM to indicate the record is a remark record. |
2 |
Sequence |
No |
This defaults to zero, which indicates the remark is a header remark. If this is a different value, it indicates the remark is associated with a specific line number of the pick demand. |
3 |
Remark Data |
Yes |
This is the text of the remark. |
4 |
Start Date |
No |
This is the first date on which to display the remark on documents. The date that is compared to this date depends on the document for the remark. |
5 |
End Date |
No |
This is the last date on which to display the remark on documents. The date that is compared to this date depends on the document for the remark. |
6 |
Repeat Yearly |
No |
This is YES if the remark is included on documents for the date range specified in the Start Date and End Date fields for each year. |
7 |
All Document |
No |
This is YES if the remark is included on all documents. |
8 |
Document 1 |
No |
This is a specific document for the remark. |
9 |
Document 2 |
No |
This is a specific document for the remark. |
10 |
Document 3 |
No |
This is a specific document for the remark. |