PurchaseReceiptLandedCostsV2ByReceiptNumber: Visma.net Financials itgen_vnet_purchasereceiptlandedcostsv2byreceiptnumber_plural
read only REST
- Catalog:
VismaNet - Schema:
PurchaseReceiptV2 - Label: itgen_vnet_purchasereceiptlandedcostsv2byreceiptnumber_plural
Get a specific Purchase Receipt Data for a single Purchase Receipt. The response headers include an ETag after a successful GET operation.
Can only retrieve data.
Summary
Data for a single Purchase Receipt.
The response headers include an ETag after a successful GET operation.
API Source
- Endpoint:
/v2/PurchaseReceipt/{receiptNumber} - Operation:
get /v2/PurchaseReceipt/{receiptNumber}
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 |
|---|---|---|---|---|
include |
`` | Optional parameter to request custom free fields. | ||
receipt |
`` | Identifies the Purchase Receipt |
Table Columns
The columns of the table PurchaseReceiptLandedCostsV2ByReceiptNumber 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_ |
varchar2 |
Company Code | writable | Partition code, segmenting the data. | |
COMPANY_ |
varchar2 |
Company Name | writable | Name of the partition. | |
amount |
double |
Amount | writable, amount |
Landed costs tab > Amount > A non-zero amount of the landed cost. | |
ap |
datetime |
itgen_vnet_apbilldate | writable, ap |
Landed costs tab > Purchase invoice date > The date of the purchase invoice for the landed cost. | |
ap |
varchar2 |
itgen_vnet_apdoctype | writable, ap |
Landed costs tab > Supplier document type > The type of the supplier document generated for the landed cost. | |
ap |
varchar2 |
itgen_vnet_aprefnbr | writable, ap |
Landed costs tab > Supplier ref. > The reference number of the supplier document generated for the landed cost. | |
branch |
varchar2 |
Branch Name | filters on the platform, writable, ::ancestor. |
Click the magnifier. > The name. | |
branch |
varchar2 |
Branch Number | filters on the platform, writable, ::ancestor. |
Click the magnifier. > The identifier. | |
control |
double |
itgen_vnet_controlqty | filters on the platform, writable, ::ancestor. |
The top part > Control qty. > The total quantity of goods on the receipt or return | |
control |
double |
Total for Control | filters on the platform, writable, ::ancestor. |
The top part > Control amt. > The total amount of the receipt or return, which you manually enter. | |
create |
char |
Create Bill | filters on the platform, writable, ::ancestor. |
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 |
varchar2 |
Currency | writable, currency |
Landed costs tab > Currency > The currency used for the landed cost. | |
currency_ |
varchar2 |
itgen_vnet_currency_2 | filters on the platform, writable, ::ancestor. |
The top part > Currency > The currency the supplier uses for invoicing. | |
custom |
datetime |
itgen_vnet_customdatetimeutc1 | filters on the platform, writable, ::ancestor. |
A free custom colum of type DateTime - in UTC timezone | |
custom |
double |
itgen_vnet_customdec1 | filters on the platform, writable, ::ancestor. |
A free custom colum of type decimal with max 4 decimals. | |
custom |
double |
itgen_vnet_customdec2 | filters on the platform, writable, ::ancestor. |
A free custom colum of type decimal with max 4 decimals. | |
custom |
int32 |
itgen_vnet_customint1 | filters on the platform, writable, ::ancestor. |
A free custom colum of type int | |
custom |
int32 |
itgen_vnet_customint2 | filters on the platform, writable, ::ancestor. |
A free custom colum of type int | |
custom |
varchar2 |
itgen_vnet_customstr1 | filters on the platform, writable, ::ancestor. |
A free custom colum of type string with max length 100. | |
custom |
varchar2 |
itgen_vnet_customstr2 | filters on the platform, writable, ::ancestor. |
A free custom colum of type string with max length 100. | |
custom |
varchar2 |
itgen_vnet_customstr3 | filters on the platform, writable, ::ancestor. |
A free custom colum of type string with max length 100. | |
custom |
varchar2 |
itgen_vnet_customstr4 | filters on the platform, writable, ::ancestor. |
A free custom colum of type string with max length 100. | |
custom |
varchar2 |
itgen_vnet_customstr5 | filters on the platform, writable, ::ancestor. |
A free custom colum of type string with max length 100. | |
date |
datetime |
Date | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Date* > The date when the receipt document was created. | |
description |
varchar2 |
Description | writable, description |
Mandatory field: Landed costs tab > Description* > The description of the landed cost code. | |
due |
datetime |
Due Date | filters on the platform, writable, ::ancestor. |
This value indicates the date the document is due | |
error |
varchar2 |
Error Message | filters on the platform, writable, ::ancestor. |
||
exchange |
double |
Exchange Rate | filters on the platform, writable, ::ancestor. |
||
hold |
char |
Hold | filters on the platform, writable, ::ancestor. |
The top part > Hold > A check box that indicates (if selected) that the document has the On hold status. | |
in |
varchar2 |
itgen_vnet_indoctype | writable, in |
Landed costs tab > Inventory doc. type > The type of the document generated in the Inventory workspace for this landed cost. | |
in |
varchar2 |
itgen_vnet_inrefnbr | writable, in |
Landed costs tab > Inventory ref. no. > The reference number of the document generated in the Inventory workspace for this landed cost. | |
inventory_ |
varchar2 |
Inventory Description | writable, inventory. |
Name of item/description | |
inventory_ |
varchar2 |
Inventory Number | writable, inventory. |
Number of item | |
landed |
varchar2 |
itgen_vnet_landedcostcode | writable, landed |
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. | |
last |
datetime |
Last Modified | filters on the platform, writable, ::ancestor. |
System generated information. | |
line |
int32 |
itgen_vnet_linenbr | writable, line |
Landed costs tab > Line number | |
location_ |
varchar2 |
Location Country ID | writable, location. |
Location*. | |
location_ |
varchar2 |
Location Country ID 2 | filters on the platform, writable, ::ancestor. |
Location*. | |
location_ |
varchar2 |
Location ID | writable, location. |
Click the magnifier > The identifier | |
location_ |
varchar2 |
Location ID 2 | filters on the platform, writable, ::ancestor. |
Click the magnifier > The identifier | |
location_ |
varchar2 |
Location Name | writable, location. |
Click the magnifier > The displayed name | |
location_ |
varchar2 |
Location Name 2 | filters on the platform, writable, ::ancestor. |
Click the magnifier > The displayed name | |
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, ::ancestor. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, ::ancestor. |
||
note |
varchar2 |
Note | filters on the platform, writable, ::ancestor. |
||
post |
varchar2 |
Post Period | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Post period* > The financial period to which the transactions recorded in the document should be posted. Format MMYYYY. | |
postpone |
char |
itgen_vnet_postponepurchaseinvoicecreation | writable, postpone |
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. | |
purchase |
varchar2 |
itgen_vnet_purchaseinvoicenbr | writable, purchase |
||
receipt |
varchar2 |
Receipt Number | filters on the platform, writable, ::ancestor. |
The top part > Receipt no. > The unique reference number of the purchase receipt. | |
receipt |
varchar2 |
Receipt Type | filters on the platform, writable, ::ancestor. |
The top part > Type > The type of the document, which can be one of the following options: Receipt, Return, Transfer receipt. | |
status |
varchar2 |
Status | filters on the platform, writable, ::ancestor. |
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 |
varchar2 |
Supplier Reference | filters on the platform, writable, ::ancestor. |
The top part > Supplier ref. > The reference number of the supplier document this receipt or return is based on. | |
supplier_ |
int32 |
Supplier Internal ID | writable, supplier. |
||
supplier_ |
int32 |
itgen_vnet_supplier_internalid_2 | filters on the platform, writable, ::ancestor. |
||
supplier_ |
varchar2 |
Supplier Name | writable, supplier. |
The name of the particular destination of the selected type. | |
supplier_ |
varchar2 |
itgen_vnet_supplier_name_2 | filters on the platform, writable, ::ancestor. |
The name of the particular destination of the selected type. | |
supplier_ |
varchar2 |
Supplier Number | writable, supplier. |
The identifier of the particular destination of the selected type. | |
supplier_ |
varchar2 |
itgen_vnet_supplier_number_2 | filters on the platform, writable, ::ancestor. |
The identifier of the particular destination of the selected type. | |
tax |
varchar2 |
itgen_vnet_taxcategory_description | writable, tax |
Name of item/description | |
tax |
varchar2 |
itgen_vnet_taxcategory_number | writable, tax |
Number of item | |
terms_ |
varchar2 |
Terms Description | writable, terms. |
Click on the magnifier. > The description. | |
terms_ |
varchar2 |
Terms ID | writable, terms. |
Click on the magnifier. > The identifier. | |
time |
blob |
Timestamp | filters on the platform, writable, ::ancestor. |
The top part > Tstamp > The timestamp of the purchase receipt. | |
total |
double |
Total Amount | filters on the platform, writable, ::ancestor. |
The top part > Total amt. > The total amount calculated for items received from or returned to the supplier. | |
total |
double |
Total Quantity | filters on the platform, writable, ::ancestor. |
The top part > Total qty. > The total quantity of items received from or returned to the supplier. | |
vat |
double |
VAT Exempt Total | filters on the platform, writable, ::ancestor. |
The top part > VAT exempt total > The document total that is exempt from VAT. | |
vat |
double |
VAT Taxable Total | filters on the platform, writable, ::ancestor. |
The top part > VAT taxable total > The document total that is subjected to VAT. | |
warehouse_ |
varchar2 |
Warehouse Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
warehouse_ |
varchar2 |
Warehouse ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: