SupplierPaymentMethodDetailsByCode: Visma.net Financials Supplier Payment Method Details by Code
read only REST
- Catalog:
VismaNet - Schema:
Supplier - Label: Supplier Payment Method Details by Code
Get a specific supplier Data for a single supplier. The response headers include an ETag after a successful GET operation.
Can only retrieve data.
Summary
Data for a single supplier.
The response headers include an ETag after a successful GET operation.
API Source
- Endpoint:
/v1/supplier/{supplierCd} - Operation:
get /v1/supplier/{supplierCd}
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 |
|---|---|---|---|---|
supplier |
`` | Identifies the supplier |
Table Columns
The columns of the table SupplierPaymentMethodDetailsByCode 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 |
varchar2 |
Account Reference | filters on the platform, writable, ::ancestor. |
General information tab > Main contact section > Account ref. > An optional text field that can contain a reference to your company's account number in the supplier's system. | |
account |
varchar2 |
itgen_vnet_accountusedforpayment | filters on the platform, writable, ::ancestor. |
Payment settings tab > Payment settings section > Account used for payment > The bank account to be used for payments to the supplier. | |
cash |
varchar2 |
Cash Account | filters on the platform, writable, ::ancestor. |
Payment settings tab > Payment settings section > Cash account > The cash account to be used for operations with the supplier. You must select a cash account. | |
charge |
varchar2 |
Charge Bearer | filters on the platform, writable, ::ancestor. |
Payment settings tab > Payment settings section > Charge bearer > The party that will pay possible expenses connected with the payment. | |
corporate |
varchar2 |
Corporate ID | filters on the platform, writable, ::ancestor. |
Purchase settings tab > Default location settings section > National insurance no. > The supplier’s national insurance number associated with the location. | |
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. |
General information tab > Financial settings section > Currency ID > The currency that is used in operations with the supplier. | |
currency |
char |
itgen_vnet_currencyoverride | filters on the platform, writable, ::ancestor. |
General information tab > Financial settings section > Enable currency override | |
currency |
char |
itgen_vnet_currencyrateoverride | filters on the platform, writable, ::ancestor. |
General information tab > Financial settings section > Enable rate override | |
document |
varchar2 |
Document Language | filters on the platform, writable, ::ancestor. |
General information tab > Financial settings section > Document language > The language of the documents to be printed to the suppliers of the class. | |
error |
varchar2 |
Error Message | filters on the platform, writable, ::ancestor. |
||
gl |
varchar2 |
itgen_vnet_glaccounts_expenseaccountimport_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
gl |
varchar2 |
itgen_vnet_glaccounts_expenseaccountimport_number | filters on the platform, writable, ::ancestor. |
Number of item | |
gl |
varchar2 |
itgen_vnet_glaccounts_expenseaccountimport_type | filters on the platform, writable, ::ancestor. |
||
gl |
varchar2 |
itgen_vnet_glaccounts_expenseaccountnontax_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
gl |
varchar2 |
itgen_vnet_glaccounts_expenseaccountnontax_number | filters on the platform, writable, ::ancestor. |
Number of item | |
gl |
varchar2 |
itgen_vnet_glaccounts_expenseaccountnontax_type | filters on the platform, writable, ::ancestor. |
||
gl |
varchar2 |
itgen_vnet_glaccounts_expenseaccount_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
gl |
varchar2 |
itgen_vnet_glaccounts_expenseaccount_number | filters on the platform, writable, ::ancestor. |
Number of item | |
gl |
varchar2 |
itgen_vnet_glaccounts_expenseaccount_type | filters on the platform, writable, ::ancestor. |
||
gl |
varchar2 |
itgen_vnet_glaccounts_expenseeuaccount_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
gl |
varchar2 |
itgen_vnet_glaccounts_expenseeuaccount_number | filters on the platform, writable, ::ancestor. |
Number of item | |
gl |
varchar2 |
itgen_vnet_glaccounts_expenseeuaccount_type | filters on the platform, writable, ::ancestor. |
||
gl |
char |
itgen_vnet_glaccounts_expensesubaccount_active | filters on the platform, writable, ::ancestor. |
||
gl |
varchar2 |
itgen_vnet_glaccounts_expensesubaccount_description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
gl |
varchar2 |
itgen_vnet_glaccounts_expensesubaccount_id | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
gl |
varchar2 |
itgen_vnet_glaccounts_supplieraccount_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
gl |
varchar2 |
itgen_vnet_glaccounts_supplieraccount_number | filters on the platform, writable, ::ancestor. |
Number of item | |
gl |
varchar2 |
itgen_vnet_glaccounts_supplieraccount_type | filters on the platform, writable, ::ancestor. |
||
gl |
char |
itgen_vnet_glaccounts_suppliersubaccount_active | filters on the platform, writable, ::ancestor. |
||
gl |
varchar2 |
itgen_vnet_glaccounts_suppliersubaccount_description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
gl |
varchar2 |
itgen_vnet_glaccounts_suppliersubaccount_id | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
internal |
int32 |
Internal ID | filters on the platform, writable, ::ancestor. |
||
landed |
char |
itgen_vnet_landedcostsupplier | filters on the platform, writable, ::ancestor. |
General information tab > SupplierProperties > Landed Cost Supplier > Indicates if the supplier is a landed cost supplier or not | |
last |
datetime |
Last Modified | filters on the platform, writable, ::ancestor. |
System generated information. | |
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 | |
main |
int32 |
Main Address ID | filters on the platform, writable, ::ancestor. |
||
main |
varchar2 |
Main Address Line 1 | filters on the platform, writable, ::ancestor. |
Address 1 > The first line of the customer's/supplier's/company's/employee's contact address. | |
main |
varchar2 |
Main Address Line 2 | filters on the platform, writable, ::ancestor. |
Address 2 > The second line of the address. | |
main |
varchar2 |
Main Address Line 3 | filters on the platform, writable, ::ancestor. |
Address 3 > The third line of the address. | |
main |
varchar2 |
Main Address City | filters on the platform, writable, ::ancestor. |
City > The city. | |
main |
varchar2 |
itgen_vnet_mainaddress_country_errorinfo | filters on the platform, writable, ::ancestor. |
||
main |
varchar2 |
Main Address Country ID | filters on the platform, writable, ::ancestor. |
Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166. | |
main |
int64 |
itgen_vnet_mainaddress_country_metadata_maxpagesize | filters on the platform, writable, ::ancestor. |
||
main |
int64 |
itgen_vnet_mainaddress_country_metadata_totalcount | filters on the platform, writable, ::ancestor. |
||
main |
varchar2 |
Main Address Country Name | filters on the platform, writable, ::ancestor. |
Mandatory field: Country name* > The complete name of the country. | |
main |
varchar2 |
Main Address County ID | filters on the platform, writable, ::ancestor. |
Click the magnifier > The identifier | |
main |
varchar2 |
Main Address County Name | filters on the platform, writable, ::ancestor. |
Click the magnifier > The displayed name | |
main |
varchar2 |
Main Address Postal Code | filters on the platform, writable, ::ancestor. |
Postcode > The postcode. | |
main |
varchar2 |
Main Contact Attention | filters on the platform, writable, ::ancestor. |
Attention > 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. | |
main |
int32 |
Main Contact ID | filters on the platform, writable, ::ancestor. |
||
main |
varchar2 |
Main Contact Email Address | filters on the platform, writable, ::ancestor. |
Email > The email address of the customer/supplier/company as a business entity. | |
main |
varchar2 |
Fax | filters on the platform, writable, ::ancestor. |
Fax > The fax number. | |
main |
varchar2 |
Main Contact Name | filters on the platform, writable, ::ancestor. |
Name > The legal name of to appear on the documents. | |
main |
varchar2 |
Main Contact Phone 1 | filters on the platform, writable, ::ancestor. |
Phone 1 > The default phone number. | |
main |
varchar2 |
Main Contact Phone 2 | filters on the platform, writable, ::ancestor. |
Phone 2 > An additional phone number. | |
main |
varchar2 |
Main Contact Website | filters on the platform, writable, ::ancestor. |
Web > The website of the company, if one exists. | |
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, ::ancestor. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, ::ancestor. |
||
nace |
varchar2 |
itgen_vnet_nacecode | filters on the platform, writable, ::ancestor. |
General information tab > Main contact section > Industry Code ID > The supplier's NACE code | |
name |
varchar2 |
Name | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Supplier name* > 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. |
||
number |
varchar2 |
Number | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Supplier ID* > The ID of the supplier account. | |
number |
int32 |
Number of Employees | filters on the platform, writable, ::ancestor. |
Legal requirements that all companies with more than 250 employees keep track of their business accounts | |
parent |
varchar2 |
Parent Record Name | filters on the platform, writable, ::ancestor. |
Click the magnifier. > The name. | |
parent |
varchar2 |
Parent Record Number | filters on the platform, writable, ::ancestor. |
Click the magnifier. > The identifier. | |
pay |
char |
itgen_vnet_payseparately | filters on the platform, writable, ::ancestor. |
Payment settings tab > Payment settings section > Pay separately > A check box that indicates (if selected) that each supplier document should be paid by a separate payment. | |
payment |
varchar2 |
Payment by | filters on the platform, writable, ::ancestor. |
Payment settings tab > Payment settings section > Payment by > An option that defines how to calculate the date when this supplier should be paid. | |
payment |
int32 |
itgen_vnet_paymentleadtime | filters on the platform, writable, ::ancestor. |
Payment settings tab > Payment settings section > Payment lead time (days) > The number of days required for the payment to be delivered to the supplier's location. | |
payment |
varchar2 |
itgen_vnet_paymentmethoddetailbankingdetailtype | writable, payment |
Payment method banking detail type | |
payment |
varchar2 |
itgen_vnet_paymentmethoddetaildescription | writable, payment |
The description of the payment method detail. | |
payment |
varchar2 |
itgen_vnet_paymentmethoddetailid | writable, payment |
payment method detail ID | |
payment |
varchar2 |
itgen_vnet_paymentmethoddetailvalue | writable, payment |
The ID of the payment method detail. | |
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 |
itgen_vnet_paymentrefdisplaymask | filters on the platform, writable, ::ancestor. |
Payment settings tab > Payment settings section > Payment ref. display mask > This is a rule (mask) for how the payment reference number will be displayed. | |
remit |
int32 |
itgen_vnet_remitaddress_addressid | filters on the platform, writable, ::ancestor. |
||
remit |
varchar2 |
itgen_vnet_remitaddress_addressline1 | filters on the platform, writable, ::ancestor. |
Address 1 > The first line of the customer's/supplier's/company's/employee's contact address. | |
remit |
varchar2 |
itgen_vnet_remitaddress_addressline2 | filters on the platform, writable, ::ancestor. |
Address 2 > The second line of the address. | |
remit |
varchar2 |
itgen_vnet_remitaddress_addressline3 | filters on the platform, writable, ::ancestor. |
Address 3 > The third line of the address. | |
remit |
varchar2 |
itgen_vnet_remitaddress_city | filters on the platform, writable, ::ancestor. |
City > The city. | |
remit |
varchar2 |
itgen_vnet_remitaddress_country_errorinfo | filters on the platform, writable, ::ancestor. |
||
remit |
varchar2 |
itgen_vnet_remitaddress_country_id | filters on the platform, writable, ::ancestor. |
Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166. | |
remit |
int64 |
itgen_vnet_remitaddress_country_metadata_maxpagesize | filters on the platform, writable, ::ancestor. |
||
remit |
int64 |
itgen_vnet_remitaddress_country_metadata_totalcount | filters on the platform, writable, ::ancestor. |
||
remit |
varchar2 |
itgen_vnet_remitaddress_country_name | filters on the platform, writable, ::ancestor. |
Mandatory field: Country name* > The complete name of the country. | |
remit |
varchar2 |
itgen_vnet_remitaddress_county_id | filters on the platform, writable, ::ancestor. |
Click the magnifier > The identifier | |
remit |
varchar2 |
itgen_vnet_remitaddress_county_name | filters on the platform, writable, ::ancestor. |
Click the magnifier > The displayed name | |
remit |
varchar2 |
itgen_vnet_remitaddress_postalcode | filters on the platform, writable, ::ancestor. |
Postcode > The postcode. | |
remit |
varchar2 |
itgen_vnet_remitcontact_attention | filters on the platform, writable, ::ancestor. |
Attention > 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. | |
remit |
int32 |
itgen_vnet_remitcontact_contactid | filters on the platform, writable, ::ancestor. |
||
remit |
varchar2 |
itgen_vnet_remitcontact_email | filters on the platform, writable, ::ancestor. |
Email > The email address of the customer/supplier/company as a business entity. | |
remit |
varchar2 |
itgen_vnet_remitcontact_fax | filters on the platform, writable, ::ancestor. |
Fax > The fax number. | |
remit |
varchar2 |
itgen_vnet_remitcontact_name | filters on the platform, writable, ::ancestor. |
Name > The legal name of to appear on the documents. | |
remit |
varchar2 |
itgen_vnet_remitcontact_phone1 | filters on the platform, writable, ::ancestor. |
Phone 1 > The default phone number. | |
remit |
varchar2 |
itgen_vnet_remitcontact_phone2 | filters on the platform, writable, ::ancestor. |
Phone 2 > An additional phone number. | |
remit |
varchar2 |
itgen_vnet_remitcontact_web | filters on the platform, writable, ::ancestor. |
Web > The website of the company, if one exists. | |
retainage |
char |
itgen_vnet_retainageapply | filters on the platform, writable, ::ancestor. |
Payment settings tab > Retainage settings section > Apply retainage > A check box that indicates (if selected) that by default, invoices with retainage are created for the supplier in the Purchase invoices window. | |
retainage |
varchar2 |
itgen_vnet_retainagecashaccountid | filters on the platform, writable, ::ancestor. |
Payment settings tab > Retainage settings section > Retainage cash account > The cash account to be used to record retainages for this supplier. | |
retainage |
double |
Retainage Percentage | filters on the platform, writable, ::ancestor. |
Payment settings tab > Retainage settings section > Retainage (%) > The default percent to be retained in invoices for the supplier. | |
status |
varchar2 |
Status | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Status* > The status of the supplier account. | |
supplier |
int32 |
itgen_vnet_supplieraddress_addressid | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
itgen_vnet_supplieraddress_addressline1 | filters on the platform, writable, ::ancestor. |
Address 1 > The first line of the customer's/supplier's/company's/employee's contact address. | |
supplier |
varchar2 |
itgen_vnet_supplieraddress_addressline2 | filters on the platform, writable, ::ancestor. |
Address 2 > The second line of the address. | |
supplier |
varchar2 |
itgen_vnet_supplieraddress_addressline3 | filters on the platform, writable, ::ancestor. |
Address 3 > The third line of the address. | |
supplier |
varchar2 |
itgen_vnet_supplieraddress_city | filters on the platform, writable, ::ancestor. |
City > The city. | |
supplier |
varchar2 |
itgen_vnet_supplieraddress_country_errorinfo | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
itgen_vnet_supplieraddress_country_id | filters on the platform, writable, ::ancestor. |
Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166. | |
supplier |
int64 |
itgen_vnet_supplieraddress_country_metadata_maxpagesize | filters on the platform, writable, ::ancestor. |
||
supplier |
int64 |
itgen_vnet_supplieraddress_country_metadata_totalcount | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
itgen_vnet_supplieraddress_country_name | filters on the platform, writable, ::ancestor. |
Mandatory field: Country name* > The complete name of the country. | |
supplier |
varchar2 |
itgen_vnet_supplieraddress_county_id | filters on the platform, writable, ::ancestor. |
Click the magnifier > The identifier | |
supplier |
varchar2 |
itgen_vnet_supplieraddress_county_name | filters on the platform, writable, ::ancestor. |
Click the magnifier > The displayed name | |
supplier |
varchar2 |
itgen_vnet_supplieraddress_postalcode | filters on the platform, writable, ::ancestor. |
Postcode > The postcode. | |
supplier |
varchar2 |
Supplier Class Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
supplier |
varchar2 |
Supplier Class ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
supplier |
varchar2 |
itgen_vnet_suppliercontact_attention | filters on the platform, writable, ::ancestor. |
Attention > 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. | |
supplier |
int32 |
itgen_vnet_suppliercontact_contactid | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
itgen_vnet_suppliercontact_email | filters on the platform, writable, ::ancestor. |
Email > The email address of the customer/supplier/company as a business entity. | |
supplier |
varchar2 |
itgen_vnet_suppliercontact_fax | filters on the platform, writable, ::ancestor. |
Fax > The fax number. | |
supplier |
varchar2 |
itgen_vnet_suppliercontact_name | filters on the platform, writable, ::ancestor. |
Name > The legal name of to appear on the documents. | |
supplier |
varchar2 |
itgen_vnet_suppliercontact_phone1 | filters on the platform, writable, ::ancestor. |
Phone 1 > The default phone number. | |
supplier |
varchar2 |
itgen_vnet_suppliercontact_phone2 | filters on the platform, writable, ::ancestor. |
Phone 2 > An additional phone number. | |
supplier |
varchar2 |
itgen_vnet_suppliercontact_web | filters on the platform, writable, ::ancestor. |
Web > The website of the company, if one exists. | |
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) | |
vat |
varchar2 |
VAT Registration ID | filters on the platform, writable, ::ancestor. |
Purchase settings tab > Default location settings section > VAT registration ID > The supplier's VAT registration ID associated with the location. | |
vat |
varchar2 |
VAT Zone Default Tax Category Description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
vat |
varchar2 |
VAT Zone Default Tax Category Number | filters on the platform, writable, ::ancestor. |
Number of item | |
vat |
varchar2 |
VAT Zone Default VAT Category | 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. | |
vat |
varchar2 |
VAT Zone 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. | |
vat |
varchar2 |
itgen_vnet_vatzone_errorinfo | filters on the platform, writable, ::ancestor. |
||
vat |
varchar2 |
VAT Zone 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. | |
vat |
int64 |
itgen_vnet_vatzone_metadata_maxpagesize | filters on the platform, writable, ::ancestor. |
||
vat |
int64 |
itgen_vnet_vatzone_metadata_totalcount | filters on the platform, writable, ::ancestor. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: