...
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
...