Payments

CurrencyId is an nvarchar field to store the 3-letter code of the accepted currency for a payment within the Payment table. Its maximum length of 128 characters should include enough characters for different international currencies.

The ChargeBearerId field in the Payment table stores a unique string of characters up to 64 characters in length associated with the charge bearer of a payment.

The Reference field in the Payment table is a nvarchar data type with a maximum length of 128 characters, and is used to store a unique reference code for each payment record.

The StatusId field in the Payment table is a nvarchar field with a maximum length of 64 characters. It is used to track the status of payments, such as “Paid”, “Unpaid” and “Cancelled,” which are stored as alphanumeric values in the field.

RemittanceInformation is an nvarchar field in the Payment table which stores additional, user-defined details about a payment in the form of text. It allows users to keep track of supplementary information that may not necessarily fit into the other categories in the table, e.g. payment originator or intended recipient, which can provide helpful context when running queries or troubleshooting.

The PaymentMessage field in the Payment table contains message text about each payment made by customers. This could include information about the payment itself, links to resources, or other related messages for the payment.

Miscellaneous notes and information for the entry or record.

The BankReference field in the Payment table contains a string up to 64 characters long containing a reference to a payment received from a bank, such as a transaction ID from an interface or a check number.