Overview
The Frame Report target provides users with access to reportable columns containing standard frame information, size, and other frame details.
Permissions
To manage permissions for the Frame Report, go to Rx-Hub → Roles → (Specific Role) → Rx-Inventory. You can grant Design and/or Run permissions to a role based on the level of access you want to provide to the user. Learn more or get a refresher on how our User Roles and Permissions work.
Column Definitions
Here is the list of the available fields on the Frame Report target and their brief descriptions.
Frame - Main Columns
Column Name | Description | Data Type |
|---|---|---|
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. | Text |
Manufacturer UPC | This is the Universal Product Code assigned by the manufacturer to the item | Text |
Trace | The id of the trace associated to the item (if available) | Text |
Size | ||
Standard Cost | The standard cost of item charged by the supplier | Float (with two decimal place) |
Average Cost | The average cost of the frame across all receipts at all warehouses | Float (with two decimal place) |
Manufacturer Suggested Retail Price | The Manufacturer Suggested Retail Price of the item | Float (with two decimal place) |
Suggested Retail Price | The suggested retail price for the frame | Float (with two decimal place) |
Price Group | The price group that the frame is a member of | Text |
Color | The color associated to the item | Text |
Frame Details | ||
Status | The status of the item in the inventory (Active, Inactive, BackOrdered, On Order, Recalled, Discontinued) | Text |
Source | Indicates how the item was imported into the system | Text |
Created | The date and time the item was created in the system | DateTime |
Last Used | The date when the frame was most recently used | Date |
Back Order Date | The date the item is expected to be available again. This is only availale if the frame has “Back Ordered” status. | Date |
Dynamic Days | The number of days after item creation to switch from min/max to usage history reorder method | Integer |
Description | An optional freetext description of the item | Text |
Source | How the item was imported into the system | Text |
Last Import File | The name of the file that last updated this frame (if applicable) | Text |
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 | Date |
Time Last Modified | The time when a change was most recently made to this item, it's associated categories, or it's value on a price list | Time |
Web? | This flag tracks if the frame is displayed on the lab's website if applicable. | Boolean |
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. | Text |
Frame Size Columns
Column Name | Description | Data Type |
|---|---|---|
Temple | The temple measurement. | Integer |
Bridge | The bridge measurement. | Integer |
Eye | The eye measurement. | Integer |
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. | Float (with single decimal place) |
B | The vertical height of the lenses at the widest point of the lens within the frame. | Float (with single decimal place) |
ED | The longest diagonal distance inside the frame edges in mm | Float (with single decimal place) |
Part Type | The part type classification of the time (Whole, Front, Temple, Bridge, Clip, Side Shield, Miscellaneous) | Text |
Inventory Type | Wether the order is frame or frame part | Text |
Frame Details Columns
Column Name | Description | Data Type |
|---|---|---|
Material | The material the item is made of | Text |
Edge Type → Name | The full name for the edge type | Text |
Edge Type → Code | The short-name for the edge type | Text |
Gender | The gender the item was designed to be worn by | Text |
Requested Base Curve | The requested base curve for the item | Float (with single decimal place) |
Minimum Base Curve | The smallest accepted base curve that will fit in the frame | Float (with single decimal place) |
Prop 65? | Whether the frame is Prop65 or not | Boolean |
Name | The name associated to the item | Text |
Brand | The brand of the item | Text |
Collection | The collection the item belongs to | Text |
Model | The model of the item | Text |
Manufacturer | ||
Class → Name | The name of the class | Text |
Class → Safety | The flag that tracks if the class is Standard or Safety | Boolean |
Manufacturer Column
Column Name | Description | Data Type |
|---|---|---|
Name | The name of the manufacturer | Text |
Reorder Method | The method used to reorder items that this manufacturer supplies. This is applied on the item if SKU → Reorder Method is set to Manufacturer Default | Text |
Receive All? | Determines whether or not the Receive All button can be used when receiving a PO | Boolean |
Account Number | The number account number this lab has with the manufacturer | Text |
Sample Report
Rx-Reports is created to give users maximum flexibility in designing and creating reports that fit their requirements. You can use fields from various targets to customize your reports. Learn more on how to create, design, and run our reports.
Here is a sample of a report that uses the Frame Report as the report target.
CSV
