API CreateOrder - Historie editací

Chrzaszcz v 6. 11. 2020, 15:20

2020-11-06T15:20:54Z

Chrzaszcz v 6. 11. 2020, 15:15

2020-11-06T15:15:29Z

Chrzaszcz v 6. 11. 2020, 15:12

2020-11-06T15:12:14Z

Chrzaszcz v 29. 9. 2020, 10:03

2020-09-29T10:03:13Z

Chrzaszcz v 29. 9. 2020, 08:06

2020-09-29T08:06:13Z

Chrzaszcz v 29. 9. 2020, 07:56

2020-09-29T07:56:36Z

Chrzaszcz v 29. 9. 2020, 07:45

2020-09-29T07:45:39Z

Chrzaszcz v 29. 9. 2020, 07:44

2020-09-29T07:44:05Z

Chrzaszcz v 29. 9. 2020, 06:53

2020-09-29T06:53:35Z

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to create new order in system. ==== Exact name ==== `API_CreateOrder` ==== Type ==== Standard executab…“

2020-09-25T15:09:20Z

Založena nová stránka s textem „==== Description ==== Method allows You to create new order in system. ==== Exact name ==== <code>API_CreateOrder</code> ==== Type ==== Standard executab…“

Nová stránka

==== Description ====
Method allows You to create new order in system.

==== Exact name ====
<code>API_CreateOrder</code>

==== Type ====
Standard executable stored procedure with table-Valued Parameters.

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@Series
|nvarchar(10)
|
|Series number starts. Format: Series+Year+Auto Increment Number
|
|-
|@CurrencyID
|int
|
|Currency ID
|
|-
|@CurrencyInCurrencyID
|int
|
|Currency in currency ID
|
|-
|@ExchangeRate
|decimal(18,6)
|
|Exchange rate
|
|-
|@CustomerBranchID
|int
|
|Customer branch ID
|
|-
|@PaymentMethodID
|int
|
|Payment method ID
|
|-
|@SupplierOrderNo
|nvarchar(80)
|
|Supplier Order Number
|
|-
|@Note
|nvarchar(600)
|
|Note
|
|-
|@TransportID
|int
|
|Transport ID
|
|-
|@ExpeditionID
|int
|
|Expedition ID
|
|-
|@LockRelease
|int
|
|Lock release
|
|-
|@RealizationDate
|datetime
|
|Realization Date
|
|-
|@OrderTypeID
|int
|
|Order type ID
|
|-
|@SeparatedDocument
|int
|
|Separated document
|
|-
|@FinalDocumentTypeID
|int
|
|Final document type ID
|
|-
|@WaitForNextOrder
|int
|
|Wait for next order
|
|-
|@AddDeposits
|bit
|
|Add deposits
|
|-
|@DoNotOrderFromSupplier
|int
|
|Do not order from supplier
|
|-
|@OrderNo
|nvarchar(25)
|
|Order number OUTPUT
|
|-
|@OrderID
|int
|
|Order ID OUTPUT
|
|}

==== Table-Valued Parameters Specification====
{| class="wikitable"
!Columns name
!Data type
!Value range
!Description
!Relation
|-
|ProduktGroupID
|int
|
|ProduktGroupID
|API_GetProductGroups.ID
|-
|SupplierID
|int
|
|Supplier ID
|
|-
|Quantity
|decimal(14,2)
|
|Quantity
|
|-
|PurchasePriceInCurrency
|decimal(19,6)
|
|Purchase price in currency
|
|-
|PurchasePriceAfterDiscountInCurrency
|decimal(19,6)
|
|Purchase price after discount in currency
|
|}

==== Return ====
Number : OK - Number of added items
-100 : Order could not be created

==== Example ====
<syntaxhighlight lang="sql">
DECLARE @return_value int
Declare @OrderItems dbo.ApiOrderItems
Declare @_OrderNo nvarchar(25)
Declare @_OrderID int

Insert INTO @OrderItems
SELECT 232157, -1, 2, 300, 370
Union
SELECT 5650223, -1, 1, 20, 30

exec @return_value = dbo.[API_CreateOrder]
@Series = 'ORD',
@CurrencyID = 16034,
@CurrencyInCurrencyID = 16034,
@ExchangeRate = 1,
@CustomerBranchID = 75,
@PaymentMethodID = 2,
@SupplierOrderNo = '',
@Note = 'Some note',
@TransportID = 2,
@ExpeditionID = 1,
@LockRelease = 0,
@RealizationDate = -1,
@OrderTypeID = 0,
@SeparatedDocument = 0,
@FinalDocumentTypeID = 0,
@WaitForNextOrder = 0,
@AddDeposits = 0,
@DoNotOrderFromSupplier = -1,
@OrderItems = @OrderItems,
@OrderNo = @_OrderNo OUTPUT,
@OrderID = @_OrderID OUTPUT

Select @return_value, @_OrderNo, @_OrderID</syntaxhighlight>

==== Notices ====
API_CreateOrder procedure uses own data type called OrderItems (dbo.ApiOrderItems).

@@ Řádka 159: / Řádka 159: @@
 |-
 |@OtherShippingAddress
+|
+|Other shipping address
+- NO
+|
 |-
 |@RecipientName
+|
+|Recipient name
+|
 |-
 |@RecipientStreet
+|
+|Recipient street
+|
 |-
 |@RecipientCity
+|
+|Recipient city
+|
 |-
 |@RecipientPostal
+|
+|Recipient postal
+|
 |-
 |@RecipientDistrict
+|
+|Recipient district
+|
 |-
 |@RecipientProvince
+|
+|Recipient province
+|
 |-
 |@RecipientStat
+|
+|Recipient stat
+|
 |-
 |@RecipientRegNo
+|
+|Recipient Reg. No.
+|
 |-
 |@RecipientTAX
+|
+|Recipient TAX
+|
 |-
 |@RecipientTelephone
+|
+|Recipient telephone
+|
 |-
 |@RecipientFax
+|
+|Recipient fax
+|
 |-
 |@RecipientPhone
+|
+|Recipient phone
+|
 |-
 |@RecipientEmail
+|
+|Recipient email
+|
 |-

@@ Řádka 156: / Řádka 156: @@
 - Activated,
 -1 - Automatic
+|
 |-

@@ Řádka 90: / Řádka 90: @@
 |int
+|
-|Lock release
+|Pause warehouse release (manually authorization required)
+|
 |-

@@ Řádka 84: / Řádka 84: @@
 |Expedition ID
 - Immediately,
-- EntireOnly
+- Entire only
+|
 |-
@@ Řádka 187: / Řádka 187: @@
+|
 |Supplier ID
+-1 - Automatic selection
 |-
 |Quantity

@@ Řádka 246: / Řádka 246: @@
 @AddDeposits = 0,
 @DoNotOrderFromSupplier = -1,
 @OrderItems = @OrderItems,
 @OrderNo = @_OrderNo OUTPUT,

@@ Řádka 224: / Řádka 224: @@
 Insert INTO @OrderItems
 SELECT 232157, -1, 2, 300, 370
-Union
+Union all
 SELECT 5650223, -1, 1, 20, 30

@@ Řádka 51: / Řádka 51: @@
+|
 |Payment method ID
+|
 |-
@@ Řádka 93: / Řádka 101: @@
+|
 |Order type ID
+|
 |-
@@ Řádka 99: / Řádka 114: @@
+|
 |Separated document
+|
 |-
@@ Řádka 105: / Řádka 122: @@
+|
 |Final document type ID
+|
 |-
@@ Řádka 111: / Řádka 133: @@
+|
 |Wait for next order
+|
 |-
@@ Řádka 117: / Řádka 141: @@
+|
 |Add deposits
+|
 |-
@@ Řádka 123: / Řádka 149: @@
+|
 |Do not order from supplier
+|
 |-

@@ Řádka 27: / Řádka 27: @@
+|
 |Currency ID
+|API_GetCurrency.ID
 |-
 |@CurrencyInCurrencyID
@@ Řádka 33: / Řádka 33: @@
+|
 |Currency in currency ID
+|API_GetCurrency.ID
 |-
 |@ExchangeRate
@@ Řádka 45: / Řádka 45: @@
+|
 |Customer branch ID
+|API_GetCustomers.ID
 |-
 |@PaymentMethodID
@@ Řádka 69: / Řádka 69: @@
+|
 |Transport ID
+|API_GetTransports.ID
 |-
 |@ExpeditionID