API GetProviderInformations: Porovnání verzí
Z Podpora.nextis.cz
| Řádka 37: | Řádka 37: | ||
|ZIPCode | |ZIPCode | ||
|nvarchar(15) | |nvarchar(15) | ||
| − | |ZIP | + | |ZIP code |
| | | | ||
|- | |- | ||
Verze z 25. 7. 2017, 13:56
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 | |
| nvarchar(70) | |||
| 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.
