ADO.NET Provider for Sage Intacct

Build 26.0.9655

Tables

The provider models the data in Sage Intacct as a list of tables in a relational database that can be queried using standard SQL statements.

CData ADO.NET Provider for Sage Intacct Tables

Name Description
Account Represents general ledger accounts, including account type, category, and status details.
AccountAllocation Represents account allocation definitions used to distribute general ledger account balances across dimensions and entities.
AccountGroup Represents general ledger account groups used to organize and aggregate accounts for reporting and financial analysis.
AccountGroupPurpose Represents the defined purposes that classify how account groups are used in financial reporting and analysis.
AccumulationType Represents accumulation types that classify how costs and amounts are accumulated and categorized in project and financial reporting.
Adjustment Represents accounts payable adjustment transactions, including header-level details such as vendor, currency, amounts, and posting state.
AdjustmentJournal Represents journal configurations for accounts payable adjustments, linking adjustments to general ledger journals and book settings.
AdjustmentLine Represents individual line items on accounts payable adjustment transactions, including account, amount, and tax details.
Advance Represents accounts payable advance transactions, including vendor, payment, currency, and reconciliation details.
AdvanceLine Represents individual line items on accounts payable advance transactions, including general ledger account and amount details.
AffiliateEntityGroup Represents groups used to organize affiliate entities for reporting, filtering, and intercompany transaction management.
Aisle Represents aisles within warehouse locations used for organizing and tracking inventory storage areas.
ApRetainageRelease Represents accounts payable retainage release transactions used to release withheld retainage amounts back to vendors.
ArAdvanceTxnTemplate Represents templates used to configure default settings for accounts receivable advance transactions, including transaction source and line templates.
ArRetainageRelease Represents accounts receivable retainage release transactions used to release withheld retainage amounts back to customers.
Asset Represents fixed assets, including acquisition, depreciation, disposal, and general ledger account details.
AssetClassification Represents asset classifications used to categorize fixed assets and define their associated general ledger accounts and depreciation rules.
AssetDepreciationRule Represents depreciation rules applied to fixed assets, defining the method, rate, useful life, and journal used for calculating depreciation.
Attachment Represents attachment folders used to group and manage files associated with transactions and records.
BankFee Represents bank fee transactions recorded against financial accounts, including transaction amounts, currency details, and reconciliation state.
BankFeed Represents bank feed imports used to download and process transactions from financial institution connections into financial accounts.
Bill Represents accounts payable bill transactions, including vendor, payment, currency, retainage, and tax solution details.
BillbackTemplate Represents templates used to configure default account mappings and settings for billback transactions between entities.
BillbackTemplateLine Represents individual line items in a billback template, defining the general ledger account mappings and department assignments for each billback entry.
BillingPriceList Represents billing price lists used to define pricing structures for items and services in contract and project billing.
BillingPriceListEntry Represents entries in a billing price list, defining the pricing type, item, tiering settings, and versioning for each priced item or service.
BillingPriceListEntryLine Represents individual pricing lines within a billing price list entry, defining start dates, flat amounts, included units, and variable rates.
BillingPriceListEntryLineTier Represents tiered pricing levels within a billing price list entry line, defining the beginning quantity and rate for each pricing tier.
BillingSchedule Represents billing schedules generated from contract lines, defining the planned billing dates and amounts for recurring revenue recognition.
BillingTemplate Represents billing templates that define the method and schedule for billing contract revenue, including step billing and milestone configurations.
BillLine Represents individual line items on accounts payable bill transactions, including general ledger account, amount, retainage, and tax details.
Bin Represents storage bins within warehouse locations, used to organize inventory at the most granular level of the warehouse hierarchy.
BinFace Represents bin face designations used to label and categorize the facing side of storage bins in warehouse locations.
BinSize Represents bin size classifications used to define the physical dimensions and capacity of storage bins in warehouse locations.
Book Represents accounting books used to record financial transactions, including primary, secondary, and tax books with their associated journals and consolidation settings.
Budget Represents financial budgets used to plan and track projected income and expenses across accounts, entities, and reporting periods.
ChangeRequest Represents change requests submitted against project contracts, including scope, schedule, cost, and approval tracking details.
ChangeRequestStatus Represents statuses used to classify and track the workflow state of change requests.
ChangeRequestType Represents types used to categorize and classify change requests in project management workflows.
CheckingAccount Represents checking accounts used for financial transactions, including ACH payment settings, bank file configurations, reconciliation details, and banking cloud connection information.
CheckRun Represents check run configurations used to define check stock, print settings, and sort order for printing accounts payable checks.
Class Represents user-defined classes used to segment and categorize transactions for reporting and analysis purposes.
ClassificationDepreciationRule Represents depreciation rules assigned to asset classifications, defining the depreciation method, rate, useful life, and posting rule for each classification.
CloudStorage Represents cloud storage configurations used to define external file storage destinations, including AWS S3 and HTTP storage settings.
CompanyPreference Represents company-wide preference settings, including accounting configuration, branding, security, localization, and session management options.
ComplianceDefinition Represents compliance definitions used to enforce documentation and lien waiver requirements on vendor payments in construction and project management workflows.
ComplianceRecord Represents compliance records tracking the receipt and status of compliance documents such as lien waivers and insurance certificates for vendor payments and projects.
ComplianceType Represents compliance types that define the specific document templates and sequence settings used within a compliance definition.
ConsolidationPreference Represents consolidation preference settings that control how multi-entity financial data is aggregated and reported.
Contact Manages contact records including customer and vendor contact information.
ContactTaxGroup Represents contact tax groups used to assign tax solutions to customers and vendors for tax calculation purposes.
Contract Represents contracts that define recurring billing and revenue recognition agreements with customers, including term, renewal, currency, and hold settings.
ContractLine Represents individual line items on contracts, defining the item, billing method, revenue recognition settings, renewal options, and schedule details for each contracted service or product.
ContractType Represents contract types used to categorize contracts and define default settings for billing and revenue recognition.
ContractUsage Represents usage records submitted against contract lines, capturing quantities consumed during a service period for usage-based billing and revenue recognition.
CostType Represents cost types used to categorize and track project costs, including accumulation type, GL account, standard cost type, and tax schedule associations.
CostTypeObservedPercentCompleted Represents observed percent-completed entries recorded against cost types, tracking progress measurements as of a specific date for project performance reporting.
CreditCardAccount Represents credit card accounts used for expense tracking and reconciliation, including card details, accounting settings, banking cloud connection information, and reconciliation configuration.
CreditCardTxn Represents credit card transactions, including transaction amounts, currency details, reconciliation state, reversal information, and tax solution associations.
CreditCardTxnTemplate Represents templates used to automate the entry of recurring credit card transactions, defining default payee, tax settings, and line item details.
Customer Represents customers, including billing and financial settings, account health, payment options, pricing, and contact list details.
CustomerEmailTemplate Represents email template assignments for customers, linking specific email templates to customers for use on particular transaction types.
CustomerGlGroup Represents GL groups assigned to customers for controlling the general ledger accounts used in accounts receivable transactions.
CustomerGroup Represents groups used to organize customers for reporting, restrictions, and bulk operations.
CustomerItemCrossReference Represents cross-reference mappings between internal items and customer-specific item identifiers, enabling lookup and translation of item names on customer transactions.
CustomerMessage Represents predefined messages that can be printed on customer invoices and statements.
CustomerRefund Represents refund transactions issued to customers, including payment method, currency amounts, exchange rate details, and reconciliation information.
EmailTemplate Represents email templates used to define the subject, body, recipients, sender settings, and logo options for automated email communications.
Employee Represents employees, including personal details, ACH payment settings, bank file configuration, position and type assignments, contact information, and expense defaults.
EmployeeExpense Represents employee expense reports, including reimbursement totals, non-reimbursable amounts, base payment details, and associated expense summary information.
EmployeeExpenseAdjustment Represents adjustment records for employee expenses, capturing corrected reimbursement totals, non-reimbursable amounts, and references to the originating employee expense.
EmployeeExpenseAdjustmentLine Represents individual line items on employee expense adjustments, capturing GL account allocations, expense types, payment types, amounts, and currency conversion details.
EmployeeExpenseLine Represents individual line items on employee expense reports, capturing GL account allocations, expense types, payment types, credit card transaction links, and currency conversion details.
EmployeeExpensePaymentType Represents payment types used on employee expense lines, defining whether the payment method is non-reimbursable and specifying the associated offset GL account.
EmployeeExpenseSummary Represents expense summary batches used to group and post employee expense reports and adjustments to the general ledger.
EmployeeExpenseType Represents expense types used to categorize employee expenses, including GL account assignments, offset GL account settings, Form 1099 configuration, and unit rate details.
EmployeeGroup Represents groups used to organize employees for reporting, restrictions, and bulk operations.
EmployeePosition Represents positions that can be assigned to employees to define their role classification within an organization.
EmployeeRate Represents compensation rate records for employees, capturing hourly and annual salary rates effective for a defined date range.
EmployeeType Represents employee types used to classify employees, including Form 1099 settings and parent type hierarchy.
Entity Represents entities in a multi-entity organization, including fiscal settings, tax configuration, inter-entity GL accounts, legal contact details, and associated customer and vendor records.
EvergreenTemplate Represents templates used to configure automatic renewal settings for contracts, including pricing markup options and recurrence timing relative to the renewal date.
ExchangeRate Represents currency exchange rate records that define conversion rates between two currencies for a given exchange rate type.
ExchangeRateLine Represents individual rate entries within an exchange rate record, defining the conversion rate and its effective start date.
ExchangeRateType Represents exchange rate types used to categorize and organize exchange rate records for currency conversion.
ExpenseTemplate Represents expense recognition templates used to define amortization methods, posting types, and recognition schedules for contract expenses.
Export Represents export operations used to retrieve data from the system in a specified file format based on a query.
File Represents files attached to records, including the file name, size, and binary data content.
FinancialInstitution Represents financial institutions connected to the system, grouping associated checking accounts, savings accounts, and credit cards.
Folder Represents attachment folders used to organize and store files and supporting documents for records.
FundsTransfer Represents funds transfer transactions between accounts, including transfer amounts, reversal references, and reconciliation state.
InteractiveCustomReport Represents interactive custom reports that can be created from existing reports or library templates, configured with a report type, audience, and module settings.
InterEntityAccountMapping Represents inter-entity account mapping configurations that define how GL accounts are mapped between entities for inter-entity transactions.
InterEntityAdvancedMap Represents advanced inter-entity account mapping rules that define payable and receivable GL accounts for specific source and target entity combinations.
InterEntityBasicMap Represents basic inter-entity account mapping rules that define payable and receivable GL accounts for a specific entity.
Invoice Represents accounts receivable invoices, including customer billing details, payment information, invoice totals, and associated summary and tax solution references.
InvoiceLine Represents individual line items on an invoice, capturing GL account allocations, account labels, transaction amounts, and payment information.
item Represents inventory and service items, including commercial attributes, contract defaults, measurement details, replenishment settings, and sales and purchasing configuration.
ItemCrossReference Represents item cross-reference records that map an item to alternate identifiers used by customers, vendors, or other items.
ItemGlGroup Represents item GL groups that define the default revenue recognition template and deferred revenue GL account used for items in a specific entity.
ItemGroup Represents groups used to organize items for reporting, restrictions, and bulk operations.
ItemTaxGroup Represents item tax groups used to assign tax rules to items for a specific tax solution.
ItemWarehouseInventory Represents inventory levels and replenishment settings for an item at a specific warehouse location, including quantity details, cost values, and bin assignments.
ItemWarehouseStandardCost Represents standard cost entries for an item at a specific warehouse, capturing the standard cost value and its effective start date.
ItemWarehouseVendor Represents vendor-specific purchasing information for an item at a specific warehouse, including pricing, lead time, and order quantity settings.
JointPayee Represents joint payees added to AP bills, specifying the name and print format for co-payees on payments.
Journal Represents general ledger journals used to categorize and control how journal entries are recorded and posted to a specific book.
JournalEntry Represents general ledger journal entries, including posting details, reversal references, transaction source information, and associated line items.
JournalEntryLine Represents individual line items on a journal entry, capturing GL account allocations, transaction amounts, currency details, and reconciliation information.
JournalEntryTemplate Represents journal entry templates used to define reusable journal entry structures, including GL journal, tax schedule, and entity associations.
KeyValueMap Represents key-value map entries used to store typed configuration or reference data as flexible name-value pairs.
KitComponent Represents component items that make up a kit, including the component item details, quantity, revenue percentage, and deferral and delivery status settings.
LaborClass Represents labor classes used to categorize and classify workers for payroll and project cost tracking.
LaborShift Represents labor shifts used to define named work shift periods for time tracking and payroll purposes.
LaborUnion Represents labor unions used to associate workers with union agreements for payroll and project cost tracking.
LoanAccount Represents loan accounts used to track lending arrangements, including origination details, repayment schedule, interest rate, and outstanding balance information.
LoanCategory Represents loan categories used to classify loan accounts and define the associated document sequence for loan transactions.
LoanFeeType Represents loan fee types used to define named fee categories, their associated GL accounts, and the items used when applying fees to loan accounts.
LoanInterestRate Represents loan interest rate configurations that define the amortization type and interest rate entries used for calculating loan payments.
LoanInterestRateEntry Represents individual interest rate entries within a loan interest rate, capturing the rate value, effective start date, and supporting notes.
LoanInvoiceLineOrder Represents the display order of invoice line types for a loan type, defining how principal, interest, and fee lines appear on loan invoices.
LoanSchedule Represents repayment schedules for loan accounts, tracking the associated loan account and the current schedule status.
LoanScheduleEntry Represents individual entries within a loan repayment schedule, capturing the scheduled date, payment breakdown, and pre- and post-payment balances.
LoanType Represents loan types that define the amortization method, interest calculation approach, and associated items used for creating and processing loan accounts.
Location Represents locations used as dimensions for financial reporting, including parent-child hierarchies, manager assignments, and date range settings.
LocationGroup Represents groups used to organize locations for reporting, restrictions, and bulk operations.
ManualDeposit Represents manual deposit transactions used to record cash receipts not generated from standard payment processing, including payment totals, customer details, and deposit summary references.
MeaCategory Represents Multiple Element Arrangement (MEA) categories used to classify items for fair value pricing and revenue recognition purposes.
MeaPriceList Represents Multiple Element Arrangement (MEA) price lists used to define fair value prices for items in revenue recognition arrangements.
MeaPriceListEntry Represents entries within a Multiple Element Arrangement (MEA) price list, defining fair value pricing rules, price types, and currency settings for specific items.
MeaPriceListEntryLine Represents individual price range lines within a Multiple Element Arrangement (MEA) price list entry, capturing the price amount or percentage, markup and markdown rules, and applicable date range.
MultiEntityPreference Represents multi-entity configuration preferences that control inter-entity transaction behavior, account mapping plans, currency settings, and entity-level restrictions.
Operation Represents system operations used to track scheduled or queued actions, including associated user, entity, module, and status information.
OrderEntryTaxDetail Represents tax details used in order entry transactions, defining tax rates, tax limits, GL account assignments, and tax authority associations.
OrderEntryTaxSchedule Represents tax schedules used in order entry transactions to group tax details by effective date and tax solution.
OtherReceipt Represents other receipt transactions used to record miscellaneous cash receipts, including payer details, payment method, tax solution, currency, and deposit references.
OverrideAccount Represents override account entries used to substitute default GL accounts for consolidation books, including exchange rate and rate type settings.
OwnershipStructure Represents ownership structures used to define consolidation relationships between entities, including accounting method, elimination settings, and equity method book assignments.
Payment Represents vendor payment transactions, including payment method, currency totals, joint payee details, payment provider references, and associated summary information.
PaymentProviderBankAccount Represents bank account configurations associated with a payment provider, including account details, check start numbers, remittance email, and enrollment state.
PaymentSummary Represents payment summary batches used to group and post vendor payments to the general ledger, including bank account details, entity references, and posting controls.
PositionSkill Represents position skills used to define named competency categories for staffing and project resource assignments.
PriceList Represents price lists used to define item pricing for sales or purchasing transactions within a specified effective date range.
PriceListEntry Represents individual entries within a price list, defining item pricing by value type, quantity range, effective dates, and optional employee or product line filters.
PriceSchedule Represents price schedules that associate a price list with a customer or group and apply a discount percentage for pricing calculations.
ProductLine Represents product lines used to group related items for sales, purchasing, and reporting purposes.
project Represents projects used to track work, billing, and costs, including budget details, billing type, customer and department assignments, grant information, and schedule and scope details.
ProjectBillingTemplate Represents project billing templates that define the billing method, calculation basis, and milestone schedules used to generate project invoices.
ProjectEstimate Represents project estimates used to forecast costs and budgets for a project, including estimate type, posting details, customer and location assignments, and associated estimate lines.
ProjectEstimateType Represents project estimate types used to categorize and classify estimates by workflow type and estimate category.
ProjectGroup Represents project groups used to organize and categorize projects, including group type, dimension structure settings, and member filter criteria.
ProjectResource Represents project resources that assign employees or items to a project, including pricing methods, billing rates, and start date details.
ProjectStatus Represents project statuses used to define workflow stages for projects, including entry restrictions for expenses, timesheets, purchasing, and invoice generation.
ProjectType Represents project types used to classify projects into hierarchical categories for reporting and management purposes.
PurchasingPreference Represents purchasing module preferences, including approval workflows, automation settings, tax configuration, price and discount options, and document conversion controls.
PurchasingTaxDetail Represents tax details used in purchasing transactions, defining tax rates, tax limits, GL account assignments, and tax authority associations.
PurchasingTaxSchedule Represents tax schedules used in purchasing transactions to group tax details by effective date and tax solution.
RecurringBill Represents recurring vendor bills that are automatically generated on a schedule, including vendor details, currency, tax solution, payment terms, and execution history.
RecurringBillLine Represents individual line items on a recurring bill, capturing GL account allocations, currency amounts, allocation details, and associated tax entries.
ReportAudience Represents report audiences used to define the groups or entities that have access to specific reports.
ReportingPeriod Represents reporting periods used to define fiscal date ranges for financial reporting, including period type, budget eligibility, and column header labels.
ReportType Represents report types used to categorize and classify stored reports by their purpose or content area.
RevenueRecognitionTemplate Represents revenue recognition templates that define the recognition method, calculation basis, posting schedule, and milestone source used to generate revenue schedules.
RevenueSchedule Represents revenue schedules generated from contract lines, tracking the recognition status, cancellation date, and associated journal and schedule lines.
RevenueTemplate Represents revenue templates used to define the recognition method, schedule period, posting type, and adjustment options for revenue schedules.
Role Represents user roles used to define access permissions and assign groups of privileges to users or user groups.
RolePermissionAssignment Represents the assignments of permissions to roles, defining the specific access rights granted to a role for a given permission.
Row Represents rows used to define named entries within custom report structures or data grids.
SavingsAccount Represents savings accounts used for financial management, including bank account details, banking cloud connection status, reconciliation settings, entity and location assignments, and restriction configurations.
Schedule Represents schedules that define the execution frequency, start and end dates, and repeat configuration for automated recurring operations.
ScheduledOperation Represents scheduled operations that link a specific operation to a schedule, defining when and how the operation is executed.
SecondaryVendor Represents secondary vendors associated with purchasing documents, including lien waiver generation settings and vendor print name details.
Setup Represents fixed asset module setup configuration, including enabled modules, journal assignments, GL account settings, and posting rules.
SetupPostingRule Represents posting rules defined within a fixed asset setup, specifying the depreciation convention, journal assignment, salvage value usage, and useful life units.
ShippingMethod Represents shipping methods used to define delivery options, including estimated transit time and entity assignments.
StandardCostType Represents standard cost types used to categorize project and task costs, including GL account assignments, accumulation type, and item associations.
StandardTask Represents standard tasks used as reusable templates for project tasks, including billable and milestone settings, time type, WBS code, and associated standard cost types.
StockableKitDocument Represents stockable kit inventory documents, capturing document details, build state, exchange rates, journal entry references, and associated line items and history.
StoredReport Represents stored reports saved by users, including report type, title, module, and cloud store status.
Task Represents project tasks that define the work breakdown structure for a project, including planned and actual dates, duration tracking, billable settings, and associated resources.
TaskGroup Represents task groups used to organize and categorize tasks, including group type, dimension structure settings, and member filter criteria.
TaxAuthority Represents tax authorities used to define the governmental bodies responsible for collecting taxes, including hierarchical parent relationships and associated vendor identifiers.
TaxReturn Represents tax returns submitted to tax authorities, including submission period, reporting entity, current workflow step, and associated tax solution details.
TaxSolution Represents tax solutions that define the tax calculation method, solution type, GL account assignments, and multiline tax settings for a tax framework.
Term Represents payment terms that define due date rules, early payment discount conditions, and late payment penalty settings.
Territory Represents sales territories used to organize and assign geographic or market segments to managers, including hierarchical parent relationships.
TerritoryGroup Represents territory groups used to organize and categorize territories, including entity assignments and group member details.
Timesheet Represents employee timesheets that record weekly or periodic time worked, including employee contact details, date ranges, posting configuration, and associated timesheet lines.
TimesheetLine Represents individual lines within a timesheet, capturing hours worked, billable status, labor class and shift assignments, external payroll details, and time type references.
Total Represents totals used in order entry or purchasing documents to define subtotal line items, including update type and current status.
TransferHistory Represents the history of fixed asset transfers, capturing the transfer date, asset details, allocation, and associated journal entries.
UnitOfMeasure Represents individual units of measure within a unit of measure group, including conversion factor, decimal precision, and hierarchical parent relationships.
UnitOfMeasureGroup Represents groups of related units of measure, including system-generated status and associated member units.
User Represents system users, including contact details, entity access settings, password configuration, user type, and role and territory assignments.
UserDefinedBook Represents user-defined books used for alternative accounting reporting, including management reporting designation and current status.
UserGroup Represents groups of users used to collectively assign roles and permissions, including an optional description and associated role memberships.
UserView Represents custom views created by users to define filtered or structured data perspectives, including query definitions, visibility settings, and associated object references.
Vendor Represents vendors used in accounts payable transactions, including payment settings, ACH configuration, GL account assignments, and contact and billing details.
VendorAccountNumber Represents vendor account numbers assigned per location, linking vendors to their location-specific account identifiers.
VendorContact Represents contacts associated with vendors, linking contact records to vendors with an optional category classification.
VendorEmailTemplate Represents email templates assigned to vendors for specific transaction definitions, linking email templates to vendor and transaction contexts.
VendorGlGroup Represents vendor GL groups used to organize vendors for general ledger reporting, including entity assignments and current status.
VendorGroup Represents groups used to organize and categorize vendors, including group type, entity assignments, and member filter criteria.
VendorPaymentProvider Represents payment provider enrollments for vendors, linking vendors to payment providers and preferred payment methods with enrollment state tracking.
VendorType Represents vendor types used to classify vendors, including form 1099 reporting settings, hierarchical parent relationships, and entity assignments.
Warehouse Represents warehouses used for inventory storage, including entity and location assignments, replenishment settings, and parent warehouse relationships.
WarehouseTransfer Represents warehouse transfer transactions that record the movement of inventory between warehouses, including transfer dates, exchange rate details, and associated inventory documents.
WipForecastDetail Represents detailed forecast data within a WIP period for a project task and cost type, capturing cost estimates, variances, project manager forecasts, and prior period comparisons.
WipPeriod Represents WIP reporting periods used to capture project cost and forecast data at defined intervals, including period dates, fiscal year, state, and associated WIP projects.
WipProject Represents WIP project records within a WIP period, capturing financial metrics such as contract values, cost estimates, earned revenue, billings, and project manager forecast data.
WipProjectManagerForecast Represents project manager forecast entries within a WIP period, capturing cost estimates, completion percentages, and forecast variances by project, task, and cost type.
WipSetup Represents the WIP configuration settings, including period automation, cost breakdown level, reconciliation method, and associated posting journal and setup accounts.
WipSetupAccount Represents GL accounts configured for WIP reporting, associating each account with a WIP account type and a parent WIP setup record.
WorkOrder Represents work orders used to track service requests and field work, including customer and project associations, external billing details, and work order type, state, and problem code classifications.
WorkOrderCallType Represents call types used to classify work orders, including hierarchical parent relationships and current status.
WorkOrderProblemCode Represents problem codes used to classify the nature of issues reported on work orders, including hierarchical parent relationships and current status.
WorkOrderState Represents states used to track the lifecycle stage of work orders, including hierarchical parent relationships and current status.
WorkOrderType Represents types used to categorize work orders, including hierarchical parent relationships and current status.
Zone Represents zones used to define geographic or logical groupings for assignment and reporting purposes.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655