Visma.net Financials Data Model

Zoom Window Out
Larger Text | Smaller Text
Hide Page Header
Show Expanding Text
Print Topic
Send Mail Feedback
Share This Topic
Save Permalink URL

Navigation: Schema: PurchaseReceipt > Tables

PurchaseReceiptLandedCostsBasicByReceiptNumber

Get a specific Purchase Receipt

Catalog: VismaNet

Schema: PurchaseReceipt

The data in this table is partitioned per value of the COMPANY_CODE column.

This is a read-only table function. The Visma.net API may not support changing the data or the Invantive SQL driver for Visma.net does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Visma.net API.

Select Visma.net API URL: /controller/api/v1/PurchaseReceipt/{receiptNbr}

Insert Visma.net API URL: /controller/api/v1/PurchaseReceipt/{receiptNbr}

Update Visma.net API URL: /controller/api/v1/PurchaseReceipt/{receiptNbr}

Delete Visma.net API URL: /controller/api/v1/PurchaseReceipt/{receiptNbr}

Field Selection Method: NotRequired

Base Path: landedCost[*]

Select Visma.net API Operation: get /controller/api/v1/PurchaseReceipt/{receiptNbr}

Table Function Parameters

The following parameters can be used to control the behaviour of the table function PurchaseReceiptLandedCostsBasicByReceiptNumber. 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 treated using their default values.

Value specification by position is done by listing all values from the first to the last needed value. For example with `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
COMPANY_CODE	string	☐		Partition to retrieve data from.
receiptNbr	string	☑		Identifies the Purchase Receipt

Table Function Columns

The columns of the table function PurchaseReceiptLandedCostsBasicByReceiptNumber are shown below. Each column has an SQL data type.

Name	Data Type	Label	Required	Documentation
amount	double	Amount	☐	Landed costs tab > Amount > A non-zero amount of the landed cost.
apBillDate	datetime		☐	Landed costs tab > Purchase invoice date > The date of the purchase invoice for the landed cost.
apDocType	string		☐	Landed costs tab > Supplier document type > The type of the supplier document generated for the landed cost.
apRefNbr	string		☐	Landed costs tab > Supplier ref. > The reference number of the supplier document generated for the landed cost.
branchNumber_name	string	Branch Name	☐	Click the magnifier. > The name.
branchNumber_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.
controlQty	double		☐	The top part > Control qty. > The total quantity of goods on the receipt or return
controlTotal	double	Total for Control	☐	The top part > Control amt. > The total amount of the receipt or return, which you manually enter.
createBill	boolean	Create Bill	☐	The top part > Create invoice > A check box that you select if the system must create an appropriate invoice (or adjustment) automatically when the purchase receipt is released.
currency	string	Currency	☐	Landed costs tab > Currency > The currency used for the landed cost.
currency_1	string		☐	The top part > Currency > The currency the supplier uses for invoicing.
date	datetime	Date	☐	Mandatory field: The top part > Date* > The date when the receipt document was created.
description	string	Description	☐	Mandatory field: Landed costs tab > Description* > The description of the landed cost code.
errorInfo	string	Error Message	☐
exchangeRate	double	Exchange Rate	☐
hold	boolean	Hold	☐	The top part > Hold > A check box that indicates (if selected) that the document has the On hold status.
inDocType	string		☐	Landed costs tab > Inventory doc. type > The type of the document generated in the Inventory workspace for this landed cost.
inRefNbr	string		☐	Landed costs tab > Inventory ref. no. > The reference number of the document generated in the Inventory workspace for this landed cost.
inventory_description	string	Inventory Description	☐	Name of item/description
inventory_number	string	Inventory Number	☐	Number of item
landedCostCode	string		☐	Mandatory field: Landed costs tab > Landed costs* > Landed cost code > The landed cost code associated with the landed costs incurred for this purchase or transfer receipt.
lastModifiedDateTime	datetime	Last Modified	☐	System generated information.
lineNbr	int32		☐	Landed costs tab > Line number
location_countryId	string	Location Country ID	☐	Location*.
location_countryId_1	string		☐	Location*.
location_id	string	Location ID	☐	Click the magnifier > The identifier
location_id_1	string		☐	Click the magnifier > The identifier
location_name	string	Location Name	☐	Click the magnifier > The displayed name
location_name_1	string		☐	Click the magnifier > The displayed name
metadata_maxPageSize	int64		☐
metadata_totalCount	int64	Total Count	☐
postPeriod	string	Post Period	☐	Mandatory field: The top part > Post period* > The financial period to which the transactions recorded in the document should be posted. Format MMYYYY.
postponePurchaseInvoiceCreation	boolean		☐	Landed costs tab > Postpone creation of purchase invoice > A check box that indicates (if selected) that a related supplier ledger invoice for the incurred landed costs must be created later.
purchaseInvoiceNbr	string		☐
receiptNbr	string	Receipt Number	☐	The top part > Receipt no. > The unique reference number of the purchase receipt.
receiptType	string	Receipt Type	☐	The top part > Type > The type of the document, which can be one of the following options: Receipt, Return, Transfer receipt.
status	string	Status	☐	The top part > Status > The current status of the purchase or transfer receipt, or return, which the system assigns automatically. On hold, Balanced, Released.
supplier_internalId	int32	Supplier Internal ID	☐
supplier_internalId_1	int32		☐
supplier_name	string	Supplier Name	☐	The name of the particular destination of the selected type.
supplier_name_1	string		☐	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.
supplier_number_1	string		☐	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 this receipt or return is based on.
taxCategory_description	string		☐	Name of item/description
taxCategory_number	string		☐	Number of item
terms_description	string	Terms Description	☐	Click on the magnifier. > The description.
terms_id	string	Terms ID	☐	Click on the magnifier. > The identifier.
totalAmt	double		☐	The top part > Total amt. > The total amount calculated for items received from or returned to the supplier.
totalQty	double		☐	The top part > Total qty. > The total quantity of items received from or returned to the supplier.
vatExemptTotal	double	VAT Exempt Total	☐	The top part > VAT exempt total > The document total that is exempt from VAT.
vatTaxableTotal	double	VAT Taxable Total	☐	The top part > VAT taxable total > The document total that is subjected to VAT.
warehouse_description	string	Warehouse Description	☐	Click on the magnifier. > The description.
warehouse_id	string	Warehouse ID	☐	Click on the magnifier. > The identifier.

12-12-2020 18:42 Version 20.1.301-BETA+3023

Please enable JavaScript to view this site.

Visma.net Financials Data Model

Table Function Parameters

Table Function Columns