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