Purchase Cost Matrix Import Format

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.

Prerequisites

Before using this import, the following must be set up:

Import Format Notes