NOTE For general information on using imports, see Imports FAQ.
The following table lists the format for importing in EDI Product Activity Import.
Column |
Position |
Field |
Maximum Length |
Format |
Required |
Description |
A |
1 |
Trade ID |
25 |
Character |
Yes |
Enter a valid EDI trading partner ID that has a form 852 set up. |
B |
2 |
Store ID |
20 |
Character |
Yes |
Enter the mass merchant’s store identification number. The store ID must be associated with an active customer that is associated with the trading partner, or with the trading partner itself. |
C |
3 |
Product Code |
40 |
Character |
Yes |
Enter the product code. Validation of the product code can come from the following sources in this order:
|
D |
4 |
Transaction Date |
10 |
99/99/9999 |
Yes |
Enter the transaction date. |
E |
5 |
Quantity on Hand |
11 |
->>,>>>,>>9 |
No |
Enter the quantity on hand for the product. |
F |
6 |
Quantity Sold |
11 |
->>,>>>,>>9 |
No |
Enter the quantity sold for the product. This field is used for the point of sale sell through quantity in DRP. |
G |
7 |
Quantity in Transit |
11 |
->>,>>>,>>9 |
No |
Enter the quantity in transit for the product. |
H |
8 |
Quantity on Order |
11 |
->>,>>>,>>9 |
No |
Enter the quantity on order for the product. |
I |
9 |
Quantity Received |
11 |
->>,>>>,>>9 |
No |
Enter the quantity received for the product. |
J |
10 |
Quantity Adjustments |
11 |
->>,>>>,>>9 |
No |
Enter the quantity of adjustments for the product. |
K |
11 |
Quantity Returned |
11 |
->>,>>>,>>9 |
No |
Enter the quantity returned for the product. |
L |
12 |
Quantity Damaged |
11 |
->>,>>>,>>9 |
No |
Enter the quantity damaged for the product. |
M |
13 |
Quantity Transfer |
11 |
->>,>>>,>>9 |
No |
Enter the quantity transferred for the product. |
N |
14 |
Shipping Location Prefix |
3 |
Character |
Yes, only if a shipping location is not set up for the trading partner or customer. |
Enter a valid shipping location prefix. If this field is blank, it defaults to the shipping location for the trading partner. If no shipping location is set up for the trading partner, it defaults to the shipping location for the first customer associated with the trading partner. |
O |
15 |
Quantity Forecast |
11 |
->>,>>>,>>9 |
No |
Enter the quantity forecast for the product. |
Note Each trade ID can have multiple customers attached to it. The import looks for a customer with the imported trade ID and the imported store ID first to determine the relevant customer (if you have a billing customer/customer setup). If the import does not find one, it assumes a customer/customer ship-to setup, in which case one would typically have just one customer per trade ID. Therefore, it uses the first customer for that trading partner.
Before using this import, the following must be set up:
EDI trading partners
products
shipping locations
There must be a record of blank space(s) at the end of an import file.