API GetProducts: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „==== Description ==== Method gives You overview of existing products in system. ==== Exact name ==== <code>API_GetProducts</code> ==== Type ==== Standard…“) |
(Žádný rozdíl)
|
Verze z 31. 7. 2017, 10:11
Description
Method gives You overview of existing products in system.
Exact name
API_GetProducts
Type
Standard view.
Specification
| Column | Data type | Description | Relation |
|---|---|---|---|
| ID | int | Internal system id | |
| GroupID | int | GroupID | |
| SupplierID | int | SupplierID | |
| ProductCode | nvarchar(40) | Product code | |
| TypeID | int | TypeID | |
| MinimumOrderableQuantity | decimal(18,2) | Minimum orderable quantity | |
| BasicPrice | decimal(18,6) | Basic price | |
| CreatedDate | datetime | Created date | |
| UpdatedDate | datetime | Updated date | |
| SupplierItemName | nvarchar(150) | Supplier item name | |
| SupplierProductCode | nvarchar(40) | Supplier product code | |
| Prefix | nvarchar(3) | Prefix | |
| ManufacturerSupplier | nvarchar(50) | Manufacturer supplier | |
| ForeignPrice | decimal(19,6) | Foreign price | |
| RetailPrice | decimal(18,6) | Retail price |
Example
SELECT TOP 1000 * FROM [API_GetProducts]
Notices
None.
