Reports - Data Sources (Views / Tables)
If your system is licensed for IQanalytics Report Writer, you may design your own reports.
In order to design reports, please refer to Knowledge Base Article
here.
Designing reports requires an understanding of the available data sources and their respective fields. The printIQ database is comprehensive, and areas of the system are written to
many tables in the database. When planning a future report, please use the tables on this page to understand which data sources hold certain information, and which fields may be used to join multiple data sources.
Fields highlighted in yellow are suitable joins
|
AccountManager
|
Data Type |
|
Account Manager ID
|
numeric
|
|
Email
|
string
|
|
Fax
|
string
|
|
Name
|
string |
|
Phone
|
string
|
|
Site
|
string
|
|
Title
|
string
|
|
Address
|
Data Type
|
|
Active
|
boolean
|
|
Address ID
|
numeric
|
| City |
string
|
|
Country
|
string
|
|
Full Address
|
string
|
|
Line 1-3
|
string
|
|
Name
|
string
|
|
Post Code
|
string
|
|
State
|
string
|
|
Customer |
Data Type
|
|
Account Manager ID |
string
|
| Active |
string
|
|
Alt Code
|
string
|
|
Billing Address City
|
string
|
|
Billing Address Country
|
string
|
|
Billing Address Full
|
string
|
|
Billing Address ID |
numeric
|
|
Billing Address Line 1 - 3
|
string
|
|
Billing Address Name
|
string
|
|
Billing Address Post Code
|
string
|
|
Billing Address State
|
string
|
| Code |
string
|
|
Comment
|
string
|
|
Company Number
|
string
|
|
Company Number Type
|
string
|
|
Credit Balance
|
numeric
|
|
Currency
|
string
|
|
Customer ID |
numeric
|
|
Discount Rate
|
numeric
|
| Email |
string
|
|
Fax
|
string |
|
Is Lead
|
string
|
|
Last Job ID
|
numeric
|
|
Last Quote ID
|
numeric
|
| Lead First Conversion Date |
dateTime
|
|
Lead Is Converted
|
string
|
|
Lead Last Conversion Date
|
dateTime
|
|
Mobile
|
string
|
|
Name
|
string
|
| Payment Terms |
string
|
|
Phone
|
string
|
|
Pricing Tier
|
string
|
|
Reference 1 - 20
|
string
|
|
Site Code
|
string
|
|
Site ID |
numeric |
| Site Name |
string
|
|
Type
|
string
|
|
Website
|
string
|
| Customer_Group |
Data Type |
| Customer ID |
numeric |
| Group ID |
numeric |
| Group Name |
string |
| Site ID |
numeric |
|
Customer_JobsAndAcceptedSalesOrders
|
Data Type
|
|
Customer ID
|
numeric
|
|
Job ID
|
numeric
|
|
Sales Order ID
|
numeric
|
|
Customer_Contacts |
Data Type
|
|
Active
|
string
|
|
Comment
|
string
|
|
Contact Type
|
string
|
|
Customer Contact ID |
numeric |
|
Customer ID |
numeric
|
|
Default
|
string
|
|
Email
|
string |
|
Fax
|
string
|
|
First Name
|
string
|
|
Full Name
|
string
|
|
Mobile
|
string
|
|
Phone
|
string
|
|
Surname
|
string
|
| Title |
string
|
|
Website
|
string
|
| Dispatch |
Data Type |
| Address City |
string |
| Address Country |
string |
| Address Full |
string |
| Address Line 1-3 |
string |
| Adddress Name |
string |
| Address Post Code |
string |
| Address State Long |
string |
| Address State Short |
string |
| Consignment |
string |
| Contact Email |
string |
| Contact Fax |
string |
| Contact First Name |
string |
| Contact Full Name |
string |
| Contact Mobile |
string |
| Contact Phone |
string |
| Contact Surname |
string |
| Contact Title |
string |
| Contact Website |
string |
| Courier |
numeric |
| Customer ID |
numeric |
| Date - Dispatched |
dateTime |
| Date - Email Sent |
dateTime |
| Date - Job Due |
dateTime |
| Delivery Num |
numeric |
| Delivery Type |
string |
| Dispatch Status |
string |
| Instructions |
string |
| Job ID |
numeric |
| Job Number |
string |
| Operation Key |
numeric |
| PODispSendDispatchEmail |
string |
| Production Type |
string |
| Quantity |
numeric |
| Reference |
string |
| Sales Order ID |
numeric |
| Sales Order Number |
string |
| Weight |
numeric |
| Weight - Verified |
numeric |
| EstVsActuals |
Data Type |
| Actual Cost |
numeric |
| Actual Hours |
numeric |
| Actual Time |
string |
| Cost Difference |
numeric |
| Cost Difference Absolute |
numeric |
| Department |
string |
| Estimated Cost |
numeric |
| Estimated Hours |
numeric |
| Estimated Time |
string |
| Job ID |
numeric |
| Job No |
string |
| Operation ID |
numeric |
| OperationOrder* |
string |
| Title |
string |
| Type |
string |
[OperationOrder] in this view has been deprecated. Please pull from
Jobs_Operations_Totals
If an Outsourced Operation price has been adjusted at Job stage, please use the VW_Reporting_OutsourcePurchaseOrder view / Price fields to report on any adjustment.
| Inventory_Group |
Data Type |
| Group Name |
string |
| Item ID |
numeric |
|
Inventory_Stock_Visibility
|
Data Type
|
|
Available Quantity
|
numeric |
|
Cost Value
|
numeric
|
|
In Or Ready For Transit Quantity
|
numeric
|
|
In Production Quantity
|
numeric
|
|
In Warehouse Quantity
|
numeric
|
| Item ID |
numeric
|
|
Location Code
|
string
|
|
Location ID
|
numeric
|
|
Location Site Name
|
string
|
|
QuantityUnit
|
string
|
|
Reserved Quantity
|
numeric
|
|
Stock Code
|
string
|
|
Stock Description
|
string
|
|
Stock ID
|
numeric
|
|
Stock Size ID
|
numeric
|
|
Stock x Stock Size ID
|
numeric
|
| InventoryHistory |
Data Type |
| Inventory Tran ID |
numeric |
| Is Picked |
boolean |
| Item Code |
string |
| Item Description |
string |
| Item ID |
numeric |
| Job ID |
numeric |
| Location |
string |
| Notes |
string |
| Order ID |
numeric |
| PO Line ID |
numeric |
| Running Unit Cost |
numeric |
| Running Units |
numeric |
| Transaction Date |
dateTime |
| Transaction Type |
string |
| Unit Cost |
numeric |
| Units |
numeric |
| Units Remaining |
numeric |
| User Name |
string |
| Inventory Items |
Data Type |
| Active |
string |
| Awaiting Delivery |
string |
| Code |
string |
| Date Created |
dateTime |
| Date Last Ordered |
dateTime |
| Description |
string |
| Global QOH |
numeric |
| Global Value |
numeric |
| Item ID |
numeric |
| Item Requires Reorder |
boolean |
| Item Type |
string |
| Location |
string |
| Location QOH |
numeric |
| Location Re-order Level |
numeric |
| Location Value |
numeric |
| Managed |
boolean |
| Outsourced |
boolean |
| Outstanding PO Value |
numeric |
| Owned By |
string |
| Owned By Customer ID |
numeric |
| Owned By Customer Name |
string |
| Quantity on Hand |
numeric |
| Ref Key |
numeric |
| Reorder Level |
numeric |
| Sales Item |
boolean |
| Sales Item Description |
string |
| Sales Item Name |
string |
| Sales Item Type |
string |
| Single Unit Weight |
numeric |
| Stock ID |
numeric |
| InventoryItems_CustomerAccess |
Data Type |
| Customer Active |
boolean |
| Customer Code |
string |
| Customer ID |
numeric |
| Customer Name |
string |
| Customer Type |
string |
| Description |
string |
| Item Active |
boolean |
| Item Code |
string |
| Item ID |
numeric |
| InventoryPurchaseOrder |
Data Type |
| Consignment No |
string |
| Customer Contact ID |
numeric |
| Customer ID |
numeric |
| Date Actual Delivery |
dateTime |
| Date Cancelled |
dateTime |
| Date Completed |
dateTime |
| Date ETA Delivery |
dateTime |
| Date Exported |
dateTime |
| Date Last Modified |
dateTime |
| Date Ordered |
dateTime |
| Delivery Address |
string |
| Delivery Address City |
string |
| Delivery Address Full |
string |
| Delivery Address Line 1 - 3 |
string |
| Delivery Address Name |
string |
| Delivery Address Post Code |
string |
| Delivery Address State |
string |
| Exported Inventory PO No |
string |
| Inventory PO - Child PO No |
numeric |
| Inventory PO - Parent PO ID |
numeric |
| Inventory PO - Parent Version ID |
numeric |
| Inventory PO ID |
numeric |
| Inventory PO No |
string |
| Is Draft |
boolean |
| Job ID |
numeric |
| Notes |
string |
| Order Status |
string |
| Price - Tax |
numeric |
| Price - Total Price |
numeric |
| Status ID |
numeric |
| InventoryPurchaseOrderLine |
Data Type |
| Inventory PO ID |
numeric |
| Inventory PO Line ID |
numeric |
| Item Code |
string |
| Item Description |
string |
| Item ID |
numeric |
| Line No |
numeric |
| Location |
string |
| Notes |
string |
| Price - Line Total |
numeric |
| Price - Tax |
numeric |
| Price - Unit Price |
numeric |
| Quantity Actual |
numeric |
| Quantity Ordered |
numeric |
| Supplier Code |
string |
| Supplier ID |
numeric |
| Supplier Name |
string |
| Units |
string |
| InvoiceLines |
Data Type |
| Account Manager ID |
string |
| Batch |
string |
| Customer ID |
numeric |
| Date Created |
dateTime |
| Date Due |
dateTime |
| Date Exported |
dateTime |
| Description |
string |
| IGLA Code |
string |
| Invoice ID |
numeric |
| Invoice Number |
string |
| Is Credit Note |
boolean |
| Item Code |
string |
| Job ID |
numeric |
| Kinds |
numeric |
| Operation ID |
numeric |
| Price - Adjustment |
numeric |
| Price - ex Tax |
numeric |
| Price - Incl Tax |
numeric |
| Price - Tax |
numeric |
| Quantity |
numeric |
| Sales Order Item ID |
numeric |
| Status |
string |
| Tax Code |
string |
| Tax Rate |
numeric |
| Title |
string |
| Invoices |
Data Type |
| Account Manager ID |
string |
| Address ID |
numeric |
| Amount Paid |
numeric |
| Batch |
string |
| Customer ID |
numeric |
| Date Created |
dateTime |
| Date Due |
dateTime |
| Date Exported |
dateTime |
| Invoice ID |
numeric |
| Invoice Number |
string |
| Is Credit Note |
boolean |
| Is Exported |
boolean |
| Is Internally Invoiced |
boolean |
| Price - Adjustments |
numeric |
| Price - ex Tax |
numeric |
| Price - Tax |
numeric |
| Price - Total |
numeric |
| Reference |
string |
| Status |
string |
| Jobs |
Data Type |
| Accepted By User Email |
string |
| Accepted By User First Name |
string |
| Accepted By User ID |
string |
| Accepted By User Name |
string |
| Accepted By User Surname |
string |
| Account Manager ID |
string |
| Customer ID |
numeric |
| Customer Status |
string |
| Date Accepted |
dateTime |
| Date Customer Required |
dateTime |
| Date Due |
dateTime |
| Date Quote Created |
dateTime |
| Factory Location |
string |
| Invoice Number - Latest |
string |
| Invoiced |
string |
| Is Draft |
string |
| Job ID |
numeric |
| Job No |
string |
| Job Series Code |
string |
| Job Title |
string |
| Job Type |
string |
| Kinds |
numeric |
| PO Number |
string |
| Price - Cost Plus Price |
numeric |
| Price - Cost Price |
numeric |
| Price - Extras Price |
numeric |
| Price - Freight Price |
numeric |
| Price - Quoted |
numeric |
| Price - Retail Price |
numeric |
| Price - Total Price |
numeric |
| Price - Total Sale Price |
numeric |
| Price - Total Sale Price Incl Tax |
numeric |
| Price - Total Sale Price Tax |
numeric |
| Price - Wholesale Price |
numeric |
| Priority |
string |
| Production Status |
string |
| Quantity |
numeric |
| Quote No |
string |
| Quote Product ID |
numeric |
| Quote Quantity ID |
numeric |
| Reference 1 - 20 |
string |
| Site ID |
numeric |
| Site Name |
string |
| Stock Codes |
string |
| Template |
string |
| Jobs_Operations |
Data Type |
| Complete |
numeric |
| Cost GLA Tax Code |
string |
| Cost IGLACode |
string |
| Cost IGLADescription |
string |
| Cost IGLAName |
string |
| Cost Plus Price |
numeric |
| Cost Price |
numeric |
| Date Accepted |
dateTime |
| Date Due |
dateTime |
| Date Finished Production |
dateTime |
| Department Name |
string |
| EtimatedMakeReadyHours |
numeric |
| EstimatedRunHours |
numeric |
| First Invoiced Date |
dateTime |
| Invoiced |
boolean |
| Job ID |
numeric |
| Job Number |
string |
| Job Type |
string |
| MakeReady Cost |
numeric |
| Materials Cost |
numeric |
| Min Charge |
numeric |
| Operation ID |
numeric |
| Operation Name |
string |
| Picked Stock Size Depth |
string |
| Picked Stock Size ID |
numeric |
| Picked Stock Size Name |
string |
| Picked Stock Size Width |
string |
| Press Name |
string |
| Printed Stock Size Depth |
string |
| Printed Stock Size ID |
numeric |
| Printed Stock Size Name |
string |
| Printed Stock Size Width |
string |
| Production Status |
string |
| Reporting Code Short |
string |
| ReportingCode |
string |
| RunCost |
numeric |
| Sale GLA Tax Code |
string |
| Sale IGLACode |
string |
| Sale IGLADescription |
string |
| Sale IGLAName |
string |
| Stock Code |
string |
| Stock Description |
string |
| Stock ID |
numeric |
| Stock Size Unit |
string |
| Total Logged Hours |
numeric |
| Unit Price |
numeric |
| Jobs_Operations_Totals |
Data Type |
| Actual Cost |
numeric |
|
Department
|
string
|
| Guillotine ID |
numeric |
| Guillotine Name |
string |
| Invoiced Cost |
numeric |
| Job ID |
numeric |
| Machine ID |
numeric |
| Machine Name |
string |
| Machine Type |
string |
| Operation* |
string |
| Operation ID |
numeric |
| Press ID |
numeric |
| Press Name |
string |
| Press Type |
string |
| Quoted Cost |
numeric |
| Stock Code |
string |
| Stock Description |
string |
| Stock ID |
numeric |
| Stock Size Key |
numeric |
| Stock Size Name |
string |
[Operation] is the Operation
Description
| Jobs_Totals |
Data Type |
| Average Seconds per Operation |
numeric |
| Job Has Time Entries |
numeric |
| Job ID |
numeric |
| Job Number |
string |
| Number of Operations |
numeric |
| Price - Cost Plus Price |
numeric |
| Price - Cost Price |
numeric |
| Price - Materials Price |
numeric |
| Jobs_Totals_Invoice |
Data Type |
| Date - Last Invoice |
dateTime |
| Job ID |
numeric |
| Job No |
string |
| No. of Charges |
numeric |
| No. of Invoices |
numeric |
| Price - Tax |
numeric |
| Price - Total ex Tax |
numeric |
| Price - Total incl Tax |
numeric |
| Total Price Adjustment |
numeric |
| Jobs_Totals_PurchaseOrder |
Data Type |
| Inventory - Date Last PO |
dateTime |
| Inventory - No. of PO's |
numeric |
| Inventory - No. of Suppliers |
numeric |
| Inventory - Price - ex Tax |
numeric |
| Inventory - Price - incl Tax |
numeric |
| Inventory - Price - Tax |
numeric |
| Job ID |
numeric |
| Job No |
string |
| Outsource - Price - ex Tax |
numeric |
| Outsource - Date Last PO |
dateTime |
| Outsource - No. of PO's |
numeric |
| Outsource - No. of Suppliers |
numeric |
| Outsource - Price - incl Tax |
numeric |
| Outsource - Price - Tax |
numeric |
| Jobs_Totals_SupplierInvoice_PurchaseOrder |
Data Type |
| Inventory - Date Last PO |
dateTime |
| Inventory - No. of PO's |
numeric |
| Inventory - No. of Suppliers |
numeric |
| Inventory - Price - ex Tax |
numeric |
| Inventory - Price - incl Tax |
numeric |
| Inventory - Price - Tax |
numeric |
| Job ID |
numeric |
| Job No |
string |
| Outsource - Price - ex Tax |
numeric |
| Outsource - Date Last PO |
dateTime |
| Outsource - No. of PO's |
numeric |
| Outsource - No. of Suppliers |
numeric |
| Outsource - Price - incl Tax |
numeric |
| Outsource - Price - Tax |
numeric |
| JobSection_GetStockCertification |
Data Type |
| Customer Name |
string |
| Fixed Stock Sheet Weight |
string |
| Job Certification Percent |
numeric |
| Job Certification Type |
string |
| Job Due Date |
dateTime |
| Job First Invoice Date |
dateTime |
| Job Kinds |
numeric |
| Job No |
string |
| Job Quantity |
numeric |
| Job Title |
string |
| Section Finished Depth |
string |
| Section Finished Depth Unit |
string |
| Section Finished Width |
string |
| Section Finished Width Unit |
string |
| Section ID |
numeric |
| Section Name |
string |
| Section Weight |
string |
| Section Weight Unit |
string |
| Stock Certification Percent |
numeric |
| Stock Certification Type |
string |
| Stock Code |
string |
| Stock Depth |
string |
| Stock Depth Unit |
string |
| Stock Description |
string |
| Stock Sheets Actual Cost |
numeric |
| Stock Sheets Actual Quantity |
numeric |
| Stock Sheets Purchase Order Total |
numeric |
| Stock Sheets Quoted Cost |
numeric |
| Stock Sheets Quoted Quantity |
numeric |
| Stock Sheets Quoted Quantity Unit |
numeric |
| Stock Sheets Weight Unit |
string |
| Stock Weight |
string |
| Stock Weight Unit |
string |
| Stock Width |
string |
| Stock Width Unit |
string |
| OutsourcePurchaseOrder |
Data Type |
| Completed Date |
dateTime |
| Date Deliver from Supplier |
dateTime |
| Date Deliver to Supplier |
dateTime |
| Date Sent |
dateTime |
| Delayed Note |
string |
| Deliver to Me |
string |
| Delivery Address City |
string |
| Delivery Address Country |
string |
| Delivery Address Full |
string |
| Delivery Address Line 1 - 3 |
string |
| Delivery Address Name |
string |
| Delivery Address Post Code |
string |
| Delivery Address State |
string |
| Delivery Contact ID |
numeric |
| Description |
string |
| Dispatched Connote |
string |
| Dispatched Courier |
string |
| Dispatched Date |
dateTime |
| Job ID |
numeric |
| Kinds |
numeric |
| Original Currency |
string |
| Original Price |
numeric |
| Original Price Incl Tax |
numeric |
| Outsource PO ID |
numeric |
| Outsource PO No |
string |
| Outsource Request Status |
string |
| Price |
numeric |
| Price - Price Incl Tax |
numeric |
| Price - Tax |
numeric |
| Quantity |
numeric |
| Reference |
string |
| Special Instructions |
string |
| Status |
string |
| Status ID |
numeric |
| Supplier ID |
numeric |
| Payments |
Data Type |
| Cart Amount |
numeric |
| Cart Status |
string |
| Cart Type |
string |
| Customer ID |
numeric |
| Invoice Customer |
string |
| Invoice ID |
numeric |
| Invoice Number |
string |
| Payment Amount |
numeric |
| Payment Key |
numeric |
| Payment Reference |
string |
| Payment Status |
string |
| Payment Time Submitted |
dateTime |
| Payment Type |
string |
| Quote ID |
numeric |
| Quote Number |
string |
| Sales Order ID |
numeric |
| Sales Order Number |
string |
| Transaction Amount |
numeric |
| Transaction Status |
string |
| Transaction Time Submitted |
dateTime |
| User ID |
string |
| ProductCategories |
Data Type |
| Active |
boolean |
| Product Category ID |
numeric |
| Product Category Name |
string |
| Product Category Type |
string |
| ProductionTimeEntry |
Data Type |
| Average Entry Time in Minutes |
numeric |
| Average Entry Time in Seconds |
numeric |
| Department |
string |
| End Time |
dateTime |
| Job ID |
numeric |
| Job No |
string |
| Notes |
string |
| Operation |
string |
| Operation ID |
numeric |
| Operation Total Entries |
numeric |
| Operation Total Time |
numeric |
| Section Description |
string |
| Start Time |
dateTime |
| Time in Minutes |
numeric |
| Time in Seconds |
numeric |
| User Full Name |
string |
| User ID |
string |
| User Name |
string |
| QuoteProducts |
Data Type |
| Description |
string |
| Job Title |
string |
| Job Type |
string |
| Kinds |
numeric |
| Price - Extras Price |
numeric |
| Price - Freight Price |
numeric |
| Price - Retail Price |
numeric |
| Price - Total Sale Price |
numeric |
| Price - Total Sale Price Incl Tax |
numeric |
| Price - Total Sale Price Tax |
numeric |
| Product Status |
string |
| Quantity |
numeric |
| Quote ID |
numeric |
| Quote No |
string |
| Quote Product ID |
numeric |
| Quote Quantity ID |
numeric |
| Reference 1 - 20 |
string |
| Template |
string |
| QuoteProducts_Totals |
Data Type |
| Job Type |
string |
| Max Kinds |
numeric |
| Max Quantity |
numeric |
| Min Kinds |
numeric |
| Min Quantity |
numeric |
| No. of Quantities |
numeric |
| Price - Cost Plus Price |
numeric |
| Price - Extras Price |
numeric |
| Price - Extras Price - Max |
numeric |
| Price - Extras Price - Min |
numeric |
| Price - Freight Price |
numeric |
| Price - Freight Price - Max |
numeric |
| Price - Freight Price - Min |
numeric |
| Price - Materials Price |
numeric |
| Price - Retail Price |
numeric |
| Price - Retail Price - Max |
numeric |
| Price - Retail Price - Min |
numeric |
| Price - Total Sale Price |
numeric |
| Price - Total Sale Price - Max |
numeric |
| Price - Total Sale Price - Min |
numeric |
| Price - Wholesale Price |
numeric |
| Price - Wholesale Price - Max |
numeric |
| Price - Wholesale Price - Min |
numeric |
| Product Category ID |
numeric |
| Quote ID |
numeric |
| Quote No |
string |
| Quote Product ID |
numeric |
| Template |
string |
| Tree Node ID |
numeric |
| QuoteQuestions_Job |
Data Type |
| Answer |
string |
| Job ID |
numeric |
| Line Item |
string |
| Question |
string |
| Question Answer ID |
numeric |
| Section Name |
string |
| Source |
string |
| QuoteQuestions_Quote |
Data Type |
| Answer |
string |
| Line Item |
string |
| Question |
string |
| Question Answer ID |
numeric |
| Quote Quantity ID |
numeric |
| Section Name |
string |
| Source |
string |
| Quotes |
Data Type |
| Account Manager ID |
string |
| Archived |
string |
| Billing Address City |
string |
| Billing Address Country |
string |
| Billing Address Full |
string |
| Billing Address ID |
numeric |
| Billing Address Line 1 - 3 |
string |
| Billing Address Name |
string |
| Billing Address Post Code |
string |
| Billing Address State |
string |
| Contact Name |
string |
| Currency |
string |
| Customer Contact ID |
numeric |
| Customer ID |
numeric |
| Customer Reference |
string |
| Date Created |
dateTime |
| Date Valid Until |
dateTime |
| Expired |
boolean |
| IsGangQuote |
boolean |
| IsUserVisible |
boolean |
| Job Series Code |
string |
| Job Title |
string |
| Quote ID |
numeric |
| Quote No |
string |
| Quote Status |
string |
| User ID |
string |
| Quotes_Totals |
Data Type |
| Max Kinds |
numeric |
| Max Quantity |
numeric |
| Min Kinds |
numeric |
| Min Quantity |
numeric |
| No. of Products |
numeric |
| No. of Quantities |
numeric |
| Price - Cost Plus Price |
numeric |
| Price - Extras Price |
numeric |
| Price - Extras Price - Max |
numeric |
| Price - Extras Price - Min |
numeric |
| Price - Freight Price |
numeric |
| Price - Freight Price - Max |
numeric |
| Price - Freight Price - Min |
numeric |
| Price - Materials Price |
numeric |
| Price - Retail Price |
numeric |
| Price - Retail Price - Max |
numeric |
| Price - Retail Price - Min |
numeric |
| Price - Total Sale Price |
numeric |
| Price - Total Sale Price - Max |
numeric |
| Price - Total Sale Price - Max (SUM) |
numeric |
| Price - Total Sale Price - Min |
numeric |
| Price - Total Sale Price - Min (SUM) |
numeric |
| Price - Wholesale Price |
numeric |
| Price - Wholesale Price - Max |
numeric |
| Price - Wholesale Price - Min |
numeric |
| Products |
string |
| Quote ID |
numeric |
| Quote No |
string |
| ReworkJobs |
Data Type |
| Accepted By User Email |
string |
| Accepted By User First Name |
string |
| Accepted By User ID |
string |
| Accepted By User Name |
string |
| Accepted By User Surname |
string |
| Account Manager ID |
string |
| Customer ID |
numeric |
| Customer Status |
string |
| Date Accepted |
dateTime |
| Date Customer Required |
dateTime |
| Date Due |
dateTime |
| Date Quote Created |
dateTime |
| Date Reworked |
dateTime |
| Factory Location |
string |
| Invoice Number - Latest |
string |
| Invoiced |
string |
| Is Draft |
boolean |
| Job ID |
numeric |
| Job No |
string |
| Job Series Code |
string |
| Job Title |
string |
| Job Type |
string |
| Kinds |
numeric |
| PO Number |
string |
| Price - Cost Plus Price |
numeric |
| Price - Cost Price |
numeric |
| Price - Materials Price |
numeric |
| Priority |
string |
| Production Status |
string |
| Quantity |
numeric |
| Quote No |
string |
| Quote Product ID |
numeric |
| Quote Quantity ID |
numeric |
| Reference 1 - 20 |
string |
| Rework Reason |
string |
| Reworked From Job ID |
numeric |
| Site ID |
numeric |
| Site Name |
string |
| Stock Codes |
string |
| Template |
string |
| SalesOrder |
Data Type |
| Customer ID |
numeric |
| Date Customer Receipt Email |
dateTime |
| Date Order |
dateTime |
| Order Reference |
string |
| Parent Sales Order Key |
numeric |
| Price - Freight Total Price |
numeric |
| Price - Pick n Pack Tax |
numeric |
| Price - Pick n Pack Total |
numeric |
| Price - Subtotal Price |
numeric |
| Price - Tax Price |
numeric |
| Price - Total Price |
numeric |
| Purchase Order Reference |
string |
| Sales Order ID |
numeric |
| Sales Order Notes |
string |
| Sales Order Number |
string |
| Sales Order Paid |
boolean |
| Sales Order Status |
string |
| User ID |
string |
| SalesOrder_Item |
Data Type |
| Item Key |
numeric |
| Price - Sales Item Price |
numeric |
| Price - Sales Item Tax Price |
numeric |
| Sales Item Description |
string |
| Sales Item Name |
string |
| Sales Item Quantity |
numeric |
| Sales Order ID |
numeric |
| Sales Order Item ID |
numeric |
*Join the Item Key to the Item ID field of InventoryItems view
| Stock |
Data Type |
| Active |
boolean |
| Description |
string |
| Is Ad-Hoc |
boolean |
| Is Coated |
boolean |
| Is FSC Certified |
boolean |
| Is House |
boolean |
| Stock Code |
string |
| Stock Family Name |
string |
| Stock ID |
numeric |
| Stock Weight |
numeric |
| Thickness |
numeric |
| SupplierInvoice |
Data Type |
| Batch Number |
numeric |
| Date Created |
dateTime |
| Date Invoice Due |
dateTime |
| Date Invoiced |
dateTime |
| Description |
string |
| Interface Date |
dateTime |
| Invoice Notes |
string |
| Invoice Number |
string |
| Invoice Status |
string |
| Invoice Type |
string |
| Price - Invoice Total |
numeric |
| Price - PO Total |
numeric |
| Supplier ID |
numeric |
| Supplier Invoice ID |
numeric |
| Tax Rate |
numeric |
| Tax Type |
string |
| SupplierInvoice_InventoryPurchaseOrder |
Data Type |
| Consignment No |
string |
| Customer Contact ID |
numeric |
| Customer ID |
numeric |
| Date Actual Delivery |
dateTime |
| Date Cancelled |
dateTime |
| Date Completed |
dateTime |
| Date ETA Delivery |
dateTime |
| Date Exported |
dateTime |
| Date Last Modified |
dateTime |
| Date Ordered |
dateTime |
| Delivery Address City |
string |
| Delivery Address Country |
string |
| Delivery Address Full |
string |
| Delivery Address Line 1 - 3 |
string |
| Delivery Address Name |
string |
| Delivery Address Post Code |
string |
| Delivery Address State |
string |
| Exported Inventory PO No |
string |
| Inventory PO - Child PO No |
numeric |
| Inventory PO - Parent PO ID |
numeric |
| Inventory PO - Parent Version ID |
numeric |
| Inventory PO ID |
numeric |
| Inventory PO No |
string |
| Is Draft |
boolean |
| Job ID |
numeric |
| Notes |
string |
| Order Status |
string |
| Price - Tax |
numeric |
| Price - Total Price |
numeric |
| Status ID |
numeric |
| Supplier Invoice ID |
numeric |
| Supplier Invoice Line Account Code |
string |
| Supplier Invoice Line Amount |
numeric |
| Supplier Invoice Line Description |
string |
| SupplierInvoice_OutsourcePurchaseOrder |
Data Type |
| Completed Date |
dateTime |
| Date Deliver from Supplier |
dateTime |
| Date Deliver to Supplier |
dateTime |
| Date Sent |
dateTime |
| Delayed Note |
string |
| Deliver to Me |
string |
| Delivery Address City |
string |
| Delivery Address Country |
string |
| Delivery Address Full |
string |
| Delivery Address Line 1 - 3 |
string |
| Delivery Address Name |
string |
| Delivery Address Post Code |
string |
| Delivery Address State |
string |
| Delivery Contact ID |
numeric |
| Description |
string |
| Dispatched Connote |
string |
| Dispatched Courier |
string |
| Dispatched Date |
dateTime |
| Job ID |
numeric |
| Kinds |
numeric |
| Original Currency |
string |
| Original Price |
numeric |
| Original Price Incl Tax |
numeric |
| Outsource PO ID |
numeric |
| Outsource PO No |
string |
| Outsource Request Status |
string |
| Price |
numeric |
| Price - Price Incl Tax |
numeric |
| Price - Tax |
numeric |
| Quantity |
numeric |
| Reference |
string |
| Special Instructions |
string |
| Status |
string |
| Status ID |
numeric |
| Supplier ID |
numeric |
| Supplier Invoice ID |
numeric |
| Supplier Invoice Line Account Code |
string |
| Supplier Invoice Line Amount |
numeric |
| Supplier Invoice Line Description |
string |
| SupplierInvoiceLines |
Data Type |
| Batch |
string |
| Date Created |
dateTime |
| Date Due |
dateTime |
| Date Exported |
dateTime |
| Description |
string |
| Foreign Currency Code |
string |
| Foreign Exchange Rate |
numeric |
| Foreign Price - ex Tax |
numeric |
| Foreign Price - Incl Tax |
numeric |
| Foreign Price - Tax |
numeric |
| IGLA Code |
string |
| Invoice Line Ref Number |
string |
| Invoice Number |
string |
| Is Credit Note |
string |
| Item Code |
string |
| Job ID |
numeric |
| Kinds |
numeric |
| Line Order |
numeric |
| Operation ID |
numeric |
| Price - Adjustment |
numeric |
| Price - ex Tax |
numeric |
| Price - Incl Tax |
numeric |
| Price - Tax |
numeric |
| Quantity |
numeric |
| Reference |
string |
| Sales Order Item ID |
numeric |
| Status |
string |
| Supplier ID |
numeric |
| Supplier Invoice ID |
numeric |
| Tax Code |
string |
| Tax Rate |
numeric |
| Title |
string |
| Tracking Code |
string |
| Tasks |
Data Type |
| Assigned To |
string |
| Author |
string |
| Body |
string |
| Complete |
dateTime |
| Context ID |
string |
| Context Name |
string |
| Context Type |
string |
| Context URL |
string |
| Cost |
numeric |
| Customer ID |
numeric |
| Due Date |
dateTime |
| Identifying Dept |
string |
| Is Shell |
string |
| Job ID |
numeric |
| OutsourceRequest ID |
numeric |
| Quote ID |
numeric |
| Remedy |
string |
| Source Dept |
string |
| Subject |
string |
| Task ID |
numeric |
| Time Stamp |
dateTime |
| User ID |
string |
| Users |
Data Type |
| Account Manager ID |
string |
| Customer ID |
numeric |
| Date Last Login |
dateTime |
| Email |
string |
| Enabled |
boolean |
| First Name |
string |
| IsAccountManager |
boolean |
| LastActivityDate |
dateTime |
| Locked |
boolean |
| Roles |
string |
| Surname |
string |
| User ID |
string |
| User Name |
string |
Related Articles
Reports - Designing a Report
If your system is licensed for IQanalytics Report Writer, you may design your own reports. For a more comprehensive guide on how to design Izenda report, please scroll down to the end of the article to download the attachment. *All credit to the ...Syllabus IQanalytics Report Writing (Izenda)
Download the attached PDF file for full list of fieldsReports - Designing a Dashboard
Dashboards Once a number of reports and charts have been created, you can place different charts onto a single Dashboard for high level views of printIQ’s database. These dashboards have their unique sharing permissions and may be set as default for ...IQ Standard Reports
A brief walkthrough and explanation of standard reports included with IQ... Customer \ Customer Activity in Selected Period This report provides a list of ALL of your active customers showing Job activity in the selected date range. The sorting logic ...REPORTS - List All Quotes Showing User That Created Quote
If your system is licensed for IQanalytics Report Writer, you may design your own reports. This is a supplementary article specifically related to creating a report listing all quotes showing the user that created the quote. For more detail ...