Tables
The cmdlet models the data in Sage Intacct as a list of tables in a relational database that can be queried using standard SQL statements.
CData Cmdlets PowerShell Module for Sage Intacct Tables
| Name | Description |
| AcctLabelTaxGroup | Stores information about account label tax groups, focusing on tax-related classifications and their configurations. |
| AcctRange | Defines account ranges and provides metadata for setting up and managing financial account groupings. |
| ActivityLog | Logs system and user-generated events, offering a historical view of activity for auditing and troubleshooting. |
| Aisle | Represents aisles in warehouse or storage systems, enabling organization and location tracking within facilities. |
| Allocation | Tracks allocation records, including types, descriptions, and statuses for financial distributions. |
| APAccountLabel | Manages labels for accounts payable accounts, linking them to general ledger accounts and descriptions. |
| APAdjustment | Tracks accounts payable adjustments, including vendor interactions and changes to payment statuses. |
| APBill | Contains information on accounts payable bills, including vendor data, payment terms, and outstanding balances. |
| APBillBatch | Groups accounts payable bills into batches, providing statuses, totals, and related operational details. |
| APPymt | Provides detailed information about accounts payable payments, including vendor details, payment amounts, and transaction statuses. |
| APRecurBill | Manages recurring accounts payable bills, detailing contract-specific billing and vendor information. |
| APTerm | Maintains accounts payable terms, including payment schedules, discounts, and penalties. |
| ARAccountLabel | Stores accounts receivable account labels, linking them to tax attributes and general ledger accounts. |
| ARAdjustment | Manages AR adjustment records, allowing for retrieval and modification of details related to adjustments in the Accounts Receivable module. |
| ARInvoice | Manages accounts receivable invoices, including customer details, payment terms, and transaction specifics. |
| ARInvoiceBatch | Manages and retrieves batch data for AR invoices, including status and entity details. |
| ARPaymentBatch | Manages batch-level data for accounts receivable payments, supporting creation, updates, and deletions. |
| ARTerm | Manages terms for accounts receivable transactions, including payment schedules, discounts, and penalties. |
| Attendee | Retrieves data about attendees including relevant customer and employee information. |
| Billing_Contact | Manages billing contact records, linking them to customers and their corresponding financial details. |
| Bin | Stores data about bins used in warehouse or inventory management, including identifiers and descriptions. |
| CheckingAccount | Retrieves information about checking accounts, including bank details, account configuration, and associated financial data. |
| Class | Tracks classification objects, including hierarchy and metadata for organizational purposes. |
| Comments | Logs comments linked to various objects, including creation details and modification histories. |
| Contact | Tracks contact records, linking them to entities, customers, or employees for communication purposes. |
| Contract | Manages contract records, supporting operational and financial tracking for agreements in Sage Intacct. |
| CreditCard | Stores credit card data for financial reporting and transaction tracking. |
| Customer | Manages customer records, including contact details, classifications, and financial interactions. |
| CustomerEmailTemplate | Stores email templates tailored for customer communication and engagement. |
| CustomerGroup | Retrieves report data for customer groups. |
| CustomerVisibility | Tracks visibility settings for customers, controlling access and permissions across entities. |
| CustType | Defines customer types, enabling categorization and tailored business processes. |
| Department | Manages department records, capturing organizational structure and operational details. |
| EarningType | Manages earning type records, detailing classifications and usage in payroll or compensation. |
| EEAccountLabel | Tracks employee expense account labels, linking them to accounts and operational data. |
| EExpenses | Manages employee expense records, including amounts, dates, and associated accounts. |
| EmailTemplate | Manages email templates for communication, supporting customization and entity-specific messaging. |
| Employee | Tracks employee records, including contact details, positions, and associated operational data. |
| EmployeeEntityContacts | Manages contact records linked to employee entities, supporting communication and reporting. |
| EmployeeGroup | Retrieves report data for employee groups. |
| EmployeeOutOfOffice | Tracks employees who are out of office, including statuses and associated dates. |
| EmployeePositionSkill | Manages employee position skills, linking roles to required qualifications and competencies. |
| EmployeeRate | Tracks employee rate records, detailing pay rates and associated financial data. |
| EmployeeType | Defines employee types for categorization and operational grouping. |
| ExchangeRate | Stores exchange rate records, including currency conversions and effective dates. |
| ExpenseAdjustments | Manages expense adjustment records, detailing changes, statuses, and related financial data. |
| ExpensePaymentType | Tracks expense payment types, detailing configurations, statuses, and financial offsets. |
| FixedAsset | Table containing details on fixed assets. |
| GAAPAdjJrnl | Contains detailed information for GAAP (Generally Accepted Accounting Principles) adjustment journals, including journal titles, statuses, and timestamps, to support compliance and reporting. |
| Geninvoicepreview | Defines the schema used for generating and previewing invoices, facilitating pre-approval workflows and invoice accuracy checks. |
| GLAccount | Stores detailed metadata for General Ledger (GL) accounts, including account types, attributes, and configuration, to support financial tracking. |
| GLAcctGrp | Manages data for GL account groups, including group filters and configurations, to streamline categorization and reporting. |
| GLAcctGrpMember | Contains data on the individual members of GL account groups, including their relationships within the group hierarchy. |
| GLBatch | Tracks General Ledger (GL) batches with associated metadata, enabling batch processing and auditing. |
| Glbudgetheader | Summarizes metadata and high-level information for General Ledger (GL) budget headers, supporting financial planning. |
| Glbudgetitem | Holds detailed line item data for General Ledger (GL) budgets, facilitating granular budget analysis and tracking. |
| GLCoaCatMember | Captures relationships between accounts and their categories within the Chart of Accounts, supporting classification and reporting. |
| GLCompGrpMember | Manages data related to comparison group memberships in the General Ledger, enabling multi-dimensional analysis. |
| ICRow | Captures row-level data for the Inventory Control (IC) module, including inventory movement and adjustments. |
| InvDocument | Holds information about invoicing documents, including header-level data for tracking and processing. |
| InvDocumentParams | Defines parameters and configuration settings for invoicing documents, supporting custom workflows and templates. |
| InvPriceList | Stores pricing details for items in a price list, including effective dates and conditions for price application. |
| Item | Maintains comprehensive details about items, including descriptions, pricing, and tax data, for inventory and sales processes. |
| ItemTaxGroup | Stores tax group information for items, including applicable tax codes, rates, and classifications. |
| ItemWarehouseInfo | Tracks warehouse-specific details for items, such as stock levels and locations, to enable inventory management. |
| Journal | Stores comprehensive journal data, including transactional records, journal entries, and accounting details for financial analysis and reporting. |
| Location | Holds location-specific data, including addresses, contact information, and configuration settings, to support multi-location operations. |
| Misc_Supporting_Document | Retrieves miscellaneous supporting documents referencing customers and vendors, useful for supplementary record-keeping and audits. |
| OutOfOffice | Tracks employee out-of-office records, noting absence dates, durations, and related approvals for workforce management. |
| PODocument | Stores comprehensive details for Purchase Order (PO) documents, capturing statuses, associated vendors, and workflow data. |
| PODocumentParams | Stores parameter settings for PO documents, enabling advanced configuration, custom fields, and specialized workflows. |
| POPriceList | Maintains price list configurations for POs, including validity periods, discount structures, and status details. |
| PositionSkill | Maintains records of required or possessed skills for specific positions, including skill statuses and descriptive data. |
| ProductLine | Organizes product lines with descriptive information, linking child lines, statuses, and related product attributes. |
| Project | Manages project records, capturing essential details like budget allocations, operational status, and relevant dimensions. |
| PjEstimate | Stores project estimate records, detailing cost projections, status, type classifications, and related metadata. |
| ProjectGroup | Defines groupings for projects, consolidating shared attributes, types, and metadata for easier management. |
| ProjectResources | Tracks resource allocations by listing employees, materials, and costs assigned to specific projects. |
| ProjectStatus | Manages status definitions for projects, capturing constraints, creation data, and workflow metadata. |
| ProjectTransactionRule | Sets rules governing project transactions, tracking rule definitions, creation history, and modification details. |
| ProjectType | Classifies projects by type, linking them to parent classifications, statuses, and additional metadata. |
| Ratetable | Serves as the master reference for rate tables, maintaining data on various rates used in financial transactions. |
| Ratetableapentry | Stores AP-specific rate table entries, providing currency exchange data, rates, and related accounts payable fields. |
| Ratetableccentry | Houses rate table entries tailored to credit card transactions, including rate details and related purchase data. |
| Ratetableexpenseentry | Defines rate-based expense entries, linking employee expense transactions with currency or rate adjustments. |
| Ratetableglentry | Captures GL-based rate table entries, incorporating currency conversions and relevant ledger references. |
| Ratetablepoentry | Compiles PO-specific rate table entries, ensuring accurate currency conversions for purchase order transactions. |
| Ratetabletsentry | Manages timesheet-related rate table entries, ensuring accurate currency conversions and cost calculations for project time tracking. |
| RecurGLBatch | Houses information on recurring general ledger batches, enabling automatic posting of repeated financial transactions. |
| RenewalMacro | Captures configuration and execution data for automated renewal processes, streamlining contract renewals and recurring agreements. |
| ReportingPeriod | Defines reporting windows, including start/end dates and status, ensuring accurate financial statements and analysis over specific time frames. |
| Revrecschedule | Maintains schedules outlining how revenue is recognized over time, supporting compliance with revenue recognition principles. |
| Revrecscheduleentry | Details each component of a revenue recognition schedule, noting corresponding accounts, allocation amounts, and recognition statuses. |
| RevRecTemplate | Serves as a template for revenue recognition scheduling, defining periods, allocation methods, and default attributes. |
| RevRecTemplMilestone | Specifies milestone-based revenue recognition triggers within a template, detailing offsets, percentages, and descriptions. |
| SavingsAccount | Stores details for savings accounts, including bank configuration and account offsets, aiding financial transactions and reconciliation. |
| Seminar_Package | Tracks seminar package contents, associating GL accounts and line items to group offerings under a single event or product. |
| Seminar_Registration | Documents seminar registrations, referencing invoice details and record URLs to confirm attendee enrollment. |
| SODocument | Holds comprehensive data for Sales Order (SO) documents, capturing order status, contact details, addresses, and project linkages. |
| SODocumentParams | Configures Sales Order (SO) document parameters, such as numbering sequences, discount handling, and tax calculations. |
| SOPriceList | Stores sales order-specific price list configurations, detailing effective dates, usage contexts, and entity restrictions. |
| StatAccount | Stores statistical account data, supporting non-financial metrics that can impact budgeting and analysis (e.g., headcount). |
| StatJournal | Captures statistical journal records, including journal symbols, approval status, and modification details for non-monetary entries. |
| STKitDocument | Tracks stock kit documents, detailing item bundling, shipping requirements, and relevant transaction references. |
| Task | Oversees task assignments within projects or jobs, specifying status, effort, budget, and stakeholder info for efficient tracking. |
| TaskResources | Tracks resource allocation for tasks, including employee assignments, cost rates, and project linkage for better utilization. |
| TaxGroup | Stores data about tax groups, detailing group names, codes, applicable tax rates, and configuration across entities. |
| TerritoryGroup | Organizes territories into groups for streamlined regional management and reporting, capturing key group attributes. |
| Timesheet | Captures timesheet entries at a summary level, including employee data, total hours, and project or department allocations. |
| TimeType | Defines categories for tracked time (e.g., regular, overtime), specifying associated accounts and earnings types. |
| Track | Holds a collection of track items, such as usage logs or progress markers, for auditing and analysis. |
| TransactionRule | Governs financial transaction logic by defining parameters, validations, and triggers within the system. |
| TransactionRuleDetail | Lists the specific configurations tied to a transaction rule, including account overrides, filters, and range limitations. |
| TrxCurrencies | Holds information on currencies used in transactions, including currency codes, exchange formats, and related metadata. |
| UoM | Defines units of measure (UoM), setting standardized conversions and usage settings for consistent quantity tracking. |
| UserAdjJrnl | Tracks user-generated journal adjustments, documenting journal details, statuses, and modification timestamps. |
| UserInfo | Captures user credentials and profile data, including contact details and system preferences for each Intacct user. |
| UserRoles | Defines roles within the system and the users associated with them, guiding functional access and authorization. |
| Vendor | Holds vendor records, capturing addresses, payment terms, and financial settings for accounts payable processes. |
| VendorGroup | Contains detailed information about vendor groups, including group attributes, associated entities, and creation/modification details. |
| VendorVisibility | Controls which vendors are visible to specific departments or locations, enforcing access and compliance requirements. |
| VendType | Classifies vendors into types, including tax classification, parent relationships, and additional configuration details. |
| Warehouse | Manages warehouse data, capturing addresses, operational details, and inventory controls for each storage facility. |