ODBC Driver for NetSuite

Build 25.0.9434

ItemRevision

Manages revisions of inventory items, tracking changes in specifications or configurations in NetSuite.

Columns

Name Type ReadOnly Description
InternalId [KEY] String True

A unique identifier assigned by NetSuite to track this specific item revision.

EffectiveDate Datetime False

The date when this item revision becomes active and can be used in transactions or manufacturing processes.

ExternalId String False

A unique identifier for this item revision in external systems, facilitating integrations and cross-platform tracking.

Inactive Boolean False

Indicates whether this item revision is inactive, preventing it from being used in new transactions while maintaining historical records.

Item_ExternalId String False

The external identifier of the item associated with this revision, useful for integrations and data synchronization.

Item_InternalId String False

The internal identifier of the item that this revision applies to, ensuring accurate tracking within NetSuite.

Item_Name String False

The name of the item for which this revision is created, providing easy reference for users.

Item_Type String False

The classification of the item being revised, such as 'Inventory Item,' 'Assembly Item,' or 'Non-Inventory Item.'

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.

Memo String False

A free-text field for additional notes or context related to this item revision, such as engineering changes or manufacturing updates.

Name String False

The name or version label of this item revision, often indicating a version number (for example, 'Rev A' or 'V2.0').

ObsoleteDate Datetime False

The date when this item revision is considered obsolete and should no longer be used in active processes.

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