NOTE For general information on using imports, see Imports FAQ.
The following table lists the format for importing a record in RIP Product Import.
|
Column |
Position |
Field |
Maximum Length |
Format |
Required |
Description |
|
A |
1 |
RIP Code |
8 |
Character |
Yes |
Enter a retail incentive program code for the retail incentive program rule. |
|
B |
2 |
Description |
30 |
Character |
No |
Enter a description of the retail incentive program code. |
|
C |
3 |
Product Code |
40 |
Character |
Yes |
Enter a valid product code for the retail incentive program rule. |
|
D |
4 |
Customer Code |
12 |
Character |
No |
Enter a valid customer code for the retail incentive program rule. If this field is blank, the rule is for all customers. If you enter a value for this field, do not enter a value for the Customer Division field (position 5). |
|
E |
5 |
Customer Division |
12 |
Character |
No |
Enter a valid customer division for the retail incentive program rule. If this field is blank, the rule is for all customer divisions. If you enter a value for this field, do not enter a value for the Customer Code field (position 4). |
|
F |
6 |
Start Date |
10 |
99/99/9999 |
Yes |
Enter the first date in a range of dates for the retail incentive program rule. |
|
G |
7 |
End Date |
10 |
99/99/9999 |
Yes |
Enter the last date in a range of dates for the retail incentive program rule. |
|
H |
8 |
Family Price Code |
10 |
Character |
No |
Enter a valid family price code associated with the retail incentive program rule. |
|
I |
9 |
Currency |
8 |
Character |
No |
Enter a valid currency associated with the retail incentive program rule. If this field is left blank, it defaults to the default currency for the ledger. |
|
J |
10 |
Unit of Measure |
8 |
Character |
No |
Enter a valid selling unit of measure associated with the retail incentive program rule. If this field is left blank, it defaults to the default selling unit of measure for the product. |
|
K |
11 |
Break 1 |
14 |
>>>,>>>,>>9.99 |
No |
Enter the first break quantity for the retail incentive program rule. |
|
L |
12 |
Break 2 |
14 |
>>>,>>>,>>9.99 |
No |
Enter the second break quantity for the retail incentive program rule. |
|
M |
13 |
Break 3 |
14 |
>>>,>>>,>>9.99 |
No |
Enter the third break quantity for the retail incentive program rule. |
|
N |
14 |
Break 4 |
14 |
>>>,>>>,>>9.99 |
No |
Enter the fourth break quantity for the retail incentive program rule. |
|
O |
15 |
Break 5 |
14 |
>>>,>>>,>>9.99 |
No |
Enter the fifth break quantity for the retail incentive program rule. |
|
P |
16 |
Break 6 |
14 |
>>>,>>>,>>9.99 |
No |
Enter the sixth break quantity for the retail incentive program rule. |
|
Q |
17 |
Break 7 |
14 |
>>>,>>>,>>9.99 |
No |
Enter the seventh break quantity for the retail incentive program rule. |
|
R |
18 |
Break 8 |
14 |
>>>,>>>,>>9.99 |
No |
Enter the eighth break quantity for the retail incentive program rule. |
|
S |
19 |
Break 9 |
14 |
>>>,>>>,>>9.99 |
No |
Enter the ninth break quantity for the retail incentive program rule. |
|
T |
20 |
Break 10 |
14 |
>>>,>>>,>>9.99 |
No |
Enter the tenth break quantity for the retail incentive program rule. |
|
U |
21 |
Award 1 |
14 |
>>>,>>>,>>9.99 |
No |
Enter the award amount for the first break. |
|
V |
22 |
Award 2 |
14 |
>>>,>>>,>>9.99 |
No |
Enter the award amount for the second break. |
|
W |
23 |
Award 3 |
14 |
>>>,>>>,>>9.99 |
No |
Enter the award amount for the third break. |
|
X |
24 |
Award 4 |
14 |
>>>,>>>,>>9.99 |
No |
Enter the award amount for the fourth break. |
|
Y |
25 |
Award 5 |
14 |
>>>,>>>,>>9.99 |
No |
Enter the award amount for the fifth break. |
|
Z |
26 |
Award 6 |
14 |
>>>,>>>,>>9.99 |
No |
Enter the award amount for the sixth break. |
|
AA |
27 |
Award 7 |
14 |
>>>,>>>,>>9.99 |
No |
Enter the award amount for the seventh break. |
|
AB |
28 |
Award 8 |
14 |
>>>,>>>,>>9.99 |
No |
Enter the award amount for the eighth break. |
|
AC |
29 |
Award 9 |
14 |
>>>,>>>,>>9.99 |
No |
Enter the award amount for the ninth break. |
|
AD |
30 |
Award 10 |
14 |
>>>,>>>,>>9.99 |
No |
Enter the award amount for the tenth break. |
Before using this import, the following must be set up: