Codat Tables
The provider models the data in API as a list of tables in a relational database that can be queried using standard SQL statements.
Codat Tables
| Name | Description |
| Accounts | Gets the latest chart of accounts for a company |
| AgedCreditorReport | Gets the aged creditor report for a company |
| AgedDebtorReport | Gets the aged debtor report for a company |
| BalanceSheet | Gets the latest balance sheet for a company. |
| BankAccounts | Gets bank accounts info |
| BankStatements | Gets the latest bank statements for a company |
| BankStatementsAccounts | Gets the latest bank statements for a company |
| BillPayments | Gets the latest billPayments for a company |
| Bills | Gets the latest bills for a company |
| Companies | Fetch a list of all companies metadata with accounting links on the Codat platform |
| CompanyInfo | Gets the latest basic info for a company |
| Connections | Gets connections for a company |
| CreditNotes | Gets a list of all credit notes for a company |
| Customers | Gets the latest bank statements for a company |
| DataSets | Fetch a list of all data snapshots captured for a company |
| IntegrationBankSettings | Gets Bank Settings for integrations for your account |
| Integrations | Gets integrations for your account |
| Invoices | Gets the latest invoices for a company |
| Items | Gets the items for a given company |
| Journals | Gets the latest journal entries for a company |
| Payments | Gets the latest payments for a company |
| Profile | Fetch your organisations company profile |
| ProfileSyncSettings | Fetch your profile sync settings |
| ProfitAndLoss | Gets the latest profit and loss for a company. |
| Suppliers | Gets the latest suppliers for a company |
| TaxRates | Gets the latest tax rates for a given company. |
| Transactions | Gets the latest bank transactions for given account ID and company. |