SupplierInvoiceLineAttachments: Visma.net Financials Supplier Invoice Line Attachments
read only REST
- Catalog:
VismaNet - Schema:
SupplierInvoice - Label: Supplier Invoice Line Attachments
Get a range of Invoices - ScreenId=AP301000. Request 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
Can only retrieve data.
API Source
- Endpoint:
/v1/supplierInvoice - Operation:
get /v1/supplierInvoice
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 |
|---|---|---|---|---|
balance |
`` | This value represents balance of the payment remaining to be applied and released. Only released applications will count towards the balance. Note: Balance and BalanceCondition are mutually inclusive. | ||
balance |
`` | This value represents the condition to be applied to the Balance 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: Balance and BalanceCondition are mutually inclusive. | ||
branch |
`` | Filter by Branch | ||
created |
`` | This value, generated by the system, indicates the creation date and time. Use it to retrieve all records that have been created since that time, up to the present. Accepted format: * yyyy- * yyyy- * yyyy- * yyyy- * yyyy- Note: CreatedDateTime and CreatedDateTimeCondition are mutually inclusive. |
||
created |
`` | 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: CreatedDateTime and CreatedDateTimeCondition are mutually inclusive. | ||
doc |
`` | This value indicates the document date. Use it to retrieve all records that have the Document Date since that time, up to the future. Accepted format: * yyyy- * yyyy- * yyyy- * yyyy- * yyyy- Note: Docate and DocDateCondition are mutually inclusive. |
||
doc |
`` | This value represents the condition to be applied to the Document 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: DocumentDate and DocumentDateCondition are mutually inclusive. | ||
document |
`` | By type of document. (Values: Invoice, CreditAdj, DebitAdj, Prepayment, Refund, Payment) | ||
due |
`` | This value indicates the date the document is due for payment. Use it to retrieve all records that have the Due date since that time, up to the future. Accepted format: * yyyy- * yyyy- * yyyy- * yyyy- * yyyy- Note: DueDate and DueDateConditionCondition are mutually inclusive. |
||
due |
`` | 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: DueDate and DueDateCondition are mutually inclusive. | ||
expand |
`` | Set to true to include approval information. | ||
expand |
`` | Set to true if you want to see all attachments regarding this document. | ||
expand |
`` | Expland landed cost lines | ||
expand |
`` | Expland line-level pre-booking account and sub-account information. | ||
expand |
`` | Set to true to include description. | ||
financial |
`` | Filter by Financial Period, format YYYYPP | ||
greater |
`` | Greater than value. The item which is the object for this, varies from API to API. | ||
item |
`` | Filter by Item used into the document lines | ||
last |
`` | 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- * yyyy- * yyyy- * yyyy- * yyyy- Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive. |
||
last |
`` | 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. | ||
project |
`` | Filter by the project with which the document is associated. | ||
released |
`` | Parameter for showing if invoice has been released or not. | ||
status |
`` | The status of the document (Values: Hold, Balanced, Voided, Scheduled, Open, Closed, Printed, Prebooked, Reserved) | ||
supplier |
`` | Filter by Supplier |
Table Columns
The columns of the table SupplierInvoiceLineAttachments 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, ::ancestor. |
||
account_ |
varchar2 |
Account Description | writable, ::ancestor. |
Name of item/description | |
account_ |
varchar2 |
Account External Code 1 | writable, ::ancestor. |
Account class > The identifier of the account class. | |
account_ |
varchar2 |
Account External Code 2 | writable, ::ancestor. |
Account class > The name of the account class. | |
account_ |
varchar2 |
Account Number | writable, ::ancestor. |
Number of item | |
account_ |
varchar2 |
Account Type | writable, ::ancestor. |
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, ::ancestor. |
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, ::ancestor. |
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, ::ancestor. |
The table > Cost > The unit cost of the item or service received from the supplier. | |
cost |
double |
itgen_vnet_costincurrency | writable, ::ancestor. |
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, ::ancestor. |
||
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, ::ancestor. |
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, ::ancestor. |
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, ::ancestor. |
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, ::ancestor. |
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, ::ancestor. |
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, ::ancestor. |
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, ::ancestor. |
Background calculation giving you the Discount unit cost in the default currency. | |
discount |
double |
itgen_vnet_discountunitcostincurrency | writable, ::ancestor. |
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, ::ancestor. |
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. | |
id |
guid |
ID | writable, id |
The ID of the attachment | |
inventory |
varchar2 |
Inventory Number | writable, ::ancestor. |
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, ::ancestor. |
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, ::ancestor. |
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. |
||
name |
varchar2 |
Name | writable, name |
The name of the attachment. | |
note |
varchar2 |
Note | writable, ::ancestor. |
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, ::ancestor. |
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, ::ancestor. |
The table > Purchase order number > The number of the purchase order linked to this line of the invoice. | |
po |
int32 |
itgen_vnet_poreceiptlinenbr | writable, ::ancestor. |
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, ::ancestor. |
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, ::ancestor. |
||
prebook |
varchar2 |
itgen_vnet_prebookaccount_description | writable, ::ancestor. |
Name of item/description | |
prebook |
varchar2 |
itgen_vnet_prebookaccount_externalcode1 | writable, ::ancestor. |
Account class > The identifier of the account class. | |
prebook |
varchar2 |
itgen_vnet_prebookaccount_externalcode2 | writable, ::ancestor. |
Account class > The name of the account class. | |
prebook |
varchar2 |
itgen_vnet_prebookaccount_number | writable, ::ancestor. |
Number of item | |
prebook |
varchar2 |
itgen_vnet_prebookaccount_type | writable, ::ancestor. |
Account > The account number. | |
prebook |
char |
itgen_vnet_prebooksubaccount_active | writable, ::ancestor. |
Active > The status of the identifier. | |
prebook |
varchar2 |
itgen_vnet_prebooksubaccount_description | writable, ::ancestor. |
Description > The description of the identifier. | |
prebook |
varchar2 |
itgen_vnet_prebooksubaccount_errorinfo | writable, ::ancestor. |
||
prebook |
datetime |
itgen_vnet_prebooksubaccount_lastmodifieddatetime | writable, ::ancestor. |
System generated information. | |
prebook |
int64 |
itgen_vnet_prebooksubaccount_metadata_maxpagesize | writable, ::ancestor. |
||
prebook |
int64 |
itgen_vnet_prebooksubaccount_metadata_totalcount | writable, ::ancestor. |
||
prebook |
int32 |
itgen_vnet_prebooksubaccount_subaccountid | writable, ::ancestor. |
SubID > The identifier of the subaccount. | |
prebook |
varchar2 |
itgen_vnet_prebooksubaccount_subaccountnumber | writable, ::ancestor. |
Mandatory field: Subaccount* > The subaccount number. Format 9-XX. | |
prebook |
blob |
itgen_vnet_prebooksubaccount_timestamp | writable, ::ancestor. |
The timestamp of the subaccount, used for concurrency control. | |
project |
varchar2 |
Project Task Description | writable, ::ancestor. |
Click on the magnifier. > The description. | |
project |
varchar2 |
Project Task ID | writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
project |
int32 |
itgen_vnet_projecttask_internalid | writable, ::ancestor. |
The internal identifier. | |
project_ |
varchar2 |
Project Description | writable, ::ancestor. |
Click on the magnifier. > The description. | |
project_ |
varchar2 |
Project ID | writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
project_ |
int32 |
itgen_vnet_project_internalid | writable, ::ancestor. |
The internal identifier. | |
quantity |
double |
Quantity | writable, ::ancestor. |
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, ::ancestor. |
||
revision |
int32 |
Revision | writable, revision |
The version of the attachment. | |
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, ::ancestor. |
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, ::ancestor. |
Background information indicating whether the item is a stock item or not. | |
subaccount_ |
char |
Sub Account Active 2 | writable, ::ancestor. |
Active > The status of the identifier. | |
subaccount_ |
varchar2 |
Subaccount Description | writable, ::ancestor. |
Description > The description of the identifier. | |
subaccount_ |
varchar2 |
Sub Account Error Message | writable, ::ancestor. |
||
subaccount_ |
datetime |
Sub Account Last Modified | writable, ::ancestor. |
System generated information. | |
subaccount_ |
int64 |
Sub Account Metadata Max Pagesize | writable, ::ancestor. |
||
subaccount_ |
int64 |
Sub Account Metadata Total Count | writable, ::ancestor. |
||
subaccount_ |
int32 |
Sub Account ID | writable, ::ancestor. |
SubID > The identifier of the subaccount. | |
subaccount_ |
varchar2 |
Sub Account Number | writable, ::ancestor. |
Mandatory field: Subaccount* > The subaccount number. Format 9-XX. | |
subaccount_ |
blob |
itgen_vnet_subaccount_timestamp | writable, ::ancestor. |
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, ::ancestor. |
||
term |
datetime |
Term Start Date | writable, ::ancestor. |
||
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, ::ancestor. |
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, ::ancestor. |
The table > Unit cost > The unit cost of the item. | |
unit |
double |
itgen_vnet_unitcostincurrency | writable, ::ancestor. |
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, ::ancestor. |
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, ::ancestor. |
Click on the magnifier. > The description. | |
vat |
varchar2 |
VAT Code ID | writable, ::ancestor. |
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: