CustomerDirectDebitLines: Visma.net Financials Customer Direct Debit Lines
read only REST
- Catalog:
VismaNet - Schema:
Customer - Label: Customer Direct Debit Lines
Get a range of customers - ScreenId=AR303000
Can only retrieve data.
API Source
- Endpoint:
/v1/customer - Operation:
get /v1/customer
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 |
`` | Attributes (additional information) connected to the entity. Examples: {{base}}/customer?attributes={"AttributeID":"ValueID","AttributeID":"ValueID"} {{base}}/customer?attributes={"AttributeID":"ValueID1,ValueID2"} | ||
corporate |
`` | Equals Corporate ID from Delivery settings tab. | ||
created |
`` | This value, generated by the system, indicates the creation date and time. Use it to retrieve all records that have been created since that time, up to the present. Accepted format: * yyyy- * yyyy- * yyyy- * yyyy- * yyyy- Note: CreatedDateTime and CreatedDateTimeCondition are mutually inclusive. |
||
created |
`` | This value represents the condition to be applied when retrieving records. Accepted values (without the single quotes): * '>' for greater than * '<' for less than * '>=' for greater than or equal * '<=' for less than or equal Note: CreatedDateTime and CreatedDateTimeCondition are mutually inclusive. | ||
email |
`` | Equals Email for customer. | ||
expand |
`` | |||
expand |
`` | Expand direct debit info | ||
expand |
`` | |||
greater |
`` | This field does not work and has been deprecated. It will be removed in future versions. | ||
last |
`` | 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- * yyyy- * yyyy- * yyyy- * yyyy- Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive. |
||
last |
`` | This value represents the condition to be applied when retrieving records. Accepted values (without the single quotes): * '>' for greater than * '<' for less than * '>=' for greater than or equal * '<=' for less than or equal Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive. | ||
name |
`` | Contains Customer name. | ||
phone |
`` | Equals Phone 1 for customer. | ||
status |
`` | Drop down and select Status. (Values: Active, OnHold, CreditHold, Inactive, OneTime) | ||
vat |
`` | Equals VAT registration ID from Delivery settings tab. |
Table Columns
The columns of the table CustomerDirectDebitLines 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. | |
bic |
varchar2 |
BIC | writable, bic |
||
branch |
varchar2 |
Branch | writable, branch |
||
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. | |
date |
datetime |
Date of Signature | writable, date |
||
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. | |
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 | |
expiration |
datetime |
Expiration Date | writable, expiration |
||
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. | |
iban |
varchar2 |
IBAN | writable, iban |
||
id |
guid |
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. | |
is |
char |
Is Default | writable, is |
||
last |
datetime |
Last Collection Date | writable, last |
||
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. | |
mandate |
varchar2 |
Mandate Description | writable, mandate |
||
mandate |
varchar2 |
Mandate ID | writable, mandate |
||
max |
double |
Maximum Amount | writable, max |
||
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 | |
one |
char |
One-time | writable, one |
||
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) | |
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. |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Customer |
credit |
CreditTermRecords. |
Key | |
Customer |
currency |
Currencies.id |
Key | |
Customer |
customer |
CustomerClasses.id |
Key | |
Customer |
default |
PaymentMethods. |
Key | |
Customer |
location_ |
Countries.id |
Key | |
Customer |
vat |
VatZones.id |
Key |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: