API GetProducts: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
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…“ |
Bez shrnutí editace |
||
| (Nejsou zobrazeny 2 mezilehlé verze od stejného uživatele.) | |||
| Řádek 22: | Řádek 22: | ||
|GroupID | |GroupID | ||
|int | |int | ||
| | | | ||
|API_GetProductGroups.ID | |||
|- | |- | ||
|SupplierID | |SupplierID | ||
|int | |int | ||
|SupplierID | |SupplierID | ||
| | |API_GetCustomers.ID | ||
|- | |- | ||
|ProductCode | |ProductCode | ||
| Řádek 37: | Řádek 37: | ||
|TypeID | |TypeID | ||
|int | |int | ||
|TypeID | |TypeID. | ||
1 - products | |||
| | | | ||
|- | |- | ||
| Řádek 88: | Řádek 89: | ||
|decimal(18,6) | |decimal(18,6) | ||
|Retail price | |Retail price | ||
| | |||
|- | |||
|IsArchiving | |||
|int | |||
|Is archiving | |||
| | |||
|- | |||
|ArchivingDate | |||
|datetime | |||
|Archiving date | |||
| | |||
|- | |||
|InfoReturnOfGoods | |||
|nvarchar(50) | |||
|Info return of goods | |||
| | | | ||
|} | |} | ||
Aktuální verze z 13. 8. 2020, 08:26
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 | API_GetProductGroups.ID | |
| SupplierID | int | SupplierID | API_GetCustomers.ID |
| ProductCode | nvarchar(40) | Product code | |
| TypeID | int | TypeID.
1 - products |
|
| 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 | |
| IsArchiving | int | Is archiving | |
| ArchivingDate | datetime | Archiving date | |
| InfoReturnOfGoods | nvarchar(50) | Info return of goods |
Example
SELECT TOP 1000 * FROM [API_GetProducts]
Notices
None.