Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Field

Description

Part Type

This field defines the type of item. (Whole, Front, Temple, Bridge, Clip, Side Shield, Miscellaneous)

Name

The name associated to the item

Manufacturer

The manufacturer that makes the item

Gender

The gender the item was designed to be worn by

Collection

The collection the item belongs to

Brand

The brand of the item

Model

The model of the item

Class

The class of the item (Standard or Safety)

Print Sticker Template

The template used when printing the SKU label (The template must be an XML file and saved on the RX-XML folder in your Rx-Universe directory

Material

The material the item is made of

Color

The color of the item

Edge Type

The edge type of the frame. (This is provided by the Rx-Universe)

 Eye

 The eye measurement. It only accepts whole number

 Temple

 The temple measurement. It only accepts whole number

 Bridge

 The bridge measurement. It only accepts whole number

A

The horizontal width of each lens at its widest point of the lens within the frame. This commonly has the same value as the eye.

B

The vertical height of the lenses at the widest point of the lens within the frame.

ED

The longest diagonal distance inside the frame edges in mm

REQ BC

The requested base curve for the item

Min BC

The smallest accepted base curve that will fit in the frame

UPC

The Universal Product Code for the item. This is the most common frame identifier and is the code printed on the barcode sticker label.

Manufacturer UPC

This is the univesal product code used by the manufacturer to identify this item

Cost

The cost of item charged by the supplier

MSRP

The Manufacturer Suggested Retail Price of the item

Suggested Retail Price

The suggested retail price for the frame

Price Group

The price group that the frame is a member of

Trace

The trace of the frame. The options that show on this field comes from Rx-Universe.

Status

The status on the item in the inventory.

Reorder Method

The method used to reorder this item. There are

Min/Max - Based on the set minimum or maximum quantity available in the warehouse. If an inventory item is below the set minimum, it will be flagged as needs replenishment.

Quantity Replenishment -

Dynamic -

Vendor Default - Based on the set reormethod ofreorder method on the vendor profile of the item

Dynamic Days

The number of days after item creation to switch from min/max to usage history reorder method

Description

An optional freetext description of the item

Source

How the item was imported into the system

Vision Star Item Number

Primarily used when importing from Vision Star. This is used for the “CODE” field of the frame extract file that is sent to AcuityLogic.

Created

The date and time the item was created in the system

Date Last Used

The date when the frame was most recently used

Date Last Modified

The date when a change was most recently made to this item, it's associated categories, or it's value on a price list

Back Order Date

The date the item is expected to be available again. This is only availale if the frame has “Back Ordered” status.

Frame - Warehouse Fields Definitions

...