How to define, design and implement bar code, rfid, in warehouse management, inventory management software providing supply chain visibility and inventory control.

Get started. drill down from layman to technical understanding of rfid, bar code applications, benefits and tradeoffs. Get started and drill down from layman to technical understanding of bar code and rfid applications, benefits and tradeoffs. Best practices, benchmarking, and cost payback enable you to define, design and implement cost effective global supply chain systems. Fundamentals of global supply chain flow and how rfid and bar codes and Internet communications are used to optimize your system. Introduction and drill down for supply chain standards retail, paper, automotive, airframe, DoD, military GS1, UPC, UPC.EAN, GTIN, EAN, AIAG, DoD, Spec. 2000, UID, EPC.

Home

 

Join Insight

 

Products:

Faculty

 

Professional Registry

 

Contact Us

 

 

 

 

 

 

 

 

 

The Supply Chain Implementation Series, Guide #1: Using Industry-Compliant Bar Codes

[Home] [Introduction] [The Trend: What and Why] [What This Could Mean for Your Company] [What You Must Do] [Implementation Path] [Support Materials]

[ Appendix 1 ] [ Appendix 2 ] [ Appendix 3 ] [ Appendix 4 ] [ Appendix 5 ] [ Appendix 6 ] [ Appendix 7 ] [ Appendix 8 ] [ Appendix 9 ] [ Appendix 10 ]

Appendix 1: TRADING PARTNER CONTACT

[ App1-1 ] [ 1-2 ] [ 1-3 ] [ 1-4 ] [ 1-5 ] [ 1-6 ] [ 1-7 ]

1.6 Flat File

Following is a recommended variable length ASCII file record layout for bar code information and file and price diskette updates between trading partners.  Files may be formatted as .txt  .csv  .wks  .xls

FIELD DESCRIPTION MAX LENGTH
Catalog #  15
Manufacturer U.P.C. or W/D Internal Number* 15
Product Description 80
Unit of Measure 3
Packing Indicator Level 0 (significant quantity 1) 5
Packing Indicator Level 1 Quantity 5
Packing Indicator Level 2 Quantity 5
Packing Indicator Level 3 Quantity 5
Packing Indicator Level 4 Quantity  5
Packing Indicator Level 5 Quantity 5
Packing Indicator Level 6 Quantity 5
Packing Indicator Level 7 Quantity  5
UPC or EAN 13 digit field**  14
SPIN Number for Commodity Items***  14
Unit of Measure Code*** 2
Cubic Volume Shipping Total*** 11 (i.e. 999999.9999)
Unit Shipping Weight*** 11 ( i.e. 999999.9999)
Unit Price Code (“L” for List; “C” for Cost)*** 1
Unit List Price (Manufacturer)*** 9  (i.e. 9999.9999)

 

** This field is for EAN(13).  It can also be used for SCC-14 if Package Indicators are not used.

*** these are optional fields of information.

0006-H1/2C, 763439000040, WALL MOUNT FAUCET  ADJUSTABLE FLANGE/HOSE END, EA, 1, R, 6, 24, 0, 0, 0, 0

0006-H1/2H, 763439000057, WALL MOUNT FAUCET  ADJUSTABLE FLANGE/HOSE END, EA, 1, R, 6, 24, 0, 0, 0, 0

0007-1/2, 763439000071, WALL MOUNT FAUCET  SOLID FLANGE/PLAIN END, EA, 1, R, 6, 24, 0, 0, 0, 0

0007-H1/2, 763439000088, WALL MOUNT FAUCET  SOLID FLANGE/HOSE END, EA, 1, R, 6, 24, 0, 0, 0, 0

0009-H1/2C, 763439000101, WALL MOUNT FAUCET  SOLID FLANGE/HOSE END/COLD, EA, 1, R, 6, 24, 0, 0, 0, 0

0009-H1/2H, 763439000118, WALL MOUNT FAUCET  SOLID FLANGE/HOSE END/HOT, EA, 1, R, 6, 24, 0, 0, 0, 0

0029-1, 763439000125, RABBIT EAR FAUCET  PLAIN END/ROUGH BRASS, EA, 1, R, 2, 0, 0, 0, 0, 0

0029-1/2, 763439000132, RABBIT EAR FAUCET  PLAIN END/ROUGH BRASS, EA, 1, R, 8, 0, 0, 0, 0, 0

0029-11/4, 763439000149, RABBIT EAR FAUCET  PLAIN END/ROUGH BRASS, EA, 1, R, 2, 0, 0, 0, 0, 0

 

 

 Package Indicator Level and Quantity - see 1.6 above

CAT #

U.P.C.

DESCRIPTION

U/M

PI-0

PI-1

PI-2

PI-3

PI-4

PI-5

PI-6

PI-7

0006-H1/2C

763439000040

WALL MOUNT FAUCET  ADJUSTABLE FLANGE/HOSE END

EA

1

R

6

24

0

0

0

0

0006-H1/2H

763439000057

WALL MOUNT FAUCET  ADJUSTABLE FLANGE/HOSE END

EA

1

R

6

24

0

0

0

0

0007-1/2

763439000071

WALL MOUNT FAUCET  SOLID FLANGE/PLAIN END

EA

1

R

6

24

0

0

0

0

0007-H1/2

763439000088

WALL MOUNT FAUCET  SOLID FLANGE/HOSE END

EA

1

R

6

24

0

0

0

0

0009-H1/2C

763439000101

WALL MOUNT FAUCET  SOLID FLANGE/HOSE END/COLD

EA

1

R

6

24

0

0

0

0

0009-H1/2H

763439000118

WALL MOUNT FAUCET  SOLID FLANGE/HOSE END/HOT

EA

1

R

6

24

0

0

0

0

0029-1

763439000125

RABBIT EAR FAUCET  PLAIN END/ROUGH BRASS

EA

1

R

2

0

0

0

0

0

0029-1/2

763439000132

RABBIT EAR FAUCET  PLAIN END/ROUGH BRASS

EA

1

R

8

0

0

0

0

0

0029-11/4

763439000149

RABBIT EAR FAUCET  PLAIN END/ROUGH BRASS

EA

1

R

2

0

0

0

0

0
 

 

[bottom.htm]