iZySolutions - Documentation

FAQ - Excel format for lenses - Manufacturing grids tab

Owned by hachmi Benthanane
Last updated: Jan 05, 2022
1 min read

If several diameters of a lens exist for the same definition of manufacturing grid, then a line must be indicated for each diameter.

Tab

Possible fields and values for enumerations

Example

Mandatory / Optional / Conditional

Further information

Lens

Manufacturer code

IZY

Mandatory

 

Distributor code

IZY

Mandatory

 

Product code

A001XX

Mandatory

 

Groupment code

 

Optional

 

Catalog state

Action
1 : Edit
2 : Delete

1

Mandatory

 

Validity start date

 

Optionnel

 

Validity end date

 

Optionnel

 

Grid definition

Nominal diameter dn (Purchasing diameter)

60

Mandatory

 

Effective diameter de (Physical diameter)

60

Mandatory

 

EDI ordering code for the diameter

 

Optional

Enter a value only if the expected code is different from the value of the effective diameter * 100

Usable diameter

 

Conditional

Only if the grid is for aphakic lens

Range type
1 : Stock
2 : RX
3 : Outside manufacturing range

2

Mandatory

 

Range name

Rx

Mandatory

 

Point 1: cylinder

0

Mandatory

 

Point 1: sphere

-10

Mandatory

 

Point 2: sphere

6

Mandatory

 

Point 3: cylinder

4

Mandatory

 

Point 4: sphere

-10

Mandatory

 

Point 3: sphere

2

Mandatory

 

Minimal addition

 

Conditional

Please indicate if the lens is :

Progressive

Bifocal

Trifocal

Mid-distance (optional)

Maximal addition

 

Conditional

addition step

 

Conditional

Manufacturing range step

0,25

Mandatory

 

Max prism

SF6 specificity

Optional

Managed only in SF6. Allows you to indicate for a particular grid a restriction on the value of the Maximum Prism allowed for the manufacturing grid

Automated processing
0 : No
1 : Yes

 

 

If empty then the value will be 0.

Balance lens availability
0 : No
1 : Yes

1

 

If empty then the value will be 0.

Marketing

Time to delivery

 

Optional

 

Latest ordering time

 

Optional

 

Electronic ordering
0 : Prohibited
1 : Mandatory
2 : Optional

2

Mandatory

 

Remisable
0 : No
1 : Yes

SF6 specificity

 

If empty then the value will be 0.

Modification date

 

Optional

If empty then the current date will be shown

© 2018 iZySolutions