Database – Cash Drawer Transaction Limits (source_company_cash_drawer_transaction_limits)
Updated 3 weeks ago
Description
This table holds information on the transaction limits for your company's cash drawer. Adding a transaction limit offers control over how large a transaction from the cash drawer can be.
Table Fields
Column | Data Type | Column Info | Value Notes |
id | int(11) | The ID of the cash drawer. | |
source_company_id | int(11) | The ID for the source company | |
reason_text | varchar(255) | ||
reason_id | int(11) | ||
transaction_limit | double(6,2) | The limit on how large a cash drawer transaction can be | |
active | int(11) | Whether the transaction limit is active | |
created | timestamp | When the cash drawer was created | |
lastUpdated | timestamp | When the cash drawer was last updated | |
deleted | tinyiny(4) | Whether the transaction limit has been deleted |