Order SOS2534860 - NetSuite Backup

	#	Item	Description	Qty	Fulfilled	Rate	Amount
	1	HSI3060RWHCE	3060SI: Right: White: Hydro: Friction Heater: PneumaticControl: AutoDrain: Chrome Trim: Overflow : HEATED PAD : WALL SURROUND SQ 4" TILE - GLOSSY WHITE : 2x 60x60" ACRYLIC SHEETS : 2x 60" CORNER CADDIES : 10x SILICONE TUBES : 4x ADHESIVE TAPE : 2x CAULKING TUBES	1.00	1.00	1,890.83	1,890.83

Subtotal	1,890.83
Total	1,890.83

General

General · 35 fields · 27 with a value · 8 empty

Can be unapprovedcanbeunapproved: No
Checkcommittedcheckcommitted: No
Customer PO #otherrefnum: 99625583
Customformcustomform: Spa World - Sales Order
Isonlinetransactionisonlinetransaction: No
Istransformedbillistransformedbill: No
Istransformedtransactionistransformedtransaction: No
Linkedlinked: Yes
Locationlocation: Miami
Locationusesbinslocationusesbins: Yes
Nexus countrynexus_country: US
Order #tranid: SOS2534860
Order statusorderstatus: Billed
Originalnexusoriginalnexus: United States FL
Originalnexuscountryoriginalnexuscountry: US
Origstatusorigstatus: G
Recordcreatedbyrecordcreatedby: -5
Statusstatus: Billed
Subsidiarysubsidiary: Spa World Corporation
Tax nexusnexus: United States FL
To be emailedtobeemailed: No
To be faxedtobefaxed: No
To be printedtobeprinted: No
Transactionnumbertransactionnumber: SALESORD67630
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,484,267.03
Companyidcompanyid: 49
Credholdentitycredholdentity: 49
Credholdoverridecredholdoverride: Yes
Custcurrepcustcurrep: 1168891
Customerentity: 5001 Home Depot.com
Daysoverduedaysoverdue: 166
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,484,267.03
Overrideholdoverridehold: No
Overrideholdcheckedoverrideholdchecked: No
Prevrepprevrep: 587
Sales repsalesrep: Aimee Lefebvre

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: Joel Helton 651 VICTORIA DR DANDRIDGE TN 37725 (865) 397-9791
Shipcompleteshipcomplete: Yes
Shipcountryshipcountry: US
Shipisresidentialshipisresidential: No
Shipoverrideshipoverride: No
Shippingaddress keyshippingaddress_key: 1902941
Shippingaddress textshippingaddress_text: Joel Helton 651 VICTORIA DR DANDRIDGE TN 37725 (865) 397-9791
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: TN
Shipzipshipzip: 37725
Signaturerequiredsignaturerequired: No
Tracking numberslinkedtrackingnumbers: 770952062603
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 · 7 with a value · 5 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 United States
Billingaddress keybillingaddress_key: 29
Billingaddress textbillingaddress_text: HOME DEPOT.COM 2455 Paces Ferry Road Atlanta GA 30339 United States
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 · 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: 1,710.62
Estgrossprofitpercentestgrossprofitpercent: 90.47
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: 1,890.83
Origtotal2origtotal2: 1,890.83
Overallunbilledordersoverallunbilledorders: 483,351.80
Payment termsterms: Net 60
Persistedtermspersistedterms: 3
Primarycurrencyprimarycurrency: 1.00
Primarycurrencyfxrateprimarycurrencyfxrate: 1.00
Promotionappliedpromotionapplied: No
Stc amount after discountcustbody_stc_amount_after_discount: 1,890.83
Stc tax after discountcustbody_stc_tax_after_discount: 0.00
Stc total after discountcustbody_stc_total_after_discount: 1,890.83
Subtotalsubtotal: 1,890.83
Tax totaltaxtotal: 0.00
Totaltotal: 1,890.83
Totalcostestimatetotalcostestimate: 180.21
Unbilledordersunbilledorders: 483,351.80

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: 1,890.83
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

Createdcreateddate: 4/9/2020 9:00 am
Datedrivendatedriven: No
Document datecustbody_document_date_dt: Apr 9, 2020
Esc created datecustbody_esc_created_date_dt: Apr 9, 2020
Esc last modified datecustbody_esc_last_modified_date_dt: Apr 15, 2020
Last modifiedlastmodifieddate: 4/15/2020 4:44 pm
Order datetrandate_dt: Apr 9, 2020
Prevdateprevdate_dt: Apr 9, 2020
Recordcreateddaterecordcreateddate: 04/09/2020 06:00:52
Saleseffectivedatesaleseffectivedate_dt: Apr 9, 2020
Ship dateshipdate_dt: Apr 22, 2020
So formula ship datecustbody_so_formula_ship_date_dt: Apr 16, 2020

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: —
Approval datecustbody_approval_date: —
Date of taxable supplycustbody_date_of_taxable_supply_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_99625583
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 · 35 with a value · 75 empty

15699 exclude from ep processcustbody_15699_exclude_from_ep_process: No
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: Standard
Hj tc edideptnocustbodyhj_tc_edideptno: 29
Hj tc storecodecustbodyhj_tc_storecode: 8119
Hj tc udf1custbodyhj_tc_udf1: 99625583
Hj tc udf5custbodyhj_tc_udf5: 4/9/2020
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: 09/04/2020 06:00:51
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
Time corder reatedcustbody_time_corder_reated: 09:04 AM
Walcommfeeaddcbcustbody_walcommfeeaddcb: No
Wm wfsordercustbody_wm_wfsorder: No
Wrm reg hid updateexpirecustbody_wrm_reg_hid_updateexpire: No

No value 75

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 autopacktemplatecustbodyhj_tc_autopacktemplate: —
Hj tc dccodecustbodyhj_tc_dccode: —
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: —
So line countcustbody_so_line_count: —
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 · 43 with a value · 75 empty

Baserecordtypebaserecordtype: salesorder
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=3169014
Haslineshaslines: Yes
Hj tc asntype refidcustbodyhj_tc_asntype_refid: 3
Idid: 3169014
InternalIdInternalId: 3169014
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: 873
Rectype 159 1115 maxnkeyrectype_159_1115_maxnkey: 0
Rectype 400 3093 maxnkeyrectype_400_3093_maxnkey: 7
Salesrep refidsalesrep_refid: 587
Shipmethod refidshipmethod_refid: 9598
StatusRefstatusRef: fullyBilled
Subsidiary refidsubsidiary_refid: 1
Suppressusereventsandemailssuppressusereventsandemails: No
Tax affecting address fields before recalctax_affecting_address_fields_before_recalc: cityDANDRIDGEstateTNzip37725countryUS
Templatestoredtemplatestored: Yes
Terms refidterms_refid: 3
Typetype: salesord
Versionversion: 3