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


How did we do?


Powered by HelpDocs (opens in a new tab)