Standard AQ - Processed Transaction Summary

Overview

Updated 01/17/2023

• Click here for information on Standard Reports
• Click here for information on Advanced Queries.

Report Description
Parameters
Report Fields

Report Description

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

Parameters

Parameter Name	Options	Description
Branch (Transaction)	All available branches.	Transaction’s Branch.
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.
SSN		Filters results by Social Security Number.
Employee ID	Field to enter a value	Filters results by Employee ID.

Report Fields

Field Name	Description
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 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)
SSN	Social Security number of employee from transaction.
EmployeeName	Name of employee from transaction.
Is W2	Indicates whether the transaction is a W2 Transaction or Non-W2 Transaction.
StaffingOrderID	Order ID associated with Transaction
OrderType	Order Type from Order associated with Transaction
WcCode	Worker compensation Code. For e.g. MN7854 where MN is the state and 7854 is the WcCode.
Wc Code Rate	Rate associated with the Wc Code.
JobPosition	Job Position from transaction
BoldJobID	The identifier for Job in AviontéBOLD (Front Office)
AssignmentID	Assignment Id associated with Transaction
AssignmentStartDate	Assignment Start Date
AssignmentEndDate	Assignment End Date
CheckAccountingPeriodDate	Accounting Period associated with the check.
CheckDate	Check Date from the check associated with the transaction
CheckNumber	Check number.
CheckBranch	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
Agency Name	Agency Name associated with non W2 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
FederalIncomeTax	Federal Income 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
StateTax	State Tax from payment check associated with transaction.
FICAEE	FICAEE from payment check associated with transaction.
MEDEE	MEDEE from payment check associated with transaction.
OtherTaxes	Sum of all tax amounts present in the check associated with transaction (excluding Federal Income Tax, State Tax, FICAEE, MEDEE)
BoldCompanyID	Identifier for Company in AviontéBOLD (Front Office)
ResidentGeocode
WorkGeocode
WorksiteAddress1
WorksiteAddress2
WorksiteCity
WorksiteState
WorksiteZipCode
WorksiteCountry
Dynamic fields	After the column ‘OtherTaxes, 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