JDBC Driver for Acumatica

Build 20.0.7587

テーブル

本製品 はAcumatica のデータを、標準のSQL ステートメントを使用してクエリできるテーブルのリストにモデル化します。

一般的には、Acumatica テーブルのクエリは、リレーショナルデータベースのテーブルのクエリと同じです。時には特別なケースもあります。例えば、テーブルの特定のカラムデータを取得するために特定のカラムをWHERE 句に含める必要がある場合などです。これは通常、特定のカラムを取得するために行ごとに個別のリクエストを行う必要がある場合に必要です。これらの特別な状況は、以下にリンクされているテーブルページの上部に明確に文書化されています。

CData JDBC Driver for Acumatica テーブル

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