Power BI Connector for NetSuite

Build 24.0.9062

cashsale

The cashsale table.

Columns

Name Type References Description
account String Account
allowemptycards Boolean Allowemptycards
althandlingcost Decimal Althandlingcost
altshippingcost Decimal Altshippingcost
asofdate Date Asofdate
authcode String Authcode
billaddress String Billaddress
billaddresslist String Billaddresslist
billingaccount String Billingaccount
billingaddress String Billingaddress
billisresidential String Billisresidential
bulkprocsubmission String Bulkprocsubmission
canhavestackable Boolean Canhavestackable
ccapproved Boolean Ccapproved
ccavsstreetmatch String Ccavsstreetmatch
ccavszipmatch String Ccavszipmatch
ccexpiredate String Ccexpiredate
cchold String Cchold
ccholdetails String Ccholdetails
cciavsmatch String Cciavsmatch
ccispurchasecardbin Boolean Ccispurchasecardbin
ccname String Ccname
ccnumber String Ccnumber
ccprocessoraccount String Ccprocessoraccount
ccsecuritycode String Ccsecuritycode
ccsecuritycodematch String Ccsecuritycodematch
ccstreet String Ccstreet
cczipcode String Cczipcode
chargeit Boolean Chargeit
checknumber String Checknumber
class String Class
cleared Boolean Cleared
cleareddate Date Cleareddate
couponcode String Couponcode
createddate Datetime Createddate
createdfrom String Createdfrom
creditcard String Creditcard
creditcardprocessor String Creditcardprocessor
currency String Currency
currencyname String Currencyname
currencysymbol String Currencysymbol
customercode String Customercode
customform String Customform
debitcardissueno String Debitcardissueno
deferredrevenue Decimal Deferredrevenue
department String Department
discountitem String Discountitem
discountrate String Discountrate
discounttotal Decimal Discounttotal
dynamicdescriptor String Dynamicdescriptor
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
giftcertapplied Decimal Giftcertapplied
handlingcost Decimal Handlingcost
handlingmode String Handlingmode
handlingtax1rate String Handlingtax1rate
handlingtaxcode String Handlingtaxcode
ignoreavs Boolean Ignoreavs
ignorecsc Boolean Ignorecsc
inputauthcode String Inputauthcode
inputpnrefnum String Inputpnrefnum
inputreferencecode String Inputreferencecode
isbasecurrency Boolean Isbasecurrency
ismultishipto Boolean Ismultishipto
ispurchasecard String Ispurchasecard
isrecurringpayment Boolean Isrecurringpayment
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
nexus String Nexus
opportunity String Opportunity
otherrefnum String Otherrefnum
outputauthcode String Outputauthcode
outputreferencecode String Outputreferencecode
overridehold Boolean Overridehold
overrideholdchecked Boolean Overrideholdchecked
partner String Partner
paymentcardcsc String Paymentcardcsc
paymenteventdate Datetime Paymenteventdate
paymenteventholdreason String Paymenteventholdreason
paymenteventpurchasedatasent String Paymenteventpurchasedatasent
paymenteventresult String Paymenteventresult
paymenteventtype String Paymenteventtype
paymenteventupdatedby String Paymenteventupdatedby
paymentmethod String Paymentmethod
paymentoperation String Paymentoperation
paymentoption String Paymentoption
paymentprocessingprofile String Paymentprocessingprofile
paypalauthid String Paypalauthid
paypalprocess Boolean Paypalprocess
paypalstatus String Paypalstatus
paypaltranid String Paypaltranid
pnrefnum String Pnrefnum
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
softdescriptor String Softdescriptor
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
threedstatuscode String Threedstatuscode
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
undepfunds String Undepfunds
validfrom String Validfrom
vsoeautocalc Boolean Vsoeautocalc

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