The following tables list the format for importing receipt data from a WMS. Each record is a caret-delimited row in the import file.
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. |
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. |
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. |