API GetProviderInformations

Description

Method gives You overview of existing provider informations in system

Exact name

API_GetProviderInformations

Type

Standard view.

Specification

Column	Data type	Description	Relation
ID	int	Internal system id
Name	nvarchar(150)	Provider name
Street	nvarchar(200)	Street
City	nvarchar(120)	City
ZIPCode	nvarchar(15)	ZIP Code
Country	nvarchar(70)	Country
Region	nvarchar(70)	Region
State	nvarchar(80)	State
StateID	int	ID of country from country list (see relation)	API_GetCountry.ID
Phone	nvarchar(50)	Phone
Phone2	nvarchar(50)	Phone 2
Fax	nvarchar(50)	Fax
MobilePhone	nvarchar(50)	Mobile phone
Email	nvarchar(70)	Email
Email2	nvarchar(70)	Email 2
Web	nvarchar(150)	Web address
CompanyRegistrationNumber	nvarchar(20)	Company registration number
VATNumber	nvarchar(25)	VAT Number
VATNumber2	char(20)	VAT Number 2
IsVATPayer	int	Is VAT Payer
FileMark	nvarchar(50)	File mark
FileMark2	nvarchar(50)	File mark 2
FileMark3	nvarchar(50)	File mark 3
FileMark4	nvarchar(50)	File mark 4

Example

SELECT TOP 1000 * FROM [API_GetProviderInformations]

Notices

None.