invantive documentation
Invantive Support ForumsLog In / Sign Up

InvoicePaymentByNumber: Fortnox Invoice Payment by Number

read only REST

  • Catalog: Fortnox
  • Schema: InvoicePayments
  • Label: Invoice Payment by Number

Retrieve a single invoice payment

Can only retrieve data.

API Source

  • Endpoint: /3/invoicepayments/{Number}
  • Operation: get /3/invoicepayments/{Number}

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).
Number `` identifies the invoice payment
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 InvoicePaymentByNumber 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
InvoicePayment_Amount double Invoice Payment Amount filters on the platform, writable, InvoicePayment.Amount
InvoicePayment_AmountCurrency double Invoice Payment Amount Currency filters on the platform, writable, InvoicePayment.AmountCurrency
InvoicePayment_Booked char Invoice Payment Booked filters on the platform, writable, InvoicePayment.Booked
InvoicePayment_Currency varchar2(3) Invoice Payment Currency filters on the platform, writable, InvoicePayment.Currency
InvoicePayment_CurrencyRate double Invoice Payment Currency Rate filters on the platform, writable, InvoicePayment.CurrencyRate
InvoicePayment_CurrencyUnit double Invoice Payment Currency Unit filters on the platform, writable, InvoicePayment.CurrencyUnit
InvoicePayment_ExternalInvoiceReference1 varchar2 Invoice Payment External Invoice Reference 1 filters on the platform, writable, InvoicePayment.ExternalInvoiceReference1
InvoicePayment_ExternalInvoiceReference2 varchar2 Invoice Payment External Invoice Reference 2 filters on the platform, writable, InvoicePayment.ExternalInvoiceReference2
InvoicePayment_InvoiceCustomerName varchar2 Invoice Payment Invoice Customer Name filters on the platform, writable, InvoicePayment.InvoiceCustomerName
InvoicePayment_InvoiceCustomerNumber varchar2 Invoice Payment Invoice Customernumber filters on the platform, writable, InvoicePayment.InvoiceCustomerNumber
InvoicePayment_InvoiceDueDate datetime Invoice Payment Invoice Duedate filters on the platform, writable, InvoicePayment.InvoiceDueDate
InvoicePayment_InvoiceNumber int32 Invoice Payment Invoice Number filters on the platform, writable, InvoicePayment.InvoiceNumber
InvoicePayment_InvoiceOCR varchar2 Invoice Payment Invoice Ocr filters on the platform, writable, InvoicePayment.InvoiceOCR
InvoicePayment_InvoiceTotal varchar2 Invoice Payment Invoice Total filters on the platform, writable, InvoicePayment.InvoiceTotal
InvoicePayment_ModeOfPayment varchar2 Invoice Payment Mode of Payment filters on the platform, writable, InvoicePayment.ModeOfPayment
InvoicePayment_ModeOfPaymentAccount int32 Invoice Payment Mode of Payment Account filters on the platform, writable, InvoicePayment.ModeOfPaymentAccount
InvoicePayment_Number varchar2 Invoice Payment Number filters on the platform, writable, InvoicePayment.Number
InvoicePayment_PaymentDate datetime Invoice Payment Date filters on the platform, writable, InvoicePayment.PaymentDate
InvoicePayment_Source varchar2 Invoice Payment Source filters on the platform, writable, InvoicePayment.Source
InvoicePayment_VoucherNumber int32 Invoice Payment Voucher Number filters on the platform, writable, InvoicePayment.VoucherNumber
InvoicePayment_VoucherSeries varchar2 Invoice Payment Voucher Series filters on the platform, writable, InvoicePayment.VoucherSeries
InvoicePayment_VoucherYear int32 Invoice Payment Voucher Year filters on the platform, writable, InvoicePayment.VoucherYear
InvoicePayment__url varchar2 Invoice Payment URL filters on the platform, writable, InvoicePayment.@url

Release Notes

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