invantive documentation
Invantive Support ForumsLog In / Sign Up

RecurringDeviationAccrualLinesById: Fortnox itgen_fnx_recurringdeviationaccruallinesbyid_plural

read only REST

  • Catalog: Fortnox
  • Schema: RecurringBillingDeviations
  • Label: itgen_fnx_recurringdeviationaccruallinesbyid_plural

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

Can only retrieve data.

Summary

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

API Source

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

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
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).

Table Columns

The columns of the table RecurringDeviationAccrualLinesById 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
account_number int64 Account Number writable, account_number General ledger account this accrual distribution row books to.
accrual_account_number int64 itgen_fnx_accrual_account_number writable, ::ancestor.accrual_account_number General ledger account holding the deferred (not yet recognised) revenue.
accrual_id guid itgen_fnx_accrual_id writable, accrual_id Identifier of the accrual this row belongs to. Read-only.
amount decimal Amount writable, ::ancestor.amount Total amount to be periodised (accrued) across accounting periods.
cost_center_id varchar2 itgen_fnx_cost_center_id writable, cost_center_id Identifier of the cost center this distribution row is booked against.
created_at datetime itgen_fnx_created_at writable, created_at Timestamp when the accrual row was created. Read-only.
created_at_2 datetime itgen_fnx_created_at_2 writable, ::ancestor.created_at Timestamp when the accrual was created. Read-only.
created_at_3 datetime itgen_fnx_created_at_3 filters on the platform, writable, ::ancestor.::ancestor.created_at Timestamp when the deviation was created. Read-only.
credit decimal Credit writable, credit Credit amount booked for this distribution row.
debit decimal Debit writable, debit Debit amount booked for this distribution row.
deviation_type varchar2 itgen_fnx_deviation_type filters on the platform, writable, ::ancestor.::ancestor.deviation_type
id guid ID writable, id Server-generated unique identifier of the accrual row.
id_2 guid ID writable, ::ancestor.id Server-generated unique identifier of the accrual.
id_3 guid itgen_fnx_id_3 filters on the platform, writable, ::ancestor.::ancestor.id Server-generated unique identifier of the deviation.
modified_at datetime itgen_fnx_modified_at writable, modified_at Timestamp when the accrual row was last modified. Read-only.
modified_at_2 datetime itgen_fnx_modified_at_2 writable, ::ancestor.modified_at Timestamp when the accrual was last modified. Read-only.
modified_at_3 datetime itgen_fnx_modified_at_3 filters on the platform, writable, ::ancestor.::ancestor.modified_at Timestamp when the deviation was last modified. Read-only.
project_id varchar2 Project ID writable, project_id Identifier of the project this distribution row is booked against.
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.
transaction_info varchar2 itgen_fnx_transaction_info writable, transaction_info Free-text transaction information attached to the bookkeeping entry.
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: