invantive documentation
Invantive Support ForumsLog In / Sign Up

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_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 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_transactions char Aggregate Transactions filters on the platform, writable, ::ancestor.::ancestor.aggregate_transactions Whether the ledgeraccount needs to be compressed, also known as 'verdichten'.
aggregation_aggregation_level int64 Aggregation Level filters on the platform, writable, ::ancestor.::ancestor.aggregation.aggregation_level Between 1 and 5.
aggregation_description varchar2 Aggregation Description filters on the platform, writable, ::ancestor.::ancestor.aggregation.description
allow_free_vat_input char Allow Free VAT Input filters on the platform, writable, ::ancestor.::ancestor.allow_free_vat_input
balance_description varchar2 Balance Description filters on the platform, writable, ::ancestor.::ancestor.balance.description
balance_id int64 Balance ID filters on the platform, writable, ::ancestor.::ancestor.balance.id
balance_isGroup char Balance Is Group filters on the platform, writable, ::ancestor.::ancestor.balance.isGroup
balance_type varchar2 Balance Type filters on the platform, writable, ::ancestor.::ancestor.balance.type
blocked_active char Blocked Active filters on the platform, writable, ::ancestor.::ancestor.blocked.active Indicates if the account is blocked
blocked_reason varchar2 Blocked Reason filters on the platform, writable, ::ancestor.::ancestor.blocked.reason The reason the account is blocked
budget_division_description varchar2 Budget Division Description filters on the platform, writable, ::ancestor.::ancestor.budget_division.description
budget_division_id int64 Budget Division ID filters on the platform, writable, ::ancestor.::ancestor.budget_division.id
debit_credit_suggestion varchar2 Debit/Credit Suggestion filters on the platform, writable, ::ancestor.::ancestor.debit_credit_suggestion
description varchar2 Description writable, ::ancestor.description
description_2 varchar2 itgen_minox_description_2 filters on the platform, writable, ::ancestor.::ancestor.description
id varchar2 ID writable, id
id_2 int64 itgen_minox_id_2 filters on the platform, writable, ::ancestor.::ancestor.id
isBalance char Is Balance filters on the platform, writable, ::ancestor.::ancestor.isBalance
memo_active char Memo Active filters on the platform, writable, ::ancestor.::ancestor.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, ::ancestor.::ancestor.memo.text The content of the memo.
quantity_applicable char Quantity Applicable filters on the platform, writable, ::ancestor.::ancestor.quantity_applicable
referral_ledger_account_description varchar2 Referral Ledger Account Description filters on the platform, writable, ::ancestor.::ancestor.referral_ledger_account.description
referral_ledger_account_id int64 Referral Ledger Account ID filters on the platform, writable, ::ancestor.::ancestor.referral_ledger_account.id
value varchar2 Value writable, value
vat_account_id varchar2 VAT Account ID filters on the platform, writable, ::ancestor.::ancestor.vat.account_id
vat_amount decimal VAT Amount filters on the platform, writable, ::ancestor.::ancestor.vat.amount
vat_description varchar2 VAT Description filters on the platform, writable, ::ancestor.::ancestor.vat.description
vat_id int64 VAT ID filters on the platform, writable, ::ancestor.::ancestor.vat.id
vat_percentage decimal VAT Percentage filters on the platform, writable, ::ancestor.::ancestor.vat.percentage
vat_type varchar2 VAT Type filters on the platform, writable, ::ancestor.::ancestor.vat.type
year_budget decimal Year Budget filters on the platform, writable, ::ancestor.::ancestor.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