Views

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData MCP Server for Sage Intacct Views


Name	Description
AccountBalance	Contains comprehensive account balance details, including historical data and summaries for financial reporting.
AccountBalanceByDimensions	View containing detailed account balance by dimension data.
ACHBank	Captures configurations and details for ACH bank setups, aiding in electronic payment processes.
AllocationEntry	Details individual allocation components, covering related dimensions and associated financial entities.
APAdjustmentItem	Details line items in accounts payable adjustments, covering accounts, amounts, and allocation dimensions.
APBillItem	Provides line-level details for items in accounts payable bills, including allocation and cost specifics.
APBillPayment	Tracks payments made for accounts payable bills, recording amounts, payment states, and related data.
APIUsageDetail	Provides granular data on API usage, tracking functions, client interactions, and transaction details.
APIUsageSummary	Summarizes API usage data, including transaction counts, client types, and daily summaries.
APPayment	Captures information on payments made in the accounts payable module, including vendor details and amounts.
APPaymentItem	Details specific items within accounts payable payments, highlighting allocation, amounts, and associated entities.
APPaymentRequest	Tracks accounts payable payment requests, including statuses, amounts, and related scheduling data.
APRecurBillEntry	Tracks individual entries in recurring AP bills, covering amounts, allocations, and related projects or entities.
ARAdjustmentItem	Details line items associated with accounts receivable adjustments for in-depth reporting and tracking.
ARInvoiceItem	Details line items in accounts receivable invoices, providing financial and dimensional insights.
ARPayment	Provides detailed records of accounts receivable payments, including transaction statuses and related metadata.
ARPaymentItem	Tracks individual items within AR payments, offering insights into payment allocation and transaction details.
ARRecurInvoice	Handles retrieval of AR recurring invoice report data.
ARRecurInvoiceEntry	Tracks detailed entries for recurring AR invoices, covering line items, amounts, and related dimensions.
Attachments	Stores and manages attachment records, enabling linkage to related transactions or entities.
Audithistory	The AuditHistory table returns information about multiple tpyes of objects including audit trail logs and user access logs.
BankFee	Details bank fees, including associated accounts, transactions, and financial entities.
BankFeeEntry	Captures line-level data for bank fees, detailing amounts, allocations, and relevant dimensions.
BillingSchedule	Provides information about billing schedules, including methods, statuses, and related transactions.
CCTransaction	Retrieves details about credit card transactions, including financial entity, payment information, and status.
CCTransactionEntry	Retrieves detailed line items related to credit card transactions, including account, department, location, and project details.
ChargePayoff	Tracks charge payoff transactions, documenting statuses, financial entities, and reversal information.
ChargePayoffEntry	Provides detailed line items for charge payoff transactions, including accounts, amounts, and dimensions.
ClassGroup	Manages class groups, capturing group types, relationships, and associated entities.
CNSAcctBal	Provides consolidated account balance data, summarizing financial entries and subsidiary relationships.
Company	Stores company information, covering legal, operational, and contact-related metadata.
Contractbillingschedule	Metadata for managing contract billing schedules in Sage Intacct.
Contractbillingschedule	Tracks revenue schedules for contracts, supporting financial reporting and compliance.
CreditCardFee	Details fees associated with credit card transactions, including allocations and related accounts.
CreditCardFeeEntry	Tracks line items for credit card fees, documenting amounts, accounts, and financial allocations.
DDSJob	Tracks data delivery service jobs, documenting statuses, schedules, and related entities.
DepartmentGroup	Retrieves report data for department groups.
Deposit	Records deposit transactions, detailing amounts, accounts, and associated financial data.
DepositEntry	Provides detailed line items for deposits, including accounts, amounts, and transaction metadata.
DimensionRelationships	Maps relationships between dimension objects, providing integration and hierarchy information.
Dimensions	Lists all standard and user-defined dimensions in a company, enabling detailed financial analysis.
EExpensesItem	Provides line-level details for employee expense items, documenting allocations and related projects.
EExpensesPayment	Tracks payments for employee expenses, recording amounts, statuses, and transaction details.
EPPayment	Tracks payments made to employees, including amounts, methods, and transaction metadata.
EPPaymentItem	Details line items for employee payments, documenting allocations and associated transactions.
EPPaymentRequest	Tracks employee payment requests, recording amounts, statuses, and related data.
ExchangeRateEntry	Tracks detailed entries for exchange rates, documenting rate values and associated periods.
ExchangeRateTypes	Defines types of exchange rates, linking them to currencies and operational configurations.
ExpenseAdjustmentsItem	Provides line-level details for expense adjustments, documenting accounts, amounts, and allocations.
FundsTransfer	Tracks fund transfers between accounts, including amounts, currencies, and transaction statuses.
FundsTransferEntry	Provides detailed line items for fund transfers, documenting accounts, amounts, and dimensions.
GLAccountBalance	Tracks the balances of GL accounts, including details on transactions and period summaries, to aid in financial reporting and reconciliation.
GLAcctGrpHierarchy	Provides a hierarchical representation of GL account groups, detailing member accounts and their attributes for structured reporting.
GLDetail	Contains granular details of General Ledger (GL) entries, including transaction data for precise financial tracking.
GLEntry	Stores information about individual GL entries, including amounts, accounts, and supporting details for journal postings.
GLResolve	Supports the resolution and reconciliation of General Ledger (GL) entries, facilitating error correction and reporting.
InvDocumentEntry	Provides detailed line item information for invoicing documents, including descriptions, quantities, and amounts.
InvDocumentSubtotals	Retrieves subtotal data for invoicing documents, including item totals, taxes, and other aggregates.
InvoiceRun	Tracks details of invoice runs, including batch processing information and associated summaries.
InvPriceListEntry	Provides line-item level pricing data for price lists, including quantity breaks, item-specific pricing, and related conditions.
ItemComponent	Details the components comprising a single item, including their quantities and costs, for assembly and tracking.
ItemGroup	Defines groupings of items, including shared attributes and member details, to simplify product categorization.
LocationGroup	Manages grouping information for multiple locations, detailing membership and operational attributes for streamlined oversight.
OtherReceipts	Tracks receipts outside standard invoices, capturing creation dates, payment details, and metadata for financial reconciliation.
OtherReceiptsEntry	Maintains line-level details for miscellaneous receipts, including allocations to specific accounts, departments, or projects.
PODocumentEntry	Details individual line items in a PO, covering item information, quantity, pricing, and other relevant metadata.
PODocumentSubtotals	Provides detailed subtotal data for purchase order (PO) documents, including values, percentages, and related metadata.
POPriceListEntry	Captures line-level pricing rules for POs, detailing item-specific rates, quantities, effective dates, and conditions.
PORecurSubtotals	Tracks recurring subtotal data for POs, including periodic cost updates, discounts, and associated attributes.
RecurDocumentEntry	Stores recurring document data at the entry level, capturing periodic line items, associated amounts, and schedule details for automating repetitive transactions.
RecurGLEntry	Contains individual entries within recurring GL batches, detailing accounts, amounts, and effective dates for consistent financial postings.
RevRecChangeLog	Logs changes to revenue recognition settings, tracking modifications and user details for audit trails and compliance.
RevRecScheduleEntryTask	Tracks tasks associated with revenue recognition schedule entries, including planned and actual progress for accurate forecasting.
SODocumentEntry	Provides line-level detail for SO documents, including items, pricing, taxes, and references to related records.
SODocumentSubtotals	Contains subtotal information for sales order (SO) documents, including values such as absolute amounts, percentages, totals, and relevant dimension keys for various categories like project, vendor, employee, and item.
SOPriceListEntry	Contains the entries for sales order (SO) price lists, including details for specific items, pricing, quantity limits, and associated employee or sale information.
SORecurDocument	Holds data for recurring SO documents, managing repeated transactions, billing schedules, and customer payment details.
SORecurSubtotals	Contains subtotal data for recurring sales orders (SO), including values for absolute amounts, percentages, and totals, along with associated project, vendor, employee, and location details.
STKitDocumentEntry	Offers line-level insights into stock kit document entries, capturing kit components, pricing, and quantity data.
Subscriptions	Documents subscription services, including contract terms, recurring billing cycles, and associated product or service details.
TerritoryGrpMember	Identifies individual territories within a territory group, detailing membership and associated metadata for comprehensive coverage.
TimesheetEntry	Provides line-level detail within timesheets, recording daily hours, tasks, projects, and cost allocation details.
TransTmplBatch	Stores batched transaction template data, enabling bulk handling of repeated transaction patterns.
TransTmplEntry	Provides detailed line items for transaction templates, including account, project, vendor, and item associations.
TrialBalances	Compiles trial balance data, including debits, credits, and adjustments for specified accounting periods.
TrialBalancesDepartmentDetail	Breaks down trial balances by department, showing account-level debits, credits, and adjustments for departmental analysis.
TrialBalancesLocationDetail	Offers a location-based trial balance view, itemizing financial data and enabling site-specific financial oversight.
UoMDetail	Expands on UoM data with conversion factors and additional metadata for precise measurement across transactions.
UserRights	Outlines access privileges and permissions assigned to users, covering application modules and record-level visibility.
WfpmPaymentRequest	Stores information about payment requests, including requested amounts, statuses, and links to vendor or financial data.