invantive documentation
Invantive Support ForumsLog In / Sign Up

LedgerAccountById: Minox Ledger Account by ID

read only per partition REST

  • Catalog: Minox
  • Schema: MasterDataLedger
  • Label: Ledger Account by ID

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_id `` The identity of an account
administration_code `` Partition to retrieve data from.
max_ledger_id_length `` pass the ledger id length for the accountNrRule
rgs_based_on `` Enum: minox_balance or account_total (Values: minox_balance, account_total)
rgs_mapping_level `` | 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 LedgerAccountById 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_transactions char Aggregate Transactions filters on the platform, writable, aggregate_transactions Whether the ledgeraccount needs to be compressed, also known as 'verdichten'.
aggregation_aggregation_level int64 Aggregation Level filters on the platform, writable, aggregation.aggregation_level Between 1 and 5.
aggregation_description varchar2 Aggregation Description filters on the platform, writable, aggregation.description
allow_free_vat_input char Allow Free VAT Input filters on the platform, writable, allow_free_vat_input
balance_description varchar2 Balance Description filters on the platform, writable, balance.description
balance_id int64 Balance ID filters on the platform, writable, balance.id
balance_isGroup char Balance Is Group filters on the platform, writable, balance.isGroup
balance_type varchar2 Balance Type filters on the platform, writable, balance.type
blocked_active char Blocked Active filters on the platform, writable, blocked.active Indicates if the account is blocked
blocked_reason varchar2 Blocked Reason filters on the platform, writable, blocked.reason The reason the account is blocked
budget_division_description varchar2 Budget Division Description filters on the platform, writable, budget_division.description
budget_division_id int64 Budget Division ID filters on the platform, writable, budget_division.id
cost_type_description varchar2 Cost Type Description filters on the platform, writable, cost_type.description
debit_credit_suggestion varchar2 Debit/Credit Suggestion filters on the platform, writable, debit_credit_suggestion
description varchar2 Description filters on the platform, writable, description
id int64 ID filters on the platform, writable, id
isBalance char Is Balance filters on the platform, writable, isBalance
memo_active char Memo Active filters on the platform, writable, memo.active Whether the memo is shown in the UI when this account is used.
memo_text varchar2 Memo Text filters on the platform, writable, memo.text The content of the memo.
quantity_applicable char Quantity Applicable filters on the platform, writable, quantity_applicable
referral_ledger_account_description varchar2 Referral Ledger Account Description filters on the platform, writable, referral_ledger_account.description
referral_ledger_account_id int64 Referral Ledger Account ID filters on the platform, writable, referral_ledger_account.id
vat_account_id varchar2 VAT Account ID filters on the platform, writable, vat.account_id
vat_amount decimal VAT Amount filters on the platform, writable, vat.amount
vat_description varchar2 VAT Description filters on the platform, writable, vat.description
vat_id int64 VAT ID filters on the platform, writable, vat.id
vat_percentage decimal VAT Percentage filters on the platform, writable, vat.percentage
vat_type varchar2 VAT Type filters on the platform, writable, vat.type
year_budget decimal Year Budget filters on the platform, writable, year_budget

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

All changes of the driver, 26.0 to 27.0