BasicPurchaseOrderTaxDetails: Visma.net Financials Basic Purchase Order Tax Details |
Get a range of Purchase Order - ScreenId=PO301000Request page size must be lower or equal to the allowed max page size which is returned as part of the metadata information.If requested page size is greater than allowed max page size, request will be limited to max page size
Catalog: VismaNet
Schema: PurchaseOrderBasic
Label: Basic Purchase Order Tax Details
This is a read-only table function. The Visma.net Financials API may not support changing the data or the Invantive UniversalSQL driver for Visma.net Financials does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Visma.net Financials API.
Parameters of Table Function
The following parameters can be used to control the behaviour of the table function BasicPurchaseOrderTaxDetails. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values.
Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.
Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.
Name |
Data Type |
Required |
Default Value |
Documentation |
|---|---|---|---|---|
branch |
string |
☐ |
|
Filter on Branch |
deliveryDate |
string |
☐ |
|
This value indicates the date the document is due for delivery. Use it to retrieve all records that have the delivery date since that time, up to the future.Accepted format:* ```yyyy-MM-dd```* ```yyyy-MM-dd HH:mm:ss```* ```yyyy-MM-dd HH:mm:ss.FFF```* ```yyyy-MM-ddTHH:mm:ss```* ```yyyy-MM-ddTHH:mm:ss.FFF```_Note:_ __DeliveryDate__ and __DeliveryDateCondition__ are __mutually inclusive__. |
deliveryDateCondition |
string |
☐ |
|
This value represents the condition to be applied to the Due Date when retrieving records.Accepted values (without the single quotes):* '>' for greater than* '<' for less than* '>=' for greater than or equal* '<=' for less than or equal_Note:_ __DeliveryDate__ and __DeliveryDateCondition__ are __mutually inclusive__. |
greaterThanValue |
string |
☐ |
|
Filter on order no. and forward |
includeCustomFreeFields |
boolean |
☐ |
|
Parameter to include custom free fields information in the result set, if true then custom free fields will be included in the result set |
lastModifiedDateTime |
string |
☐ |
|
This value, generated by the system, indicates the last time the record was modified. Use it to retrieve all records that have been modified since that time, up to the present.Accepted format:* ```yyyy-MM-dd```* ```yyyy-MM-dd HH:mm:ss```* ```yyyy-MM-dd HH:mm:ss.FFF```* ```yyyy-MM-ddTHH:mm:ss```* ```yyyy-MM-ddTHH:mm:ss.FFF```_Note:_ __LastModifiedDateTime__ and __LastModifiedDateTimeCondition__ are __mutually inclusive__. |
lastModifiedDateTimeCondition |
string |
☐ |
|
This value represents the condition to be applied when retrieving records.Accepted values (without the single quotes):* '>' for greater than* '<' for less than* '>=' for greater than or equal* '<=' for less than or equal_Note:_ __LastModifiedDateTime__ and __LastModifiedDateTimeCondition__ are __mutually inclusive__. |
orderDate |
string |
☐ |
|
This value indicates the order date. Use it to retrieve all records that have the order date since that time, up to the future.Accepted format:* ```yyyy-MM-dd```* ```yyyy-MM-dd HH:mm:ss```* ```yyyy-MM-dd HH:mm:ss.FFF```* ```yyyy-MM-ddTHH:mm:ss```* ```yyyy-MM-ddTHH:mm:ss.FFF```_Note:_ __OrderDate__ and __OrderDateCondition__ are __mutually inclusive__. |
orderDateCondition |
string |
☐ |
|
This value represents the condition to be applied to the order date when retrieving records.Accepted values (without the single quotes):* '>' for greater than* '<' for less than* '>=' for greater than or equal* '<=' for less than or equal_Note:_ __OrderDate__ and __OrderDateCondition__ are __mutually inclusive__. |
orderStatus |
string |
☐ |
|
Select and filter on Status. (Values: Balanced, Cancelled, Closed, Hold, Open, PendingEmail, PendingPrint, Printed, Voided) |
orderType |
string |
☐ |
|
Select and filter on Type. (Values: RegularOrder, DropShip, Blanket, StandardBlanket) |
supplier |
string |
☐ |
|
Filter on Supplier. |
Columns of Table Function
The columns of the table function BasicPurchaseOrderTaxDetails are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
branch_name |
string |
Branch Name |
☐ |
Click the magnifier. > The name. |
branch_number |
string |
Branch Number |
☐ |
Click the magnifier. > The identifier. |
COMPANY_CODE |
string(30) |
Company Code |
☑ |
Partition code, segmenting the data. |
COMPANY_NAME |
string(240) |
Company Name |
☑ |
Name of the partition. |
controlTotal |
double |
Total for Control |
☐ |
The top part > Control total > The order's total amount (including VAT), which you must enter manually when you attempt to save the order with the Balanced status. |
controlTotalInBaseCurrency |
double |
{res:itgen_vnet_controltotalinbasecurrency} |
☐ |
The top part > View base > A button that recalculates the Control total to your base currency if the amount on the purchase order is in another currency then base currency. When you click the button, the button toggles to View currency. |
currency |
string |
Currency |
☐ |
The top part > Currency > The currency the purchase order will be paid in. |
customDateTimeUTC1 |
datetime |
{res:itgen_vnet_customdatetimeutc1} |
☐ |
A free custom colum of type DateTime - in UTC timezone |
customDec1 |
double |
{res:itgen_vnet_customdec1} |
☐ |
A free custom colum of type decimal with max 4 decimals. |
customDec2 |
double |
{res:itgen_vnet_customdec2} |
☐ |
A free custom colum of type decimal with max 4 decimals. |
customInt1 |
int32 |
{res:itgen_vnet_customint1} |
☐ |
A free custom colum of type int |
customInt2 |
int32 |
{res:itgen_vnet_customint2} |
☐ |
A free custom colum of type int |
customStr1 |
string |
{res:itgen_vnet_customstr1} |
☐ |
A free custom colum of type string with max length 100. |
customStr2 |
string |
{res:itgen_vnet_customstr2} |
☐ |
A free custom colum of type string with max length 100. |
customStr3 |
string |
{res:itgen_vnet_customstr3} |
☐ |
A free custom colum of type string with max length 100. |
customStr4 |
string |
{res:itgen_vnet_customstr4} |
☐ |
A free custom colum of type string with max length 100. |
customStr5 |
string |
{res:itgen_vnet_customstr5} |
☐ |
A free custom colum of type string with max length 100. |
date |
datetime |
Date |
☐ |
Mandatory field: The top part > Date* > The date when the purchase order was created. |
description |
string |
Description |
☐ |
The top part > Description > A brief description of the purchase order. |
errorInfo |
string |
Error Message |
☐ |
|
exchangeRate |
double |
Exchange Rate |
☐ |
|
hold |
boolean |
Hold |
☐ |
The top part > Hold > A check box that you select to give the purchase order the On hold status. |
lastModifiedDateTime |
datetime |
Last Modified |
☐ |
System generated information. |
lineTotal |
double |
Line Total |
☐ |
The top part > Line total > The total sum of the Extended amount entries for all lines in the current purchase order. This value is calculated by the system and users cannot manually change it. |
lineTotalInBaseCurrency |
double |
{res:itgen_vnet_linetotalinbasecurrency} |
☐ |
The top part > View base > A button that recalculates the Line total to your base currency if the amount on the purchase order is in another currency then base currency. When you click the button, the button toggles to View currency. |
location_id |
int32 |
Location ID |
☐ |
Click the magnifier > The identifier |
location_name |
string |
Location Name |
☐ |
Click the magnifier > The displayed name |
metadata_maxPageSize |
int64 |
Metadata Max Pagesize |
☐ |
|
metadata_totalCount |
int64 |
Total Count |
☐ |
|
note |
string |
Note |
☐ |
Icon Notes on top of the window > Pop-up window for providing any user-defined text connected to the document. |
orderNbr |
string |
Order Number |
☐ |
The top part > Order no. > The unique reference number of the purchase order, which the system assigns based on the number series assigned to purchase orders of this type, as specified in the PO101000 window. |
orderTotal |
double |
Order Total |
☐ |
The Top part > Order total > The total sum for the purchase order, including VAT. This read-only value is the sum of the Line total and VAT total values. |
orderTotalInBaseCurrency |
double |
{res:itgen_vnet_ordertotalinbasecurrency} |
☐ |
The top part > View base > A button that recalculates the Order total to your base currency if the amount on the purchase order is in another currency then base currency. When you click the button, the button toggles to View currency. |
orderType |
string |
Order Type |
☐ |
The top part > Type > The type of the purchase order, which can be one of these options: Normal, Drop-ship, Blanket, Default |
owner_id |
guid |
Owner ID |
☐ |
Click the magnifier > The identifier |
owner_name |
string |
Owner Name |
☐ |
Click the magnifier > The displayed name |
promisedOn |
datetime |
Promised on |
☐ |
The top part > Delivery date > The date when the supplier promised that the items listed in the order will be received at their destination location. |
recordId |
int32 |
Record ID |
☐ |
The id as stored in the database. It can be used when we want to update a VAT record. |
status |
string |
Status |
☐ |
The top part > Status > The system-generated status of the purchase order, which can be one of the following options: On hold, Open, Pending approval, Rejected, Pending printing, Pending e-mail, Closed, Cancelled. |
supplier_internalId |
int32 |
Supplier Internal ID |
☐ |
|
supplier_name |
string |
Supplier Name |
☐ |
The name of the particular destination of the selected type. |
supplier_number |
string |
Supplier Number |
☐ |
The identifier of the particular destination of the selected type. |
supplierRef |
string |
Supplier Reference |
☐ |
The top part > Supplier ref. > The reference number of the supplier document related to this purchase order. |
taxableAmount |
double |
Taxable Amount |
☐ |
Taxable amount > The taxable amount for the VAT, which is calculated at the document level. |
taxId |
string |
Tax ID |
☐ |
Mandatory field: VAT ID* > The ID of the VAT applied to the document. |
taxTotal |
double |
Tax Total |
☐ |
The Top part > VAT total > The total VAT amount for all lines added to the current purchase order. This value, also calculated by the system, is the sum of the VAT amounts for each line. |
taxTotalInBaseCurrency |
double |
{res:itgen_vnet_taxtotalinbasecurrency} |
☐ |
The top part > View base > A button that recalculates the VAT total to your base currency if the amount on the purchase order is in another currency then base currency. When you click the button, the button toggles to View currency. |
timeStamp |
byte[] |
Timestamp |
☐ |
|
vatAmount |
double |
VAT Amount |
☐ |
VAT > The VAT amount for the specific VAT, which is calculated at the document level. |
vatExemptTotal |
double |
VAT Exempt Total |
☐ |
The Top part > VAT exempt total > The document total that is exempt from VAT. This total is calculated as the taxable amount for the VAT with the Include in VAT exempt total check box selected in the TX205000 window. |
vatExemptTotalInBaseCurrency |
double |
{res:itgen_vnet_vatexempttotalinbasecurrency} |
☐ |
The top part > View base > A button that recalculates the VAT exempt total to your base currency if the amount on the purchase order is in another currency then base currency. When you click the button, the button toggles to View currency. |
vatId_description |
string |
{res:itgen_vnet_vatid_description} |
☐ |
Name of item/description |
vatId_number |
string |
{res:itgen_vnet_vatid_number} |
☐ |
Number of item |
vatRate |
double |
VAT Rate |
☐ |
VAT rate > The rate of the VAT. |
23-06-2025 19:16 Version 24.1.116-BETA+5455
Visma.net Financials API Data Model