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.