API UpdateDeliveryNote: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
(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…“)
 
 
(Nejsou zobrazeny 3 mezilehlé verze od stejného uživatele.)
Řádka 15: Řádka 15:
 
!Description
 
!Description
 
!Relation
 
!Relation
 +
|-
 +
|@ID
 +
|int
 +
|
 +
|Internal system id
 +
|API_GetDeliveryNote.ID
 
|-  
 
|-  
 
|@StockID
 
|@StockID
Řádka 78: Řádka 84:
 
|-  
 
|-  
 
|@Number
 
|@Number
−
|varchar(25)  
+
|nvarchar(25)  
 
|
 
|
 
|Number
 
|Number
Řádka 90: Řádka 96:
 
|-  
 
|-  
 
|@OrdererName
 
|@OrdererName
−
|varchar(140)  
+
|nvarchar(140)  
 
|
 
|
 
|Orderer name
 
|Orderer name
Řádka 96: Řádka 102:
 
|-  
 
|-  
 
|@OrdererStreet
 
|@OrdererStreet
−
|varchar(100)  
+
|nvarchar(100)  
 
|
 
|
 
|Orderer street
 
|Orderer street
Řádka 102: Řádka 108:
 
|-  
 
|-  
 
|@OrdererCity
 
|@OrdererCity
−
|varchar(140)  
+
|nvarchar(140)  
 
|
 
|
 
|Orderer city
 
|Orderer city
Řádka 108: Řádka 114:
 
|-  
 
|-  
 
|@OrdererZIPCode
 
|@OrdererZIPCode
−
|char(10)  
+
|nvarchar(10)  
 
|
 
|
 
|Orderer ZIP code
 
|Orderer ZIP code
Řádka 114: Řádka 120:
 
|-  
 
|-  
 
|@OrdererCountry
 
|@OrdererCountry
−
|varchar(50)  
+
|nvarchar(50)  
 
|
 
|
 
|Orderer country
 
|Orderer country
Řádka 120: Řádka 126:
 
|-  
 
|-  
 
|@OrdererRegion
 
|@OrdererRegion
−
|varchar(30)  
+
|nvarchar(30)  
 
|
 
|
 
|Orderer region
 
|Orderer region
Řádka 126: Řádka 132:
 
|-  
 
|-  
 
|@OrdererState
 
|@OrdererState
−
|varchar(50)  
+
|nvarchar(50)  
 
|
 
|
 
|Orderer state
 
|Orderer state
Řádka 132: Řádka 138:
 
|-  
 
|-  
 
|@CompanyRegistrationNumber
 
|@CompanyRegistrationNumber
−
|char(20)  
+
|nvarchar(20)  
 
|
 
|
 
|Company registration number
 
|Company registration number
Řádka 138: Řádka 144:
 
|-  
 
|-  
 
|@VATNumber
 
|@VATNumber
−
|char(20)  
+
|nvarchar(20)  
 
|
 
|
 
|VAT number
 
|VAT number
Řádka 144: Řádka 150:
 
|-  
 
|-  
 
|@RecipientName
 
|@RecipientName
−
|varchar(140)  
+
|nvarchar(140)  
 
|
 
|
 
|Recipient name
 
|Recipient name
Řádka 150: Řádka 156:
 
|-  
 
|-  
 
|@RecipientStreet
 
|@RecipientStreet
−
|varchar(100)  
+
|nvarchar(100)  
 
|
 
|
 
|Recipient street
 
|Recipient street
Řádka 156: Řádka 162:
 
|-  
 
|-  
 
|@RecipientCity
 
|@RecipientCity
−
|varchar(140)  
+
|nvarchar(140)  
 
|
 
|
 
|Recipient city
 
|Recipient city
Řádka 162: Řádka 168:
 
|-  
 
|-  
 
|@RecipientZIPCode
 
|@RecipientZIPCode
−
|char(10)  
+
|nvarchar(10)  
 
|
 
|
 
|Recipient ZIP code
 
|Recipient ZIP code
Řádka 168: Řádka 174:
 
|-  
 
|-  
 
|@RecipientCountry
 
|@RecipientCountry
−
|varchar(50)  
+
|nvarchar(50)  
 
|
 
|
 
|Recipient country
 
|Recipient country
Řádka 174: Řádka 180:
 
|-  
 
|-  
 
|@RecipientRegion
 
|@RecipientRegion
−
|varchar(30)  
+
|nvarchar(30)  
 
|
 
|
 
|Recipient region
 
|Recipient region
Řádka 180: Řádka 186:
 
|-  
 
|-  
 
|@RecipientState
 
|@RecipientState
−
|varchar(50)  
+
|nvarchar(50)  
 
|
 
|
 
|Recipient state
 
|Recipient state
Řádka 198: Řádka 204:
 
|-  
 
|-  
 
|@IsCancelReason
 
|@IsCancelReason
−
|varchar(150)  
+
|nvarchar(150)  
 
|
 
|
 
|Is cancel reason
 
|Is cancel reason
Řádka 210: Řádka 216:
 
|-  
 
|-  
 
|@Note
 
|@Note
−
|varchar(300)  
+
|nvarchar(300)  
 
|
 
|
 
|Note
 
|Note
Řádka 276: Řádka 282:
 
|-  
 
|-  
 
|@RecipientCompanyRegistrationNumber
 
|@RecipientCompanyRegistrationNumber
−
|char(20)  
+
|nvarchar(20)  
 
|
 
|
 
|Recipient company registration number
 
|Recipient company registration number
Řádka 282: Řádka 288:
 
|-  
 
|-  
 
|@RecipientVATNumber
 
|@RecipientVATNumber
−
|char(20)  
+
|nvarchar(20)  
 
|
 
|
 
|Recipient VAT number
 
|Recipient VAT number
Řádka 300: Řádka 306:
 
|-  
 
|-  
 
|@OrdererVATNumber2
 
|@OrdererVATNumber2
−
|char(20)  
+
|nvarchar(20)  
 
|
 
|
 
|Orderer VAT number 2
 
|Orderer VAT number 2
Řádka 306: Řádka 312:
 
|-  
 
|-  
 
|@RecipientVATNumber2
 
|@RecipientVATNumber2
−
|char(20)  
+
|nvarchar(20)  
 
|
 
|
 
|Recipient VAT number 2
 
|Recipient VAT number 2
Řádka 348: Řádka 354:
 
|}
 
|}
  
 +
==== Return ====
 +
0 : OK
 +
100 : Item could not be updated
  
 
==== Example ====
 
==== Example ====
 
<syntaxhighlight lang="sql">
 
<syntaxhighlight lang="sql">
−
  DECLARE @ID INT
+
DECLARE @return_value int
−
  DECLARE @WorkshopID 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 nvarchar(25)
 +
DECLARE @Date datetime
 +
DECLARE @OrdererName nvarchar(140)
 +
DECLARE @OrdererStreet nvarchar(100)
 +
DECLARE @OrdererCity nvarchar(140)
 +
DECLARE @OrdererZIPCode nvarchar(10)
 +
DECLARE @OrdererCountry nvarchar(50)
 +
DECLARE @OrdererRegion nvarchar(30)
 +
DECLARE @OrdererState nvarchar(50)
 +
DECLARE @CompanyRegistrationNumber nvarchar(20)
 +
DECLARE @VATNumber nvarchar(20)
 +
DECLARE @RecipientName nvarchar(140)
 +
DECLARE @RecipientStreet nvarchar(100)
 +
DECLARE @RecipientCity nvarchar(140)
 +
DECLARE @RecipientZIPCode nvarchar(10)
 +
DECLARE @RecipientCountry nvarchar(50)
 +
DECLARE @RecipientRegion nvarchar(30)
 +
DECLARE @RecipientState nvarchar(50)
 +
DECLARE @RecipientNote nvarchar(250)
 +
DECLARE @IsCanceled int
 +
DECLARE @IsCancelReason nvarchar(150)
 +
DECLARE @IsCancelDate datetime
 +
DECLARE @Note nvarchar(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 nvarchar(20)
 +
DECLARE @RecipientVATNumber nvarchar(20)
 +
DECLARE @OrdererBankName nvarchar(120)
 +
DECLARE @OrdererBankAccount nvarchar(50)
 +
DECLARE @OrdererVATNumber2 nvarchar(20)
 +
DECLARE @RecipientVATNumber2 nvarchar(20)
 +
DECLARE @IsPrinted int
 +
DECLARE @PrintedDate date
 +
DECLARE @StornoDocument int
 +
DECLARE @StornoDocumentOriginID int
 +
DECLARE @CurrencyInCurrencyID int
 +
  DECLARE @ExchangeRate decimal(18,2)
  
  
 
   
 
   
−
  SELECT @ID = id,  
+
  SELECT @ID = [ID],
−
       @WorkshopID = [workshopid],  
+
      @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]  
 
  FROM  [API_GetDeliveryNote]  
−
  WHERE  id = 3
+
  WHERE  id = 15
 
   
 
   
−
  EXECUTE [API_UpdateDeliveryNote]  
+
  EXECUTE @return_value = [API_UpdateDeliveryNote]  
−
   @ID,  
+
  @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>
 
</syntaxhighlight>

Aktuální verze z 9. 11. 2018, 12:55

Description

Method allows You to update delivery note in system.

Exact name

API_UpdateDeliveryNote

Type

Standard executable stored procedure.

Specification

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

 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 nvarchar(25)
 DECLARE @Date datetime
 DECLARE @OrdererName nvarchar(140)
 DECLARE @OrdererStreet nvarchar(100)
 DECLARE @OrdererCity nvarchar(140)
 DECLARE @OrdererZIPCode nvarchar(10)
 DECLARE @OrdererCountry nvarchar(50)
 DECLARE @OrdererRegion nvarchar(30)
 DECLARE @OrdererState nvarchar(50)
 DECLARE @CompanyRegistrationNumber nvarchar(20)
 DECLARE @VATNumber nvarchar(20)
 DECLARE @RecipientName nvarchar(140)
 DECLARE @RecipientStreet nvarchar(100)
 DECLARE @RecipientCity nvarchar(140)
 DECLARE @RecipientZIPCode nvarchar(10)
 DECLARE @RecipientCountry nvarchar(50)
 DECLARE @RecipientRegion nvarchar(30)
 DECLARE @RecipientState nvarchar(50)
 DECLARE @RecipientNote nvarchar(250)
 DECLARE @IsCanceled int
 DECLARE @IsCancelReason nvarchar(150)
 DECLARE @IsCancelDate datetime
 DECLARE @Note nvarchar(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 nvarchar(20)
 DECLARE @RecipientVATNumber nvarchar(20)
 DECLARE @OrdererBankName nvarchar(120)
 DECLARE @OrdererBankAccount nvarchar(50)
 DECLARE @OrdererVATNumber2 nvarchar(20)
 DECLARE @RecipientVATNumber2 nvarchar(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

Notices

None.

Citováno z „https://podpora.nextis.cz/index.php?title=API_UpdateDeliveryNote&oldid=1522“