...
Required column - O=optional, R=required, C=conditional (dependent on other tags)
Chiral column - N=non-chiral (one value per label); Y=chiral (value is right, semi-colon, left - ie 2.50;1.25)
Field Name | Reqd | Chiral | Data Type | Length | Description | Format / Valid Values |
---|---|---|---|---|---|---|
_CUSTNO | O | N | String | 09 | Account Number | |
JOB | R | N | String | 20 | Job number from retail | This information is saved in the “PO#” field. |
_INV | O | N | String | 08 | Invoice number | Use this field if you want to keep the same Invoice Number as |
_OMICS_TRAY_NUM | O | N | String | 06 | Tray Number | Use this field if you want to keep the same Tray Number as |
_JTYPE | R | N | String | 01 | Job Type | Valid Values: |
PATIENT | C | N | String | 21 | Patient Name | This field is not needed if you are using the “_FIRSTNAME” and |
_FIRSTNAME | C | N | String | 21 | First name of patient | Use either PATIENT or combination of first and last name |
_LASTNAME | C | N | String | 21 | Last name of patient | Use either PATIENT or combination of first and last name |
_RDATE | O | N | String | 08 | Date Ordered | YYYYMMDD |
_WDATE | O | N | String | 08 | Date Wanted | YYYYMMDD |
_OPT_WDATE | O | N | String | 8 | Optional date wanted | YYYYMMDD |
REF | O | N | String | 18 | Release Number | |
SHIPTO | O | N | String | 10 | Ship to Number | Each part separated by a comma. |
_SHIPMETHOD or _SHIPMETH | O | N | String | 04 | Shipping Method Code | |
REM | O | N | String | 30 | Remarks or Special Instructions. | Can have up to 11 comment lines. |
_CALLFST
| O | N | String | 01 | Call first before processing. | Valid Entries are: |
_REMAKECODE | O | N | String | 04 | Remake code | An entry in this field sets the REDO flag on the order and |
_RUSH_JOB | O | N | String | 01 | Set Rush indicator on order | Valid Entries are: |
_DOCTOR_ID | O | N | String | 30 | Doctor’s name | |
_ORD_ORIG_INVOICE | O | N | String | 08 | Used to send the original invoice number when sending a remake job | |
_REMAKE_CAT | O | N | String | 04 | Used to send the remake category | |
_PRLIST | O | N | String | 03 | Price list number. | Specify to force pricing to a certain lab price list. |
_TRAY_COLOR | O | N | String | 03 | Used to override the tray color that would normally be associated | |
_LAYOUT | O | N | String | 01 | Indicates whether frame measurements should be considered exact, | Valid Entries are: |
_UNCUTDIAM | O | Y | Numeric | 05 | Diameter to use for thickness for uncut job | Value >= 0 and <= 99.9 |
_USER_DEF_JF | C | N | String | 10 | User Define Job Flow Labels. | |
_FSTATUS | O | N | String | 01 | Frame status for the order | Valid Entries are: "1" or "S"- Supply frame "2" or "F" - Frame to follow "3" or "O" - Other "4" or "E" - Frame enclosed "5" or "L" - Lenses only "6" OR "N" - Supply frame at no charge |
_ROUTE | O | N | String | 04 | Work ticket routing for work ticket | LPT1, LPT2, up to LPT9 If used, this directs the work ticket to be printed to the specified printer routing. If left blank, normal routing rules will be used when the order is processed. |
_BALANCE | O | N | String | 01 | Indicates one eye is a balance lens | Valid entries are R, L or blank _BALANCE=R (introduced in version 7.52) |
_HOLDORDER | O | N | String | 01 | Makes the order processor place an order on hold | Valid entries are Y N or blank |
_REMOTE_USER_NAME | O | N | String | 20 | Name of the user entering the remote order | Introduced in version 7.73 |
Rx And Lens Information
Field Name | Reqd | Chiral | Data Type | Length | Description | Format / Valid Values |
---|---|---|---|---|---|---|
DO | R | Y | String | 01 | Which eye | Valid Values: |
_LSTYLE | C | Y | String | 06 | If _LCODE and UPC are not specified, this field specifies the lab code for the lens style being ordered | |
_MATERIAL | C | Y | String | 02 | If _LCODE and UPC are not specified, this field specifies the lab code for the lens material being ordered | |
_TREAT | C | Y | String | 03 | If _LCODE and UPC are not specified, this field specifies the lab code for the treatment of the lens | This is the Pretreatment that comes already on the lens from the manufacturer. |
_TINT | C | Y | String | 03 | If _LCODE and UPC are not specified, this field specifies the lab code for the tint of the lens | This is the Tint (Color) that comes already on the lens from the manufacturer |
_LCODE | C | Y | String | 02 | Lens Material | Refer to catalogue reference, under the lens section. This is the code from the catalogue You may also use UPC with the UPC translation table to specify materials, lens styles, |
SPH +/- | R | Y | Numeric | 05 | Rx Sphere Power | Range from -39.0 to +49.0 and must be a multiple of 0.125, rounded to 2 |
CYL +/- | O | Y | Numeric | 05 | Rx Cylinder Power | Valid values range from-19.75 to +19.75, in increments of 0.125, rounded to |
AX | C | Y | Integer | 03 | Prescribed Cylinder Axis. | Valid values range from 0 to 180. |
IPD | R | Y | Numeric | 03 | Far PD: The far interpupillary distance for Multifocals and can be entered as | Valid range values: |
NPD | C | Y | Numeric | 03 | Near PD or Vertical Decentration: | Valid range values: For SV-Style lenses, this field represents the distance above or below the datum of the OC. |
OCHT | O | Y | Numeric | 04 | Vertical O.C. height measured from the lower boxes tangent of the frame. | |
ADD | C | Y | Numeric | 04 | The add power of the multifocal segment; required for multifocal lenses | 99.99 |
ADD2 | C | Y | Numeric | 04 | The add power of the upper segment in an occupational lens | 99.99 |
SEGHT | C | Y | Numeric | 03 | Segment Height | Ex: SEGHT=19;19 |
SEGDHT | O | Y | Numeric | 04 | The field contains the length in millimeters from the top of the segment or fitting cross (if progressive type lens) or the vertical decentration point of a single vision lens, to the point where the vertical line would cross the frame. The position of the line would be vertically from the distance power location (see diagram).
When the SEGDHT is supplied, the value is used along with a trace pattern, to calculate the value of SEGHT of a multi-focal lens or the vertical decentration of a single vision lens.. | Ex: SEGDHT=10.2;10.2 |
PRVM +/- | O | Y | Numeric | 04 | Rx Prism in diopters | Ex: |
PRVA | C | Y | String | 03 | Rx Prism direction | Ex: |
ELLH | O | Y | Numeric | 02 | Elliptical Cribbing | Ex: ELLH=62;62 |
_SUPELLH | O | Y | String | 01 | Suppress Elliptical Cribbing | Valid Values are: |
THNP | O | Y | Numeric | 03 | Requested edge thickness at the thinnest edge | Ex: THNP=1.5;1.5 |
_PRTHIN | O | N | String | 01 | Prism Thinning | Valid Entries Are: |
_ADDON | O | N | String | 06 | Add-on Codes | Codes specified by receiving lab or from catalogue. As of version 7.59.02, _ADDON can also be specified as: |
CLASS | O | Y | String String | 03 03 | To force Finished (Stock) or Semi-Finish lenses per eye | Valid Values |
_FORCESF_F | O | Y | String | 01 | To force Semi-Finish or Finished (Stock) lenses on your job | Valid Values: |
_RFRONT | O | Y | String | 04 | Requested Nominal Front Curve | Ex: _RFRONT=0400;0400 |
_RDIA | O | Y | Numeric | 02 | Requested Blank (Lens) Diameter | Ex: _RDIA=76;76 |
_LMFRID | O | Y | String | 04 | Lens Manufacturer | If you want to force Rx-Universe to select a lens from a certain manufacturer |
OPC | O | Y | Numeric | 10 | Lens OPC Code | Select lenses by OPC codes |
SWIDTH | C | Y | Numeric | 02 | Segment Width | Ex:_SWIDTH=28;28 |
SDEPTH | C | Y | Numeric | 02 | Segment Depth of the Intermediate Segment. Required only for Trifocal lenses | Ex:SDEPTH=08;08 |
LNAM | O | Y | String | 23 | VCA Label Translation | |
LTYP | O | Y | String | 23 | VCA Label Translation | |
HBOX | C | O | Numeric | 03 | Horizontal box lens size of the frame. This is the “A” measurement | Valid range of values is from 30.0 to 80.0 mm |
VBOX | C | O | Numeric | 03 | Vertical boxes lens size of the frame. This is the “B” measurement. | Valid range of values is from 15.0 to 60.0 mm |
_EDBOX | C | O | Numeric | 03 | “ED” measurement of the box measurement system. The widest possible |
and temple are not supplied.Valid range of values
the brow, cheek, | Valid range of values is from 30.0 to 80.0 mm | |||||
FED | C | N | Numeric | 03 | FED or ED measurement of the frame - same as _EDBOX | Valid range is from 30.0 to 80.0 mm |
DBL | C | N | Numeric | 03 | Distance Between Lenses | Valid range of values is from 7.0 to 30.0 mm |
ETYP | O | N | String | 01 | Type of edge to cut on lens. | Valid Entries are: |
SFTHK | O | N | String | 01 | This field needs to be placed after the “ETYP” field | Y = Safety Thickness |
FTYP | O | N | Numeric | 01 | Frame Type | Valid Entries are: |
_SHAPE | O | N | String | Stored trace in RxUniverse that are saved as shapes (SHAP) names | Rx-Universe will look into the Trace Database for a Frame Name matching the value of “_SHAPE”, with the Manufacturer of “SHAP”. The VBOX and HBOX fields are checked against the stored shape's values and the _SHAPE trace will be resized accordingly and an INV# trace will be created using the order number as the trace name with the resized trace information and this will be attached to the received order. If no VBOX or HBOX values were supplied in the remote order file, then the _SHAPE name is stored as the trace information name on the order with no adjustments made to the trace. Note the _SHAPE traces are for calculations only and cannot be used on an edging machine. | |
_TRACE | O | N | String | 12 | Trace Number | Rx-Universe will look into the Pattern Database for a Frame Name matching the value of “_TRACE”, with a Manufacturer of “DATA”, the Nominal A Size field being blank and the Nominal Bridge field being blank. The VBOX and HBOX fields are checked against the stored trace's values and the _TRACE data points will be resized accordingly and an INV# trace will be created using the order number as the trace name and the resized trace information, this INV# trace will be attached to the received order. If no VBOX or HBOX values were supplied in the remote order file, then the _TRACE name is stored as the trace information name on the order with no adjustments made to the trace. |
_CCIRC | O | N | Numeric | 04 | You can specify the actual circumference of the customer’s frame. | Ex: CIRC=138.4 |
_SLAB | O | N | String | 01 | Slab-Off | Valid Entries are: "Y" - Yes "N", "?", spaces or ":" - No "R" - Reverse |
_WRAP | O | N | String | 01 | To take advantage of the Wrap Frame Calculation. | Valid Entries are: |
ZTILT | O | N | Numeric | 03 | Panoramic (Wrap) Angle | Valid range of values is from 0 to 30.0 degrees |
PANTO | O | N | Numeric | 03 | Pantoscopic (Angle) Tilt | Valid range of values is from 0 to 30.0 degrees |
BVD | O | N | Numeric | 03 | Vertex Fitting. Back vertex distance, as worn (mm) | Valid range of values is from 5 to 30 mm |
RVD | O | N | Numeric | 03 | Refracted Vertex Distance - Back vertex distance, as refracted (mm) | Valid range of values is from 5 to 30 mm
|
TRCFMT | O | N | Numeric | 01 | Format of frame trace data | Valid Entries are: |
Number | 04 | Number of radii in the trace | ||||
String | 01 | Radius mode identifier | Valid Entries are: | |||
String | 01 | Which eyes are included | Valid Entries are: | |||
ZFMT | O | N | Numeric | 01 | Format of vertical height frame trace data | Valid Entries are: |
Number | 04 | Number of radii in the trace | ||||
String | 01 | Radius mode identifier | E – the radii are evenly spaced | |||
String | 01 | Which eyes are included | R – Right | |||
R | C | N | Numeric | 05 | Radius Data | Separate values for this field by a semi-colon “;” such as: |
A | C | N | Numeric | 05 | Angle data for radius data (angular locations of trace radii expressed | Separate values for this field by a semi-colon “;” such as: |
Z | C | N | Numeric | 05 | Radius Data | Separate values for this field by a semi-colon “;” such as: |
CTHICK | O | Y | Numeric | 05 | Center thickness - used only if a specific center thickness is desired for the lens. This can | CTHICK=2.3;2.3 |
UPC | O | Y | Numeric | 12 | This is a translation code that can be used with the UPC translation file to specify either lens style, material, tint and treatment, or an addon code. This allows a third party system to send one code that can be translated on the Rx-Universe side into the lab's codes for the lens product. |
Frame and Miscellaneous Inventory Items
...
Field Name | Reqd | Chiral | Data Type | Length | Description | Format / Valid Values |
---|---|---|---|---|---|---|
CLINIT | N | String | Wearer’s Initials | up to 4 alphanumeric characters | ||
CLHT | N | Numeric | Client Height in meters | |||
HEADK | N | Numeric | Head Eye Coefficient | Measured by Visi-Office | ||
HEADS | N | Numeric | Stability Coefficient | Measured by Visi-Office | ||
_NVI | Y | Numeric | Near Vision Inset | Inset of the near vision segment relative | ||
NWD | N | Numeric | Near Working Distance | Working object distance at near viewing | ||
ERCD | Y | Numeric | Eye Rotation Center Distance | Measured by Visi-Office | ||
CAPE | Y | Numeric | Cape Head Angle | Measured by Visi-Office | ||
_LP | Y | Progression Length (corridor length) | Valid values vary by design | |||
DMNTEYE | N | Dominant Eye | R-right, L-left, or N-none | |||
_CLLAT | N | Laterality (Dominant Hand) | Valid Entries are: | |||
NOD | Y | Numeric | Refracted object distance at near viewing point (meters) | Valid values 0.20 to 0.60 m | ||
CLNVB | N | String | 7 | Near Vision Behaviour, used for Essilor Varilux X designs | Must be 7 alphanumeric characters; for example CLNVB=HCN7DEV( | |
CCBLND or _LTLVL | O | Y | Numeric | 2 | Digital Lenticular Blending | A value between 0 and 10 depending on the digital type. 0-2 for "Essilor", "Crossbows", "Rx-Me", "Rx-PRO" and "A2Vision". 0-10 for all other digital vendors. |
CCBOWL or _LTDIA | O | Y | Numeric | 2 | Digital Lenticular Bowl | A value between 30 and 90 |
CLLIFE | O | N | String | CLLIFE option for specified digital design(s) | Valid values are "Static" or "Active" |
This ASCII text file will be generated at the retail site and be sent to the lab from which they are placing their order. The following is an example of items you can find in an order file (RAW file):
...