Power BI Connector for NetSuite

Build 24.0.9062

invoice

The invoice table.

Columns

Name Type References Description
account String Account
althandlingcost Decimal Althandlingcost
altshippingcost Decimal Altshippingcost
amountpaid Decimal Amountpaid
amountremaining Decimal Amountremaining
amountremainingtotalbox Decimal Amountremainingtotalbox
approvalstatus String Approvalstatus
asofdate Date Asofdate
balance Decimal Balance
billaddress String Billaddress
billaddresslist String Billaddresslist
billingaccount String Billingaccount
billingaddress String Billingaddress
billisresidential String Billisresidential
bulkprocsubmission String Bulkprocsubmission
canhavestackable Boolean Canhavestackable
class String Class
consolidatebalance Decimal Consolidatebalance
couponcode String Couponcode
createddate Datetime Createddate
createdfrom String Createdfrom
currency String Currency
currencyname String Currencyname
currencysymbol String Currencysymbol
customform String Customform
deferredrevenue Decimal Deferredrevenue
department String Department
discountamount Decimal Discountamount
discountdate Date Discountdate
discountitem String Discountitem
discountrate String Discountrate
discounttotal Decimal Discounttotal
duedate Date Duedate
email String Email
enddate Date Enddate
entity String Entity
entitynexus String Entitynexus
entitytaxregnum String Entitytaxregnum
estgrossprofit Decimal Estgrossprofit
estgrossprofitpercent String Estgrossprofitpercent
exchangerate Decimal Exchangerate
excludecommission Boolean Excludecommission
expcostdiscamount Decimal Expcostdiscamount
expcostdiscount String Expcostdiscount
expcostdiscprint Boolean Expcostdiscprint
expcostdiscrate String Expcostdiscrate
expcostdisctaxable Boolean Expcostdisctaxable
expcosttaxcode String Expcosttaxcode
expcosttaxrate1 String Expcosttaxrate1
externalid String Externalid
fob String Fob
forinvoicegrouping Boolean Forinvoicegrouping
giftcertapplied Decimal Giftcertapplied
groupedto String Groupedto
handlingcost Decimal Handlingcost
handlingtax1rate String Handlingtax1rate
handlingtaxcode String Handlingtaxcode
isbasecurrency Boolean Isbasecurrency
ismultishipto Boolean Ismultishipto
istaxable Boolean Istaxable
itemcostdiscamount Decimal Itemcostdiscamount
itemcostdiscount String Itemcostdiscount
itemcostdiscprint Boolean Itemcostdiscprint
itemcostdiscrate String Itemcostdiscrate
itemcostdisctaxable Boolean Itemcostdisctaxable
itemcosttaxcode String Itemcosttaxcode
itemcosttaxrate1 String Itemcosttaxrate1
lastmodifieddate Datetime Lastmodifieddate
leadsource String Leadsource
linkedtrackingnumbers String Linkedtrackingnumbers
location String Location
memo String Memo
message String Message
messagesel String Messagesel
muccpromocodeinstance String Muccpromocodeinstance
nextapprover String Nextapprover
nexus String Nexus
opportunity String Opportunity
otherrefnum String Otherrefnum
overrideinstallments Boolean Overrideinstallments
partner String Partner
paylink String Paylink
postingperiod String Postingperiod
promocode String Promocode
promocodepluginimpl String Promocodepluginimpl
recognizedrevenue Decimal Recognizedrevenue
recurringbill Boolean Recurringbill
returntrackingnumbers String Returntrackingnumbers
revenuestatus String Revenuestatus
revreconrevcommitment Boolean Revreconrevcommitment
saleseffectivedate Date Saleseffectivedate
salesgroup String Salesgroup
salesrep String Salesrep
shipaddress String Shipaddress
shipaddresslist String Shipaddresslist
shipdate Date Shipdate
shipisresidential String Shipisresidential
shipmethod String Shipmethod
shipoverride String Shipoverride
shippingaddress String Shippingaddress
shippingcost Decimal Shippingcost
shippingcostoverridden String Shippingcostoverridden
shippingtax1rate String Shippingtax1rate
shippingtaxcode String Shippingtaxcode
source String Source
startdate Date Startdate
status String Status
statusRef String Statusref
subsidiary String Subsidiary
subsidiarytaxregnum String Subsidiarytaxregnum
subtotal Decimal Subtotal
syncpartnerteams Boolean Syncpartnerteams
syncsalesteams Boolean Syncsalesteams
taxdetailsoverride Boolean Taxdetailsoverride
taxitem String Taxitem
taxpointdate Date Taxpointdate
taxpointdateoverride Boolean Taxpointdateoverride
taxrate Double Taxrate
taxregoverride Boolean Taxregoverride
taxtotal Decimal Taxtotal
terms String Terms
timediscamount Decimal Timediscamount
timediscount String Timediscount
timediscprint Boolean Timediscprint
timediscrate String Timediscrate
timedisctaxable Boolean Timedisctaxable
timetaxcode String Timetaxcode
timetaxrate1 String Timetaxrate1
tobeemailed Boolean Tobeemailed
tobefaxed Boolean Tobefaxed
tobeprinted Boolean Tobeprinted
total Decimal Total
totalcostestimate Decimal Totalcostestimate
trackingnumbers String Trackingnumbers
trandate Date Trandate
tranid String Tranid
tranisvsoebundle Boolean Tranisvsoebundle
unbilledorders Decimal Unbilledorders
vsoeautocalc Boolean Vsoeautocalc

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062