NOTE For general information on using imports, see Imports FAQ.
The following tables list the format for importing a header or trailer record in Receiving EDI Advanced Shipping Notice Import.
Column |
Position |
Field |
Maximum Length |
Format |
Required |
Description |
A |
1 |
Supplier Code |
15 |
Character |
Yes |
Enter a valid supplier code for the supplier that shipped products. For information on setting up supplier codes, see Supplier Maintenance. |
B |
2 |
Count Type |
9 |
Character |
Yes |
Enter the type of receipt count demand for the shipped products. Enter PO or Container. |
C |
3 |
Reference Number |
20 |
Character |
Yes |
Enter a valid purchase order or container number for the shipped products. If you enter a container number, the container must be linked to the supplier code entered for the Supplier Code field. |
D |
4 |
Receipt Count ID |
12 |
Character |
Yes |
Enter the receipt count ID for the shipped products. For information on setting up receipt count ID's, see Receiving Count Create. |
E |
5 |
Line Count |
4 |
Integer |
Yes |
Enter the number of shipped line items. |
F |
6 |
Package Count |
8 |
Integer |
No |
Enter the number of shipped packages. |
G |
7 |
Pallet Count |
8 |
Integer |
No |
Enter the number of shipped pallets. |
Column |
Position |
Field |
Maximum Length |
Format |
Required |
Description |
A |
1 |
Product Code |
40 |
Character |
Yes |
Enter the product code of the shipped product. |
B |
2 |
Unit of Measure |
8 |
Character |
Yes |
Enter the unit of measure of the shipped product. |
C |
3 |
Quantity |
10 |
Integer |
Yes |
Enter the quantity of the shipped product. |
D |
4 |
Serial Number |
40 |
Character |
No |
If the shipped product is tracked by serial number, enter the serial number. |
E |
5 |
Lot |
10 |
Character |
No |
If the shipped product is tracked by lot, enter the lot. |
F |
6 |
Associated Purchase Order |
12 |
Character |
No |
Enter the purchase order number associated with the shipped product. |
G |
7 |
Associated Purchase Order Line |
4 |
Integer |
Yes, only if a purchase order is entered in the Associated PO field |
Enter the purchase order line number associated with the shipped product. |
H |
8 |
Package ID |
20 |
Character |
No |
Enter the package ID for the package that contains the shipped product. |
I |
9 |
Pallet ID |
30 |
Character |
No |
Enter the pallet ID for the pallet that contains the shipped product. |
J |
10 |
Best Before Date |
10 |
99/99/9999 |
Yes, only for catch weight products |
Enter the date before which the shipped product should be consumed. This is typically used for food products. |
K |
11 |
Expiration Date |
10 |
99/99/9999 |
Yes, only for catch weight products |
Enter the expiration date of the shipped product (if it has one). |
L |
12 |
Weight Received |
14 |
>>>,>>>,>>9.99 |
Yes, only for catch weight products |
Enter the weight of the shipped product. |
Before using this import, the following must be set up:
suppliers
purchase orders or containers
receipt count IDs
products
units of measure
There must be a record of blank space(s) at the end of an import file.