Podpora.nextis.cz - Nejnovější stránky [cs]

API RemoveOrderItem

2021-09-06T11:18:45Z

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to remove order item in system. ==== Exact name ==== <code>API_RemoveOrderItem</code> ==== Type ==== Standard exe…“

==== Description ====
Method allows You to remove order item in system.

==== Exact name ====
<code>API_RemoveOrderItem</code>

==== Type ====
Standard executable stored procedure.

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@ID
|int
|
|Internal system id
|API_GetOrderDetail.ID
|}

==== Return ====
0 : OK
100 : Item does not exist
200 : Item ordered from the supplier

==== Example ====
<syntaxhighlight lang="sql">
DECLARE @return_value int
EXEC @return_value = [API_RemoveOrderItem]
@ID = 3
</syntaxhighlight>

==== Notices ====
None.

API GetSupplierProductPriceList

2021-07-29T10:18:27Z

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method gives You overview of existing supplier product price list in system. ==== Exact name ==== <code>API_GetSupplierProductPriceL…“

==== Description ====
Method gives You overview of existing supplier product price list in system.

==== Exact name ====
<code>API_GetSupplierProductPriceList</code>

==== Type ====
Standard view.

==== Specification ====
{| class="wikitable"
!Column
!Data type
!Description
!Relation
|-
|ID
|int
|Internal system id
|
|-
|SupplierID
|int
|SupplierID
|API_GetCustomers.ID
|-
|SupplierProductCode
|nvarchar(40)
|Supplier product code
|API_GetSupplierProductCrossList.SupplierProductCode
|-
|ManufacturerSupplier
|nvarchar(50)
|Manufacturer supplier
|API_GetSupplierProductCrossList.ManufacturerSupplier
|-
|Prefix
|nvarchar(3)
|Prefix
|API_GetSupplierProductCrossList.Prefix
|-
|ForeignPrice
|decimal(19,6)
|Foreign price
|
|-
|CreatedDate
|datetime
|Created date
|
|-
|UpdatedDate
|datetime
|Updated date
|
|}

==== Example ====
<syntaxhighlight lang="sql">
SELECT TOP 1000 * FROM [API_GetSupplierProductPriceList]
</syntaxhighlight>

==== Notices ====
None.

API GetSupplierProductCrossList

2021-07-29T10:11:51Z

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method gives You overview of existing supplier product cross list in system. ==== Exact name ==== <code>API_GetSupplierProductCrossL…“

==== Description ====
Method gives You overview of existing supplier product cross list in system.

==== Exact name ====
<code>API_GetSupplierProductCrossList</code>

==== Type ====
Standard view.

==== Specification ====
{| class="wikitable"
!Column
!Data type
!Description
!Relation
|-
|ID
|int
|Internal system id
|
|-
|GroupID
|int
|
|API_GetProductGroups.ID
|-
|SupplierID
|int
|SupplierID
|API_GetCustomers.ID
|-
|SupplierItemName
|nvarchar(150)
|Supplier item name
|
|-
|SupplierProductCode
|nvarchar(40)
|Supplier product code
|
|-
|Prefix
|nvarchar(3)
|Prefix
|
|-
|ManufacturerSupplier
|nvarchar(50)
|Manufacturer supplier
|
|-
|CreatedDate
|datetime
|Created date
|
|}

==== Example ====
<syntaxhighlight lang="sql">
SELECT TOP 1000 * FROM [API_GetSupplierProductCrossList]
</syntaxhighlight>

==== Notices ====
None.

API RemoveAllSupplierProductPriceWithoutSupplierProductCrossListConnection

2021-07-29T09:54:20Z

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to remove all supplier product price without supplier product cross list connection in system. ==== Exact name ===…“

==== Description ====
Method allows You to remove all supplier product price without supplier product cross list connection in system.

==== Exact name ====
<code>API_RemoveAllSupplierProductPriceWithoutSupplierProductCrossListConnection</code>

==== Type ====
Standard executable stored procedure.

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@SupplierID
|int
|
|Internal system id
|API_GetCustomers.ID
|}

==== Return ====
0 : OK
100 : Item does not exist

==== Example ====
<syntaxhighlight lang="sql">
DECLARE @return_value int
EXEC @return_value = [API_RemoveAllSupplierProductPriceWithoutSupplierProductCrossListConnection]
@SupplierID = 3
</syntaxhighlight>

==== Notices ====
None.

API RemoveAllSupplierProductDoubleCrosses

2021-07-29T09:50:46Z

Chrzaszcz:

==== Description ====
Method allows You to remove all supplier product double crosses in system. The method leaves the last uploaded cross in system

==== Exact name ====
<code>API_RemoveAllSupplierProductDoubleCrosses</code>

==== Type ====
Standard executable stored procedure.

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@SupplierID
|int
|
|Internal system id
|API_GetCustomers.ID
|}

==== Return ====
0 : OK
100 : Item does not exist

==== Example ====
<syntaxhighlight lang="sql">
DECLARE @return_value int
EXEC @return_value = [API_RemoveAllSupplierProductDoubleCrosses]
@SupplierID = 3
</syntaxhighlight>

==== Notices ====
None.

API UpdateOrdersDetail

2021-05-28T10:44:26Z

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update order detail in system. ==== Exact name ==== <code>API_UpdateOrdersDetail</code> ==== Type ==== Standar…“

==== Description ====
Method allows You to update order detail in system.

==== Exact name ====
<code>API_UpdateOrdersDetail</code>

==== Type ====
Standard executable stored procedure.

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@ID
|int
|
|Internal system id
|API_GetOrderDetail.ID
|-
|@DeliveredQuantity
|decimal(18,4)
|
|Delivered quantity
|
|-
|@CanceledQuantity
|decimal(18,4)
|
|Canceled quantity
|
|}

==== Return ====
0 : OK
100 : Item could not be updated

==== Example ====
<syntaxhighlight lang="sql">
DECLARE @return_value int
DECLARE @ID int
DECLARE @DeliveredQuantity decimal(18,4)
DECLARE @CanceledQuantity decimal(18,4)

set @ID = 15
set @DeliveredQuantity = 0
set @CanceledQuantity = 3

EXECUTE @return_value = [API_UpdateOrdersDetail]
@ID
,@DeliveredQuantity
,@CanceledQuantity

</syntaxhighlight>

==== Notices ====
None.