CV1:General Item V1.07

Format : PIDF

CETE Topic : IT

Usage : Generic item information.

Description

Start Position

Len

Format

Required?

Comments

CV1 Item Number

1

6

N

Y

Number used by the distributor to refer to the item.  (The distributor's product code)

Description

7

35

A

N

A Textual description of the item.

Category Number

42

2

N

N

A code the distributor uses to classify the item.

Sales Class Number

44

5

N

N

A code the distributor uses to classify the item.

Product Class Number

49

5

N

N

A code the distributor uses to classify the item.

Unit of Measure 1

54

3

A

N

 An abbreviated text value the distributor uses to describe the smallest saleable package.  For example, PAK, BAR, EA.

Unit of Measure 2

57

3

A

N

  An abbreviated text value the distributor uses to describe the next-to-smallest saleable package.  For example, CTN, BOX, BAG.

Unit of Measure 3

60

3

A

N

   An abbreviated text value the distributor uses to describe the third-to-smallest saleable package.  For example, CAS. 

Unit of Measure 4

63

3

A

N

   An abbreviated text value the distributor uses to describe the largest saleable unit of measurement.  For example, PAL.

Qty Multiplier 1

66

5

A

N

 The number of the next smaller unit contained in this unit.  Because this unit is usually the smallest definable unit, this number is generally always 1.

Qty Multiplier 2

71

5

A

N

  The number of the next smaller unit contained in this unit.  For example, if this unit describes a Carton of cigarettes, the value would typically be 10. (10 Packs per Carton)

Qty Multiplier 3

76

5

A

N

  The number of the next smaller unit contained in this unit.  For example, if this unit describes a Case of cigarettes, the value would typically be 60. (60 Cartons per Case)

Qty Multiplier 4

81

5

A

N

 The number of the next smaller unit contained in this unit.  

Mfr Part Number

86

15

A

N

 A number the manufacturer uses to refer to the item (other than the UPC code).

Pack Description

101

10

A

N

 Text that describes the package size of the smallest unit of measure.  For example, "20/Pack", "10 OZ Bars", etc.

Catch Weight Sts

111

1

A

N

Y=Yes, this product is sold by weight. N=No, this product is not sold by weight. NULL=Assume "N".

Mfr. Suggested Rtl.

112

17

R

N

 The retail price that the manufacturer suggests the item be sold at.  The value corresponds to the unit of measure specified as the "Standard Selling Unit" for the item.

UPC #1

129

15

A

N

UPC # for Unit #1

UPC #2

144

15

A

N

UPC # for Unit #2

UPC #3

159

15

A

N

UPC # for Unit #3

UPC #4

174

15

A

N

UPC # for Unit #4

ANSI Unit #1

189

2

A

N

Ansi Unit of measure for Unit #1

ANSI Unit #2

191

2

A

N

Ansi Unit of measure for Unit #2

ANSI Unit #3

193

2

A

N

Ansi Unit of measure for Unit #3

ANSI Unit #4

195

2

A

N

Ansi Unit of measure for Unit #4

CV1 Vendor Number

197

6

A

N

ID of the distributor's vendor for this item as defined in the DAC system.

Brand Code

203

10

A

N

Brand code of the product.  

Tax Class Number

213

5

N

N

Tax Class of the Product

Status

218

1

A

N

Status.  A=Active, I=Inactive, D=Marked for deletion.

Extended Item Description

219

35

A

N

Additional, longer text field for describing an item.

Demoted?

254

1

A

N

Indicates if the item is "demoted". 

D=Demoted
*Blank = Not Demoted

Demoted Reason

255

1

A

N

If item is demoted, this is the reason why:

1=Inactive Item Master
2=All Item Balance Records for the item are inactive, or, if the target is a customer, then the balance record for that customer's default warehouse is inactive.
3=All Item Balance Records for the item are excluded from Price Books, or, if the target is a customer, then the balance record for that customer's default warehouse is inactive.
4=Inactive for purchasing

Original Entry Date

256

8

N

N

Date the item was originally entered into the system. (YYYYMMDD)

NACS Category

264

6

N

N

The NACS Category for this item (If defined)

Services per SSU

270

6

R

N

Servings per Standard Sell Unit (5.1)

Product Heading Number

276

4

A

N

 

Product Sequence Number

280

5

N

N

 

Transaction Terminator Symbol

285

2

A

Y

Literal "//"

Total Length

 

286