Style Import Format

A

1

Style Code

12

Character

Yes

Enter the style code.

B

2

Name

30

Character

Yes

Enter the name of the style.

C

3

Product Line

8

Character

Yes

Enter a valid product line associated with the style. For information on setting up product lines, see Product Line Maintenance.

D

4

Sort Sequence

7

Integer

No

Enter the sequence number that controls the order of product styles in Lookup windows. If you leave this field blank, it defaults to 0.

E

5

Style Type

10

Character

Yes

Enter a valid style type. This information can be used for Business Intelligence analysis. For information on setting up style types, see Style Type Maintenance.

F

6

Display in Lookups

3

Yes/No

No

Enter Yes to allow the style to display in the style code Lookup window.

Enter No if you do not want to allow the style to display in the style code Lookup window.

If this field is blank, it defaults to Yes.

G

7

Row/Column Orientation

10

Character

No

Enter one of the following to select how the product style appears in the style matrix:

• Color/Size

• Size/Color

H

8

Status Code

12

Character

No

Enter a status for the style. Enter one of the following:

• Setup - You are in the process of setting up the style and do not want it to be available for use yet.

• Active - Mark all existing products and products/locations for the style as not discontinued. If you enter this status, the Discontinued and Include On Order Quantity in OE Discontinued Validation check boxes are cleared for the style's products in Product Maintenance and Product Location Maintenance.

• Discontinued - Mark all existing products and products/locations for the style as discontinued.  If you select this status, the Discontinued check box is selected for the style's products in Product Maintenance and Product Location Maintenance.

If this field is blank, it defaults to Setup.

I

9

Style Primary Supplier Code

15

Character

No

Enter a valid primary supplier code for the style (if different than the primary supplier of the product line). For information on setting up supplier codes, see Supplier Maintenance.

Note Suppliers do not always make all the styles of a specific product line. Sometimes different suppliers make different styles for the same product line.

J

10

User Defined 1

400

Character, Date, Decimal, Integer, or Logical

No

Enter data for the first user-defined field for the style. For information on setting up user-defined fields, see User Defined Fields Maintenance.

K

11

User Defined 2

400

Character, Date, Decimal, Integer, or Logical

No

Enter data for the second user-defined field for the style. For information on setting up user-defined fields, see User Defined Fields Maintenance.

L

12

User Defined 3

400

Character, Date, Decimal, Integer, or Logical

No

Enter data for the third user-defined field for the style. For information on setting up user-defined fields, see User Defined Fields Maintenance.

M

13

User Defined 4

400

Character, Date, Decimal, Integer, or Logical

No

Enter data for the fourth user-defined field for the style. For information on setting up user-defined fields, see User Defined Fields Maintenance.

N

14

User Defined 5

400

Character, Date, Decimal, Integer, or Logical

No

Enter data for the fifth user-defined field for the style. For information on setting up user-defined fields, see User Defined Fields Maintenance.

O

15

User Defined 6

400

Character, Date, Decimal, Integer, or Logical

No

Enter data for the sixth user-defined field for the style. For information on setting up user-defined fields, see User Defined Fields Maintenance.

P

16

User Defined 7

400

Character, Date, Decimal, Integer, or Logical

No

Enter data for the seventh user-defined field for the style. For information on setting up user-defined fields, see User Defined Fields Maintenance.

Q

17

User Defined 8

400

Character, Date, Decimal, Integer, or Logical

No

Enter data for the eighth user-defined field for the style. For information on setting up user-defined fields, see User Defined Fields Maintenance.

R

18

User Defined 9

400

Character, Date, Decimal, Integer, or Logical

No

Enter data for the ninth user-defined field for the style. For information on setting up user-defined fields, see User Defined Fields Maintenance.

S

19

User Defined 10

400

Character, Date, Decimal, Integer, or Logical

No

Enter data for the tenth user-defined field for the style. For information on setting up user-defined fields, see User Defined Fields Maintenance.

T

20

User Defined 11

400

Character, Date, Decimal, Integer, or Logical

No

Enter data for the eleventh user-defined field for the style. For information on setting up user-defined fields, see User Defined Fields Maintenance.

U

21

User Defined 12

400

Character, Date, Decimal, Integer, or Logical

No

Enter data for the twelfth user-defined field for the style. For information on setting up user-defined fields, see User Defined Fields Maintenance.

V

22

User Defined 13

400

Character, Date, Decimal, Integer, or Logical

No

Enter data for the thirteenth user-defined field for the style. For information on setting up user-defined fields, see User Defined Fields Maintenance.

W

23

User Defined 14

400

Character, Date, Decimal, Integer, or Logical

No

Enter data for the fourteenth user-defined field for the style. For information on setting up user-defined fields, see User Defined Fields Maintenance.

X

24

User Defined 15

400

Character, Date, Decimal, Integer, or Logical

No

Enter data for the fifteenth user-defined field for the style. For information on setting up user-defined fields, see User Defined Fields Maintenance.

Y

25

User Defined 16

400

Character, Date, Decimal, Integer, or Logical

No

Enter data for the sixteenth user-defined field for the style. For information on setting up user-defined fields, see User Defined Fields Maintenance.

Z

26

User Defined 17

400

Character, Date, Decimal, Integer, or Logical

No

Enter data for the seventeenth user-defined field for the style. For information on setting up user-defined fields, see User Defined Fields Maintenance.

AA

27

User Defined 18

400

Character, Date, Decimal, Integer, or Logical

No

Enter data for the eighteenth user-defined field for the style. For information on setting up user-defined fields, see User Defined Fields Maintenance.

AB

28

User Defined 19

400

Character, Date, Decimal, Integer, or Logical

No

Enter data for the nineteenth user-defined field for the style. For information on setting up user-defined fields, see User Defined Fields Maintenance.

AC

29

User Defined 20

400

Character, Date, Decimal, Integer, or Logical

No

Enter data for the twentieth user-defined field for the style. For information on setting up user-defined fields, see User Defined Fields Maintenance.

AD

30

Propagate Updates Across All Products

9

Character

No

Enter one of the following values to control whether changes to one product in the style are copied to other products in the style:

• Yes - Changes to products are automatically copied to all products in the style. Product Style Selection does not appear.

• No - Changes to products are not copied to products in the style. Product Style Selection does not appear.

• Prompt With Defaults - When making changes to products, Product Style Selection appears with all changes and products in the same style selected by default. If the user does not make any changes in Product Style Selection, and clicks the OK button in the ribbon, all changes are copied to all products in the style.

• Prompt With NO Defaults -  When making changes to products, Product Style Selection appears, and users must manually select which changes to copy to products in the style.

For information on data that can be copied between products in a style, see Copying Data Between Products in a Style.