API CreateProduct: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „==== Description ==== Method allows You to create new product in system. ==== Exact name ==== <code>API_CreateProduct</code> ==== Type ==== Standard exec…“) |
(Žádný rozdíl)
|
Verze z 7. 8. 2017, 08:07
Description
Method allows You to create new product in system.
Exact name
API_CreateProduct
Type
Standard executable stored procedure.
Specification
| Parameter | Data type | Value range | 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 |
Example
EXEC [API_CreateBranch] @WorkshopID = 1 ,@Name = 'Name' ,@Street = 'Street' ,@City = 'City' ,@ZIPCode = 'ZIPCode' ,@Country = 'Country' ,@Region = 'Region' ,@State ='Česká republika' ,@StateID = 15797 ,@Phone = '+420 556 621 300' ,@Fax = '+420 596 790 789' ,@MobilePhone = '+420 556 621 301' ,@Email = 'info@nextis.cz' ,@Web = 'www.nextis.cz'
Notices
None.
