LedgerAccount_Cost_typeSearchAccountId: Minox itgen_minox_ledgeraccount_cost_typesearchaccountid_plural
read only per partition REST
- Catalog:
Minox - Schema:
MasterDataLedger - Label: itgen_minox_ledgeraccount_cost_typesearchaccountid_plural
Retrieves a single ledger_account.
The data in this table is partitioned per value of the administration_code column.
Can only retrieve data.
API Source
- Endpoint:
/tenant/{tenant_id}/administration/{administration_id}/ledger_account/{account_id} - Operation:
get /tenant/{tenant_id}/administration/{administration_id}/ledger_account/{account_id}
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
account_ |
`` | The identity of an account | ||
administration_ |
`` | Partition to retrieve data from. | ||
max_ |
`` | pass the ledger id length for the accountNrRule | ||
rgs_ |
`` | Enum: minox_balance or account_total (Values: minox_balance, account_total) | ||
rgs_ |
`` | | Value | Description | |--------|----------------------------------| | saved | Saved mappings on administration | | best | 100% Mappings on tenant or crowd | | guess | Partly matched mappings | | report | Full mappings (for reporting) | (Values: saved, best, guess, report) |
Table Columns
The columns of the table LedgerAccount_Cost_typeSearchAccountId are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
aggregate_ |
char |
Aggregate Transactions | filters on the platform, writable, ::ancestor. |
Whether the ledgeraccount needs to be compressed, also known as 'verdichten'. | |
aggregation_ |
int64 |
Aggregation Level | filters on the platform, writable, ::ancestor. |
Between 1 and 5. | |
aggregation_ |
varchar2 |
Aggregation Description | filters on the platform, writable, ::ancestor. |
||
allow_ |
char |
Allow Free VAT Input | filters on the platform, writable, ::ancestor. |
||
balance_ |
varchar2 |
Balance Description | filters on the platform, writable, ::ancestor. |
||
balance_ |
int64 |
Balance ID | filters on the platform, writable, ::ancestor. |
||
balance_ |
char |
Balance Is Group | filters on the platform, writable, ::ancestor. |
||
balance_ |
varchar2 |
Balance Type | filters on the platform, writable, ::ancestor. |
||
blocked_ |
char |
Blocked Active | filters on the platform, writable, ::ancestor. |
Indicates if the account is blocked | |
blocked_ |
varchar2 |
Blocked Reason | filters on the platform, writable, ::ancestor. |
The reason the account is blocked | |
budget_ |
varchar2 |
Budget Division Description | filters on the platform, writable, ::ancestor. |
||
budget_ |
int64 |
Budget Division ID | filters on the platform, writable, ::ancestor. |
||
debit_ |
varchar2 |
Debit/Credit Suggestion | filters on the platform, writable, ::ancestor. |
||
description |
varchar2 |
Description | writable, ::ancestor. |
||
description_ |
varchar2 |
itgen_minox_description_2 | filters on the platform, writable, ::ancestor. |
||
id |
varchar2 |
ID | writable, id |
||
id_2 |
int64 |
itgen_minox_id_2 | filters on the platform, writable, ::ancestor. |
||
is |
char |
Is Balance | filters on the platform, writable, ::ancestor. |
||
memo_ |
char |
Memo Active | filters on the platform, writable, ::ancestor. |
Whether the memo is shown in the UI when this account is used. | |
memo_ |
varchar2 |
Memo Text | filters on the platform, writable, ::ancestor. |
The content of the memo. | |
quantity_ |
char |
Quantity Applicable | filters on the platform, writable, ::ancestor. |
||
referral_ |
varchar2 |
Referral Ledger Account Description | filters on the platform, writable, ::ancestor. |
||
referral_ |
int64 |
Referral Ledger Account ID | filters on the platform, writable, ::ancestor. |
||
value |
varchar2 |
Value | writable, value |
||
vat_ |
varchar2 |
VAT Account ID | filters on the platform, writable, ::ancestor. |
||
vat_ |
decimal |
VAT Amount | filters on the platform, writable, ::ancestor. |
||
vat_ |
varchar2 |
VAT Description | filters on the platform, writable, ::ancestor. |
||
vat_id |
int64 |
VAT ID | filters on the platform, writable, ::ancestor. |
||
vat_ |
decimal |
VAT Percentage | filters on the platform, writable, ::ancestor. |
||
vat_ |
varchar2 |
VAT Type | filters on the platform, writable, ::ancestor. |
||
year_ |
decimal |
Year Budget | filters on the platform, writable, ::ancestor. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver:
Changes of This Table, 26.0 to 27.0
-administration_code-administration_name