API CreateInvoice

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

EXEC [API_CreateInvoice] @WorkshopID = 1 ,@Name = 'Name'

Notices

None.