wiki.b2bOptic.com

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== 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 [[en:companies:index|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|mail|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**

<code>
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......
</code>
(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:

<code>
cylindergroup-base	= 4
cylindergroup-1	= 6
cylindergroup-2	= 8
</code>

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.