API Data Provider - Online Help
Board Profile
Connecting to Board
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
AccountingTypes
Analyses
Clients
Contacts
DocumentDeliveries
DocumentDeliveryDetails
DocumentEstimateDetails
DocumentEstimates
DocumentInvoiceDetails
DocumentInvoices
DocumentReceiptDetails
DocumentReceipts
ExpenditureDocumentOrders
ExpenditurePayments
Expenditures
ExpenditureTypes
Groups
Invoices
Orders
PayeeBranches
PayeeContacts
Payees
PaymentTerms
ProjectCosts
Projects
ProjectTypes
Users
PaymentTerms
Generated schema file.
Columns
Name
Type
References
CreatedAt
Datetime
Id
Integer
Name
String
UpdatedAt
Datetime