Transaction designators and types

Each transaction in Infor Public Sector Billing is classified using a combination of a transaction designator and a transaction type. The transaction designator indicates the balance the transaction applies to, such as a penalty or the principal amount of a bill. The transaction type indicates what was done to that balance, such as adjusting it or refunding it.

When you look up transactions, Infor Public Sector shows each transaction's designator and type in the Lookup Results grid. The transaction designator and type are also displayed at the top of the Transaction InfoViewer. The database uses enumerations to represent transaction designators and types, so it is important to know what these values represent. This table lists the transaction designator enumerations:

Enumeration	Description
1	Account
2	Budget Billing Settle (unused)
3	Deposit
4	Discount
5	Interest
6	Overpay
7	Payment Resolution
8	Penalty
9	Penalty Interest
10	Principal
11	Surcharge

This table lists the transaction type enumerations:

Enumeration	Description
1	Adjustment: credit or debit modification of the amount owed for a charge or due for a credit
2	Apply: amount of credit funds applied to a charge elsewhere on the account
3	Charge: original amount charged to the account
4	Credit: repositioning transaction when a credit amount is moved within the account, funds in a temporary location
5	Drop Balance: credit or debit amount to zero out the account when it is near a 0.00 balance
6	Refund: debit amount returned to the customer
7	Resolution: debit amount to record the resolution of unmatched payments
8	Round: credit or debit to account for cash rounding transactions in AU and NZ
9	Payment: credit amount paid toward a charge
10	Payment Adjustment: credit or debit modification to the amount paid toward a charge
11	Transfer: debit amount moved from one account to another
12	Reallocate: debit amount moved from one bill type to another within the same account
13	Rebate: credit discount amount that can apply toward other charges on the account/bill

As a shorthand, Infor Public Sector Billing transactions are typically classified using the transaction designator enumeration followed by the transaction type enumeration, such as 6,11 for an overpayment transfer. Note that not all transaction types are allowed for all designators, so not all combinations will be found in the database. The tables below list all of the possible combinations.

Account Transactions

This table shows each combination of transaction designator and transaction type that can be found in the ACCTTRAN table:

Enum	Designator	Enum	Transaction Type
1	Account	1	Adjustment
		2	Apply
		5	Drop Balance
		6	Refund
		8	Round
		9	Payment
		10	Payment Adjustment
		11	Transfer
		12	Reallocate
4	Discount	1	Adjustment
		2	Apply
		4	Credit
		5	Drop Balance
6	Overpayment	2	Apply
		4	Credit
		5	Drop Balance
		6	Refund
		10	Payment Adjustment
		11	Transfer
		12	Reallocate
7	Payment Resolution	7	Resolution
8	Penalty	1	Adjustment
		3	Charge
		5	Drop Balance
		9	Payment
		10	Payment Adjustment
		11	Transfer
9	Penalty Interest	1	Adjustment
		3	Charge
		5	Drop Balance
		9	Payment
		10	Payment Adjustment
		11	Transfer
10	Principal	1	Adjustment
		2	Apply
		3	Charge
		5	Drop Balance
		9	Payment
		10	Payment Adjustment
		11	Transfer
		13	Rebate
11	Surcharge	1	Adjustment
		3	Charge
		5	Drop Balance
		9	Payment
		10	Payment Adjustment
		11	Transfer
		13	Rebate

Deposit Transactions

This table shows each combination of transaction designator and transaction type that can be found in the DEPTRAN table:

Enum	Designator	Enum	Transaction Type
3	Deposit	1	Adjustment
		2	Apply
		3	Charge
		6	Refund
		9	Payment
		10	Payment Adjustment
		11	Transfer