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 fields

• Reports - 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

  Intended Audience This Knowledgebase Article is intended for all staff that have access to running Izenda Reports. Izenda Reports are usually used\designed to provide information based on a line report style output. An Izenda report may or may not ...

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