API CreateInvoice - Historie editací

Chrzaszcz v 9. 11. 2018, 13:03

2018-11-09T13:03:52Z

Chrzaszcz v 22. 9. 2017, 08:26

2017-09-22T08:26:20Z

Chrzaszcz: /* Example */

2017-08-03T11:43:13Z

‎Example

Chrzaszcz v 3. 8. 2017, 11:22

2017-08-03T11:22:06Z

Chrzaszcz: /* Example */

2017-08-03T11:14:27Z

‎Example

Chrzaszcz v 3. 8. 2017, 09:01

2017-08-03T09:01:29Z

Ukázat změny

Chrzaszcz v 3. 8. 2017, 08:57

2017-08-03T08:57:31Z

Ukázat změny

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to create new branch in system. ==== Exact name ==== `API_CreateInvoice` ==== Type ==== Standard execu…“

2017-08-03T08:56:07Z

Založena nová stránka s textem „==== Description ==== Method allows You to create new branch in system. ==== Exact name ==== <code>API_CreateInvoice</code> ==== Type ==== Standard execu…“

Nová stránka

==== Description ====
Method allows You to create new branch in system.

==== Exact name ====
<code>API_CreateInvoice</code>

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

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|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
|varchar(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
|char(10)
|Supplier ZIP code
|
|-
|SupplierCountry
|nvarchar(50)
|Supplier country
|
|-
|SupplierRegion
|nvarchar(30)
|Supplier region
|
|-
|SupplierState
|nvarchar(50)
|Supplier state
|
|-
|SupplierCompanyRegistrationNumber
|char(20)
|Supplier company registration number
|
|-
|SupplierVATNumber2
|char(20)
|Supplier VAT number 2
|
|-
|SupplierVATNumber
|char(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
|char(10)
|Orderer ZIP code
|
|-
|OrdererCountry
|nvarchar(50)
|Orderer country
|
|-
|OrdererRegion
|nvarchar(30)
|Orderer region
|
|-
|OrdererState
|nvarchar(50)
|Orderer state
|
|-
|OrdererCompanyRegistrationNumber
|char(20)
|Orderer company registration number
|
|-
|OrdererVATNumber2
|char(20)
|Orderer VAT number 2
|
|-
|OrdererVATNumber
|char(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
|char(10)
|Recipient ZIP code
|
|-
|RecipientCountry
|nvarchar(50)
|Recipient country
|
|-
|RecipientRegion
|nvarchar(30)
|Recipient region
|
|-
|RecipientState
|nvarchar(50)
|Recipient state
|
|-
|RecipientCompanyRegistrationNumber
|char(20)
|Recipient company registration number
|
|-
|RecipientVATNumber
|char(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
|varchar(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
|
|}

==== Example ====
<syntaxhighlight lang="sql">
EXEC [API_CreateInvoice] @WorkshopID = 1 ,@Name = 'Name'
</syntaxhighlight>

==== Notices ====
None.

@@ Řádka 193: / Řádka 193: @@
 |-
 |@Currency
-|varchar(5)
+|nvarchar(5)
+|
 |Currency
@@ Řádka 295: / Řádka 295: @@
 |-
 |@SupplierZIPCode
-|char(10)
+|nvarchar(10)
+|
 |Supplier ZIP code
@@ Řádka 319: / Řádka 319: @@
 |-
 |@SupplierCompanyRegistrationNumber
-|char(20)
+|nvarchar(20)
+|
 |Supplier company registration number
@@ Řádka 325: / Řádka 325: @@
 |-
 |@SupplierVATNumber2
-|char(20)
+|nvarchar(20)
+|
 |Supplier VAT number 2
@@ Řádka 331: / Řádka 331: @@
 |-
 |@SupplierVATNumber
-|char(20)
+|nvarchar(20)
+|
 |Supplier VAT number
@@ Řádka 403: / Řádka 403: @@
 |-
 |@OrdererZIPCode
-|char(10)
+|nvarchar(10)
+|
 |Orderer ZIP code
@@ Řádka 427: / Řádka 427: @@
 |-
 |@OrdererCompanyRegistrationNumber
-|char(20)
+|nvarchar(20)
+|
 |Orderer company registration number
@@ Řádka 433: / Řádka 433: @@
 |-
 |@OrdererVATNumber2
-|char(20)
+|nvarchar(20)
+|
 |Orderer VAT number 2
@@ Řádka 439: / Řádka 439: @@
 |-
 |@OrdererVATNumber
-|char(20)
+|nvarchar(20)
+|
 |Orderer VAT number
@@ Řádka 505: / Řádka 505: @@
 |-
 |@RecipientZIPCode
-|char(10)
+|nvarchar(10)
+|
 |Recipient ZIP code
@@ Řádka 529: / Řádka 529: @@
 |-
 |@RecipientCompanyRegistrationNumber
-|char(20)
+|nvarchar(20)
+|
 |Recipient company registration number
@@ Řádka 535: / Řádka 535: @@
 |-
 |@RecipientVATNumber
-|char(20)
+|nvarchar(20)
+|
 |Recipient VAT number
@@ Řádka 625: / Řádka 625: @@
 |-
 |@Note2
-|varchar(120)
+|nvarchar(120)
+|
 |Note 2

@@ Řádka 762: / Řádka 762: @@
 |API_GetVATRates.ID
 |}
 ==== Example ====
 <syntaxhighlight lang="sql">
 DECLARE @d datetime
 set @d = getdate()
-EXEC [API_CreateInvoice] @ContactID= 14 ,@OrdererID= 14 ,@RecipientID= 14 ,@StockID= 1 ,@BranchID= 1 ,@DocumentTypeID= 1 ,@TransportID= 1 ,@PaymentTypeID= 1 ,@PriceTypeID= 0 ,@DocumentNumber= 'DocumentNumber12' ,@Date= @d ,@TaxableSupplyDate= @d ,@DueDate= @d ,@VariableSymbol= 123456789 ,@BasicPrice= 270.000000 ,@BasicPriceInCurrency= 270.000000 ,@VATPrice= 56.700000 ,@VATPriceInCurrency= 56.700000 ,@TotalPrice= 327.000000 ,@TotalPriceInCurrency= 327.000000 ,@RoundPrice= 0.3000 ,@RoundPriceInCurrency= 0.3000 ,@Price= 327.000000 ,@PriceInCurrency= 327.000000 ,@Currency= 'CZK' ,@CurrencyID= 144 ,@CurrencyIDInCurrency= 144 ,@ExchangeRate= 1.0000 ,@ExchangeRate2= 1.0000 ,@AccountingExchangeRate= 1.000000 ,@VATExchangeRate= 1.0000 ,@AccountingExchangeRate2= 1.000000 ,@RoundStyle= 3 ,@RoundType= 3 ,@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= null ,@CancelationReason= null ,@CancelationDate= null ,@IsForeign= 0 ,@FinancialYear= 2017 ,@FinancialMonth= 8 ,@Note= '' ,@Note2= '' ,@IsPrintedOnFiscal= 0 ,@FiskalComputerName= null ,@IsPrinted= 0 ,@CancelDocument= 0 ,@CancelDocumentOriginID= 0 ,@FiskalPrintDate= null ,@FiskalPrintOrder= null ,@Basis0= 0 ,@BasisInCurrency0= 0 ,@Tax0= 0 ,@TaxInCurrency0= 0 ,@VATRateID0= -1 ,@Basis1= 270.0000 ,@BasisInCurrency1= 270.0000 ,@Tax1= 56.7000 ,@TaxInCurrency1= 56.7000 ,@VATRateID1= 16028 ,@Basis2= 0 ,@BasisInCurrency2= 0 ,@Tax2=0 ,@TaxInCurrency2= 0 ,@VATRateID2= -1
+EXEC @return_value = [API_CreateInvoice] @ContactID= 14 ,@OrdererID= 14 ,@RecipientID= 14 ,@StockID= 1 ,@BranchID= 1 ,@DocumentTypeID= 1 ,@TransportID= 1 ,@PaymentTypeID= 1 ,@PriceTypeID= 0 ,@DocumentNumber= 'DocumentNumber12' ,@Date= @d ,@TaxableSupplyDate= @d ,@DueDate= @d ,@VariableSymbol= 123456789 ,@BasicPrice= 270.000000 ,@BasicPriceInCurrency= 270.000000 ,@VATPrice= 56.700000 ,@VATPriceInCurrency= 56.700000 ,@TotalPrice= 327.000000 ,@TotalPriceInCurrency= 327.000000 ,@RoundPrice= 0.3000 ,@RoundPriceInCurrency= 0.3000 ,@Price= 327.000000 ,@PriceInCurrency= 327.000000 ,@Currency= 'CZK' ,@CurrencyID= 144 ,@CurrencyIDInCurrency= 144 ,@ExchangeRate= 1.0000 ,@ExchangeRate2= 1.0000 ,@AccountingExchangeRate= 1.000000 ,@VATExchangeRate= 1.0000 ,@AccountingExchangeRate2= 1.000000 ,@RoundStyle= 3 ,@RoundType= 3 ,@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= null ,@CancelationReason= null ,@CancelationDate= null ,@IsForeign= 0 ,@FinancialYear= 2017 ,@FinancialMonth= 8 ,@Note= '' ,@Note2= '' ,@IsPrintedOnFiscal= 0 ,@FiskalComputerName= null ,@IsPrinted= 0 ,@CancelDocument= 0 ,@CancelDocumentOriginID= 0 ,@FiskalPrintDate= null ,@FiskalPrintOrder= null ,@Basis0= 0 ,@BasisInCurrency0= 0 ,@Tax0= 0 ,@TaxInCurrency0= 0 ,@VATRateID0= -1 ,@Basis1= 270.0000 ,@BasisInCurrency1= 270.0000 ,@Tax1= 56.7000 ,@TaxInCurrency1= 56.7000 ,@VATRateID1= 16028 ,@Basis2= 0 ,@BasisInCurrency2= 0 ,@Tax2=0 ,@TaxInCurrency2= 0 ,@VATRateID2= -1
 </syntaxhighlight>
 ==== Notices ====
 None.

@@ Řádka 673: / Řádka 673: @@
 |-
 |@Basis0
+|numeric(18,4)
+|
 |Basis 0
@@ Řádka 679: / Řádka 679: @@
 |-
 |@BasisInCurrency0
+|
 |Basis in currency 0
+|
 |-
+|
+|Tax 0
+|
 |-
+|
+|Tax in currency 0
+|
 |-
+|
+|ID of VAT rates from VAT rates list (see relation)
+|API_GetVATRates.ID
 |-
+|
+|Basis 1
+|
 |-
+|
+|Basis in currency 1
+|
 |-
+|
+|Tax 1
+|
 |-
+|
+|Tax in currency 1
+|
 |-
+|
+|ID of VAT rates from VAT rates list (see relation)
+|API_GetVATRates.ID
 |-
+|
+|Basis 2
+|
 |-
+|
+|Basis in currency 2
+|
 |-
+|
+|Tax 2
+|
 |-
+|
+|Tax in currency 2
+|
 |-
+|
+|ID of VAT rates from VAT rates list (see relation)
+|API_GetVATRates.ID
 |}

@@ Řádka 670: / Řádka 670: @@
+|
 |Fiskal print order
+|
 |}
@@ Řádka 675: / Řádka 765: @@
 ==== Example ====
 <syntaxhighlight lang="sql">
-EXEC [API_CreateInvoice] @WorkshopID = 1 ,@Name = 'Name'
+EXEC [API_CreateInvoice] @ContactID= 14 ,@OrdererID= 14 ,@RecipientID= 14 ,@StockID= 1 ,@BranchID= 1 ,@DocumentTypeID= 1 ,@TransportID= 1 ,@PaymentTypeID= 1 ,@PriceTypeID= 0 ,@DocumentNumber= 'DocumentNumber12' ,@Date= Getdate() ,@TaxableSupplyDate= Getdate() ,@DueDate= Getdate() ,@VariableSymbol= 123456789 ,@BasicPrice= 270.000000 ,@BasicPriceInCurrency= 270.000000 ,@VATPrice= 56.700000 ,@VATPriceInCurrency= 56.700000 ,@TotalPrice= 327.000000 ,@TotalPriceInCurrency= 327.000000 ,@RoundPrice= 0.3000 ,@RoundPriceInCurrency= 0.3000 ,@Price= 327.000000 ,@PriceInCurrency= 327.000000 ,@Currency= 'CZK' ,@CurrencyID= 144 ,@CurrencyIDInCurrency= 144 ,@ExchangeRate= 1.0000 ,@ExchangeRate2= 1.0000 ,@AccountingExchangeRate= 1.000000 ,@VATExchangeRate= 1.0000 ,@AccountingExchangeRate2= 1.000000 ,@RoundStyle= 3 ,@RoundType= 3 ,@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= null ,@CancelationReason= null ,@CancelationDate= null ,@IsForeign= 0 ,@FinancialYear= 2017 ,@FinancialMonth= 8 ,@Note= '' ,@Note2= '' ,@IsPrintedOnFiscal= 0 ,@FiskalComputerName= null ,@IsPrinted= 0 ,@CancelDocument= 0 ,@CancelDocumentOriginID= 0 ,@FiskalPrintDate= null ,@FiskalPrintOrder= null ,@Basis0= 0 ,@BasisInCurrency0= 0 ,@Tax0= 0 ,@TaxInCurrency0= 0 ,@VATRateID0= -1 ,@Basis1= 270.0000 ,@BasisInCurrency1= 270.0000 ,@Tax1= 56.7000 ,@TaxInCurrency1= 56.7000 ,@VATRateID1= 16028 ,@Basis2= 0 ,@BasisInCurrency2= 0 ,@Tax2=0 ,@TaxInCurrency2= 0 ,@VATRateID2= -1
 </syntaxhighlight>
 ==== Notices ====
 None.

API CreateInvoice - Historie editací

Chrzaszcz v 9. 11. 2018, 13:03

Chrzaszcz v 22. 9. 2017, 08:26

Chrzaszcz: /* Example */

Chrzaszcz v 3. 8. 2017, 11:22

Chrzaszcz: /* Example */

Chrzaszcz v 3. 8. 2017, 09:01

Chrzaszcz v 3. 8. 2017, 08:57

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to create new branch in system. ==== Exact name ==== API_CreateInvoice ==== Type ==== Standard execu…“

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to create new branch in system. ==== Exact name ==== `API_CreateInvoice` ==== Type ==== Standard execu…“