API GetInvoices

Description

Method gives You overview of existing invoices in system.

Exact name

API_GetInvoices

Type

Standard view.

Specification

Column	Data type	Description	Relation
ID	int	Internal system id
ContactID	int
OrdererID	int
RecipientID	int
StockID	int
BranchID	int
DocumentTypeID	int
TransportID	int
PaymentTypeID	int
PriceTypeID	int
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	CurrencyID
CurrencyIDInCurrency	int	CurrencyIDInCurrency
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
RoundType	int	Round type
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	Cancel document origin ID
FiskalPrintDate	date	Fiskal print date
FiskalPrintOrder	int	Fiskal print order

Example

SELECT TOP 1000 * FROM [API_GetInvoices]

Notices

None.