Power BI Connector for NetSuite

Build 25.0.9454

Solution

Stores knowledge base solutions for customer support, troubleshooting, and self-service portals in NetSuite.

Columns

Name Type ReadOnly Description
InternalId [KEY] String True

A system-generated unique identifier for the solution, used for internal tracking and reference within NetSuite.

Assigned_ExternalId String False

An externally assigned identifier for the user or entity assigned to this solution, referenced in external integrations.

Assigned_InternalId String False

A system-generated identifier for the assigned user or entity managing this solution, ensuring accurate record-keeping.

Assigned_Name String False

The name of the user or entity assigned to manage or maintain this solution within the system.

Assigned_Type String False

The type of assignment for this solution, such as user, department, or support role.

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.

CreatedDate Datetime False

The date and time when this solution was originally created, used for audit trails and tracking updates.

CustomForm_ExternalId String False

An externally assigned identifier for the custom form used to manage this solution, referenced in third-party integrations.

CustomForm_InternalId String False

A system-generated identifier for the custom form applied to this solution, ensuring consistency in data entry.

CustomForm_Name String False

The name of the custom form assigned to this solution, defining the layout and structure of its fields.

CustomForm_Type String False

The type of custom form used, specifying whether it is a standard form or a specialized entry format.

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.

DisplayOnline Boolean False

A boolean flag indicating whether this solution is available online for self-service access by customers or employees.

ExternalId String False

An externally assigned identifier for this solution, used in integrations and external reporting.

IsInactive Boolean False

A boolean flag indicating whether this solution is inactive ('true') or active ('false') within NetSuite.

LastModifiedDate Datetime False

The date and time when this solution was last modified, useful for tracking updates and maintaining version control.

LongDescription String False

A detailed description of the solution, providing in-depth explanations and troubleshooting steps.

Message String False

A brief message or summary associated with this solution, typically used in notifications or alerts.

SolutionCode String False

A unique code assigned to this solution, useful for categorization, searching, and quick identification.

SolutionsList_ReplaceAll Boolean False

A boolean flag indicating whether the list of associated solutions should be fully replaced when updating records.

Status String False

The current status of this solution, such as active, pending review, or deprecated.

The allowed values are _approved, _unapproved.

Title String False

The title of the solution, displayed in search results and category listings for easy identification.

TopicsList_ReplaceAll Boolean False

A boolean flag indicating whether the list of associated topics should be fully replaced during updates.

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