WMS Receipt Import Format

The following tables list the format for importing receipt data from a WMS. Each record is a caret-delimited row in the import file.

Header Record

Position

Field Name

Required

Description

1

RECHDR

Yes

This is RECHDR to indicate the record is a header record.

2

Location Prefix

Yes

This is the location prefix for the location of the receipt.

3

Receipt Type

Yes

This is PO or Container.

4

Reference Number

Yes

This is the purchase order number or the container code for the receipt.

5

Dock

Yes

This is the dock for the receipt.

6

Receipt Date

No

This defaults to the current date.

7

Receipt Time

No

This defaults to 00:00:00.

8

Bill of Lading Number

No

This is informational only.

9

As Is Option

No

If this is YES, receive as is.

10

WMS Transaction Date

No

This is the date the transaction occurred in the WMS. This defaults to the current date.

11

WMS Transaction Time

No

This is the time the transaction occurred in the WMS. This defaults to the current time.

12

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.

13

WMS Receipt Number

No

This is used when inquiring in Apprise to provide visibility for the WMS pick demand number. This is informational only.

Trailer Record

Position

Field Name

Required

Description

1

RECTRL

Yes

This is RECTRL to indicate the record is a trailer record.

2

Purchase Order Number

Yes

This is the purchase order number for the receipt.

3

Purchase Order Line Number

Yes

This is the purchase order line number for the receipt.

4

Release Number

No

This is the release number.

5

Release Line Number

No

This is the release line number.

6

Product Code

No

This defaults to the product for the purchase order line.

7

Receipt Quantity

Yes

This is the quantity received.

8

Unit of Measure

No

This defaults to the default receipt unit of measure for the product/location.

9

Bin

Yes

This is the bin in which the product is received.

10

Lot

No

This is the lot for the received product if it is tracked by lot.

11

Serial Number

No

This is the serial number for the received product if it is tracked by serial number.

12

Receipt Complete

No

This is YES if the receipt is complete.

13

Expiration Date

No

This is the lot expiration date if the product is tracked by lot.

14

Additional Item

No

This indicates if it is an additional line item.

Charge Record

Position

Field Name

Required

Description

1

RECCHG

Yes

This is RECCHG to indicate the record is a charge record.

2

Charge Type

Yes

This is the charge type.

3

Supplier Code

No

This is the supplier code for the charge.

4

Charge Sign

No

This is the charge sign.

5

Charge Amount

Yes

This is the charge amount.

6

Base Quantity

No

This is the base quantity for per unit and per unit weight charges.

7

Purchase Order Number

Yes

This is the purchase order number for the receipt charge.

8

Purchase Order Line Number

No

This is the purchase order line number for the receipt charge. This is 0 if the charge is for the entire order.

9

Comment

No

This is a comment for the charge.

10

VAT Taxable

No

This is YES if the additional charge is VAT taxable.

11

VAT Supplier Code

No

This is the supplier code for the VAT.

12

VAT Class Code

No

This is the class code for the VAT.

13

VAT Exempt Reason Code

No

This is the reason code to explain why the charge is exempt from VAT.

14

VAT Amount Inclusive

No

This is the sum of the additional charge amount and the VAT amount.