payments
Pipelined Data Sets
>
Banno Operation and Transaction
>
payments
| Column name | Description | Mode | Type | Length |
|---|---|---|---|---|
| payment_id | The unique identifier for the payment. | NULLABLE | STRING | |
| bill_id | The unique identifier for the bill. This is a UUID and References the user_bills table, which contains the bill_id. | NULLABLE | STRING | |
| transaction_id | The unique identifier for the transaction. | NULLABLE | STRING | |
| payable_from_account_id | The unique identifier for the account from which the payment is made. | NULLABLE | STRING | |
| amount | The amount of the payment. | NULLABLE | BIGNUMERIC | |
| is_active | Indicates whether the payment is active. | NULLABLE | BOOLEAN | |
| estimated_arrival | The estimated arrival date for the payment. | NULLABLE | TIMESTAMP | |
| process_date | The date when the payment is processed. | NULLABLE | TIMESTAMP | |
| fee | The fee associated with the payment. | NULLABLE | BIGNUMERIC | |
| confirmation_id | The confirmation ID for the payment. | NULLABLE | STRING | |
| tracking_code | The payment tracking code. | NULLABLE | STRING | |
| updated_at | The last updated date for the payment. | NULLABLE | TIMESTAMP | |
| merchant_id | The unique identifier for the recipient. | NULLABLE | STRING | |
| payment_method | The payment method used for the transaction. | NULLABLE | INTEGER | |
| rush_option | The rush option for the payment. | NULLABLE | INTEGER | |
| processing_state | The processing state of the payment. | NULLABLE | INTEGER | |
| partner_status | The status of the payment with the payment provider. | NULLABLE | INTEGER | |
| created_at | The creation date of the payment. | NULLABLE | TIMESTAMP | |
| memo | A memo or note associated with the payment. | NULLABLE | STRING | |
| comment | A comment associated with the payment. | NULLABLE | STRING | |
| schedule | The schedule for the payment. | NULLABLE | STRING |
Have a Question?
- Have a how-to question? Seeing a weird error? Get help on StackOverflow.
- Register for the Developer Office Hours where we answer technical Q&A from the audience.
Did this page help you?
Last updated Wed Mar 4 2026