Cost_typeSearchLedgerAccount: Minox itgen_minox_cost_typesearchledgeraccount_plural
read only per partition REST
- Catalog:
Minox - Schema:
MasterDataLedger - Label: itgen_minox_cost_typesearchledgeraccount_plural
Retrieves a ledger_account list.
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 - Operation:
get /tenant/{tenant_id}/administration/{administration_id}/ledger_account
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
administration_ |
`` | Partition to retrieve data from. | ||
number_ |
`` | If number of fiscal years is 1: only retrieve the ledger accounts of the last fiscal year. If number of fiscal years is 2 - 5: Receive additional ledger accounts from earlier fiscal years that do not exist anymore in the last fiscal year, indicated with a 'deleted'-tag. On default, three fiscal years will be checked. | ||
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) | If rgs_mapping_level is set to 'report', then rgs_based_on also needs to be set. (Values: saved, best, guess, report) |
Table Columns
The columns of the table Cost_typeSearchLedgerAccount 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 |
int64 |
ID | 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. |
||
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