invantive documentation
Invantive Support ForumsLog In / Sign Up

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_code `` Partition to retrieve data from.
number_of_fiscal_years `` 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_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) | 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_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 int64 ID 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
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