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 ADO.NET Provider for Sage Intacct Views


Name	Description
AccountCategory	Represents account categories used to classify and group general ledger accounts by type and balance characteristics.
AccountGroupCategoryMember	Represents the account category members that belong to an account group, linking account categories to their parent groups.
AccountGroupComputation	Represents computation configurations for account groups, defining formula operations and display settings used in financial reporting.
AccountGroupMember	Represents the member relationships between account groups, defining how child account groups are nested within parent groups.
AccountRange	Represents ranges of general ledger accounts assigned to account groups, defining the starting and ending account identifiers included in each range.
AdjustmentSummary	Represents summary-level records that group accounts payable adjustment transactions for batch processing and general ledger posting.
AdjustmentTaxEntry	Represents tax entries applied to individual lines on accounts payable adjustment transactions, including tax rate and amount details.
AffiliateEntity	Represents affiliate entities used to identify and manage related organizations in intercompany and multi-entity transactions.
ApReleasableRetainage	Represents accounts payable retainage amounts that are eligible for release, including retained and remaining balances from vendor bills.
ApRetainageReleaseLine	Represents individual line items on accounts payable retainage release transactions, linking released retainage amounts to their originating bills.
ArAdvanceTxnLineTemplate	Represents line-level template entries for accounts receivable advance transaction templates, defining default account and memo settings for advance transactions.
ArReleasableRetainage	Represents accounts receivable retainage amounts that are eligible for release, including retained and remaining balances from customer invoices.
ArRetainageReleaseLine	Represents individual line items on accounts receivable retainage release transactions, linking released retainage amounts to their originating invoices.
AuditHistory	Represents an audit trail of changes made to records, capturing the field-level details, action performed, and source of each change.
BankAccount	Represents bank accounts used for financial transactions, including checking, savings, and other account types linked to financial institutions.
BillingScheduleLine	Represents individual lines within a billing schedule, defining the scheduled and actual billing dates, amounts, and billing state.
BillingTemplateLine	Represents individual lines within a billing template, defining the percentage to bill, period offset, and step billing thresholds.
BillSummary	Represents summary-level records that group accounts payable bill transactions for batch processing and general ledger posting.
BillTaxEntry	Represents tax entries applied to individual lines on accounts payable bill transactions, including tax rate and amount details.
BudgetDetail	Represents individual budget detail lines that define planned amounts by general ledger account, reporting period, and entity.
ChangeRequestLine	Represents individual line items on change requests, defining the cost, price, quantity, and project contract associations for each change.
ComplianceDefinitionAssociation	Represents associations between compliance definitions and project or vendor types, controlling which combinations require compliance tracking.
ContactVersion	Represents versioned snapshots of contact records, capturing historical changes to contact details such as address, tax, and price list information.
CreditCardTxnTaxEntry	Represents tax entries applied to credit card transaction lines, capturing the tax detail, tax rate, and calculated tax amounts in both base and transaction currencies.
CustomApplication	Represents custom applications registered in the system.
CustomerContact	Represents contact associations for customers, linking contacts to customers with a named category.
CustomerRefundDetail	Represents detail records that link customer refund lines to the originating AR transactions, such as invoices, adjustments, advances, or overpayments.
CustomerRefundLine	Represents individual line items on customer refunds, capturing GL account allocations, amounts in base and transaction currencies, and exchange rate details.
CustomerRestrictedDepartment	Represents department restrictions assigned to customers, controlling which departments or department groups are available for use on transactions for each customer.
DepreciationMethod	Represents depreciation methods used to define how asset values are reduced over time for fixed asset accounting.
DepreciationSchedule	Represents depreciation schedules for assets, tracking accumulated depreciation amounts, depreciable cost, historical posting data, and associated depreciation rule settings.
DepreciationScheduleEntry	Represents individual period entries within a depreciation schedule, capturing scheduled and actual posting dates, depreciation amounts, and associated journal entry details.
Disposal	Represents asset disposal transactions, capturing the disposal type, date, amounts, gain or loss, and associated journal entry details.
DisposalDepreciationScheduleMap	Represents the mapping between asset disposals and their corresponding depreciation schedules, capturing partial depreciation amounts, gain or loss, and disposal journal entry details.
EmployeeBankFileSetup	Represents bank file setup configurations for employees, capturing bank account details, creditor address information, and international banking identifiers used for payment processing.
ExpenseTemplateLine	Represents individual period lines within an expense recognition template, defining the percentage to recognize and the period offset for each scheduled recognition step.
ExpenseToApprove	Represents employee expense reports that are pending approval, providing a view of submitted expenses with reimbursement totals and expense summary information.
ExpenseToApproveLine	Represents individual line items on expense reports pending approval, capturing GL account allocations, expense types, payment types, credit card transaction links, and currency conversion details.
FundsTransferLine	Represents individual line items on a funds transfer, capturing GL account allocations, transaction amounts, and currency conversion details.
InitialOpenItem	Represents initial open items used to record outstanding balances for bank accounts at the start of a reconciliation period.
InvoiceRun	Represents invoice run records that capture the execution of automated invoice generation, including template, price list, and processing state details.
InvoiceSummary	Represents invoice summary batches used to group and post accounts receivable invoices to the general ledger.
InvoiceTaxEntry	Represents individual tax entries on invoice lines, capturing the tax detail, tax rate, and calculated tax amounts in both base and transaction currencies.
ItemLandedCost	Represents landed cost configurations for items, defining the distribution method and cost values used to allocate landed costs to inventory transactions.
ItemTaxGroupItemMap	Represents mappings between items and item tax groups for a specific tax solution.
ItemVendor	Represents vendor-specific information for items, including pricing, lead time, order quantity settings, and unit of measure details.
JournalEntryLineTemplate	Represents template lines used to define the default GL account, transaction type, and exchange rate settings for journal entry templates.
JournalEntryTaxEntry	Represents individual tax entries on journal entry lines, capturing the tax detail, tax rate, and calculated tax amounts in both base and transaction currencies.
LocationGroupMember	Represents the membership of individual locations within a location group, including sort order for display purposes.
ManualDepositLine	Represents individual line items on a manual deposit, capturing GL account allocations, account labels, and payment amounts in base and transaction currencies.
ManualDepositSummary	Represents manual deposit summary batches used to group and post manual deposit transactions to the general ledger.
OrderEntryTaxScheduleDetail	Represents individual tax detail lines within an order entry tax schedule, associating a tax detail with its effective date and parent tax schedule.
OtherReceiptLine	Represents individual line items on an other receipt, capturing GL account allocations, AR account labels, payment amounts, and currency details.
OtherReceiptTaxEntry	Represents individual tax entries on other receipt lines, capturing the tax detail, tax rate, and calculated tax amounts in both base and transaction currencies.
PaymentDetail	Represents the detail records associated with a payment, linking applied bills, advances, adjustments, and inline transactions with their corresponding payment amounts and currencies.
PaymentLine	Represents individual line items on a payment, capturing GL account allocations, currency amounts, tax details, and exchange rate information.
PaymentProvider	Represents payment providers used to facilitate electronic payment processing, including contact information, withdrawal type, and supported payment methods.
Permission	Represents system permissions that define access rights for roles, organized by module.
PostingSummary	Represents posting summary records that link source documents to their corresponding journal entries for audit and traceability purposes.
ProjectBillingTemplateMilestone	Represents individual milestones within a project billing template, defining the completion percentage and the corresponding percentage to invoice at each stage.
ProjectEstimateLine	Represents individual line items within a project estimate, capturing GL account allocations, cost amounts, quantities, workflow type, and associated change request references.
ProviderPaymentMethod	Represents the payment methods supported by a payment provider, defining the payment type and current status.
ReconciliationSourceRecord	Represents source records used in bank reconciliation, capturing transaction amounts, dates, posting states, and reconciliation status for matching against bank statements.
RecurringBillTaxEntry	Represents individual tax entries on recurring bill lines, capturing the purchasing tax detail, tax rate, and calculated tax amounts.
RecurringDocument	Represents recurring order entry or purchasing documents generated on a schedule, including customer details, transaction definition, currency, schedule configuration, and associated line items.
RevenueScheduleLine	Represents individual lines within a revenue schedule, capturing scheduled and posted amounts, posting dates, exchange rates, and the associated journal entry.
RoleUserGroupMap	Represents the mapping of user groups to roles, defining which user groups are assigned a given role.
RoleUserMap	Represents the mapping of users to roles, defining which users are assigned a given role.
StatisticalJournalEntryLine	Represents individual lines within a statistical journal entry, capturing statistical account allocations, unit counts, transaction amounts, and reconciliation details.
StockableKitDocumentLine	Represents individual line items within a stockable kit document, capturing item quantities, costs, unit of measure, source document references, and tracking details.
StoredReportErrorRecord	Represents error records generated when a stored report fails to process, capturing the error code, description, and associated stored report.
SuppliesDocumentDetail	Represents detail records linking supplies requisition documents to inventory document lines, capturing transaction date, quantity, and processing state.
SystemView	Represents system-defined views that expose queryable data sets, including the associated object, query definition, applicable contexts, and display name.
TaxDetail	Represents tax details that define tax rates, applicable tax limits, reverse charge settings, and associated tax solution references.
TaxRecord	Represents tax records generated from transactions, capturing tax amounts, filing status, tax authority details, and links to source and tax journal entry lines.
TimesheetApprovalRecord	Represents approval records for timesheet entries, capturing the approval stage, approver assignments, workflow state, and associated timesheet and timesheet line references.
TransferJournalEntryMap	Represents the mapping of journal entries to fixed asset transfer history records, linking depreciation schedules and journals to the resulting transfer entries.
UndepositedFund	Represents undeposited funds awaiting deposit, capturing payment method, payee, currency, and transaction totals.
UnitRate	Represents unit rates assigned to employee expense types, specifying the rate amount and the effective start date.
VendorBankFileSetup	Represents bank file payment setup records for vendors, capturing bank account details, creditor information, and payment reference configuration.
VendorRestrictedDepartment	Represents department restrictions assigned to vendors, specifying which departments or department groups the vendor is restricted to.
VendorRestrictedLocation	Represents location restrictions assigned to vendors, specifying which locations or location groups the vendor is restricted to.
VendorTotal	Represents total amount summaries for vendors, capturing the total amount currently due for each vendor.
WarehouseTransferLine	Represents individual line items within a warehouse transfer, capturing item details, quantities, costs, transfer direction, and associated inventory documents.