New Databaseformat

Posté par root le Mar, 2009-05-05 12:30.
Pour de plus amples informations, consultez ce fichier excel.


001 ID SUPPLIER

Code: Alphanumeric | Characters max: 20 | Importance: A


002 TARIFNAME

Code: Alphanumeric | Characters max: 20 | Importance: B


003  VALIDITY

Code: Alphanumeric | Characters max: 8 | Importance: A


004 TARIFDATE ONLINE

Code: Numeric  | Importance: B


005 BRAND

Code: Alphanumeric | Characters max: 20 | Importance: A


006 MANUFACTURER

Code: Alphanumeric  | Importance: B


007 RANGE

Code: Alphanumeric | Characters max: 20 | Importance: A


008 ID ARTICLE

Code: Alphanumeric | Characters max: 20 | Importance: A


009 ID ARTICLE INTERNAL

Code: Alphanumeric | Characters max: 20 | Importance: A


010 ID ARTICLE COMPLETE

Code: Alphanumeric | Characters max: 20 | Importance: A


011 GROSS PRICE IN EURO

Code: Numeric | Characters max: 12 | Importance: A


012 GUIDE PRICE

Code: Numeric   | Importance: B


013 PRICE UNIT

Code: Numeric | Characters max: 4 | Importance: A


014 VAT CODE (%)

Code: Alphanumeric  | Importance: B


015 PACKAGE UNIT

Code: Alphanumeric | Characters max: 20 | Importance: A


016 LBL DESC DUTCH SHORT

Code: Alphanumeric | Characters max: 40 | Importance: A


017 LBL DESC FRENCH SHORT

Code: Alphanumeric | Characters max: 40 | Importance: A


018 LBL DESC GERMAN SHORT

Code: Alphanumeric | Characters max: 40 | Importance: C


019 LBL DESC ENGLISH SHORT

Code: Alphanumeric | Characters max: 40 | Importance: B


020 PROD LIFE PHASE

Code: Alphanumeric | Characters max: 1 | Importance: B


021 PROD LIFE DATE

Code: Numeric | Characters max: 8 | Importance: B


022 PROD MODIF TYPE

Code: Alphanumeric | Characters max: 1 | Importance: B


023 PRICE MODIF TYPE

Code: Alphanumeric | Characters max: 1 | Importance: B


024 ID ARTICLE SUBSTITUTION

Code: Alphanumeric | Characters max: 20 | Importance: B


025 ID ARTICLE PRECEDING

Code: Alphanumeric | Characters max: 20 | Importance: B


026 BEBAT CODE 

Code: Alphanumeric | Characters max: 5 | Importance: A


027  BEBAT QUANTITY

Code: Numeric | Characters max: 5 | Importance: A


028 RECUPEL CODE APPLIANCES 

Code: Alphanumeric | Characters max: 8 | Importance: A


029 RECUPEL QUANTITY APPLIANCES

Code: Numeric | Characters max: 5 | Importance: A


030 RECUPEL CODE LAMPS

Code: Alphanumeric | Characters max: 8 | Importance: A


031 RECUPEL QUANTITY LAMPS

Code: Numeric | Characters max: 5 | Importance: A


032 RECUPEL CODE TORCHES

Code: Alphanumeric | Characters max: 5 | Importance: A


033 AUTHOR CODE

Code: Alphanumeric | Characters max: 5 | Importance: A


034 AUTHOR QUANTITY

Code: Numeric | Characters max: 5 | Importance: A


035 SURCHARGE BRASS

Code: Alphanumeric | Characters max: 5 | Importance: A


036 SURCHARGE PVC

Code: Alphanumeric | Characters max: 5 | Importance: A


037 SURCHARGE LEAD

Code: Alphanumeric | Characters max: 5 | Importance: A


038 MINIMUM ORDER QUANTITY

Code: Numeric | Characters max: 6 | Importance: A


039 EAN CODE A PIECE

Code: Alphanumeric | Characters max: 13 | Importance: A


040 MEASUREMENT UNIT CODE

Code: Numeric | Importance: A


041 WEIGHT UNIT CODE

Code: Numeric | Importance: A


042 WEIGHT (PIECE)

Code: Numeric | Characters max: 10 | Importance: A


043 LENGTH (PIECE)

Code: Numeric | Characters max: 10 | Importance: A


044 WIDTH (PIECE)

Code: Numeric | Characters max: 10 | Importance: A


045 HEIGHT (PIECE)

Code: Numeric | Characters max: 10 | Importance: A


046 VOLUME (PIECE)

Code: Numeric | Characters max: 10 | Importance: B


047 EAN CODE A BOX

Code: Alphanumeric | Characters max: 13 | Importance: A


048 CONTENT A BOX

Code: Numeric | Characters max: 10 | Importance: B


049 WEIGHT (BOX)

Code: Numeric | Characters max: 10 | Importance: B


050 LENGTH (BOX)

Code: Numeric | Characters max: 10 | Importance: B


051 WIDTH (BOX)

Code: Numeric | Characters max: 10 | Importance: B


052 HEIGHT (BOX)

Code: Numeric | Characters max: 10 | Importance: B


053 VOLUME (BOX)

Code: Numeric | Characters max: 10 | Importance: B


054 EAN CODE (OUTBOX)

Code: Alphanumeric | Characters max: 13 | Importance: B


055 CONTENT (OUTBOX)

Code: Numeric | Characters max: 10 | Importance: B


056 WEIGHT (OUTBOX)

Code: Numeric | Characters max: 10 | Importance: B


057 LENGTH (OUTBOX)

Code: Numeric | Characters max: 10 | Importance: B


058 WIDTH (OUTBOX)

Code: Numeric | Characters max: 10 | Importance: B


059 HEIGHT (OUTBOX)

Code: Numeric | Characters max: 10 | Importance: B


060 VOLUME (OUTBOX)

Code: Numeric | Characters max: 10 | Importance: B


061 EAN CODE A PALLET

Code: Alphanumeric | Characters max: 13 | Importance: B


062 CONTENT A PALLET

Code: Numeric  | Characters max: 10 | Importance: B


063 WEIGHT (PALLET)

Code: Numeric | Characters max: 10 | Importance: B


064 LENGTH (PALLET)

Code: Numeric | Characters max: 10 | Importance: B


065 WIDTH (PALLET)

Code: Numeric | Characters max: 10 | Importance: B


066 HEIGHT (PALLET)

Code: Numeric | Characters max: 40 | Importance: B


067 VOLUME (PALLET)

Code: Numeric | Characters max: 10 | Importance: B


068 SERVICE CODE

Code: Numeric | Characters max: 5 | Importance: B


069 WARRANTY (MONTHS)

Code: Numeric | Characters max: 2 | Importance: C


070 DELIVERY WORKDAYS

Code: Numeric | Characters max: 2 | Importance: A


071 STOCK PRODUCT

Code: Alphanumeric | Characters max: 4 | Importance: A


072 KG CU/KM

Code: Numeric | Characters max: 5 | Importance: B


073 COEFFICIENT

Code: Numeric | Characters max: 5 | Importance: B


074 CABLE BEL CODE

Code: Alphanumeric | Characters max: 12 | Importance: B


075 LENGTH ON DRUM

Code: Numeric | Characters max: 10 | Importance: B


076 WIDTH DRUM

Code: Alphanumeric | Characters max: 10 | Importance: B


077  DIAMETER DRUM

Code: Numeric | Characters max: 10 | Importance: B


078 WEIGHT DRUM

Code: Numeric | Characters max: 10 | Importance: B


079 DRUM - CHARGE - NO CHARGE

Code: Alphanumeric | Characters max: 4 | Importance: B


080 LENGTH ON COIL

Code: Alphanumeric | Characters max: 4 | Importance: B


081 WIDTH COIL

Code: Alphanumeric | Characters max: 4 | Importance: B


082 DIAMETER COIL

Code: Alphanumeric | Characters max: 4 | Importance: B


083 WEIGHT COIL

Code: Alphanumeric | Characters max: 4 | Importance: B


084 PRODUCT GROUP

Code: Alphanumeric | Characters max: 10 | Importance: A


085 DISCOUNT CODE

Code: Alphanumeric | Characters max: 10 | Importance: A


086 INTRASTAT CODE

Code: Alphanumeric | Characters max: 10 | Importance: B


087 INTRASTAT COUNTRY CODE

Code: Alphanumeric | Characters max: 5 | Importance: B


088 INTRASTAT COMPLEMENTARY UNIT CODE

Code: Alphanumeric | Importance: B


089 INTRASTAT NUMBER OF COMPLEMENTARY UNIT

Code: Alphanumeric | Importance: B


090 ICGME CODE TOP

Code: Alphanumeric | Characters max: 1 | Importance: B


091 ICGME CODE SUB

Code: Alphanumeric  | Characters max: 3 |  Importance: B


092 ICGME CODE

Code: Alphanumeric | Characters max: 6 | Importance: B


093 BELLIDIC CODE

Code: Alphanumeric | Characters max: 2 | Importance: B


094 ETIM CODE

Code: Alphanumeric | Characters max: 8 | Importance: C


095 ETIM CHARACTERISTIC

Code: Alphanumeric | Importance: C


096 ETIM VALUE

Code: Alphanumeric | Importance: C


097 ETIM VERSION

Code: Alphanumeric | Importance: C


098 UNSPEC CODE

Code: Alphanumeric | Characters max: 8 | Importance: C


099 CAT PAGE

Code: Alphanumeric | Characters max: 10 | Importance: B


100 CAT VERSION

Code: Alphanumeric | Characters max: 10 | Importance: B


101 LBL DESC DUTCH LONG

Code: Alphanumeric | Characters max: 70 | Importance: A


102 LBL DESC FRENCH LONG

Code: Alphanumeric | Characters max: 70 | Importance: A


103 LBL DESC GERMAN LONG

Code: Alphanumeric | Characters max: 70 | Importance: C


104 LBL DESC ENGLISH LONG

Code: Alphanumeric | Characters max: 70 | Importance: B


105 URL PROD PICTURE

Code: Alphanumeric | Characters max: 256 | Importance: A


106 URL PROD PICTURE ENVIRONMENT

Code: Alphanumeric | Characters max: 256  | Importance: C


107 URL CE CERTIFICATE

Code: Alphanumeric | Characters max: 256 | Importance: C


108 URL WARRANTY DUTCH

Code:Alphanumeric | Characters max: 256 | Importance: C


109 ULR WARRANTY FRENCH

Code: Alphanumeric | Characters max: 256 | Importance: C


110 URL WARRANTY GERMAN

Code: Alphanumeric | Characters max: 256 | Importance: C


111 URL WARRANTY ENGLISH

Code: Alphanumeric | Characters max: 256 | Importance: C


112 URL ASSEMBLY PRESCRIPTION DUTCH

Code: Alphanumeric | Characters max: 256 | Importance:C


113 URL ASSEMBLY PRESCRIPTION FRENCH

Code: Alphanumeric | Characters max: 256 | Importance: C


114 URL ASSEMBLY PRESCRIPTION GERMAN

Code: Alphanumeric | Characters max: 256 | Importance: C


115 URL ASSEMBLY PRESCRIPTION ENGLISH

Code: Alphanumeric | Characters max: 256 | Importance: C


116 URL SAFETY PRESCRIPTION DUTCH

Code: Alphanumeric | Characters max: 256 | Importance: C


117 URL SAFETY PRESCRIPTION FRENCH

Code: Alphanumeric | Characters max: 256 | Importance: C


118 URL SAFETY PRESCRIPTION GERMAN

Code: Alphanumeric | Characters max: 256 | Importance: C


119 URL SAFETY PRESCRIPTION ENGLISH

Code: Alphanumeric | Characters max: 256 | Importance: C


120  URL TECHNICAL INFORMATION DUTCH

Code: Alphanumeric | Characters max: 256 | Importance: B


121  URL TECHNICAL INFORMATION FRENCH

Code: Alphanumeric | Characters max: 256 | Importance: B


122  URL TECHNICAL INFORMATION GERMAN

Code: Alphanumeric | Characters max: 256 | Importance: B


123  URL TECHNICAL INFORMATION ENGLISH

Code: Alphanumeric | Characters max: 256 | Importance: B


124 URL OPERATING INSTRUCTIONS DUTCH

Code: Alphanumeric | Characters max: 256 | Importance: C


125 URL OPERATING INSTRUCTIONS FRENCH

Code: Alphanumeric | Characters max: 256 | Importance: C


126 URL OPERATING INSTRUCTIONS GERMAN

Code: Alphanumeric | Characters max: 256 | Importance: C


127 URL OPERATING INSTRUCTIONS ENGLISH

Code: Alphanumeric  | Characters max: 256 | Importance: C


128 URL OPERATING INSTRUCTIONS DUTCH

Code: Alphanumeric | Characters max: 256 | Importance: C


129 URL SPECIFIC INFORMATION FRENCH

Code: Alphanumeric | Characters max: 256 | Importance: C


130 URL SPECIFIC INFORMATION GERMAN

Code: Alphanumeric | Characters max: 256 | Importance: C


131 URL SPECIFIC INFORMATION ENGLISH

Code: Alphanumeric | Characters max: 256 | Importance: C


132 URL PROD SPECIFICATIONS DUTCH

Code: Alphanumeric | Characters max: 256 | Importance: C


133 URL PROD SPECIFICATIONS FRENCH

Code: Alphanumeric | Characters max: 256 | Importance: C


134 URL PROD SPECIFICATIONS GERMAN

Code: Alphanumeric | Characters max: 256 | Importance: C


135 URL PROD SPECIFICATIONS ENGLISH

Code: Alphanumeric | Characters max: 256 | Importance: C