Payment Sets

PaymentSetStateId is a field in the PaymentSet table that stores state information related to a payment set, represented as a string of up to 32 characters in length. The state information can be any string that is related to the specific payment set.

Miscellaneous notes and information for the entry or record.

The PaymentSetMessage field is an nvarchar data type in the PaymentSet table that holds text referring to the payment transactions that can be used to describe the payment status of those transactions.

The BankReference field in the PaymentSet table is an nvarchar data type of up to 64 characters used to store a customer's bank reference associated with a payment.

The PaymentSetStateMessage field in the PaymentSet table is a data type of nvarchar with a maximum length of 4000 characters. This field is used to store a message that describes the current state of a payment. It may provide information on the status of the payment, any updates or changes that have been made, or any errors or issues that have occurred during processing. This field allows for clear and concise communication and tracking of payment statuses within the PaymentSet table.

The 'Filename' field in the PaymentSet table is designed to store the name of a file associated with a payment record. It is of type nvarchar, allowing for Unicode character storage, and has a maximum length of 256 characters. This enables the field to accommodate diverse file naming conventions and extends support for international character sets, ensuring compatibility with various languages and symbols. The Filename field is essential for linking payment records to their corresponding files, facilitating efficient data management and retrieval.