Please enable JavaScript to view this site.

itgendoc001X

xMsg javascript has not been loaded.

Visma.net Financials API Data Model

Navigation: Schema: Customer > Tables

CustomerClassAttributeDetails

Contents Previous Home Next More

Get Customer Classes - ScreenId=AR201000

Catalog: VismaNet

Schema: Customer

The data in this table is partitioned per value of the COMPANY_CODE column.

This is a read-only table. The Visma.net Financials API may not support changing the data or the Invantive SQL 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.

Select Visma.net Financials API URL: /controller/api/v1/customer/customerClass

Insert Visma.net Financials API URL: /controller/api/v1/customer/customerClass

Update Visma.net Financials API URL: /controller/api/v1/customer/customerClass

Delete Visma.net Financials API URL: /controller/api/v1/customer/customerClass

Field Selection Method: NotRequired

Base Path: attributes[*].details[*]

Select Visma.net Financials API Operation: get /controller/api/v1/customer/customerClass

Table Columns

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

Name

Data Type

Label

Required

Documentation

attributeId

string

Attribute ID

The Attributes tab > Attribute ID > The identifier of the attribute.

attributeType

string

 

 

COMPANY_CODE

string(30)

Company Code

Partition code, segmenting the data.

COMPANY_NAME

string(240)

Company Name

Name of the partition.

defaultValue

string

 

The Attributes tab > Default value > The default value of the attribute.

description_1

string

 

The Attributes tab > Description > A read-only column that displays the detailed description of the attribute.

description_2

string

 

The top part > Description > A detailed description of the customer class.

description

string

Description

Click on the magnifier. > The description.

id_1

string

 

The top part > Class ID> The unique identifier of the class. You can use an alphanumeric string of up to 10 characters.

id

string

ID

Click on the magnifier. > The identifier.

paymentMethodId

string

Payment Method ID

The General information tab > Payment method > The payment method used by default in relations with these customers.

required

boolean

Required

The Attributes tab > Required > This check box indicates (if selected) that the attribute value is required for items of the class.

requiredTaxzoneId

boolean

Required Tax Zone ID

The General information tab > Require VAT zone > A check box that means (if selected) that the VAT zone value is required for customers of the class.

sortOrder

int32

 

The Attributes tab > Sort order > A number that represents the order of the attribute in the list of class attributes.The lower the number, the higher the attribute will be in the list of class attributes.

taxZoneId

string

Tax Zone ID

The General information tab > VAT zone ID >The default VAT zone for customers of the class.

 

06-04-2021 14:55 Version 20.1.393-BETA+3152