invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

RecurringDeviationLinesById: Fortnox itgen_fnx_recurringdeviationlinesbyid_plural

read only REST

  • Catalogus: Fortnox
  • Schema: RecurringBillingDeviations
  • Label: itgen_fnx_recurringdeviationlinesbyid_plural

Get a deviation by ID Returns a single deviation for a recurring, including its rows and any accrual override.

Kan alleen gegevens ophalen.

Samenvatting

Returns a single deviation for a recurring, including its rows and any accrual override.

API-bron

  • Eindpunt: /api/recurring-billing/recurrings-v1/{recurring-id}/deviations/{deviation-id}
  • Operatie: get /api/recurring-billing/recurrings-v1/{recurring-id}/deviations/{deviation-id}

Prestatiekenmerken

Characteristic Value
Gemiddelde toegangsvertraging (ms) 356
Aantal rijen per minuut bij volledige scan 85,000
Aantal rijen per minuut in een Query 168

Het resultaat kan op de client in de Cache worden opgeslagen.

Parameters

Name Datatype Required Default Documentation
deviation-id `` The unique identifier of the deviation.
financialyear `` Selects what financial year that should be used (does not work on every table).
financialyeardate `` Selects by date, what financial year that should be used (does not work on every table).
fromdate `` Defines a selection based on a start date.Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table).
lastmodified `` Retrieves all records since the provided timestamp (does not work on every table).
recurring-id `` The unique identifier of the recurring contract.
todate `` Defines a selection based on an end date.Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table).

Tabelkolommen

De kolommen van de tabel RecurringDeviationLinesById worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
account_number int64 Rekeningnummer writable, account_number General ledger account the row revenue is booked to.
accrual_created_at datetime itgen_fnx_accrual_created_at filters on the platform, writable, ::ancestor.accrual.created_at Timestamp when the accrual was created.Read-only.
accrual_id guid itgen_fnx_accrual_id filters on the platform, writable, ::ancestor.accrual.id Server-generated unique identifier of the accrual.
accrual_modified_at datetime itgen_fnx_accrual_modified_at filters on the platform, writable, ::ancestor.accrual.modified_at Timestamp when the accrual was last modified.Read-only.
accrual_recurring_id guid itgen_fnx_accrual_recurring_id filters on the platform, writable, ::ancestor.accrual.recurring_id Identifier of the recurring this accrual belongs to.Read-only.
article_id varchar2 itgen_fnx_article_id writable, article_id Reference to an article in the article register.When set, article defaults (price, account, unit) may be applied.
cost_center_id varchar2 itgen_fnx_cost_center_id writable, cost_center_id Identifier of the cost center this row is booked against.Overrides the recurring-level cost center.
created_at datetime itgen_fnx_created_at writable, created_at Timestamp when the deviation row was created.Read-only.
created_at_2 datetime itgen_fnx_created_at_2 filters on the platform, writable, ::ancestor.created_at Timestamp when the deviation was created.Read-only.
description varchar2 Description writable, description Text describing the row, printed on the invoice.
deviation_id guid itgen_fnx_deviation_id writable, deviation_id Identifier of the deviation this row belongs to.Read-only.
deviation_type varchar2 itgen_fnx_deviation_type filters on the platform, writable, ::ancestor.deviation_type
discount double Discount writable, discount Discount applied to the row, interpreted according to discount_type.
discount_type varchar2 itgen_fnx_discount_type writable, discount_type
id guid ID writable, id Server-generated unique identifier of the deviation row.
id_2 guid ID filters on the platform, writable, ::ancestor.id Server-generated unique identifier of the deviation.
modified_at datetime itgen_fnx_modified_at writable, modified_at Timestamp when the deviation row was last modified.Read-only.
modified_at_2 datetime itgen_fnx_modified_at_2 filters on the platform, writable, ::ancestor.modified_at Timestamp when the deviation was last modified.Read-only.
price double Price writable, price Unit price before discount and VAT.
project_id varchar2 Project ID writable, project_id Identifier of the project this row is booked against.Overrides the recurring-level project.
quantity double Quantity writable, quantity Number of units invoiced for this row.
recurring_id guid itgen_fnx_recurring_id writable, recurring_id Identifier of the recurring the deviation belongs to.Read-only.
recurring_id_2 guid itgen_fnx_recurring_id_2 filters on the platform, writable, ::ancestor.recurring_id Identifier of the recurring this deviation belongs to.Read-only.
repeat_interval int64 itgen_fnx_repeat_interval filters on the platform, writable, ::ancestor.repeat_interval When set, the SKIP deviation repeats every this many invoices starting from target_invoice_index.Only applies to SKIP deviations.
row_index int64 itgen_fnx_row_index writable, row_index Zero-based position of the row within the recurring's row list, determining print order.
source_recurring_row_id guid itgen_fnx_source_recurring_row_id writable, source_recurring_row_id Identifier of the recurring row this deviation row was derived from, when applicable.
target_invoice_index int64 itgen_fnx_target_invoice_index filters on the platform, writable, ::ancestor.target_invoice_index Zero-based index of the invoice occurrence in the recurring's sequence that the deviation applies to.
totals_excl_vat double itgen_fnx_totals_excl_vat writable, totals.excl_vat Row amount excluding VAT.
totals_incl_vat double itgen_fnx_totals_incl_vat writable, totals.incl_vat Row amount including VAT.
totals_vat double itgen_fnx_totals_vat writable, totals.vat Row VAT amount.
type varchar2 Type writable, type
unit varchar2 Unit writable, unit Unit of measure for the quantity (e.g."hour", "pcs").
vat_percentage double itgen_fnx_vat_percentage writable, vat_percentage VAT rate applied to the row, as a percentage.Typically one of 0, 6, 12 or 25.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: