Power BI Connector for NetSuite

Build 25.0.9454

otherchargeitem

Stores non-inventory charge items applied to transactions, such as fees or shipping costs.

Columns

Name Type References Description
amortizationperiod Integer The number of periods over which the cost is amortized.
amortizationtemplate String The template used for amortization schedules.
availabletopartners Boolean Indicates whether the item is available to partners.
billexchratevarianceacct String The account used for bill exchange rate variance adjustments.
billingschedule String The billing schedule applied to this item.
billpricevarianceacct String The account for tracking price variances on bills.
billqtyvarianceacct String The account for tracking quantity variances on bills.
class String The classification category assigned to the item.
consumptionunit String The unit of measurement for item consumption, such as liters or kilograms.
contingentrevenuehandling Boolean Indicates whether revenue recognition is contingent on conditions being met.
cost Decimal The base cost of the item.
costcategory String The cost category associated with the item.
costestimate Decimal The estimated cost of the item based on standard calculations.
costestimatetype String The method used to estimate costs, such as standard or average.
costunits String The unit of measurement for cost calculations.
createddate Datetime The date and time when the record was created.
createrevenueplanson String Specifies when revenue plans should be created for this item.
currency String The currency associated with the item's financial transactions.
customform String The custom form used for entering or displaying this record.
deferralaccount String The account used for deferring revenue or expenses.
deferredrevenueaccount String The account used for recognizing deferred revenue.
deferrevrec Boolean Indicates whether revenue recognition should be deferred.
department String The department associated with this item.
directrevenueposting Boolean Indicates whether revenue is posted directly to accounts without deferrals.
displayname String The name displayed for the item in listings and reports.
enforceminqtyinternally Boolean Specifies if the system enforces a minimum quantity for transactions.
expenseaccount String The account used for tracking expenses related to the item.
externalid String An external identifier for integration with other systems.
generateaccruals Boolean Specifies if accruals should be automatically generated for this item.
includechildren Boolean Specifies if child items should be included in item listings.
incomeaccount String The income account associated with the item.
intercodefrevaccount String The intercompany deferred revenue account for financial transactions.
intercoexpenseaccount String The intercompany expense account used for cost tracking.
intercoincomeaccount String The intercompany income account for revenue tracking.
isfulfillable Boolean Specifies if this item can be fulfilled through standard order processing.
isgcocompliant Boolean Indicates whether the item complies with Google Checkout requirements.
isinactive Boolean Indicates whether the item is inactive in the system.
isonline Boolean Specifies if the item is available for online sales.
issueproduct String The associated product that is issued as part of this item.
itemid String The unique identifier for the item in the system.
itemoptions String The available options or variations for the item.
itemrevenuecategory String The revenue category assigned to this item.
itemtype String The type of item, such as inventory, service, or non-inventory.
lastmodifieddate Datetime The date and time when the record was last modified.
location String The physical location associated with the item.
matrixitemnametemplate String The template used for naming matrix items.
matrixtype String Indicates whether the item is a matrix parent or child.
maximumquantity String The highest quantity of this item that can be purchased in a single transaction.
minimumquantity String The minimum quantity of this item that can be purchased in a single transaction.
minimumquantityunits String The unit of measure associated with the minimum quantity.
mossapplies Boolean Indicates whether the Mini One Stop Shop (MOSS) VAT rules apply to this item.
offersupport Boolean Indicates whether customer support is offered for this item.
overallquantitypricingtype String The pricing strategy applied based on total quantity purchased.
overheadtype String The type of overhead costs associated with the item.
parent String The parent item in a hierarchical product structure.
pricinggroup String The pricing group to which the item belongs.
purchasedescription String The description of the item used in purchase transactions.
purchaseorderamount String The total amount associated with purchase orders for this item.
purchaseorderquantity String The quantity of this item specified in purchase orders.
purchaseorderquantitydiff String The variance between ordered and received quantities.
purchaseunit String The unit of measure used for purchasing this item.
quantitypricingschedule String The pricing schedule based on purchase quantity tiers.
receiptamount String The total value of received inventory for this item.
receiptquantity String The total quantity of this item received.
receiptquantitydiff String The difference between expected and received item quantities.
residual String The remaining value or cost after deductions.
revenueallocationgroup String The group used for revenue allocation across multiple items.
revenuerecognitionrule String The rule governing when and how revenue is recognized.
revrecforecastrule String The rule used for forecasting revenue recognition.
revreclassfxaccount String The account used for foreign exchange reclassification of revenue.
revrecschedule String The schedule for recognizing revenue over time.
salesdescription String The description of the item used in sales transactions.
saleunit String The unit of measure used when selling this item.
softdescriptor String The billing descriptor that appears on customer statements.
subsidiary String The subsidiary entity associated with the item.
subtype String The subtype of the item, if applicable.
taxschedule String The tax schedule that applies to this item.
unitstype String The type of unit measurement used for the item.
upccode String The Universal Product Code (UPC) assigned to the item.
usemarginalrates Boolean Indicates whether marginal tax rates are applied to this item.
vendorname String The name of the vendor supplying this item.
vsoedeferral String The method used for deferring revenue under VSOE rules.
vsoedelivered Boolean Indicates whether the item has been delivered under VSOE accounting rules.
vsoepermitdiscount String Specifies if discounts are permitted under VSOE rules.
vsoeprice Decimal The VSOE-compliant price of the item.
vsoesopgroup String The VSOE Statement of Position group assigned to the item.

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