invantive documentation
Invantive Support ForumsLog In / Sign Up

CustomerInvoiceRotRutDistributionByRefNumber: Visma.net Financials Customer Invoice ROTRUT Distribution by Reference Number

read only REST

  • Catalog: VismaNet
  • Schema: CustomerInvoice
  • Label: Customer Invoice ROTRUT Distribution by Reference Number

Get Rot Rut informations for a Customer Invoice Data for the Rot Rut

Can only retrieve data.

Summary

Data for the Rot Rut

API Source

  • Endpoint: /v1/customerinvoice/{refNbr}/rotrut
  • Operation: get /v1/customerinvoice/{refNbr}/rotrut

Performance Characteristics

Characteristic Value
Average access latency (ms) 155
Full scan rows per minute 29,100
Point query rows per minute 387

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
refNbr `` Identify the customer invoice for which to return data

Table Columns

The columns of the table CustomerInvoiceRotRutDistributionByRefNumber 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
COMPANY_CODE varchar2(30) Company Code writable Partition code, segmenting the data.
COMPANY_NAME varchar2(240) Company Name writable Name of the partition.
amount double Amount writable, amount
appartment varchar2 itgen_vnet_appartment filters on the platform, writable, ::ancestor.appartment
distributedAmount double Distributed Amount filters on the platform, writable, ::ancestor.distributedAmount
distributedAutomaticaly char itgen_vnet_distributedautomaticaly filters on the platform, writable, ::ancestor.distributedAutomaticaly
docType varchar2 Document Type filters on the platform, writable, ::ancestor.docType
estate varchar2 Estate filters on the platform, writable, ::ancestor.estate
extra char Extra writable, extra
lineNbr int32 itgen_vnet_linenbr writable, lineNbr
materialCost double itgen_vnet_materialcost filters on the platform, writable, ::ancestor.materialCost
organizationNbr varchar2 Organisation Number filters on the platform, writable, ::ancestor.organizationNbr
otherCost double Other Cost filters on the platform, writable, ::ancestor.otherCost
personalId varchar2 Personal ID writable, personalId
refNbr varchar2 Reference Number filters on the platform, writable, ::ancestor.refNbr
totalDeductableAmount double itgen_vnet_totaldeductableamount filters on the platform, writable, ::ancestor.totalDeductableAmount
type varchar2 Type filters on the platform, writable, ::ancestor.type
workPrice double Work Price filters on the platform, writable, ::ancestor.workPrice

Release Notes

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