SupplierInvoiceLinesByTypeDocumentTypeInvoiceNumber: Visma.net Financials Supplier Invoice Lines by Type Document Type Invoice Number
read only REST
- Catalog:
VismaNet - Schema:
SupplierInvoice - Label: Supplier Invoice Lines by Type Document Type Invoice Number
Get a specific Invoice, DebitAdj, CreditAdj or Prepayment Data for a single invoice. The response headers include an ETag after a successful GET operation.
Can only retrieve data.
Summary
Data for a single invoice.
The response headers include an ETag after a successful GET operation.
API Source
- Endpoint:
/v1/supplierInvoice/{documentType}/{invoiceNumber} - Operation:
get /v1/supplierInvoice/{documentType}/{invoiceNumber}
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 |
|---|---|---|---|---|
document |
`` | Identifies the Invoice | ||
expand |
`` | Expland landed costs information. | ||
expand |
`` | Expland line-level pre-booking account and sub-account information. | ||
invoice |
`` | Identifies the Invoice |
Table Columns
The columns of the table SupplierInvoiceLinesByTypeDocumentTypeInvoiceNumber 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. | |
account_ |
char |
Account Active | writable, account. |
||
account_ |
varchar2 |
Account Description | writable, account. |
Name of item/description | |
account_ |
varchar2 |
Account External Code 1 | writable, account. |
Account class > The identifier of the account class. | |
account_ |
varchar2 |
Account External Code 2 | writable, account. |
Account class > The name of the account class. | |
account_ |
varchar2 |
Account Number | writable, account. |
Number of item | |
account_ |
varchar2 |
Account Type | writable, account. |
Account > The account number. | |
amount |
double |
Amount | filters on the platform, writable, ::ancestor. |
The Top part > Amount > The amount to be paid for the document. Equal to the amount (or to the sum of amounts) shown in the Amount column of the Document details tab. | |
approval |
varchar2 |
Approval Details Attachment ID | filters on the platform, writable, ::ancestor. |
The Approval details tab > Default document > The default document that includes the payments requiring approval. | |
approval |
varchar2 |
Approval Details Comment | filters on the platform, writable, ::ancestor. |
The Approval details tab > Comment > The comment connected with the approval of the payments. | |
approval |
varchar2 |
Approval Status | filters on the platform, writable, ::ancestor. |
The Top part > Approval status > The status of the document in Visma.net Approval. [New, Canceled, SentToApproval, ReceivedByApproval, InProgressApproval, RejectedInApproval, ApprovedInApproval, ActiveWorkflowApproval. | |
balance |
double |
Balance | filters on the platform, writable, ::ancestor. |
The Top part > Balance > The balance of the supplier ledger document after VAT (if inclusive) and the discount as specified in the tabs below. | |
balance |
double |
Balance in Currency | filters on the platform, writable, ::ancestor. |
Background calculation giving you the Balance in your default currency. This field is applicable if the amount is given in another currency than your default. | |
branch |
varchar2 |
Branch Name | writable, branch |
Click the magnifier. > The name. | |
branch |
varchar2 |
Branch Number Name 2 | filters on the platform, writable, ::ancestor. |
Click the magnifier. > The name. | |
branch |
varchar2 |
Branch Number | writable, branch |
Click the magnifier. > The identifier. | |
branch |
varchar2 |
Branch Number 2 | filters on the platform, writable, ::ancestor. |
Click the magnifier. > The identifier. | |
buyer |
varchar2 |
Buyer Reference | filters on the platform, writable, ::ancestor. |
The Top part > Supplier ref. > The document's original reference number as assigned by the supplier (for informational purposes). | |
cash |
varchar2 |
Cash Account | filters on the platform, writable, ::ancestor. |
Financial details tab > The payment information section > Cash account > The cash account associated with the payment method. | |
cash |
double |
Cash Discount | filters on the platform, writable, ::ancestor. |
The Top part > Cash discount > The cash discount amount that has been or will be taken in the document, which the system calculates based in the specified credit terms. | |
cash |
datetime |
Cash Discount Date | filters on the platform, writable, ::ancestor. |
The Top part > Cash discount date > The end date of the cash discount period, which the system calculates by using the supplier's credit terms. | |
cash |
double |
Cash Discount in Currency | filters on the platform, writable, ::ancestor. |
Background calculation giving you the Cash discount in your default currency. This field is applicable if the amount is given in another currency than your default. | |
closed |
varchar2 |
Closed Financial Period | filters on the platform, writable, ::ancestor. |
Format YYYYMM. | |
cost |
double |
Cost | writable, cost |
The table > Cost > The unit cost of the item or service received from the supplier. | |
cost |
double |
itgen_vnet_costincurrency | writable, cost |
Background calculation giving you the Cost in the selected currency.This field is applicable if the amount is given in a another currency than your default. | |
created |
datetime |
Created | filters on the platform, writable, ::ancestor. |
||
credit |
varchar2 |
Credit Terms Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
credit |
varchar2 |
Credit Terms ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
currency |
varchar2 |
Currency ID | filters on the platform, writable, ::ancestor. |
The Top part > Currency > The currency of the document. | |
cury |
double |
itgen_vnet_curyretainageamt | writable, cury |
||
cury |
double |
itgen_vnet_curyretainagetotal | filters on the platform, writable, ::ancestor. |
||
cury |
double |
itgen_vnet_curyretainageunreleasedamt | filters on the platform, writable, ::ancestor. |
||
date |
datetime |
Date | filters on the platform, writable, ::ancestor. |
The Top part > Date* > The date of the original supplier ledger document; by default, it is the current date, which can be changed. | |
deferral |
varchar2 |
itgen_vnet_deferralcode | writable, deferral |
The table > Deferral code > The deferral code assigned to the stock item or non-stock item specified in this document line. | |
deferral |
int32 |
itgen_vnet_deferralschedule | writable, deferral |
The table > Original deferral schedule > A read-only column filled in by the system in the Debit adjustment documents created by the reversing process.It shows the ID of the deferral schedule associated with the original document (such as a purchase invoice). | |
deferral |
varchar2 |
itgen_vnet_deferralschedulenbr | writable, deferral |
The public CD/Code of the deferral schedule visible to user | |
description |
varchar2 |
Description | filters on the platform, writable, ::ancestor. |
The Top part > Description > A user-provided description for this supplier ledger document. | |
detail |
double |
Detail Total | filters on the platform, writable, ::ancestor. |
The Top part > Detail total > The document total as specified in the Document details tab. | |
detail |
double |
Detail Total in Currency | filters on the platform, writable, ::ancestor. |
Background calculation giving you the Detail total in your default currency. This field is applicable if the amount is given in another currency than your default. | |
discount |
double |
itgen_vnet_discountamount | writable, discount |
The table > Discount amount > The amount of the line-level discount that has been applied manually or automatically to this line. | |
discount |
double |
itgen_vnet_discountamountincurrency | writable, discount |
Background calculation giving you the Discount amount in the selected currency.This field is applicable if the amount is given in a another currency than your default. | |
discount |
double |
Discount Percent | writable, discount |
The table > Discount percent > The percent of the line-level discount that has been applied manually or automatically. | |
discount |
double |
Discount Total | filters on the platform, writable, ::ancestor. |
The Top part > Discount total > The discount total calculated for the document. This total includes discounts of the Group and Document levels. | |
discount |
double |
Discount Total in Currency | filters on the platform, writable, ::ancestor. |
Background calculation giving you the Discount total in your default currency. This field is applicable if the amount is given in another currency than your default. | |
discount |
double |
itgen_vnet_discountunitcost | writable, discount |
Background calculation giving you the Discount unit cost in the default currency. | |
discount |
double |
itgen_vnet_discountunitcostincurrency | writable, discount |
Background calculation giving you the Discount unit cost in the selected currency.This field is applicable if the amount is given in a another currency than your default. | |
document |
varchar2 |
Document Type | filters on the platform, writable, ::ancestor. |
The top part > Top part > Type > The type of the document. The following types are available: Purchase invoice, credit adjustment, purchase credit note, prepayment. | |
document |
int64 |
itgen_vnet_documentversionnumber | filters on the platform, writable, ::ancestor. |
||
due |
datetime |
Due Date | filters on the platform, writable, ::ancestor. |
The Top part > Due date* > The date when payment for the document is due in accordance with the supplier's credit terms. | |
error |
varchar2 |
Error Message | filters on the platform, writable, ::ancestor. |
||
exchange |
double |
Exchange Rate | filters on the platform, writable, ::ancestor. |
The Top part > Currency > The currency of the document. | |
external |
varchar2 |
itgen_vnet_externalinventoryid | writable, external |
The table > External inventory id > External inventory number | |
financial |
varchar2 |
Financial Period | filters on the platform, writable, ::ancestor. |
The financial period to which the transactions recorded in the document should be posted. Format YYYYMM. | |
hold |
char |
Hold | filters on the platform, writable, ::ancestor. |
The Top part > Hold > A check box that indicates that the status of the supplier ledger document is On hold. | |
hold |
char |
itgen_vnet_holdforpayment | filters on the platform, writable, ::ancestor. |
The Financial details tab > The Payment information section > Hold for payment > When set to true indicates that the document is on hold for payment and cannot be applied to a supplier payment. | |
inventory |
varchar2 |
Inventory Number | writable, inventory |
The table > Item ID > The unique ID of the particular item or service delivered by the supplier. | |
last |
datetime |
Last Modified | filters on the platform, writable, ::ancestor. |
||
line |
int32 |
Line Number | writable, line |
The table > Number at the left indicating the line number of the table. | |
location_ |
varchar2 |
Location Country ID | filters on the platform, writable, ::ancestor. |
Location*. | |
location_ |
varchar2 |
Location ID | filters on the platform, writable, ::ancestor. |
Click the magnifier > The identifier | |
location_ |
varchar2 |
Location Name | filters on the platform, writable, ::ancestor. |
Click the magnifier > The displayed name | |
manual |
char |
Manual Discount | writable, manual |
The table > Manual discount > A check box that indicates (if selected) that the discount has been applied manually. | |
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, ::ancestor. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, ::ancestor. |
||
note |
varchar2 |
Note | writable, note |
The table > Icon Notes > Pop-up window for providing any user-defined text connected with to invoice. | |
note_2 |
varchar2 |
Note 2 | filters on the platform, writable, ::ancestor. |
The table > Document details tab and Applications tab > Icon Notes > Pop-up window for providing any user-defined text connected with to invoice. | |
orig |
datetime |
Original Invoice Date | filters on the platform, writable, ::ancestor. |
The Top part > OrigInvoiceDate* > The original invoice date of the original supplier ledger document; by default, it is the current date, which can be changed. | |
original |
varchar2 |
itgen_vnet_originalreferencenumber | filters on the platform, writable, ::ancestor. |
The original reference number of the document. | |
pay |
datetime |
Pay Date | filters on the platform, writable, ::ancestor. |
The Financial details tab > The Payment information section > Pay date* > The date when the invoice should be paid. The date is the difference between the document due date or discount date and the number of days specified in the Payment lead time field in AP303000. | |
pay |
char |
Pay Selected | filters on the platform, writable, ::ancestor. |
The Financial details tab > The Payment information section > Approved for payment > When set to true indicates that the document is approved for payment. | |
payment |
varchar2 |
itgen_vnet_paymentmessage | filters on the platform, writable, ::ancestor. |
The Financial details tab > The Payment information section > Payment message > The message connected with the payment. | |
payment |
varchar2 |
Payment Method Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
payment |
varchar2 |
Payment Method ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
payment |
varchar2 |
Payment Reference Number | filters on the platform, writable, ::ancestor. |
The Top part > Payment ref.no > The payment reference number of the document. | |
po |
int32 |
itgen_vnet_polinenr | writable, po |
The table > Purchase order line > The line number of the purchase order line linked to this line of the invoice. | |
po |
varchar2 |
PO Number | writable, po |
The table > Purchase order number > The number of the purchase order linked to this line of the invoice. | |
po |
int32 |
itgen_vnet_poreceiptlinenbr | writable, po |
The table > Purchase order receipt line > The line number of the purchase receipt's line that is linked to this line of the invoice. | |
po |
varchar2 |
itgen_vnet_poreceiptnbr | writable, po |
The table > Purchase order receipt no. > The number of the purchase receipt linked to this line of the invoice. | |
post |
varchar2 |
Post Period | filters on the platform, writable, ::ancestor. |
The Top part > Post period* > The post period of the payment document. Format MMYYYY. | |
prebook |
char |
itgen_vnet_prebookaccount_active | writable, prebook |
||
prebook |
varchar2 |
itgen_vnet_prebookaccount_description | writable, prebook |
Name of item/description | |
prebook |
varchar2 |
itgen_vnet_prebookaccount_externalcode1 | writable, prebook |
Account class > The identifier of the account class. | |
prebook |
varchar2 |
itgen_vnet_prebookaccount_externalcode2 | writable, prebook |
Account class > The name of the account class. | |
prebook |
varchar2 |
itgen_vnet_prebookaccount_number | writable, prebook |
Number of item | |
prebook |
varchar2 |
itgen_vnet_prebookaccount_type | writable, prebook |
Account > The account number. | |
prebook |
char |
itgen_vnet_prebooksubaccount_active | writable, prebook |
Active > The status of the identifier. | |
prebook |
varchar2 |
itgen_vnet_prebooksubaccount_description | writable, prebook |
Description > The description of the identifier. | |
prebook |
varchar2 |
itgen_vnet_prebooksubaccount_errorinfo | writable, prebook |
||
prebook |
datetime |
itgen_vnet_prebooksubaccount_lastmodifieddatetime | writable, prebook |
System generated information. | |
prebook |
int64 |
itgen_vnet_prebooksubaccount_metadata_maxpagesize | writable, prebook |
||
prebook |
int64 |
itgen_vnet_prebooksubaccount_metadata_totalcount | writable, prebook |
||
prebook |
int32 |
itgen_vnet_prebooksubaccount_subaccountid | writable, prebook |
SubID > The identifier of the subaccount. | |
prebook |
varchar2 |
itgen_vnet_prebooksubaccount_subaccountnumber | writable, prebook |
Mandatory field: Subaccount* > The subaccount number. Format 9-XX. | |
prebook |
blob |
itgen_vnet_prebooksubaccount_timestamp | writable, prebook |
The timestamp of the subaccount, used for concurrency control. | |
project |
varchar2 |
Project Task Description | writable, project |
Click on the magnifier. > The description. | |
project |
varchar2 |
Project Task ID | writable, project |
Click on the magnifier. > The identifier. | |
project |
int32 |
itgen_vnet_projecttask_internalid | writable, project |
The internal identifier. | |
project_ |
varchar2 |
Project Description | writable, project. |
Click on the magnifier. > The description. | |
project_ |
varchar2 |
Project ID | writable, project. |
Click on the magnifier. > The identifier. | |
project_ |
int32 |
itgen_vnet_project_internalid | writable, project. |
The internal identifier. | |
quantity |
double |
Quantity | writable, quantity |
The table > Quantity > The quantity of the item or service to be delivered by the supplier. | |
reference |
varchar2 |
Reference Number | filters on the platform, writable, ::ancestor. |
||
retainage |
char |
itgen_vnet_retainageapply | filters on the platform, writable, ::ancestor. |
The Top part > Apply retainage > A check box that indicates (if selected) that this invoice is an invoice with retainage. | |
retainage |
double |
Retainage Percentage | writable, retainage |
||
rounding |
double |
Rounding Difference | filters on the platform, writable, ::ancestor. |
The Top part > Rounding diff. > The difference between the original invoice amount (including the VAT amount calculated by the system) and rounded invoice amount (including the VAT amount modified by a user for VAT-inclusive items). | |
rounding |
double |
Rounding Difference in Currency | filters on the platform, writable, ::ancestor. |
Background calculation giving you the Rounding diff. in your default currency. This field is applicable if the amount is given in another currency than your default. | |
split |
varchar2 |
itgen_vnet_splithierarchy | writable, split |
The table > Split hierarchy > The number of the original row that has been split. | |
status |
varchar2 |
Status | filters on the platform, writable, ::ancestor. |
The Top part > Document status > A read-only field that shows the status of the supplier ledger document:[Hold, Balanced, Voided, Scheduled, Open, Closed, Printed, Prebooked, Reserved] | |
stock |
char |
Stock Item | writable, stock |
Background information indicating whether the item is a stock item or not. | |
subaccount_ |
char |
Sub Account Active 2 | writable, subaccount. |
Active > The status of the identifier. | |
subaccount_ |
varchar2 |
Subaccount Description | writable, subaccount. |
Description > The description of the identifier. | |
subaccount_ |
varchar2 |
Sub Account Error Message | writable, subaccount. |
||
subaccount_ |
datetime |
Sub Account Last Modified | writable, subaccount. |
System generated information. | |
subaccount_ |
int64 |
Sub Account Metadata Max Pagesize | writable, subaccount. |
||
subaccount_ |
int64 |
Sub Account Metadata Total Count | writable, subaccount. |
||
subaccount_ |
int32 |
Sub Account ID | writable, subaccount. |
SubID > The identifier of the subaccount. | |
subaccount_ |
varchar2 |
Sub Account Number | writable, subaccount. |
Mandatory field: Subaccount* > The subaccount number. Format 9-XX. | |
subaccount_ |
blob |
itgen_vnet_subaccount_timestamp | writable, subaccount. |
The timestamp of the subaccount, used for concurrency control. | |
supplier |
varchar2 |
itgen_vnet_supplierreference | filters on the platform, writable, ::ancestor. |
The Top part > Supplier ref. > The document's original reference number as assigned by the supplier (for informational purposes). | |
supplier |
varchar2 |
itgen_vnet_suppliertaxzone_defaulttaxcategory_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
supplier |
varchar2 |
itgen_vnet_suppliertaxzone_defaulttaxcategory_number | filters on the platform, writable, ::ancestor. |
Number of item | |
supplier |
varchar2 |
itgen_vnet_suppliertaxzone_defaultvatcategory | filters on the platform, writable, ::ancestor. |
Click the magnifier. The Default VAT category for the VAT zone of the supplier, which is specified in the AP303000 window. | |
supplier |
varchar2 |
itgen_vnet_suppliertaxzone_description | filters on the platform, writable, ::ancestor. |
Click the magnifier. The description for the VAT zone of the supplier, which is specified in the AP303000 window. | |
supplier |
varchar2 |
itgen_vnet_suppliertaxzone_errorinfo | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
itgen_vnet_suppliertaxzone_id | filters on the platform, writable, ::ancestor. |
Click the magnifier. The identifier for the VAT zone of the supplier, which is specified in the AP303000 window. | |
supplier |
int64 |
itgen_vnet_suppliertaxzone_metadata_maxpagesize | filters on the platform, writable, ::ancestor. |
||
supplier |
int64 |
itgen_vnet_suppliertaxzone_metadata_totalcount | filters on the platform, writable, ::ancestor. |
||
supplier_ |
int64 |
Supplier Internal ID | filters on the platform, writable, ::ancestor. |
The internal id of the supplier | |
supplier_ |
varchar2 |
Supplier Name | filters on the platform, writable, ::ancestor. |
Click the magnifier. > The name. | |
supplier_ |
varchar2 |
Supplier Number | filters on the platform, writable, ::ancestor. |
Click the magnifier. > The identifier. | |
tax |
varchar2 |
itgen_vnet_taxcalculationmode | filters on the platform, writable, ::ancestor. |
The Financial details tab > The VAT section > VAT calculation mode > The VAT calculation mode, which defines which amounts (VAT-inclusive or VAT-exclusive) should be entered in the detail lines of a document (TaxSetting, Gross, Net) | |
term |
datetime |
Term End Date | writable, term |
||
term |
datetime |
Term Start Date | writable, term |
||
time |
blob |
Timestamp | filters on the platform, writable, ::ancestor. |
Identifier that represents a specific version of the resource. It helps to prevent simultaneous updates of the resource from overwriting each other (by using ETags and If-Match headers) | |
transaction |
varchar2 |
itgen_vnet_transactiondescription | writable, transaction |
The table > Transaction descr. > Any description relevant to the transaction. An alphanumeric string of up to 30 characters may be used. | |
unit |
double |
Unit Cost | writable, unit |
The table > Unit cost > The unit cost of the item. | |
unit |
double |
itgen_vnet_unitcostincurrency | writable, unit |
Background calculation giving you the Unit cost in the selected currency.This field is applicable if the amount is given in a another currency than your default. | |
uom |
varchar2 |
Unit of Measure | writable, uom |
The table > UoM > The unit of measure for the item. | |
vat |
double |
VAT Amount | filters on the platform, writable, ::ancestor. |
The Top part > VAT amount > The VAT amount to be paid for the document. Enter this amount manually according to the VAT amount specified in the original document. | |
vat |
varchar2 |
VAT Code Description | writable, vat |
Click on the magnifier. > The description. | |
vat |
varchar2 |
VAT Code ID | writable, vat |
Click on the magnifier. > The identifier. | |
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 Exempt Total in Currency | filters on the platform, writable, ::ancestor. |
Background calculation giving you the VAT exempt total in your default currency. This field is applicable if the amount is given in another currency than your default. | |
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. | |
vat |
double |
VAT Taxable Total in Currency | filters on the platform, writable, ::ancestor. |
Background calculation giving you the VAT taxable total in your default currency. This field is applicable if the amount is given in another currency than your default. | |
vat |
double |
VAT Total | filters on the platform, writable, ::ancestor. |
The Top part > VAT total > The total amount of tax paid in the document. | |
vat |
double |
VAT Total in Currency | filters on the platform, writable, ::ancestor. |
Background calculation giving you the VAT total in your default currency. This field is applicable if the amount is given in another currency than your default. | |
withholding |
double |
itgen_vnet_withholdingtax | filters on the platform, writable, ::ancestor. |
The Top part > With. tax > The amount of withholding tax calculated for the document, if applicable. | |
withholding |
double |
itgen_vnet_withholdingtaxincurrency | filters on the platform, writable, ::ancestor. |
Background calculation giving you the With. tax in your default currency. This field is applicable if the amount is given in another currency than your default. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: