API GetProductService: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Založena nová stránka s textem „s“ |
Bez shrnutí editace |
||
| (Není zobrazena jedna mezilehlá verze od stejného uživatele.) | |||
| Řádek 1: | Řádek 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, 14: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.