API CreateInvoice: Porovnání verzí

Z Podpora.nextis.cz
Skočit na navigaci Skočit na vyhledávání
← Porovnání se starší verzí

Chrzaszcz (diskuse | příspěvky)

2 uživatelské skupiny
542 editací
VizuálníWikitext
Bez shrnutí editace
Bez shrnutí editace
 
(Není zobrazeno 5 mezilehlých verzí od stejného uživatele.)
Řádek 16: Řádek 16:
!Relation
!Relation
|-  
|-  
|ContactID  
|@ContactID  
|int  
|int  
|
|
Řádek 22: Řádek 22:
|API_GetCustomers.ID
|API_GetCustomers.ID
|-  
|-  
|OrdererID  
|@OrdererID  
|int  
|int  
|
|
Řádek 28: Řádek 28:
|API_GetCustomers.ID
|API_GetCustomers.ID
|-  
|-  
|RecipientID  
|@RecipientID  
|int  
|int  
|
|
Řádek 34: Řádek 34:
|API_GetCustomers.ID
|API_GetCustomers.ID
|-  
|-  
|StockID  
|@StockID  
|int  
|int  
|
|
Řádek 40: Řádek 40:
|API_GetStocks.ID
|API_GetStocks.ID
|-  
|-  
|BranchID  
|@BranchID  
|int  
|int  
|
|
Řádek 46: Řádek 46:
|API_GetBranches.ID
|API_GetBranches.ID
|-  
|-  
|DocumentTypeID  
|@DocumentTypeID  
|int  
|int  
|
|
Řádek 64: Řádek 64:
|
|
|-  
|-  
|TransportID  
|@TransportID  
|int  
|int  
|
|
Řádek 70: Řádek 70:
|API_GetTransports.ID
|API_GetTransports.ID
|-  
|-  
|PaymentTypeID  
|@PaymentTypeID  
|int  
|int  
|
|
Řádek 90: Řádek 90:
|
|
|-  
|-  
|PriceTypeID  
|@PriceTypeID  
|int  
|int  
|
|
Řádek 102: Řádek 102:
|
|
|-  
|-  
|DocumentNumber  
|@DocumentNumber  
|nvarchar(40)  
|nvarchar(40)  
|
|
Řádek 108: Řádek 108:
|
|
|-  
|-  
|Date  
|@Date  
|datetime  
|datetime  
|
|
Řádek 114: Řádek 114:
|
|
|-  
|-  
|TaxableSupplyDate  
|@TaxableSupplyDate  
|datetime  
|datetime  
|
|
Řádek 120: Řádek 120:
|
|
|-  
|-  
|DueDate  
|@DueDate  
|datetime  
|datetime  
|
|
Řádek 126: Řádek 126:
|
|
|-  
|-  
|VariableSymbol  
|@VariableSymbol  
|bigint  
|bigint  
|
|
Řádek 132: Řádek 132:
|
|
|-  
|-  
|BasicPrice  
|@BasicPrice  
|decimal(18,6)  
|decimal(18,6)  
|
|
Řádek 138: Řádek 138:
|
|
|-  
|-  
|BasicPriceInCurrency  
|@BasicPriceInCurrency  
|decimal(18,6)  
|decimal(18,6)  
|
|
Řádek 144: Řádek 144:
|
|
|-  
|-  
|VATPrice  
|@VATPrice  
|decimal(18,6)  
|decimal(18,6)  
|
|
Řádek 150: Řádek 150:
|
|
|-  
|-  
|VATPriceInCurrency  
|@VATPriceInCurrency  
|decimal(18,6)  
|decimal(18,6)  
|
|
Řádek 156: Řádek 156:
|
|
|-  
|-  
|TotalPrice  
|@TotalPrice  
|decimal(18,6)  
|decimal(18,6)  
|
|
Řádek 162: Řádek 162:
|
|
|-  
|-  
|TotalPriceInCurrency  
|@TotalPriceInCurrency  
|decimal(18,6)  
|decimal(18,6)  
|
|
Řádek 168: Řádek 168:
|
|
|-  
|-  
|RoundPrice  
|@RoundPrice  
|decimal(18,4)  
|decimal(18,4)  
|
|
Řádek 174: Řádek 174:
|
|
|-  
|-  
|RoundPriceInCurrency  
|@RoundPriceInCurrency  
|decimal(18,4)  
|decimal(18,4)  
|
|
Řádek 180: Řádek 180:
|
|
|-  
|-  
|Price  
|@Price  
|decimal(19,6)  
|decimal(19,6)  
|
|
Řádek 186: Řádek 186:
|
|
|-  
|-  
|PriceInCurrency  
|@PriceInCurrency  
|decimal(19,6)  
|decimal(19,6)  
|
|
Řádek 192: Řádek 192:
|
|
|-  
|-  
|Currency  
|@Currency  
|varchar(5)  
|nvarchar(5)  
|
|
|Currency  
|Currency  
|
|
|-  
|-  
|CurrencyID  
|@CurrencyID  
|int  
|int  
|
|
Řádek 204: Řádek 204:
|API_GetCurrency.ID
|API_GetCurrency.ID
|-  
|-  
|CurrencyIDInCurrency  
|@CurrencyIDInCurrency  
|int  
|int  
|
|
Řádek 210: Řádek 210:
|API_GetCurrency.ID
|API_GetCurrency.ID
|-  
|-  
|ExchangeRate  
|@ExchangeRate  
|decimal(19,4)  
|decimal(19,4)  
|
|
Řádek 216: Řádek 216:
|
|
|-  
|-  
|ExchangeRate2  
|@ExchangeRate2  
|decimal(18,4)  
|decimal(18,4)  
|
|
Řádek 222: Řádek 222:
|
|
|-  
|-  
|AccountingExchangeRate  
|@AccountingExchangeRate  
|decimal(18,6)  
|decimal(18,6)  
|
|
Řádek 228: Řádek 228:
|
|
|-  
|-  
|VATExchangeRate  
|@VATExchangeRate  
|decimal(18,4)  
|decimal(18,4)  
|
|
Řádek 234: Řádek 234:
|
|
|-  
|-  
|AccountingExchangeRate2  
|@AccountingExchangeRate2  
|decimal(18,6)  
|decimal(18,6)  
|
|
Řádek 240: Řádek 240:
|
|
|-  
|-  
|RoundStyle  
|@RoundStyle  
|int  
|int  
|
|
Řádek 263: Řádek 263:
|
|
|-  
|-  
|RoundType  
|@RoundType  
|int  
|int  
|
|
Řádek 276: Řádek 276:
|
|
|-  
|-  
|SupplierName  
|@SupplierName  
|nvarchar(140)  
|nvarchar(140)  
|
|
Řádek 282: Řádek 282:
|
|
|-  
|-  
|SupplierStreet  
|@SupplierStreet  
|nvarchar(100)  
|nvarchar(100)  
|
|
Řádek 288: Řádek 288:
|
|
|-  
|-  
|SupplierCity  
|@SupplierCity  
|nvarchar(140)  
|nvarchar(140)  
|
|
Řádek 294: Řádek 294:
|
|
|-  
|-  
|SupplierZIPCode  
|@SupplierZIPCode  
|char(10)  
|nvarchar(10)  
|
|
|Supplier ZIP code  
|Supplier ZIP code  
|
|
|-  
|-  
|SupplierCountry  
|@SupplierCountry  
|nvarchar(50)  
|nvarchar(50)  
|
|
Řádek 306: Řádek 306:
|
|
|-  
|-  
|SupplierRegion  
|@SupplierRegion  
|nvarchar(30)  
|nvarchar(30)  
|
|
Řádek 312: Řádek 312:
|
|
|-  
|-  
|SupplierState  
|@SupplierState  
|nvarchar(50)  
|nvarchar(50)  
|
|
Řádek 318: Řádek 318:
|
|
|-  
|-  
|SupplierCompanyRegistrationNumber  
|@SupplierCompanyRegistrationNumber  
|char(20)  
|nvarchar(20)  
|
|
|Supplier company registration number  
|Supplier company registration number  
|
|
|-  
|-  
|SupplierVATNumber2  
|@SupplierVATNumber2  
|char(20)  
|nvarchar(20)  
|
|
|Supplier VAT number 2  
|Supplier VAT number 2  
|
|
|-  
|-  
|SupplierVATNumber  
|@SupplierVATNumber  
|char(20)  
|nvarchar(20)  
|
|
|Supplier VAT number  
|Supplier VAT number  
|
|
|-  
|-  
|SupplierPhone  
|@SupplierPhone  
|nvarchar(30)  
|nvarchar(30)  
|
|
Řádek 342: Řádek 342:
|
|
|-  
|-  
|SupplierFax  
|@SupplierFax  
|nvarchar(30)  
|nvarchar(30)  
|
|
Řádek 348: Řádek 348:
|
|
|-  
|-  
|SupplierMobilePhone  
|@SupplierMobilePhone  
|nvarchar(30)  
|nvarchar(30)  
|
|
Řádek 354: Řádek 354:
|
|
|-  
|-  
|SupplierEmail  
|@SupplierEmail  
|nvarchar(60)  
|nvarchar(60)  
|
|
Řádek 360: Řádek 360:
|
|
|-  
|-  
|SupplierWeb  
|@SupplierWeb  
|nvarchar(50)  
|nvarchar(50)  
|
|
Řádek 366: Řádek 366:
|
|
|-  
|-  
|SupplierBankName  
|@SupplierBankName  
|nvarchar(120)  
|nvarchar(120)  
|
|
Řádek 372: Řádek 372:
|
|
|-  
|-  
|SupplierBankAccount  
|@SupplierBankAccount  
|nvarchar(50)  
|nvarchar(50)  
|
|
Řádek 378: Řádek 378:
|
|
|-  
|-  
|SupplierBankSwift  
|@SupplierBankSwift  
|nvarchar(50)  
|nvarchar(50)  
|
|
Řádek 384: Řádek 384:
|
|
|-  
|-  
|OrdererName  
|@OrdererName  
|nvarchar(140)  
|nvarchar(140)  
|
|
Řádek 390: Řádek 390:
|
|
|-  
|-  
|OrdererStreet  
|@OrdererStreet  
|nvarchar(100)  
|nvarchar(100)  
|
|
Řádek 396: Řádek 396:
|
|
|-  
|-  
|OrdererCity  
|@OrdererCity  
|nvarchar(140)  
|nvarchar(140)  
|
|
Řádek 402: Řádek 402:
|
|
|-  
|-  
|OrdererZIPCode  
|@OrdererZIPCode  
|char(10)  
|nvarchar(10)  
|
|
|Orderer ZIP code  
|Orderer ZIP code  
|
|
|-  
|-  
|OrdererCountry  
|@OrdererCountry  
|nvarchar(50)  
|nvarchar(50)  
|
|
Řádek 414: Řádek 414:
|
|
|-  
|-  
|OrdererRegion  
|@OrdererRegion  
|nvarchar(30)  
|nvarchar(30)  
|
|
Řádek 420: Řádek 420:
|
|
|-  
|-  
|OrdererState  
|@OrdererState  
|nvarchar(50)  
|nvarchar(50)  
|
|
Řádek 426: Řádek 426:
|
|
|-  
|-  
|OrdererCompanyRegistrationNumber  
|@OrdererCompanyRegistrationNumber  
|char(20)  
|nvarchar(20)  
|
|
|Orderer company registration number  
|Orderer company registration number  
|
|
|-  
|-  
|OrdererVATNumber2  
|@OrdererVATNumber2  
|char(20)  
|nvarchar(20)  
|
|
|Orderer VAT number 2  
|Orderer VAT number 2  
|
|
|-  
|-  
|OrdererVATNumber  
|@OrdererVATNumber  
|char(20)  
|nvarchar(20)  
|
|
|Orderer VAT number  
|Orderer VAT number  
|
|
|-  
|-  
|OrdererPhone  
|@OrdererPhone  
|nvarchar(30)  
|nvarchar(30)  
|
|
Řádek 450: Řádek 450:
|
|
|-  
|-  
|OrdererFax  
|@OrdererFax  
|nvarchar(30)  
|nvarchar(30)  
|
|
Řádek 456: Řádek 456:
|
|
|-  
|-  
|OrdererMobilePhone  
|@OrdererMobilePhone  
|nvarchar(30)  
|nvarchar(30)  
|
|
Řádek 462: Řádek 462:
|
|
|-  
|-  
|OrdererEmail  
|@OrdererEmail  
|nvarchar(60)  
|nvarchar(60)  
|
|
Řádek 468: Řádek 468:
|
|
|-  
|-  
|OrdererWeb  
|@OrdererWeb  
|nvarchar(50)  
|nvarchar(50)  
|
|
Řádek 474: Řádek 474:
|
|
|-  
|-  
|OrdererBankName  
|@OrdererBankName  
|nvarchar(120)  
|nvarchar(120)  
|
|
Řádek 480: Řádek 480:
|
|
|-  
|-  
|OrdererBankAccount  
|@OrdererBankAccount  
|nvarchar(50)  
|nvarchar(50)  
|
|
Řádek 486: Řádek 486:
|
|
|-  
|-  
|RecipientName  
|@RecipientName  
|nvarchar(120)  
|nvarchar(120)  
|
|
Řádek 492: Řádek 492:
|
|
|-  
|-  
|RecipientStreet  
|@RecipientStreet  
|nvarchar(100)  
|nvarchar(100)  
|
|
Řádek 498: Řádek 498:
|
|
|-  
|-  
|RecipientCity  
|@RecipientCity  
|nvarchar(140)  
|nvarchar(140)  
|
|
Řádek 504: Řádek 504:
|
|
|-  
|-  
|RecipientZIPCode  
|@RecipientZIPCode  
|char(10)  
|nvarchar(10)  
|
|
|Recipient ZIP code  
|Recipient ZIP code  
|
|
|-  
|-  
|RecipientCountry  
|@RecipientCountry  
|nvarchar(50)  
|nvarchar(50)  
|
|
Řádek 516: Řádek 516:
|
|
|-  
|-  
|RecipientRegion  
|@RecipientRegion  
|nvarchar(30)  
|nvarchar(30)  
|
|
Řádek 522: Řádek 522:
|
|
|-  
|-  
|RecipientState  
|@RecipientState  
|nvarchar(50)  
|nvarchar(50)  
|
|
Řádek 528: Řádek 528:
|
|
|-  
|-  
|RecipientCompanyRegistrationNumber  
|@RecipientCompanyRegistrationNumber  
|char(20)  
|nvarchar(20)  
|
|
|Recipient company registration number  
|Recipient company registration number  
|
|
|-  
|-  
|RecipientVATNumber  
|@RecipientVATNumber  
|char(20)  
|nvarchar(20)  
|
|
|Recipient VAT number  
|Recipient VAT number  
|
|
|-  
|-  
|RecipientPhone  
|@RecipientPhone  
|nvarchar(30)  
|nvarchar(30)  
|
|
Řádek 546: Řádek 546:
|
|
|-  
|-  
|RecipientFax  
|@RecipientFax  
|nvarchar(30)  
|nvarchar(30)  
|
|
Řádek 552: Řádek 552:
|
|
|-  
|-  
|RecipientMobilePhone  
|@RecipientMobilePhone  
|nvarchar(30)  
|nvarchar(30)  
|
|
Řádek 558: Řádek 558:
|
|
|-  
|-  
|RecipientEmail  
|@RecipientEmail  
|nvarchar(60)  
|nvarchar(60)  
|
|
Řádek 564: Řádek 564:
|
|
|-  
|-  
|RecipientWeb  
|@RecipientWeb  
|nvarchar(50)  
|nvarchar(50)  
|
|
Řádek 570: Řádek 570:
|
|
|-  
|-  
|RecipientBankName  
|@RecipientBankName  
|nvarchar(120)  
|nvarchar(120)  
|
|
Řádek 576: Řádek 576:
|
|
|-  
|-  
|RecipientBankAccount  
|@RecipientBankAccount  
|nvarchar(50)  
|nvarchar(50)  
|
|
Řádek 582: Řádek 582:
|
|
|-  
|-  
|IsCanceled  
|@IsCanceled  
|int  
|int  
|
|
Řádek 588: Řádek 588:
|
|
|-  
|-  
|CancelationReason  
|@CancelationReason  
|nvarchar(100)  
|nvarchar(100)  
|
|
Řádek 594: Řádek 594:
|
|
|-  
|-  
|CancelationDate  
|@CancelationDate  
|datetime  
|datetime  
|
|
Řádek 600: Řádek 600:
|
|
|-  
|-  
|IsForeign  
|@IsForeign  
|int  
|int  
|
|
Řádek 606: Řádek 606:
|
|
|-  
|-  
|FinancialYear  
|@FinancialYear  
|int  
|int  
|
|
Řádek 612: Řádek 612:
|
|
|-  
|-  
|FinancialMonth  
|@FinancialMonth  
|int  
|int  
|
|
Řádek 618: Řádek 618:
|
|
|-  
|-  
|Note  
|@Note  
|nvarchar(500)  
|nvarchar(500)  
|
|
Řádek 624: Řádek 624:
|
|
|-  
|-  
|Note2  
|@Note2  
|varchar(120)  
|nvarchar(120)  
|
|
|Note 2  
|Note 2  
|
|
|-  
|-  
|IsPrintedOnFiscal  
|@IsPrintedOnFiscal  
|int  
|int  
|
|
Řádek 636: Řádek 636:
|
|
|-  
|-  
|FiskalComputerName  
|@FiskalComputerName  
|nvarchar(255)  
|nvarchar(255)  
|
|
Řádek 642: Řádek 642:
|
|
|-  
|-  
|IsPrinted  
|@IsPrinted  
|int  
|int  
|
|
Řádek 648: Řádek 648:
|
|
|-  
|-  
|CancelDocument  
|@CancelDocument  
|int  
|int  
|
|
Řádek 654: Řádek 654:
|
|
|-  
|-  
|CancelDocumentOriginID  
|@CancelDocumentOriginID  
|int  
|int  
|
|
Řádek 660: Řádek 660:
|API_GetInvoices.ID
|API_GetInvoices.ID
|-  
|-  
|FiskalPrintDate  
|@FiskalPrintDate  
|date  
|date  
|
|
Řádek 666: Řádek 666:
|
|
|-  
|-  
|FiskalPrintOrder  
|@FiskalPrintOrder  
|int  
|int  
|
|
|Fiskal print order  
|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 created


==== Example ====
==== Example ====
<syntaxhighlight lang="sql">
<syntaxhighlight lang="sql">
EXEC [API_CreateInvoice] @WorkshopID = 1 ,@Name = 'Name'  
DECLARE @return_value int
DECLARE @d datetime
set @d = getdate()
 
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>
</syntaxhighlight>


==== Notices ====
==== Notices ====
None.
None.

Aktuální verze z 9. 11. 2018, 13:03

Description

Method allows You to create new branch in system.

Exact name

API_CreateInvoice

Type

Standard executable stored procedure.

Specification

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 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 created

Example

DECLARE @return_value int
DECLARE @d datetime
set @d = getdate()

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

Notices

None.

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