api_advance_deposit_entries
Description
The api_advance_deposit_entries table exposes information about individual advance deposit entries. This table allows you to view all entries per advance deposit. Entries without an invoice ID represent write-offs. This table can be used in work-in-progress reports.
Fields
| Field Name | Type | Description |
|---|---|---|
key_entry_id | number | Unique identifier for the advance deposit entry |
key_account_id | number | Identifier of the account this entry belongs to |
key_project_id | number | Identifier of the project this entry belongs to |
key_invoice_id | number | Identifier of the invoice this entry belongs to |
account_name | string | Name of the account this entry belongs to |
entry_value | number | Value of the advance deposit entry |
entry_created_at | time | Timestamp when the entry was created |
entry_updated_at | time | Timestamp when the entry was last updated |
Related Tables
api_invoices– linked viakey_invoice_id