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. |