API UpdateInvoice: Porovnání verzí

Aktuální verze z 9. 11. 2018, 14:10

Obsah

1 Description
2 Exact name
3 Type
4 Specification
5 Return
6 Example
7 Notices

Description

Method allows You to update invoice in system.

Exact name

API_UpdateInvoice

Type

Standard executable stored procedure.

Specification

Parameter	Data type	Description	Relation
@ID	int	Internal system id
@ContactID	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
@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
@DocumentTypeID	int	Document type ID 1 - Invoice 14 - InvoiceProforma 16 - InvoiceForPoints 6 - Chit 8 - CreditNote 15 - DeliveryNote
@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
@PriceTypeID	int	Price type ID 0 - WithVAT 1 - WithoutVAT 2 - VATTransfer
@DocumentNumber	nvarchar(40)	Document number
@Date	datetime	Date
@TaxableSupplyDate	datetime	Taxable supply date
@DueDate	datetime	Due date
@VariableSymbol	bigint	Variable symbol
@BasicPrice	decimal(18,6)	Basic price
@BasicPriceInCurrency	decimal(18,6)	Basic price in currency
@VATPrice	decimal(18,6)	VAT price
@VATPriceInCurrency	decimal(18,6)	VAT price in currency
@TotalPrice	decimal(18,6)	Total price
@TotalPriceInCurrency	decimal(18,6)	Total price in currency
@RoundPrice	decimal(18,4)	Round price
@RoundPriceInCurrency	decimal(18,4)	Round price in currency
@Price	decimal(19,6)	Price
@PriceInCurrency	decimal(19,6)	Price in currency
@Currency	nvarchar(5)	Currency
@CurrencyID	int	ID of currency from currency list (see relation)	API_GetCurrency.ID
@CurrencyIDInCurrency	int	ID of currency from currency list (see relation)	API_GetCurrency.ID
@ExchangeRate	decimal(19,4)	Exchange rate
@ExchangeRate2	decimal(18,4)	Exchange rate 2
@AccountingExchangeRate	decimal(18,6)	Accounting exchange rate
@VATExchangeRate	decimal(18,4)	VAT exchange rate
@AccountingExchangeRate2	decimal(18,6)	Accounting exchange rate 2
@RoundStyle	int	Round style. -1 - not selected, 0 - round off, -1000 - 0,0001, -100 - 0,001 1 - 0,01 3 - 1 4 - 10 5 - 100 6 - 1000
@RoundType	int	Round type -1 - not selected, 1 - Up, 2 - Down, 3 - Mathematical
@SupplierName	nvarchar(140)	Supplier name
@SupplierStreet	nvarchar(100)	Supplier street
@SupplierCity	nvarchar(140)	Supplier city
@SupplierZIPCode	nvarchar(10)	Supplier ZIP code
@SupplierCountry	nvarchar(50)	Supplier country
@SupplierRegion	nvarchar(30)	Supplier region
@SupplierState	nvarchar(50)	Supplier state
@SupplierCompanyRegistrationNumber	nvarchar(20)	Supplier company registration number
@SupplierVATNumber2	nvarchar(20)	Supplier VAT number 2
@SupplierVATNumber	nvarchar(20)	Supplier VAT number
@SupplierPhone	nvarchar(30)	Supplier phone
@SupplierFax	nvarchar(30)	Supplier fax
@SupplierMobilePhone	nvarchar(30)	Supplier mobile phone
@SupplierEmail	nvarchar(60)	Supplier email
@SupplierWeb	nvarchar(50)	Supplier web
@SupplierBankName	nvarchar(120)	Supplier bank name
@SupplierBankAccount	nvarchar(50)	Supplier bank account
@SupplierBankSwift	nvarchar(50)	Supplier bank swift
@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
@OrdererCompanyRegistrationNumber	nvarchar(20)	Orderer company registration number
@OrdererVATNumber2	nvarchar(20)	Orderer VAT number 2
@OrdererVATNumber	nvarchar(20)	Orderer VAT number
@OrdererPhone	nvarchar(30)	Orderer phone
@OrdererFax	nvarchar(30)	Orderer fax
@OrdererMobilePhone	nvarchar(30)	Orderer mobile phone
@OrdererEmail	nvarchar(60)	Orderer email
@OrdererWeb	nvarchar(50)	Orderer web
@OrdererBankName	nvarchar(120)	Orderer bank name
@OrdererBankAccount	nvarchar(50)	Orderer bank account
@RecipientName	nvarchar(120)	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
@RecipientCompanyRegistrationNumber	nvarchar(20)	Recipient company registration number
@RecipientVATNumber	nvarchar(20)	Recipient VAT number
@RecipientPhone	nvarchar(30)	Recipient phone
@RecipientFax	nvarchar(30)	Recipient fax
@RecipientMobilePhone	nvarchar(30)	Recipient mobile phone
@RecipientEmail	nvarchar(60)	Recipient email
@RecipientWeb	nvarchar(50)	Recipient web
@RecipientBankName	nvarchar(120)	Recipient bank name
@RecipientBankAccount	nvarchar(50)	Recipient bank account
@IsCanceled	int	Is canceled
@CancelationReason	nvarchar(100)	Cancelation reason
@CancelationDate	datetime	Cancelation date
@IsForeign	int	Is foreign
@FinancialYear	int	Financial year
@FinancialMonth	int	Financial month
@Note	nvarchar(500)	Note
@Note2	nvarchar(120)	Note 2
@IsPrintedOnFiscal	int	Is printed on fiscal
@FiskalComputerName	nvarchar(255)	Fiskal computer name
@IsPrinted	int	Is printed
@CancelDocument	int	Cancel document
@CancelDocumentOriginID	int	ID of invoice from invoice list (see relation)	API_GetInvoices.ID
@FiskalPrintDate	date	Fiskal print date
@FiskalPrintOrder	int	Fiskal print order
@Basis0	numeric(18,4)	Basis 0
@BasisInCurrency0	numeric(18,6)	Basis in currency 0
@Tax0	numeric(18,4)	Tax 0
@TaxInCurrency0	numeric(18,6)	Tax in currency 0
@VATRateID0	int	ID of VAT rates from VAT rates list (see relation)	API_GetVATRates.ID
@Basis1	numeric(18,4)	Basis 1
@BasisInCurrency1	numeric(18,6)	Basis in currency 1
@Tax1	numeric(18,4)	Tax 1
@TaxInCurrency1	numeric(18,6)	Tax in currency 1
@VATRateID1	int	ID of VAT rates from VAT rates list (see relation)	API_GetVATRates.ID
@Basis2	numeric(18,4)	Basis 2
@BasisInCurrency2	numeric(18,6)	Basis in currency 2
@Tax2	numeric(18,4)	Tax 2
@TaxInCurrency2	numeric(18,6)	Tax in currency 2
@VATRateID2	int	ID of VAT rates from VAT rates list (see relation)	API_GetVATRates.ID

Return

0 : OK
100 : Item could not be updated

Example

 DECLARE @return_value int
 DECLARE @ID int 
 DECLARE @ContactID int 
 DECLARE @OrdererID int 
 DECLARE @RecipientID int 
 DECLARE @StockID int 
 DECLARE @BranchID int 
 DECLARE @DocumentTypeID int 
 DECLARE @TransportID int 
 DECLARE @PaymentTypeID int 
 DECLARE @PriceTypeID int 
 DECLARE @DocumentNumber nvarchar(40) 
 DECLARE @Date datetime 
 DECLARE @TaxableSupplyDate datetime 
 DECLARE @DueDate datetime 
 DECLARE @VariableSymbol bigint 
 DECLARE @BasicPrice decimal(18,6) 
 DECLARE @BasicPriceInCurrency decimal(18,6) 
 DECLARE @VATPrice decimal(18,6) 
 DECLARE @VATPriceInCurrency decimal(18,6) 
 DECLARE @TotalPrice decimal(18,6) 
 DECLARE @TotalPriceInCurrency decimal(18,6) 
 DECLARE @RoundPrice decimal(18,4) 
 DECLARE @RoundPriceInCurrency decimal(18,4) 
 DECLARE @Price decimal(19,6) 
 DECLARE @PriceInCurrency decimal(19,6) 
 DECLARE @Currency nvarchar(5) 
 DECLARE @CurrencyID int 
 DECLARE @CurrencyIDInCurrency int 
 DECLARE @ExchangeRate decimal(19,4) 
 DECLARE @ExchangeRate2 decimal(18,4) 
 DECLARE @AccountingExchangeRate decimal(18,6) 
 DECLARE @VATExchangeRate decimal(18,4) 
 DECLARE @AccountingExchangeRate2 decimal(18,6) 
 DECLARE @RoundStyle int 
 DECLARE @RoundType int 
 DECLARE @SupplierName nvarchar(140) 
 DECLARE @SupplierStreet nvarchar(100) 
 DECLARE @SupplierCity nvarchar(140) 
 DECLARE @SupplierZIPCode nvarchar(10) 
 DECLARE @SupplierCountry nvarchar(50) 
 DECLARE @SupplierRegion nvarchar(30) 
 DECLARE @SupplierState nvarchar(50) 
 DECLARE @SupplierCompanyRegistrationNumber nvarchar(20) 
 DECLARE @SupplierVATNumber2 nvarchar(20) 
 DECLARE @SupplierVATNumber nvarchar(20) 
 DECLARE @SupplierPhone nvarchar(30) 
 DECLARE @SupplierFax nvarchar(30) 
 DECLARE @SupplierMobilePhone nvarchar(30) 
 DECLARE @SupplierEmail nvarchar(60) 
 DECLARE @SupplierWeb nvarchar(50) 
 DECLARE @SupplierBankName nvarchar(120) 
 DECLARE @SupplierBankAccount nvarchar(50) 
 DECLARE @SupplierBankSwift nvarchar(50) 
 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 @OrdererCompanyRegistrationNumber nvarchar(20) 
 DECLARE @OrdererVATNumber2 nvarchar(20) 
 DECLARE @OrdererVATNumber nvarchar(20) 
 DECLARE @OrdererPhone nvarchar(30) 
 DECLARE @OrdererFax nvarchar(30) 
 DECLARE @OrdererMobilePhone nvarchar(30) 
 DECLARE @OrdererEmail nvarchar(60) 
 DECLARE @OrdererWeb nvarchar(50) 
 DECLARE @OrdererBankName nvarchar(120) 
 DECLARE @OrdererBankAccount nvarchar(50) 
 DECLARE @RecipientName nvarchar(120) 
 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 @RecipientCompanyRegistrationNumber nvarchar(20) 
 DECLARE @RecipientVATNumber nvarchar(20) 
 DECLARE @RecipientPhone nvarchar(30) 
 DECLARE @RecipientFax nvarchar(30) 
 DECLARE @RecipientMobilePhone nvarchar(30) 
 DECLARE @RecipientEmail nvarchar(60) 
 DECLARE @RecipientWeb nvarchar(50) 
 DECLARE @RecipientBankName nvarchar(120) 
 DECLARE @RecipientBankAccount nvarchar(50) 
 DECLARE @IsCanceled int 
 DECLARE @CancelationReason nvarchar(100) 
 DECLARE @CancelationDate datetime 
 DECLARE @IsForeign int 
 DECLARE @FinancialYear int 
 DECLARE @FinancialMonth int 
 DECLARE @Note nvarchar(500) 
 DECLARE @Note2 nvarchar(120) 
 DECLARE @IsPrintedOnFiscal int 
 DECLARE @FiskalComputerName nvarchar(255) 
 DECLARE @IsPrinted int 
 DECLARE @CancelDocument int 
 DECLARE @CancelDocumentOriginID int 
 DECLARE @FiskalPrintDate date 
 DECLARE @FiskalPrintOrder int 

 DECLARE @Basis0 numeric(18,4)
 DECLARE @BasisInCurrency0 numeric(18,6)
 DECLARE @Tax0 numeric(18,4)
 DECLARE @TaxInCurrency0 numeric(18,6)
 DECLARE @VATRateID0 int
 DECLARE @Basis1 numeric(18,4)
 DECLARE @BasisInCurrency1 numeric(18,6)
 DECLARE @Tax1 numeric(18,4)
 DECLARE @TaxInCurrency1 numeric(18,6)
 DECLARE @VATRateID1 int
 DECLARE @Basis2 numeric(18,4)
 DECLARE @BasisInCurrency2 numeric(18,6)
 DECLARE @Tax2 numeric(18,4)
 DECLARE @TaxInCurrency2 numeric(18,6)
 DECLARE @VATRateID2 int

 set @VATRateID0 = -1
 set @VATRateID1 = 16028
 set @VATRateID2 = -1
 
 SELECT @ID = [ID], 
       @ContactID = [ContactID],
       @OrdererID = [OrdererID],
       @RecipientID = [RecipientID],
       @StockID = [StockID],
       @BranchID = [BranchID],
       @DocumentTypeID = [DocumentTypeID],
       @TransportID = [TransportID],
       @PaymentTypeID = [PaymentTypeID],
       @PriceTypeID = [PriceTypeID],
       @DocumentNumber = [DocumentNumber],
       @Date = [Date],
       @TaxableSupplyDate = [TaxableSupplyDate],
       @DueDate = [DueDate],
       @VariableSymbol = '123654897',
       @BasicPrice = [BasicPrice],
       @BasicPriceInCurrency = [BasicPriceInCurrency],
       @VATPrice = [VATPrice],
       @VATPriceInCurrency = [VATPriceInCurrency],
       @TotalPrice = [TotalPrice],
       @TotalPriceInCurrency = [TotalPriceInCurrency],
       @RoundPrice = [RoundPrice],
       @RoundPriceInCurrency = [RoundPriceInCurrency],
       @Price = [Price],
       @PriceInCurrency = [PriceInCurrency],
       @Currency = [Currency],
       @CurrencyID = [CurrencyID],
       @CurrencyIDInCurrency = [CurrencyIDInCurrency],
       @ExchangeRate = [ExchangeRate],
       @ExchangeRate2 = [ExchangeRate2],
       @AccountingExchangeRate = [AccountingExchangeRate],
       @VATExchangeRate = [VATExchangeRate],
       @AccountingExchangeRate2 = [AccountingExchangeRate2],
       @RoundStyle = [RoundStyle],
       @RoundType = [RoundType],
       @SupplierName = [SupplierName],
       @SupplierStreet = [SupplierStreet],
       @SupplierCity = [SupplierCity],
       @SupplierZIPCode = [SupplierZIPCode],
       @SupplierCountry = [SupplierCountry],
       @SupplierRegion = [SupplierRegion],
       @SupplierState = [SupplierState],
       @SupplierCompanyRegistrationNumber = [SupplierCompanyRegistrationNumber],
       @SupplierVATNumber2 = [SupplierVATNumber2],
       @SupplierVATNumber = [SupplierVATNumber],
       @SupplierPhone = [SupplierPhone],
       @SupplierFax = [SupplierFax],
       @SupplierMobilePhone = [SupplierMobilePhone],
       @SupplierEmail = [SupplierEmail],
       @SupplierWeb = [SupplierWeb],
       @SupplierBankName = [SupplierBankName],
       @SupplierBankAccount = [SupplierBankAccount],
       @SupplierBankSwift = [SupplierBankSwift],
       @OrdererName = [OrdererName],
       @OrdererStreet = [OrdererStreet],
       @OrdererCity = [OrdererCity],
       @OrdererZIPCode = [OrdererZIPCode],
       @OrdererCountry = [OrdererCountry],
       @OrdererRegion = [OrdererRegion],
       @OrdererState = [OrdererState],
       @OrdererCompanyRegistrationNumber = [OrdererCompanyRegistrationNumber],
       @OrdererVATNumber2 = [OrdererVATNumber2],
       @OrdererVATNumber = [OrdererVATNumber],
       @OrdererPhone = [OrdererPhone],
       @OrdererFax = [OrdererFax],
       @OrdererMobilePhone = [OrdererMobilePhone],
       @OrdererEmail = [OrdererEmail],
       @OrdererWeb = [OrdererWeb],
       @OrdererBankName = [OrdererBankName],
       @OrdererBankAccount = [OrdererBankAccount],
       @RecipientName = [RecipientName],
       @RecipientStreet = [RecipientStreet],
       @RecipientCity = [RecipientCity],
       @RecipientZIPCode = [RecipientZIPCode],
       @RecipientCountry = [RecipientCountry],
       @RecipientRegion = [RecipientRegion],
       @RecipientState = [RecipientState],
       @RecipientCompanyRegistrationNumber = [RecipientCompanyRegistrationNumber],
       @RecipientVATNumber = [RecipientVATNumber],
       @RecipientPhone = [RecipientPhone],
       @RecipientFax = [RecipientFax],
       @RecipientMobilePhone = [RecipientMobilePhone],
       @RecipientEmail = [RecipientEmail],
       @RecipientWeb = [RecipientWeb],
       @RecipientBankName = [RecipientBankName],
       @RecipientBankAccount = [RecipientBankAccount],
       @IsCanceled = [IsCanceled],
       @CancelationReason = [CancelationReason],
       @CancelationDate = [CancelationDate],
       @IsForeign = [IsForeign],
       @FinancialYear = [FinancialYear],
       @FinancialMonth = [FinancialMonth],
       @Note = [Note],
       @Note2 = [Note2],
       @IsPrintedOnFiscal = [IsPrintedOnFiscal],
       @FiskalComputerName = [FiskalComputerName],
       @IsPrinted = [IsPrinted],
       @CancelDocument = [CancelDocument],
       @CancelDocumentOriginID = [CancelDocumentOriginID],
       @FiskalPrintDate = [FiskalPrintDate],
       @FiskalPrintOrder = [FiskalPrintOrder]
 FROM   [API_GetInvoices] 
 WHERE  id = 8


SELECT @Basis0 = [basis], 
       @BasisInCurrency0 = [basisincurrency], 
       @Tax0 = [tax], 
       @TaxInCurrency0 = [taxincurrency] 
FROM   [API_GetDocumentVAT] 
WHERE  [documentid] = @ID 
       AND [rate] = (SELECT [value] 
                     FROM   [API_GetVATRates] 
                     WHERE  id = @VATRateID0) 
       AND isrounding = 0 


SELECT @Basis1 = [basis], 
       @BasisInCurrency1 = [basisincurrency], 
       @Tax1 = [tax], 
       @TaxInCurrency1 = [taxincurrency] 
FROM   [API_GetDocumentVAT] 
WHERE  [documentid] = @ID 
       AND [rate] = (SELECT [value] 
                     FROM   [API_GetVATRates] 
                     WHERE  id = @VATRateID1) 
       AND isrounding = 0 


SELECT @Basis2 = [basis], 
       @BasisInCurrency2 = [basisincurrency], 
       @Tax2 = [tax], 
       @TaxInCurrency2 = [taxincurrency] 
FROM   [API_GetDocumentVAT] 
WHERE  [documentid] = @ID 
       AND [rate] = (SELECT [value] 
                     FROM   [API_GetVATRates] 
                     WHERE  id = @VATRateID2) 
       AND isrounding = 0 


 
 EXECUTE @return_value = [API_UpdateInvoice] 
  @ID,
  @ContactID,
  @OrdererID,
  @RecipientID,
  @StockID,
  @BranchID,
  @DocumentTypeID,
  @TransportID,
  @PaymentTypeID,
  @PriceTypeID,
  @DocumentNumber,
  @Date,
  @TaxableSupplyDate,
  @DueDate,
  @VariableSymbol,
  @BasicPrice,
  @BasicPriceInCurrency,
  @VATPrice,
  @VATPriceInCurrency,
  @TotalPrice,
  @TotalPriceInCurrency,
  @RoundPrice,
  @RoundPriceInCurrency,
  @Price,
  @PriceInCurrency,
  @Currency,
  @CurrencyID,
  @CurrencyIDInCurrency,
  @ExchangeRate,
  @ExchangeRate2,
  @AccountingExchangeRate,
  @VATExchangeRate,
  @AccountingExchangeRate2,
  @RoundStyle,
  @RoundType,
  @SupplierName,
  @SupplierStreet,
  @SupplierCity,
  @SupplierZIPCode,
  @SupplierCountry,
  @SupplierRegion,
  @SupplierState,
  @SupplierCompanyRegistrationNumber,
  @SupplierVATNumber2,
  @SupplierVATNumber,
  @SupplierPhone,
  @SupplierFax,
  @SupplierMobilePhone,
  @SupplierEmail,
  @SupplierWeb,
  @SupplierBankName,
  @SupplierBankAccount,
  @SupplierBankSwift,
  @OrdererName,
  @OrdererStreet,
  @OrdererCity,
  @OrdererZIPCode,
  @OrdererCountry,
  @OrdererRegion,
  @OrdererState,
  @OrdererCompanyRegistrationNumber,
  @OrdererVATNumber2,
  @OrdererVATNumber,
  @OrdererPhone,
  @OrdererFax,
  @OrdererMobilePhone,
  @OrdererEmail,
  @OrdererWeb,
  @OrdererBankName,
  @OrdererBankAccount,
  @RecipientName,
  @RecipientStreet,
  @RecipientCity,
  @RecipientZIPCode,
  @RecipientCountry,
  @RecipientRegion,
  @RecipientState,
  @RecipientCompanyRegistrationNumber,
  @RecipientVATNumber,
  @RecipientPhone,
  @RecipientFax,
  @RecipientMobilePhone,
  @RecipientEmail,
  @RecipientWeb,
  @RecipientBankName,
  @RecipientBankAccount,
  @IsCanceled,
  @CancelationReason,
  @CancelationDate,
  @IsForeign,
  @FinancialYear,
  @FinancialMonth,
  @Note,
  @Note2,
  @IsPrintedOnFiscal,
  @FiskalComputerName,
  @IsPrinted,
  @CancelDocument,
  @CancelDocumentOriginID,
  @FiskalPrintDate,
  @FiskalPrintOrder,
  @Basis0,
  @BasisInCurrency0,
  @Tax0,
  @TaxInCurrency0,
  @VATRateID0,
  @Basis1,
  @BasisInCurrency1,
  @Tax1,
  @TaxInCurrency1,
  @VATRateID1,
  @Basis2,
  @BasisInCurrency2,
  @Tax2,
  @TaxInCurrency2,
  @VATRateID2

Notices

None.

@@ Řádka 199: / Řádka 199: @@
 |-
 |@Currency
-|varchar(5)
+|nvarchar(5)
 |
 |Currency
@@ Řádka 301: / Řádka 301: @@
 |-
 |@SupplierZIPCode
-|char(10)
+|nvarchar(10)
 |
 |Supplier ZIP code
@@ Řádka 325: / Řádka 325: @@
 |-
 |@SupplierCompanyRegistrationNumber
-|char(20)
+|nvarchar(20)
 |
 |Supplier company registration number
@@ Řádka 331: / Řádka 331: @@
 |-
 |@SupplierVATNumber2
-|char(20)
+|nvarchar(20)
 |
 |Supplier VAT number 2
@@ Řádka 337: / Řádka 337: @@
 |-
 |@SupplierVATNumber
-|char(20)
+|nvarchar(20)
 |
 |Supplier VAT number
@@ Řádka 409: / Řádka 409: @@
 |-
 |@OrdererZIPCode
-|char(10)
+|nvarchar(10)
 |
 |Orderer ZIP code
@@ Řádka 433: / Řádka 433: @@
 |-
 |@OrdererCompanyRegistrationNumber
-|char(20)
+|nvarchar(20)
 |
 |Orderer company registration number
@@ Řádka 439: / Řádka 439: @@
 |-
 |@OrdererVATNumber2
-|char(20)
+|nvarchar(20)
 |
 |Orderer VAT number 2
@@ Řádka 445: / Řádka 445: @@
 |-
 |@OrdererVATNumber
-|char(20)
+|nvarchar(20)
 |
 |Orderer VAT number
@@ Řádka 511: / Řádka 511: @@
 |-
 |@RecipientZIPCode
-|char(10)
+|nvarchar(10)
 |
 |Recipient ZIP code
@@ Řádka 535: / Řádka 535: @@
 |-
 |@RecipientCompanyRegistrationNumber
-|char(20)
+|nvarchar(20)
 |
 |Recipient company registration number
@@ Řádka 541: / Řádka 541: @@
 |-
 |@RecipientVATNumber
-|char(20)
+|nvarchar(20)
 |
 |Recipient VAT number
@@ Řádka 631: / Řádka 631: @@
 |-
 |@Note2
-|varchar(120)
+|nvarchar(120)
 |
 |Note 2
@@ Řádka 738: / Řádka 738: @@
 |API_GetVATRates.ID
 |-
-|Basis2
+|@Basis2
 |numeric(18,4)
 |
@@ Řádka 769: / Řádka 769: @@
 |}
+==== Return ====
+: OK
+: Item could not be updated
 ==== Example ====
 <syntaxhighlight lang="sql">
+ DECLARE @return_value int
   DECLARE @ID int
   DECLARE @ContactID int
@@ Řádka 797: / Řádka 801: @@
   DECLARE @Price decimal(19,6)
   DECLARE @PriceInCurrency decimal(19,6)
-  DECLARE @Currency varchar(5)
+  DECLARE @Currency nvarchar(5)
   DECLARE @CurrencyID int
   DECLARE @CurrencyIDInCurrency int
@@ Řádka 810: / Řádka 814: @@
   DECLARE @SupplierStreet nvarchar(100)
   DECLARE @SupplierCity nvarchar(140)
-  DECLARE @SupplierZIPCode char(10)
+  DECLARE @SupplierZIPCode nvarchar(10)
   DECLARE @SupplierCountry nvarchar(50)
   DECLARE @SupplierRegion nvarchar(30)
   DECLARE @SupplierState nvarchar(50)
-  DECLARE @SupplierCompanyRegistrationNumber char(20)
+  DECLARE @SupplierCompanyRegistrationNumber nvarchar(20)
-  DECLARE @SupplierVATNumber2 char(20)
+  DECLARE @SupplierVATNumber2 nvarchar(20)
-  DECLARE @SupplierVATNumber char(20)
+  DECLARE @SupplierVATNumber nvarchar(20)
   DECLARE @SupplierPhone nvarchar(30)
   DECLARE @SupplierFax nvarchar(30)
@@ Řádka 828: / Řádka 832: @@
   DECLARE @OrdererStreet nvarchar(100)
   DECLARE @OrdererCity nvarchar(140)
-  DECLARE @OrdererZIPCode char(10)
+  DECLARE @OrdererZIPCode nvarchar(10)
   DECLARE @OrdererCountry nvarchar(50)
   DECLARE @OrdererRegion nvarchar(30)
   DECLARE @OrdererState nvarchar(50)
-  DECLARE @OrdererCompanyRegistrationNumber char(20)
+  DECLARE @OrdererCompanyRegistrationNumber nvarchar(20)
-  DECLARE @OrdererVATNumber2 char(20)
+  DECLARE @OrdererVATNumber2 nvarchar(20)
-  DECLARE @OrdererVATNumber char(20)
+  DECLARE @OrdererVATNumber nvarchar(20)
   DECLARE @OrdererPhone nvarchar(30)
   DECLARE @OrdererFax nvarchar(30)
@@ Řádka 845: / Řádka 849: @@
   DECLARE @RecipientStreet nvarchar(100)
   DECLARE @RecipientCity nvarchar(140)
-  DECLARE @RecipientZIPCode char(10)
+  DECLARE @RecipientZIPCode nvarchar(10)
   DECLARE @RecipientCountry nvarchar(50)
   DECLARE @RecipientRegion nvarchar(30)
   DECLARE @RecipientState nvarchar(50)
-  DECLARE @RecipientCompanyRegistrationNumber char(20)
+  DECLARE @RecipientCompanyRegistrationNumber nvarchar(20)
-  DECLARE @RecipientVATNumber char(20)
+  DECLARE @RecipientVATNumber nvarchar(20)
   DECLARE @RecipientPhone nvarchar(30)
   DECLARE @RecipientFax nvarchar(30)
@@ Řádka 865: / Řádka 869: @@
   DECLARE @FinancialMonth int
   DECLARE @Note nvarchar(500)
-  DECLARE @Note2 varchar(120)
+  DECLARE @Note2 nvarchar(120)
   DECLARE @IsPrintedOnFiscal int
   DECLARE @FiskalComputerName nvarchar(255)
@@ Řádka 890: / Řádka 894: @@
   DECLARE @VATRateID2 int
+ set @VATRateID0 = -1
+ set @VATRateID1 = 16028
+ set @VATRateID2 = -1
   SELECT @ID = [ID],
-       @ID = [ID],
         @ContactID = [ContactID],
         @OrdererID = [OrdererID],
@@ Řádka 906: / Řádka 912: @@
         @TaxableSupplyDate = [TaxableSupplyDate],
         @DueDate = [DueDate],
-        @VariableSymbol = [VariableSymbol],
+        @VariableSymbol = '123654897',
         @BasicPrice = [BasicPrice],
         @BasicPriceInCurrency = [BasicPriceInCurrency],
@@ Řádka 1 034: / Řádka 1 040: @@
-  EXECUTE [API_UpdateInvoice]
+  EXECUTE @return_value = [API_UpdateInvoice]
    @ID,
    @ContactID,

API UpdateInvoice: Porovnání verzí

Aktuální verze z 9. 11. 2018, 14:10

Obsah

Description

Exact name

Type

Specification

Return

Example

Notices

Navigační menu

Osobní nástroje

Jmenné prostory

Varianty

Zobrazení

Další

Hledat

Navigace

Nástroje

Videonávody