SSIS Components for Acumatica

Build 20.0.7587

Tables

The component 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 SSIS Components 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 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.
FinancialYear FinancialYear 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.
ItemSalesCategory ItemSalesCategory 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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587