Database – Cash Drawer Transaction Entity (cash_drawer_transaction_entity)
Description
This table holds a transaction line for a cash drawer. Transaction lines can be in the form of a withdrawal or a deposit. Furthermore, they can either be reconciled or unreconciled. For an overview on cash drawers and source companies, take a look at our Source Company – Cash Drawers and the Vault article. Our API – Create a Source Company article is a good place to start for API Source Company information.
Cash Drawer Transaction Entity
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The ID of the entity | ||
cash_drawer_id | int(11) | Associated cash drawer ID | ||
loan_id | int(11) | The ID of the associated loan account | ||
payment_id | int(11) | Associated payment ID | ||
description | varchar(255) | The description of the entity instance | ||
category | int(11) | Transaction category | ||
type | char(30) | Identifier for the entity type | transaction.type.deposit, transaction.type.withdrawl | |
amount | decimal(11,2) | Charge amount | ||
balance | decimal(11,2) | Cash Drawer balance after the transaction | ||
date | date | Disbursement date | ||
is_reconciled | tinyint(1) | States if the transaction has been reconciled | 1 - yes, 0 - no | |
reconciliation_date | datetime | Reconciliation date time | ||
deleted | tinyint(1) | States if the entity was deleted | 1 - yes, 0 - no | |
lastUpdated | timestamp | Timestamp of when the entity was last updated |