NOTE For general information on using imports, see Imports FAQ.
The following table lists the format for importing a record in Purchase Cost Matrix Import.
Column |
Position |
Field |
Maximum Length |
Format |
Required |
Description |
A |
1 |
Supplier Code |
15 |
Character |
Yes |
Enter a valid supplier code for the purchase cost matrix. For information on setting up suppliers, see Supplier Maintenance. |
B |
2 |
Cost Region |
10 |
Character |
No |
Enter a valid cost region for the purchase cost matrix or leave this field blank to indicate the matrix is for all cost regions. For information on setting up cost regions, see Cost Region Maintenance. |
C |
3 |
Product Code |
40 |
Character |
Yes, only if the Cost Class field is blank |
Enter a valid product code for the purchase cost matrix. For information on setting up products, see Product Maintenance. |
D |
4 |
Cost Class |
10 |
Character |
Yes, only if the Product Code field is blank |
Enter a valid purchase cost class for the purchase cost matrix. For information on setting up purchase cost classes, see Purchase Cost Class Maintenance. |
E |
5 |
Multiplier |
5 |
Character |
No |
Enter a multiplier if the purchase cost matrix uses cost multipliers. You must enter List1, List2, List3, or List4. |
F |
6 |
Cost/Multiplier 1 |
14 |
>,>>>,>>9.9999 |
Yes |
Enter the first break cost or multiplier. |
G |
7 |
Drop-Ship Cost/Multiplier 1 |
14 |
>,>>>,>>9.9999 |
No |
Enter the first drop-ship break cost or multiplier. |
H |
8 |
Break 2 |
13 |
>,>>>,>>>,>>9 |
No |
Enter the second break quantity. |
I |
9 |
Cost/Multiplier 2 |
14 |
>,>>>,>>9.9999 |
No |
Enter the second break cost or multiplier. |
J |
10 |
Drop-Ship Cost/Multiplier 2 |
14 |
>,>>>,>>9.9999 |
No |
Enter the second drop-ship break cost or multiplier. |
K |
11 |
Break 3 |
13 |
>,>>>,>>>,>>9 |
No |
Enter the third break quantity. |
L |
12 |
Cost/Multiplier 3 |
14 |
>,>>>,>>9.9999 |
No |
Enter the third break cost or multiplier. |
M |
13 |
Drop-Ship Cost/Multiplier 3 |
14 |
>,>>>,>>9.9999 |
No |
Enter the third drop-ship break cost or multiplier. |
N |
14 |
Break 4 |
13 |
>,>>>,>>>,>>9 |
No |
Enter the fourth break quantity. |
O |
15 |
Cost/Multiplier 4 |
14 |
>,>>>,>>9.9999 |
No |
Enter the fourth break cost or multiplier. |
P |
16 |
Drop-Ship Cost/Multiplier 4 |
14 |
>,>>>,>>9.9999 |
No |
Enter the fourth drop-ship break cost or multiplier. |
Q |
17 |
Break 5 |
13 |
>,>>>,>>>,>>9 |
No |
Enter the fifth break quantity. |
R |
18 |
Cost/Multiplier 5 |
14 |
>,>>>,>>9.9999 |
No |
Enter the fifth break cost or multiplier. |
S |
19 |
Drop-Ship Cost/Multiplier 5 |
14 |
>,>>>,>>9.9999 |
No |
Enter the fifth drop-ship break cost or multiplier. |
T |
20 |
Break 6 |
13 |
>,>>>,>>>,>>9 |
No |
Enter the sixth break quantity. |
U |
21 |
Cost/Multiplier 6 |
14 |
>,>>>,>>9.9999 |
No |
Enter the sixth break cost or multiplier. |
V |
22 |
Drop-Ship Cost/Multiplier 6 |
14 |
>,>>>,>>9.9999 |
No |
Enter the sixth drop-ship break cost or multiplier. |
W |
23 |
Break 7 |
13 |
>,>>>,>>>,>>9 |
No |
Enter the seventh break quantity. |
X |
24 |
Cost/Multiplier 7 |
14 |
>,>>>,>>9.9999 |
No |
Enter the seventh break cost or multiplier. |
Y |
25 |
Drop-Ship Cost/Multiplier 7 |
14 |
>,>>>,>>9.9999 |
No |
Enter the seventh drop-ship break cost or multiplier. |
Z |
26 |
Break 8 |
13 |
>,>>>,>>>,>>9 |
No |
Enter the eighth break quantity. |
AA |
27 |
Cost/Multiplier 8 |
14 |
>,>>>,>>9.9999 |
No |
Enter the eighth break cost or multiplier |
AB |
28 |
Drop-Ship Cost/Multiplier 8 |
14 |
>,>>>,>>9.9999 |
No |
Enter the eighth drop-ship break cost or multiplier. |
AC |
29 |
Break 9 |
13 |
>,>>>,>>>,>>9 |
No |
Enter the ninth break quantity. |
AD |
30 |
Cost/Multiplier 9 |
14 |
>,>>>,>>9.9999 |
No |
Enter the ninth break cost or multiplier. |
AE |
31 |
Drop-Ship Cost/Multiplier 9 |
14 |
>,>>>,>>9.9999 |
No |
Enter the ninth drop-ship break cost or multiplier. |
AF |
32 |
Break 10 |
13 |
>,>>>,>>>,>>9 |
No |
Enter the tenth break quantity. |
AG |
33 |
Cost/Multiplier 10 |
14 |
>,>>>,>>9.9999 |
No |
Enter the tenth break cost or multiplier. |
AH |
34 |
Drop-Ship Cost/Multiplier 10 |
14 |
>,>>>,>>9.9999 |
No |
Enter the tenth drop-ship break cost or multiplier. |
AI |
35 |
Charge 1 Code |
10 |
Character |
No |
This field is validated. Enter the purchase order additional charge code. For information on setting up valid purchase additional charges, see Purchase Additional Charge Maintenance. |
AJ |
36 |
Charge 1 Amount |
10 |
->>,>>9.99 |
No |
Enter the amount or percentage break (depending on the charge setup) |
AK |
37 |
Charge 1 Weight Unit of Measure Usage Name |
4 |
Character |
No |
Enter the weight unit of measure of the charge. This field is only used for per unit weight charges. |
AL |
38 |
Charge 2 Code |
10 |
Character |
No |
This field is validated. Enter the purchase order additional charge code. For information on setting up valid purchase additional charges, see Purchase Additional Charge Maintenance. |
AM |
39 |
Charge 2 Amount |
10 |
->>,>>9.99 |
No |
Enter the amount or percentage break (depending on the charge setup) |
AN |
40 |
Charge 2 Weight Unit of Measure Usage Name |
4 |
Character |
No |
Enter the weight unit of measure of the charge. This field is only used for per unit weight charges. |
AO |
41 |
Charge 3 Code |
10 |
Character |
No |
This field is validated. Enter the purchase order additional charge code. For information on setting up valid purchase additional charges, see Purchase Additional Charge Maintenance. |
AP |
42 |
Charge 3 Amount |
10 |
->>,>>9.99 |
No |
Enter the amount or percentage break (depending on the charge setup) |
AQ |
43 |
Charge 3 Weight Unit of Measure Usage Name |
4 |
Character |
No |
Enter the weight unit of measure of the charge. This field is only used for per unit weight charges. |
AR |
44 |
Charge 4 Code |
10 |
Character |
No |
This field is validated. Enter the purchase order additional charge code. For information on setting up valid purchase additional charges, see Purchase Additional Charge Maintenance. |
AS |
45 |
Charge 4 Amount |
10 |
->>,>>9.99 |
No |
Enter the amount or percentage break (depending on the charge setup) |
AT |
46 |
Charge 4 Weight Unit of Measure Usage Name |
4 |
Character |
No |
Enter the weight unit of measure of the charge. This field is only used for per unit weight charges. |
AU |
47 |
Charge 5 Code |
10 |
Character |
No |
This field is validated. Enter the purchase order additional charge code. For information on setting up valid purchase additional charges, see Purchase Additional Charge Maintenance. |
AV |
48 |
Charge 5 Amount |
10 |
->>,>>9.99 |
No |
Enter the amount or percentage break (depending on the charge setup) |
AW |
49 |
Charge 5 Weight Unit of Measure Usage Name |
4 |
Character |
No |
Enter the weight unit of measure of the charge. This field is only used for per unit weight charges. |
AX |
50 |
Charge 6 Code |
10 |
Character |
No |
This field is validated. Enter the purchase order additional charge code. For information on setting up valid purchase additional charges, see Purchase Additional Charge Maintenance. |
AY |
51 |
Charge 6 Amount |
10 |
->>,>>9.99 |
No |
Enter the amount or percentage break (depending on the charge setup) |
AZ |
52 |
Charge 6 Weight Unit of Measure Usage Name
|
4 |
Character |
No |
Enter the weight unit of measure of the charge. This field is only used for per unit weight charges. |
BA |
53 |
Charge 7 Code |
10 |
Character |
No |
This field is validated. Enter the purchase order additional charge code. For information on setting up valid purchase additional charges, see Purchase Additional Charge Maintenance. |
BB |
54 |
Charge 7 Amount |
10 |
->>,>>9.99 |
No |
Enter the amount or percentage break (depending on the charge setup) |
BC |
55 |
Charge 7 Weight Unit of Measure Usage Name |
4 |
Character |
No |
Enter the weight unit of measure of the charge. This field is only used for per unit weight charges. |
BD |
56 |
Charge 8 Code |
10 |
Character |
No |
This field is validated. Enter the purchase order additional charge code. For information on setting up valid purchase additional charges, see Purchase Additional Charge Maintenance. |
BE |
57 |
Charge 8 Amount |
10 |
->>,>>9.99 |
No |
Enter the amount or percentage break (depending on the charge setup) |
BF |
58 |
Charge 8 Weight Unit of Measure Usage Name |
4 |
Character |
No |
Enter the weight unit of measure of the charge. This field is only used for per unit weight charges. |
BG |
59 |
Charge 9 Code |
10 |
Character |
No |
This field is validated. Enter the purchase order additional charge code. For information on setting up valid purchase additional charges, see Purchase Additional Charge Maintenance. |
BH |
60 |
Charge 9 Amount |
10 |
->>,>>9.99 |
No |
Enter the amount or percentage break (depending on the charge setup) |
BI |
61 |
Charge 9 Weight Unit of Measure Usage Name |
4 |
Character |
No |
Enter the weight unit of measure of the charge. This field is only used for per unit weight charges. |
BJ |
62 |
Charge 10 Code |
10 |
Character |
No |
This field is validated. Enter the purchase order additional charge code. For information on setting up valid purchase additional charges, see Purchase Additional Charge Maintenance. |
BK |
63 |
Charge 10 Amount |
10 |
->>,>>9.99 |
No |
Enter the amount or percentage break (depending on the charge setup) |
BL |
64 |
Charge 10 Weight Unit of Measure Usage Name |
4 |
Character |
No |
Enter the weight unit of measure of the charge. This field is only used for per unit weight charges. |
BM |
65 |
Freight Free - Break 1 |
3 |
Yes/No |
No |
Enter Yes if the first cost break is freight free. This field defaults to No if it is left blank. |
BN |
66 |
Freight Free - Break 2 |
3 |
Yes/No |
No |
Enter Yes if the second cost break is freight free. This field defaults to No if it is left blank. |
BO |
67 |
Freight Free - Break 3 |
3 |
Yes/No |
No |
Enter Yes if the third cost break is freight free. This field defaults to No if it is left blank. |
BP |
68 |
Freight Free - Break 4 |
3 |
Yes/No |
No |
Enter Yes if the fourth cost break is freight free. This field defaults to No if it is left blank. |
BQ |
69 |
Freight Free - Break 5 |
3 |
Yes/No |
No |
Enter Yes if the fifth cost break is freight free. This field defaults to No if it is left blank. |
BR |
70 |
Freight Free - Break 6 |
3 |
Yes/No |
No |
Enter Yes if the sixth cost break is freight free. This field defaults to No if it is left blank. |
BS |
71 |
Freight Free - Break 7 |
3 |
Yes/No |
No |
Enter Yes if the seventh cost break is freight free. This field defaults to No if it is left blank. |
BT |
73 |
Freight Free - Break 8 |
3 |
Yes/No |
No |
Enter Yes if the eighth cost break is freight free. This field defaults to No if it is left blank. |
BU |
73 |
Freight Free - Break 9 |
3 |
Yes/No |
No |
Enter Yes if the ninth cost break is freight free. This field defaults to No if it is left blank. |
BV |
74 |
Freight Free - Break 10 |
3 |
Yes/No |
No |
Enter Yes if the tenth cost break is freight free. This field defaults to No if it is left blank. |
BW |
75 |
Start Date |
10 |
99/99/9999 |
Yes |
Enter the first date in a range of dates for the purchase cost matrix. |
BX |
76 |
End Date |
10 |
99/99/9999 |
Yes |
Enter the last date in a range of dates for the purchase cost matrix. |
BY |
77 |
Currency |
8 |
Character |
No |
Enter a valid currency for the purchase cost matrix. If this field is blank, the currency defaults to the default system currency. For information on setting up currencies, see Currency Maintenance. |
BZ |
78 |
Country |
10 |
Character |
Yes, only if you enter a cost region in the Cost Region field that is associated with multiple countries |
Enter a valid country associated with the cost region for the purchase cost matrix. For information on setting up countries, see Country Maintenance. |
CA |
79 |
Cost Includes VAT |
3 |
Yes/No |
No |
Enter Y or Yes if the costs for the purchase cost matrix include VAT. Enter N or No if the costs do not include VAT. |
Before using this import, the following must be set up:
suppliers
product codes or cost classes
If a multiplier basis is required, it must be one of the following: List1, List2, List3, or List4. Do not use your company's naming conventions for the user-defined list prices for List 1 through 4.
The first break quantity is always set to zero.
You can use this import to update existing purchase cost matrix records.
There must be a record of blank space(s) at the end of an import file.