Submit a ticket

Standard AQ - Processed Transaction Detail AQ

Updated on Follow
0 out of 0 found this helpful

Report Description

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

ProcessedTransactionDetail.png

 

 

 

 

Parameters

Parameter Name

Options

Description

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.

 

 

 

 

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

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

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

OrderType

Order Type of 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

TotalAdjustmentCost

Total Adjustment cost from Transaction

GPAdjustmentPay

GPAdjustmentPay from transaction

GPAdjustmentBill

GPAdjustmentBill from transaction

GPAdjustmentCost

GPAdjustmentCost from transaction

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

 

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)

 

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

 


Have more questions? Submit a request

0 Comments


This space is for article feedback only. To make a request of the Avionté Support Team, please submit a ticket to https://support.avionte.com.