Report Field Definitions

EPRO Analytics Report Designer provides a Data Binding feature that drives how data is connected to the report. With the Data Binding feature, you are able to place data components on the report canvas where you want them to appear in the report output. The optios you select from are called Fields. There are many Fields to choose from across all reports.

The following table is a a partial list of fields used across all EPRO Analytics reports. Please note that this is not an exhaustive list. If you are searching for a field not found in this, please Contact Support to receive assistance from one of our Support Representatives.

Designer Field Name	Friendly Field Name	Field Description
TLNUMBER	Theater Location Number	Buyer's internal number for a location.
TLNAME	Theater Location Name	Buyer's formal name for a location.
BuyerPONbr	Buyer Purchase Order Number	Buyer's Purchase Order Number assigned in the system
VENDORPONUMBER	Vendor Purchase Order Number	Vendor's Purchase Order Number assigned in the system
ORDERDATE	Date of an order	The date an order was placed.
ORDERTOTAL	Order Total (Monetary)	The Monetary total of an order
PO_ORIGIN	Where the PO Originated from. (Ex. Punchout)	Where the Purchase Order Originated from. (Ex. Punchout)
*cf_external_order_field	Is System Generated (Y/N)	Is order field system generated? Possible values are Y (Yes) and N (No).
cf_Status	"Order Status (Received Shipped Submitted)"	"The Order's Status. Can be in Received Shipped or Submitted"
APPROVEDDATE	Approved Date	The date an order was approved
SHIPDATE	Shipped Date	The date an order was shipped
RECEIVEDDATE	Received Date	The date an order was received
VENDORSHORTNAME	Vendor's Short Name	A Vendor's system abbrivated name
TPODHINVOICEDATE	Invoice Date	Listed date of an invoice
TIGDATEADDED	Invoice Posted Date	Posted date of an invoice
TPODHINVOICENUMBER	Invoice Number	The invoice's assigned idenfication number
TIGDINVOICEAMOUNT	Invoice Total (Monetary)	The total monetary amount in an invoice
PONUMBERPENDAGE	Purchase Number Pendage	Pending Status
VLNAME	Vendor Location Name	Vendor's formal name for a locaiton
cf_OrderTotal	Order Amount (Monetary)	Monetary Order Total
INVOICEDATE	Invoice Date	Listed date of an invoice
INVOICENUMBER	Invoice Number	The invoice's assigned idenfication number
DATEADDED	Posted Date	Posted date of an invoice
PAYMENTREFERENCENUMBER	Payment Reference Number	Listed Payment Reference Number
VENDORCORPORATEADDRESS	Vendor Corporate Address	Vendor's Corporate Address assigned in the system.
BeginDate	Begin Date (Selected by parameters)	The earliest date a user assigned in the parameters
EndDate	End Date (Selected by parameters)	The end date a user assigned in the parameters
HeaderGroupBy	Group By (Selected by parameters)	Group Header Settings
DisplayFilterSetting	Filter Settings	Diplay Filter Settings
VENDORITEMNUMBER	Supplier item #	Vendor's item number assigned in the system
PROD_NAME	Name of Product	An items assigned name in the system
QUANTITYORDERED	Quantity of items ordered	The amount of items ordered
OGNUMBER	Order Guide Number	A descriptor assigned to an Order Guide by the Buyer.
OGNAME	Order Guide Name	A descriptive name a Buyer gives to an Order Guide.
DELIVERYDAYOFTHEWEEK	Delivery Day	The date an order was physically delivered.
SALEPRICE	Unit Sale Price	An items assigned Sale price
BEGINONHAND	Quantity on hand	The amount of an item a location has on hand
NSTOCK	Stock Quantity	Stock Quantity
NSALES	Sales	Number of Sales
NWASTE	Net Waste	Net Waste
NTRANSFEROUT	Net Transfers	Net Transfers
VARIANCESALEVALUE	Sale value of variance	Sale value of variance
Basis	Involved Quantity	Involved Quantity
DISTINCTSHIPPEDDSTRPRICEPERUNIT	Unit price invoiced	Unit Price listed in invoice
WABDISTRIBUTORPRICEPERUNIT	Unit PO/Contract Price at time of purchase	Price at time of purchase
SORTOPTION	Sort product by	Sort Product
GROUPOPTION	Group product by	Group Product
ALLOWANCEYN	Impose Allowances	Is there Allowance. Possible values are Y (Yes) and N (No).
OGCOMMENTSMEMO	Comments	Order Guide Comments
MODELNUMBERYN	Show Model #	Used to determine if the Model Number should show on an Order Guide. Possible values are Y (Yes) and N (No).
VENDORNUMBERYN	Show Vendor #	Used to determine if the Vendor's Number (or SKU) for an item should show on an Order Guide. Possible values are Y (Yes) and N (No).
DSTRNUMBERYN	Show Distributor #	Used to determine if the Distributor's Number (or SKU) for an item should show on an Order Guide. Possible values are Y (Yes) and N (No).
THEATERNUMBERYN	Show Buyer #	Used to determine if the Buyer's Number for an item should show on an Order Guide. Possible values are Y (Yes) and N (No).
City	City of Location	City of a location
State	State of Location	State (geological) of a location
RP_REEPORTAPPROVEDITEMLIST.NAME	Item Name	Name of an item listed in system
RP_REEPORTAPPROVEDITEMLIST.SUPPLIERNAME	Supplier's Name	Supplier's name listed in system
RP_REEPORTAPPROVEDITEMLIST.SUPPLIERITEMNUMBER	Supplier Item Number	Supplier's item number listed in system
RP_REEPORTAPPROVEDITEMLIST.SUPPLIERUOM	Supplier Unit of Measure	Supplier's Unit of Measure for an item
RP_REEPORTAPPROVEDITEMLIST.SUPPLIERQPU	Supplier Quanity Per Unit	Supplier's Qunanity Per Unit for an item
RP_REEPORTAPPROVEDITEMLIST.APPROVALSTATUS	Approval Status	The Approval Status of an item
RP_REEPORTAPPROVEDITEMLIST.THEATERITEMNUMBER	Buyer Item Number	Buyer's item number in system
RP_REEPORTAPPROVEDITEMLIST.TAXABLEYN	Tax Y/N	Is there tax? Possible values are Y (Yes) and N (No).
RP_REEPORTAPPROVEDITEMLIST.ALLOWANCENAME	Allowance	The Allowance name in the system
RP_REEPORTAPPROVEDITEMLIST.INVENTORYYN	Inventory Y/N	In Inventory? Possible values are Y (Yes) and N (No).
RP_REEPORTAPPROVEDITEMLIST.ORDERGUIDEYN	Order Guide Y/N	In Order Guide? Possible values are Y (Yes) and N (No).
USERNAME	Username in System	A user's assigned username in the system.
FIRSTNAME	User's Firstname in System	A user's assigned firstname in the system.
LASTNAME	User's Lastname in System	A user's assigned lastname in the system.
TITLE	User's Title in System	A user's assigned title in the system
EMAIL	User's Email in System	A user's assigned email in the system.
ACCESSTYPE	User's Access Type in System	A user's assigned access type in the system.
LASTLOGIN	User's Last Login to Account	A user's assigned last login to the account.
DATEADDED	Date User was added	The date a user was added to the system
LASTUPDATEDATE	Date of Changes made to User's account	The date changes were made to a user account
WHOADDEDFIRSTNAME	System User who added new User's first name to System	System User who added new User's first name to System
WHOADDEDLASTNAME	System User who added new User's last name to System	System User who added new User's last name to System
LOCATIONNAMES	Location Names tied to User	Location Names tied to User
LOCATIONNUMBERS	Location Numbers tied to User	Location Numbers tied to User
LOCATIONCITIES	Location's Cities tied to User	Location's Cities tied to User
LOCATIONSTATES	Location's States tied to User	Location's States tied to User
REGIONNAMES	User's Region Names of Locations tied to User	User's Region Names of Locations tied to User
ORDERFORLOCS	Locations Ordered For	Locations a user ordered for
RECEIVEDFORLOCS	User's Locations Received For	Locations a user received for
ORDERCOUNT30DAY	User's 30 Day Order Count	Count of a user's order count in the past 30 days
RECEIVEDCOUNT30DAY	User's 30 Day Received Count	Count of a user's received count in the past 30 days
ACTIVE30DAY	User Active in past 30 days Y/N	Was a user active in the past 30 days ? Possible values are Y (Yes) and N (No).