invantive documentation
Invantive Support ForumsLog In / Sign Up

RecurringDeviationAccrualLinesByRecurringId: Fortnox itgen_fnx_recurringdeviationaccruallinesbyrecurringid_plural

read only REST

  • Catalog: Fortnox
  • Schema: RecurringBillingDeviations
  • Label: itgen_fnx_recurringdeviationaccruallinesbyrecurringid_plural

List all deviations for a recurring Returns the deviations defined for a recurring. A deviation overrides the normal invoicing for one or more occurrences of the recurring — either changing the rows (ROWS) or skipping the invoice entirely (SKIP).

Can only retrieve data.

Summary

Returns the deviations defined for a recurring. A deviation overrides the normal invoicing for one or more occurrences of the recurring — either changing the rows (ROWS) or skipping the invoice entirely (SKIP).

API Source

  • Endpoint: /api/recurring-billing/recurrings-v1/{recurring-id}/deviations
  • Operation: get /api/recurring-billing/recurrings-v1/{recurring-id}/deviations

Performance Characteristics

Characteristic Value
Average access latency (ms) 356
Full scan rows per minute 85,000
Point query rows per minute 168

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
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).

Table Columns

The columns of the table RecurringDeviationAccrualLinesByRecurringId 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
accrual_account_number int64 itgen_fnx_accrual_account_number writable, ::ancestor.accrual_account_number General ledger account holding the deferred (not yet recognised) revenue.
amount decimal Amount writable, ::ancestor.amount Total amount to be periodised (accrued) across accounting periods.
created_at datetime itgen_fnx_created_at writable, ::ancestor.created_at Timestamp when the accrual was created. Read-only.
created_at_2 datetime itgen_fnx_created_at_2 filters on the platform, writable, ::ancestor.::ancestor.created_at Timestamp when the deviation was created. Read-only.
deviation_type varchar2 itgen_fnx_deviation_type filters on the platform, writable, ::ancestor.::ancestor.deviation_type
id guid ID writable, ::ancestor.id Server-generated unique identifier of the accrual.
id_2 guid ID filters on the platform, writable, ::ancestor.::ancestor.id Server-generated unique identifier of the deviation.
modified_at datetime itgen_fnx_modified_at writable, ::ancestor.modified_at Timestamp when the accrual was last modified. Read-only.
modified_at_2 datetime itgen_fnx_modified_at_2 filters on the platform, writable, ::ancestor.::ancestor.modified_at Timestamp when the deviation was last modified. Read-only.
recurring_id guid itgen_fnx_recurring_id writable, ::ancestor.recurring_id Identifier of the recurring this accrual belongs to. Read-only.
recurring_id_2 guid itgen_fnx_recurring_id_2 filters on the platform, writable, ::ancestor.::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.::ancestor.repeat_interval When set, the SKIP deviation repeats every this many invoices starting from target_invoice_index. Only applies to SKIP deviations.
revenue_account_number int64 itgen_fnx_revenue_account_number writable, ::ancestor.revenue_account_number General ledger account the revenue is recognised to as each period is released.
target_invoice_index int64 itgen_fnx_target_invoice_index filters on the platform, writable, ::ancestor.::ancestor.target_invoice_index Zero-based index of the invoice occurrence in the recurring's sequence that the deviation applies to.
vat_option varchar2 itgen_fnx_vat_option writable, ::ancestor.vat_option

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: