API CreateInvoice: 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 create new branch in system. ==== Exact name ==== <code>API_CreateInvoice</code> ==== Type ==== Standard execu…“)
 
 
(Není zobrazeno 6 mezilehlých verzí od stejného uživatele.)
Řádka 16: Řádka 16:
 
!Relation
 
!Relation
 
|-  
 
|-  
−
|ContactID  
+
|@ContactID  
 
|int  
 
|int  
 +
|
 
|ID of customer from customer list (see relation)   
 
|ID of customer from customer list (see relation)   
 
|API_GetCustomers.ID
 
|API_GetCustomers.ID
 
|-  
 
|-  
−
|OrdererID  
+
|@OrdererID  
 
|int  
 
|int  
 +
|
 
|ID of customer from customer list (see relation)  
 
|ID of customer from customer list (see relation)  
 
|API_GetCustomers.ID
 
|API_GetCustomers.ID
 
|-  
 
|-  
−
|RecipientID  
+
|@RecipientID  
 
|int  
 
|int  
 +
|
 
|ID of customer from customer list (see relation)   
 
|ID of customer from customer list (see relation)   
 
|API_GetCustomers.ID
 
|API_GetCustomers.ID
 
|-  
 
|-  
−
|StockID  
+
|@StockID  
 
|int  
 
|int  
 +
|
 
|ID of stock from stock list (see relation)   
 
|ID of stock from stock list (see relation)   
 
|API_GetStocks.ID
 
|API_GetStocks.ID
 
|-  
 
|-  
−
|BranchID  
+
|@BranchID  
 
|int  
 
|int  
 +
|
 
|ID of branch from branch list (see relation)  
 
|ID of branch from branch list (see relation)  
 
|API_GetBranches.ID
 
|API_GetBranches.ID
 
|-  
 
|-  
−
|DocumentTypeID  
+
|@DocumentTypeID  
 
|int  
 
|int  
 +
|
 
| Document type ID
 
| Document type ID
  
Řádka 58: Řádka 64:
 
|
 
|
 
|-  
 
|-  
−
|TransportID  
+
|@TransportID  
 
|int  
 
|int  
 +
|
 
|ID of transport from transport list (see relation)  
 
|ID of transport from transport list (see relation)  
 
|API_GetTransports.ID
 
|API_GetTransports.ID
 
|-  
 
|-  
−
|PaymentTypeID  
+
|@PaymentTypeID  
 
|int  
 
|int  
 +
|
 
| Payment type ID.  
 
| Payment type ID.  
  
Řádka 82: Řádka 90:
 
|
 
|
 
|-  
 
|-  
−
|PriceTypeID  
+
|@PriceTypeID  
 
|int  
 
|int  
 +
|
 
| Price type ID
 
| Price type ID
  
Řádka 93: Řádka 102:
 
|
 
|
 
|-  
 
|-  
−
|DocumentNumber  
+
|@DocumentNumber  
 
|nvarchar(40)  
 
|nvarchar(40)  
 +
|
 
|Document number  
 
|Document number  
 
|
 
|
 
|-  
 
|-  
−
|Date  
+
|@Date  
 
|datetime  
 
|datetime  
 +
|
 
|Date  
 
|Date  
 
|
 
|
 
|-  
 
|-  
−
|TaxableSupplyDate  
+
|@TaxableSupplyDate  
 
|datetime  
 
|datetime  
 +
|
 
|Taxable supply date  
 
|Taxable supply date  
 
|
 
|
 
|-  
 
|-  
−
|DueDate  
+
|@DueDate  
 
|datetime  
 
|datetime  
 +
|
 
|Due date  
 
|Due date  
 
|
 
|
 
|-  
 
|-  
−
|VariableSymbol  
+
|@VariableSymbol  
 
|bigint  
 
|bigint  
 +
|
 
|Variable symbol  
 
|Variable symbol  
 
|
 
|
 
|-  
 
|-  
−
|BasicPrice  
+
|@BasicPrice  
 
|decimal(18,6)  
 
|decimal(18,6)  
 +
|
 
|Basic price  
 
|Basic price  
 
|
 
|
 
|-  
 
|-  
−
|BasicPriceInCurrency  
+
|@BasicPriceInCurrency  
 
|decimal(18,6)  
 
|decimal(18,6)  
 +
|
 
|Basic price in currency  
 
|Basic price in currency  
 
|
 
|
 
|-  
 
|-  
−
|VATPrice  
+
|@VATPrice  
 
|decimal(18,6)  
 
|decimal(18,6)  
 +
|
 
|VAT price  
 
|VAT price  
 
|
 
|
 
|-  
 
|-  
−
|VATPriceInCurrency  
+
|@VATPriceInCurrency  
 
|decimal(18,6)  
 
|decimal(18,6)  
 +
|
 
|VAT price in currency  
 
|VAT price in currency  
 
|
 
|
 
|-  
 
|-  
−
|TotalPrice  
+
|@TotalPrice  
 
|decimal(18,6)  
 
|decimal(18,6)  
 +
|
 
|Total price  
 
|Total price  
 
|
 
|
 
|-  
 
|-  
−
|TotalPriceInCurrency  
+
|@TotalPriceInCurrency  
 
|decimal(18,6)  
 
|decimal(18,6)  
 +
|
 
|Total price in currency  
 
|Total price in currency  
 
|
 
|
 
|-  
 
|-  
−
|RoundPrice  
+
|@RoundPrice  
 
|decimal(18,4)  
 
|decimal(18,4)  
 +
|
 
|Round price  
 
|Round price  
 
|
 
|
 
|-  
 
|-  
−
|RoundPriceInCurrency  
+
|@RoundPriceInCurrency  
 
|decimal(18,4)  
 
|decimal(18,4)  
 +
|
 
|Round price in currency  
 
|Round price in currency  
 
|
 
|
 
|-  
 
|-  
−
|Price  
+
|@Price  
 
|decimal(19,6)  
 
|decimal(19,6)  
 +
|
 
|Price  
 
|Price  
 
|
 
|
 
|-  
 
|-  
−
|PriceInCurrency  
+
|@PriceInCurrency  
 
|decimal(19,6)  
 
|decimal(19,6)  
 +
|
 
|Price in currency  
 
|Price in currency  
 
|
 
|
 
|-  
 
|-  
−
|Currency  
+
|@Currency  
−
|varchar(5)  
+
|nvarchar(5)  
 +
|
 
|Currency  
 
|Currency  
 
|
 
|
 
|-  
 
|-  
−
|CurrencyID  
+
|@CurrencyID  
 
|int  
 
|int  
 +
|
 
|ID of currency from currency list (see relation)  
 
|ID of currency from currency list (see relation)  
 
|API_GetCurrency.ID
 
|API_GetCurrency.ID
 
|-  
 
|-  
−
|CurrencyIDInCurrency  
+
|@CurrencyIDInCurrency  
 
|int  
 
|int  
 +
|
 
|ID of currency from currency list (see relation)  
 
|ID of currency from currency list (see relation)  
 
|API_GetCurrency.ID
 
|API_GetCurrency.ID
 
|-  
 
|-  
−
|ExchangeRate  
+
|@ExchangeRate  
 
|decimal(19,4)  
 
|decimal(19,4)  
 +
|
 
|Exchange rate  
 
|Exchange rate  
 
|
 
|
 
|-  
 
|-  
−
|ExchangeRate2  
+
|@ExchangeRate2  
 
|decimal(18,4)  
 
|decimal(18,4)  
 +
|
 
|Exchange rate 2  
 
|Exchange rate 2  
 
|
 
|
 
|-  
 
|-  
−
|AccountingExchangeRate  
+
|@AccountingExchangeRate  
 
|decimal(18,6)  
 
|decimal(18,6)  
 +
|
 
|Accounting exchange rate  
 
|Accounting exchange rate  
 
|
 
|
 
|-  
 
|-  
−
|VATExchangeRate  
+
|@VATExchangeRate  
 
|decimal(18,4)  
 
|decimal(18,4)  
 +
|
 
|VAT exchange rate  
 
|VAT exchange rate  
 
|
 
|
 
|-  
 
|-  
−
|AccountingExchangeRate2  
+
|@AccountingExchangeRate2  
 
|decimal(18,6)  
 
|decimal(18,6)  
 +
|
 
|Accounting exchange rate 2  
 
|Accounting exchange rate 2  
 
|
 
|
 
|-  
 
|-  
−
|RoundStyle  
+
|@RoundStyle  
 
|int  
 
|int  
 +
|
 
|Round style.
 
|Round style.
 
-1        - not selected,  
 
-1        - not selected,  
Řádka 230: Řádka 263:
 
|
 
|
 
|-  
 
|-  
−
|RoundType  
+
|@RoundType  
 
|int  
 
|int  
 +
|
 
|Round type
 
|Round type
 
-1 - not selected,
 
-1 - not selected,
Řádka 242: Řádka 276:
 
|
 
|
 
|-  
 
|-  
−
|SupplierName  
+
|@SupplierName  
 
|nvarchar(140)  
 
|nvarchar(140)  
 +
|
 
|Supplier name  
 
|Supplier name  
 
|
 
|
 
|-  
 
|-  
−
|SupplierStreet  
+
|@SupplierStreet  
 
|nvarchar(100)  
 
|nvarchar(100)  
 +
|
 
|Supplier street  
 
|Supplier street  
 
|
 
|
 
|-  
 
|-  
−
|SupplierCity  
+
|@SupplierCity  
 
|nvarchar(140)  
 
|nvarchar(140)  
 +
|
 
|Supplier city  
 
|Supplier city  
 
|
 
|
 
|-  
 
|-  
−
|SupplierZIPCode  
+
|@SupplierZIPCode  
−
|char(10)  
+
|nvarchar(10)  
 +
|
 
|Supplier ZIP code  
 
|Supplier ZIP code  
 
|
 
|
 
|-  
 
|-  
−
|SupplierCountry  
+
|@SupplierCountry  
 
|nvarchar(50)  
 
|nvarchar(50)  
 +
|
 
|Supplier country  
 
|Supplier country  
 
|
 
|
 
|-  
 
|-  
−
|SupplierRegion  
+
|@SupplierRegion  
 
|nvarchar(30)  
 
|nvarchar(30)  
 +
|
 
|Supplier region  
 
|Supplier region  
 
|
 
|
 
|-  
 
|-  
−
|SupplierState  
+
|@SupplierState  
 
|nvarchar(50)  
 
|nvarchar(50)  
 +
|
 
|Supplier state  
 
|Supplier state  
 
|
 
|
 
|-  
 
|-  
−
|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)  
 +
|
 
|Supplier phone  
 
|Supplier phone  
 
|
 
|
 
|-  
 
|-  
−
|SupplierFax  
+
|@SupplierFax  
 
|nvarchar(30)  
 
|nvarchar(30)  
 +
|
 
|Supplier fax  
 
|Supplier fax  
 
|
 
|
 
|-  
 
|-  
−
|SupplierMobilePhone  
+
|@SupplierMobilePhone  
 
|nvarchar(30)  
 
|nvarchar(30)  
 +
|
 
|Supplier mobile phone  
 
|Supplier mobile phone  
 
|
 
|
 
|-  
 
|-  
−
|SupplierEmail  
+
|@SupplierEmail  
 
|nvarchar(60)  
 
|nvarchar(60)  
 +
|
 
|Supplier email  
 
|Supplier email  
 
|
 
|
 
|-  
 
|-  
−
|SupplierWeb  
+
|@SupplierWeb  
 
|nvarchar(50)  
 
|nvarchar(50)  
 +
|
 
|Supplier web  
 
|Supplier web  
 
|
 
|
 
|-  
 
|-  
−
|SupplierBankName  
+
|@SupplierBankName  
 
|nvarchar(120)  
 
|nvarchar(120)  
 +
|
 
|Supplier bank name  
 
|Supplier bank name  
 
|
 
|
 
|-  
 
|-  
−
|SupplierBankAccount  
+
|@SupplierBankAccount  
 
|nvarchar(50)  
 
|nvarchar(50)  
 +
|
 
|Supplier bank account  
 
|Supplier bank account  
 
|
 
|
 
|-  
 
|-  
−
|SupplierBankSwift  
+
|@SupplierBankSwift  
 
|nvarchar(50)  
 
|nvarchar(50)  
 +
|
 
|Supplier bank swift  
 
|Supplier bank swift  
 
|
 
|
 
|-  
 
|-  
−
|OrdererName  
+
|@OrdererName  
 
|nvarchar(140)  
 
|nvarchar(140)  
 +
|
 
|Orderer name  
 
|Orderer name  
 
|
 
|
 
|-  
 
|-  
−
|OrdererStreet  
+
|@OrdererStreet  
 
|nvarchar(100)  
 
|nvarchar(100)  
 +
|
 
|Orderer street  
 
|Orderer street  
 
|
 
|
 
|-  
 
|-  
−
|OrdererCity  
+
|@OrdererCity  
 
|nvarchar(140)  
 
|nvarchar(140)  
 +
|
 
|Orderer city  
 
|Orderer city  
 
|
 
|
 
|-  
 
|-  
−
|OrdererZIPCode  
+
|@OrdererZIPCode  
−
|char(10)  
+
|nvarchar(10)  
 +
|
 
|Orderer ZIP code  
 
|Orderer ZIP code  
 
|
 
|
 
|-  
 
|-  
−
|OrdererCountry  
+
|@OrdererCountry  
 
|nvarchar(50)  
 
|nvarchar(50)  
 +
|
 
|Orderer country  
 
|Orderer country  
 
|
 
|
 
|-  
 
|-  
−
|OrdererRegion  
+
|@OrdererRegion  
 
|nvarchar(30)  
 
|nvarchar(30)  
 +
|
 
|Orderer region  
 
|Orderer region  
 
|
 
|
 
|-  
 
|-  
−
|OrdererState  
+
|@OrdererState  
 
|nvarchar(50)  
 
|nvarchar(50)  
 +
|
 
|Orderer state  
 
|Orderer state  
 
|
 
|
 
|-  
 
|-  
−
|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)  
 +
|
 
|Orderer phone  
 
|Orderer phone  
 
|
 
|
 
|-  
 
|-  
−
|OrdererFax  
+
|@OrdererFax  
 
|nvarchar(30)  
 
|nvarchar(30)  
 +
|
 
|Orderer fax  
 
|Orderer fax  
 
|
 
|
 
|-  
 
|-  
−
|OrdererMobilePhone  
+
|@OrdererMobilePhone  
 
|nvarchar(30)  
 
|nvarchar(30)  
 +
|
 
|Orderer mobile phone  
 
|Orderer mobile phone  
 
|
 
|
 
|-  
 
|-  
−
|OrdererEmail  
+
|@OrdererEmail  
 
|nvarchar(60)  
 
|nvarchar(60)  
 +
|
 
|Orderer email  
 
|Orderer email  
 
|
 
|
 
|-  
 
|-  
−
|OrdererWeb  
+
|@OrdererWeb  
 
|nvarchar(50)  
 
|nvarchar(50)  
 +
|
 
|Orderer web  
 
|Orderer web  
 
|
 
|
 
|-  
 
|-  
−
|OrdererBankName  
+
|@OrdererBankName  
 
|nvarchar(120)  
 
|nvarchar(120)  
 +
|
 
|Orderer bank name  
 
|Orderer bank name  
 
|
 
|
 
|-  
 
|-  
−
|OrdererBankAccount  
+
|@OrdererBankAccount  
 
|nvarchar(50)  
 
|nvarchar(50)  
 +
|
 
|Orderer bank account  
 
|Orderer bank account  
 
|
 
|
 
|-  
 
|-  
−
|RecipientName  
+
|@RecipientName  
 
|nvarchar(120)  
 
|nvarchar(120)  
 +
|
 
|Recipient name  
 
|Recipient name  
 
|
 
|
 
|-  
 
|-  
−
|RecipientStreet  
+
|@RecipientStreet  
 
|nvarchar(100)  
 
|nvarchar(100)  
 +
|
 
|Recipient street  
 
|Recipient street  
 
|
 
|
 
|-  
 
|-  
−
|RecipientCity  
+
|@RecipientCity  
 
|nvarchar(140)  
 
|nvarchar(140)  
 +
|
 
|Recipient city  
 
|Recipient city  
 
|
 
|
 
|-  
 
|-  
−
|RecipientZIPCode  
+
|@RecipientZIPCode  
−
|char(10)  
+
|nvarchar(10)  
 +
|
 
|Recipient ZIP code  
 
|Recipient ZIP code  
 
|
 
|
 
|-  
 
|-  
−
|RecipientCountry  
+
|@RecipientCountry  
 
|nvarchar(50)  
 
|nvarchar(50)  
 +
|
 
|Recipient country  
 
|Recipient country  
 
|
 
|
 
|-  
 
|-  
−
|RecipientRegion  
+
|@RecipientRegion  
 
|nvarchar(30)  
 
|nvarchar(30)  
 +
|
 
|Recipient region  
 
|Recipient region  
 
|
 
|
 
|-  
 
|-  
−
|RecipientState  
+
|@RecipientState  
 
|nvarchar(50)  
 
|nvarchar(50)  
 +
|
 
|Recipient state  
 
|Recipient state  
 
|
 
|
 
|-  
 
|-  
−
|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)  
 +
|
 
|Recipient phone  
 
|Recipient phone  
 
|
 
|
 
|-  
 
|-  
−
|RecipientFax  
+
|@RecipientFax  
 
|nvarchar(30)  
 
|nvarchar(30)  
 +
|
 
|Recipient fax  
 
|Recipient fax  
 
|
 
|
 
|-  
 
|-  
−
|RecipientMobilePhone  
+
|@RecipientMobilePhone  
 
|nvarchar(30)  
 
|nvarchar(30)  
 +
|
 
|Recipient mobile phone  
 
|Recipient mobile phone  
 
|
 
|
 
|-  
 
|-  
−
|RecipientEmail  
+
|@RecipientEmail  
 
|nvarchar(60)  
 
|nvarchar(60)  
 +
|
 
|Recipient email  
 
|Recipient email  
 
|
 
|
 
|-  
 
|-  
−
|RecipientWeb  
+
|@RecipientWeb  
 
|nvarchar(50)  
 
|nvarchar(50)  
 +
|
 
|Recipient web  
 
|Recipient web  
 
|
 
|
 
|-  
 
|-  
−
|RecipientBankName  
+
|@RecipientBankName  
 
|nvarchar(120)  
 
|nvarchar(120)  
 +
|
 
|Recipient bank name  
 
|Recipient bank name  
 
|
 
|
 
|-  
 
|-  
−
|RecipientBankAccount  
+
|@RecipientBankAccount  
 
|nvarchar(50)  
 
|nvarchar(50)  
 +
|
 
|Recipient bank account  
 
|Recipient bank account  
 
|
 
|
 
|-  
 
|-  
−
|IsCanceled  
+
|@IsCanceled  
 
|int  
 
|int  
 +
|
 
|Is canceled  
 
|Is canceled  
 
|
 
|
 
|-  
 
|-  
−
|CancelationReason  
+
|@CancelationReason  
 
|nvarchar(100)  
 
|nvarchar(100)  
 +
|
 
|Cancelation reason  
 
|Cancelation reason  
 
|
 
|
 
|-  
 
|-  
−
|CancelationDate  
+
|@CancelationDate  
 
|datetime  
 
|datetime  
 +
|
 
|Cancelation date  
 
|Cancelation date  
 
|
 
|
 
|-  
 
|-  
−
|IsForeign  
+
|@IsForeign  
 
|int  
 
|int  
 +
|
 
|Is foreign  
 
|Is foreign  
 
|
 
|
 
|-  
 
|-  
−
|FinancialYear  
+
|@FinancialYear  
 
|int  
 
|int  
 +
|
 
|Financial year  
 
|Financial year  
 
|
 
|
 
|-  
 
|-  
−
|FinancialMonth  
+
|@FinancialMonth  
 
|int  
 
|int  
 +
|
 
|Financial month  
 
|Financial month  
 
|
 
|
 
|-  
 
|-  
−
|Note  
+
|@Note  
 
|nvarchar(500)  
 
|nvarchar(500)  
 +
|
 
|Note  
 
|Note  
 
|
 
|
 
|-  
 
|-  
−
|Note2  
+
|@Note2  
−
|varchar(120)  
+
|nvarchar(120)  
 +
|
 
|Note 2  
 
|Note 2  
 
|
 
|
 
|-  
 
|-  
−
|IsPrintedOnFiscal  
+
|@IsPrintedOnFiscal  
 
|int  
 
|int  
 +
|
 
|Is printed on fiscal  
 
|Is printed on fiscal  
 
|
 
|
 
|-  
 
|-  
−
|FiskalComputerName  
+
|@FiskalComputerName  
 
|nvarchar(255)  
 
|nvarchar(255)  
 +
|
 
|Fiskal computer name  
 
|Fiskal computer name  
 
|
 
|
 
|-  
 
|-  
−
|IsPrinted  
+
|@IsPrinted  
 
|int  
 
|int  
 +
|
 
|Is printed  
 
|Is printed  
 
|
 
|
 
|-  
 
|-  
−
|CancelDocument  
+
|@CancelDocument  
 
|int  
 
|int  
 +
|
 
|Cancel document  
 
|Cancel document  
 
|
 
|
 
|-  
 
|-  
−
|CancelDocumentOriginID  
+
|@CancelDocumentOriginID  
 
|int  
 
|int  
 +
|
 
|ID of invoice from invoice list (see relation)  
 
|ID of invoice from invoice list (see relation)  
 
|API_GetInvoices.ID
 
|API_GetInvoices.ID
 
|-  
 
|-  
−
|FiskalPrintDate  
+
|@FiskalPrintDate  
 
|date  
 
|date  
 +
|
 
|Fiskal print date  
 
|Fiskal print date  
 
|
 
|
 
|-  
 
|-  
−
|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, 14: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“