API CreateOrder - Historie editací

Chrzaszcz v 6. 11. 2020, 15:20

2020-11-06T15:20:54Z

← Starší verze		Verze z 6. 11. 2020, 15:20
Řádek 159:		Řádek 159:
	\|-		\|-
	\|@OtherShippingAddress		\|@OtherShippingAddress
			\|bit
	\|		\|
	\|		\|Other shipping address
	\|		0 - NO
			1 - YES
	\|		\|
	\|-		\|-
	\|@RecipientName		\|@RecipientName
			\|nvarchar(140)
	\|		\|
	\|		\|Recipient name
	\|
	\|		\|
	\|-		\|-
	\|@RecipientStreet		\|@RecipientStreet
			\|nvarchar(100)
	\|		\|
	\|		\|Recipient street
	\|
	\|		\|
	\|-		\|-
	\|@RecipientCity		\|@RecipientCity
			\|nvarchar(140)
	\|		\|
	\|		\|Recipient city
	\|
	\|		\|
	\|-		\|-
	\|@RecipientPostal		\|@RecipientPostal
			\|nvarchar(10)
	\|		\|
	\|		\|Recipient postal
	\|
	\|		\|
	\|-		\|-
	\|@RecipientDistrict		\|@RecipientDistrict
			\|nvarchar(150)
	\|		\|
	\|		\|Recipient district
	\|
	\|		\|
	\|-		\|-
	\|@RecipientProvince		\|@RecipientProvince
			\|nvarchar(30)
	\|		\|
	\|		\|Recipient province
	\|
	\|		\|
	\|-		\|-
	\|@RecipientStat		\|@RecipientStat
			\|nvarchar(50)
	\|		\|
	\|		\|Recipient stat
	\|
	\|		\|
	\|-		\|-
	\|@RecipientRegNo		\|@RecipientRegNo
			\|nvarchar(20)
	\|		\|
	\|		\|Recipient Reg. No.
	\|
	\|		\|
	\|-		\|-
	\|@RecipientTAX		\|@RecipientTAX
			\|nvarchar(20)
	\|		\|
	\|		\|Recipient TAX
	\|
	\|		\|
	\|-		\|-
	\|@RecipientTelephone		\|@RecipientTelephone
			\|nvarchar(30)
	\|		\|
	\|		\|Recipient telephone
	\|
	\|		\|
	\|-		\|-
	\|@RecipientFax		\|@RecipientFax
			\|nvarchar(30)
	\|		\|
	\|		\|Recipient fax
	\|
	\|		\|
	\|-		\|-
	\|@RecipientPhone		\|@RecipientPhone
			\|nvarchar(30)
	\|		\|
	\|		\|Recipient phone
	\|
	\|		\|
	\|-		\|-
	\|@RecipientEmail		\|@RecipientEmail
			\|nvarchar(60)
	\|		\|
	\|		\|Recipient email
	\|
	\|		\|
	\|-		\|-

Chrzaszcz v 6. 11. 2020, 15:15

2020-11-06T15:15:29Z

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

Chrzaszcz v 6. 11. 2020, 15:12

2020-11-06T15:12:14Z

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

Chrzaszcz v 29. 9. 2020, 10:03

2020-09-29T10:03:13Z

← Starší verze		Verze z 29. 9. 2020, 10:03
Řádek 224:		Řádek 224:
	Insert INTO @OrderItems		Insert INTO @OrderItems
	SELECT 232157, -1, 2, 300, 370		SELECT 232157, -1, 2, 300, 370
	Union		Union all
	SELECT 5650223, -1, 1, 20, 30		SELECT 5650223, -1, 1, 20, 30

Chrzaszcz v 29. 9. 2020, 08:06

2020-09-29T08:06:13Z

← Starší verze		Verze z 29. 9. 2020, 08:06
Řádek 90:		Řádek 90:
	\|int		\|int
	\|		\|
	\|~~Lock~~ release		\|Pause warehouse release (manually authorization required)
			0 - OFF
			1 - ON
	\|		\|
	\|-		\|-

Chrzaszcz v 29. 9. 2020, 07:56

2020-09-29T07:56:36Z

← Starší verze		Verze z 29. 9. 2020, 07:56
Řádek 84:		Řádek 84:
	\|Expedition ID		\|Expedition ID
	1 - Immediately,		1 - Immediately,
	2 - ~~EntireOnly~~		2 - Entire only
	\|		\|
	\|-		\|-
Řádek 187:		Řádek 187:
	\|		\|
	\|Supplier ID		\|Supplier ID
	\|		-1 - Automatic selection
			\|API_GetCustomers.ID
	\|-		\|-
	\|Quantity		\|Quantity

Chrzaszcz v 29. 9. 2020, 07:45

2020-09-29T07:45:39Z

← Starší verze		Verze z 29. 9. 2020, 07:45
Řádek 83:		Řádek 83:
	\|		\|
	\|Expedition ID		\|Expedition ID
			1 - Immediately,
			2 - EntireOnly
	\|		\|
	\|-		\|-

Chrzaszcz v 29. 9. 2020, 07:44

2020-09-29T07:44:05Z

← Starší verze		Verze z 29. 9. 2020, 07:44
Řádek 51:		Řádek 51:
	\|		\|
	\|Payment method ID		\|Payment method ID
			1 - Cash,
			2 - Transfer,
			3 - CardPersonally,
			4 - Before,
			5 - Voucher,
			6 - DeliveryCash,
			7 - GoPay,
			8 - Payout
	\|		\|
	\|-		\|-
Řádek 93:		Řádek 101:
	\|		\|
	\|Order type ID		\|Order type ID
			-1 - NA
			0 - Personal,
			1 - Warehouse,
			2 - Intraday,
			5 - Common,
			6 - Warehouse (producer),
			500 - Manufacturing (Assembly)
	\|		\|
	\|-		\|-
Řádek 99:		Řádek 114:
	\|		\|
	\|Separated document		\|Separated document
			0 - OFF
			1 - ON
	\|		\|
	\|-		\|-
Řádek 105:		Řádek 122:
	\|		\|
	\|Final document type ID		\|Final document type ID
			0 - OFF
			5 - Receipt,
			1 - Bank transfer invoice,
			2 - Cash invoice,
			10 - Delivery note
	\|		\|
	\|-		\|-
Řádek 111:		Řádek 133:
	\|		\|
	\|Wait for next order		\|Wait for next order
			0 - OFF
			1 - ON
	\|		\|
	\|-		\|-
Řádek 117:		Řádek 141:
	\|		\|
	\|Add deposits		\|Add deposits
			0 - NO
			1 - YES
	\|		\|
	\|-		\|-
Řádek 123:		Řádek 149:
	\|		\|
	\|Do not order from supplier		\|Do not order from supplier
			0 - Deactivated,
			1 - Activated,
			-1 - Automatic
	\|		\|
	\|-		\|-

Chrzaszcz v 29. 9. 2020, 06:53

2020-09-29T06:53:35Z

← Starší verze		Verze z 29. 9. 2020, 06:53
Řádek 27:		Řádek 27:
	\|		\|
	\|Currency ID		\|Currency ID
	\|		\|API_GetCurrency.ID
	\|-		\|-
	\|@CurrencyInCurrencyID		\|@CurrencyInCurrencyID
Řádek 33:		Řádek 33:
	\|		\|
	\|Currency in currency ID		\|Currency in currency ID
	\|		\|API_GetCurrency.ID
	\|-		\|-
	\|@ExchangeRate		\|@ExchangeRate
Řádek 45:		Řádek 45:
	\|		\|
	\|Customer branch ID		\|Customer branch ID
	\|		\|API_GetCustomers.ID
	\|-		\|-
	\|@PaymentMethodID		\|@PaymentMethodID
Řádek 69:		Řádek 69:
	\|		\|
	\|Transport ID		\|Transport ID
	\|		\|API_GetTransports.ID
	\|-		\|-
	\|@ExpeditionID		\|@ExpeditionID

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).