Zobrazení zdroje stránky API UpdateDeliveryNote

==== 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
|-
|@ID
|int
|
|Internal system id
|API_GetDeliveryNote.ID
|- 
|@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
|nvarchar(25) 
|
|Number
| 
|- 
|@Date
|datetime 
|
|Date
| 
|- 
|@OrdererName
|nvarchar(140) 
|
|Orderer name
| 
|- 
|@OrdererStreet
|nvarchar(100) 
|
|Orderer street
| 
|- 
|@OrdererCity
|nvarchar(140) 
|
|Orderer city
| 
|- 
|@OrdererZIPCode
|nvarchar(10) 
|
|Orderer ZIP code
| 
|- 
|@OrdererCountry
|nvarchar(50) 
|
|Orderer country
| 
|- 
|@OrdererRegion
|nvarchar(30) 
|
|Orderer region
| 
|- 
|@OrdererState
|nvarchar(50) 
|
|Orderer state
| 
|- 
|@CompanyRegistrationNumber
|nvarchar(20) 
|
|Company registration number
| 
|- 
|@VATNumber
|nvarchar(20) 
|
|VAT number
| 
|- 
|@RecipientName
|nvarchar(140) 
|
|Recipient name
| 
|- 
|@RecipientStreet
|nvarchar(100) 
|
|Recipient street
| 
|- 
|@RecipientCity
|nvarchar(140) 
|
|Recipient city
| 
|- 
|@RecipientZIPCode
|nvarchar(10) 
|
|Recipient ZIP code
| 
|- 
|@RecipientCountry
|nvarchar(50) 
|
|Recipient country
| 
|- 
|@RecipientRegion
|nvarchar(30) 
|
|Recipient region
| 
|- 
|@RecipientState
|nvarchar(50) 
|
|Recipient state
| 
|- 
|@RecipientNote
|nvarchar(250) 
|
|Recipient note
| 
|- 
|@IsCanceled
|int 
|
|Is canceled
| 
|- 
|@IsCancelReason
|nvarchar(150) 
|
|Is cancel reason
| 
|- 
|@IsCancelDate
|datetime 
|
|Is cancel date
| 
|- 
|@Note
|nvarchar(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
|nvarchar(20) 
|
|Recipient company registration number
| 
|- 
|@RecipientVATNumber
|nvarchar(20) 
|
|Recipient VAT number
| 
|- 
|@OrdererBankName
|nvarchar(120) 
|
|Orderer bank name
| 
|- 
|@OrdererBankAccount
|nvarchar(50) 
|
|Orderer bank account
| 
|- 
|@OrdererVATNumber2
|nvarchar(20) 
|
|Orderer VAT number 2
| 
|- 
|@RecipientVATNumber2
|nvarchar(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
| 
|}

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

==== Example ====
<syntaxhighlight lang="sql">
 DECLARE @return_value int
 DECLARE @ID int
 DECLARE @StockID int
 DECLARE @BranchID int
 DECLARE @SupplierID int
 DECLARE @OrdererID int
 DECLARE @RecipientID int
 DECLARE @TransportID int
 DECLARE @PaymentTypeID int
 DECLARE @CurrencyID int
 DECLARE @Number varchar(25)
 DECLARE @Date datetime
 DECLARE @OrdererName varchar(140)
 DECLARE @OrdererStreet varchar(100)
 DECLARE @OrdererCity varchar(140)
 DECLARE @OrdererZIPCode char(10)
 DECLARE @OrdererCountry varchar(50)
 DECLARE @OrdererRegion varchar(30)
 DECLARE @OrdererState varchar(50)
 DECLARE @CompanyRegistrationNumber char(20)
 DECLARE @VATNumber char(20)
 DECLARE @RecipientName varchar(140)
 DECLARE @RecipientStreet varchar(100)
 DECLARE @RecipientCity varchar(140)
 DECLARE @RecipientZIPCode char(10)
 DECLARE @RecipientCountry varchar(50)
 DECLARE @RecipientRegion varchar(30)
 DECLARE @RecipientState varchar(50)
 DECLARE @RecipientNote nvarchar(250)
 DECLARE @IsCanceled int
 DECLARE @IsCancelReason varchar(150)
 DECLARE @IsCancelDate datetime
 DECLARE @Note varchar(300)
 DECLARE @OrdererPhone nvarchar(30)
 DECLARE @OrdererFax nvarchar(30)
 DECLARE @OrdererMobilePhone nvarchar(30)
 DECLARE @OrdererEmail nvarchar(60)
 DECLARE @OrdererUrl nvarchar(50)
 DECLARE @RecipientPhone nvarchar(30)
 DECLARE @RecipientFax nvarchar(30)
 DECLARE @RecipientMobilePhone nvarchar(30)
 DECLARE @RecipientEmail nvarchar(60)
 DECLARE @RecipientUrl nvarchar(50)
 DECLARE @RecipientCompanyRegistrationNumber char(20)
 DECLARE @RecipientVATNumber char(20)
 DECLARE @OrdererBankName nvarchar(120)
 DECLARE @OrdererBankAccount nvarchar(50)
 DECLARE @OrdererVATNumber2 char(20)
 DECLARE @RecipientVATNumber2 char(20)
 DECLARE @IsPrinted int
 DECLARE @PrintedDate date
 DECLARE @StornoDocument int
 DECLARE @StornoDocumentOriginID int
 DECLARE @CurrencyInCurrencyID int
 DECLARE @ExchangeRate decimal(18,2)


 
 SELECT @ID = [ID], 
       @StockID = [StockID],
       @BranchID = [BranchID],
       @SupplierID = [SupplierID],
       @OrdererID = [OrdererID],
       @RecipientID = [RecipientID],
       @TransportID = [TransportID],
       @PaymentTypeID = [PaymentTypeID],
       @CurrencyID = [CurrencyID],
       @Number = '321564Z',
       @Date = [Date],
       @OrdererName = [OrdererName],
       @OrdererStreet = [OrdererStreet],
       @OrdererCity = [OrdererCity],
       @OrdererZIPCode = [OrdererZIPCode],
       @OrdererCountry = [OrdererCountry],
       @OrdererRegion = [OrdererRegion],
       @OrdererState = [OrdererState],
       @CompanyRegistrationNumber = [CompanyRegistrationNumber],
       @VATNumber = [VATNumber],
       @RecipientName = [RecipientName],
       @RecipientStreet = [RecipientStreet],
       @RecipientCity = [RecipientCity],
       @RecipientZIPCode = [RecipientZIPCode],
       @RecipientCountry = [RecipientCountry],
       @RecipientRegion = [RecipientRegion],
       @RecipientState = [RecipientState],
       @RecipientNote = [RecipientNote],
       @IsCanceled = [IsCanceled],
       @IsCancelReason = [IsCancelReason],
       @IsCancelDate = [IsCancelDate],
       @Note = [Note],
       @OrdererPhone = [OrdererPhone],
       @OrdererFax = [OrdererFax],
       @OrdererMobilePhone = [OrdererMobilePhone],
       @OrdererEmail = [OrdererEmail],
       @OrdererUrl = [OrdererUrl],
       @RecipientPhone = [RecipientPhone],
       @RecipientFax = [RecipientFax],
       @RecipientMobilePhone = [RecipientMobilePhone],
       @RecipientEmail = [RecipientEmail],
       @RecipientUrl = [RecipientUrl],
       @RecipientCompanyRegistrationNumber = [RecipientCompanyRegistrationNumber],
       @RecipientVATNumber = [RecipientVATNumber],
       @OrdererBankName = [OrdererBankName],
       @OrdererBankAccount = [OrdererBankAccount],
       @OrdererVATNumber2 = [OrdererVATNumber2],
       @RecipientVATNumber2 = [RecipientVATNumber2],
       @IsPrinted = [IsPrinted],
       @PrintedDate = [PrintedDate],
       @StornoDocument = [StornoDocument],
       @StornoDocumentOriginID = [StornoDocumentOriginID],
       @CurrencyInCurrencyID = [CurrencyInCurrencyID],
       @ExchangeRate = [ExchangeRate]
 FROM   [API_GetDeliveryNote] 
 WHERE  id = 15
 
 EXECUTE @return_value = [API_UpdateDeliveryNote] 
   @ID
  ,@StockID
  ,@BranchID
  ,@SupplierID
  ,@OrdererID
  ,@RecipientID
  ,@TransportID
  ,@PaymentTypeID
  ,@CurrencyID
  ,@Number
  ,@Date
  ,@OrdererName
  ,@OrdererStreet
  ,@OrdererCity
  ,@OrdererZIPCode
  ,@OrdererCountry
  ,@OrdererRegion
  ,@OrdererState
  ,@CompanyRegistrationNumber
  ,@VATNumber
  ,@RecipientName
  ,@RecipientStreet
  ,@RecipientCity
  ,@RecipientZIPCode
  ,@RecipientCountry
  ,@RecipientRegion
  ,@RecipientState
  ,@RecipientNote
  ,@IsCanceled
  ,@IsCancelReason
  ,@IsCancelDate
  ,@Note
  ,@OrdererPhone
  ,@OrdererFax
  ,@OrdererMobilePhone
  ,@OrdererEmail
  ,@OrdererUrl
  ,@RecipientPhone
  ,@RecipientFax
  ,@RecipientMobilePhone
  ,@RecipientEmail
  ,@RecipientUrl
  ,@RecipientCompanyRegistrationNumber
  ,@RecipientVATNumber
  ,@OrdererBankName
  ,@OrdererBankAccount
  ,@OrdererVATNumber2
  ,@RecipientVATNumber2
  ,@IsPrinted
  ,@PrintedDate
  ,@StornoDocument
  ,@StornoDocumentOriginID
  ,@CurrencyInCurrencyID
  ,@ExchangeRate

</syntaxhighlight>

==== Notices ====
None.