Tables
The connector models the data in Acumatica as a list of tables in a relational database that can be queried using standard SQL statements.
CData Power BI Connector 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. |