API Data Provider - Online Help
ZarMoney Profile
Connecting to ZarMoney
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
Classes
Customers
CustomerTransactions
ExpenseAttachments
Expenses
FinancialAccounts
FinancialAccountTypes
ItemCustomFields
ItemImages
ItemPriceLevels
ItemQuantities
Items
PaymentMethods
Payments
PaymentTerms
PriceLevels
ProfitLossReport
PurchaseAttachments
PurchaseCustomFields
Purchases
PurchasesReport
SaleAttachments
SaleCustomFields
Sales
SalesReport
SaleStatuses
ShippingMethods
Sites
TaxAgencies
TaxGroups
TaxItems
TaxTypes
UmSets
Users
Vendors
VendorTransactions
PaymentMethods
Returns all payments.
Columns
Name
Type
References
Id [KEY]
Integer
Name
String
Active
Boolean
TypeId
String