WMS Pick Demand Confirmation Import Format

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.

Header Record

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: YES - Confirm as is (default) NO - Confirm, but leave open (do not adjust or invoice) SPLIT - Create a new pick demand for the unconfirmed quantity
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.

Trailer Record

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.

Package Record

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.

Tag Record

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.

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

Note Record

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.

Remark Record

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.