ODBC Driver for NetSuite

Build 25.0.9434

Department

Stores department classifications for financial reporting and organizational structure in NetSuite.

Columns

Name Type ReadOnly Description
InternalId [KEY] String True

A unique internal identifier assigned by NetSuite to track this department within the system.

ClassTranslationList_ReplaceAll Boolean False

Indicates whether the existing class translations for this department should be replaced with the provided list.

ExternalId String False

A unique identifier for this department in an external system, used for integrations and data synchronization.

IncludeChildren Boolean False

Specifies whether this department includes data from its sub-departments in reports and filters.

IsInactive Boolean False

Indicates whether this department is currently inactive, preventing its selection in transactions and reports.

Name String False

The name of the department, used for classification and reporting purposes within NetSuite.

Parent_ExternalId String False

The unique external identifier of the parent department, linking this department to a higher-level category in an external system.

Parent_InternalId String False

The internal NetSuite identifier of the parent department, defining hierarchical relationships within the organization.

Parent_Name String False

The name of the parent department, providing a clear hierarchical reference for reporting and categorization.

Parent_Type String False

The classification type of the parent department, which helps define the structure and purpose of departmental relationships.

The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434