Power BI Connector for NetSuite

Build 25.0.9454

serviceitem

Defines general service items used for billing non-physical services.

Columns

Name Type References Description
amortizationperiod Integer The number of accounting periods over which the cost of the service item is amortized.
amortizationtemplate String The predefined amortization schedule applied to the service item for revenue recognition purposes.
auctionquantity String The quantity of this service item listed in an auction-based selling format, typically used in online marketplaces.
auctiontype String The type of auction applicable to this item, such as fixed-price or traditional auction.
availabletopartners Boolean If the value is 'true', the service item is available for selection by partner users; if 'false', it is hidden from partners.
billexchratevarianceacct String The general ledger account used to record variances due to billing exchange rate differences.
billingschedule String The billing schedule template that determines how and when the customer is billed for the service item.
billpricevarianceacct String The account used to track variances between billed and expected prices for the service item.
billqtyvarianceacct String The account used to capture quantity discrepancies between the billed and actual service quantities.
buyitnowprice Decimal The fixed price at which a customer can immediately purchase the service item in an auction setting.
class String The classification assigned to the service item for tracking and reporting purposes, such as business line or region.
conditionenabled String Indicates whether item condition rules are enabled for this service item (for example, refurbished, new).
conditionhelpurl String A Uniform Resource Locator (URL) linking to documentation or guidelines explaining condition settings applicable to this service item.
consumptionunit String The unit of measure used to track service consumption, such as hours or sessions.
contingentrevenuehandling Boolean If the value is 'true', contingent revenue recognition rules are applied to this item; if 'false', revenue is recognized as billed.
cost Decimal The direct cost associated with delivering the service item, used for profitability analysis.
costcategory String The cost category assigned to the service item, which determines how costs are grouped in financial reports.
costestimate Decimal An estimated cost used for forecasting and project planning related to the service item.
costestimatetype String The method used to estimate the cost of the service item, such as average or standard cost.
costunits String The unit of measure in which the item's cost is expressed, such as per hour or per project.
createddate Datetime The date and time the service item record was created in the system.
createjob Boolean If the value is 'true', a job or project record is automatically created when this item is used; if 'false', no job is created.
createrevenueplanson String Specifies the rule or trigger that initiates the creation of a revenue recognition plan for the service item.
currency String The currency in which the service item’s pricing and cost data are recorded.
customform String The custom form template used to display or manage this service item’s record in the user interface.
deferralaccount String The general ledger account used to temporarily hold deferred amounts until revenue can be recognized.
deferredrevenueaccount String The revenue account where deferred income is posted for the service item until it is earned.
deferrevrec Boolean If the value is 'true', revenue recognition is deferred for this item; if 'false', revenue is recognized immediately.
department String The internal department responsible for the delivery or management of the service item.
directrevenueposting Boolean If the value is 'true', revenue for this service item is posted directly without using deferred accounts; if 'false', deferral logic is used.
displayinebaystore Boolean If the value is 'true', the service item is listed in the connected eBay store; if 'false', it is excluded.
displayname String The user-friendly name displayed for the service item across NetSuite interfaces and customer-facing documents.
dontshowprice Boolean If the value is 'true', the price of the service item is hidden on customer-facing records and portals; if 'false', the price is shown.
ebayhandlingtime String The handling time commitment displayed on eBay listings, indicating how soon the item will be processed for shipment after purchase.
ebayintlinsurancefee Decimal The cost of international shipping insurance for the service item when sold through eBay.
ebayintlpackagehandlingfee Decimal Additional handling fee charged for international shipments of this service item on eBay.
ebayintlshipinsurance String Specifies the type or provider of international shipping insurance for eBay transactions involving this item.
ebayintlshippingitem1 String The first shipping option for international delivery of the service item when listed on eBay.
ebayintlshippingitem2 String The second international shipping method offered on the eBay listing for the service item.
ebayintlshippingitem3 String The third shipping option for international orders of this item on eBay.
ebayisintlcalculatedrate String Indicates whether international shipping rates are calculated automatically for the eBay listing.
ebayisirregularpackage Boolean If the value is 'true', the item is marked as irregular in shape or weight for shipping on eBay; if 'false', it is considered a standard package.
ebayitemdescription String The item description used in eBay listings, providing details of the service being sold.
ebayitemlocdisplay String A custom display value for the item’s physical location in the eBay listing (for example,'Ships from California').
ebayitemloczipcode String The ZIP code associated with the service item’s shipping origin in eBay listings.
ebayitemlots Integer The number of service units grouped into one lot when listed on eBay, relevant for bulk service sales.
ebayitemsubtitle String An optional subtitle shown on the eBay listing, used to attract buyers with additional item info.
ebayitemtitle String The title of the eBay listing for the service item, typically including keywords to improve visibility.
ebayitemweightamt String The weight of the item as entered for eBay shipping calculations. May include value and unit (for example,'2 lbs').
ebaylayout String The listing layout template used for displaying the service item on eBay.
ebaypackagetype String The packaging format selected for the service item in eBay listings (for example,box, envelope).
ebaypagecounter String The page counter setting in the eBay listing, such as 'Basic' or 'Hidden', which tracks page views.
ebayrelistingoption String Specifies the relisting behavior on eBay if the service item does not sell, such as 'Auto-Relist'.
ebaytheme String The visual theme applied to the eBay listing to control branding and layout.
ebaythemegroup String The theme group to which the eBay theme belongs, helping organize available listing designs.
endauctionswhenoutofstock Boolean If the value is 'true', the eBay auction will end when the available quantity reaches zero; if 'false', the listing remains active.
enforceminqtyinternally Boolean If the value is 'true', internal rules enforce a minimum quantity requirement for using this service item; if 'false', quantity is unrestricted.
excludefromsitemap Boolean If the value is 'true', this service item is excluded from XML sitemaps used for search engine optimization (SEO) and web indexing.
expenseaccount String The general ledger account to which the service item’s purchase-related expenses are posted.
externalid String A user-defined external identifier used to reference the service item from external systems or integrations.
featureddescription String A short, attention-grabbing description used to highlight the service item in search results or promotional displays.
gallery Boolean If the value is 'true', the item is featured in the gallery section on eBay listings; if 'false', it is not displayed in the gallery.
galleryfeatured Boolean If the value is 'true', the item is marked as a featured listing in the gallery view on online marketplaces such as eBay.
generateaccruals Boolean If the value is 'true', accruals will be automatically generated for this service item during financial transactions.
gifttypeexpressship Boolean If the value is 'true', the item supports express shipping as a gift option.
gifttypegiftwrap Boolean If the value is 'true', the item supports gift wrapping services.
gifttypeshiptorecipient Boolean If the value is 'true', the item can be shipped directly to the gift recipient.
handlinggroup String The group that determines how the item is handled during order fulfillment, such as packaging or special processing requirements.
imagesgroup String A reference to the group of images associated with the item, used for managing product visuals across listings.
imageslocation String The file path or URL location where the item's images are stored.
includechildren Boolean If the value is 'true', child items (such as variants or components) are included in item listings and pricing.
incomeaccount String The general ledger account that receives revenue from the sale of this service item.
intercodefrevaccount String The intercompany deferred revenue account used when this item is involved in transactions between subsidiaries.
intercoexpenseaccount String The intercompany expense account associated with costs incurred for this item between subsidiaries.
intercoincomeaccount String The intercompany income account used when this item is sold between subsidiaries.
internalid Integer The unique internal identifier for the item within NetSuite’s system.
iscalculatedrate String Indicates whether the rate for this item is calculated automatically or entered manually.
isdonationitem Boolean If the value is 'true', the item is treated as a donation item and may be used in charitable transactions or campaigns.
isfulfillable Boolean If the value is 'true', the item can be fulfilled like a physical product, even though it is a service.
isgcocompliant Boolean If the value is 'true', the item complies with Generally Compliant Operations (GCO) standards, typically for global commerce.
isinactive Boolean If the value is 'true', the item is inactive and not available for new transactions.
isonline Boolean If the value is 'true', the item is available in the online store or e-commerce platform.
issueproduct String A reference to the product that this service item is issued with or related to.
itemcondition String The condition of the item such as new, refurbished, or used—relevant in marketplaces or regulated industries.
itemhandlingfee Decimal The fee charged for handling this service item during fulfillment or delivery.
itemid String The item’s unique identifier or Stock Keeping Unit (SKU) used for tracking and sales.
iteminsurancefee Decimal The fee charged for optional insurance coverage during delivery of the service.
itemoptions String A list of customizable or selectable options available for the item such as duration or level of service.
itemrevenuecategory String The revenue category used for classifying income generated by this item, useful in revenue recognition and reporting.
itemshipinsurance String Specifies the shipping insurance option associated with this item.
itemtype String The type of item, such as 'service', which determines how it is processed in transactions.
lastmodifieddate Datetime The date and time when the item record was last modified in the system.
listimmediate String Indicates whether the item should be listed immediately in an online store or held for manual publishing.
listingduration String The duration for which the item is listed on an external marketplace, such as 7 days, 30 days, or 'Good Till Cancelled'.
listingstartdate Date The calendar date when the listing becomes active on external marketplaces or e-commerce platforms.
listingstarttime String The specific time of day when the listing is scheduled to start.
location String The inventory or service location associated with the item, often used for fulfillment and tax calculations.
manufacturingchargeitem Boolean If the value is 'true', the service item is used to represent manufacturing overhead or charges during production.
matrixitemnametemplate String A template used to generate the names of matrix items, which are items with variations such as size or color.
matrixtype String Specifies the role of the item in a matrix setup, such as 'parent' or 'child'.
maxdonationamount Decimal The maximum donation amount allowed when this service item is used in a charitable transaction.
maximumquantity String The upper limit of quantity that can be ordered for this item in a single transaction.
metataghtml String Custom HTML meta tags used to enhance SEO for this item on e-commerce sites.
minimumquantity String The minimum quantity required when purchasing or processing this item.
minimumquantityunits String The unit of measurement that applies to the minimum quantity value.
mossapplies Boolean If the value is 'true', the item is subject to the Mini One Stop Shop (MOSS) VAT reporting rules for digital services in the European Union.
nopricemessage String A custom message displayed when no price is available for this item, such as 'Contact us for pricing'.
numactivelistings Integer The number of active listings for this item across all sales channels and marketplaces.
numcurrentlylisted Integer The number of current listings available for this item at the present time.
offersupport Boolean If the value is 'true', the item includes or enables customer support services.
outofstockbehavior String Specifies how the system should behave when the item is out of stock, such as 'Allow Backorders' or 'Prevent Sales'.
outofstockmessage String A message shown to users when the item is not currently available, such as 'Out of stock—check back soon'.
overheadtype String The type of overhead cost associated with this item, such as labor or material overhead in manufacturing.
packageheight String The height of the item’s packaging, used for shipping calculations and logistics planning.
packagelength String The length of the item’s packaging for shipping and dimensional weight considerations.
packagewidth String The width of the item’s packaging for determining shipping costs.
pagetitle String The HTML page title used for this item’s detail page, helpful for SEO and browser display.
parent String The parent item in a matrix or hierarchical relationship, if applicable.
pricinggroup String The pricing group assigned to this item, which determines pricing rules for different customer segments.
primarycatdisplayname String The display name of the primary category to which this item belongs, shown in storefronts.
primarycategory Integer The internal identifier of the item's main product category.
purchasedescription String A detailed description used on purchase transactions such as vendor bills or purchase orders.
purchaseorderamount String The total amount specified for the item on a purchase order.
purchaseorderquantity String The quantity of the item specified on a purchase order.
purchaseorderquantitydiff String The difference between the expected quantity and the received quantity on purchase orders for this service item.
purchaseunit String The unit of measurement used when ordering this item from a vendor, such as 'hours' or 'each'.
receiptamount String The monetary amount received for the item as recorded on the receipt document.
receiptquantity String The quantity of this item received into inventory or service fulfillment.
receiptquantitydiff String The difference between the expected quantity and actual quantity received for this item.
refundgivenas String Specifies the method by which refunds are issued for this item, such as store credit or original payment method.
relateditemsdescription String A descriptive text that highlights related or complementary items to encourage cross-selling.
reserveprice Decimal The minimum acceptable price set for the item in auction-style listings.
residual String The residual value of the item used in financial or amortization calculations.
returnpolicy String The return policy applied to this item, defining general return terms such as eligibility or timeframe.
returnpolicydetails String Detailed information about the return policy, such as restocking fees or return process steps.
returnshippingpaidby String Indicates who is responsible for return shipping costs, such as 'buyer' or 'seller'.
returnswithin String Specifies the allowable period for returning the item, such as '30 days from receipt'.
revenueallocationgroup String A group used to allocate revenue for multi-element arrangements involving this item.
revenuerecognitionrule String The rule that governs how and when revenue is recognized for this item.
revrecforecastrule String The rule used to forecast revenue recognition amounts and timing for this item.
revreclassfxaccount String The foreign currency reclassification account used during revenue reclassification.
revrecschedule String The revenue recognition schedule associated with the item, such as monthly or quarterly.
salesdescription String A description of the item intended for display on sales documents or e-commerce listings.
saleunit String The unit in which the item is sold, such as 'per hour' or 'per session'.
searchkeywords String Keywords associated with this item to improve searchability on storefronts and marketplaces.
secondarycatdisplayname String The name of the secondary category where this item is displayed online.
secondarycategory Integer The internal ID for the item's secondary category, often used for navigation or filtering.
sellonebay Boolean If the value is 'true', the item is available for sale on eBay via integrated listing functionality.
shipasia Boolean If the value is 'true', the item can be shipped to countries in Asia.
shipaustralia Boolean If the value is 'true', the item can be shipped to customers in Australia.
shipcanada Boolean If the value is 'true', the item is available for shipping to Canada.
shipeurope Boolean If the value is 'true', the item can be shipped to countries in Europe.
shipgermany Boolean If the value is 'true', the item can be shipped to Germany.
shipjapan Boolean If the value is 'true', the item is eligible for shipping to Japan.
shipmexico Boolean If the value is 'true', the item can be shipped to customers in Mexico.
shipnorthsouthamerica Boolean If the value is 'true', the item can be shipped to countries in North and South America.
shippingdomesticmethodsgroup String The group of shipping methods available for domestic deliveries of this service item.
shippingdomgroup String The internal group used to organize domestic shipping settings for the item.
shippingintlgroup String The group that defines international shipping options for the item across all global regions.
shippingintlgroup1 String The first specific group of international shipping settings applicable to this item.
shippingintlgroup2 String The second group of international shipping configurations available for this item.
shippingintlgroup3 String The third group of international shipping methods defined for this item.
shippingitem1 String The first shipping item or method associated with this service item for fulfillment purposes.
shippingitem2 String The second designated shipping item or method associated with the item.
shippingitem3 String The third defined shipping method or item applicable to this product.
shippinglocationsgroup String The group of shipping locations where this item is available for delivery.
shippingpackaginggroup String The group that determines the packaging configuration used when shipping this item.
shippingrate1 Decimal The first tier or level of the shipping rate applied to this item.
shippingrate2 Decimal The second tier of shipping rates assigned to the item, often used for bulk pricing.
shippingrate3 Decimal The third shipping rate level, typically used when multiple shipping options are configured.
shipuk Boolean If the value is 'true', the item can be shipped to customers located in the United Kingdom.
shipworldwide Boolean If the value is 'true', the item is available for shipping to all supported international destinations.
showasgift Boolean If the value is 'true', this item is flagged as eligible for gifting on storefronts and receipts.
showdefaultdonationamount Boolean If the value is 'true', a default donation amount is displayed when this item is part of a donation offering.
sitemappriority String The priority level this item should have in the site's XML sitemap, which affects search engine indexing.
softdescriptor String A short text description that appears on a customer’s credit card statement when they purchase this item.
standardimages String The set of standard images associated with this item for display on web store listings and product pages.
startingprice Decimal The initial price for this item when used in auction-style listings.
storecatdisplayname String The display name of the primary store category this item belongs to, shown on the storefront.
storecatdisplayname2 String The display name of the secondary store category where this item is listed.
storecategory Integer The internal ID of the primary store category used to classify this item on the web store.
storecategory2 Integer The internal ID of the secondary store category used for additional classification on the storefront.
storedescription String A brief marketing description of the item used on web store listings to attract buyers.
storedetaileddescription String A detailed description of the item shown on the web store product page, providing features and benefits.
storedisplayimage String The image file used as the default product image when the item appears in listings.
storedisplayname String The name of the item as it appears on the storefront, customer invoices, and order confirmations.
storedisplaythumbnail String The thumbnail image used for the item in smaller web store views, such as category listings or promotional banners.
storeitemtemplate String The template used to format the item's appearance on the web store, including layout and styling.
subsidiary String The subsidiary associated with this service item, used in multi-subsidiary environments to manage ownership and availability.
subtype String The subtype classification of the item, which provides more detailed categorization within the broader item type.
supersizeimages Boolean If the value is 'true', the web store displays a larger or high-resolution version of the item's image when available.
taxable Boolean If the value is 'true', the item is subject to tax based on the applicable tax rules and jurisdictions.
taxschedule String The tax schedule that determines how tax is calculated for the item based on location, customer, or other criteria.
templatesgroup String The group of templates used to generate printed or digital documents related to this item, such as invoices or receipts.
unitstype String The unit type assigned to the item, which defines how the item is measured and tracked in inventory or service billing.
upccode String The Universal Product Code (UPC) assigned to the item, used for barcoding and point-of-sale scanning.
urlcomponent String The URL-friendly identifier for this item, appended to the website domain to create the item’s product page link.
vendorname String The name of the preferred vendor or supplier associated with this service item.
vsoedeferral String Indicates the revenue deferral rule under the Vendor-Specific Objective Evidence (VSOE) method for this item.
vsoedelivered Boolean If the value is 'true', the item is flagged as delivered under VSOE accounting, allowing revenue recognition to proceed.
vsoepermitdiscount String Defines the discount policy that applies to the item under VSOE guidelines, permitting or restricting discounts.
vsoeprice Decimal The established VSOE price for this item, used to allocate revenue in multi-element transactions.
vsoesopgroup String The grouping this item belongs to for Statement of Position (SOP) revenue recognition under VSOE guidelines.
willship String Indicates the shipping behavior or preference for the item, such as whether it is fulfilled physically or digitally.

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