Contents

Transaction History

Transaction History conditions allow you to query accounts based on payment transaction history criteria.

Condition	Table	Column	Description
Check Number	PayHistory	Checknbr	Check number to pay the invoice.
Invoice Date	PayHistory	Invoiced	Date on the invoice.
Invoice Number	PayHistory	Invoice	Invoice number.
Net Tax amount	PayHistory	Tax	Net tax amount.
Net Transaction Amount	PayHistory	TotalPaid	Net transaction amount.
Net Transaction Fee	PayHistory	Calculated	Sum of Fee1 through Fee10.
Overpayment Amount	PayHistory	OverPaidAmt	Overpayment amount.
Total Transaction Amount	PayHistory	TotalPaid	Total transaction amount.
Transaction Batch Number	PayHistory	BatchNumber	Number that Latitude assigns to identify the transaction batch.
Transaction Batch Type	PayHistory	BatchType	Type of transaction batch, such as payment, reversal, or balance adjustment.
Transaction Comment	PayHistory	Comment	Comment regarding the transaction.
Transaction Date	PayHistory	DatePaid	Date the transaction occurred.
Transaction Desk	PayHistory	Desk	Desk associated to the transaction.
Transaction Entered Date	PayHistory	Entered	Date a user added the transaction.
Transaction Fee	PayHistory	Calculated	Sum of Fee1 through Fee10.
Transaction id	PayHistory	UID	Code that Latitude assigned to identify a transaction in the batch.
Transaction is Correction?	PayHistory	IsCorrection	Transaction is or isn't a correction.
Transaction Post Date UID	PayHistory	PostDateUID	Code that identifies the transaction and links it to the payment arrangement (in the ScheduledPayment table).
Transaction Reversed?	PayHistory		Transaction is or isn't a reversal.
Transaction Sub Batch Type	PayHistory	SubBatchType	Type of transaction sub-batch.
Transaction System Month	PayHistory	SystemMonth	System month in which the transaction occurred.
Transaction Type?	PayHistory	BatchType	Type of transaction batch, such as payment, reversal, or balance adjustment.