Navigation: Catalog: VismaNet > Schemas > Schema: Supplier > Tables

SupplierPaymentMethodDetailsByCode: Visma.net Financials Supplier Payment Method Details by Code

Get a specific supplierData for a single supplier. The response headers include an ETag after a successful GET operation.

Catalog: VismaNet

Schema: Supplier

Label: Supplier Payment Method Details by Code

This is a read-only table function. The Visma.net Financials API may not support changing the data or the Invantive UniversalSQL driver for Visma.net Financials does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Visma.net Financials API.

Parameters of Table Function

The following parameters can be used to control the behaviour of the table function SupplierPaymentMethodDetailsByCode. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values.

Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.

Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.

Name	Data Type	Required	Default Value	Documentation
supplierCd		☑		Identifies the supplier

Columns of Table Function

The columns of the table function SupplierPaymentMethodDetailsByCode are shown below. Each column has an SQL data type.

Name	Data Type	Label	Required	Documentation
accountReference	varchar2	Account Reference	☐	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.
accountUsedForPayment	varchar2		☐	Payment settings tab > Payment settings section > Account used for payment > The bank account to be used for payments to the supplier.
cashAccount	varchar2	Cash Account	☐	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.
chargeBearer	varchar2	Charge Bearer	☐	Payment settings tab > Payment settings section > Charge bearer > The party that will pay possible expenses connected with the payment.
COMPANY_CODE	varchar2(30)	Company Code	☑	Partition code, segmenting the data.
COMPANY_NAME	varchar2(240)	Company Name	☑	Name of the partition.
corporateId	varchar2	Corporate ID	☐	Purchase settings tab > Default location settings section > National insurance no. > The supplier’s national insurance number associated with the location.
creditTerms_description	varchar2	Credit Terms Description	☐	Click on the magnifier. > The description.
creditTerms_id	varchar2	Credit Terms ID	☐	Click on the magnifier. > The identifier.
currencyId	varchar2	Currency ID	☐	General information tab > Financial settings section > Currency ID > The currency that is used in operations with the supplier.
currencyOverride	char		☐	General information tab > Financial settings section > Enable currency override
currencyRateOverride	char		☐	General information tab > Financial settings section > Enable rate override
documentLanguage	varchar2	Document Language	☐	General information tab > Financial settings section > Document language > The language of the documents to be printed to the suppliers of the class.
errorInfo	varchar2	Error Message	☐
glAccounts_expenseAccount_description	varchar2		☐	Name of item/description
glAccounts_expenseAccount_number	varchar2		☐	Number of item
glAccounts_expenseAccount_type	varchar2		☐
glAccounts_expenseAccountImport_description	varchar2		☐	Name of item/description
glAccounts_expenseAccountImport_number	varchar2		☐	Number of item
glAccounts_expenseAccountImport_type	varchar2		☐
glAccounts_expenseAccountNonTax_description	varchar2		☐	Name of item/description
glAccounts_expenseAccountNonTax_number	varchar2		☐	Number of item
glAccounts_expenseAccountNonTax_type	varchar2		☐
glAccounts_expenseEUAccount_description	varchar2		☐	Name of item/description
glAccounts_expenseEUAccount_number	varchar2		☐	Number of item
glAccounts_expenseEUAccount_type	varchar2		☐
glAccounts_expenseSubaccount_active	char		☐
glAccounts_expenseSubaccount_description	varchar2		☐	Click on the magnifier. > The description.
glAccounts_expenseSubaccount_id	varchar2		☐	Click on the magnifier. > The identifier.
glAccounts_supplierAccount_description	varchar2		☐	Name of item/description
glAccounts_supplierAccount_number	varchar2		☐	Number of item
glAccounts_supplierAccount_type	varchar2		☐
glAccounts_supplierSubaccount_active	char		☐
glAccounts_supplierSubaccount_description	varchar2		☐	Click on the magnifier. > The description.
glAccounts_supplierSubaccount_id	varchar2		☐	Click on the magnifier. > The identifier.
internalId	int32	Internal ID	☐
landedCostSupplier	char		☐	General information tab > SupplierProperties > Landed Cost Supplier > Indicates if the supplier is a landed cost supplier or not
lastModifiedDateTime	datetime	Last Modified	☐	System generated information.
location_countryId	varchar2	Location Country ID	☐	Location*.
location_id	varchar2	Location ID	☐	Click the magnifier > The identifier
location_name	varchar2	Location Name	☐	Click the magnifier > The displayed name
mainAddress_addressId	int32	Main Address ID	☐
mainAddress_addressLine1	varchar2	Main Address Line 1	☐	Address 1 > The first line of the customer's/supplier's/company's/employee's contact address.
mainAddress_addressLine2	varchar2	Main Address Line 2	☐	Address 2 > The second line of the address.
mainAddress_addressLine3	varchar2	Main Address Line 3	☐	Address 3 > The third line of the address.
mainAddress_city	varchar2	Main Address City	☐	City > The city.
mainAddress_country_errorInfo	varchar2		☐
mainAddress_country_id	varchar2	Main Address Country ID	☐	Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166.
mainAddress_country_metadata_maxPageSize	int64		☐
mainAddress_country_metadata_totalCount	int64		☐
mainAddress_country_name	varchar2	Main Address Country Name	☐	Mandatory field: Country name* > The complete name of the country.
mainAddress_county_id	varchar2	Main Address County ID	☐	Click the magnifier > The identifier
mainAddress_county_name	varchar2	Main Address County Name	☐	Click the magnifier > The displayed name
mainAddress_postalCode	varchar2	Main Address Postal Code	☐	Postcode > The postcode.
mainContact_attention	varchar2	Main Contact Attention	☐	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.
mainContact_contactId	int32	Main Contact ID	☐
mainContact_email	varchar2	Main Contact Email Address	☐	Email > The email address of the customer/supplier/company as a business entity.
mainContact_fax	varchar2	Fax	☐	Fax > The fax number.
mainContact_name	varchar2	Main Contact Name	☐	Name > The legal name of to appear on the documents.
mainContact_phone1	varchar2	Main Contact Phone 1	☐	Phone 1 > The default phone number.
mainContact_phone2	varchar2	Main Contact Phone 2	☐	Phone 2 > An additional phone number.
mainContact_web	varchar2	Main Contact Website	☐	Web > The website of the company, if one exists.
metadata_maxPageSize	int64	Metadata Max Pagesize	☐
metadata_totalCount	int64	Total Count	☐
naceCode	varchar2		☐	General information tab > Main contact section > Industry Code ID > The supplier's NACE code
name	varchar2	Name	☐	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	☐
number	varchar2	Number	☐	Mandatory field: The top part > Supplier ID* > The ID of the supplier account.
numberOfEmployees	int32	Number of Employees	☐	Legal requirements that all companies with more than 250 employees keep track of their business accounts
parentRecord_name	varchar2	Parent Record Name	☐	Click the magnifier. > The name.
parentRecord_number	varchar2	Parent Record Number	☐	Click the magnifier. > The identifier.
paymentBy	varchar2	Payment by	☐	Payment settings tab > Payment settings section > Payment by > An option that defines how to calculate the date when this supplier should be paid.
paymentLeadTime	int32		☐	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.
paymentMethod_description	varchar2	Payment Method Description	☐	Click on the magnifier. > The description.
paymentMethod_id	varchar2	Payment Method ID	☐	Click on the magnifier. > The identifier.
paymentMethodDetailBankingDetailType	varchar2		☐	Payment method banking detail type
paymentMethodDetailDescription	varchar2		☐	The description of the payment method detail.
paymentMethodDetailID	varchar2		☐	payment method detail ID
paymentMethodDetailValue	varchar2		☐	The ID of the payment method detail.
paymentRefDisplayMask	varchar2		☐	Payment settings tab > Payment settings section > Payment ref. display mask > This is a rule (mask) for how the payment reference number will be displayed.
paySeparately	char		☐	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.
remitAddress_addressId	int32		☐
remitAddress_addressLine1	varchar2		☐	Address 1 > The first line of the customer's/supplier's/company's/employee's contact address.
remitAddress_addressLine2	varchar2		☐	Address 2 > The second line of the address.
remitAddress_addressLine3	varchar2		☐	Address 3 > The third line of the address.
remitAddress_city	varchar2		☐	City > The city.
remitAddress_country_errorInfo	varchar2		☐
remitAddress_country_id	varchar2		☐	Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166.
remitAddress_country_metadata_maxPageSize	int64		☐
remitAddress_country_metadata_totalCount	int64		☐
remitAddress_country_name	varchar2		☐	Mandatory field: Country name* > The complete name of the country.
remitAddress_county_id	varchar2		☐	Click the magnifier > The identifier
remitAddress_county_name	varchar2		☐	Click the magnifier > The displayed name
remitAddress_postalCode	varchar2		☐	Postcode > The postcode.
remitContact_attention	varchar2		☐	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.
remitContact_contactId	int32		☐
remitContact_email	varchar2		☐	Email > The email address of the customer/supplier/company as a business entity.
remitContact_fax	varchar2		☐	Fax > The fax number.
remitContact_name	varchar2		☐	Name > The legal name of to appear on the documents.
remitContact_phone1	varchar2		☐	Phone 1 > The default phone number.
remitContact_phone2	varchar2		☐	Phone 2 > An additional phone number.
remitContact_web	varchar2		☐	Web > The website of the company, if one exists.
retainageApply	char		☐	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.
retainageCashAccountID	varchar2		☐	Payment settings tab > Retainage settings section > Retainage cash account > The cash account to be used to record retainages for this supplier.
retainagePct	double	Retainage Percentage	☐	Payment settings tab > Retainage settings section > Retainage (%) > The default percent to be retained in invoices for the supplier.
status	varchar2	Status	☐	Mandatory field: The top part > Status* > The status of the supplier account.
supplierAddress_addressId	int32		☐
supplierAddress_addressLine1	varchar2		☐	Address 1 > The first line of the customer's/supplier's/company's/employee's contact address.
supplierAddress_addressLine2	varchar2		☐	Address 2 > The second line of the address.
supplierAddress_addressLine3	varchar2		☐	Address 3 > The third line of the address.
supplierAddress_city	varchar2		☐	City > The city.
supplierAddress_country_errorInfo	varchar2		☐
supplierAddress_country_id	varchar2		☐	Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166.
supplierAddress_country_metadata_maxPageSize	int64		☐
supplierAddress_country_metadata_totalCount	int64		☐
supplierAddress_country_name	varchar2		☐	Mandatory field: Country name* > The complete name of the country.
supplierAddress_county_id	varchar2		☐	Click the magnifier > The identifier
supplierAddress_county_name	varchar2		☐	Click the magnifier > The displayed name
supplierAddress_postalCode	varchar2		☐	Postcode > The postcode.
supplierClass_description	varchar2	Supplier Class Description	☐	Click on the magnifier. > The description.
supplierClass_id	varchar2	Supplier Class ID	☐	Click on the magnifier. > The identifier.
supplierContact_attention	varchar2		☐	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.
supplierContact_contactId	int32		☐
supplierContact_email	varchar2		☐	Email > The email address of the customer/supplier/company as a business entity.
supplierContact_fax	varchar2		☐	Fax > The fax number.
supplierContact_name	varchar2		☐	Name > The legal name of to appear on the documents.
supplierContact_phone1	varchar2		☐	Phone 1 > The default phone number.
supplierContact_phone2	varchar2		☐	Phone 2 > An additional phone number.
supplierContact_web	varchar2		☐	Web > The website of the company, if one exists.
timeStamp	blob	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	☐	Purchase settings tab > Default location settings section > VAT registration ID > The supplier's VAT registration ID associated with the location.
vatZone_defaultTaxCategory_description	varchar2	VAT Zone Default Tax Category Description	☐	Name of item/description
vatZone_defaultTaxCategory_number	varchar2	VAT Zone Default Tax Category Number	☐	Number of item
vatZone_defaultVatCategory	varchar2	VAT Zone Default VAT Category	☐	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	☐	Click the magnifier. The description for the VAT zone of the supplier, which is specified in the AP303000 window.
vatZone_errorInfo	varchar2		☐
vatZone_id	varchar2	VAT Zone ID	☐	Click the magnifier. The identifier for the VAT zone of the supplier, which is specified in the AP303000 window.
vatZone_metadata_maxPageSize	int64		☐
vatZone_metadata_totalCount	int64		☐

Please enable JavaScript to view this site.

Visma.net Financials API Data Model

SupplierPaymentMethodDetailsByCode: Visma.net Financials Supplier Payment Method Details by Code

Parameters of Table Function

Columns of Table Function

Important Safety and Usage Information