AccountByName |
Catalog: Severa
Schema: API
This is a read-only table function. The Visma Severa API may not support changing the data or the Invantive SQL driver for Visma Severa does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Visma Severa API.
Action: http://soap.severa.com/IAccount/GetAccountByName
Topic: GetAccountByName
Base XPath: /s:Envelope/s:Body/tns:GetAccountByNameResponse/tns:GetAccountByNameResult
Filters on API Server: accountName
Table Function Columns
The columns of the table function AccountByName are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
ACCOUNTGROUPGUIDS_STRING |
string |
|
|
|
ACCOUNTOWNERUSERGUID |
string |
|
|
|
ACCOUNTRATING |
int32 |
|
|
|
COMPANYGUID |
string |
|
|
|
CURRENCYCODE |
string |
|
|
|
CURRENCYGUID |
string |
|
|
|
EINVOICEADDRESS |
string |
|
|
|
EINVOICEOPERATOR |
string |
|
|
|
GUID |
string |
|
|
|
INSERTTS |
datetime |
|
|
|
INVOICINGVAT |
decimal |
|
|
|
ISACTIVE |
boolean |
|
|
|
ISINTERNAL |
boolean |
|
|
|
LANGUAGECODE |
string |
|
|
|
LANGUAGEGUID |
string |
|
|
|
NAME |
string |
|
|
|
NOTES |
string |
|
|
|
NUMBER |
int64 |
|
|
|
OVERDUEINTEREST |
decimal |
|
|
|
PAYMENTTERM |
int32 |
|
|
|
PRICELISTGUID |
string |
|
|
|
REVERSECHARGE |
boolean |
|
|
|
REVERSECHARGEDESCRIPTION |
string |
|
|
|
UPDATEDTS |
datetime |
|
|
|
URLTOACCOUNT |
string |
|
|
|
29-05-2022 01:10 Version 22.0.196-PROD+3400