Customer Product Import Format

A

1

Record Type

1

Character

Yes

Enter H to specify the record is a header record.

B

2

Product Code

40

Character

Yes

Enter a valid product code for which to define a customer product. For information on setting up products, see Product Maintenance.

C

3

Customer Code

12

Character

Yes

Enter a valid customer code for which to define a customer product. For information on setting up customers, see Customer Maintenance.

D

4

Customer's Product Code

40

Character

Yes

Enter the customer’s product code for the product.

E

5

Customer's Product Name

30

Character

No

Enter the customer’s product name for the product.

F

6

Customer UPC

25

Character

No

Enter the customer’s UPC for the product. This field is typically used for custom invoice printing.

G

7

Customer Manufacturing Code

20

Character

No

Enter the customer's manufacturing code for the product. This field is typically used for custom invoice printing.

H

8

Retail Price

14

>,>>>,>>9.99<<

No

Enter the customer’s suggested retail price (informational only; no other standard functionality). This field is used for custom retail label printing.

I

9

Retail Label Type

10

Character

No

Enter the customer’s retail label type. This field is used for custom retail label printing.

J

10

User Defined 1

30

Character

No

Enter appropriate data for this user-defined field. This field is typically used for custom invoice printing purposes.

K

11

User Defined 2

30

Character

No

Enter appropriate data for this user-defined field. This field is typically used for custom invoice printing purposes.

L

12

Default Selling Unit of Measure

8

Character

No

Enter a valid default selling unit of measure used in Order Entry when entering an order line item for the customer and product. This must be the same type of unit of measure as the product unit of measure for the product, and this must be a selling unit of measure for the product. For information on setting up units of measure, see Unit of Measure Maintenance.

M

13

Default Package Unit of Measure

8

Character

No

Enter a valid default package unit of measure used with cartonization for the customer and product. This must be the same type of unit of measure as the product unit of measure for the product. For information on setting up units of measure, see Unit of Measure Maintenance.

N

14

Can Be Packaged

3

Yes/No

No

Enter Yes if the customer/product combination can be used in cartonization. For more information, see Cartonization FAQ.

If this field is blank, it defaults to No.

O

15

Default Customer Product

3

Yes/No

No

Enter Yes to make this the default customer’s product code associated with the customer and product code.

Note There can be many customer’s product codes linked to a product code, but there can only be one that is the current default. If you enter Yes and a default customer product code previously existed, the imported customer product is set as the new default.

Example Customer ABC has its own product code A101 that supersedes its previous model product code B101. Both B101 and A101 are linked to your product code 1243434, but A101 is now selected as the default.

If this field is blank, it defaults to No.

P

16

Master Carton Unit of Measure

8

Character

Yes, only if you enter a unit of measure for the Inner Pack Unit of Measure field

Enter a valid master carton unit of measure for the product. This must be the same type of unit of measure as the product unit of measure for the product, and this must be a selling unit of measure for the product. This must be larger than and a multiple of the unit of measure entered for the Inner Pack Unit of Measure field.

Q

17

Inner Pack Unit of Measure

8

Character

Yes, only if you enter a unit of measure for the Master Carton Unit of Measure field

Enter a valid inner pack unit of measure for the product. This must be the same type of unit of measure as the product unit of measure for the product, and this must be a selling unit of measure for the product. If a customer only has one case pack unit of measure, the inner pack unit of measure should be the base unit of measure for the product. This must be smaller than the unit of measure entered for the Master Carton Unit of Measure field.

R

18

Order Minimum

10

>>>,>>9.99

No

Enter the minimum quantity in the selling default unit of measure when the customer orders the product. If a value is entered for the Order Multiple field, this must be a multiple of that value. For more information, see Unit of Measure Fields FAQ.

S

19

Order Multiple

10

>>>,>>9.99

No

Enter the order multiple quantity in the selling default unit of measure when the customer orders the product. For more information, see Unit of Measure Fields FAQ.

T

20

Allocation Minimum

10

>>>,>>9.99

No

Enter the minimum quantity that can be allocated for the product in the selling default unit of measure. This overrides the allocation minimum value entered for the product in Product Maintenance and Product Location Maintenance. This value functions in conjunction with the Allocation Qty Min/Mult Automatic and Allocation Qty Min/Mult Manual options in Customer Service Control Maintenance. This value cannot be greater than the value entered for the Order Minimum field. If a value is entered for the Allocation Multiple field, this must be a multiple of that value.

U

21

Allocation Multiple

10

>>>,>>9.99

No

Enter a value of which a multiple can be allocated for the product in the selling default unit of measure. This overrides the multiple allocation value entered for the product in Product Maintenance and Product Location Maintenance. This value functions in conjunction with the Allocation Qty Min/Mult Automatic and Allocation Qty Min/Mult Manual options in Customer Service Control Maintenance.

V

22

Exclude from Inventory Inquiry/Advice

3

Yes/No

No

Enter Yes to exclude the product from the EDI Inventory Inquiry/Advice files. For more information, see Customer Product Maintenance.

If this field is blank, it defaults to No.

A

1

Record Type

1

Character

Yes if you are entering a cross-reference record

Enter X to specify the record is a cross-reference record.

B

2

Apprise Code

8

Character

Yes if you are entering a cross-reference record

Enter the unit of measure your company uses for the product. This unit of measure should be equivalent to the unit of measure entered in the Partner Code field, so that you can set up a cross-reference between the two units of measure.

C

3

Partner Code

16

Character

Yes if you are entering a cross-reference record

Enter the trading partner's unit of measure for the customer product. This unit of measure should be equivalent to the unit of measure entered in the Apprise Code field, so that you can set up a cross-reference between the two units of measure.