payment

List of all payments, including payments which did not clear. The payments that were accepted will have a txid filled in referring to the corresponding receipt transaction in the tx table.

Column name	Description	Data type
payment	Primary key.	integer
payment_status	What state the payment is in. Reference to `payment_status`.	smallint
company	Reference to `company`.	integer
account	Reference to `account`.	integer
tx	Reference to `tx`.	integer *
creation_time		timestamp with time zone
attempt_count	How many times this payment has been attempted.	integer *
clearance_time		timestamp with time zone *
clearing_operator	Reference to `operator`.	integer *
clearance_message	The message related to how the payment status was reached. For example, from the bank.	text *
amount		numeric (10,2)
account_name		text *
card_number_hint		text *
card_expiry_date		text *
creating_operator		integer
payment_type	Reference to `payment_type`.	integer
payment_number		text
bank_branch_number		text *
back_account_number	Also used for credit card numbers and other types of account numbers.	text *
surcharge_amount		numeric *
surcharge_tax_amount		numeric *
surcharge_tx	Reference to `tx`.	integer *
payment_plan	Reference to `payment_plan`.	integer *