Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Current »

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

See columns list for 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

See columns list for 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

Back to top

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

See columns list for 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

Back to top

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.

PDF

CSV

  • No labels