Invoice INV578223 - NetSuite Backup

	#	Item	Description	Qty	Amount
	1	PRT1200BN-A	SteamSpa Premium 12 KW QuickStart Acu-Steam Bath Generator Package with Built-in Auto Drain in Brushed Nickel	1.00	1,699.99

	10	G-STEAMFILT	Water Filter for SteamSpa Generators - G-STEAMFILT - STEAMSPA	1.00	0.00

	13	G-STEAMFILTERCART3	3x SteamSpa Filter Cartridge	1.00	0.00

Subtotal	1,699.99
Total	1,699.99

General

General · 31 fields · 25 with a value · 6 empty

Checkcommittedcheckcommitted: No
Created fromcreatedfrom: Sales Order #SOS2875969
Customer PO #otherrefnum: KL-Terry Heath
Customformcustomform: Spa World - Product Invoice
Invoice #tranid: INV578223
Isonlinetransactionisonlinetransaction: No
Istransformedbillistransformedbill: Yes
Istransformedtransactionistransformedtransaction: Yes
Linkedlinked: Yes
Locationlocation: Miami
Locationusesbinslocationusesbins: Yes
Nexus countrynexus_country: US
Originalnexusoriginalnexus: United States FL
Originalnexuscountryoriginalnexuscountry: US
Recordcreatedbyrecordcreatedby: 167359
Statusstatus: Paid In Full
Subsidiarysubsidiary: Spa World Corporation
Tax nexusnexus: United States FL
To be emailedtobeemailed: No
To be faxedtobefaxed: No
To be printedtobeprinted: No
Transactionnumbertransactionnumber: CUSTINVC392793
Voidedvoided: No
Warnnexuschangewarnnexuschange: No
Weekendpreferenceweekendpreference: ASIS

No value 6

Classclass: —
Departmentdepartment: —
Memomemo: —
Message to customermessage: —
Messageselmessagesel: —
Opportunityopportunity: —

Customer

Customer · 26 fields · 16 with a value · 10 empty

Balancebalance: 1,955.30
Companyidcompanyid: 1957250
Credholdentitycredholdentity: 1957250
Credholdoverridecredholdoverride: No
Custcurrepcustcurrep: 1123
Customerentity: 19927 Steam Sauna Direct
Daysoverduedaysoverdue: 0
Emailemail: tbhplumbing@gmail.com
Entity nexus countryentity_nexus_country: US
Entityfieldnameentityfieldname: entity
Entitynameentityname: 19927 Steam Sauna Direct
Entitynexusentitynexus: United States FL
Manualcreditholdmanualcredithold: No
Overallbalanceoverallbalance: 1,955.30
Prevrepprevrep: 1123
Sales repsalesrep: House Account

No value 10

10184 customer entity bankcustbody_10184_customer_entity_bank: —
Credlimcredlim: —
Email hc trancustbody_email_hc_tran: —
Faxfax: —
Jobjob: —
Lead sourceleadsource: —
Partnerpartner: —
Partneridpartnerid: —
Phone hc enitycustbody_phone_hc_enity: —
Ret label emailcustbody_ret_label_email: —

Shipping

Shipping · 37 fields · 16 with a value · 21 empty

Carriercarrier: nonups
Hasfedexfreightservicehasfedexfreightservice: No
Itemshippingcostfxrateitemshippingcostfxrate: 1
Pj sssdeliverycustbody_pj_sssdelivery: No
Ship toshipaddress: Terry Heath Professional Plumbing 282 Enterprise Rd Littleton NC 27850 (252) 532-3215
Shipcountryshipcountry: US
Shipisresidentialshipisresidential: No
Shipoverrideshipoverride: No
Shippingaddress keyshippingaddress_key: 15792791
Shippingaddress textshippingaddress_text: Terry Heath Professional Plumbing 282 Enterprise Rd Littleton NC 27850 (252) 532-3215
Shippingaddress typeshippingaddress_type: shipaddr
Shippingaddress2 setshippingaddress2_set: var subrecord = nlapiViewSubrecord('shippingaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('shippingaddress_text', addresstext);
Shipstateshipstate: NC
Shipzipshipzip: 27850
Sw ship to email addresscustbody_sw_ship_to_email_address: tbhplumbing@gmail.com
Tracking numberslinkedtrackingnumbers: 276419717806

No value 21

Amz shipment idcustbody_amz_shipment_id: —
Carrier codecustbody_carrier_code: —
Delivery termscustbody_delivery_terms: —
Doshippingrecalcdoshippingrecalc: —
Fedexservicenamefedexservicename: —
FOBfob: —
Packing label file urlcustbody_packing_label_file_url: —
Packing slip filecustbody_packing_slip_file: —
Previous shipaddresslistprevious_shipaddresslist: —
Returntrackingnumbersreturntrackingnumbers: —
Rma tracking numbercustbody_rma_tracking_number: —
Ship methodshipmethod: —
Ship method usedcustbody_ship_method_used: —
Shipaddresslistshipaddresslist: —
Shipping label filecustbody_shipping_label_file: —
Shipping label linkcustbody_shipping_label_link: —
Shipping label urlcustbody_shipping_label_url: —
Shippingaddress defaultvalueshippingaddress_defaultvalue: —
Shipspeedcustbody_shipspeed: —
Tracking numbercustbody_tracking_number: —
Tracking numberstrackingnumbers: —

Billing

Billing · 12 fields · 7 with a value · 5 empty

Address country state mapaddress_country_state_map: [9328410:US][9307802:US_NY][9329421:US_FL][9322993:CA_ON][9307806:US_NY][9284097:US_MO][9382793:US_MD][9366979:US_LA][9322992:CA_ON][9327909:US_AZ][9391625:US_MI][9391629:US_IN][9329420:US_FL][9418731:US_CA][9307808:US_NY][9169126:US_FL][9169127:US_TN][9168724:US_PR][9288126:US_MD][9288529:US_NV][9284700:US_LA][9559214:US_OH][9593250:US_CA][9564827:US_MT][9653575:US_NH][9637178:US_NY][9556566:US][9634446:US_CO][9576301:US_MA][9633942:US][9559215:US_AZ][9700866:US_TN][9442340:US][9458619:US_IA][9700865:US_TN][9702682:US][9459431:US_CO][9759181:US_CA][9691436:US_NY][9847526:US_NY][9932014:US_CO][9936957:US_FL][9982095:US_TX][10014465:US_GA][9897495:US_MA][10015579:US_NY][9946809:US][10056988:US_PA][9870829:US_MO][9870830:US_MO][10077965:US_TX][10070943:US][10070944:US][9850558:US_MI][10047464:US][10088937:US_WA][10088938:US_MT][9862083:US_AZ][9991238:US_PA][10015175:US][9850057:US][10130825:US][9831473:US][9831474:US][9862084:US_CA][10071046:US][9935945:US_CO][10081393:US][10152840:US][10016081:US_FL][10070942:US][9936755:US_CO][10154154:US_NJ][9835598:US_NY][9835599:US_OH][10045357:US_CA][10140058:US_TX][10018509:US_NY][10195266:US_FL][9819019:US_IL][9819020:US_IL][9923670:US_DE][9980177:CA_ON][10192046:US][10168416:US][10191945:US][9848031:US_NY][10367960:US][10364535:US][10362521:US_MD][10241843:US_FL][10367147:US_CA][10337727:US][10228774:US][10221460:US_FL][10278942:US][10291707:US_FL][10241835:US][10580378:US_TN][10580379:US_GA][10206200:US][10265276:US][10617447:US][10242745:US_CA][10619057:US_NY][10218229:US_GA][10354009:US_IL][10291705:US_IL][10350381:US][10438308:US][10519545:US_TN][10438307:US][10444714:US][10411772:US_NJ][10512023:US_CA][10434983:US][10384341:US][10237799:US_NY][10237900:US_NY][10241842:US_FL][10458081:US][10291810:US_FL][10314098:US_AZ][10315510:US][10433062:US_NY][10509714:US][10377023:US][10264365:US][10458483:US_NY][10458485:US_NY][10362823:US][10367148:US_CA][10446631:CA_ON][10343164:US_IL][10414705:US_NJ][10794676:US_TX][10796997:US_FL][10808957:US_NJ][10785034:US_NY][10685320:US_FL][10814975:US_FL][10814974:US_FL][10732615:US_CT][10795283:US][10786955:US_LA][10634535:US_CT][10724377:US_UT][10745883:US_NY][10695591:US_MI][10695592:US_MI][10693965:US][10893657:US_MO][10942133:US_MO][10761690:US][10687634:US_WA][10663879:US][10933486:US][10916795:US_NJ][10687432:US_IL][10745382:US_CA][10687633:US_ID][10753460:US_CA][10746900:US_CA][10761892:US_FL][10794575:US_TX][10954991:US_NJ][11007404:US][10733419:US_MS][10784329:US_KY][10685321:US_FL][10873593:US][10702922:US_FL][10825643:US_FL][10941114:CA_QC][10859823:US_AR][10665405:US_WI][10975728:US_TX][11042180:US][10860327:US_MN][10814773:US][11317297:US_AZ][11446170:US][11430157:US_MA][11441525:US_TX][11373013:US_PA][11373014:US_PA][11337993:US_FL][11445161:US][11475006:US_OH][11476819:US_PA][11468187:US_SD][11370194:US_PA][11383973:US_NY][11360555:US][11465257:US][11358935:US_WA][11475005:US_OH][11428248:US_CT][11337792:US_FL][11081711:US_MT][11317300:US_AZ][11455625:US_CA][11404133:US_TX][11451178:US_GA][11327744:US_CA][11456132:US_NJ][11373010:US_CO][11477223:US_GA][11358120:US][11180379:US][11163041:US_CA][11183110:US_AZ][11104650:US_IL][11149768:US_MI][11149769:US_MI][11197990:US][11247888:US][11295473:US][11137876:US][11163148:US_CA][11189433:US][11205427:US_IL][11095389:US][11105967:US_GA][11105968:US_GA][11254008:US_CT][11264148:US_FL][11205729:US_OR][11113099:US_CA][11113300:US_CA][11248897:US_AZ][11097218:US_UT][11244749:US_FL][11112286:US_OR][11274625:US_CA][11163039:US_TX][11188625:US_TX][11104148:US_DE][11199600:US][11096714:US][11086649:US_WA][11296078:US_NJ][11296079:US_NJ][11097419:US][11164363:US_CA][11163151:US_VA][11267292:US][11096916:US][11207551:US_NY][11246778:US_GA][11137977:US_FL][11246779:US_GA][11079143:US][11180483:US][11137978:US][11105155:US_CA][11264149:US_FL][11294159:US][11208968:US_PA][11213083:US_OR][11131348:US_TX][11906835:US_NM][11537698:US][11748884:US][11864471:US][11873649:US_MA][11873650:US_MA][11918100:US][11938725:US][11904623:US_MA][11875462:US][11873448:US_CO][11938926:US][11590421:US_FL][11619684:US_CA][11747976:US_FL][11607408:US_NY][11837450:US_MI][11837451:US_MI][11851124:US_CA][11677403:US_CO][11704738:US][11757307:US_NY][11759625:US_NY][11503465:US_CO][11602972:US_MI][11747775:US_FL][11549551:US_FL][11549550:US_FL][11759729:US_TX][11822109:US_NJ][11822110:US_NJ][11594455:US_NJ][11503466:US_CO][11505182:US][11549046:US_NY][11614542:US_OK][11517535:US_NY][11770974:US][11607409:US_NY][12426250:US][12286079:US_NY][12438506:US_TX][12301563:US_CO][12450863:US][12425741:US_CA][12474866:US][12451873:US][12382205:US_LA][12477681:US_OH][12392035:US][12394758:US_CO][12460307:US_WV][12465444:US_NY][12438619:US_NY][12438620:US_NY][12466149:US_GA][12286080:US_NY][12463016:US_TX][12395466:US_VA][12034426:US][12170156:US_TX][12029801:US_RI][12035128:US_NY][12113348:US_VA][12139735:US_WI][12139734:US_IL][12201068:US_VA][12079794:US_OH][12049686:US_OH][12012741:US][12216818:US_MN][12029800:US_RI][12047077:US_OH][12044652:US_NY][12045660:US_VA][12045661:US_MD][11983959:US_TX][12031208:US_NY][12034427:US][12044857:US_MO][12046771:US_TX][12044651:US_OH][12130019:US][13198133:US_AR][13042145:US_CA][13030679:US_WA][13170130:US_GA][13210409:US_CA][13208892:US_CA][13217335:US_OK][13116979:US][13218558:US_CT][13228922:US_NV][13087834:US_IN][13113837:US_RI][13154736:US_CA][13154737:US_CA][13020518:US_CA][13048576:US][13049788:US_CA][13139226:CA_ON][13169615:CA_ON][13136997:US_PA][13255799:US_NV][13032683:US][13250287:US_MN][13053319:US][13050800:US][13190194:US_CA][13246651:US_NY][13190188:CA_AB][13054126:US_CO][13153621:US_NY][13115565:US][13161979:US][13029263:US_NJ][13074928:US][13153825:US_CA][13189679:US_NJ][13146670:US_GA][13190190:US_FL][13227303:US_CA][13256213:US_NY][13051708:US_MA][13277034:US_NV][13372996:US_NY][13395933:US_NY][13337973:US_TX][13338075:US_TX][13295207:US_MA][13378032:US_TX][13085202:CA_ON][13085303:CA_ON][13375811:US_NC][13478115:US_CA][13393700:US][13457198:US_AZ][13395228:US_NY][13435772:US_IN][13357454:US_MA][13296737:US_OK][13456994:US_NM][13077258:US_PR][13343322:US_CA][13343423:US_CA][13439019:US_WA][13356847:US_FL][13094146:US][13449964:US][13295310:US_NY][13480949:US_MA][13394114:US_FL][13378033:US_TX][13457096:US_AZ][13457197:US_NM][13480642:US_CO][13424906:US][13041839:US_FL][13296736:US_OK][13044073:US][13479937:US_AZ][13480641:US_CO][13148294:US_PA][13387275:US_TN][13009755:US_NJ][13355745:US_NV][13375810:US_NC][12545842:US_TX][12750201:US][12724895:US_TX][12708805:US_NY][12778251:US][12606324:US_TX][12647174:US][12783913:US_NV][12651110:US_MO][12708806:US_NY][12804387:US_MD][12647176:CA][12817460:CA_BC][12783912:US_NV][12859897:US_GA][12872984:US_GA][12883949:US][12896016:US_PA][12525618:US_MI][12525620:US_MI][12950814:US][12553662:US][12936637:US_FL][12950108:US_UT][12862007:US_AZ][12874308:US][12962675:US_CO][12525725:US_AL][12872080:US_PA][12558396:US_NY][12871874:US][12545943:US_TX][12908591:US_CA][13646301:US_CT][13652522:US_AZ][13674600:US_MA][13639440:US_NY][13513433:US_NV][13753425:US_CA][13586191:US_NY][13511923:US_AL][13586192:US_NY][13768051:US_WA][13663056:US_TX][13765939:US_NJ][13505001:US_NV][13878386:US_FL][13514841:US_AZ][13578354:US_TN][13617471:US_OH][13639541:US_IL][13889302:US_VA][13499647:US_FL][13674198:US_MA][13514844:US_NV][13802610:US_NJ][13629304:US_GA][13806742:US_FL][13900055:US_NY][13579370:US_CA][13601867:US_CA][13524676:US_MO][13785277:US_FL][13514845:US_CA][13576634:US_FL][13903666:US_VA][13574206:CA_ON][13804225:US_WI][13656146:US_CO][13656147:US_CO][13514843:US_AZ][13574708:US_CA][14028309:US_CA][13745279:US_MD][14038642:US_WY][14049778:US_CA][13599845:US_IL][13823952:US_TX][13964120:US_CA][14082286:US_NV][14082687:US_GA][13977378:US_FL][13977276:US_WA][13936279:US_CO][13871362:US_CA][13974454:US_FL][14049775:US_CA][14124300:US_CA][13514639:US_AL][13950574:US_WA][14050081:US_CO][14157079:US_NV][14087724:US_TX][14142438:US_FL][14145554:US_NV][13940236:US_CA][14087725:US_TX][14038641:US_WY][14144950:US_FL][13977277:US_WA][14144449:US_AZ][13563665:US_CA][13974453:US_FL][13872765:US_CA][14039147:US_NY][14046964:US_FL][14124199:US_CA][14028410:DO_DN][14163730:US_FL][13965229:US_NJ][13940235:US_CA][14267980:US_FL][14303711:US_CA][14441893:US_TX][14214259:US_FL][14441894:US_TX][14442401:US_CA][14316598:US_CA][14440238:US_NJ][14292748:US_CO][14314072:US_FL][14303505:US_CA][14329777:US_CA][14327855:US_UT][14316599:US_AZ][14454157:US_NY][14319001:US_PA][14431164:US_TN][14468289:US_TX][14267779:US][14230708:US_OH][14301478:US_VA][14314070:US_FL][14442095:US_CA][14303710:US_CA][14329878:US_CA][14465426:US_IL][14267981:US_FL][14319002:US_PA][14523374:CA_ON][14230909:US_OH][14583448:US_CO][14610293:US_CA][14241662:US_NV][14537978:US_AL][14515213:US_CT][14608681:US_CA][14651046:US_NJ][14529022:US_SC][14247592:US_TN][14255132:US_GA][14647603:US_FL][14242772:US_CA][14583246:US_MA][14233032:US_CA][14523475:CA_ON][14598845:US_CA][14608782:US_CA][14651044:US_NJ][14650131:US_NJ][14233031:US_CA][14373463:CA_ON]
Bill tobilladdress: Terry Heath Terry Heath 282 Enterprise Rd Littleton NC 27850 (252) 532-3215
Billingaddress keybillingaddress_key: 15792790
Billingaddress textbillingaddress_text: Terry Heath Terry Heath 282 Enterprise Rd Littleton NC 27850 (252) 532-3215
Billingaddress typebillingaddress_type: shipaddr
Billingaddress2 setbillingaddress2_set: var subrecord = nlapiViewSubrecord('billingaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('billingaddress_text', addresstext);
Billisresidentialbillisresidential: No

No value 5

Billaddresslistbilladdresslist: —
Billingaddress defaultvaluebillingaddress_defaultvalue: —
Defaultaddrbookdefaultaddrbook: —
Defaultaddresseedefaultaddressee: —
Previous billaddresslistprevious_billaddresslist: —

Amounts & tax

Amounts & tax · 83 fields · 38 with a value · 45 empty

Amount dueamountremaining: 0.00
Amount paidamountpaid: 1,699.99
Amountremainingtotalboxamountremainingtotalbox: 0.00
Balreadyrefundedbalreadyrefunded: No
Currencycurrency: US Dollar
Currencynamecurrencyname: US Dollar
Currencyprecisioncurrencyprecision: 2
Currencysymbolcurrencysymbol: USD
Disablepromotionrecalcdisablepromotionrecalc: No
Discount totaldiscounttotal: 0.00
Estgrossprofitestgrossprofit: 1,400.09
Estgrossprofitpercentestgrossprofitpercent: 82.36
Exchange rateexchangerate: 1.00
Expcostdiscprintexpcostdiscprint: No
Installmentcountinstallmentcount: 0
Isbasecurrencyisbasecurrency: Yes
Iseditbilledtransactionwithpromotioniseditbilledtransactionwithpromotion: No
Islegacypromoislegacypromo: No
Itemcostdiscprintitemcostdiscprint: No
Linkedclosedperioddiscountslinkedclosedperioddiscounts: No
Oldrevenuecommitmentoldrevenuecommitment: No
Origcurrencyorigcurrency: 1
Origexchangerateorigexchangerate: 1.00
Origtotalorigtotal: 1,699.99
Origtotal2origtotal2: 1,699.99
Overallunbilledordersoverallunbilledorders: 2,377.55
Primarycurrencyprimarycurrency: 1.00
Primarycurrencyfxrateprimarycurrencyfxrate: 1.00
Promotionappliedpromotionapplied: No
Stc amount after discountcustbody_stc_amount_after_discount: 1,699.99
Stc tax after discountcustbody_stc_tax_after_discount: 0.00
Stc total after discountcustbody_stc_total_after_discount: 1,699.99
Subtotalsubtotal: 1,699.99
Tax totaltaxtotal: 0.00
Timediscprinttimediscprint: No
Totaltotal: 1,699.99
Totalcostestimatetotalcostestimate: 299.90
Unbilledordersunbilledorders: 2,377.55

No value 45

Amz discount totalcustbody_amz_discount_total: —
Amz total taxcustbody_amz_total_tax: —
Couponcodecouponcode: —
Discdaysdiscdays: —
Discountamountdiscountamount: —
Discountastotaldiscountastotal: —
Discountistaxablediscountistaxable: —
Discountitemdiscountitem: —
Discountratediscountrate: —
Discounttax1amountdatadiscounttax1amountdata: —
Discounttax2amountdatadiscounttax2amountdata: —
Discpctdiscpct: —
Duedaysduedays: —
Expcostdiscacctexpcostdiscacct: —
Expcostdiscamountexpcostdiscamount: —
Expcostdiscountexpcostdiscount: —
Expcostdiscrateexpcostdiscrate: —
Expcosttaxcodeexpcosttaxcode: —
Expcosttaxrate1expcosttaxrate1: —
Intercostatusintercostatus: —
Isinstallmentisinstallment: —
Itemcostdiscamountitemcostdiscamount: —
Itemcostdiscountitemcostdiscount: —
Itemcostdiscrateitemcostdiscrate: —
Itemcosttaxcodeitemcosttaxcode: —
Itemcosttaxrate1itemcosttaxrate1: —
Mindaysmindays: —
Ns refund idcustbody_ns_refund_id: —
Payment termsterms: —
Persistedpromocodepersistedpromocode: —
Persistedtermspersistedterms: —
Promo codepromocode: —
Promocodepluginimplpromocodepluginimpl: —
Promodiscountpromodiscount: —
Promotionidspromotionids: —
St amountcustbody_st_amount: —
Stc discountpercentcustbody_stc_discountpercent: —
Taxamount2overridetaxamount2override: —
Taxamountoverridetaxamountoverride: —
Taxperiodtaxperiod: —
Timediscamounttimediscamount: —
Timediscounttimediscount: —
Timediscratetimediscrate: —
Timetaxcodetimetaxcode: —
Timetaxrate1timetaxrate1: —

Payment

Payment · 6 fields · 1 with a value · 5 empty

Applied depositscustbody_applied_deposits: 1,699.99

No value 5

Customerpaymentcustomerpayment: —
Payment methodcustbody_payment_method: —
Payout idcustbody_payout_id: —
Stc payment transaction idcustbody_stc_payment_transaction_id: —
Wrm so returnauthorizationcustbody_wrm_so_returnauthorization: —

Dates

Dates · 34 fields · 10 with a value · 24 empty

Createdcreateddate: 6/28/2024 2:06 pm
Due dateduedate_dt: Jun 28, 2024
Esc created datecustbody_esc_created_date_dt: Jun 28, 2024
Esc last modified datecustbody_esc_last_modified_date_dt: Jun 28, 2024
Invoice datetrandate_dt: Jun 28, 2024
Last modifiedlastmodifieddate: 6/28/2024 2:06 pm
Prevdateprevdate_dt: Jun 28, 2024
Recordcreateddaterecordcreateddate: 06/26/2024 13:55:32
Saleseffectivedatesaleseffectivedate_dt: Jun 28, 2024
Ship dateshipdate_dt: Jun 27, 2024

No value 24

8custbody8_dt: —
Amazon order datecustbody_amazon_order_date: —
Amz ear delivery datecustbody_amz_ear_delivery_date: —
Amz earliest ship datecustbody_amz_earliest_ship_date: —
Amz last updated datecustbody_amz_last_updated_date: —
Amz latest delivery datecustbody_amz_latest_delivery_date: —
Amz latest ship datecustbody_amz_latest_ship_date: —
Approval datecustbody_approval_date: —
Date of taxable supplycustbody_date_of_taxable_supply_dt: —
Datedrivendatedriven: —
Discountdatediscountdate_dt: —
Document datecustbody_document_date_dt: —
End dateenddate_dt: —
Estimated ship datecustbody_estimated_ship_date: —
Fba ship datecustbody_fba_ship_date: —
Po date for invoicecustbody_po_date_for_invoice_dt: —
Pp epp_e_dt: —
Pp spp_s_dt: —
Sii operation datecustbody_sii_operation_date_dt: —
So formula ship datecustbody_so_formula_ship_date_dt: —
St end datecustbody_st_end_date: —
St start datecustbody_st_start_date: —
Start datestartdate_dt: —
Wrm reg hid lastbegindatecustbody_wrm_reg_hid_lastbegindate_dt: —

Integrations & channels

Integrations & channels · 77 fields · 24 with a value · 53 empty

Amazon fbacustbody_amazon_fba: No
Amazon prime sfcustbody_amazon_prime_sf: No
Cancel order in ebaycustbody_cancel_order_in_ebay: No
Is ebay ordercustbody_is_ebay_order: No
Issynchedcustbody_issynched: Yes
Ns os sales shipments exportdcustbody_ns_os_sales_shipments_exportd: No
Nsts wodm is chargebackcustbody_nsts_wodm_is_chargeback: No
Nsts wodm on holdcustbody_nsts_wodm_on_hold: No
Nsts wodm write off amountcustbody_nsts_wodm_write_off_amount: 10.00
Nsts wodm write off limitcustbody_nsts_wodm_write_off_limit: 1
Nsts wodm write off percentcustbody_nsts_wodm_write_off_percent: 0.50
Refund to shopifycustbody_refund_to_shopify: No
Shopify order cancelledcustbody_shopify_order_cancelled: No
Storeorderstoreorder: No
Wmsse codflagcustbody_wmsse_codflag: No
Wmsse printpickticketcustbody_wmsse_printpickticket: No
Wmsse saturdaydeliverycustbody_wmsse_saturdaydelivery: No
Wmsse signiturerequiredcustbody_wmsse_signiturerequired: No
Woocom if updated to woocustbody_woocom_if_updated_to_woo: No
Woocom order cancelled by scrcustbody_woocom_order_cancelled_by_scr: No
Woocom order created by scripcustbody_woocom_order_created_by_scrip: No
Woocom order linkcustbody_woocom_order_link: <a href=&action=edit></a>
Woocom order refunded by scricustbody_woocom_order_refunded_by_scri: No
Woocom order upd in woocustbody_woocom_order_upd_in_woo: No

No value 53

Amazon order idcustbody_amazon_order_id: —
Amazon premium shippingcustbody_amazon_premium_shipping: —
B2c channelcustbody_b2c_channel: —
Custbody ebay srncustbodycustbody_ebay_srn: —
Ebay buyer notecustbody_ebay_buyer_note: —
Ebay cancel idcustbody_ebay_cancel_id: —
Ebay cancel reason nscustbody_ebay_cancel_reason_ns: —
Ebay order numbercustbody_ebay_order_number: —
Ebay orderidcustbody_ebay_orderid: —
Edi statuscustbody_edi_status: —
Externalidexternalid: —
Fulfilment channel ordercustbody_fulfilment_channel_order: —
Marketplace shippingcustbody_marketplace_shipping: —
Ns os sales channel namecustbody_ns_os_sales_channel_name: —
Ns os sales channel numbercustbody_ns_os_sales_channel_number: —
Ns os sales error codecustbody_ns_os_sales_error_code: —
Ns os sales order idcustbody_ns_os_sales_order_id: —
Ns os sales order statuscustbody_ns_os_sales_order_status: —
Ns os sales setup rec idcustbody_ns_os_sales_setup_rec_id: —
Ns os sales ship exp bat idcustbody_ns_os_sales_ship_exp_bat_id: —
Ns os sales shipping carriercustbody_ns_os_sales_shipping_carrier: —
Ns os sales shipping methodcustbody_ns_os_sales_shipping_method: —
Ns os sales warehouse namecustbody_ns_os_sales_warehouse_name: —
Nsts wodm credit memo typecustbody_nsts_wodm_credit_memo_type: —
Nsts wodm deduct mngmt idcustbody_nsts_wodm_deduct_mngmt_id: —
Pacejet batchidcustbody_pacejet_batchid: —
Pacejet cust parent linkcustbody_pacejet_cust_parent_link: —
Pacejet delivery instructionscustbody_pacejet_delivery_instructions: —
Pacejet freight costcustbody_pacejet_freight_cost: —
Pacejet freight costcurrencycustbody_pacejet_freight_costcurrency: —
Pacejet freight pricecustbody_pacejet_freight_price: —
Pacejet freight pricecurrencycustbody_pacejet_freight_pricecurrency: —
Pacejet freight servicecustbody_pacejet_freight_service: —
Pacejet freight termscustbody_pacejet_freight_terms: —
Pacejet freightacctoverridecustbody_pacejet_freightacctoverride: —
Pacejet int rqurlcustbody_pacejet_int_rqurl: —
Pacejet ship from overridecustbody_pacejet_ship_from_override: —
Pacejet timestampcustbody_pacejet_timestamp: —
Shopify order idcustbody_shopify_order_id: —
Shopify refund idcustbody_shopify_refund_id: —
Shopify storecustbody_shopify_store: —
Sourcesource: —
Walmart order idcustbody_walmart_order_id: —
Websitewebsite: —
Wms atlas reason for returncustbody_wms_atlas_reason_for_return: —
Wmsse freighttermscustbody_wmsse_freightterms: —
Wmsse ordertypecustbody_wmsse_ordertype: —
Wmsse thirdpartyaccountnumbercustbody_wmsse_thirdpartyaccountnumber: —
Woocom transaction idcustbody_woocom_transaction_id: —
Woocommerce coupon codecustbody_woocommerce_coupon_code: —
Woocommerce order idcustbody_woocommerce_order_id: —
Woocommerce order statuscustbody_woocommerce_order_status: —
Woorefundidcustbody_woorefundid: —

Custom fields

Custom fields · 110 fields · 33 with a value · 77 empty

15699 exclude from ep processcustbody_15699_exclude_from_ep_process: No
24custbody24: 0
25custbody25: 0
6custbody6: No
Address updatedcustbody_address_updated: No
Amz business ordercustbody_amz_business_order: No
Amz is premium ordercustbody_amz_is_premium_order: No
Amz is primecustbody_amz_is_prime: No
Awaiting inventorycustbody_awaiting_inventory: No
Call confirmedcustbody_call_confirmed: No
Can in houzzcustbody_can_in_houzz: No
Castlegate ordercustbodycastlegate_order: No
Comission paidcustbody_comission_paid: No
Mannycheckboxcustbodymannycheckbox: No
Order on holdcustbody_order_on_hold: No
Pj sscodcustbody_pj_sscod: No
Pj ssliftgatecustbody_pj_ssliftgate: No
Pj sssigreqcustbody_pj_sssigreq: No
Po acceptedcustbody_po_accepted: No
Report timestampcustbody_report_timestamp: 28/6/2024 11:6:48
Sale partnercustbody_sale_partner: Kemy E Lopez
Scpq trns sowo convertedcustbody_scpq_trns_sowo_converted: No
Send register requestcustbody_send_register_request: No
Sii article 61dcustbody_sii_article_61d: No
Sii article 72 73custbody_sii_article_72_73: No
Sii is third partycustbody_sii_is_third_party: No
Sii not reported in timecustbody_sii_not_reported_in_time: No
So line countcustbody_so_line_count: 3
So wo countcustbody_so_wo_count: 0
Time corder reatedcustbody_time_corder_reated: 14:06 PM
Walcommfeeaddcbcustbody_walcommfeeaddcb: No
Wm wfsordercustbody_wm_wfsorder: No
Wrm reg hid updateexpirecustbody_wrm_reg_hid_updateexpire: No

No value 77

2custbody2: —
22custbody22: —
23custbody23: —
3custbody3: —
4110 customregnumcustbody_4110_customregnum: —
7custbody7: —
Amz adjustment idcustbody_amz_adjustment_id: —
Amz fee stcustbody_amz_fee_st: —
Amz gift wrap chargescustbody_amz_gift_wrap_charges: —
Amz order setupcustbody_amz_order_setup: —
Amz order urlcustbody_amz_order_url: —
B2c ponumcustbody_b2c_ponum: —
Bol filecustbody_bol_file: —
Bol file urlcustbody_bol_file_url: —
Castlgate wsaidcustbody_castlgate_wsaid: —
Counterparty vatcustbody_counterparty_vat: —
Country of origincustbody_country_of_origin: —
Custbody order urlcustbodycustbody_order_url: —
Custbody sale partner cscustbodycustbody_sale_partner_cs: —
Doc num summ invoicecustbody_doc_num_summ_invoice: —
Establishment codecustbody_establishment_code: —
Hj tc asntypecustbodyhj_tc_asntype: —
Hj tc autopacktemplatecustbodyhj_tc_autopacktemplate: —
Hj tc dccodecustbodyhj_tc_dccode: —
Hj tc edideptnocustbodyhj_tc_edideptno: —
Hj tc markforcodecustbodyhj_tc_markforcode: —
Hj tc storecodecustbodyhj_tc_storecode: —
Hj tc udf1custbodyhj_tc_udf1: —
Hj tc udf2custbodyhj_tc_udf2: —
Hj tc udf3custbodyhj_tc_udf3: —
Hj tc udf4custbodyhj_tc_udf4: —
Hj tc udf5custbodyhj_tc_udf5: —
Houzz order idcustbody_houzz_order_id: —
Houzz storecustbody_houzz_store: —
Itr nexuscustbody_itr_nexus: —
Mode of transportcustbody_mode_of_transport: —
Nexus notccustbody_nexus_notc: —
Notccustbody_notc: —
Ns markerplace setupcustbody_ns_markerplace_setup: —
Order notescustbody_order_notes: —
Package height iftrancustbody_package_height_iftran: —
Package lengthcustbody_package_length: —
Package width iftranscustbody_package_width_iftrans: —
Po acceptidcustbody_po_acceptid: —
Product added on trancustbody_product_added_on_tran: —
Refno originvoicecustbody_refno_originvoice: —
Regime codecustbody_regime_code: —
Regime code of supplycustbody_regime_code_of_supply: —
Scpq iframecustbody_scpq_iframe: —
Scpq trns wos createdcustbody_scpq_trns_wos_created: —
Settlement idcustbody_settlement_id: —
Setup recordcustbody_setup_record: —
Sii code issued invcustbody_sii_code_issued_inv: —
Sii correction typecustbody_sii_correction_type: —
Sii exempt detailscustbody_sii_exempt_details: —
Sii external referencecustbody_sii_external_reference: —
Sii intra txn typecustbody_sii_intra_txn_type: —
Sii issued inv typecustbody_sii_issued_inv_type: —
Sii land registercustbody_sii_land_register: —
Sii orig invoicecustbody_sii_orig_invoice: —
Sii property locationcustbody_sii_property_location: —
Sii registration codecustbody_sii_registration_code: —
Sii registration msgcustbody_sii_registration_msg: —
Sii registration statuscustbody_sii_registration_status: —
Sii spcl scheme code salescustbody_sii_spcl_scheme_code_sales: —
So closed reasoncustbody_so_closed_reason: —
Ssp created fromcustbody_ssp_created_from: —
St amz settle idcustbody_st_amz_settle_id: —
Stc daysuntilexpirycustbody_stc_daysuntilexpiry: —
Sw related so numbercustbody_sw_related_so_number: —
Sw related wo numbercustbody_sw_related_wo_number: —
Transaction regioncustbody_transaction_region: —
Warehouse idcustbody_warehouse_id: —
Wf po numbercustbody_wf_po_number: —
Wm purchase idcustbody_wm_purchase_id: —
Wrm claimnumbercustbody_wrm_claimnumber: —
Wrm replacementsocustbody_wrm_replacementso: —

Others

Others · 22 fields · 14 with a value · 8 empty

Accountaccount: 11010 Total Accounts Receivable : Accounts Receivable
Canhavestackablecanhavestackable: Yes
Custpage taf subsidiarycachecustpage_taf_subsidiarycache: {"1":"US","5":"US","6":"US","3":"US","9":"US","2":"US","4":"US","7":"US","8":"US"}
Custpage wrm invoice warranty accesscustpage_wrm_invoice_warranty_access: Yes
Custpage wrm lineitem cachecustpage_wrm_lineitem_cache: {}
Finchrgfinchrg: No
Iseitf81oniseitf81on: No
Isfulfilledisfulfilled: Yes
Linkedrevrecjelinkedrevrecje: No
Postingperiodpostingperiod: Jun 2024
Ppsetbyuserppsetbyuser: No
Semailsemail: tbhplumbing@gmail.com
Sendorderfulfillmentemailsendorderfulfillmentemail: Yes
Tranline0 locationtranline0_location: 1

No value 8

Allownonglchangesallownonglchanges: —
Bulkprocsubmissionbulkprocsubmission: —
Intercotransactionintercotransaction: —
Periodclosedperiodclosed: —
Ppsetbyuservalueppsetbyuservalue: —
Previousopportunitypreviousopportunity: —
Tranline0 classtranline0_class: —
Tranline0 departmenttranline0_department: —

System & IDs

System & IDs · 111 fields · 32 with a value · 79 empty

Account refidaccount_refid: 122
Baserecordtypebaserecordtype: invoice
Createdfrom refidcreatedfrom_refid: 27790561
Currency refidcurrency_refid: 1
Customform refidcustomform_refid: 179
Dbstrantypedbstrantype: CustInvc
Editionedition: US
Entity refidentity_refid: 1957250
Entitynexus refidentitynexus_refid: 1
Entryformquerystringentryformquerystring: e=T&id=27824048
Haslineshaslines: Yes
Idid: 27824048
InternalIdInternalId: 27824048
Inventorydetailuitypeinventorydetailuitype: LOH_STRICT_VALIDATION
Location refidlocation_refid: 1
Nexus refidnexus_refid: 1
Nsts wodm write off limit refidcustbody_nsts_wodm_write_off_limit_refid: 1
Ntypentype: Invoice
Ntype refidntype_refid: 7
Orderleveldataorderleveldata: []
Originalnexus refidoriginalnexus_refid: 1
Postingperiod refidpostingperiod_refid: 130
Rectype 159 1115 maxnkeyrectype_159_1115_maxnkey: 0
Rectype 400 3093 maxnkeyrectype_400_3093_maxnkey: 7
Sale partner refidcustbody_sale_partner_refid: 167359
Salesrep refidsalesrep_refid: 1123
StatusRefstatusRef: paidInFull
Subsidiary refidsubsidiary_refid: 1
Tax affecting address fields before recalctax_affecting_address_fields_before_recalc: cityLittletonstateNCzip27850countryUS
Templatestoredtemplatestored: Yes
Typetype: custinvc
Versionversion: 2

No value 79

10184 customer entity bank refidcustbody_10184_customer_entity_bank_refid: —
2 refidcustbody2_refid: —
Amz order setup refidcustbody_amz_order_setup_refid: —
Billaddresslist refidbilladdresslist_refid: —
Bol file refidcustbody_bol_file_refid: —
Bulkbulk: —
Bulkprocsubmission refidbulkprocsubmission_refid: —
Class refidclass_refid: —
Couponcode refidcouponcode_refid: —
Custbody sale partner cs refidcustbodycustbody_sale_partner_cs_refid: —
Customwhencecustomwhence: —
Delivery terms refidcustbody_delivery_terms_refid: —
Department refiddepartment_refid: —
Discountitem refiddiscountitem_refid: —
Errornotificationsfielderrornotificationsfield: —
Expcostdiscount refidexpcostdiscount_refid: —
Expcosttaxcode refidexpcosttaxcode_refid: —
Hj tc asntype refidcustbodyhj_tc_asntype_refid: —
Hj tc autopacktemplate refidcustbodyhj_tc_autopacktemplate_refid: —
Houzz store refidcustbody_houzz_store_refid: —
Intercostatus refidintercostatus_refid: —
Intercotransaction refidintercotransaction_refid: —
Itemcostdiscount refiditemcostdiscount_refid: —
Itemcosttaxcode refiditemcosttaxcode_refid: —
Job refidjob_refid: —
Leadsource refidleadsource_refid: —
Messagesel refidmessagesel_refid: —
Mode of transport refidcustbody_mode_of_transport_refid: —
Nexus notc refidcustbody_nexus_notc_refid: —
Notc refidcustbody_notc_refid: —
Noticenotificationsfieldnoticenotificationsfield: —
Ns markerplace setup refidcustbody_ns_markerplace_setup_refid: —
Ns os sales setup rec id refidcustbody_ns_os_sales_setup_rec_id_refid: —
Nsbrowserenvnsbrowserenv: —
Nsts wodm credit memo type refidcustbody_nsts_wodm_credit_memo_type_refid: —
Nsts wodm deduct mngmt id refidcustbody_nsts_wodm_deduct_mngmt_id_refid: —
Opportunity refidopportunity_refid: —
Originatororiginator: —
Pacejet cust parent link refidcustbody_pacejet_cust_parent_link_refid: —
Pacejet freight terms refidcustbody_pacejet_freight_terms_refid: —
Pacejet freightacctoverride refidcustbody_pacejet_freightacctoverride_refid: —
Pacejet ship from override refidcustbody_pacejet_ship_from_override_refid: —
Packing slip file refidcustbody_packing_slip_file_refid: —
Partner refidpartner_refid: —
Promocode refidpromocode_refid: —
Regime code of supply refidcustbody_regime_code_of_supply_refid: —
Regime code refidcustbody_regime_code_refid: —
Selectedtabselectedtab: —
Setup record refidcustbody_setup_record_refid: —
Shadow shipaddressshadow_shipaddress: —
Shipaddresslist refidshipaddresslist_refid: —
Shipmethod refidshipmethod_refid: —
Shipping label file refidcustbody_shipping_label_file_refid: —
Shopify store refidcustbody_shopify_store_refid: —
Sii correction type refidcustbody_sii_correction_type_refid: —
Sii exempt details refidcustbody_sii_exempt_details_refid: —
Sii intra txn type refidcustbody_sii_intra_txn_type_refid: —
Sii issued inv type refidcustbody_sii_issued_inv_type_refid: —
Sii orig invoice refidcustbody_sii_orig_invoice_refid: —
Sii property location refidcustbody_sii_property_location_refid: —
Sii registration code refidcustbody_sii_registration_code_refid: —
Sii registration status refidcustbody_sii_registration_status_refid: —
Sii spcl scheme code sales refidcustbody_sii_spcl_scheme_code_sales_refid: —
So closed reason refidcustbody_so_closed_reason_refid: —
Sw related so number refidcustbody_sw_related_so_number_refid: —
Sw related wo number refidcustbody_sw_related_wo_number_refid: —
Synceventfieldsynceventfield: —
Terms refidterms_refid: —
Timediscount refidtimediscount_refid: —
Timetaxcode refidtimetaxcode_refid: —
Transaction region refidcustbody_transaction_region_refid: —
Trantypepermchecktrantypepermcheck: —
Warningnotificationsfieldwarningnotificationsfield: —
Wms atlas reason for return refidcustbody_wms_atlas_reason_for_return_refid: —
Wmsse freightterms refidcustbody_wmsse_freightterms_refid: —
Wmsse ordertype refidcustbody_wmsse_ordertype_refid: —
Wrm claimnumber refidcustbody_wrm_claimnumber_refid: —
Wrm replacementso refidcustbody_wrm_replacementso_refid: —
Wrm so returnauthorization refidcustbody_wrm_so_returnauthorization_refid: —