Skip to main content
Aria Knowledge Central

Aria Transaction Types

Aria Transaction Types
This guide describes all Aria transaction types, details API scenarios that result in these transactions, displays screenshots (in the Aria Customer Care Portal) that demonstrate the results of transactions within an Aria account, and relates invoice and payment transactions to Aria batch processes.

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
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
  • collect_from_account_m
  • manage_pending_invoice_m
  • update_order_m
  • create_order_m
  • create_order_with_plan_m
  • gen_invoice_m
  • settle_account_balance_m
-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
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
  • issue_refund_to_acct_m
  • record_out_going_payment_m
-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 

Invoice charge line item

Includes invoice charge line items having the following <line_ type>(s)

Values/Descriptions
1—Recurring Charge
2—Tax Charge
5—Activation Charge
6—Usage Charge
7—Recurring Arrears      Charge
8—Order Charge
9—Surcharge

Yes Invoice charge line item. gl_detail invoice_
detail_no
  • gen_invoice_m
  • create_order_m
  • create_order_with_plan_m
  • manage_pending_invoice_m
  • gen_rb_m
  • update_order_m

-21

 

Void Invoice Charge Line Item

Includes invoice charge line items having the following <line type>(s)

Values/Descriptions
3—Service Credit
4—Coupon Credit

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
  • gen_invoice_m
  • create_order_m
  • create_order_with_plan_m
  • manage_pending_invoice_m
-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
  • create_cm_m
  • gen_rb_m
-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

  • Was this article helpful?