Total859.88US Dollar · Subtotal 859.88
Order dateAug 27, 2023Ship date Aug 28, 2023
LocationMiamiSpa World Corporation
Items14 related · 0 files
Open a line with + to see all of its information.
| # | Item | Description | Qty | Fulfilled | Rate | Amount | |
|---|---|---|---|---|---|---|---|
| 1 | TL-STSF851WH | Envo 1-Piece 1.26 GPF Single Flush Elongated Smart Toilet and Bidet in White | 1.00 | 1.00 | 859.88 | 859.88 | |
| Subtotal | 859.88 | ||||||
| Total | 859.88 | ||||||
General
General · 35 fields · 27 with a value · 8 empty
- Can be unapprovedcanbeunapproved
- No
- Checkcommittedcheckcommitted
- No
- Customer PO #otherrefnum
- 83572611
- Customformcustomform
- Spa World - Sales Order
- Isonlinetransactionisonlinetransaction
- No
- Istransformedbillistransformedbill
- No
- Istransformedtransactionistransformedtransaction
- No
- Linkedlinked
- Yes
- Locationlocation
- Miami
- Locationusesbinslocationusesbins
- Yes
- Nexus countrynexus_country
- US
- Order #tranid
- SOS2817206
- Order statusorderstatus
- Billed
- Originalnexusoriginalnexus
- United States FL
- Originalnexuscountryoriginalnexuscountry
- US
- Origstatusorigstatus
- G
- Recordcreatedbyrecordcreatedby
- 2015389
- Statusstatus
- Billed
- Subsidiarysubsidiary
- Spa World Corporation
- Tax nexusnexus
- United States FL
- To be emailedtobeemailed
- No
- To be faxedtobefaxed
- No
- To be printedtobeprinted
- No
- Transactionnumbertransactionnumber
- SALESORD350459
- 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 · 18 with a value · 11 empty
- Balancebalance
- 3,088,094.61
- Companyidcompanyid
- 49
- Credholdentitycredholdentity
- 49
- Credholdoverridecredholdoverride
- Yes
- Custcurrepcustcurrep
- 1168891
- Customerentity
- 5001 Home Depot.com
- Daysoverduedaysoverdue
- 175
- Emailemail
- info@homedepot.com
- Entity nexus countryentity_nexus_country
- US
- Entityfieldnameentityfieldname
- entity
- Entitynameentityname
- 5001 Home Depot.com
- Entitynexusentitynexus
- United States FL
- Manualcreditholdmanualcredithold
- No
- Overallbalanceoverallbalance
- 3,088,094.61
- Overrideholdoverridehold
- No
- Overrideholdcheckedoverrideholdchecked
- No
- Prevrepprevrep
- 1168891
- Sales repsalesrep
- Danny Cruz
No value 11
- 10184 customer entity bankcustbody_10184_customer_entity_bank
- —
- Credlimcredlim
- —
- 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 · 19 with a value · 22 empty
- Carriercarrier
- nonups
- Hasfedexfreightservicehasfedexfreightservice
- No
- Itemshippingcostfxrateitemshippingcostfxrate
- 1
- Pj sssdeliverycustbody_pj_sssdelivery
- No
- Ship methodshipmethod
- UPS Ground
- Ship toshipaddress
- Elias Ramos 38215 47TH ST EAST C/O THD Ship to Store #6883 PALMDALE CA 93552 (661) 285-3252
- Shipcompleteshipcomplete
- Yes
- Shipcountryshipcountry
- US
- Shipisresidentialshipisresidential
- No
- Shipoverrideshipoverride
- No
- Shippingaddress keyshippingaddress_key
- 11848553
- Shippingaddress textshippingaddress_text
- Elias Ramos 38215 47TH ST EAST C/O THD Ship to Store #6883 PALMDALE CA 93552 (661) 285-3252
- 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
- CA
- Shipzipshipzip
- 93552
- Signaturerequiredsignaturerequired
- No
- Tracking numberslinkedtrackingnumbers
- 150-8164616-6
- Updatedropshiporderqtyupdatedropshiporderqty
- Yes
No value 22
- 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 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
- [303455:US_WA][303459:US_CA][251838:US_CT][245856:US_MI][272432:US_MA][243441:US_FL][1520574:US_MN][1520886:US_PA][972934:US_TX][45132:US_FL][89541:CA_ON][102706:US_NY][45947:US_NY][95874:US_MD][89133:US_NY][1939798:US_AR][436572:US][90749:US_CA][204453:US_MT][237904:US_NM][193024:US_FL][176729:US_MA][233281:US_MD][182568:US][222945:US_CT][237906:US_NC][187798:US_FL][236996:US_NC][182770:US][1607753:US_VA][1623679:US_NC][1609376:US_NV][465556:US_CO][1816960:US_CT][1672008:US_WV][395277:US_CO][359755:US_MN][1071106:US_TX][1096326:US_PA][855371:US_AZ][1155017:US_PA][1123067:US_CT][1136229:US_NY][6023:US_FL][6024:US_GA][1452258:US_CO][1435015:US_WV][1709947:US_TX][2:US_GA][138329:US_NJ][109232:US_VA][155413:US_WI][159452:US_NJ][626573:US_CA][353820:US_AZ][314635:US_WA][353716:US_WA][326508:US_PA][8732:US_WA][14337:US_PA][11112:US_WA][1364909:US_MD][1365114:US_MD][1364910:US_MD][1365113:US_MD][1979433:US_TX][1912995:US_OH][1912893:US_CO][1979230:US_WA][1809:US_FL][1810:US_FL][546925:US_GA][2055890:US_ND][2317053:US_CO][2247710:US_MI][2287413:US_TX][2247709:US_FL][2280767:US_OK][2382707:US_CA][2405071:US_NM][2465049:US_UT][2465050:US_UT][8178063:US_MO][7891412:US_IL][7995105:US_FL][8078431:US_MO][7963175:US_CA][8110042:US_CA][8060652:US_AZ][7891515:US_WA][8236079:US_IN][8199284:US_ID][7891513:US_TX][8053122:US_GA][8241194:US_MO][7891514:US_CA][8030465:US_NC][8078028:US_GA][8146683:US_FL][8110041:US_MN][8199387:US_NY][8236181:US_CA][7909539:US_PA][7946078:US_VA][8236183:US_TX][8919721:US_CA][8677522:US_MN][8677523:US_MN][8931121:US_FL][8995414:US_AK][8995415:US_AK][8953066:US_TN][8887529:US_CA][8953367:US_TX][8656700:US_UT][8919519:US_CO][8919520:US_NV][8953062:US_NY][8897277:US_AZ][8966949:US_IA][8967356:US_LA][8995817:US_VA][8896773:US_OH][9025778:US_OH][8760569:US_MD][8789112:US_ME][8789113:US_FL][8789117:US_MA][8789118:US_TN][8789116:US_MD][8760570:US_CA][8656801:US_WI][8716343:US_NV][8801525:US_TX][8815813:US_NY][8870777:US_PA][8806172:US_FL][8855322:US_OR][8855320:US_IL][8825055:US_LA][8866020:US_AZ][8866013:US_NC][8875385:US_PA][8486375:US_AL][8616542:US_OH][8571332:US_PA][8547179:US_RI][8606611:US_MD][8625780:US_PA][8546768:US_IN][8547286:US_MS][8553009:US_OH][8266436:US_IL][8599999:US_PA][8546765:US_KY][8606301:US_NJ][8571331:US_GA][8364559:US_MS][8364558:US_FL][8380565:US_TX][8380568:US_WA][8428324:US_CA][8299705:US_CO][8311796:US_KY][8407177:US_CT][8301942:US_WA][8320730:US_GA][8460575:US_CO][8364557:US_FL][8311695:US_WA][8299707:US_IL][2645863:US_MO][2511117:US][2642137:US_MS][2548036:US_AL][3115909:US_NM][3372871:US_TX][3207479:US_FL][3347887:US_MS][3472241:US_WA][3472242:US_WA][3207476:US_IL][3207478:US_UT][3372769:US_VA][3384039:US_MO][3486907:US_WA][3345258:US_TX][3842876:US_AL][3629082:US_TN][3629083:US_TN][3629084:US_TN][3729097:US_ID][3781712:US_WA][3629085:US_TN][3842775:US_AL][3522697:US_MI][3644693:US_NJ][3578330:US_AR][3788346:US_OH][3880136:US_TN][4269858:US_NJ][4159644:US_NM][4485885:US_NY][4458948:US_CA][4472038:US_TX][4362094:US_TN][4631702:US_WA][4502254:US_MI][4669849:US_NM][4472037:US_TX][4523163:US_LA][4482835:US_NE][4501432:US_CA][4706265:US_FL][4478514:US_HI][4688354:US_TX][4688355:US_NC][4334240:US_CA][4501431:US_CA][4514764:US_GA][4471829:US_CA][4471831:US_CA][4764536:US_CA][4941215:US_NE][5001413:US_MS][4999874:US_SC][4756396:US_WA][4999876:US_OK][4872077:US_HI][4892880:US_VA][4892881:US_VA][4774818:US_AZ][4779331:US_ID][4720020:US_FL][5423338:US_OK][5434976:US_CA][5435487:US_OH][5267648:US_UT][5441936:US_KY][5531534:US_AR][5567633:US_IL][5374157:US_HI][5435078:US_MI][5441634:US_KY][5323486:US_FL][5483399:US_TN][5173417:US_TX][5435080:US_CO][5467651:US_AR][5474831:US_MA][5213143:US_NV][5578917:US_UT][5772883:US_TN][5612873:US_CA][5772479:US_OR][5963929:US_CA][5578409:US_UT][5626765:US_NJ][5662241:US_TX][5737447:US_FL][5839658:US_AL][5727687:US_OK][5772480:US_NM][5907492:US_VA][5617484:US_OR][5926495:US_MT][5728397:US_WA][5610427:US_TX][5627166:US_OH][5609615:US_OH][6072502:US_FL][6249242:US_PA][6289405:US_NY][6292556:US_MD][6028513:US_WY][6120841:US_IL][6347830:US_DE][6121847:US_TX][6094391:US_AZ][6297281:US_IL][6337652:US_ME][6347727:US_PA][6338356:US_TN][6090931:US_AR][6091640:US_IL][6154771:US_TX][6249550:US_GA][6061627:US_NV][6249245:US_MN][6154562:US_IA][6152131:US_CO][6289607:US_GA][6364740:US_GA][6151928:US_TX][6090930:US_PA][6091742:US_IL][6350556:US_UT][6094905:US_CA][6028514:US_CT][6364741:US_OK][6032962:US_OR][6154770:US_SC][6902277:US_IL][6928284:US_VT][6746298:US_TX][6936573:US_VT][6936676:US_IA][6980301:US_AR][6845420:US_CA][6993099:US_AR][6776887:US_GA][6936572:US_FL][6721501:US_SC][6989658:US_NJ][6777808:US_NY][6936878:US_CA][6947877:US_WA][6980802:US_ID][6735003:US_MI][6902481:US_OR][6928183:US_FL][6812227:US_NJ][6837946:US_PA][6811112:US_NC][6883941:US_OR][7000534:US_NY][7000535:US_AZ][6845928:US_FL][6757443:US_FL][6947876:US_WA][6944339:US_TN][6883940:US_FL][6951704:US_TX][6887945:US_FL][6391036:US_IL][6442266:US_TX][6640840:US_FL][6640839:US_MA][6640850:US_AL][6640853:US_NH][6640854:US_TX][6438619:US_CA][6640966:US_MS][6640964:US_GA][6526886:US_CA][6640738:US_NJ][6607455:US_CO][6660563:US_MN][6640857:US_IL][6625972:US_MD][6640855:US_TN][6640860:US_NH][6607460:US_AZ][6640848:US_CA][6526283:US_IL][6688966:US_ID][6524156:US_VA][6640737:US_FL][6472387:US_NJ][6640969:US_FL][6640843:US_UT][6640844:US_FL][6640851:US_CT][6640859:US_CA][6668842:US_DC][6697818:US_GA][6544821:US_IL][6640845:US_PA][6605739:US_TX][6475219:US_KY][6640856:US_FL][6640962:US_FL][6640842:US_AZ][6526987:US_FL][6524157:US_VA][6640971:US_MN][6641174:US_NC][6640846:US_UT][7761566:US_CO][7633836:US_IL][7797521:US_GA][7797823:US_OK][7797924:US_KS][7735299:US_MD][7833834:US_MA][7646405:US_FL][7744273:US_MD][7833228:US_NM][7535220:US_CO][7806669:US_NH][7665096:US_IL][7806567:US_TX][7514824:US_AR][7514926:US_PA][7490083:US_TX][7490584:US_NJ][7569410:US_CA][7867439:US_WI][7569717:US_TN][7699459:US_IA][9294632:US_MO][9097275:US_GA][9063193:US_GA][9230035:US_NH][9330229:US_TX][9294631:US_ID][9347358:US_TX][9298260:US_DE][9298261:US_DE][9321468:US_VA][9346856:US_GA][9321065:US_SC][9417680:US_CT][9417681:US_NJ][9417782:US_VA][9320963:US_MI][9369723:US_SC][9417677:US_AL][9417678:US_NH][9417679:US_NH][9218975:US_AZ][9346753:US_TX][9155439:US_CA][9155442:US_CA][9156247:US_IN][9063294:US_MN][9107241:US_RI][9085300:US_FL][9100921:US_AR][9206309:US_CA][9287824:US_GA][9085302:US_IL][9097274:US_GA][9097276:US_OH][9075344:US_ID][9254320:US_NJ][9166512:US_GA][9165904:US_IL][9155644:US_OK][9063295:US_MN][9242677:US_IL][9133090:US_MO][9259066:US_TX][9287218:US_SC][9097277:US_WA][9135017:US_OR][9223424:US_FL][9223526:US_FL][9223527:US_NM][9036039:US_TX][9144863:US_TX][7351033:US_ME][7351542:US_PA][7351440:US_VA][7219538:US_FL][7219536:US_CA][7284712:US_NM][7107223:US_AR][7258958:US_AZ][7451913:US_MA][7106921:US_NC][7229205:US_GA][7127487:US_FL][7285314:US_ID][7443347:US_OH][7328780:US_NY][7053939:US_NJ][7261686:US_CA][9592234:US_MI][9592235:US_PA][9592336:US_NJ][9594869:US_OH][9555038:US_MD][9592233:US_NY][9618627:US_IL][9577626:US_GA][9583539:US_TX][9565633:US_FL][9583543:US_UT][9554330:US_FL][9565531:US_MN][9594466:US_NH][9554329:US_NJ][9555036:US_FL][9577521:US_CA][9647357:US_MD][9647559:US_CO][9647256:US_FL][9442742:US_GA][9577623:US_MA][9645729:US_TN][9584756:US_CT][9565229:US_FL][9493295:US_CA][9718346:US_AL][9718447:US_MA][9454478:US_FL][9493297:US_FL][9493293:US_CA][9493294:US_NY][9677646:US_OR][9718548:US_MI][9744103:US_MA][9430459:US_TX][9493296:US_CA][9787126:US_WA][9760089:US_WA][9818094:US_WA][9870018:US_MD][9859667:US_WA][9936150:US_WI][9831066:US_FL][9870321:US_LA][9848735:US_CT][10932578:US_NJ][10783618:US_IL][10916793:US_PA][10849581:US_IL][12806408:US][5539302:US_FL]
- Bill tobilladdress
- Chris Duplesis HOME DEPOT.COM 2455 Paces Ferry Road Atlanta GA 30339 (850) 557-5018
- Billaddresslistbilladdresslist
- 110 w north st
- Billingaddress keybillingaddress_key
- 2183718
- Billingaddress textbillingaddress_text
- HOME DEPOT.COM 2455 Paces Ferry Road Atlanta GA 30339 (850) 557-5018
- 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 · 37 with a value · 24 empty
- Balreadyrefundedbalreadyrefunded
- No
- Currencycurrency
- US Dollar
- Currencynamecurrencyname
- US Dollar
- Currencyprecisioncurrencyprecision
- 2
- Currencysymbolcurrencysymbol
- USD
- Disablepromotionrecalcdisablepromotionrecalc
- No
- Discount totaldiscounttotal
- 0.00
- Duedaysduedays
- 60
- Estgrossprofitestgrossprofit
- 519.88
- Estgrossprofitpercentestgrossprofitpercent
- 60.46
- 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
- 859.88
- Origtotal2origtotal2
- 859.88
- Overallunbilledordersoverallunbilledorders
- 490,608.22
- Payment termsterms
- Net 60
- Persistedtermspersistedterms
- 3
- Primarycurrencyprimarycurrency
- 1.00
- Primarycurrencyfxrateprimarycurrencyfxrate
- 1.00
- Promotionappliedpromotionapplied
- No
- Stc amount after discountcustbody_stc_amount_after_discount
- 859.88
- Stc tax after discountcustbody_stc_tax_after_discount
- 0.00
- Stc total after discountcustbody_stc_total_after_discount
- 859.88
- Subtotalsubtotal
- 859.88
- Tax totaltaxtotal
- 0.00
- Totaltotal
- 859.88
- Totalcostestimatetotalcostestimate
- 340.00
- Unbilledordersunbilledorders
- 490,608.22
No value 24
- Amz discount totalcustbody_amz_discount_total
- —
- Amz total taxcustbody_amz_total_tax
- —
- Automaticallyapplypromotionsautomaticallyapplypromotions
- —
- Automaticallyapplypromotionsassociatedmessageautomaticallyapplypromotionsassociatedmessage
- —
- Couponcodecouponcode
- —
- Discdaysdiscdays
- —
- Discountastotaldiscountastotal
- —
- Discountistaxablediscountistaxable
- —
- Discountitemdiscountitem
- —
- Discountratediscountrate
- —
- Discounttax1amountdatadiscounttax1amountdata
- —
- Discounttax2amountdatadiscounttax2amountdata
- —
- Discpctdiscpct
- —
- Intercostatusintercostatus
- —
- Ns refund idcustbody_ns_refund_id
- —
- Persistedpromocodepersistedpromocode
- —
- Promo codepromocode
- —
- Promocodepluginimplpromocodepluginimpl
- —
- Promodiscountpromodiscount
- —
- Promotionidspromotionids
- —
- St amountcustbody_st_amount
- —
- Stc discountpercentcustbody_stc_discountpercent
- —
- Taxamount2overridetaxamount2override
- —
- Taxamountoverridetaxamountoverride
- —
Payment
Payment · 32 fields · 6 with a value · 26 empty
- Getauthgetauth
- No
- Isrecurringpaymentisrecurringpayment
- No
- Paymentcancelablepaymentcancelable
- No
- Paymentprocessingmodepaymentprocessingmode
- SAVE_ONLY
- Paymentsessionamountpaymentsessionamount
- 859.88
- 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 · 11 with a value · 20 empty
- Createdcreateddate
- 8/27/2023 11:15 pm
- Datedrivendatedriven
- No
- Esc created datecustbody_esc_created_date_dt
- Aug 27, 2023
- Esc last modified datecustbody_esc_last_modified_date_dt
- Aug 28, 2023
- Last modifiedlastmodifieddate
- 8/28/2023 6:17 pm
- Order datetrandate_dt
- Aug 27, 2023
- Prevdateprevdate_dt
- Aug 27, 2023
- Recordcreateddaterecordcreateddate
- 08/27/2023 20:15:41
- Saleseffectivedatesaleseffectivedate_dt
- Aug 27, 2023
- Ship dateshipdate_dt
- Aug 28, 2023
- So formula ship datecustbody_so_formula_ship_date_dt
- Aug 28, 2023
No value 20
- 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
- —
- 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 · 26 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
- Export to shopifycustbody_export_to_shopify
- No
- Externalidexternalid
- HJ_PO_8119_83572611_08/27/2023
- Is ebay ordercustbody_is_ebay_order
- No
- Issynchedcustbody_issynched
- No
- 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
- Pacejet freight termscustbody_pacejet_freight_terms
- Third Party Billing
- Refund to shopifycustbody_refund_to_shopify
- No
- Shopify order cancelledcustbody_shopify_order_cancelled
- No
- Sourcesource
- Web Services
- 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 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
- —
- 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
- —
- 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 · 38 with a value · 72 empty
- 15699 exclude from ep processcustbody_15699_exclude_from_ep_process
- No
- 24custbody24
- 0
- 25custbody25
- 1
- 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
- Hj tc asntypecustbodyhj_tc_asntype
- Pick and Pack
- Hj tc dccodecustbodyhj_tc_dccode
- 6883
- Hj tc edideptnocustbodyhj_tc_edideptno
- 29
- Hj tc storecodecustbodyhj_tc_storecode
- 8119
- Hj tc udf1custbodyhj_tc_udf1
- 83572611
- Hj tc udf5custbodyhj_tc_udf5
- 8/27/2023
- 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
- 27/08/2023 20:15:37
- 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
- 1
- So wo countcustbody_so_wo_count
- 0
- Time corder reatedcustbody_time_corder_reated
- 23:08 PM
- Walcommfeeaddcbcustbody_walcommfeeaddcb
- No
- Wm wfsordercustbody_wm_wfsorder
- No
- Wrm reg hid updateexpirecustbody_wrm_reg_hid_updateexpire
- No
No value 72
- 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 autopacktemplatecustbodyhj_tc_autopacktemplate
- —
- Hj tc markforcodecustbodyhj_tc_markforcode
- —
- Hj tc udf2custbodyhj_tc_udf2
- —
- Hj tc udf3custbodyhj_tc_udf3
- —
- Hj tc udf4custbodyhj_tc_udf4
- —
- 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
- —
- Sale partnercustbody_sale_partner
- —
- 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 · 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 · 44 with a value · 74 empty
- Baserecordtypebaserecordtype
- salesorder
- Billaddresslist refidbilladdresslist_refid
- 2
- Bnopostmainbnopostmain
- Yes
- Currency refidcurrency_refid
- 1
- Customform refidcustomform_refid
- 157
- Dbstrantypedbstrantype
- SalesOrd
- Editionedition
- US
- Entity refidentity_refid
- 49
- Entitynexus refidentitynexus_refid
- 1
- Entryformquerystringentryformquerystring
- e=T&id=22651762
- Haslineshaslines
- Yes
- Hj tc asntype refidcustbodyhj_tc_asntype_refid
- 2
- Idid
- 22651762
- InternalIdInternalId
- 22651762
- 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
- webServices
- 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
- 929
- Rectype 159 1115 maxnkeyrectype_159_1115_maxnkey
- 0
- Rectype 400 3093 maxnkeyrectype_400_3093_maxnkey
- 7
- Salesrep refidsalesrep_refid
- 1168891
- Shipmethod refidshipmethod_refid
- 9598
- StatusRefstatusRef
- fullyBilled
- Subsidiary refidsubsidiary_refid
- 1
- Suppressusereventsandemailssuppressusereventsandemails
- No
- Tax affecting address fields before recalctax_affecting_address_fields_before_recalc
- cityPALMDALEstateCAzip93552countryUS
- Templatestoredtemplatestored
- Yes
- Terms refidterms_refid
- 3
- Typetype
- salesord
- Versionversion
- 4
No value 74
- 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 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
- —
- Sale partner refidcustbody_sale_partner_refid
- —
- Selectedtabselectedtab
- —
- Setup record refidcustbody_setup_record_refid
- —
- Shadow shipaddressshadow_shipaddress
- —
- Shipaddresslist refidshipaddresslist_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.