CustomerAttributesByCode: Visma.net Financials Customer Attributes by Code
read only REST
- Catalog:
VismaNet - Schema:
Customer - Label: Customer Attributes by Code
Get a specific customer Data for the customer The response headers include an ETag after a successful GET operation.
Can only retrieve data.
Summary
Data for the customer
The response headers include an ETag after a successful GET operation.
API Source
- Endpoint:
/v1/customer/{customerCd} - Operation:
get /v1/customer/{customerCd}
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 |
|---|---|---|---|---|
customer |
`` | Identifies the customer |
Table Columns
The columns of the table CustomerAttributesByCode 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. | |
accept |
char |
Accept Auto-invoices | filters on the platform, writable, ::ancestor. |
Invoicing settings > Print and email settings section > Send invoices to AutoInvoice > Select this check box if you are using AutoInvoice and want to send invoices directly to this service. | |
account |
varchar2 |
Account Reference | filters on the platform, writable, ::ancestor. |
General information tab > Main contact section > Account ref. > Your company's account number in the customer's system. | |
corporate |
varchar2 |
Corporate ID | filters on the platform, writable, ::ancestor. |
Delivery settings tab > Default location settings section > Corporate ID > The customers company ID, associated with the location. | |
created |
datetime |
Created | filters on the platform, writable, ::ancestor. |
Information collected from the system. Not visible on the screen. | |
credit |
int32 |
Credit Days Past Due | filters on the platform, writable, ::ancestor. |
General information tab > Credit verification rules section > Credit days past due > The maximum number of days by which the customer payment may exceed the invoice date. | |
credit |
double |
Credit Limit | filters on the platform, writable, ::ancestor. |
The General information tab > Credit verification rules section > Credit limit > The amount, if applicable, that serves as a credit limit for the customer. | |
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. | |
credit |
varchar2 |
Credit Verification | filters on the platform, writable, ::ancestor. |
The General information tab > Credit verification rules > Credit verification > The credit rule applied to this customer. The following options are available: Days past due, Credit limit, Limit and days past due, disabled. | |
currency |
varchar2 |
Currency ID | filters on the platform, writable, ::ancestor. |
The General information tab > Financial settings section > Currency ID > The currency used in operations with the customer, which you can select from the list of currencies defined in the system. | |
customer |
varchar2 |
Customer Class Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
customer |
varchar2 |
Customer Class ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
default |
varchar2 |
itgen_vnet_defaultpaymentmethodid | filters on the platform, writable, ::ancestor. |
Invoicing settings tab > Default payment method section > The default payment method. | |
delivery |
int32 |
Delivery Address ID | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Delivery 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. | |
delivery |
varchar2 |
Delivery Address Line 2 | filters on the platform, writable, ::ancestor. |
Address 2 > The second line of the address. | |
delivery |
varchar2 |
Delivery Address Line 3 | filters on the platform, writable, ::ancestor. |
Address 3 > The third line of the address. | |
delivery |
varchar2 |
Delivery Address City | filters on the platform, writable, ::ancestor. |
City > The city. | |
delivery |
varchar2 |
itgen_vnet_deliveryaddress_country_errorinfo | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Delivery 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. | |
delivery |
int64 |
itgen_vnet_deliveryaddress_country_metadata_maxpagesize | filters on the platform, writable, ::ancestor. |
||
delivery |
int64 |
itgen_vnet_deliveryaddress_country_metadata_totalcount | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Delivery Address Country Name | filters on the platform, writable, ::ancestor. |
Mandatory field: Country name* > The complete name of the country. | |
delivery |
varchar2 |
Delivery Address County ID | filters on the platform, writable, ::ancestor. |
Click the magnifier > The identifier | |
delivery |
varchar2 |
Delivery Address County Name | filters on the platform, writable, ::ancestor. |
Click the magnifier > The displayed name | |
delivery |
varchar2 |
Delivery Address Postal Code | filters on the platform, writable, ::ancestor. |
Postcode > The postcode. | |
delivery |
varchar2 |
Delivery 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. | |
delivery |
int32 |
Delivery Contact ID | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Delivery Contact Email Address | filters on the platform, writable, ::ancestor. |
Email > The email address of the customer/supplier/company as a business entity. | |
delivery |
varchar2 |
Delivery Contact Fax | filters on the platform, writable, ::ancestor. |
Fax > The fax number. | |
delivery |
varchar2 |
Delivery Contact Name | filters on the platform, writable, ::ancestor. |
Name > The legal name of to appear on the documents. | |
delivery |
varchar2 |
Delivery Contact Phone 1 | filters on the platform, writable, ::ancestor. |
Phone 1 > The default phone number. | |
delivery |
varchar2 |
Delivery Contact Phone 2 | filters on the platform, writable, ::ancestor. |
Phone 2 > An additional phone number. | |
delivery |
varchar2 |
Delivery Contact Website | filters on the platform, writable, ::ancestor. |
Web > The website of the company, if one exists. | |
description |
varchar2 |
Description | writable, description |
Attribute > The description of the attribute. | |
e |
varchar2 |
itgen_vnet_einvoicecontract_finvoicecontractid | filters on the platform, writable, ::ancestor. |
||
e |
varchar2 |
itgen_vnet_einvoicecontract_finvoiceintermediatorid | filters on the platform, writable, ::ancestor. |
||
error |
varchar2 |
Error Message | filters on the platform, writable, ::ancestor. |
||
exclude |
char |
itgen_vnet_excludedebtcollection | filters on the platform, writable, ::ancestor. |
Exclude Debt Collection for Autocollect | |
gl |
varchar2 |
itgen_vnet_glaccounts_cashdiscountaccount_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
gl |
varchar2 |
itgen_vnet_glaccounts_cashdiscountaccount_number | filters on the platform, writable, ::ancestor. |
Number of item | |
gl |
varchar2 |
itgen_vnet_glaccounts_cashdiscountaccount_type | filters on the platform, writable, ::ancestor. |
||
gl |
char |
itgen_vnet_glaccounts_cashdiscountsubaccount_active | filters on the platform, writable, ::ancestor. |
Active > The status of the identifier. | |
gl |
varchar2 |
itgen_vnet_glaccounts_cashdiscountsubaccount_description | filters on the platform, writable, ::ancestor. |
Description > The description of the identifier. | |
gl |
varchar2 |
itgen_vnet_glaccounts_cashdiscountsubaccount_errorinfo | filters on the platform, writable, ::ancestor. |
||
gl |
datetime |
itgen_vnet_glaccounts_cashdiscountsubaccount_lastmodifieddatetime | filters on the platform, writable, ::ancestor. |
System generated information. | |
gl |
int64 |
itgen_vnet_glaccounts_cashdiscountsubaccount_metadata_maxpagesize | filters on the platform, writable, ::ancestor. |
||
gl |
int64 |
itgen_vnet_glaccounts_cashdiscountsubaccount_metadata_totalcount | filters on the platform, writable, ::ancestor. |
||
gl |
int32 |
itgen_vnet_glaccounts_cashdiscountsubaccount_subaccountid | filters on the platform, writable, ::ancestor. |
SubID > The identifier of the subaccount. | |
gl |
varchar2 |
itgen_vnet_glaccounts_cashdiscountsubaccount_subaccountnumber | filters on the platform, writable, ::ancestor. |
Mandatory field: Subaccount* > The subaccount number. Format 9-XX. | |
gl |
blob |
itgen_vnet_glaccounts_cashdiscountsubaccount_timestamp | filters on the platform, writable, ::ancestor. |
The timestamp of the subaccount, used for concurrency control. | |
gl |
varchar2 |
itgen_vnet_glaccounts_customerledgeraccount_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
gl |
varchar2 |
itgen_vnet_glaccounts_customerledgeraccount_number | filters on the platform, writable, ::ancestor. |
Number of item | |
gl |
varchar2 |
itgen_vnet_glaccounts_customerledgeraccount_type | filters on the platform, writable, ::ancestor. |
||
gl |
char |
itgen_vnet_glaccounts_customerledgersubaccount_active | filters on the platform, writable, ::ancestor. |
Active > The status of the identifier. | |
gl |
varchar2 |
itgen_vnet_glaccounts_customerledgersubaccount_description | filters on the platform, writable, ::ancestor. |
Description > The description of the identifier. | |
gl |
varchar2 |
itgen_vnet_glaccounts_customerledgersubaccount_errorinfo | filters on the platform, writable, ::ancestor. |
||
gl |
datetime |
itgen_vnet_glaccounts_customerledgersubaccount_lastmodifieddatetime | filters on the platform, writable, ::ancestor. |
System generated information. | |
gl |
int64 |
itgen_vnet_glaccounts_customerledgersubaccount_metadata_maxpagesize | filters on the platform, writable, ::ancestor. |
||
gl |
int64 |
itgen_vnet_glaccounts_customerledgersubaccount_metadata_totalcount | filters on the platform, writable, ::ancestor. |
||
gl |
int32 |
itgen_vnet_glaccounts_customerledgersubaccount_subaccountid | filters on the platform, writable, ::ancestor. |
SubID > The identifier of the subaccount. | |
gl |
varchar2 |
itgen_vnet_glaccounts_customerledgersubaccount_subaccountnumber | filters on the platform, writable, ::ancestor. |
Mandatory field: Subaccount* > The subaccount number. Format 9-XX. | |
gl |
blob |
itgen_vnet_glaccounts_customerledgersubaccount_timestamp | filters on the platform, writable, ::ancestor. |
The timestamp of the subaccount, used for concurrency control. | |
gl |
varchar2 |
itgen_vnet_glaccounts_discountaccount_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
gl |
varchar2 |
itgen_vnet_glaccounts_discountaccount_number | filters on the platform, writable, ::ancestor. |
Number of item | |
gl |
varchar2 |
itgen_vnet_glaccounts_discountaccount_type | filters on the platform, writable, ::ancestor. |
||
gl |
char |
itgen_vnet_glaccounts_discountsubaccount_active | filters on the platform, writable, ::ancestor. |
Active > The status of the identifier. | |
gl |
varchar2 |
itgen_vnet_glaccounts_discountsubaccount_description | filters on the platform, writable, ::ancestor. |
Description > The description of the identifier. | |
gl |
varchar2 |
itgen_vnet_glaccounts_discountsubaccount_errorinfo | filters on the platform, writable, ::ancestor. |
||
gl |
datetime |
itgen_vnet_glaccounts_discountsubaccount_lastmodifieddatetime | filters on the platform, writable, ::ancestor. |
System generated information. | |
gl |
int64 |
itgen_vnet_glaccounts_discountsubaccount_metadata_maxpagesize | filters on the platform, writable, ::ancestor. |
||
gl |
int64 |
itgen_vnet_glaccounts_discountsubaccount_metadata_totalcount | filters on the platform, writable, ::ancestor. |
||
gl |
int32 |
itgen_vnet_glaccounts_discountsubaccount_subaccountid | filters on the platform, writable, ::ancestor. |
SubID > The identifier of the subaccount. | |
gl |
varchar2 |
itgen_vnet_glaccounts_discountsubaccount_subaccountnumber | filters on the platform, writable, ::ancestor. |
Mandatory field: Subaccount* > The subaccount number. Format 9-XX. | |
gl |
blob |
itgen_vnet_glaccounts_discountsubaccount_timestamp | filters on the platform, writable, ::ancestor. |
The timestamp of the subaccount, used for concurrency control. | |
gl |
varchar2 |
itgen_vnet_glaccounts_freightaccount_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
gl |
varchar2 |
itgen_vnet_glaccounts_freightaccount_number | filters on the platform, writable, ::ancestor. |
Number of item | |
gl |
varchar2 |
itgen_vnet_glaccounts_freightaccount_type | filters on the platform, writable, ::ancestor. |
||
gl |
char |
itgen_vnet_glaccounts_freightsubaccount_active | filters on the platform, writable, ::ancestor. |
Active > The status of the identifier. | |
gl |
varchar2 |
itgen_vnet_glaccounts_freightsubaccount_description | filters on the platform, writable, ::ancestor. |
Description > The description of the identifier. | |
gl |
varchar2 |
itgen_vnet_glaccounts_freightsubaccount_errorinfo | filters on the platform, writable, ::ancestor. |
||
gl |
datetime |
itgen_vnet_glaccounts_freightsubaccount_lastmodifieddatetime | filters on the platform, writable, ::ancestor. |
System generated information. | |
gl |
int64 |
itgen_vnet_glaccounts_freightsubaccount_metadata_maxpagesize | filters on the platform, writable, ::ancestor. |
||
gl |
int64 |
itgen_vnet_glaccounts_freightsubaccount_metadata_totalcount | filters on the platform, writable, ::ancestor. |
||
gl |
int32 |
itgen_vnet_glaccounts_freightsubaccount_subaccountid | filters on the platform, writable, ::ancestor. |
SubID > The identifier of the subaccount. | |
gl |
varchar2 |
itgen_vnet_glaccounts_freightsubaccount_subaccountnumber | filters on the platform, writable, ::ancestor. |
Mandatory field: Subaccount* > The subaccount number. Format 9-XX. | |
gl |
blob |
itgen_vnet_glaccounts_freightsubaccount_timestamp | filters on the platform, writable, ::ancestor. |
The timestamp of the subaccount, used for concurrency control. | |
gl |
varchar2 |
itgen_vnet_glaccounts_prepaymentaccount_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
gl |
varchar2 |
itgen_vnet_glaccounts_prepaymentaccount_number | filters on the platform, writable, ::ancestor. |
Number of item | |
gl |
varchar2 |
itgen_vnet_glaccounts_prepaymentaccount_type | filters on the platform, writable, ::ancestor. |
||
gl |
char |
itgen_vnet_glaccounts_prepaymentsubaccount_active | filters on the platform, writable, ::ancestor. |
Active > The status of the identifier. | |
gl |
varchar2 |
itgen_vnet_glaccounts_prepaymentsubaccount_description | filters on the platform, writable, ::ancestor. |
Description > The description of the identifier. | |
gl |
varchar2 |
itgen_vnet_glaccounts_prepaymentsubaccount_errorinfo | filters on the platform, writable, ::ancestor. |
||
gl |
datetime |
itgen_vnet_glaccounts_prepaymentsubaccount_lastmodifieddatetime | filters on the platform, writable, ::ancestor. |
System generated information. | |
gl |
int64 |
itgen_vnet_glaccounts_prepaymentsubaccount_metadata_maxpagesize | filters on the platform, writable, ::ancestor. |
||
gl |
int64 |
itgen_vnet_glaccounts_prepaymentsubaccount_metadata_totalcount | filters on the platform, writable, ::ancestor. |
||
gl |
int32 |
itgen_vnet_glaccounts_prepaymentsubaccount_subaccountid | filters on the platform, writable, ::ancestor. |
SubID > The identifier of the subaccount. | |
gl |
varchar2 |
itgen_vnet_glaccounts_prepaymentsubaccount_subaccountnumber | filters on the platform, writable, ::ancestor. |
Mandatory field: Subaccount* > The subaccount number. Format 9-XX. | |
gl |
blob |
itgen_vnet_glaccounts_prepaymentsubaccount_timestamp | filters on the platform, writable, ::ancestor. |
The timestamp of the subaccount, used for concurrency control. | |
gl |
varchar2 |
Sales Account Description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
gl |
varchar2 |
Sales Account Number | filters on the platform, writable, ::ancestor. |
Number of item | |
gl |
varchar2 |
Sales Account Type | filters on the platform, writable, ::ancestor. |
||
gl |
varchar2 |
itgen_vnet_glaccounts_saleseuaccount_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
gl |
varchar2 |
itgen_vnet_glaccounts_saleseuaccount_number | filters on the platform, writable, ::ancestor. |
Number of item | |
gl |
varchar2 |
itgen_vnet_glaccounts_saleseuaccount_type | filters on the platform, writable, ::ancestor. |
||
gl |
varchar2 |
itgen_vnet_glaccounts_salesexportaccount_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
gl |
varchar2 |
itgen_vnet_glaccounts_salesexportaccount_number | filters on the platform, writable, ::ancestor. |
Number of item | |
gl |
varchar2 |
itgen_vnet_glaccounts_salesexportaccount_type | filters on the platform, writable, ::ancestor. |
||
gl |
varchar2 |
itgen_vnet_glaccounts_salesnontaxableaccount_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
gl |
varchar2 |
itgen_vnet_glaccounts_salesnontaxableaccount_number | filters on the platform, writable, ::ancestor. |
Number of item | |
gl |
varchar2 |
itgen_vnet_glaccounts_salesnontaxableaccount_type | filters on the platform, writable, ::ancestor. |
||
gl |
char |
itgen_vnet_glaccounts_salessubaccount_active | filters on the platform, writable, ::ancestor. |
Active > The status of the identifier. | |
gl |
varchar2 |
itgen_vnet_glaccounts_salessubaccount_description | filters on the platform, writable, ::ancestor. |
Description > The description of the identifier. | |
gl |
varchar2 |
itgen_vnet_glaccounts_salessubaccount_errorinfo | filters on the platform, writable, ::ancestor. |
||
gl |
datetime |
itgen_vnet_glaccounts_salessubaccount_lastmodifieddatetime | filters on the platform, writable, ::ancestor. |
System generated information. | |
gl |
int64 |
itgen_vnet_glaccounts_salessubaccount_metadata_maxpagesize | filters on the platform, writable, ::ancestor. |
||
gl |
int64 |
itgen_vnet_glaccounts_salessubaccount_metadata_totalcount | filters on the platform, writable, ::ancestor. |
||
gl |
int32 |
itgen_vnet_glaccounts_salessubaccount_subaccountid | filters on the platform, writable, ::ancestor. |
SubID > The identifier of the subaccount. | |
gl |
varchar2 |
itgen_vnet_glaccounts_salessubaccount_subaccountnumber | filters on the platform, writable, ::ancestor. |
Mandatory field: Subaccount* > The subaccount number. Format 9-XX. | |
gl |
blob |
itgen_vnet_glaccounts_salessubaccount_timestamp | filters on the platform, writable, ::ancestor. |
The timestamp of the subaccount, used for concurrency control. | |
gln |
varchar2 |
GLN | filters on the platform, writable, ::ancestor. |
Delivery settings tab > Default location settings section > GLN > The Global Location Number, associated with the location. | |
id |
varchar2 |
ID | writable, id |
||
internal |
int32 |
Internal ID | filters on the platform, writable, ::ancestor. |
||
invoice |
int32 |
Invoice Address ID | filters on the platform, writable, ::ancestor. |
||
invoice |
varchar2 |
Invoice 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. | |
invoice |
varchar2 |
Invoice Address Line 2 | filters on the platform, writable, ::ancestor. |
Address 2 > The second line of the address. | |
invoice |
varchar2 |
Invoice Address Line 3 | filters on the platform, writable, ::ancestor. |
Address 3 > The third line of the address. | |
invoice |
varchar2 |
Invoice Address City | filters on the platform, writable, ::ancestor. |
City > The city. | |
invoice |
varchar2 |
Invoice Address Country Error Information | filters on the platform, writable, ::ancestor. |
||
invoice |
varchar2 |
Invoice 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. | |
invoice |
int64 |
itgen_vnet_invoiceaddress_country_metadata_maxpagesize | filters on the platform, writable, ::ancestor. |
||
invoice |
int64 |
itgen_vnet_invoiceaddress_country_metadata_totalcount | filters on the platform, writable, ::ancestor. |
||
invoice |
varchar2 |
Invoice Address Country Name | filters on the platform, writable, ::ancestor. |
Mandatory field: Country name* > The complete name of the country. | |
invoice |
varchar2 |
Invoice Address County ID | filters on the platform, writable, ::ancestor. |
Click the magnifier > The identifier | |
invoice |
varchar2 |
Invoice Address County Name | filters on the platform, writable, ::ancestor. |
Click the magnifier > The displayed name | |
invoice |
varchar2 |
Invoice Address Postal Code | filters on the platform, writable, ::ancestor. |
Postcode > The postcode. | |
invoice |
varchar2 |
Invoice 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. | |
invoice |
int32 |
Invoice Contact ID | filters on the platform, writable, ::ancestor. |
||
invoice |
varchar2 |
Invoice Contact Email Address | filters on the platform, writable, ::ancestor. |
Email > The email address of the customer/supplier/company as a business entity. | |
invoice |
varchar2 |
Invoice Contact Fax | filters on the platform, writable, ::ancestor. |
Fax > The fax number. | |
invoice |
varchar2 |
Invoice Contact Name | filters on the platform, writable, ::ancestor. |
Name > The legal name of to appear on the documents. | |
invoice |
varchar2 |
Invoice Contact Phone 1 | filters on the platform, writable, ::ancestor. |
Phone 1 > The default phone number. | |
invoice |
varchar2 |
Invoice Contact Phone 2 | filters on the platform, writable, ::ancestor. |
Phone 2 > An additional phone number. | |
invoice |
varchar2 |
Invoice Contact Website | filters on the platform, writable, ::ancestor. |
Web > The website of the company, if one exists. | |
invoice |
char |
itgen_vnet_invoiceordersseparately | filters on the platform, writable, ::ancestor. |
The Billing settings tab > Order consolidation section > Invoice orders separately > Indicates whether the customer should be invoiced separately. | |
invoice |
char |
Invoice to Default Location | filters on the platform, writable, ::ancestor. |
Delivery settings tab > Default location settings > Invoice to default location > A check box indicating that the default location is to be used. | |
last |
datetime |
Last Modified | filters on the platform, writable, ::ancestor. |
Information collected from the system. Not visible on the screen. | |
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. |
||
name |
varchar2 |
Name | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Customer name* > The name of the customer to appear in the system, which may be a trade name or a doing-business-as (DBA) name. | |
number |
varchar2 |
Number | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Customer ID* > The ID of the customer account, which is defined by the BIZACCT segmented key or by the CUSTOMER segmented key. When you are creating a new customer, you must specify an ID. | |
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. | |
price |
varchar2 |
Price Class Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
price |
varchar2 |
Price Class ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
print |
char |
Print Dunning Letters | filters on the platform, writable, ::ancestor. |
Invoicing settings > Email settings section > A check box that, if selected, indicates that statements can be send to email (AR503500) window. | |
print |
char |
Print Invoices | filters on the platform, writable, ::ancestor. |
Invoicing settings > Print and email settings section > Print invoices > A check box that, if selected, indicates that invoices can be printed in the Print invoice (AR508000) window. | |
print |
char |
Print Multi-Currency Statements | filters on the platform, writable, ::ancestor. |
Invoicing settings > Print and email settings section > Multi-currency statements > A check box that indicates (if selected) that this customer's statements must be printed in multi-currency format. | |
print |
char |
Print Statements | filters on the platform, writable, ::ancestor. |
Invoicing settings > Print settings section > A check box that, if selected, indicates that statements can be printed in the to email (AR503500) window. | |
send |
char |
Send Dunning Letters via Email | filters on the platform, writable, ::ancestor. |
Invoicing settings > Print and email settings section > Print statements > A check box that, if selected, indicates that statements can be printed in the Print statements (AR503500) window. | |
send |
char |
Send Invoices by Email | filters on the platform, writable, ::ancestor. |
Invoicing settings > Print and email settings section > Send invoices by email > A check box that, if selected, indicates that you can send invoices by email by using the Print invoices (AR508000) window. | |
send |
char |
Send Statements by Email | filters on the platform, writable, ::ancestor. |
Invoicing settings > Print and email settings section > Send statement by email > A check box that, if selected, indicates that statements can be sent by email to customers of the class in the Print statements (AR503500) window. | |
statement |
varchar2 |
Statement Type | filters on the platform, writable, ::ancestor. |
Invoicing settings > Print and email settings section > Statement type > The statement type used by default in relations with the customer, which can be one of the following: Open item, Balance brought forward. | |
status |
varchar2 |
Status | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Status* > The status of the customer account. You can select one of the following options: Active, On hold, Credit hold, Inactive, One time. | |
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) | |
value |
varchar2 |
Value | writable, value |
Value > The value of the attribute. | |
vat |
varchar2 |
VAT Registration ID | filters on the platform, writable, ::ancestor. |
Deliver settings tab > Default location settings section > VAT registration ID > The customer's taxpayer 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: