Aria Transaction Types
Overview
All Aria transaction types are listed below. Each transaction type has a unique numeric identifier, both positive and negative. Negative numeric identifiers represent voids of the transactions identified with that same positive integer.
Description of Backend Transaction Data
Financial transactions in the Aria System appear in two tables: ARIACORE.ACCT_TRANSACTION and a second table based on the transaction type. Every transaction has a unique EVENT_NO across all clients, accounts, and transactions in ARIACORE.ACCT_TRANSACTION. For example, no two records in this table share EVENT_NO 12345.
The second table depends on the transaction type. Electronic payments (transaction_type 3) appear in ARIACORE.PAYMENTS, with the ACCT_TRANSACTION SOURCE_NO matching the PAYMENTS PAYMENT_ID. Write-offs (transaction_type 6) appear in ARIACORE.WRITE_OFFS, with the ACCT_TRANSACTION SOURCE_NO matching the WRITE_OFFS WRITE_OFF_NO.
Different transaction types can share the same SOURCE_NO. For example, Account 123 for Client X can have transaction_type 2 with SOURCE_NO 45678, and Account 456 for Client Y can have transaction_type 3 with the same SOURCE_NO 45678. This is valid in the data model. For voided transactions, the original and voided ACCT_TRANSACTION records share the same SOURCE_NO but have different EVENT_NO values. For instance, Account 789 might have transaction_type 10 with EVENT_NO 54321 and SOURCE_NO 98765. Voiding it creates a transaction_type -10 record with EVENT_NO 54322 and SOURCE_NO 98765.
Learn more about Aria transaction tables.
The transaction types below are recorded against an account in Aria. Those marked “Results In Charge: Yes” (is_charge_type = 1) increase the account or plan instance balance, while those marked “Results In Charge: No” (is_charge_type = 0) decrease it.
Transaction Types
Click on the Trans Type Description's link to view an API Reference's example input/output transaction and related transaction detail for each specific transaction type. Resulting UI screenshots are also provided per each example.
TRANS TYPE | DESCRIPTION | RESULTS IN CHARGE |
NOTES | TABLE NAME | TABLE KEY | API REFERENCE |
---|---|---|---|---|---|---|
2 | Check | No | An application of payment against the outstanding account balance via manual check. | external_payments | payment_id | record_external_payment_m |
-2 | Voided Check | Yes | A reversal of a previously applied payment via paper check. | external_payments | payment_id | void_transaction_m |
3 | Electronic Payment | No | An application of payment against the outstanding account balance via credit card or electronic check. | payments | payment_id |
|
-3 | Voided Electronic Payment | Yes | A reversal of a previously applied payment via credit card or electronic check. | payments | payment_id | void_transaction_m |
4 | Balance Transfer To Account | Yes | A transfer of responsibility for payment of a balance to another account. | balance_transfer | transfer_no | transfer_account_balance_m |
-4 | Voided Balance Transfer To Account | No | A reversal of transfer of responsibility for payment of a balance to another account. | balance_transfer | transfer_no | void_transaction_m |
5 | Balance Transfer From Account | No | A transfer of responsibility for payment of a balance from another account. | balance_transfer | transfer_no | transfer_account_balance_m |
-5 | Voided Balance Transfer From Account | Yes | A reversal of transfer of responsibility for payment of a balance from another account. | balance_transfer | transfer_no | void_transaction_m |
6 | Write Off/Dispute Hold | No | A charge of an amount to expense or loss in order to reduce the value of earnings. | write_offs | write_off_no | create_writeoff_or_ dispute_m |
-6 | Voided Write Off | Yes | A reversal of a charge of an amount to expense or loss in order to reduce the value of earnings. | write_offs | write_off_no | void_transaction_m |
8 | Refund Related Reversal | No | A reversal of prior charges against an account done in conjunction with a refund of a payment. | refunds | refund_no | issue_refund_to_acct_m |
-8 | Voided Refund Related Reversal | Yes | A reversal of a reversal of prior charges against an account done in conjunction with a refund of a payment. | refunds | refund_no | void_transaction_m |
9 | Balance Forward | Yes | A total of amounts due after all charges and payments have been applied to an account. | balance_forward | balance_no | create_acct_complete_m |
-9 | Voided Balance Forward | No | A reversal of total of amounts due after all charges and payments have been applied to an account. | balance_forward | balance_no | void_transaction_m |
10 | Cash Credit | No | A reduction of the outstanding account balance without receipt of payment. | cash_credits | credit_no | apply_cash_credit_m |
-10 | Voided Cash Credit | Yes | A reversal of a reduction of the outstanding account balance without receipt of payment. | cash_credits | credit_no | void_transaction_m |
12 | Refund of Electronic Payment | Yes | An application of return of payment via credit card or electronic check. | payments | payment_id | issue_refund_to_acct_m |
-12 | Voided Refund of Electronic Payment | No | A reversal of application of return of payment via credit card or electronic check. | payments | payment_id | void_transaction_m |
13 | Refund of External Payment | Yes | An application of return of payment via paper check. | check_refund | check_id |
|
-13 | Voided Refund of External Payment | No | A reversal of application of return of payment via paper check. | check_refund | check_id | void_transaction_m |
14 | External Charge | Yes | A client created charge. | external_charge | charge_no | Created by support only |
-14 | Voided External Charge | No | A reversal of a client created charge. | external_charge | charge_no | Created by support only |
15 | Dunning Charge | Yes | A finance charge due to non-payment. | dunning_charge | charge_id | get_transaction_information_m |
-15 | Voided Dunning Charge | No | A reversal of a finance charge due to non-payment. | dunning_charge | charge_id | void_transaction_m |
18 | Negative Balance Forward | No | A total of amounts due after all charges and payments have been applied to an account. | balance_forward | balance_no | create_acct_complete_m |
-18 | Voided Negative Balance Forward | Yes | A reversal of total of amounts due after all charges and payments have been applied to an account. | balance_forward | balance_no | void_transaction_m |
21 |
Includes invoice charge line items having the following <line_ type>(s) Values/Descriptions |
Yes | Invoice charge line item. | gl_detail | invoice_ detail_no |
|
-21
|
Includes invoice charge line items having the following <line type>(s) Values/Descriptions |
No | Voided Invoice charge line item. | gl_detail | invoice_ detail_no |
void_invoice_m |
22 | Invoice credit line item | No | Invoice credit line item. | gl_detail | invoice_detail_no |
|
-22 | Voided Invoice Credit Line Item | Yes | Voided Invoice credit line item. | gl_detail | invoice_detail_no | void_invoice_m |
24 | Credit Memo Line | No | A credit against a charge line on a prior invoice. | credit_memo | cm_no |
|
-24 | Voided Credit Memo Line | Yes | A reversal of a credit against a charge line on a prior invoice. | credit_memo | cm_no | void_credit_memo_m |
Associated Batches
Aria batch processes (also known as batch jobs) run once a day to manage accounts. Batch processes perform functions such as generating invoices, collecting payments, sending emails and statements to customers, completing dunning steps, and loading Activity Loader data into Aria.
Batch Number | Batch Name | Transaction Type(s) |
---|---|---|
3 | Pre-invoice housekeeping | Invoice charge line item (21) and Invoice credit line item (22) |
22 | Invoicer | Invoice charge line item (21) and Invoice credit line item (22) |
23 | Billing Manager | Electronic Payment (3) |
26 | Dunning Manager | Electronic Payment (3) |
Aria Transaction Type Topics
- Aria Transaction Tables
- This article offers insight to how Aria transactions are recorded in Aria's backend.
- Check: Transaction Type 2
- An application of payment against the outstanding account balance via manual check.
- Voided Check: Transaction Type -2
- A reversal of a previously applied payment via paper check.
- Electronic Payments: Transaction Type 3
- An application of payment against the outstanding account balance via credit card or electronic check.
- Voided Electronic Payment: Transaction Type -3
- A reversal of a previously applied payment via credit card or electronic check.
- Balance Transfer to Account: Transaction Type 4
- A transfer of responsibility for payment of a balance to another account.
- Voided Balance Transfer to Account: Transaction Type -4
- A reversal of transfer of responsibility for payment of a balance to another account.
- Balance Transfer from Account: Transaction Type 5
- A transfer of responsibility for payment of a balance from another account.
- Void Balance Transfer from Account: Transaction Type -5
- A reversal of transfer of responsibility for payment of a balance from another account.
- Write-Off or Dispute Hold: Transaction Type 6
- A charge of an amount to expense or loss in order to reduce the value of earnings.
- Refund Related Reversal: Transaction Type 8
- A reversal of prior charges against an account done in conjunction with a refund of a payment.
- Voided Refund Related Reversal: Transaction Type -8
- A reversal of a reversal of prior charges against an account done in conjunction with a refund of a payment.
- Balance Forward and Negative Balance Forward: Transaction Type 9 (Balance Forward) and Transaction Type 18 (Negative Balance Forward)
- Balance Forward: A total of amounts due after all charges and payments have been applied to an account. Negative Balance Forward: A total of amounts due after all charges and payments have been applied to an account.
- Voided Balance Forward: Transaction Type -9
- A reversal of total of amounts due after all charges and payments have been applied to an account.
- Cash Credit: Transaction Type 10
- A reduction of the outstanding account balance without receipt of payment.
- Voided Cash Credit: Transaction Type -10
- A reversal of a reduction of the outstanding account balance without receipt of payment.
- Refund of Electronic Payment: Transaction Type 12
- An application of return of payment via credit card or electronic check
- Voided Refund of Electronic Payment: Transaction Type -12
- A reversal of application of return of payment via credit card or electronic check
- Refund of External Payment: Transaction Type 13
- An application of return of payment via paper check.
- Voided Refund of External Payment: Transaction Type -13
- A reversal of application of return of payment via paper check
- Dunning Charge: Transaction Type 15
- A finance charge due to non-payment
- Voided Dunning Charge: Transaction Type -15
- A reversal of a finance charge due to non-payment
- Voided Negative Balance Forward: Transaction Type -18
- A reversal of total of amounts due after all charges and payments have been applied to an account.
- Invoice Charge Line Item: Transaction Type 21 (Charge Line Items), Transaction Type 22 (Credit Line Items)
- Invoice charge line item and Invoice credit line item
- Voided Invoice Charge and Credit Line Items: Transaction Type -21 (Charge Line Items), Transaction Type -22 (Credit Line Items)
- Voided Invoice charge line item and Voided Invoice credit line item.
- Credit Memo Line: Transaction Type 24
- A credit against a charge line on a prior invoice
- Voided Credit Memo Line: Transaction Type -24
- A reversal of a credit against a charge line on a prior invoice.