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 Cmdlets PowerShell Module 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. |