Standard AQ - Processed Transaction Detail AQ

Report Description

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

mceclip1.png

 

 

Parameters

mceclip0.png

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.

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.

RootCustomerID

Customer ID of the Root Customer for the associated Transaction

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

Display the current status of the associated employee - Active, Inactive, Processed, Unprocessed, etc.

The status can be configured in Start Page > Actions menu > Admin Tools - Config Choice. 

EmployeeAddressStreet1 Employee’s primary address street 1
EmployeeAddressStreet2 Employee’s primary address street 2
EmployeeAddressCity Employee’s primary address city name
EmployeeAddressCounty Employee’s primary address County name
EmployeeAddressState Employee’s primary address state abbreviation
EmployeeAddressZipCode Employee’s primary address Zip Code
PrimaryPhone Employee’s Primary Phone Number
Email Employee’s Email Address

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

Shows Item Cost value for the Adjustment Pay codes. Otherwise, it is 0.

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 Auto-generated code for the geographical region that applies to the address type (Main Address). 
WorkGeocode Auto-generated code for the geographical region that applies to the address type (Worksite Address). 
WorksiteAddress1 Customer’s Worksite address 1
WorksiteAddress2 Customer’s Worksite address 2
WorksiteCity Customer’s Worksite City Name
WorksiteState Customer’s Worksite State Abbreviation
WorksiteZipCode Customer’s Worksite Zip Code
WorksiteCountry Customer’s Worksite country name
BoldTimeSheetApprovedBy Name of the user who has approved the Timesheet from AviontéBOLD
BoldTimeSheetApprovedDate Date on which the Timesheet was approved from AviontéBOLD
BoldSavedBy Name of the user who has saved the Timesheet from AviontéBOLD
BoldSavedTime Date on which the Timesheet was saved from AviontéBOLD
BoldSubmittedBy Name of the user who has submitted the Timesheet from AviontéBOLD
BoldSubmittedTime Date on which the Timesheet was submitted from AviontéBOLD

Dynamic Fields

After the column ‘BoldSubmittedTime’, 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

 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful
Share