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…“) |
|||
| Řádka 18: | Řádka 18: | ||
|ID | |ID | ||
|int | |int | ||
| + | | | ||
|Internal system id | |Internal system id | ||
| | | | ||
| Řádka 23: | Řádka 24: | ||
|GroupID | |GroupID | ||
|int | |int | ||
| + | | | ||
| | | | ||
|API_GetProductGroups.ID | |API_GetProductGroups.ID | ||
| Řádka 28: | Řádka 30: | ||
|SupplierID | |SupplierID | ||
|int | |int | ||
| + | | | ||
|SupplierID | |SupplierID | ||
|API_GetCustomers.ID | |API_GetCustomers.ID | ||
| Řádka 33: | Řádka 36: | ||
|ProductCode | |ProductCode | ||
|nvarchar(40) | |nvarchar(40) | ||
| + | | | ||
|Product code | |Product code | ||
| | | | ||
| Řádka 38: | Řádka 42: | ||
|TypeID | |TypeID | ||
|int | |int | ||
| + | | | ||
|TypeID. | |TypeID. | ||
1 - products | 1 - products | ||
| Řádka 44: | Řádka 49: | ||
|MinimumOrderableQuantity | |MinimumOrderableQuantity | ||
|decimal(18,2) | |decimal(18,2) | ||
| + | | | ||
|Minimum orderable quantity | |Minimum orderable quantity | ||
| | | | ||
| Řádka 49: | Řádka 55: | ||
|BasicPrice | |BasicPrice | ||
|decimal(18,6) | |decimal(18,6) | ||
| + | | | ||
|Basic price | |Basic price | ||
| | | | ||
| Řádka 54: | Řádka 61: | ||
|CreatedDate | |CreatedDate | ||
|datetime | |datetime | ||
| + | | | ||
|Created date | |Created date | ||
| | | | ||
| Řádka 59: | Řádka 67: | ||
|UpdatedDate | |UpdatedDate | ||
|datetime | |datetime | ||
| + | | | ||
|Updated date | |Updated date | ||
| | | | ||
| Řádka 64: | Řádka 73: | ||
|SupplierItemName | |SupplierItemName | ||
|nvarchar(150) | |nvarchar(150) | ||
| + | | | ||
|Supplier item name | |Supplier item name | ||
| | | | ||
| Řádka 69: | Řádka 79: | ||
|SupplierProductCode | |SupplierProductCode | ||
|nvarchar(40) | |nvarchar(40) | ||
| + | | | ||
|Supplier product code | |Supplier product code | ||
| | | | ||
| Řádka 74: | Řádka 85: | ||
|Prefix | |Prefix | ||
|nvarchar(3) | |nvarchar(3) | ||
| + | | | ||
|Prefix | |Prefix | ||
| | | | ||
| Řádka 79: | Řádka 91: | ||
|ManufacturerSupplier | |ManufacturerSupplier | ||
|nvarchar(50) | |nvarchar(50) | ||
| + | | | ||
|Manufacturer supplier | |Manufacturer supplier | ||
| | | | ||
| Řádka 84: | Řádka 97: | ||
|ForeignPrice | |ForeignPrice | ||
|decimal(19,6) | |decimal(19,6) | ||
| + | | | ||
|Foreign price | |Foreign price | ||
| | | | ||
| Řádka 89: | Řádka 103: | ||
|RetailPrice | |RetailPrice | ||
|decimal(18,6) | |decimal(18,6) | ||
| + | | | ||
|Retail price | |Retail price | ||
| | | | ||
Verze z 7. 8. 2017, 08:08
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.
