| time | time | false | false | | | 1.0a100 | the time the transaction occured |
| transid | pkey | false | true | | notice_log.transid | 1.69 | the unique identifier for this transaction |
| accounting | accounting | false | false | businesses.accounting | | 1.0a100 | the identifier for the business (see businesses) |
| source_accounting | accounting | false | false | businesses.accounting | | 1.0a100 | the source of the charge to this account |
| username | username | false | false | business_administrators.username | | 1.0a100 | the identifier for the admin involved in the transaction (see business_administrators) |
| type | string | false | false | transaction_types.name | | 1.0a100 | the type of transaction |
| description | string | false | false | | | 1.0a100 | description of the transaction |
| quantity | decimal_3 | false | false | | | 1.0a100 | the number of times to charge the account |
| rate | money | false | false | | | 1.83.0 | the amount per unit of quantity |
| payment_type | string | true | false | payment_types.name | | 1.0a100 | the type of payment made
check - check, check number will be in payment_info
money_order - money order
visa - visa card, last four in payment_info
mastercard - mastercard, last four in payment_info
amex - amex card, last four in payment_info
discover - discover card, last four in payment_info |
| payment_info | string | true | false | | | 1.0a100 | the payment info, such as last four of credit card number of check number |
| processor | string | true | false | credit_card_processors.provider_id | | 1.29 | the credit card processor that handled the payment |
| credit_card_transaction | fkey | true | false | credit_card_transactions.pkey | | 1.29 | the credit card transaction for this transaction |
| payment_confirmed | string | false | false | | | 1.0a100 | 'Y' if the payment is confirmed
'W' if waiting confirmation
'N' if confirmation failed |
