Tables
The driver models the data in Acumatica into a list of tables that can be queried using standard SQL statements.
Generally, querying Acumatica tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
CData JDBC Driver for Acumatica Tables
| Name | Description |
| Account | Account is an auto-generated table. |
| AccountByPeriodInquiry | AccountByPeriodInquiry is an auto-generated table. |
| AccountBySubaccountInquiry | AccountBySubaccountInquiry is an auto-generated table. |
| AccountDetailsInquiry | AccountDetailsInquiry is an auto-generated table. |
| AccountLocation | AccountLocation is an auto-generated table. |
| AccountSummaryInquiry | AccountSummaryInquiry is an auto-generated table. |
| Adjustment | Adjustment is an auto-generated table. |
| AttributeDefinition | AttributeDefinition is an auto-generated table. |
| Bill | Bill is an auto-generated table. |
| BusinessAccount | BusinessAccount is an auto-generated table. |
| Carrier | Carrier is an auto-generated table. |
| Case | Case is an auto-generated table. |
| CashSale | CashSale is an auto-generated table. |
| Check | Check is an auto-generated table. |
| Contact | Contact is an auto-generated table. |
| Currency | Currency is an auto-generated table. |
| Customer | Customer is an auto-generated table. |
| CustomerClass | CustomerClass is an auto-generated table. |
| CustomerLocation | CustomerLocation is an auto-generated table. |
| CustomerPaymentMethod | CustomerPaymentMethod is an auto-generated table. |
| CustomerPriceClass | CustomerPriceClass is an auto-generated table. |
| Discount | Discount is an auto-generated table. |
| DiscountCode | DiscountCode is an auto-generated table. |
| Email is an auto-generated table. | |
| Employee | Employee is an auto-generated table. |
| Event | Event is an auto-generated table. |
| FinancialPeriod | FinancialPeriod is an auto-generated table. |
| FOBPoint | FOBPoint is an auto-generated table. |
| InterBranchAccountMapping | InterBranchAccountMapping is an auto-generated table. |
| InventoryAllocationInquiry | InventoryAllocationInquiry is an auto-generated table. |
| InventoryReceipt | InventoryReceipt is an auto-generated table. |
| InventorySummaryInquiry | InventorySummaryInquiry is an auto-generated table. |
| Invoice | Invoice is an auto-generated table. |
| ItemClass | ItemClass is an auto-generated table. |
| ItemWarehouse | ItemWarehouse is an auto-generated table. |
| JournalTransaction | JournalTransaction is an auto-generated table. |
| JournalVoucher | JournalVoucher is an auto-generated table. |
| KitAssembly | KitAssembly is an auto-generated table. |
| KitSpecification | KitSpecification is an auto-generated table. |
| Lead | Lead is an auto-generated table. |
| LotSerialClass | LotSerialClass is an auto-generated table. |
| NonStockItem | NonStockItem is an auto-generated table. |
| Opportunity | Opportunity is an auto-generated table. |
| Payment | Payment is an auto-generated table. |
| PaymentMethod | PaymentMethod is an auto-generated table. |
| PhysicalInventoryReview | PhysicalInventoryReview is an auto-generated table. |
| ProjectTransaction | ProjectTransaction is an auto-generated table. |
| PurchaseOrder | PurchaseOrder is an auto-generated table. |
| PurchaseReceipt | PurchaseReceipt is an auto-generated table. |
| ReportingSettings | ReportingSettings is an auto-generated table. |
| SalesInvoice | SalesInvoice is an auto-generated table. |
| SalesOrder | SalesOrder is an auto-generated table. |
| Salesperson | Salesperson is an auto-generated table. |
| SalesPricesInquiry | SalesPricesInquiry is an auto-generated table. |
| SalesPriceWorksheet | SalesPriceWorksheet is an auto-generated table. |
| Shipment | Shipment is an auto-generated table. |
| ShippingBox | ShippingBox is an auto-generated table. |
| ShippingTerm | ShippingTerm is an auto-generated table. |
| ShippingZones | ShippingZones is an auto-generated table. |
| ShipVia | ShipVia is an auto-generated table. |
| StatementCycle | StatementCycle is an auto-generated table. |
| StockItem | StockItem is an auto-generated table. |
| Subaccount | Subaccount is an auto-generated table. |
| Task | Task is an auto-generated table. |
| Tax | Tax is an auto-generated table. |
| TaxCategory | TaxCategory is an auto-generated table. |
| TaxZone | TaxZone is an auto-generated table. |
| TransferOrder | TransferOrder is an auto-generated table. |
| TrialBalance | TrialBalance is an auto-generated table. |
| UnitsOfMeasure | UnitsOfMeasure is an auto-generated table. |
| Vendor | Vendor is an auto-generated table. |
| VendorClass | VendorClass is an auto-generated table. |
| VendorPricesInquiry | VendorPricesInquiry is an auto-generated table. |
| VendorPriceWorksheet | VendorPriceWorksheet is an auto-generated table. |
| VoucherEntryCode | VoucherEntryCode is an auto-generated table. |
| Warehouse | Warehouse is an auto-generated table. |