deposit
The deposit table tracks funds deposited into the system, used for managing cash flow and financial transactions.
Columns
| Name | Type | References | Description |
| account | String | The account associated with the transaction or record, typically used to categorize financial data. | |
| class | String | The class associated with the record, used for further classification or categorization of transactions. | |
| cleared | Boolean | Indicates whether the transaction has been cleared or reconciled, typically referring to financial transactions such as payments. | |
| cleareddate | Date | The date when the transaction was marked as cleared or reconciled, used for financial reporting and tracking. | |
| createddate | Datetime | The date and time when the record was created in the system, used for auditing and record-keeping purposes. | |
| creditcardprocessor | String | The processor or service handling credit card transactions for this record, used to track payment processing services. | |
| currency | String | The currency used in the transaction or record, typically represented by the ISO currency code (for example, USD, EUR). | |
| currencyname | String | The name of the currency, such as 'US Dollar' or 'Euro', providing the full description of the currency used. | |
| customform | String | The custom form associated with the record, often used to track specific data entry forms or templates customized by the user. | |
| department | String | The department associated with the record or transaction, typically used for categorization in an organizational structure. | |
| exchangerate | Decimal | The exchange rate used to convert between currencies in the transaction, important for multi-currency accounting. | |
| externalid | String | An external identifier used to reference the record from external systems, ensuring integration with other platforms. | |
| isbasecurrency | Boolean | Indicates whether the currency used is the base currency of the system or organization, essential for currency conversion calculations. | |
| lastmodifieddate | Datetime | The date and time when the record was last modified, used for tracking updates and changes made to the record. | |
| location | String | The location associated with the transaction, which could refer to a physical or organizational location for tracking purposes. | |
| memo | String | A description or note providing additional details about the transaction or record, often used for clarifying the purpose. | |
| postingperiod | String | The accounting period in which the transaction or record is posted, used for financial reporting and period management. | |
| subsidiary | String | The subsidiary associated with the record, used for tracking transactions and financial data within a parent organization. | |
| taxperiod | String | The period in which the transaction or record is reported for tax purposes, ensuring compliance with tax reporting requirements. | |
| tobeprinted | Boolean | Indicates whether the record is marked to be printed, typically used for documents or invoices that require physical printing. | |
| total | Decimal | The total amount for the transaction or record, often representing the sum of the line items or transaction value. | |
| trandate | Date | The date when the transaction occurred, essential for accounting, financial reporting, and timeline tracking. | |
| tranid | String | The unique identifier for the transaction, used to reference and track the specific transaction record. | |
| updatecurrency | String | The currency that will be used to update the record, particularly relevant in scenarios involving currency conversion or updates. |