---
title: "SupplierPaymentMethodDetails (Visma.net Financials)"
description: "Supplier Payment Method Details"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/vismanet/VismaNet.Supplier.SupplierPaymentMethodDetails
original: https://documentation.invantive.eu/en/datamodels/vismanet/VismaNet.Supplier.SupplierPaymentMethodDetails
updated: 2026-11-01T17:49:50Z
license: https://documentation.invantive.eu/en/
---

# SupplierPaymentMethodDetails: Visma.net Financials Supplier Payment Method Details

`read only` `REST`

- Catalog: `VismaNet`
- Schema: `Supplier`
- Label: Supplier Payment Method Details

Get a range of suppliers - ScreenId=AP303000

Can only retrieve data.

## API Source

- Endpoint: `/v1/supplier`
- Operation: `get /v1/supplier`

## 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 |
|---|---|:---:|---|---|
| `attributes` | `` | [ ] |  |  |
| `corporateId` | `` | [ ] |  |  |
| `expandAccountInformation` | `` | [ ] |  |  |
| `expandNote` | `` | [ ] |  |  |
| `greaterThanValue` | `` | [ ] |  |  |
| `lastModifiedDateTime` | `` | [ ] |  | 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` | `` | [ ] |  | This value represents the condition to be applied when retrieving records.  Accepted values (without the single quotes): * '&gt;' for greater than * '&lt;' for less than * '&gt;=' for greater than or equal * '&lt;=' for less than or equal  _Note:_ __LastModifiedDateTime__ and __LastModifiedDateTimeCondition__ are __mutually inclusive__. |
| `name` | `` | [ ] |  | Contains supplier name. |
| `status` | `` | [ ] |  | Values: Active, OnHold, HoldPayments, Inactive, OneTime. |
| `vatRegistrationId` | `` | [ ] |  |  |

## Table Columns

The columns of the table `SupplierPaymentMethodDetails` 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_CODE` | `varchar2(30)` | Company Code | [x] | writable | Partition code, segmenting the data. |
| `COMPANY_NAME` | `varchar2(240)` | Company Name | [x] | writable | Name of the partition. |
| `accountReference` | `varchar2` | Account Reference | [ ] | filters on the platform, writable, `::ancestor.accountReference` | General information tab &gt; Main contact section &gt; Account ref. &gt; An optional text field that can contain a reference to your company's account number in the supplier's system. |
| `accountUsedForPayment` | `varchar2` | itgen_vnet_accountusedforpayment | [ ] | filters on the platform, writable, `::ancestor.accountUsedForPayment` | Payment settings tab &gt; Payment settings section &gt; Account used for payment &gt; The bank account to be used for payments to the supplier. |
| `cashAccount` | `varchar2` | Cash Account | [ ] | filters on the platform, writable, `::ancestor.cashAccount` | Payment settings tab &gt; Payment settings section &gt; Cash account &gt; The cash account to be used for operations with the supplier. You must select a cash account. |
| `chargeBearer` | `varchar2` | Charge Bearer | [ ] | filters on the platform, writable, `::ancestor.chargeBearer` | Payment settings tab &gt; Payment settings section &gt; Charge bearer &gt; The party that will pay possible expenses connected with the payment. |
| `corporateId` | `varchar2` | Corporate ID | [ ] | filters on the platform, writable, `::ancestor.corporateId` | Purchase settings tab &gt; Default location settings section &gt; National insurance no. &gt; The supplier’s national insurance number associated with the location. |
| `creditTerms_description` | `varchar2` | Credit Terms Description | [ ] | filters on the platform, writable, `::ancestor.creditTerms.description` | Click on the magnifier. &gt; The description. |
| `creditTerms_id` | `varchar2` | Credit Terms ID | [ ] | filters on the platform, writable, `::ancestor.creditTerms.id` | Click on the magnifier. &gt; The identifier. |
| `currencyId` | `varchar2` | Currency ID | [ ] | filters on the platform, writable, `::ancestor.currencyId` | General information tab &gt; Financial settings section &gt; Currency ID &gt; The currency that is used in operations with the supplier. |
| `currencyOverride` | `char` | itgen_vnet_currencyoverride | [ ] | filters on the platform, writable, `::ancestor.currencyOverride` | General information tab &gt; Financial settings section &gt; Enable currency override |
| `currencyRateOverride` | `char` | itgen_vnet_currencyrateoverride | [ ] | filters on the platform, writable, `::ancestor.currencyRateOverride` | General information tab &gt; Financial settings section &gt; Enable rate override |
| `documentLanguage` | `varchar2` | Document Language | [ ] | filters on the platform, writable, `::ancestor.documentLanguage` | General information tab &gt; Financial settings section &gt; Document language &gt; The language of the documents to be printed to the suppliers of the class. |
| `errorInfo` | `varchar2` | Error Message | [ ] | filters on the platform, writable, `::ancestor.errorInfo` |  |
| `glAccounts_expenseAccountImport_description` | `varchar2` | itgen_vnet_glaccounts_expenseaccountimport_description | [ ] | filters on the platform, writable, `::ancestor.glAccounts.expenseAccountImport.description` | Name of item/description |
| `glAccounts_expenseAccountImport_number` | `varchar2` | itgen_vnet_glaccounts_expenseaccountimport_number | [ ] | filters on the platform, writable, `::ancestor.glAccounts.expenseAccountImport.number` | Number of item |
| `glAccounts_expenseAccountImport_type` | `varchar2` | itgen_vnet_glaccounts_expenseaccountimport_type | [ ] | filters on the platform, writable, `::ancestor.glAccounts.expenseAccountImport.type` |  |
| `glAccounts_expenseAccountNonTax_description` | `varchar2` | itgen_vnet_glaccounts_expenseaccountnontax_description | [ ] | filters on the platform, writable, `::ancestor.glAccounts.expenseAccountNonTax.description` | Name of item/description |
| `glAccounts_expenseAccountNonTax_number` | `varchar2` | itgen_vnet_glaccounts_expenseaccountnontax_number | [ ] | filters on the platform, writable, `::ancestor.glAccounts.expenseAccountNonTax.number` | Number of item |
| `glAccounts_expenseAccountNonTax_type` | `varchar2` | itgen_vnet_glaccounts_expenseaccountnontax_type | [ ] | filters on the platform, writable, `::ancestor.glAccounts.expenseAccountNonTax.type` |  |
| `glAccounts_expenseAccount_description` | `varchar2` | itgen_vnet_glaccounts_expenseaccount_description | [ ] | filters on the platform, writable, `::ancestor.glAccounts.expenseAccount.description` | Name of item/description |
| `glAccounts_expenseAccount_number` | `varchar2` | itgen_vnet_glaccounts_expenseaccount_number | [ ] | filters on the platform, writable, `::ancestor.glAccounts.expenseAccount.number` | Number of item |
| `glAccounts_expenseAccount_type` | `varchar2` | itgen_vnet_glaccounts_expenseaccount_type | [ ] | filters on the platform, writable, `::ancestor.glAccounts.expenseAccount.type` |  |
| `glAccounts_expenseEUAccount_description` | `varchar2` | itgen_vnet_glaccounts_expenseeuaccount_description | [ ] | filters on the platform, writable, `::ancestor.glAccounts.expenseEUAccount.description` | Name of item/description |
| `glAccounts_expenseEUAccount_number` | `varchar2` | itgen_vnet_glaccounts_expenseeuaccount_number | [ ] | filters on the platform, writable, `::ancestor.glAccounts.expenseEUAccount.number` | Number of item |
| `glAccounts_expenseEUAccount_type` | `varchar2` | itgen_vnet_glaccounts_expenseeuaccount_type | [ ] | filters on the platform, writable, `::ancestor.glAccounts.expenseEUAccount.type` |  |
| `glAccounts_expenseSubaccount_active` | `char` | itgen_vnet_glaccounts_expensesubaccount_active | [ ] | filters on the platform, writable, `::ancestor.glAccounts.expenseSubaccount.active` |  |
| `glAccounts_expenseSubaccount_description` | `varchar2` | itgen_vnet_glaccounts_expensesubaccount_description | [ ] | filters on the platform, writable, `::ancestor.glAccounts.expenseSubaccount.description` | Click on the magnifier. &gt; The description. |
| `glAccounts_expenseSubaccount_id` | `varchar2` | itgen_vnet_glaccounts_expensesubaccount_id | [ ] | filters on the platform, writable, `::ancestor.glAccounts.expenseSubaccount.id` | Click on the magnifier. &gt; The identifier. |
| `glAccounts_supplierAccount_description` | `varchar2` | itgen_vnet_glaccounts_supplieraccount_description | [ ] | filters on the platform, writable, `::ancestor.glAccounts.supplierAccount.description` | Name of item/description |
| `glAccounts_supplierAccount_number` | `varchar2` | itgen_vnet_glaccounts_supplieraccount_number | [ ] | filters on the platform, writable, `::ancestor.glAccounts.supplierAccount.number` | Number of item |
| `glAccounts_supplierAccount_type` | `varchar2` | itgen_vnet_glaccounts_supplieraccount_type | [ ] | filters on the platform, writable, `::ancestor.glAccounts.supplierAccount.type` |  |
| `glAccounts_supplierSubaccount_active` | `char` | itgen_vnet_glaccounts_suppliersubaccount_active | [ ] | filters on the platform, writable, `::ancestor.glAccounts.supplierSubaccount.active` |  |
| `glAccounts_supplierSubaccount_description` | `varchar2` | itgen_vnet_glaccounts_suppliersubaccount_description | [ ] | filters on the platform, writable, `::ancestor.glAccounts.supplierSubaccount.description` | Click on the magnifier. &gt; The description. |
| `glAccounts_supplierSubaccount_id` | `varchar2` | itgen_vnet_glaccounts_suppliersubaccount_id | [ ] | filters on the platform, writable, `::ancestor.glAccounts.supplierSubaccount.id` | Click on the magnifier. &gt; The identifier. |
| `internalId` | `int32` | Internal ID | [ ] | filters on the platform, writable, `::ancestor.internalId` |  |
| `landedCostSupplier` | `char` | itgen_vnet_landedcostsupplier | [ ] | filters on the platform, writable, `::ancestor.landedCostSupplier` | General information tab &gt; SupplierProperties &gt; Landed Cost Supplier &gt; Indicates if the supplier is a landed cost supplier or not |
| `lastModifiedDateTime` | `datetime` | Last Modified | [ ] | filters on the platform, writable, `::ancestor.lastModifiedDateTime` | System generated information. |
| `location_countryId` | `varchar2` | Location Country ID | [ ] | filters on the platform, writable, `::ancestor.location.countryId` | Location*. |
| `location_id` | `varchar2` | Location ID | [ ] | filters on the platform, writable, `::ancestor.location.id` | Click the magnifier &gt; The identifier |
| `location_name` | `varchar2` | Location Name | [ ] | filters on the platform, writable, `::ancestor.location.name` | Click the magnifier &gt; The displayed name |
| `mainAddress_addressId` | `int32` | Main Address ID | [ ] | filters on the platform, writable, `::ancestor.mainAddress.addressId` |  |
| `mainAddress_addressLine1` | `varchar2` | Main Address Line 1 | [ ] | filters on the platform, writable, `::ancestor.mainAddress.addressLine1` | Address 1 &gt; The first line of the customer's/supplier's/company's/employee's contact address. |
| `mainAddress_addressLine2` | `varchar2` | Main Address Line 2 | [ ] | filters on the platform, writable, `::ancestor.mainAddress.addressLine2` | Address 2 &gt; The second line of the address. |
| `mainAddress_addressLine3` | `varchar2` | Main Address Line 3 | [ ] | filters on the platform, writable, `::ancestor.mainAddress.addressLine3` | Address 3 &gt; The third line of the address. |
| `mainAddress_city` | `varchar2` | Main Address City | [ ] | filters on the platform, writable, `::ancestor.mainAddress.city` | City &gt; The city. |
| `mainAddress_country_errorInfo` | `varchar2` | itgen_vnet_mainaddress_country_errorinfo | [ ] | filters on the platform, writable, `::ancestor.mainAddress.country.errorInfo` |  |
| `mainAddress_country_id` | `varchar2` | Main Address Country ID | [ ] | filters on the platform, writable, `::ancestor.mainAddress.country.id` | Mandatory field: Country ID* &gt; The unique two-letter country ID according to international standard ISO 3166. |
| `mainAddress_country_metadata_maxPageSize` | `int64` | itgen_vnet_mainaddress_country_metadata_maxpagesize | [ ] | filters on the platform, writable, `::ancestor.mainAddress.country.metadata.maxPageSize` |  |
| `mainAddress_country_metadata_totalCount` | `int64` | itgen_vnet_mainaddress_country_metadata_totalcount | [ ] | filters on the platform, writable, `::ancestor.mainAddress.country.metadata.totalCount` |  |
| `mainAddress_country_name` | `varchar2` | Main Address Country Name | [ ] | filters on the platform, writable, `::ancestor.mainAddress.country.name` | Mandatory field: Country name* &gt; The complete name of the country. |
| `mainAddress_county_id` | `varchar2` | Main Address County ID | [ ] | filters on the platform, writable, `::ancestor.mainAddress.county.id` | Click the magnifier &gt; The identifier |
| `mainAddress_county_name` | `varchar2` | Main Address County Name | [ ] | filters on the platform, writable, `::ancestor.mainAddress.county.name` | Click the magnifier &gt; The displayed name |
| `mainAddress_postalCode` | `varchar2` | Main Address Postal Code | [ ] | filters on the platform, writable, `::ancestor.mainAddress.postalCode` | Postcode &gt; The postcode. |
| `mainContact_attention` | `varchar2` | Main Contact Attention | [ ] | filters on the platform, writable, `::ancestor.mainContact.attention` | Attention &gt; The attention line as it is used in your customer's/supplier's/company's business letters. The intention of this line is to direct the letter to the right person if the letter is not addressed to any specific person. |
| `mainContact_contactId` | `int32` | Main Contact ID | [ ] | filters on the platform, writable, `::ancestor.mainContact.contactId` |  |
| `mainContact_email` | `varchar2` | Main Contact Email Address | [ ] | filters on the platform, writable, `::ancestor.mainContact.email` | Email &gt; The email address of the customer/supplier/company as a business entity. |
| `mainContact_fax` | `varchar2` | Fax | [ ] | filters on the platform, writable, `::ancestor.mainContact.fax` | Fax &gt; The fax number. |
| `mainContact_name` | `varchar2` | Main Contact Name | [ ] | filters on the platform, writable, `::ancestor.mainContact.name` | Name &gt; The legal name of to appear on the documents. |
| `mainContact_phone1` | `varchar2` | Main Contact Phone 1 | [ ] | filters on the platform, writable, `::ancestor.mainContact.phone1` | Phone 1 &gt; The default phone number. |
| `mainContact_phone2` | `varchar2` | Main Contact Phone 2 | [ ] | filters on the platform, writable, `::ancestor.mainContact.phone2` | Phone 2 &gt; An additional phone number. |
| `mainContact_web` | `varchar2` | Main Contact Website | [ ] | filters on the platform, writable, `::ancestor.mainContact.web` | Web &gt; The website of the company, if one exists. |
| `metadata_maxPageSize` | `int64` | Metadata Max Pagesize | [ ] | filters on the platform, writable, `::ancestor.metadata.maxPageSize` |  |
| `metadata_totalCount` | `int64` | Total Count | [ ] | filters on the platform, writable, `::ancestor.metadata.totalCount` |  |
| `naceCode` | `varchar2` | itgen_vnet_nacecode | [ ] | filters on the platform, writable, `::ancestor.naceCode` | General information tab &gt; Main contact section &gt; Industry Code ID &gt; The supplier's NACE code |
| `name` | `varchar2` | Name | [ ] | filters on the platform, writable, `::ancestor.name` | Mandatory field: The top part &gt; Supplier name* &gt; The name of the supplier to appear in the system, which may be a trade name or a doing-business-as (DBA) name. |
| `note` | `varchar2` | Note | [ ] | filters on the platform, writable, `::ancestor.note` |  |
| `number` | `varchar2` | Number | [ ] | filters on the platform, writable, `::ancestor.number` | Mandatory field: The top part &gt; Supplier ID* &gt; The ID of the supplier account. |
| `numberOfEmployees` | `int32` | Number of Employees | [ ] | filters on the platform, writable, `::ancestor.numberOfEmployees` | Legal requirements that all companies with more than 250 employees keep track of their business accounts |
| `parentRecord_name` | `varchar2` | Parent Record Name | [ ] | filters on the platform, writable, `::ancestor.parentRecord.name` | Click the magnifier. &gt; The name. |
| `parentRecord_number` | `varchar2` | Parent Record Number | [ ] | filters on the platform, writable, `::ancestor.parentRecord.number` | Click the magnifier. &gt; The identifier. |
| `paySeparately` | `char` | itgen_vnet_payseparately | [ ] | filters on the platform, writable, `::ancestor.paySeparately` | Payment settings tab &gt; Payment settings section &gt; Pay separately &gt; A check box that indicates (if selected) that each supplier document should be paid by a separate payment. |
| `paymentBy` | `varchar2` | Payment by | [ ] | filters on the platform, writable, `::ancestor.paymentBy` | Payment settings tab &gt; Payment settings section &gt; Payment by &gt; An option that defines how to calculate the date when this supplier should be paid. |
| `paymentLeadTime` | `int32` | itgen_vnet_paymentleadtime | [ ] | filters on the platform, writable, `::ancestor.paymentLeadTime` | Payment settings tab &gt; Payment settings section &gt; Payment lead time (days) &gt; The number of days required for the payment to be delivered to the supplier's location. |
| `paymentMethodDetailBankingDetailType` | `varchar2` | itgen_vnet_paymentmethoddetailbankingdetailtype | [ ] | writable, `paymentMethodDetailBankingDetailType` | Payment method banking detail type |
| `paymentMethodDetailDescription` | `varchar2` | itgen_vnet_paymentmethoddetaildescription | [ ] | writable, `paymentMethodDetailDescription` | The description of the payment method detail. |
| `paymentMethodDetailID` | `varchar2` | itgen_vnet_paymentmethoddetailid | [ ] | writable, `paymentMethodDetailID` | payment method detail ID |
| `paymentMethodDetailValue` | `varchar2` | itgen_vnet_paymentmethoddetailvalue | [ ] | writable, `paymentMethodDetailValue` | The ID of the payment method detail. |
| `paymentMethod_description` | `varchar2` | Payment Method Description | [ ] | filters on the platform, writable, `::ancestor.paymentMethod.description` | Click on the magnifier. &gt; The description. |
| `paymentMethod_id` | `varchar2` | Payment Method ID | [ ] | filters on the platform, writable, `::ancestor.paymentMethod.id` | Click on the magnifier. &gt; The identifier. |
| `paymentRefDisplayMask` | `varchar2` | itgen_vnet_paymentrefdisplaymask | [ ] | filters on the platform, writable, `::ancestor.paymentRefDisplayMask` | Payment settings tab &gt; Payment settings section &gt; Payment ref. display mask &gt; This is a rule (mask) for how the payment reference number will be displayed. |
| `remitAddress_addressId` | `int32` | itgen_vnet_remitaddress_addressid | [ ] | filters on the platform, writable, `::ancestor.remitAddress.addressId` |  |
| `remitAddress_addressLine1` | `varchar2` | itgen_vnet_remitaddress_addressline1 | [ ] | filters on the platform, writable, `::ancestor.remitAddress.addressLine1` | Address 1 &gt; The first line of the customer's/supplier's/company's/employee's contact address. |
| `remitAddress_addressLine2` | `varchar2` | itgen_vnet_remitaddress_addressline2 | [ ] | filters on the platform, writable, `::ancestor.remitAddress.addressLine2` | Address 2 &gt; The second line of the address. |
| `remitAddress_addressLine3` | `varchar2` | itgen_vnet_remitaddress_addressline3 | [ ] | filters on the platform, writable, `::ancestor.remitAddress.addressLine3` | Address 3 &gt; The third line of the address. |
| `remitAddress_city` | `varchar2` | itgen_vnet_remitaddress_city | [ ] | filters on the platform, writable, `::ancestor.remitAddress.city` | City &gt; The city. |
| `remitAddress_country_errorInfo` | `varchar2` | itgen_vnet_remitaddress_country_errorinfo | [ ] | filters on the platform, writable, `::ancestor.remitAddress.country.errorInfo` |  |
| `remitAddress_country_id` | `varchar2` | itgen_vnet_remitaddress_country_id | [ ] | filters on the platform, writable, `::ancestor.remitAddress.country.id` | Mandatory field: Country ID* &gt; The unique two-letter country ID according to international standard ISO 3166. |
| `remitAddress_country_metadata_maxPageSize` | `int64` | itgen_vnet_remitaddress_country_metadata_maxpagesize | [ ] | filters on the platform, writable, `::ancestor.remitAddress.country.metadata.maxPageSize` |  |
| `remitAddress_country_metadata_totalCount` | `int64` | itgen_vnet_remitaddress_country_metadata_totalcount | [ ] | filters on the platform, writable, `::ancestor.remitAddress.country.metadata.totalCount` |  |
| `remitAddress_country_name` | `varchar2` | itgen_vnet_remitaddress_country_name | [ ] | filters on the platform, writable, `::ancestor.remitAddress.country.name` | Mandatory field: Country name* &gt; The complete name of the country. |
| `remitAddress_county_id` | `varchar2` | itgen_vnet_remitaddress_county_id | [ ] | filters on the platform, writable, `::ancestor.remitAddress.county.id` | Click the magnifier &gt; The identifier |
| `remitAddress_county_name` | `varchar2` | itgen_vnet_remitaddress_county_name | [ ] | filters on the platform, writable, `::ancestor.remitAddress.county.name` | Click the magnifier &gt; The displayed name |
| `remitAddress_postalCode` | `varchar2` | itgen_vnet_remitaddress_postalcode | [ ] | filters on the platform, writable, `::ancestor.remitAddress.postalCode` | Postcode &gt; The postcode. |
| `remitContact_attention` | `varchar2` | itgen_vnet_remitcontact_attention | [ ] | filters on the platform, writable, `::ancestor.remitContact.attention` | Attention &gt; The attention line as it is used in your customer's/supplier's/company's business letters. The intention of this line is to direct the letter to the right person if the letter is not addressed to any specific person. |
| `remitContact_contactId` | `int32` | itgen_vnet_remitcontact_contactid | [ ] | filters on the platform, writable, `::ancestor.remitContact.contactId` |  |
| `remitContact_email` | `varchar2` | itgen_vnet_remitcontact_email | [ ] | filters on the platform, writable, `::ancestor.remitContact.email` | Email &gt; The email address of the customer/supplier/company as a business entity. |
| `remitContact_fax` | `varchar2` | itgen_vnet_remitcontact_fax | [ ] | filters on the platform, writable, `::ancestor.remitContact.fax` | Fax &gt; The fax number. |
| `remitContact_name` | `varchar2` | itgen_vnet_remitcontact_name | [ ] | filters on the platform, writable, `::ancestor.remitContact.name` | Name &gt; The legal name of to appear on the documents. |
| `remitContact_phone1` | `varchar2` | itgen_vnet_remitcontact_phone1 | [ ] | filters on the platform, writable, `::ancestor.remitContact.phone1` | Phone 1 &gt; The default phone number. |
| `remitContact_phone2` | `varchar2` | itgen_vnet_remitcontact_phone2 | [ ] | filters on the platform, writable, `::ancestor.remitContact.phone2` | Phone 2 &gt; An additional phone number. |
| `remitContact_web` | `varchar2` | itgen_vnet_remitcontact_web | [ ] | filters on the platform, writable, `::ancestor.remitContact.web` | Web &gt; The website of the company, if one exists. |
| `retainageApply` | `char` | itgen_vnet_retainageapply | [ ] | filters on the platform, writable, `::ancestor.retainageApply` | Payment settings tab &gt; Retainage settings section &gt; Apply retainage &gt; A check box that indicates (if selected) that by default, invoices with retainage are created for the supplier in the Purchase invoices window. |
| `retainageCashAccountID` | `varchar2` | itgen_vnet_retainagecashaccountid | [ ] | filters on the platform, writable, `::ancestor.retainageCashAccountID` | Payment settings tab &gt; Retainage settings section &gt; Retainage cash account &gt; The cash account to be used to record retainages for this supplier. |
| `retainagePct` | `double` | Retainage Percentage | [ ] | filters on the platform, writable, `::ancestor.retainagePct` | Payment settings tab &gt; Retainage settings section &gt; Retainage (%) &gt; The default percent to be retained in invoices for the supplier. |
| `status` | `varchar2` | Status | [ ] | filters on the platform, writable, `::ancestor.status` | Mandatory field: The top part &gt; Status* &gt; The status of the supplier account. |
| `supplierAddress_addressId` | `int32` | itgen_vnet_supplieraddress_addressid | [ ] | filters on the platform, writable, `::ancestor.supplierAddress.addressId` |  |
| `supplierAddress_addressLine1` | `varchar2` | itgen_vnet_supplieraddress_addressline1 | [ ] | filters on the platform, writable, `::ancestor.supplierAddress.addressLine1` | Address 1 &gt; The first line of the customer's/supplier's/company's/employee's contact address. |
| `supplierAddress_addressLine2` | `varchar2` | itgen_vnet_supplieraddress_addressline2 | [ ] | filters on the platform, writable, `::ancestor.supplierAddress.addressLine2` | Address 2 &gt; The second line of the address. |
| `supplierAddress_addressLine3` | `varchar2` | itgen_vnet_supplieraddress_addressline3 | [ ] | filters on the platform, writable, `::ancestor.supplierAddress.addressLine3` | Address 3 &gt; The third line of the address. |
| `supplierAddress_city` | `varchar2` | itgen_vnet_supplieraddress_city | [ ] | filters on the platform, writable, `::ancestor.supplierAddress.city` | City &gt; The city. |
| `supplierAddress_country_errorInfo` | `varchar2` | itgen_vnet_supplieraddress_country_errorinfo | [ ] | filters on the platform, writable, `::ancestor.supplierAddress.country.errorInfo` |  |
| `supplierAddress_country_id` | `varchar2` | itgen_vnet_supplieraddress_country_id | [ ] | filters on the platform, writable, `::ancestor.supplierAddress.country.id` | Mandatory field: Country ID* &gt; The unique two-letter country ID according to international standard ISO 3166. |
| `supplierAddress_country_metadata_maxPageSize` | `int64` | itgen_vnet_supplieraddress_country_metadata_maxpagesize | [ ] | filters on the platform, writable, `::ancestor.supplierAddress.country.metadata.maxPageSize` |  |
| `supplierAddress_country_metadata_totalCount` | `int64` | itgen_vnet_supplieraddress_country_metadata_totalcount | [ ] | filters on the platform, writable, `::ancestor.supplierAddress.country.metadata.totalCount` |  |
| `supplierAddress_country_name` | `varchar2` | itgen_vnet_supplieraddress_country_name | [ ] | filters on the platform, writable, `::ancestor.supplierAddress.country.name` | Mandatory field: Country name* &gt; The complete name of the country. |
| `supplierAddress_county_id` | `varchar2` | itgen_vnet_supplieraddress_county_id | [ ] | filters on the platform, writable, `::ancestor.supplierAddress.county.id` | Click the magnifier &gt; The identifier |
| `supplierAddress_county_name` | `varchar2` | itgen_vnet_supplieraddress_county_name | [ ] | filters on the platform, writable, `::ancestor.supplierAddress.county.name` | Click the magnifier &gt; The displayed name |
| `supplierAddress_postalCode` | `varchar2` | itgen_vnet_supplieraddress_postalcode | [ ] | filters on the platform, writable, `::ancestor.supplierAddress.postalCode` | Postcode &gt; The postcode. |
| `supplierClass_description` | `varchar2` | Supplier Class Description | [ ] | filters on the platform, writable, `::ancestor.supplierClass.description` | Click on the magnifier. &gt; The description. |
| `supplierClass_id` | `varchar2` | Supplier Class ID | [ ] | filters on the platform, writable, `::ancestor.supplierClass.id` | Click on the magnifier. &gt; The identifier. |
| `supplierContact_attention` | `varchar2` | itgen_vnet_suppliercontact_attention | [ ] | filters on the platform, writable, `::ancestor.supplierContact.attention` | Attention &gt; The attention line as it is used in your customer's/supplier's/company's business letters. The intention of this line is to direct the letter to the right person if the letter is not addressed to any specific person. |
| `supplierContact_contactId` | `int32` | itgen_vnet_suppliercontact_contactid | [ ] | filters on the platform, writable, `::ancestor.supplierContact.contactId` |  |
| `supplierContact_email` | `varchar2` | itgen_vnet_suppliercontact_email | [ ] | filters on the platform, writable, `::ancestor.supplierContact.email` | Email &gt; The email address of the customer/supplier/company as a business entity. |
| `supplierContact_fax` | `varchar2` | itgen_vnet_suppliercontact_fax | [ ] | filters on the platform, writable, `::ancestor.supplierContact.fax` | Fax &gt; The fax number. |
| `supplierContact_name` | `varchar2` | itgen_vnet_suppliercontact_name | [ ] | filters on the platform, writable, `::ancestor.supplierContact.name` | Name &gt; The legal name of to appear on the documents. |
| `supplierContact_phone1` | `varchar2` | itgen_vnet_suppliercontact_phone1 | [ ] | filters on the platform, writable, `::ancestor.supplierContact.phone1` | Phone 1 &gt; The default phone number. |
| `supplierContact_phone2` | `varchar2` | itgen_vnet_suppliercontact_phone2 | [ ] | filters on the platform, writable, `::ancestor.supplierContact.phone2` | Phone 2 &gt; An additional phone number. |
| `supplierContact_web` | `varchar2` | itgen_vnet_suppliercontact_web | [ ] | filters on the platform, writable, `::ancestor.supplierContact.web` | Web &gt; The website of the company, if one exists. |
| `timeStamp` | `blob` | Timestamp | [ ] | filters on the platform, writable, `::ancestor.timeStamp` | 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) |
| `vatRegistrationId` | `varchar2` | VAT Registration ID | [ ] | filters on the platform, writable, `::ancestor.vatRegistrationId` | Purchase settings tab &gt; Default location settings section &gt; VAT registration ID &gt; The supplier's VAT registration ID associated with the location. |
| `vatZone_defaultTaxCategory_description` | `varchar2` | VAT Zone Default Tax Category Description | [ ] | filters on the platform, writable, `::ancestor.vatZone.defaultTaxCategory.description` | Name of item/description |
| `vatZone_defaultTaxCategory_number` | `varchar2` | VAT Zone Default Tax Category Number | [ ] | filters on the platform, writable, `::ancestor.vatZone.defaultTaxCategory.number` | Number of item |
| `vatZone_defaultVatCategory` | `varchar2` | VAT Zone Default VAT Category | [ ] | filters on the platform, writable, `::ancestor.vatZone.defaultVatCategory` | Click the magnifier. The Default VAT category for the VAT zone of the supplier, which is specified in the  AP303000 window. |
| `vatZone_description` | `varchar2` | VAT Zone Description | [ ] | filters on the platform, writable, `::ancestor.vatZone.description` | Click the magnifier. The description for the VAT zone of the supplier, which is specified in the  AP303000 window. |
| `vatZone_errorInfo` | `varchar2` | itgen_vnet_vatzone_errorinfo | [ ] | filters on the platform, writable, `::ancestor.vatZone.errorInfo` |  |
| `vatZone_id` | `varchar2` | VAT Zone ID | [ ] | filters on the platform, writable, `::ancestor.vatZone.id` | Click the magnifier. The identifier for the VAT zone of the supplier, which is specified in the  AP303000 window. |
| `vatZone_metadata_maxPageSize` | `int64` | itgen_vnet_vatzone_metadata_maxpagesize | [ ] | filters on the platform, writable, `::ancestor.vatZone.metadata.maxPageSize` |  |
| `vatZone_metadata_totalCount` | `int64` | itgen_vnet_vatzone_metadata_totalcount | [ ] | filters on the platform, writable, `::ancestor.vatZone.metadata.totalCount` |  |

## Keys

| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
| `SupplierPaymentMethodDetails_creditTerms_id_fk` | `creditTerms_id` | [CreditTermRecords](VismaNet.CreditTerm.CreditTermRecords)`.termsId` | Key |  |
| `SupplierPaymentMethodDetails_currencyId_fk` | `currencyId` | [Currencies](VismaNet.Currency.Currencies)`.id` | Key |  |
| `SupplierPaymentMethodDetails_location_countryId_fk` | `location_countryId` | [Countries](VismaNet.Country.Countries)`.id` | Key |  |
| `SupplierPaymentMethodDetails_paymentMethod_id_fk` | `paymentMethod_id` | [PaymentMethods](VismaNet.PaymentMethod.PaymentMethods)`.paymentMethodID` | Key |  |
| `SupplierPaymentMethodDetails_supplierClass_id_fk` | `supplierClass_id` | [SupplierClasses](VismaNet.Supplier.SupplierClasses)`.id` | Key |  |
| `SupplierPaymentMethodDetails_vatZone_id_fk` | `vatZone_id` | [VatZones](VismaNet.VatZone.VatZones)`.id` | Key |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Visma.net Financials](/en/release-notes/drivers?driver=visma-net-financials)

