Table of Contents
Head.Dat
Description
In the Head.Dat file, all data occurring only once in the database is saved.
Tabellenstruktur
No. | Fieldname | Pos | Length | Format | Comments |
---|---|---|---|---|---|
1* | Fieldname | 1 | 30 | T30 | Field names are listed in the next paragraph. |
2 | Fieldvalue | 31 | ? | ? | The length is dependent on the field value. The format and therefore the field length is defined “Fieldnames” |
Fieldnames
No. | Name | Format | Description/Comment |
---|---|---|---|
1 | version | T10 | Version of the data format. The value of this version is always identical to “6.10.2” (without quotation marks) |
1a | Software-id | T40 | Unambiguous name incl. version of the software with which the price list data were generated. |
1b | comment | T200 | Brief comment on the price list description |
1c | uid-manufacturer | T50 | Unique number clearly allocated to manufacturer to clearly mark the database(corresponds to file name in ZIP file) |
1d | uid-postedit | T50 | Unique number clearly allocated to reprocessing to clearly mark the database. (Note: value or format not yet defined, i.e. evaluation not yet possible). |
2 | Valid-from | D | |
3 | Valid-until | D | Open if no expiry date has been specified. |
4 | country | T2 | 2-digit international country code according to ISO 3166-1 ALPHA-2 DE = Germany EN = England FR = France NL = Netherlands etc. This value is also used in the ZIP file name. (See chapter 5.3) |
4a | language | T2 | The code for the language version is defined according to ISO 639-1 Alpha-2. EN = English FR = French DE = German etc. This value is also used in the ZIP file name. (See chapter 5.3) |
5 | manufacturer-code | T3 | Used codes are specified in the company list |
5a | manufacturer-subcode | T3 | Is used to define different price lists of a manufacturer (e.g. for purchasing groups) |
6 | manufacturer-name | T40 | |
6a | manufacturer-subname | T40 | |
7 | manufacturer-name-1 | T40 | Postal address Name1 |
8 | manufacturer-name-2 | T40 | Postal address Name1 |
9 | street | T40 | |
10 | zip-code | T8 | |
11 | city | T40 | |
12 | po-box-zip-code | T8 | Zip code, P.O.Box |
13 | po-box-text | T40 | Text P.O.Box |
14 | phone | T40 | |
15 | fax | T40 | |
16 | phone-order | T40 | |
17 | fax-order | T40 | |
18 | T40 | ||
19 | URL | T40 | |
20 | pricedefinition-cylinder | T1 | “+” = the prices are displayed for plus cylinders “-” = the prices are displayed for minus cylinders |
21 | cylindergroup-base | 9 | Standard = 4 dpt |
22 | cylindergroup-1 | 9 | Standard = 6 dpt |
23 | cylindergroup-2 | 9 | Standard = 8 dpt |
24 | prismgroup-1 | 99 | Standard = 03 |
25 | prismgroup-2 | 99 | Standard = 06 |
26 | prismgroup-3 | 99 | Standard = 10 |
27 | prismgroup-4 | 99 | Standard = 15 |
28 | prismgroup-5 | 99 | Standard = ' ' |
29 | currencydescription | T3 | Euros or country-specific currency |
30 | currencydescription-decimals | T3 | Ct or country-specific currency |
31 | pricefield-01 | 99 | 00 = not filled 10 = EK (purchase price) 20 = recomm. VK (selling price) 21 = recomm. VK incl. insurance 25 = recomm. VK level 1 CH 26 = recomm. VK level 2 (CH) 40 = bonus EK 50 = VK (material price incl. manual processing, or calculated VK) 52 = manual processing 55 = calc. VK level 1 CH 56 = calc. VK level 2 (CH) 90 = other EK 91 = other VK (re fields 90, 91: description is specified in the “pricefield-description-01” field) |
32 | pricefield-02 | 99 | Like price field 1 |
33 | pricefield-03 | 99 | Like price field 1 |
34 | pricefield-04 | 99 | Like price field 1 |
35 | pricefield-05 | 99 | Like price field 1 |
36 | pricefield-description-01 | T40 | If the value for price field 01 = 90 or 91, the relevant price type is specified in plain text. |
37 | pricefield-description-02 | T40 | See description of price field 1 |
38 | pricefield-description-03 | T40 | See description of price field 1 |
39 | pricefield-description-04 | T40 | See description of price field 1 |
40 | pricefield-description-05 | T40 | See description of price field 1 |
41 | Characterset | 99 | The value stands for the number of the ISO 8859 character set used in these files. 1 = ISO 8859-1 (Latin-1) 2 = ISO 8859-2 (Latin-2) 5 = ISO 8859-5 (Cyrillic) etc. See also http://de.wikipedia.org/wiki/ASCII |
42 | printpricelist-filename-pdf | T99 | File name of price list PDF A file with this file name must be available in the ZIP-file. Spaces and special characters must not be used for these file names. |
43 | printpricelist-filename-xfdf | T99 | File name of price list XFDF A file with this file name must be available in the ZIP-file. Spaces and special characters must not be used for these file names. |
44 | Pricefield-decimals | 9 | 0 (or empty) = two decimal places 1 = no decimal place |
Example
123456789012345678901234567890123456789012345678901234567890 version 6.10.2 valid-from 20031210 valid-until 20031210 country DE language DE manufacturer-code GLK manufacturer-subcode EKG manufacturer-name Glasfabrik Köln manufacturer-name-1 manufacturer-name-2 street Musterstrasse 23 zip-code 51143 usw......
(Note: The first, underlined line merely serves for a better overview and is not available in the file).
Notes
The version is always displayed in the format x.y.z, with x being the major version, y the minor version and z the subminor version. The numbers are not limited to one digit. (6.6.23 is possible).
Five price fields, ”pricefield-xx”, were defined, specifying the price type in the LensPrice.Dat and OptionsPrice.Dat files. If the value of a ”pricefield-xx” price field is 00 or if the price field is not available as a data set in the Head.Dat file, no price is available for this price field in LensPrice.Dat or OptionsPrice.Dat. If a value has been specified for a price field, prices must be specified in LensPrice.Dat and OptionsPrice.Dat or be available as a data set.
“pricedefinition-cylinder” indicates whether the price groups for lenses are displayed as minus or plus cylinders. This field has been added because different displays are used in the various countries and the present format has been developed for international use.
Higher cylinders
In order to manage a uniform extra charge for all lenses for cylinders from a certain value , the Head.Dat file contains the following fields: „cylindergroup-base“, “cylindergroup-1“ and “cylindergroup-2“. The following values have been assigned to these fields as a standard:
cylindergroup-base = 4 cylindergroup-1 = 6 cylindergroup-2 = 8
For cylindergroup-1 and cylindergroup-2, the extra charges are stored in the “OptionsPrice.Dat” file under the IT code Z2 or Z3. See the notes under point 13.3 (38). Usually, the price groups for the lenses are specified with the maximum of one cylinder which is specified in cylindergroup-base.
Example: Sph/Cyl 6/0 6/2 6/4
Price group 6/6 is not required, as the extra charge for “higher cylinders” can be used here.
Example: If the price of a lens with Sph 5.25D /cyl 5.50D is to be determined, the price for price group 6/4 is used, and the price from the Options.Dat file with IT code Z2 is then added to this price.
If the extra charge defined in cylindergroup-1 and cylindergroup-2 or Z2 and Z3 is not applicable, price groups with the accordingly high cylinder group can be created for this lens in the LensPrice.Dat file (e.g. 6/6). As soon as a price group with accordingly high values (above the value of cylindergroup-base), is available, this price is automatically used for price determination and the extra charge for higher cylinders is ignored.
Please note that the power range specified in the LensRange.Dat file is always decisive for the deliverability of a lens.