JDBC Driver for Acumatica

Build 22.0.8462

Views

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.

Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.

CData JDBC Driver for Acumatica Views

Name Description
AccountByPeriodInquiry_Results AccountByPeriodInquiry_Results is an auto-generated table.
AccountBySubaccountInquiry_Results AccountBySubaccountInquiry_Results is an auto-generated table.
AccountDetailsInquiry_Results AccountDetailsInquiry_Results is an auto-generated table.
AccountLocation_Address AccountLocation_Address is an auto-generated table.
AccountLocation_Cases AccountLocation_Cases is an auto-generated table.
AccountLocation_Contact AccountLocation_Contact is an auto-generated table.
AccountLocation_Opportunities AccountLocation_Opportunities is an auto-generated table.
AccountSummaryInquiry_Results AccountSummaryInquiry_Results is an auto-generated table.
Adjustment_Details Adjustment_Details is an auto-generated table.
AttributeDefinition_Values AttributeDefinition_Values is an auto-generated table.
Bill_Applications Bill_Applications is an auto-generated table.
Bill_Details Bill_Details is an auto-generated table.
Bill_TaxDetails Bill_TaxDetails is an auto-generated table.
BusinessAccount_Activities BusinessAccount_Activities is an auto-generated table.
BusinessAccount_Attributes BusinessAccount_Attributes is an auto-generated table.
BusinessAccount_Campaigns BusinessAccount_Campaigns is an auto-generated table.
BusinessAccount_Cases BusinessAccount_Cases is an auto-generated table.
BusinessAccount_Contacts BusinessAccount_Contacts is an auto-generated table.
BusinessAccount_Contracts BusinessAccount_Contracts is an auto-generated table.
BusinessAccount_DefaultLocationSettings BusinessAccount_DefaultLocationSettings is an auto-generated table.
BusinessAccount_Duplicates BusinessAccount_Duplicates is an auto-generated table.
BusinessAccount_Locations BusinessAccount_Locations is an auto-generated table.
BusinessAccount_MainAddress BusinessAccount_MainAddress is an auto-generated table.
BusinessAccount_MainContact BusinessAccount_MainContact is an auto-generated table.
BusinessAccount_MarketingLists BusinessAccount_MarketingLists is an auto-generated table.
BusinessAccount_Opportunities BusinessAccount_Opportunities is an auto-generated table.
BusinessAccount_Orders BusinessAccount_Orders is an auto-generated table.
BusinessAccount_Relations BusinessAccount_Relations is an auto-generated table.
BusinessAccount_ShippingAddress BusinessAccount_ShippingAddress is an auto-generated table.
BusinessAccount_ShippingContact BusinessAccount_ShippingContact is an auto-generated table.
Carrier_CustomerAccounts Carrier_CustomerAccounts is an auto-generated table.
Carrier_PlugInParameters Carrier_PlugInParameters is an auto-generated table.
Case_Activities Case_Activities is an auto-generated table.
Case_Attributes Case_Attributes is an auto-generated table.
Case_RelatedCases Case_RelatedCases is an auto-generated table.
Case_Relations Case_Relations is an auto-generated table.
CashSale_Details CashSale_Details is an auto-generated table.
Check_Details Check_Details is an auto-generated table.
Check_History Check_History is an auto-generated table.
Contact_Activities Contact_Activities is an auto-generated table.
Contact_Address Contact_Address is an auto-generated table.
Contact_Attributes Contact_Attributes is an auto-generated table.
Contact_Campaigns Contact_Campaigns is an auto-generated table.
Contact_Cases Contact_Cases is an auto-generated table.
Contact_Duplicates Contact_Duplicates is an auto-generated table.
Contact_MarketingLists Contact_MarketingLists is an auto-generated table.
Contact_Notifications Contact_Notifications is an auto-generated table.
Contact_Opportunities Contact_Opportunities is an auto-generated table.
Contact_Relations Contact_Relations is an auto-generated table.
Contact_UserInfo Contact_UserInfo is an auto-generated table.
CustomerClass_Attributes CustomerClass_Attributes is an auto-generated table.
CustomerLocation_LocationContact CustomerLocation_LocationContact is an auto-generated table.
CustomerPaymentMethod_Details CustomerPaymentMethod_Details is an auto-generated table.
Customer_Attributes Customer_Attributes is an auto-generated table.
Customer_BillingContact Customer_BillingContact is an auto-generated table.
Customer_Contacts Customer_Contacts is an auto-generated table.
Customer_CreditVerificationRules Customer_CreditVerificationRules is an auto-generated table.
Customer_MainContact Customer_MainContact is an auto-generated table.
Customer_PaymentInstructions Customer_PaymentInstructions is an auto-generated table.
Customer_Salespersons Customer_Salespersons is an auto-generated table.
Customer_ShippingContact Customer_ShippingContact is an auto-generated table.
Discount_CustomerPriceClasses Discount_CustomerPriceClasses is an auto-generated table.
Discount_Customers Discount_Customers is an auto-generated table.
Discount_DiscountBreakpoints Discount_DiscountBreakpoints is an auto-generated table.
Discount_ItemPriceClasses Discount_ItemPriceClasses is an auto-generated table.
Discount_Items Discount_Items is an auto-generated table.
Discount_Warehouses Discount_Warehouses is an auto-generated table.
Email_TimeActivity Email_TimeActivity is an auto-generated table.
Employee_Contact Employee_Contact is an auto-generated table.
Employee_EmployeeCost Employee_EmployeeCost is an auto-generated table.
Employee_EmploymentHistory Employee_EmploymentHistory is an auto-generated table.
Event_Attendees Event_Attendees is an auto-generated table.
Event_RelatedActivities Event_RelatedActivities is an auto-generated table.
Event_Reminder Event_Reminder is an auto-generated table.
Event_TimeActivity Event_TimeActivity is an auto-generated table.
FinancialPeriod_Details FinancialPeriod_Details is an auto-generated table.
InterBranchAccountMapping_TransactionsInDestinationBranch InterBranchAccountMapping_TransactionsInDestinationBranch is an auto-generated table.
InterBranchAccountMapping_TransactionsInSourceBranch InterBranchAccountMapping_TransactionsInSourceBranch is an auto-generated table.
InventoryAllocationInquiry_Results InventoryAllocationInquiry_Results is an auto-generated table.
InventoryReceipt_Details InventoryReceipt_Details is an auto-generated table.
InventorySummaryInquiry_Results InventorySummaryInquiry_Results is an auto-generated table.
Invoice_ApplicationsCreditMemo Invoice_ApplicationsCreditMemo is an auto-generated table.
Invoice_ApplicationsDefault Invoice_ApplicationsDefault is an auto-generated table.
Invoice_Details Invoice_Details is an auto-generated table.
Invoice_TaxDetails Invoice_TaxDetails is an auto-generated table.
ItemClass_Attributes ItemClass_Attributes is an auto-generated table.
JournalTransaction_Details JournalTransaction_Details is an auto-generated table.
JournalVoucher_Details JournalVoucher_Details is an auto-generated table.
JournalVoucher_GLTransactions JournalVoucher_GLTransactions is an auto-generated table.
KitAssembly_Allocations KitAssembly_Allocations is an auto-generated table.
KitAssembly_NonStockComponents KitAssembly_NonStockComponents is an auto-generated table.
KitAssembly_StockComponents KitAssembly_StockComponents is an auto-generated table.
KitSpecification_NonStockComponents KitSpecification_NonStockComponents is an auto-generated table.
KitSpecification_StockComponents KitSpecification_StockComponents is an auto-generated table.
Lead_Activities Lead_Activities is an auto-generated table.
Lead_Address Lead_Address is an auto-generated table.
Lead_Attributes Lead_Attributes is an auto-generated table.
Lead_Campaigns Lead_Campaigns is an auto-generated table.
Lead_Duplicates Lead_Duplicates is an auto-generated table.
Lead_MarketingLists Lead_MarketingLists is an auto-generated table.
Lead_Relations Lead_Relations is an auto-generated table.
LotSerialClass_Segments LotSerialClass_Segments is an auto-generated table.
NonStockItem_Attributes NonStockItem_Attributes is an auto-generated table.
NonStockItem_CrossReferences NonStockItem_CrossReferences is an auto-generated table.
NonStockItem_SalesCategories NonStockItem_SalesCategories is an auto-generated table.
NonStockItem_VendorDetails NonStockItem_VendorDetails is an auto-generated table.
Opportunity_Activities Opportunity_Activities is an auto-generated table.
Opportunity_Address Opportunity_Address is an auto-generated table.
Opportunity_Attributes Opportunity_Attributes is an auto-generated table.
Opportunity_ContactInformation Opportunity_ContactInformation is an auto-generated table.
Opportunity_Discounts Opportunity_Discounts is an auto-generated table.
Opportunity_Products Opportunity_Products is an auto-generated table.
Opportunity_Relations Opportunity_Relations is an auto-generated table.
Opportunity_TaxDetails Opportunity_TaxDetails is an auto-generated table.
PaymentMethod_AllowedCashAccounts PaymentMethod_AllowedCashAccounts is an auto-generated table.
PaymentMethod_ProcessingCenters PaymentMethod_ProcessingCenters is an auto-generated table.
Payment_ApplicationHistory Payment_ApplicationHistory is an auto-generated table.
Payment_CreditCardProcessingInfo Payment_CreditCardProcessingInfo is an auto-generated table.
Payment_DocumentsToApply Payment_DocumentsToApply is an auto-generated table.
Payment_OrdersToApply Payment_OrdersToApply is an auto-generated table.
PhysicalInventoryReview_Details PhysicalInventoryReview_Details is an auto-generated table.
ProjectTransaction_Details ProjectTransaction_Details is an auto-generated table.
PurchaseOrder_Details PurchaseOrder_Details is an auto-generated table.
PurchaseOrder_ShippingInstructions PurchaseOrder_ShippingInstructions is an auto-generated table.
PurchaseReceipt_Details PurchaseReceipt_Details is an auto-generated table.
ReportingSettings_ReportingGroups ReportingSettings_ReportingGroups is an auto-generated table.
SalesInvoice_BillingSettings SalesInvoice_BillingSettings is an auto-generated table.
SalesInvoice_Details SalesInvoice_Details is an auto-generated table.
SalesInvoice_FreightDetails SalesInvoice_FreightDetails is an auto-generated table.
SalesOrder_BillToAddress SalesOrder_BillToAddress is an auto-generated table.
SalesOrder_BillToContact SalesOrder_BillToContact is an auto-generated table.
SalesOrder_Commissions SalesOrder_Commissions is an auto-generated table.
SalesOrder_Details SalesOrder_Details is an auto-generated table.
SalesOrder_DiscountDetails SalesOrder_DiscountDetails is an auto-generated table.
SalesOrder_FinancialSettings SalesOrder_FinancialSettings is an auto-generated table.
SalesOrder_Payments SalesOrder_Payments is an auto-generated table.
SalesOrder_Shipments SalesOrder_Shipments is an auto-generated table.
SalesOrder_ShippingSettings SalesOrder_ShippingSettings is an auto-generated table.
SalesOrder_ShipToAddress SalesOrder_ShipToAddress is an auto-generated table.
SalesOrder_ShipToContact SalesOrder_ShipToContact is an auto-generated table.
SalesOrder_TaxDetails SalesOrder_TaxDetails is an auto-generated table.
SalesOrder_Totals SalesOrder_Totals is an auto-generated table.
SalesPricesInquiry_SalesPriceDetails SalesPricesInquiry_SalesPriceDetails is an auto-generated table.
SalesPriceWorksheet_SalesPrices SalesPriceWorksheet_SalesPrices is an auto-generated table.
Shipment_Details Shipment_Details is an auto-generated table.
Shipment_Orders Shipment_Orders is an auto-generated table.
Shipment_Packages Shipment_Packages is an auto-generated table.
Shipment_ShippingSettings Shipment_ShippingSettings is an auto-generated table.
ShippingTerm_Details ShippingTerm_Details is an auto-generated table.
ShipVia_FreightRates ShipVia_FreightRates is an auto-generated table.
ShipVia_Packages ShipVia_Packages is an auto-generated table.
StockItem_Attributes StockItem_Attributes is an auto-generated table.
StockItem_Boxes StockItem_Boxes is an auto-generated table.
StockItem_Categories StockItem_Categories is an auto-generated table.
StockItem_CrossReferences StockItem_CrossReferences is an auto-generated table.
StockItem_ReplenishmentParameters StockItem_ReplenishmentParameters is an auto-generated table.
StockItem_SubItems StockItem_SubItems is an auto-generated table.
StockItem_UOMConversions StockItem_UOMConversions is an auto-generated table.
StockItem_VendorDetails StockItem_VendorDetails is an auto-generated table.
StockItem_WarehouseDetails StockItem_WarehouseDetails is an auto-generated table.
Task_RelatedActivities Task_RelatedActivities is an auto-generated table.
Task_RelatedTasks Task_RelatedTasks is an auto-generated table.
Task_Reminder Task_Reminder is an auto-generated table.
Task_TimeActivity Task_TimeActivity is an auto-generated table.
TaxCategory_Details TaxCategory_Details is an auto-generated table.
TaxZone_ApplicableTaxes TaxZone_ApplicableTaxes is an auto-generated table.
Tax_TaxSchedule Tax_TaxSchedule is an auto-generated table.
Tax_Zones Tax_Zones is an auto-generated table.
TransferOrder_Details TransferOrder_Details is an auto-generated table.
TrialBalance_Details TrialBalance_Details is an auto-generated table.
VendorClass_Attributes VendorClass_Attributes is an auto-generated table.
VendorPricesInquiry_VendorPriceDetails VendorPricesInquiry_VendorPriceDetails is an auto-generated table.
VendorPriceWorksheet_VendorSalesPrices VendorPriceWorksheet_VendorSalesPrices is an auto-generated table.
Vendor_Attributes Vendor_Attributes is an auto-generated table.
Vendor_Contacts Vendor_Contacts is an auto-generated table.
Vendor_MainContact Vendor_MainContact is an auto-generated table.
Vendor_PaymentInstructions Vendor_PaymentInstructions is an auto-generated table.
Vendor_RemittanceContact Vendor_RemittanceContact is an auto-generated table.
Vendor_ShippingContact Vendor_ShippingContact is an auto-generated table.
Warehouse_Locations Warehouse_Locations is an auto-generated table.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462