Total2,284.00US Dollar · Subtotal 2,284.00
Order dateJun 24, 2021Ship date Jun 27, 2021
LocationMiamiSpa World Corporation
Items33 related · 0 files
Open a line with + to see all of its information.
| # | Item | Description | Qty | Fulfilled | Rate | Amount | |
|---|---|---|---|---|---|---|---|
| 1 | 3060WISXRWNP | 3060WI: Right Drain: White: Soaker: ColorMatchTrim: Overflow | 1.00 | 1.00 | 2,284.00 | 2,284.00 | |
| 5 | FHC20174 | 4-Piece Roman Tub Faucet with Extendable Showerhead | 1.00 | 1.00 | 0.00 | 0.00 | |
| 6 | Free Shipping Item | 1.00 | 1.00 | 0.00 | 0.00 | ||
| Subtotal | 2,284.00 | ||||||
| Total | 2,284.00 | ||||||
General
General · 35 fields · 27 with a value · 8 empty
- Can be unapprovedcanbeunapproved
- No
- Checkcommittedcheckcommitted
- No
- Customer PO #otherrefnum
- MBSH3381Mueller
- Customformcustomform
- Spa World - Sales Order
- Isonlinetransactionisonlinetransaction
- No
- Istransformedbillistransformedbill
- No
- Istransformedtransactionistransformedtransaction
- No
- Linkedlinked
- Yes
- Locationlocation
- Miami
- Locationusesbinslocationusesbins
- Yes
- Nexus countrynexus_country
- US
- Order #tranid
- SOS2621418
- Order statusorderstatus
- Billed
- Originalnexusoriginalnexus
- United States FL
- Originalnexuscountryoriginalnexuscountry
- US
- Origstatusorigstatus
- G
- Recordcreatedbyrecordcreatedby
- 135227
- Statusstatus
- Billed
- Subsidiarysubsidiary
- Spa World Corporation
- Tax nexusnexus
- United States FL
- To be emailedtobeemailed
- No
- To be faxedtobefaxed
- No
- To be printedtobeprinted
- No
- Transactionnumbertransactionnumber
- SALESORD154671
- Voidedvoided
- No
- Warnnexuschangewarnnexuschange
- No
- Weekendpreferenceweekendpreference
- ASIS
No value 8
- Classclass
- —
- Created fromcreatedfrom
- —
- Departmentdepartment
- —
- Memomemo
- —
- Message to customermessage
- —
- Messageselmessagesel
- —
- Opportunityopportunity
- —
- Order typeordertype
- —
Customer
Customer · 29 fields · 19 with a value · 10 empty
- Balancebalance
- 3,599.00
- Companyidcompanyid
- 1718
- Credholdentitycredholdentity
- 1718
- Credholdoverridecredholdoverride
- Yes
- Credlimcredlim
- 25,000.00
- Custcurrepcustcurrep
- 588
- Customerentity
- 2304 Laz Distribution LLC
- Daysoverduedaysoverdue
- 3
- Emailemail
- sales@bathtubsplus.com
- Entity nexus countryentity_nexus_country
- US
- Entityfieldnameentityfieldname
- entity
- Entitynameentityname
- 2304 Laz Distribution LLC
- Entitynexusentitynexus
- United States FL
- Manualcreditholdmanualcredithold
- No
- Overallbalanceoverallbalance
- 3,599.00
- Overrideholdoverridehold
- No
- Overrideholdcheckedoverrideholdchecked
- No
- Prevrepprevrep
- 588
- Sales repsalesrep
- Mark Barnathan
No value 10
- 10184 customer entity bankcustbody_10184_customer_entity_bank
- —
- Customercodecustomercode
- —
- 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 · 41 fields · 18 with a value · 23 empty
- Carriercarrier
- nonups
- Hasfedexfreightservicehasfedexfreightservice
- No
- Itemshippingcostfxrateitemshippingcostfxrate
- 1
- Pj sssdeliverycustbody_pj_sssdelivery
- No
- Ship toshipaddress
- John Mueller Mueller & Sons 7 Ressler Rd Valatie NY 12184 (518) 755-4045
- Shipcompleteshipcomplete
- Yes
- Shipcountryshipcountry
- US
- Shipisresidentialshipisresidential
- No
- Shipoverrideshipoverride
- No
- Shippingaddress keyshippingaddress_key
- 4566825
- Shippingaddress textshippingaddress_text
- John Mueller Mueller & Sons 7 Ressler Rd Valatie NY 12184 (518) 755-4045
- 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
- NY
- Shipzipshipzip
- 12184
- Signaturerequiredsignaturerequired
- No
- Tracking numberslinkedtrackingnumbers
- TSE2924531
- Updatedropshiporderqtyupdatedropshiporderqty
- Yes
No value 23
- Amz shipment idcustbody_amz_shipment_id
- —
- Carrier codecustbody_carrier_code
- —
- Delivery termscustbody_delivery_terms
- —
- Doshippingrecalcdoshippingrecalc
- —
- Fedexservicenamefedexservicename
- —
- FOBfob
- —
- Isdefaultshippingrequestisdefaultshippingrequest
- —
- Overrideshippingcostoverrideshippingcost
- —
- 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
- —
- Sw ship to email addresscustbody_sw_ship_to_email_address
- —
- Tracking numbercustbody_tracking_number
- —
Billing
Billing · 12 fields · 8 with a value · 4 empty
- Address country state mapaddress_country_state_map
- [276452:US_NY][272128:US_CO][1516037:US_CO][794547:US_TX][1834027:US_CA][960489:US_NV][1733498:US_FL][1851429:US_CA][1886486:US_FL][1845797:US_SC][1856865:US_MD][1913398:US_PA][1827769:US_FL][1827766:US_MO][1827768:US_FL][186986:US_MA][1612443:US_OR][1612340:US_WA][1622262:US_CO][1612341:US_GA][1607648:US_NY][1612445:US_OH][1622261:US_CA][1612442:US_CO][1607649:US_IL][1791890:US_NC][1780738:US_TX][2003622:US_MS][1626432:US_PA][1080056:US_FL][975062:US_NV][5131:US_NY][4140:US_NY][4141:US_NY][1308403:US_NJ][1442881:US_NY][586820:US_MO][1314341:US_MI][130783:US_TN][1941322:US_CA][1952964:US_NC][1963249:US_FL][1941323:US_NH][1883:US_NY][1884:US_NY][1079745:US_FL][2167155:US_VA][2137246:US_TX][2078566:US_TN][2167159:US_NC][2292646:US_AZ][2276433:US_CA][2316644:US_AR][2373543:US_TX][2406076:US_NC][2406077:US_CA][7918919:US_MS][7939270:US_MI][8052916:US_PA][7938250:US_FL][7911063:US_TX][7918816:US_SC][8053121:US_NJ][7995107:US_MD][7887293:US_VA][8234048:US_OH][8170719:US_AZ][8121724:US_WI][8246028:US_NJ][8072821:US_TX][8256072:US_CO][7887899:US_SC][8201306:US_WA][8245418:US_MD][7887796:US_CA][7887694:US_CA][8022532:US_OH][8235677:US_FL][8997540:US_AZ][8790855:US_NY][8967961:US_NM][8792475:US_LA][9029927:US_CA][8790552:US_CA][9030028:US_NY][8793285:US_AL][8793793:US_MI][8793794:US_NY][8661049:US_MI][8860592:US_GA][8825967:US_TX][8805564:US_MD][8691604:US_FL][8878933:US_AZ][8517255:US_MI][8611238:US_NV][8487697:US_VA][8570326:US_NY][8265728:US_NC][8547791:US_CA][8556039:US_IL][8265832:US_FL][8509013:US_NY][8570429:US_ID][8546767:US_WV][8570427:US_MA][8497451:US_TX][8400654:US_MI][8400653:US_TX][8430847:US_FL][8431557:US_FL][8300411:US_TX][8380566:US_TX][8447950:US_MA][8448354:US_MA][8364561:US_NY][8430844:US_TX][8451410:US_NY][8300616:US_WY][8300512:US_CA][8300513:US_NJ][8467712:US_FL][2641731:US_CA][2580516:US_CA][2586140:US_NJ][2717616:US_NJ][2615379:US_TX][2600697:US_NJ][2600698:US_NJ][2615378:US_SC][2557821:US_IL][2636494:US_MA][2973358:US_WA][2885199:US_MN][2885200:US_CA][2934407:US_PA][2873553:US_MA][2873554:US_IA][2985134:US_OH][2866426:US_PA][2920069:US_NY][2879785:US_MT][2985033:US_OH][2973357:US_AR][2866325:US_TX][3182914:US_IL][2914738:US_AZ][2978701:US_CO][3429179:US_NY][3276845:US_VA][3285892:US_PA][3327340:US_AZ][3347280:US_WI][3372664:US_CA][3372767:US_NM][3286094:US_NJ][3327236:US_AL][3420543:US_CA][3580164:US_OH][3848105:US_FL][3580874:US_MI][3513540:US_MN][3695490:US_IN][3628980:US_FL][3589027:US_FL][4199933:US_FL][4144712:US_NV][3947888:US_WI][4156909:US_WA][4208078:US_KS][4241065:US_NC][4263224:US_NY][4318977:US_MN][3947885:US_MO][4596312:US_MD][4405961:US_NY][4465777:US_TX][4589912:US_CA][4596308:US_MD][4466188:US_VA][4714579:US_TX][4472453:US_CO][4386979:US_MD][4796734:US_WA][4825469:US_NM][5392700:US_OK][5450813:US_CO][5567531:US_WA][5285200:US_MI][5525711:US_AL][5277820:US_PA][5126101:US_MA][5486437:US_FL][5248597:US_TN][5144509:US_SC][5477991:US_MO][5470523:US_IL][5569877:US_MT][5524386:US_IL][5533374:US_WA][5775518:US_CA][5775619:US_AZ][5785585:US_FL][5689870:US_KY][5664772:US_TX][5730832:US_MN][5917346:US_MD][5606179:US_CA][5730833:US_DE][5873371:US_VA][5882717:US_AR][5620447:US_TX][5944605:US_AR][5936158:US_FL][5721447:US_PA][5682022:US_CA][5906786:US_AL][5926802:US_FL][5927003:US_FL][5710984:US_WA][5710376:US_MI][5664775:US_CA][5873270:US_CA][5882821:US_TX][5612156:US_MD][5917035:US_TX][5797243:US_NJ][5710986:US_WA][5636776:US_CA][5657028:US_IL][5967158:US_TX][5997836:US_KY][6164125:US_PA][6239795:US_KY][6195288:US_AZ][6103562:US_IL][6195185:US_TX][6261022:US_TX][6054388:US_ID][6292549:US_WY][6350354:US_RI][6316814:US_OR][6124269:US_AL][6032960:US_VA][6164124:US_VA][6349942:US_IL][6240206:US_MI][6133509:US_VA][6154772:US_CA][6260821:US_CA][6280034:US_TX][6133306:US_KS][6103563:US_TX][6357913:US_IL][6124268:US_LA][6292550:US_AL][6053976:US_CO][6164123:US_WA][6175587:US_CA][6296867:US_FL][6219252:US_NJ][6219656:US_NM][6114513:US_WA][6905111:US_VA][6737730:US_WA][6777606:US_MO][6848555:US_MA][6939631:US_LA][7001656:US_PA][6795714:US_CO][7011916:US_TX][6882698:US_TX][6811213:US_MI][6786749:US_TX][6930513:US_PA][6811414:US_MA][6811415:US_SC][6984135:US_TX][6984241:US_AL][6954737:US_MI][6848656:US_CT][6757237:US_NJ][7001657:US_WA][6848759:US_OR][6848760:US_RI][6883938:US_AZ][6930518:US_FL][6745894:US_NM][6786747:US_IL][6786750:US_NY][6795405:US_WA][6557132:US_VA][6393680:US_AL][6416747:US_CT][6586392:US_CA][6467577:US_FL][6459291:US_IL][6442579:US_MI][6608283:US_MA][6634128:US_TX][6519147:US_KY][6630992:US_FL][6519040:US_MI][6459701:US_CA][6459397:US_CA][6634131:US_ND][6416642:US_OH][6672290:US_TX][6625970:US_OH][6625973:US_TN][6634233:US_NY][6408499:US_MA][6586700:US_AL][6566487:US_GA][6475113:US_FL][6527903:US_CA][6393677:US_VA][6401044:US_GA][6690284:US_MI][6441754:US_KY][6549077:US_IL][6503235:US_TX][6634127:US_TX][6672288:US_WA][6672084:US_FL][6643020:US_ID][6393881:US_OH][6493866:US_AZ][6643635:US_TX][6625768:US_VA][6681341:US_TX][6663402:US_NJ][6519146:US_CA][7655260:US_FL][7738850:US_NV][7655361:US_KS][7527483:US_TX][7693434:US_IL][7719888:US_SC][7536331:US_PA][7798230:US_TX][7654540:US_MN][7654955:US_GA][7719880:US_TX][7703091:US_FL][7806262:US_GA][7806671:US_VA][7655259:US_CT][7492724:US_CA][7693536:US_NY][7784248:US_CA][7738646:US_TX][7852053:US_WV][7806563:US_IN][7798127:US_DE][7503976:US_CA][7738848:US_MD][7513920:US_CA][7655057:US_FL][7514925:US_SC][7503977:US_PA][7813610:US_ID][7654952:US_CA][7654543:US_GA][7694153:US_MI][7852052:US_VA][7503978:US_IN][7654848:US_TN][7536435:US_WA][7514422:US_NC][7527380:US_TX][7492411:US_AZ][7654544:US_TN][7492719:US_GA][7703196:US_CA][7654545:US_AL][7654846:US_CA][9322488:US_FL][9422938:US_TX][9383000:US_FL][9330435:US_CA][9359253:US_FL][9349888:US_FL][9370530:US_IL][9393370:US_FL][9422834:US_KY][9422936:US_MO][9422122:US_WA][9068737:US_CO][9330436:US_AZ][9138140:US_WA][9040686:US_OR][9101426:US_FL][9040683:US_GA][9171059:US_MO][9212469:US_NY][9259065:US_KY][9040579:US_NY][7116408:US_MI][7298130:US_TX][7354483:US_LA][7287438:US_TX][7129205:US_PA][7298439:US_CA][7298440:US_AZ][7120254:US_NY][7287957:US_FL][7421828:US_OH][7253135:US_OH][7443145:US_FL][7129004:US_TX][7166274:US_VA][7232531:US_IN][7451910:US_NJ][7287954:US_NV][7432490:US_NM][7138739:US_CA][7451911:US_LA][7320353:US_ID][7331906:US_TX][7109975:US_WY][7120253:US_MD][7056161:US_IL][7253851:US_IL][7432491:US_OH][7386722:US_CA][7386823:US_TN][7109976:US_OH][7232838:US_NJ][7353562:US_VA][7109977:US_MI][7253849:US_CA][7156706:US_NJ][7288360:US_MO][7421624:US_NY][7288464:US_FL][7232636:US_AL][7287955:US_WA][7396780:US_IN][9447871:US_NC][9558611:US_CA][9516904:US_PA][9558813:US_OK][9656513:US_VA][9557273:US_WA][9656306:US_MI][9557674:US_FL][9577516:US_FL][9534012:US_FL][9587295:US_AL][9557676:US_FL][9656205:US_TX][9748346:US_OH][9748453:US_AL][9680271:US_OK][9711935:US_NJ][9712240:US_IL][9690929:US_MI][9783512:US_FL][9506332:US_SC][9459326:US_PA][9761299:US_FL][9701772:US_FL][9711936:US_CO][9506331:US_FL][9935942:US_NM][9821947:US_MT][9836306:US_ID][9874673:US_GA][11432492:US_VA][11432387:US_AL][11432390:US_WI][11432389:US_OR][11444857:US_MO][11432388:US_IN][11824626:US_TN][11908046:US_TN][11551499:US_CA][11551701:US_MO][11530786:US_NM][11582073:US_IN][11551500:US_OH][11986573:US_TX][12426251:US_NY][12368550:US_VA][12426552:US_OH][12368549:US_KY][12368851:US_MN][12017861:US_TX][12114657:US_FL][13011166:US_CA][13043263:US_FL][13053118:US_AZ][13087732:US_KS][13011167:US_CO][13210614:US_TX][13021126:US_TX][13148192:US_IL][13220081:US_NY][13011268:US_VA][13191919:US_NY][13139534:US_IL][13386664:US_NC][13419497:US_WI][13428550:US_TN][12737551:US_AZ][12746270:US_NY][12711522:US_NY][12746069:US_NY][12821598:US_OH][12808528:US_IL][12808830:US_NY][12544016:US_MS][12795866:US_NC][12711623:US_AR][12606526:US_WI][12962776:US_CA][12973736:US_PA][12973737:US_MN][12941464:US_CO][12886174:US_OH][12530258:US_CA][13679723:US_AL][13631826:US_CA][13554751:US_MO][13679824:US_FL][13680026:US_SC][13589518:US_FL][14016914:US_RI][13940639:US_WA][13978182:US_MI][5132:US_NY]
- Bill tobilladdress
- Laz Distribution LLC 2215 Nott St. #177 Niskayuna NY 12309
- Billaddresslistbilladdresslist
- PO Box 9316
- Billingaddress keybillingaddress_key
- 592861
- Billingaddress textbillingaddress_text
- Laz Distribution LLC 2215 Nott St. #177 Niskayuna NY 12309
- 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 4
- Billingaddress defaultvaluebillingaddress_defaultvalue
- —
- Defaultaddrbookdefaultaddrbook
- —
- Defaultaddresseedefaultaddressee
- —
- Previous billaddresslistprevious_billaddresslist
- —
Amounts & tax
Amounts & tax · 61 fields · 40 with a value · 21 empty
- Balreadyrefundedbalreadyrefunded
- No
- Currencycurrency
- US Dollar
- Currencynamecurrencyname
- US Dollar
- Currencyprecisioncurrencyprecision
- 2
- Currencysymbolcurrencysymbol
- USD
- Disablepromotionrecalcdisablepromotionrecalc
- No
- Discdaysdiscdays
- 10
- Discount totaldiscounttotal
- 0.00
- Discpctdiscpct
- 2.00
- Duedaysduedays
- 30
- Estgrossprofitestgrossprofit
- 2,165.22
- Estgrossprofitpercentestgrossprofitpercent
- 94.80
- Exchange rateexchangerate
- 1.00
- Installmentcountinstallmentcount
- 0
- Isbasecurrencyisbasecurrency
- Yes
- Iseditbilledtransactionwithpromotioniseditbilledtransactionwithpromotion
- No
- Isinstallmentisinstallment
- No
- Islegacypromoislegacypromo
- No
- Linkedclosedperioddiscountslinkedclosedperioddiscounts
- No
- Mindaysmindays
- 0
- Oldrevenuecommitmentoldrevenuecommitment
- No
- Origcurrencyorigcurrency
- 1
- Origexchangerateorigexchangerate
- 1.00
- Origtotalorigtotal
- 2,284.00
- Origtotal2origtotal2
- 2,284.00
- Overallunbilledordersoverallunbilledorders
- 3,910.31
- Payment termsterms
- 2% 10 Net 30
- Persistedtermspersistedterms
- 6
- Primarycurrencyprimarycurrency
- 1.00
- Primarycurrencyfxrateprimarycurrencyfxrate
- 1.00
- Promotionappliedpromotionapplied
- No
- Stc amount after discountcustbody_stc_amount_after_discount
- 2,238.32
- Stc discountpercentcustbody_stc_discountpercent
- 2.00
- Stc tax after discountcustbody_stc_tax_after_discount
- 0.00
- Stc total after discountcustbody_stc_total_after_discount
- 2,238.32
- Subtotalsubtotal
- 2,284.00
- Tax totaltaxtotal
- 0.00
- Totaltotal
- 2,284.00
- Totalcostestimatetotalcostestimate
- 118.78
- Unbilledordersunbilledorders
- 3,910.31
No value 21
- Amz discount totalcustbody_amz_discount_total
- —
- Amz total taxcustbody_amz_total_tax
- —
- Automaticallyapplypromotionsautomaticallyapplypromotions
- —
- Automaticallyapplypromotionsassociatedmessageautomaticallyapplypromotionsassociatedmessage
- —
- Couponcodecouponcode
- —
- Discountastotaldiscountastotal
- —
- Discountistaxablediscountistaxable
- —
- Discountitemdiscountitem
- —
- Discountratediscountrate
- —
- Discounttax1amountdatadiscounttax1amountdata
- —
- Discounttax2amountdatadiscounttax2amountdata
- —
- Intercostatusintercostatus
- —
- Ns refund idcustbody_ns_refund_id
- —
- Persistedpromocodepersistedpromocode
- —
- Promo codepromocode
- —
- Promocodepluginimplpromocodepluginimpl
- —
- Promodiscountpromodiscount
- —
- Promotionidspromotionids
- —
- St amountcustbody_st_amount
- —
- Taxamount2overridetaxamount2override
- —
- Taxamountoverridetaxamountoverride
- —
Payment
Payment · 32 fields · 6 with a value · 26 empty
- Getauthgetauth
- No
- Isrecurringpaymentisrecurringpayment
- No
- Paymentcancelablepaymentcancelable
- No
- Paymentprocessingmodepaymentprocessingmode
- SAVE_ONLY
- Paymentsessionamountpaymentsessionamount
- 2,284.00
- Threedstatuscodevisthreedstatuscodevis
- No
No value 26
- Applied depositscustbody_applied_deposits
- —
- Authcodeauthcode
- —
- Authorizedamountauthorizedamount
- —
- Collectedamountcollectedamount
- —
- Expectedpaymentstatusexpectedpaymentstatus
- —
- Inputpnrefnuminputpnrefnum
- —
- Ispaymethundepfundsispaymethundepfunds
- —
- Payment methodcustbody_payment_method
- —
- Payment methodpaymentmethod
- —
- Paymenteventholdreasonpaymenteventholdreason
- —
- Paymenteventpurchasedatasentpaymenteventpurchasedatasent
- —
- Paymenteventresultpaymenteventresult
- —
- Paymenteventtypepaymenteventtype
- —
- Paymenteventupdatedbypaymenteventupdatedby
- —
- Paymentmethodtypeidpaymentmethodtypeid
- —
- Paymentoperationpaymentoperation
- —
- Paymentrequestidpaymentrequestid
- —
- Paymentsessionpaymentsession
- —
- Paymethacctpaymethacct
- —
- Paymethtypepaymethtype
- —
- Payout idcustbody_payout_id
- —
- Pnrefnumpnrefnum
- —
- Reimbursedamountreimbursedamount
- —
- Stc payment transaction idcustbody_stc_payment_transaction_id
- —
- Threedstatuscodethreedstatuscode
- —
- Wrm so returnauthorizationcustbody_wrm_so_returnauthorization
- —
Dates
Dates · 31 fields · 12 with a value · 19 empty
- Approval datecustbody_approval_date
- 6/24/2021 9:39 am
- Createdcreateddate
- 6/24/2021 9:38 am
- Datedrivendatedriven
- No
- Esc created datecustbody_esc_created_date_dt
- Jun 24, 2021
- Esc last modified datecustbody_esc_last_modified_date_dt
- Jun 30, 2021
- Last modifiedlastmodifieddate
- 6/30/2021 4:55 pm
- Order datetrandate_dt
- Jun 24, 2021
- Prevdateprevdate_dt
- Jun 24, 2021
- Recordcreateddaterecordcreateddate
- 06/24/2021 06:38:57
- Saleseffectivedatesaleseffectivedate_dt
- Jun 24, 2021
- Ship dateshipdate_dt
- Jun 27, 2021
- So formula ship datecustbody_so_formula_ship_date_dt
- Jul 5, 2021
No value 19
- 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
- —
- Date of taxable supplycustbody_date_of_taxable_supply_dt
- —
- Document datecustbody_document_date_dt
- —
- End dateenddate_dt
- —
- Estimated ship datecustbody_estimated_ship_date
- —
- Fba ship datecustbody_fba_ship_date
- —
- Paymenteventdatepaymenteventdate
- —
- Po date for invoicecustbody_po_date_for_invoice_dt
- —
- Sii operation datecustbody_sii_operation_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 · 79 fields · 27 with a value · 52 empty
- Amazon fbacustbody_amazon_fba
- No
- Amazon prime sfcustbody_amazon_prime_sf
- No
- Cancel order in ebaycustbody_cancel_order_in_ebay
- No
- Export to shopifycustbody_export_to_shopify
- No
- Externalidexternalid
- MBSH3381Mueller
- Is ebay ordercustbody_is_ebay_order
- No
- Issynchedcustbody_issynched
- No
- Ns os sales shipments exportdcustbody_ns_os_sales_shipments_exportd
- No
- Ns os sales shipping carriercustbody_ns_os_sales_shipping_carrier
- UPS
- Nsts wodm is chargebackcustbody_nsts_wodm_is_chargeback
- No
- Nsts wodm on holdcustbody_nsts_wodm_on_hold
- No
- Pacejet freight termscustbody_pacejet_freight_terms
- Third Party Billing
- Refund to shopifycustbody_refund_to_shopify
- No
- Shopify order cancelledcustbody_shopify_order_cancelled
- No
- Sourcesource
- CSV
- Storeorderstoreorder
- No
- Webstorewebstore
- 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 52
- 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
- —
- 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 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
- —
- Nsts wodm write off amountcustbody_nsts_wodm_write_off_amount
- —
- Nsts wodm write off limitcustbody_nsts_wodm_write_off_limit
- —
- Nsts wodm write off percentcustbody_nsts_wodm_write_off_percent
- —
- 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 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
- —
- 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 · 32 with a value · 78 empty
- 15699 exclude from ep processcustbody_15699_exclude_from_ep_process
- No
- 25custbody25
- 2
- 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
- 24/06/2021 06:38:55
- Sale partnercustbody_sale_partner
- Mark Barnathan
- 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 wo countcustbody_so_wo_count
- 1
- Stc daysuntilexpirycustbody_stc_daysuntilexpiry
- 10
- Time corder reatedcustbody_time_corder_reated
- 09:06 AM
- Walcommfeeaddcbcustbody_walcommfeeaddcb
- No
- Wm wfsordercustbody_wm_wfsorder
- No
- Wrm reg hid updateexpirecustbody_wrm_reg_hid_updateexpire
- No
No value 78
- 2custbody2
- —
- 22custbody22
- —
- 23custbody23
- —
- 24custbody24
- —
- 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
- —
- So line countcustbody_so_line_count
- —
- Ssp created fromcustbody_ssp_created_from
- —
- St amz settle idcustbody_st_amz_settle_id
- —
- 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 · 7 fields · 5 with a value · 2 empty
- Canhavestackablecanhavestackable
- Yes
- Ignoreavsignoreavs
- No
- Ignoreavsvisignoreavsvis
- No
- Iseitf81oniseitf81on
- No
- Linkedrevrecjelinkedrevrecje
- No
No value 2
- Intercotransactionintercotransaction
- —
- Previousopportunitypreviousopportunity
- —
System & IDs
System & IDs · 118 fields · 43 with a value · 75 empty
- Baserecordtypebaserecordtype
- salesorder
- Billaddresslist refidbilladdresslist_refid
- 5131
- Bnopostmainbnopostmain
- Yes
- Currency refidcurrency_refid
- 1
- Customform refidcustomform_refid
- 157
- Dbstrantypedbstrantype
- SalesOrd
- Editionedition
- US
- Entity refidentity_refid
- 1718
- Entitynexus refidentitynexus_refid
- 1
- Entryformquerystringentryformquerystring
- e=T&id=8931450
- Haslineshaslines
- Yes
- Idid
- 8931450
- InternalIdInternalId
- 8931450
- Inventorydetailuitypeinventorydetailuitype
- LOH_LOOSE_VALIDATION
- Location refidlocation_refid
- 1
- Methodrequireslineleveldatamethodrequireslineleveldata
- No
- Nexus refidnexus_refid
- 1
- Ntypentype
- Sales Order
- Ntype refidntype_refid
- 31
- Orderleveldataorderleveldata
- []
- Orderstatus refidorderstatus_refid
- G
- Ordrecvdordrecvd
- Yes
- Originalnexus refidoriginalnexus_refid
- 1
- Originatororiginator
- CSV
- Pacejet freight terms refidcustbody_pacejet_freight_terms_refid
- 3
- Paymenteventmagiczerousedpaymenteventmagiczeroused
- No
- Profilesupportslineleveldataprofilesupportslineleveldata
- No
- Rectype 1206 9427 maxnkeyrectype_1206_9427_maxnkey
- 0
- Rectype 1207 9560 maxnkeyrectype_1207_9560_maxnkey
- 0
- Rectype 1221 9883 maxnkeyrectype_1221_9883_maxnkey
- 0
- Rectype 1224 9977 maxnkeyrectype_1224_9977_maxnkey
- 905
- Rectype 159 1115 maxnkeyrectype_159_1115_maxnkey
- 0
- Rectype 400 3093 maxnkeyrectype_400_3093_maxnkey
- 7
- Sale partner refidcustbody_sale_partner_refid
- 588
- Salesrep refidsalesrep_refid
- 588
- StatusRefstatusRef
- fullyBilled
- Subsidiary refidsubsidiary_refid
- 1
- Suppressusereventsandemailssuppressusereventsandemails
- No
- Tax affecting address fields before recalctax_affecting_address_fields_before_recalc
- cityValatiestateNYzip12184countryUS
- Templatestoredtemplatestored
- Yes
- Terms refidterms_refid
- 6
- Typetype
- salesord
- Versionversion
- 6
No value 75
- 10184 customer entity bank refidcustbody_10184_customer_entity_bank_refid
- —
- 2 refidcustbody2_refid
- —
- Amz order setup refidcustbody_amz_order_setup_refid
- —
- Bol file refidcustbody_bol_file_refid
- —
- Bulkbulk
- —
- Class refidclass_refid
- —
- Couponcode refidcouponcode_refid
- —
- Createdfrom refidcreatedfrom_refid
- —
- Custbody sale partner cs refidcustbodycustbody_sale_partner_cs_refid
- —
- Customwhencecustomwhence
- —
- Delivery terms refidcustbody_delivery_terms_refid
- —
- Department refiddepartment_refid
- —
- Discountitem refiddiscountitem_refid
- —
- Errornotificationsfielderrornotificationsfield
- —
- 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
- —
- 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
- —
- Nsts wodm write off limit refidcustbody_nsts_wodm_write_off_limit_refid
- —
- Opportunity refidopportunity_refid
- —
- Ordertype refidordertype_refid
- —
- Pacejet cust parent link refidcustbody_pacejet_cust_parent_link_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
- —
- Paymenteventholdreason refidpaymenteventholdreason_refid
- —
- Paymenteventresult refidpaymenteventresult_refid
- —
- Paymentmethod refidpaymentmethod_refid
- —
- Paymentoperation refidpaymentoperation_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
- —
- 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
- —
No field matches your search.
Fields without a value are shown as “—”. Payment card fields are never shown.
No files are attached to this order.