Power BI Connector for NetSuite

Build 25.0.9454

lotnumberedassemblyitem

Tracks assembly items that use lot numbers for inventory management, ensuring traceability and compliance.

Columns

Name Type References Description
alternatedemandsourceitem String Alternative demand source item used in case of shortages.
assetaccount String Asset account associated with this item.
atpmethod String Available-to-promise method used for inventory calculations.
auctionquantity String Quantity available for auction listings.
auctiontype String Type of auction listing (such as fixed price, highest bid).
autoleadtime Boolean Indicates whether lead time is automatically calculated.
autopreferredstocklevel Boolean Specifies whether the preferred stock level is automatically determined.
autoreorderpoint Boolean Indicates whether the reorder point is automatically calculated.
availabletopartners Boolean Specifies whether the item is available to partners.
averagecost Decimal Average cost of the item based on historical purchases.
billexchratevarianceacct String Account used for tracking bill exchange rate variances.
billingschedule String Billing schedule applied to this item.
billpricevarianceacct String Account used for tracking bill price variances.
billqtyvarianceacct String Account used for tracking bill quantity variances.
buildentireassembly Boolean Indicates whether the entire assembly must be built at once.
buildtime Double Time required to build the assembly.
buildtimelotsize Double Lot size used when calculating build time.
buyitnowprice Decimal Buy-it-now price for auction listings.
class String Classification category for tracking and reporting purposes.
cogsaccount String Cost of Goods Sold (COGS) account associated with this item.
conditionenabled String Indicates whether condition-based selling is enabled.
conditionhelpurl String URL for additional information about item conditions.
consumptionunit String Unit of measure for item consumption.
copydescription Boolean Indicates whether the description is copied from the parent item.
cost Decimal Standard cost of the item.
costcategory String Cost category associated with this item.
costestimate Decimal Estimated cost of the item.
costestimatetype String Method used for cost estimation (such as standard, average).
costingmethod String Costing method applied to this item (such as FIFO, LIFO, Average).
costingmethoddisplay String Human-readable display of the costing method.
costunits String Unit of measure for cost calculations.
countryofmanufacture String Country where the item is manufactured.
createddate Datetime Timestamp indicating when the item record was created.
createrevenueplanson String Defines when revenue plans are created for this item.
currency String Currency used for transactions involving this item.
customform String Custom form template applied to this item.
custreturnvarianceaccount String Account used for tracking variances in customer returns.
defaultrevision String Default revision assigned to this item.
deferredrevenueaccount String Account used for deferred revenue recognition.
deferrevrec Boolean Indicates whether revenue recognition is deferred.
demandmodifier String Modifier applied to demand calculations.
demandtimefence Integer Time fence (in days) for demand planning.
department String Department associated with this item.
description String Detailed description of the item.
directrevenueposting Boolean Indicates whether revenue is posted directly without deferral.
displayinebaystore Boolean Specifies whether the item is displayed in the eBay store.
displayname String Public-facing name of the item.
distributioncategory String Distribution category assigned to this item.
distributionnetwork String Distribution network where the item is available.
dontshowprice Boolean Indicates whether the item price is hidden in the store.
dropshipexpenseaccount String Expense account associated with drop-ship orders for this item.
ebayhandlingtime String Handling time before the item is shipped on eBay.
ebayintlinsurancefee Decimal Fee for international shipping insurance on eBay.
ebayintlpackagehandlingfee Decimal Handling fee for international shipments on eBay.
ebayintlshipinsurance String Specifies international shipping insurance options on eBay.
ebayintlshippingitem1 String First international shipping method available on eBay.
ebayintlshippingitem2 String Second international shipping method available on eBay.
ebayintlshippingitem3 String Third international shipping method available on eBay.
ebayisintlcalculatedrate String Indicates whether international shipping rates are calculated automatically on eBay.
ebayisirregularpackage Boolean Specifies whether the item is considered an irregular package for eBay shipping.
ebayitemdescription String Detailed item description for eBay listings.
ebayitemlocdisplay String Specifies how the item location is displayed on eBay.
ebayitemloczipcode String Zip code of the item’s location for eBay listings.
ebayitemlots Integer Number of lots available for the eBay listing.
ebayitemsubtitle String Subtitle displayed for the eBay listing.
ebayitemtitle String Title of the item listing on eBay.
ebayitemweightamt String Weight of the item for eBay shipping calculations.
ebaylayout String Layout template applied to the eBay listing.
ebaypackagetype String Type of packaging used for eBay shipments.
ebaypagecounter String Counter tracking the number of page views on eBay.
ebayrelistingoption String Relisting option selected for the eBay listing.
ebaytheme String Theme used for displaying the item on eBay.
ebaythemegroup String Theme group applied to the eBay listing.
effectivebomcontrol String Indicates the bill of materials (BOM) control method used.
endauctionswhenoutofstock Boolean Specifies whether auctions automatically end when the item is out of stock.
enforceminqtyinternally Boolean Indicates whether a minimum quantity is enforced internally for sales.
excludefromsitemap Boolean Specifies whether the item should be excluded from the sitemap for SEO.
externalid String External identifier used for integrations with other systems.
featureddescription String Highlighted description used for promotions and featured listings.
fixedbuildtime Double Fixed build time required for assembling this item.
froogleproductfeed String Category or group for submitting the item to Google Shopping (formerly Froogle).
futurehorizon String Time horizon used for future demand forecasting.
gainlossaccount String Account used for tracking gains or losses related to this item.
gallery Boolean Indicates whether the item is featured in a gallery view.
galleryfeatured Boolean Specifies whether the item is highlighted as a featured gallery item.
gifttypeexpressship Boolean Indicates whether express shipping is available for gift orders.
gifttypegiftwrap Boolean Specifies whether gift-wrapping options are available.
gifttypeshiptorecipient Boolean Indicates whether the item can be shipped directly to the recipient as a gift.
handlingcost Decimal Additional handling cost applied to the item.
handlingcostunits String Unit of measure used for handling cost calculations.
handlinggroup String Group to which this item belongs for handling fee calculations.
imagesgroup String Group of images associated with the item.
imageslocation String Location or URL where images of the item are stored.
includechildren Boolean Specifies whether child items are included in the listing.
incomeaccount String Account used to record revenue from item sales.
intercocogsaccount String Intercompany Cost of Goods Sold (COGS) account.
intercoincomeaccount String Intercompany income account associated with this item.
internalid Integer Unique internal identifier assigned to the item.
iscalculatedrate String Indicates whether the shipping rate is calculated dynamically.
isdonationitem Boolean Specifies whether the item is designated as a donation item.
isdropshipitem Boolean Indicates whether the item is eligible for drop shipping.
isgcocompliant Boolean Specifies whether the item meets Google Checkout compliance standards.
isinactive Boolean Indicates whether the item is inactive in the system.
isonline Boolean Specifies whether the item is available for sale online.
isphantom Boolean Indicates whether the item is a phantom assembly.
isspecialorderitem Boolean Specifies whether the item is only available via special order.
isspecialworkorderitem Boolean Indicates whether the item is a special work order item.
isstorepickupallowed Boolean Specifies whether the item can be picked up in-store.
issueproduct String Product issued when this item is sold.
itemcondition String Condition of the item (such as new, refurbished, used).
itemhandlingfee Decimal Handling fee applied per unit of this item.
itemid String Unique identifier for the item within the system.
iteminsurancefee Decimal Fee for shipping insurance on this item.
itemnumberoptions String Available numbering options for this item.
itemoptions String Available customization or configuration options for the item.
itemprocessfamily String Process family classification for manufacturing workflows.
itemprocessgroup String Process group classification for production planning.
itemrevenuecategory String Revenue category associated with this item for financial reporting.
itemshipinsurance String Indicates whether shipping insurance is available for this item.
itemtype String Type of item (such as inventory, non-inventory, service, kit).
lastmodifieddate Datetime Timestamp indicating the last modification made to the item record.
lastpurchaseprice Decimal Last recorded purchase price of the item.
leadtime Integer Lead time required for replenishment of this item.
listimmediate String Specifies whether the item should be listed immediately after creation.
listingduration String Duration for which the item listing is active.
listingstartdate Date Date when the item listing becomes active.
listingstarttime String Time when the item listing becomes active.
location String Location where the item is stored or fulfilled from.
manufacturer String Name of the manufacturer of the item.
manufactureraddr1 String First line of the manufacturer's address.
manufacturercity String City where the manufacturer is located.
manufacturerstate String State or region where the manufacturer is located.
manufacturertariff String Tariff code applicable to this item for customs and taxation.
manufacturertaxid String Tax identification number of the manufacturer.
manufacturerzip String Postal code of the manufacturer's location.
matchbilltoreceipt Boolean Specifies whether bills should be matched to receipts for this item.
matrixitemnametemplate String Template used for naming matrix items.
maxdonationamount Decimal Maximum amount allowed for donation purchases of this item.
maximumquantity String Maximum quantity allowed per purchase or transaction.
metataghtml String Meta tag HTML content for SEO purposes.
minimumquantity String Minimum quantity required per purchase.
minimumquantityunits String Unit of measure for the minimum quantity.
mpn String Manufacturer part number (MPN) assigned to this item.
multmanufactureaddr Boolean Specifies whether multiple manufacturing addresses are associated with this item.
nextagcategory String Category assigned to the item for Nextag product listings.
nextagproductfeed String Specifies whether the item is included in the Nextag product feed.
nopricemessage String Message displayed when the item price is not shown.
numactivelistings Integer Number of active listings available for this item.
numcurrentlylisted Integer Number of units currently listed for sale.
offersupport Boolean Indicates whether customer support is offered for this item.
outofstockbehavior String Defines how the item behaves when out of stock (such as allow backorders).
outofstockmessage String Message displayed when the item is out of stock.
overallquantitypricingtype String Pricing type based on overall quantity purchased.
packageheight String Height of the package for shipping purposes.
packagelength String Length of the package for shipping purposes.
packagewidth String Width of the package for shipping purposes.
pagetitle String Title of the item's product page for SEO and display.
parent String Parent item or category associated with this item.
planningitemcategory String Category used for planning inventory and production.
preferencecriterion String Preference criteria for recommending this item.
preferredlocation String Preferred location for storing or fulfilling this item.
preferredstockleveldays Double Number of days of stock to maintain as preferred inventory.
pricinggroup String Pricing group to which the item belongs.
primarycatdisplayname String Display name of the item's primary category.
primarycategory Integer Unique identifier of the primary category assigned to this item.
printitems Boolean Indicates whether this item is printable.
prodpricevarianceacct String Account used to track production price variances.
prodqtyvarianceacct String Account used to track production quantity variances.
producer Boolean Specifies whether the item is considered a producer-type item.
productfeed String Specifies whether the item is included in product feed exports.
purchasedescription String Description used for purchase transactions.
purchaseorderamount String Total amount of purchase orders for this item.
purchaseorderquantity String Total quantity of purchase orders for this item.
purchaseorderquantitydiff String Difference in purchase order quantities versus expectations.
purchasepricevarianceacct String Account used for tracking purchase price variances.
purchaseunit String Unit of measure used for purchase transactions.
quantitypricingschedule String Pricing schedule based on quantity breaks.
quantityreorderunits String Unit of measure for reorder quantities.
receiptamount String Total amount of received shipments for this item.
receiptquantity String Total quantity received for this item.
receiptquantitydiff String Difference in received quantity versus expected quantity.
refundgivenas String Defines how refunds are issued for this item (such as store credit, cash).
relateditemsdescription String Description of related items that may be purchased together.
reordermultiple String Multiple quantity used when reordering this item.
rescheduleindays Integer Number of days for inbound rescheduling of supply orders.
rescheduleoutdays Integer Number of days for outbound rescheduling of demand orders.
reserveprice Decimal Minimum price set for auction listings.
returnpolicy String Return policy associated with this item.
returnpolicydetails String Detailed terms and conditions of the return policy.
returnshippingpaidby String Indicates who is responsible for return shipping costs (such as buyer, seller).
returnswithin String Timeframe within which returns are accepted.
revenueallocationgroup String Group used for revenue allocation purposes.
revenuerecognitionrule String Revenue recognition rule applied to this item.
revrecforecastrule String Forecasting rule used for revenue recognition.
revrecschedule String Revenue recognition schedule assigned to this item.
rotationtype String Inventory rotation method used (such as FIFO, LIFO).
safetystocklevel Double Minimum quantity to keep in stock to prevent shortages.
safetystockleveldays Integer Number of days of stock to maintain as safety stock.
safetystocklevelunits String Unit of measure for safety stock levels.
saleunit String Unit of measure used for sales transactions.
schedulebcode String Schedule B code used for export classification.
schedulebnumber String Export classification number from the Schedule B list.
schedulebquantity String Unit of measure for the Schedule B classification.
scrapacct String Account used to record scrapped inventory.
searchkeywords String Search keywords associated with the item for SEO and internal search.
seasonaldemand Boolean Indicates whether the item has seasonal demand fluctuations.
secondarycatdisplayname String Display name of the item's secondary category.
secondarycategory Integer Unique identifier of the secondary category assigned to this item.
sellonebay Boolean Indicates whether the item is listed for sale on eBay.
shipasia Boolean Specifies whether the item can be shipped to Asia.
shipaustralia Boolean Specifies whether the item can be shipped to Australia.
shipcanada Boolean Specifies whether the item can be shipped to Canada.
shipeurope Boolean Specifies whether the item can be shipped to Europe.
shipgermany Boolean Specifies whether the item can be shipped to Germany.
shipindividually Boolean Indicates whether the item must be shipped separately.
shipjapan Boolean Specifies whether the item can be shipped to Japan.
shipmexico Boolean Specifies whether the item can be shipped to Mexico.
shipnorthsouthamerica Boolean Specifies whether the item can be shipped to North and South America.
shippackage String Package type used when shipping this item.
shippingcost Decimal Cost of shipping the item.
shippingcostunits String Unit of measure used for shipping cost calculations.
shippingdomesticmethodsgroup String Group of domestic shipping methods available for this item.
shippingdomgroup String Domestic shipping group assigned to the item.
shippingintlgroup String International shipping group assigned to the item.
shippingintlgroup1 String First group of international shipping methods available.
shippingintlgroup2 String Second group of international shipping methods available.
shippingintlgroup3 String Third group of international shipping methods available.
shippingitem1 String First shipping method available for this item.
shippingitem2 String Second shipping method available for this item.
shippingitem3 String Third shipping method available for this item.
shippinglocationsgroup String Group of locations where the item can be shipped.
shippingpackaginggroup String Group of packaging options available for shipping.
shippingrate1 Decimal First shipping rate tier for this item.
shippingrate2 Decimal Second shipping rate tier for this item.
shippingrate3 Decimal Third shipping rate tier for this item.
shipuk Boolean Specifies whether the item can be shipped to the United Kingdom.
shipworldwide Boolean Indicates whether the item can be shipped globally.
shoppingdotcomcategory String Category assigned for Shopping.com product listings.
shoppingproductfeed String Specifies whether the item is included in the Shopping.com product feed.
shopzillacategoryid Integer Unique category identifier for Shopzilla product listings.
shopzillaproductfeed String Specifies whether the item is included in the Shopzilla product feed.
showasgift Boolean Indicates whether the item can be purchased as a gift.
showdefaultdonationamount Boolean Specifies whether the default donation amount should be displayed.
sitemappriority String Priority level for the item in the website sitemap.
softdescriptor String Custom soft descriptor used for transaction processing.
standardimages String Standard image set associated with the item.
startingprice Decimal Starting bid price for auction listings.
stockdescription String Description of the item's stock status or availability.
stockunit String Unit of measure used for stock tracking.
storecatdisplayname String Display name of the item's primary store category.
storecatdisplayname2 String Display name of the item's secondary store category.
storecategory Integer Unique identifier for the primary store category.
storecategory2 Integer Unique identifier for the secondary store category.
storedescription String Description of the item as it appears in the online store.
storedetaileddescription String Detailed description used in the store listing.
storedisplayimage String URL or path to the main display image for the store listing.
storedisplayname String Item name as displayed in the store.
storedisplaythumbnail String URL or path to the store listing thumbnail image.
storeitemtemplate String Template applied to the store listing.
subsidiary String Subsidiary associated with this item.
supersizeimages Boolean Specifies whether larger images are available for the item.
supplyreplenishmentmethod String Method used for replenishing inventory supply.
supplytimefence Integer Number of days within which supply changes are restricted.
taxable Boolean Indicates whether the item is subject to sales tax.
taxschedule String Tax schedule applied to the item for tax calculations.
templatesgroup String Group of templates available for the item listing.
totalvalue Decimal Total inventory value of the item.
tracklandedcost Boolean Indicates whether landed cost tracking is enabled for this item.
transferprice Decimal Price used for intercompany transfers of this item.
transferpriceunits String Unit of measure used for transfer pricing calculations.
unbuildvarianceaccount String Account used to track variances when unbuilding assemblies.
unitstype String Unit type associated with this item.
upccode String Universal Product Code (UPC) assigned to the item.
urlcomponent String SEO-friendly URL component for the item page.
usebins Boolean Indicates whether bin management is enabled for this item.
usemarginalrates Boolean Indicates whether marginal tax rates apply to this item.
vendorname String Name of the preferred vendor for this item.
vendreturnvarianceaccount String Account used to track variances in vendor returns.
vsoedeferral String Specifies whether revenue deferral applies under VSOE accounting.
vsoedelivered Boolean Indicates whether the item is marked as delivered under VSOE.
vsoepermitdiscount String Specifies whether discounts are permitted under VSOE accounting rules.
vsoeprice Decimal Price used for VSOE compliance calculations.
vsoesopgroup String Standard operating procedure group used for VSOE compliance.
weight Double Weight of the item for shipping calculations.
weightunit String Unit of measurement for the item's weight.
weightunits String Specific units used to measure weight.
willship String Indicates the regions or countries where the item can be shipped.
wipacct String Work-in-progress (WIP) account used for tracking production costs.
wipvarianceacct String Account used to track variances in WIP inventory.
yahooproductfeed String Specifies whether the item is included in the Yahoo product feed.

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