Standard Canadian AQ - Processed Transaction Summary CA AQ

Overview

Updated 12/10/2021

• Click here for information on Canada AQs
• Click here for information on Canada Reports
• Click here for information on Standard Reports
• Click here for information on Advanced Queries

Report Description
Parameters
Report Fields

Report Description

This AQ is a replacement for Processed Transaction Summary AQ created for Canadian clients. The only difference between US and Canadian version are the Tax details.  Processed Transaction Summary CA shows Canadian clients.

Gives detailed information of all processed transactions. (This report shows a comprehensive view of all processed transactions during a specific time period.)

Back to Top

Parameters

Parameter Name	Options	Explanation
Branch (Transaction)	All available branches.	Transaction’s Branch.
SSN		Filters results by Social Security Number.
Date Type	Accounting Period Date, Week Worked, Check Date, Invoice Date	Transaction’s Accounting Period or Week Worked or Check Date or Invoice Date
Start Date
End Date
Customer Name		Filters results by Customer name.
Employee ID	Input Field	Filters results by Employee ID.

Back to Top

Report Fields

Field Name	Explanation
StaffingSupplierDesc	Supplier Name from Transaction.
TransactionBranch	Transaction’s Branch
AccountingPeriodDate	Transaction’s Accounting Period Date
WeekWorked	Transaction’s Week Worked Date
TimeEntryBatchID	Batch ID from Transaction.
TransactionID	Transaction ID from Transaction.
CustomerID	Customer ID of the customer associated with Transaction.
BillToName	Customer name associated with Transaction.
DepartmentName	Department Name associated with Transaction.
EmployeeID	Employee ID from transaction
BoldTalentID	Employee ID from AviontéBOLD (Front Office)
SIN	SIN of the employee.
EmployeeName	Name of the employee.
IsT4	Indicates whether the transaction is a T4 Transaction or Non-T4Transaction.
StaffingOrderID	Order ID associated with Transaction
OrderType	Order Type from Order associated with Transaction
WcCode	Worker Comp Code.
Wc Code Rate	Rate associated with the Wc Code.
JobPosition	Job Position from transaction
AssignmentID	Assignment Id associated with Transaction
AssignmentStartDate	Assignment Start Date
AssignmentEndDate	Assignment End Date
CheckAccountingPeriodDate	Accounting Period associated with the check.
ChequeDate	Check Date from the check associated with transaction
ChequeNumber	Check number.
ChequeBranch	Check’s branch
IsDirectDeposit	Shows if check is direct deposit or not.
InvoiceAccountingPeriodDate	Accounting Period associated with the Invoice.
InvoiceDate	Date of invoice associated with transaction
InvoiceNumber	Invoice number of invoice associated with Transaction
InvoiceBranch	Branch of Invoice
TotalPay	Total Pay from transaction
TotalBill	Total Bill from transaction
BillAmount	Bill Amount from transaction
GrossWages	Gross Wages from transaction
TotalAdjustmentPay	Total Adjustment Pay from Transaction
TotalAdjustmentBill	Total Adjustment Bill from Transaction
WorkerCompCost	WorkerCompCost from Transaction
CostWorkerCompCost	CostWorkerCompCost from Transaction
AgencyName	Agency Name associated with non-T4 transaction
AgencyCost	AgencyCost from transaction
PaymentCost	PaymentCost from Transaction
Burden	Burden from Transaction
GrossProfit	Gross Profit from Transaction
GrossProfitPercent	GrossProfitPercent from Transaction
GrossMargin	Difference of Total Bill and Total Pay from transaction Formula: Gross Margin = Total Bill – Total Pay
EmployerTaxes	EmployerTaxes from transaction
EmployerContribution	EmployerContribution from transaction
PayRTHours	Pay Hours from transaction for “REG” pay code
PayOTHours	Pay Hours from transaction for “OT” pay code
PayDTHours	Pay Hours from transaction for “DT” pay code
PayOtherHours	PayOtherHours from transaction.
PayTotalHours	PayTotalHours from transaction
BillRTHours	Bill Hours from transaction for “REG” pay code
BillOTHours	Bill Hours from transaction for “OT” pay code
BillDTHours	Bill Hours from transaction for “DT” pay code
BillOtherHours	BillOtherHours from transaction
BillTotalHours	BillTotalHours from transaction
RTPay	Total Pay from transaction for “REG” pay code
OTPay	Total Pay from transaction for “OT” pay code
DTPay	Total Pay from transaction for “DT” pay code
RTBill	Total Bill from transaction for “REG” pay code
OTBill	Total Bill from transaction for “OT” pay code
DTBill	Total Bill from transaction for “DT” pay code
TotalAdjustmentCost	Total Adjustment cost from Transaction
GPAdjustmentPay	GPAdjustmentPay from transaction
GPAdjustmentBill	GPAdjustmentBill from transaction
GPAdjustmentCost	GPAdjustmentCost from transaction
NonAdjustmentCost
SalesTaxAmount	Sum of total SalesTaxAmount from transaction.
WorkerCompWage	WorkerCompWage from transaction
CreditCardFee	CreditCardFee from transaction
DiscountAmount	DiscountAmount  from transaction
RebateAmount	RebateAmount from transaction
PONumber	Purchase Order number from transaction
Fed Taxes	Canadian Federal Withholding Tax from payment check associated with transaction. *The tax amount is calculated as Tax Amount present in the check multiplied by PayPercentOFTransaction. Formula = tax amount * PayPercentOFTransaction. Where PayPercentofTransaction is the proportion of transaction in a check
Prov Taxes	Canadian Province Tax from payment check associated with transaction.
EIEE	Canadian EI EE Tax from payment check associated with transaction.
CPPEE	Canadian CPP EE (Quebec Pension Plan EE) Tax  from payment check associated with transaction.
PPIEE	Canadian PPI  EE Tax from payment check associated with transaction.
OtherTaxesEE	Sum of all tax amounts present in the check associated with transaction (excluding  Fed Taxes, Prov Taxes, EIEE, CPPEE and PPIEE)
Job Position	Job Position from Order associated with Transaction
BoldJobID	The identifier for the related job in AviontéBOLD (Front Office)
BoldCompanyID	The identifier for the related company in AviontéBOLD (Front Office)
ResidentGeocode
WorkGeocode
WorksiteAddress1
WorksiteAddress2
WorksiteCity
WorksiteState
WorksiteZipCode
WorksiteCountry
Dynamic fields	After the column ‘Job Position, if there are users of particular categories present in the transaction extra for transaction, then the names of the user along with their respective category are displayed. (These columns are pulled dynamically so these columns would be displayed only if there are users present in transaction extra) For e.g. In a particular transaction, if John Doe is a Service Rep of category “CustomerUser” then his name will be displayed in the dynamic column CustomerUser: Service Rep

Back to Top