Standard AQ - Processed Transaction Detail AQ

Overview

Updated 12/10/2021

• 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 a 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
SSN		Filters results by Social Security Number.
Customer Name		Filters results by Customer name.

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.
RootCustomerID
BoldCompanyID	Company identifier in AviontéBOLD (Front Office)
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)
EmployeeName	Name of employee from transaction.
SSN	Social Security number of employee from transaction.
Is W2	Indicates whether the transaction is a W2 Transaction or Non-W2 Transaction.
EmployeeStatus
EmployeeAddressStreeet1	House number and street name
EmployeeAddressStreeet2	Apartment/Suite/Room number (if any)
EmployeeAddressCity	Name of town
EmployeeAddressCounty	Name of county
EmployeeAddressState	State abbreviation
EmployeeAddressZipCode	ZIP code of employee
PrimaryPhone	Phone number of employee
Email	Email of employee
StaffingOrderID	Order ID associated with Transaction
BOLDJobID	Job identifier in AviontéBOLD (Front Office)
OrderType	Order Type of Order associated with transaction
AssignmentID	Assignment Id associated with Transaction
AssignmentStartDate	Assignment Start Date
AssignmentEndDate	Assignment End Date
Shift	Shift is pulled from the transaction
CheckAccountingPeriodDate	Accounting Period associated with the check.
CheckDate	Check Date from the check associated with 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
PayCode	Pay Code from transaction
PayUnit	Pay Unit from transaction
PayRate	Pay Rate from transaction
ItemPay	ItemPay from transaction
BillUnit	Bill Unit from transaction
BillRate	Bill Rate from transaction
ItemBill	ItemBill from transaction
CostUnit	CostUnit from transaction
CostRate	CostRate from transaction
ItemCost	ItemCost from transaction
SalesTaxAmount	Sales Tax Amount from transaction
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	Agency Cost from Transaction
PaymentCost	Payment Cost from Transaction
Burden	Burden from Transaction
GrossProfit	Gross Profit from Transaction
GrossProfitPercent	GrossProfitPercent from Transaction
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
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
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
WcCode	Worker compensation Code. For e.g. MN7854 where MN is the state and 7854 is the WcCode.
WcCodeRate	Rate associated with the Wc Code
JobPosition	Job Position from transaction
TotalAdjustmentCost	Total Adjustment cost from Transaction
GPAdjustmentPay	GPAdjustmentPay from transaction
GPAdjustmentBill	GPAdjustmentBill from transaction
GPAdjustmentCost	GPAdjustmentCost from transaction
NonAdjustmentCost
WorkerCompWage	WorkerCompWage from transaction
CreditCardFee	CreditCardFee from transaction
DiscountAmount	DiscountAmount from transaction
RebateAmount	RebateAmount from transaction
PONumber	Purchase Order number from transaction
BillOtherHours	BillOtherHours from transaction
PayOtherHours	PayOtherHours  from transaction
ResidentGeocode
WorkGeocode
WorksiteAddress1
WorksiteAddress2
WorksiteCity
WorksiteState
WorksiteZipCode
WorksiteCountry
Dynamic Fields	After the column ‘PayOtherHours’, 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) Example: 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