Tableau Connector for NetSuite

Build 25.0.9434

InventoryNumber

Manages serialized inventory numbers for tracking individual stock items in NetSuite.

Columns

Name Type ReadOnly Description
InternalId [KEY] String True

A unique internal identifier assigned by NetSuite to track this inventory number record within the system.

ExpirationDate Datetime False

The expiration date associated with this inventory number, commonly used for perishable goods, serialized inventory, or compliance tracking.

ExternalId String False

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

InventoryNumber String False

The unique serial or lot number assigned to this inventory item, used for tracking individual units across warehouses, sales, and returns.

Item_ExternalId String False

The unique external identifier for the item associated with this inventory number, used for integrations with external inventory management systems.

Item_InternalId String False

The internal NetSuite identifier for the item linked to this inventory number, allowing precise tracking within the system.

Item_Name String False

The name of the item associated with this inventory number, such as a product or component name.

Item_Type String False

The classification of the item, indicating whether it is a lot-numbered item, serialized item, or another inventory type.

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.

LocationsList_ReplaceAll Boolean False

Indicates whether all existing location records associated with this inventory number should be replaced with the provided list, ensuring accurate inventory tracking.

Memo String False

A free-text field for entering additional notes or comments about this inventory number, such as purchase details, inspection notes, or storage conditions.

Status String False

The current status of the inventory number, such as 'Available,' 'Reserved,' 'Expired,' or 'Damaged,' helping manage stock availability.

Units String False

The unit of measure associated with this inventory number, such as 'Each,' 'Box,' or 'Pallet,' defining quantity tracking.

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