API GetProductService: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „s“) |
|||
| (Není zobrazena jedna mezilehlá verze od stejného uživatele.) | |||
| Řádka 1: | Řádka 1: | ||
| − | + | ==== Description ==== | |
| + | Method gives You overview of existing product service in system. | ||
| + | |||
| + | ==== Exact name ==== | ||
| + | <code>API_GetProductService</code> | ||
| + | |||
| + | ==== Type ==== | ||
| + | Standard view. | ||
| + | |||
| + | ==== Specification ==== | ||
| + | {| class="wikitable" | ||
| + | !Column | ||
| + | !Data type | ||
| + | !Description | ||
| + | !Relation | ||
| + | |- | ||
| + | |ID | ||
| + | |int | ||
| + | |Internal system id | ||
| + | | | ||
| + | |- | ||
| + | |ProductCode | ||
| + | |nvarchar(40) | ||
| + | |Name | ||
| + | | | ||
| + | |- | ||
| + | |Name | ||
| + | |varchar(150) | ||
| + | |Name | ||
| + | | | ||
| + | |- | ||
| + | |Description | ||
| + | |varchar(250) | ||
| + | |Description | ||
| + | | | ||
| + | |- | ||
| + | |UnitID | ||
| + | |int | ||
| + | |ID of unit from units list (see relation) | ||
| + | |API_GetUnits.ID | ||
| + | |- | ||
| + | |VATRate | ||
| + | |int | ||
| + | |ID of VAT rates from VAT rates list (see relation) | ||
| + | |API_GetVATRates.ID | ||
| + | |- | ||
| + | |EshopHide | ||
| + | |int | ||
| + | |Eshop hide: | ||
| + | 0 = show, | ||
| + | 1 = hide | ||
| + | | | ||
| + | |- | ||
| + | |RetailPrice | ||
| + | |decimal(18,6) | ||
| + | |Retail price | ||
| + | | | ||
| + | |- | ||
| + | |IsArchiving | ||
| + | |int | ||
| + | |Is archiving | ||
| + | | | ||
| + | |- | ||
| + | |ArchivingDate | ||
| + | |datetime | ||
| + | |Archiving date | ||
| + | | | ||
| + | |} | ||
| + | |||
| + | ==== Example ==== | ||
| + | <syntaxhighlight lang="sql"> | ||
| + | SELECT TOP 1000 * FROM [API_GetProductService] | ||
| + | </syntaxhighlight> | ||
| + | |||
| + | ==== Notices ==== | ||
| + | None. | ||
Aktuální verze z 5. 11. 2019, 15:54
Description
Method gives You overview of existing product service in system.
Exact name
API_GetProductService
Type
Standard view.
Specification
| Column | Data type | Description | Relation |
|---|---|---|---|
| ID | int | Internal system id | |
| ProductCode | nvarchar(40) | Name | |
| Name | varchar(150) | Name | |
| Description | varchar(250) | Description | |
| UnitID | int | ID of unit from units list (see relation) | API_GetUnits.ID |
| VATRate | int | ID of VAT rates from VAT rates list (see relation) | API_GetVATRates.ID |
| EshopHide | int | Eshop hide:
0 = show, 1 = hide |
|
| RetailPrice | decimal(18,6) | Retail price | |
| IsArchiving | int | Is archiving | |
| ArchivingDate | datetime | Archiving date |
Example
SELECT TOP 1000 * FROM [API_GetProductService]
Notices
None.
