invantive documentation
Invantive Support ForumsLog In / Sign Up

SupplierPOBalancesByCode2: Visma.net Financials Supplier PO Balances by Code

read only REST

  • Catalog: VismaNet
  • Schema: Supplier
  • Label: Supplier PO Balances by Code

Get a specific supplier's PO balance

Can only retrieve data.

API Source

  • Endpoint: /v1/supplier/{supplierCd}/POBalance
  • Operation: get /v1/supplier/{supplierCd}/POBalance

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
supplierCd `` Indentifies the supplier for witch to return data

Table Columns

The columns of the table SupplierPOBalancesByCode2 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.
lastModifiedDateTime datetime Last Modified filters on the platform, writable, lastModifiedDateTime The date and time when the purchase order was last modified.
supplier_internalId int32 Supplier Internal ID filters on the platform, writable, supplier.internalId
supplier_name varchar2 Supplier Name filters on the platform, writable, supplier.name The name of the particular destination of the selected type.
supplier_number varchar2 Supplier Number filters on the platform, writable, supplier.number The identifier of the particular destination of the selected type.
totalClosedPOLineTotal double itgen_vnet_totalclosedpolinetotal filters on the platform, writable, totalClosedPOLineTotal The total closed amount of the order line
totalClosedPOOrderTotal double itgen_vnet_totalclosedpoordertotal filters on the platform, writable, totalClosedPOOrderTotal The total closed amount of the order
totalOpenPOLineTotal double itgen_vnet_totalopenpolinetotal filters on the platform, writable, totalOpenPOLineTotal The total open amount of the order line
totalOpenPOOrderTotal double itgen_vnet_totalopenpoordertotal filters on the platform, writable, totalOpenPOOrderTotal The total open amount of the order
totalPOOnHoldLineTotal double itgen_vnet_totalpoonholdlinetotal filters on the platform, writable, totalPOOnHoldLineTotal The total amount of the order line on hold
totalPOOnHoldOrderTotal double itgen_vnet_totalpoonholdordertotal filters on the platform, writable, totalPOOnHoldOrderTotal The total amount of order on hold

Release Notes

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