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.