Table: Cash Drawer Transaction Entity

Table: Cash Drawer Transaction Entity

This 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.

Column Data Type Column Info Value Notes Other
idint(11)The id of the entity
cash_drawer_idint(11)Associated cash drawer id
loan_idint(11)The id of the associated loan account
payment_idint(11)Associated payment id
descriptionvarchar(255)The description of the entity instance
categoryint(11)Transaction category
typechar(30)Identifier for the entity type
amountdecimal(11,2)Charge amount
balancedecimal(11,2)Cash Drawer balance after the transaction
datedateDisbursement date
is_reconciledtinyint(1)Whether or not it has been reconciled1 - yes, 0 - no
reconciliation_datedatetimeReconciliation date time
deletedtinyint(1)Whether or not the entity was deleted1 - yes, 0 - no
lastUpdatedtimestampTimestamp of when the entity was last updated

< Back to List