API UpdateDeliveryNote - Historie editací

Chrzaszcz v 9. 11. 2018, 11:55

2018-11-09T11:55:05Z

Chrzaszcz v 9. 11. 2018, 11:52

2018-11-09T11:52:13Z

Chrzaszcz v 22. 9. 2017, 08:30

2017-09-22T08:30:30Z

Chrzaszcz v 7. 8. 2017, 13:14

2017-08-07T13:14:40Z

Ukázat změny

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update delivery note in system. ==== Exact name ==== `API_UpdateDeliveryNote` ==== Type ==== Standa…“

2017-08-07T13:00:54Z

Založena nová stránka s textem „==== Description ==== Method allows You to update delivery note in system. ==== Exact name ==== <code>API_UpdateDeliveryNote</code> ==== Type ==== Standa…“

Nová stránka

==== Description ====
Method allows You to update delivery note in system.

==== Exact name ====
<code>API_UpdateDeliveryNote</code>

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

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@StockID
|int
|
|ID of stock from stock list (see relation)
| API_GetStocks.ID
|-
|@BranchID
|int
|
|ID of branch from branch list (see relation)
| API_GetBranches.ID
|-
|@SupplierID
|int
|
|ID of customer from customer list (see relation)
| API_GetCustomers.ID
|-
|@OrdererID
|int
|
|ID of customer from customer list (see relation)
| API_GetCustomers.ID
|-
|@RecipientID
|int
|
|ID of customer from customer list (see relation)
| API_GetCustomers.ID
|-
|@TransportID
|int
|
|ID of transport from transport list (see relation)
| API_GetTransports.ID
|-
|@PaymentTypeID
|int
|
|Payment type ID.
-1 - _NA

1 - Cash

2 - WireTransfer

3 - CreditCard

4 - Before

5 - Voucher

6 - CashOnDelivery
|
|-
|@CurrencyID
|int
|
|ID of currency from currency list (see relation)
| API_GetCurrency.ID
|-
|@Number
|varchar(25)
|
|Number
|
|-
|@Date
|datetime
|
|Date
|
|-
|@OrdererName
|varchar(140)
|
|Orderer name
|
|-
|@OrdererStreet
|varchar(100)
|
|Orderer street
|
|-
|@OrdererCity
|varchar(140)
|
|Orderer city
|
|-
|@OrdererZIPCode
|char(10)
|
|Orderer ZIP code
|
|-
|@OrdererCountry
|varchar(50)
|
|Orderer country
|
|-
|@OrdererRegion
|varchar(30)
|
|Orderer region
|
|-
|@OrdererState
|varchar(50)
|
|Orderer state
|
|-
|@CompanyRegistrationNumber
|char(20)
|
|Company registration number
|
|-
|@VATNumber
|char(20)
|
|VAT number
|
|-
|@RecipientName
|varchar(140)
|
|Recipient name
|
|-
|@RecipientStreet
|varchar(100)
|
|Recipient street
|
|-
|@RecipientCity
|varchar(140)
|
|Recipient city
|
|-
|@RecipientZIPCode
|char(10)
|
|Recipient ZIP code
|
|-
|@RecipientCountry
|varchar(50)
|
|Recipient country
|
|-
|@RecipientRegion
|varchar(30)
|
|Recipient region
|
|-
|@RecipientState
|varchar(50)
|
|Recipient state
|
|-
|@RecipientNote
|nvarchar(250)
|
|Recipient note
|
|-
|@IsCanceled
|int
|
|Is canceled
|
|-
|@IsCancelReason
|varchar(150)
|
|Is cancel reason
|
|-
|@IsCancelDate
|datetime
|
|Is cancel date
|
|-
|@Note
|varchar(300)
|
|Note
|
|-
|@OrdererPhone
|nvarchar(30)
|
|Orderer phone
|
|-
|@OrdererFax
|nvarchar(30)
|
|Orderer fax
|
|-
|@OrdererMobilePhone
|nvarchar(30)
|
|Orderer mobile phone
|
|-
|@OrdererEmail
|nvarchar(60)
|
|Orderer email
|
|-
|@OrdererUrl
|nvarchar(50)
|
|Orderer url
|
|-
|@RecipientPhone
|nvarchar(30)
|
|Recipient phone
|
|-
|@RecipientFax
|nvarchar(30)
|
|Recipient fax
|
|-
|@RecipientMobilePhone
|nvarchar(30)
|
|Recipient mobile phone
|
|-
|@RecipientEmail
|nvarchar(60)
|
|Recipient email
|
|-
|@RecipientUrl
|nvarchar(50)
|
|Recipient url
|
|-
|@RecipientCompanyRegistrationNumber
|char(20)
|
|Recipient company registration number
|
|-
|@RecipientVATNumber
|char(20)
|
|Recipient VAT number
|
|-
|@OrdererBankName
|nvarchar(120)
|
|Orderer bank name
|
|-
|@OrdererBankAccount
|nvarchar(50)
|
|Orderer bank account
|
|-
|@OrdererVATNumber2
|char(20)
|
|Orderer VAT number 2
|
|-
|@RecipientVATNumber2
|char(20)
|
|Recipient VAT number 2
|
|-
|@IsPrinted
|int
|
|Is printed
|
|-
|@PrintedDate
|date
|
|Printed date
|
|-
|@StornoDocument
|int
|
|Storno document
|
|-
|@StornoDocumentOriginID
|int
|
|ID of delivery note from delivery note list (see relation)
| API_GetDeliveryNote.ID
|-
|@CurrencyInCurrencyID
|int
|
|ID of currency from currency list (see relation)
| API_GetCurrency.ID
|-
|@ExchangeRate
|decimal(18,2)
|
|Exchange rate
|
|}

==== Example ====
<syntaxhighlight lang="sql">
DECLARE @ID INT
DECLARE @WorkshopID INT

SELECT @ID = id,
@WorkshopID = [workshopid],

FROM [API_GetDeliveryNote]
WHERE id = 3

EXECUTE [API_UpdateDeliveryNote]
@ID,

</syntaxhighlight>

==== Notices ====
None.

@@ Řádka 370: / Řádka 370: @@
   DECLARE @PaymentTypeID int
   DECLARE @CurrencyID int
-  DECLARE @Number varchar(25)
+  DECLARE @Number nvarchar(25)
   DECLARE @Date datetime
-  DECLARE @OrdererName varchar(140)
+  DECLARE @OrdererName nvarchar(140)
-  DECLARE @OrdererStreet varchar(100)
+  DECLARE @OrdererStreet nvarchar(100)
-  DECLARE @OrdererCity varchar(140)
+  DECLARE @OrdererCity nvarchar(140)
-  DECLARE @OrdererZIPCode char(10)
+  DECLARE @OrdererZIPCode nvarchar(10)
-  DECLARE @OrdererCountry varchar(50)
+  DECLARE @OrdererCountry nvarchar(50)
-  DECLARE @OrdererRegion varchar(30)
+  DECLARE @OrdererRegion nvarchar(30)
-  DECLARE @OrdererState varchar(50)
+  DECLARE @OrdererState nvarchar(50)
-  DECLARE @CompanyRegistrationNumber char(20)
+  DECLARE @CompanyRegistrationNumber nvarchar(20)
-  DECLARE @VATNumber char(20)
+  DECLARE @VATNumber nvarchar(20)
-  DECLARE @RecipientName varchar(140)
+  DECLARE @RecipientName nvarchar(140)
-  DECLARE @RecipientStreet varchar(100)
+  DECLARE @RecipientStreet nvarchar(100)
-  DECLARE @RecipientCity varchar(140)
+  DECLARE @RecipientCity nvarchar(140)
-  DECLARE @RecipientZIPCode char(10)
+  DECLARE @RecipientZIPCode nvarchar(10)
-  DECLARE @RecipientCountry varchar(50)
+  DECLARE @RecipientCountry nvarchar(50)
-  DECLARE @RecipientRegion varchar(30)
+  DECLARE @RecipientRegion nvarchar(30)
-  DECLARE @RecipientState varchar(50)
+  DECLARE @RecipientState nvarchar(50)
   DECLARE @RecipientNote nvarchar(250)
   DECLARE @IsCanceled int
-  DECLARE @IsCancelReason varchar(150)
+  DECLARE @IsCancelReason nvarchar(150)
   DECLARE @IsCancelDate datetime
-  DECLARE @Note varchar(300)
+  DECLARE @Note nvarchar(300)
   DECLARE @OrdererPhone nvarchar(30)
   DECLARE @OrdererFax nvarchar(30)
@@ Řádka 403: / Řádka 403: @@
   DECLARE @RecipientEmail nvarchar(60)
   DECLARE @RecipientUrl nvarchar(50)
-  DECLARE @RecipientCompanyRegistrationNumber char(20)
+  DECLARE @RecipientCompanyRegistrationNumber nvarchar(20)
-  DECLARE @RecipientVATNumber char(20)
+  DECLARE @RecipientVATNumber nvarchar(20)
   DECLARE @OrdererBankName nvarchar(120)
   DECLARE @OrdererBankAccount nvarchar(50)
-  DECLARE @OrdererVATNumber2 char(20)
+  DECLARE @OrdererVATNumber2 nvarchar(20)
-  DECLARE @RecipientVATNumber2 char(20)
+  DECLARE @RecipientVATNumber2 nvarchar(20)
   DECLARE @IsPrinted int
   DECLARE @PrintedDate date

@@ Řádka 354: / Řádka 354: @@
 |}
 ==== Example ====
 <syntaxhighlight lang="sql">
   DECLARE @ID int
   DECLARE @StockID int
@@ Řádka 471: / Řádka 475: @@
   WHERE  id = 15
-  EXECUTE [API_UpdateDeliveryNote]
+  EXECUTE @return_value = [API_UpdateDeliveryNote]
     @ID
    ,@StockID