API Data Provider - Online Help
Elorus Profile
Connecting to Elorus
Using the Profile
ADO.NET
JDBC
ODBC
PowerBI
SSIS
Excel
SQL Compliance
SELECT Statements
SQL Functions
String Functions
Date Functions
Math Functions
EXECUTE Statements
Schema Discovery
ADO.NET
JDBC
System Tables
sys_tables
sys_tablecolumns
sys_procedures
Tables
BillAttachments
BillItems
Bills
ContactAttachments
Contacts
CreditNoteAppliedCredit
CreditNoteAttachments
CreditNoteItems
CreditNotes
DocumentTypes
EstimateAttachments
EstimateItems
Estimates
IncomingCheques
InvoiceAttachments
InvoiceItems
Invoices
Organization
OrganizationRoles
OrganizationSettings
OutgoingCheques
PaymentGateways
PaymentReceivedAttachments
PaymentSentAttachments
PaymentsReceived
PaymentsSent
Products
ProductStockAdjustments
ProductStockHistory
RecurringBillItems
RecurringBills
RecurringInvoiceItems
RecurringInvoices
RecurringPaymentsReceived
Reminders
SalesSeries
CreditNoteAppliedCredit
SupplierCreditAttachments
SupplierCredits
Taxes
Templates
TrackingCategories
UserProfile
Users
Elorus Stored Procedures