Order SOS2797874 - NetSuite Backup

	#	Item	Description	Qty	Fulfilled	Rate	Amount
	1	LS3471AD	Aquatica 3471: VShaped-Jets: CenterPumpRight: White: Dual: Friction Heater: Aroma: PneumaticControl: Color Match Trim	1.00	1.00	1,444.99	1,444.99

	9	OFLOWKIT-CH_Royale	27 in. Waste Overflow Kit, Chrome (1): 1 1/2" WHITE FLEX HOSE (1.5): 1 1/2 x 20 PVC Pipe (0.25)	1.00	1.00	0.00	0.00

Subtotal	1,444.99
Total	1,444.99

General

General · 35 fields · 28 with a value · 7 empty

Can be unapprovedcanbeunapproved: No
Checkcommittedcheckcommitted: No
Customer PO #otherrefnum: RM-Belz
Customformcustomform: Spa World - Sales Order
Isonlinetransactionisonlinetransaction: No
Istransformedbillistransformedbill: No
Istransformedtransactionistransformedtransaction: No
Linkedlinked: Yes
Locationlocation: Miami
Locationusesbinslocationusesbins: Yes
Memomemo: ANZZI PRICE
Nexus countrynexus_country: US
Order #tranid: SOS2797874
Order statusorderstatus: Billed
Originalnexusoriginalnexus: United States FL
Originalnexuscountryoriginalnexuscountry: US
Origstatusorigstatus: G
Recordcreatedbyrecordcreatedby: 681267
Statusstatus: Billed
Subsidiarysubsidiary: Spa World Corporation
Tax nexusnexus: United States FL
To be emailedtobeemailed: No
To be faxedtobefaxed: No
To be printedtobeprinted: No
Transactionnumbertransactionnumber: SALESORD331127
Voidedvoided: No
Warnnexuschangewarnnexuschange: No
Weekendpreferenceweekendpreference: ASIS

No value 7

Classclass: —
Created fromcreatedfrom: —
Departmentdepartment: —
Message to customermessage: —
Messageselmessagesel: —
Opportunityopportunity: —
Order typeordertype: —

Customer

Customer · 29 fields · 18 with a value · 11 empty

Balancebalance: 254.43
Companyidcompanyid: 1957251
Credholdentitycredholdentity: 1957251
Credholdoverridecredholdoverride: No
Custcurrepcustcurrep: 1123
Customerentity: 19928 Shop Anzzi Direct
Daysoverduedaysoverdue: 73
Emailemail: rklebahn@comcast.net
Entity nexus countryentity_nexus_country: US
Entityfieldnameentityfieldname: entity
Entitynameentityname: 19928 Shop Anzzi Direct
Entitynexusentitynexus: United States FL
Manualcreditholdmanualcredithold: No
Overallbalanceoverallbalance: 254.43
Overrideholdoverridehold: No
Overrideholdcheckedoverrideholdchecked: No
Prevrepprevrep: 681267
Sales repsalesrep: Rafael Martinez

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 · 18 with a value · 23 empty

Carriercarrier: nonups
Hasfedexfreightservicehasfedexfreightservice: No
Itemshippingcostfxrateitemshippingcostfxrate: 1
Pj sssdeliverycustbody_pj_sssdelivery: No
Ship toshipaddress: Kathleen Belz Kathleen Belz 216 Kingbird Dr VONORE TN 37885 (631) 896-6875
Shipcompleteshipcomplete: No
Shipcountryshipcountry: US
Shipisresidentialshipisresidential: No
Shipoverrideshipoverride: No
Shippingaddress keyshippingaddress_key: 10911232
Shippingaddress textshippingaddress_text: Kathleen Belz Kathleen Belz 216 Kingbird Dr VONORE TN 37885 (631) 896-6875
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: 37885
Signaturerequiredsignaturerequired: No
Tracking numberslinkedtrackingnumbers: TSE3128868
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 · 7 with a value · 5 empty

Address country state mapaddress_country_state_map: [9170441:US_FL][9389817:US_NY][9328913:US_GA][9391624:US_TX][9422832:US_WA][9156865:US_NY][9312431:US_NY][9166510:US_VA][9156862:US_MO][9381582:US_NY][9389211:US_TX][9356217:US_TX][9307496:US_MN][9320150:US_OH][9328916:US_NY][9350090:US_WA][9312432:US_NY][9312433:US_NY][9168925:US_VA][9159192:US_CA][9166206:US_NE][9179492:US_LA][9287016:US_PA][9288730:US_MN][9246605:US_NY][9156861:US_NY][9156863:US_CA][9211156:US_TX][9179390:US_MA][9246604:US_NY][9247407:US_CA][9282577:US_FL][9222005:US_MS][9467450:US_KS][9532786:US_TX][9616289:US_NJ][9576000:US_IL][9534215:US][9516799:US_SD][9516800:US_SD][9626582:US_FL][9647964:US_LA][9653369:US_MN][9653371:US_MN][9653372:US_MN][9654898:US_SC][9584348:US_NJ][9647863:US_LA][9654999:US_SC][9711634:US_TX][9455288:US_FL][9770243:US_AL][9708709:US_TX][9711131:US_TX][9493499:US_NY][9493500:US_NY][9767823:US_CT][9722382:US_CA][9772851:US_GA][9432096:US][9494010:US_GA][9678857:US_SC][9686795:US][9503299:US_MA][9688804:US_FL][9689308:US_IL][9689309:US_IL][9436033:US_IL][9690417:US_WA][9779182:US_NY][9677139:US_FL][9697747:US_FL][9718958:US_FL][9691940:US_IN][9768526:US_NJ][9718957:US_FL][9781200:US_NJ][9860475:US_WA][9900318:US][9944490:US_NC][9944491:US_NC][9993960:US_FL][9993961:GB_Essex][9935839:US_MD][9922763:US_AL][9973254:US_FL][9945803:US_CA][9981282:US_ID][9860474:US_AZ][9913121:US_CA][9835397:US_CA][9972751:US_IL][9922764:US_FL][9922966:US_FL][10066414:US_ID][9971237:US_FL][9849853:US_AL][9849854:US_AL][9922162:US_KS][10088939:US_TX][9911598:US_MI][9864417:US][9823063:US_CA][10057189:US_NY][10058799:US_ID][9983512:US_NJ][10068323:US_AL][9896889:US_NJ][10092779:US_CA][9911094:US_CA][9968013:US_FL][9896888:US_GA][10057190:US_NY][9942561:US_NM][9942562:US_NM][10131126:US_MN][10045255:US][9936046:US_OH][9901223:CA_AB][9920647:US_LA][10164691:US][10143506:US_WA][10167110:US][10190834:US_MO][9873758:US][9992744:US_FL][10143507:US_WA][10082223:US_FL][9911597:US_MI][10141791:US_IL][10218230:US_TX][10218331:US_TX][10315611:US_OK][10350379:US][10339540:US_MD][10349874:US][10553334:US_FL][10301542:US_FL][10569036:US_CA][10339236:US_FL][10577465:US][10204894:US_OR][10204895:US_OR][10241839:US_GA][10610316:US_NJ][10241838:US_GA][10557783:US_NY][10626798:US_MD][10208409:US_PA][10364230:US][10229381:US_CT][10576456:US][10290695:US_NV][10607981:US_OH][10625590:US_IL][10619864:US_NJ][10624274:US_FL][10624275:US_FL][10315612:US_KS][10301541:US][10610214:US_NJ][10633820:US_FL][10633821:US][10341556:US_KS][10607976:US_OH][10619863:US_NJ][10203781:US][10203782:US_FL][10616943:US_GA][10422719:US_CA][10229483:US_PA][10339235:US_FL][10497954:US_CT][10207201:US_CA][10411770:US_NV][10541566:US_NY][10544397:US_CA][10544500:US_FL][10543080:US_AZ][10459087:US_CA][10497953:US_CT][10449549:US][10341557:US_KS][10277629:US_FL][10546116:US_MO][10434479:US_FL][10499567:US_FL][10409491:US_FL][10422720:US_CA][10409490:US_FL][10425144:US_HI][10425146:US_CA][10433770:US_MS][10746495:US_CO][10746494:US_CO][10815887:US_TX][10815889:US_TX][10697005:US_CA][10824530:US_FL][10667426:US_NY][10688138:US_CA][10688139:US_CA][10859720:US_MI][10942337:US_GA][10666919:US_MS][10735838:US_MI][10851285:US_TX][10634737:US_CA][10697004:US_CA][10637354:US_FL][10637355:US_FL][10686627:US_KS][10703936:US_AL][10735939:US_MI][10869752:US_KY][10851591:US_FL][10851593:US][10873086:US_TN][10925338:US_CA][10926857:US_LA][10675155:US_NV][10890857:US_KS][10667427:US_NY][11040361:US_OR][11007708:US_CO][10726497:US_MI][10746496:US][10952874:US_FL][10824529:US_FL][10974511:US_TX][10978756:US_CA][10926856:US_MS][10927058:US_NJ][10927059:US_NJ][10951561:US_KY][10953381:CA_BC][10978751:US_NY][11063227:US][11063228:US_FL][10952876:US_FL][10978752:US_NY][10703935:US_AL][10746497:US_NY][11053457:US_FL][10955594:US][11054266:US_CO][10978249:US_CA][10684311:US_TX][10684312:US_TX][11089575:US_IL][11087863:US_FL][11454106:US_MA][11454107:US_MA][11080499:US_GA][11325123:US_NV][11400316:US_MI][11405543:US_IL][11468489:US_MD][11313970:US_WV][11337790:US_TX][11380754:US_MT][11087862:US_IL][11317298:US_AZ][11317299:US_AZ][11089574:US_IL][11400317:US_FL][11337791:US_TX][11087861:US_FL][11325124:US_NV][11369393:US_MT][11245764:US_TN][11191879:US_FL][11191777:US_CA][11154581:US_OR][11140906:US_PA][11247184:US][11273616:US_FL][11206438:US_TX][11257630:US][11214401:US_UT][11154580:US_OR][11162129:US_NC][11162130:US_NC][11200105:US_ME][11163150:US][11214402:US_UT][11256727:US_DC][11138890:US_TN][11140907:US_PA][11191878:US_FL][11207146:US_CA][11214404:US_MD][11205628:US][11246677:US_AL][11266588:US_OK][11874455:US_GA][11876574:US_MI][11931399:US_TX][11917293:US_OR][11866993:US_MO][11866994:US_MS][11874454:US_GA][11515016:US_FL][11929283:US_PA][11917294:US_OR][11759219:US_FL][11589401:US_TX][11876575:US_MI][11904416:US_IL][11550258:US_CA][11674774:US_PA][11515014:US_FL][11505889:US_CA][11759218:US_FL][11515926:US_CA][11690380:US_MD][11760132:US_FL][11517030:US_VA][11773091:US_OR][11760233:US_FL][11604390:US_LA][11517431:US_TX][11517433:US_TX][11578221:US_CA][11690379:US_MD][11550157:US_CA][12380390:US_CO][11983354:US_NC][12439126:US_IL][12439125:US_IL][12435178:US_TX][12393145:US_IN][12290309:US_FL][12286685:US_KS][12425338:US_FL][12448650:US_UT][11983355:US_NC][12049284:US_CA][12218630:US_CO][12184292:US_TX][12109617:US_FL][12168550:US_NJ][12098991:US_SC][12109213:US_FL][12185101:US_NC][12206285:US_MO][12173276:US_NJ][12173480:US_GA][12185102:US_NC][12184596:US_TX][12049285:US_CA][12171573:US_CA][13200050:US_TX][13153722:US_MA][13156059:US_FL][13200051:US_TX][13077662:US_WV][13197931:US_MA][13156060:US][13153823:US_RI][13257425:US_CA][13154530:US_VA][13171752:US_FL][13077156:US][13137708:US_CA][13268996:US_FL][13189468:US_SC][13152803:US_TX][13152804:US_TX][13169924:US_NJ][13341400:US_NY][13271013:US_FL][13077257:US][13280553:US_KY][13020115:US_CA][13341399:US][13357455:US_TN][13478113:US_ID][13428953:US_TX][13416967:US_FL][13425212:US_FL][13354836:US_CT][13357864:US_OH][13395024:US_MI][13271015:US_NY][13077664:US_FL][13271014:US][13341398:US_FL][13280857:US_KY][13341603:US_FL][13387376:US][13425211:US][13357456:US_TN][13137200:US_NY][12509856:US_NC][12736536:US_IN][12636952:US_MD][12663777:US_CA][12525727:US_AL][12525316:US_IL][12936940:US_FL][12936941:US_TX][12875111:US_NY][12911911:US_TX][12908490:US_CO][12553561:US_VA][12951118:US_TX][12863237:US_NY][12509857:US_NY][12864551:US_FL][12875612:US_CA][12985390:US_NC][12525729:US_AL][12553560:US_VA][12898442:US_FL][12951117:US_TX][12908489:US_CO][13563968:US_SC][13892828:US_CA][13524777:US_CA][13492914:US_IL][13504295:US_MN][13554645:US_SC][13599640:US_TX][13866729:US_DC][13789494:US_OH][13789495:US_MI][13876971:US_VA][13643685:US_OR][13524778:US_CA][13852360:US_FL][13632733:US_CA][13643790:US_KS][13785478:US_FL][13511119:US_PA][13632734:US_CA][13877775:US_VA][13643789:US_KS][13785479:US_FL][13948957:US_SC][14005147:US_TX][14049574:US_GA][14028006:US_FL][14082285:US_NV][14083098:US_NV][13937306:US_LA][14083099:US_NV][13960491:US_TX][14101646:US_GA][13936489:US_FL][14124501:US_CA][14156365:US_KS][13937307:US_LA][13960288:US_RI][13960289:US_NY][13986495:US_VA][13986596:US_VA][14143240:US_KS][14028005:US][14157994:US_KS][13491504:US_CA][13949266:US_MI][14156364:US_KS][14004033:US_TX][14157793:US_NY][13979092:US_NC][14142839:US_KS][14143242:US_KS][14327151:US_MI][14326850:US_CA][14291132:US_NY][14304413:US_SC][14315380:US_CA][14291133:US_NY][14291130:US_NY][14291029:US_NY][14258593:US_MD][14213553:US][14213448:US][12941668:US_AR]
Bill tobilladdress: Kathleen Belz Kathleen Belz 216 Kingbird DR VONORE TN 37885 (631) 896-6875
Billingaddress keybillingaddress_key: 10911231
Billingaddress textbillingaddress_text: Kathleen Belz Kathleen Belz 216 Kingbird DR VONORE TN 37885 (631) 896-6875
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 · 32 with a value · 29 empty

Balreadyrefundedbalreadyrefunded: No
Currencycurrency: US Dollar
Currencynamecurrencyname: US Dollar
Currencyprecisioncurrencyprecision: 2
Currencysymbolcurrencysymbol: USD
Disablepromotionrecalcdisablepromotionrecalc: No
Discount totaldiscounttotal: 0.00
Estgrossprofitestgrossprofit: 1,255.84
Estgrossprofitpercentestgrossprofitpercent: 86.91
Exchange rateexchangerate: 1.00
Installmentcountinstallmentcount: 0
Isbasecurrencyisbasecurrency: Yes
Iseditbilledtransactionwithpromotioniseditbilledtransactionwithpromotion: No
Islegacypromoislegacypromo: No
Linkedclosedperioddiscountslinkedclosedperioddiscounts: No
Oldrevenuecommitmentoldrevenuecommitment: No
Origcurrencyorigcurrency: 1
Origexchangerateorigexchangerate: 1.00
Origtotalorigtotal: 1,444.99
Origtotal2origtotal2: 1,444.99
Overallunbilledordersoverallunbilledorders: 1,503.97
Primarycurrencyprimarycurrency: 1.00
Primarycurrencyfxrateprimarycurrencyfxrate: 1.00
Promotionappliedpromotionapplied: No
Stc amount after discountcustbody_stc_amount_after_discount: 1,444.99
Stc tax after discountcustbody_stc_tax_after_discount: 0.00
Stc total after discountcustbody_stc_total_after_discount: 1,444.99
Subtotalsubtotal: 1,444.99
Tax totaltaxtotal: 0.00
Totaltotal: 1,444.99
Totalcostestimatetotalcostestimate: 189.15
Unbilledordersunbilledorders: 1,503.97

No value 29

Amz discount totalcustbody_amz_discount_total: —
Amz total taxcustbody_amz_total_tax: —
Automaticallyapplypromotionsautomaticallyapplypromotions: —
Automaticallyapplypromotionsassociatedmessageautomaticallyapplypromotionsassociatedmessage: —
Couponcodecouponcode: —
Discdaysdiscdays: —
Discountastotaldiscountastotal: —
Discountistaxablediscountistaxable: —
Discountitemdiscountitem: —
Discountratediscountrate: —
Discounttax1amountdatadiscounttax1amountdata: —
Discounttax2amountdatadiscounttax2amountdata: —
Discpctdiscpct: —
Duedaysduedays: —
Intercostatusintercostatus: —
Isinstallmentisinstallment: —
Mindaysmindays: —
Ns refund idcustbody_ns_refund_id: —
Payment termsterms: —
Persistedpromocodepersistedpromocode: —
Persistedtermspersistedterms: —
Promo codepromocode: —
Promocodepluginimplpromocodepluginimpl: —
Promodiscountpromodiscount: —
Promotionidspromotionids: —
St amountcustbody_st_amount: —
Stc discountpercentcustbody_stc_discountpercent: —
Taxamount2overridetaxamount2override: —
Taxamountoverridetaxamountoverride: —

Payment

Payment · 32 fields · 20 with a value · 12 empty

Applied depositscustbody_applied_deposits: 1,444.99
Collectedamountcollectedamount: 1444.99
Getauthgetauth: No
Inputpnrefnuminputpnrefnum: 6855543268086414203285
Ispaymethundepfundsispaymethundepfunds: Yes
Isrecurringpaymentisrecurringpayment: No
Payment methodpaymentmethod: Master Card
Paymentcancelablepaymentcancelable: No
Paymenteventholdreasonpaymenteventholdreason: Operation was successful
Paymenteventpurchasedatasentpaymenteventpurchasedatasent: No
Paymenteventresultpaymenteventresult: Accept
Paymenteventtypepaymenteventtype: SALE
Paymenteventupdatedbypaymenteventupdatedby: rmartinez@swcorp.com
Paymentmethodtypeidpaymentmethodtypeid: 1
Paymentprocessingmodepaymentprocessingmode: SAVE_ONLY
Paymentsessionpaymentsession: 2431905
Paymentsessionamountpaymentsessionamount: 1,444.99
Paymethtypepaymethtype: creditcard
Pnrefnumpnrefnum: 6855543268086414203285
Threedstatuscodevisthreedstatuscodevis: No

No value 12

Authcodeauthcode: —
Authorizedamountauthorizedamount: —
Expectedpaymentstatusexpectedpaymentstatus: —
Payment methodcustbody_payment_method: —
Paymentoperationpaymentoperation: —
Paymentrequestidpaymentrequestid: —
Paymethacctpaymethacct: —
Payout idcustbody_payout_id: —
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: 5/31/2023 5:56 pm
Createdcreateddate: 5/31/2023 1:32 pm
Esc created datecustbody_esc_created_date_dt: May 31, 2023
Esc last modified datecustbody_esc_last_modified_date_dt: Jun 28, 2023
Last modifiedlastmodifieddate: 6/28/2023 5:21 pm
Order datetrandate_dt: May 31, 2023
Paymenteventdatepaymenteventdate: 5/31/2023 10:32 am
Prevdateprevdate_dt: May 31, 2023
Recordcreateddaterecordcreateddate: 05/31/2023 10:32:05
Saleseffectivedatesaleseffectivedate_dt: May 31, 2023
Ship dateshipdate_dt: Jun 7, 2023
So formula ship datecustbody_so_formula_ship_date_dt: Jun 7, 2023

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: —
Datedrivendatedriven: —
Document datecustbody_document_date_dt: —
End dateenddate_dt: —
Estimated ship datecustbody_estimated_ship_date: —
Fba ship datecustbody_fba_ship_date: —
Po date for invoicecustbody_po_date_for_invoice_dt: —
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 · 24 with a value · 55 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
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: Prepaid
Refund to shopifycustbody_refund_to_shopify: No
Shopify order cancelledcustbody_shopify_order_cancelled: No
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 55

Amazon order idcustbody_amazon_order_id: —
Amazon premium shippingcustbody_amazon_premium_shipping: —
B2c channelcustbody_b2c_channel: —
Custbody ebay srncustbodycustbody_ebay_srn: —
Ebay buyer notecustbody_ebay_buyer_note: —
Ebay cancel idcustbody_ebay_cancel_id: —
Ebay cancel reason nscustbody_ebay_cancel_reason_ns: —
Ebay order numbercustbody_ebay_order_number: —
Ebay orderidcustbody_ebay_orderid: —
Edi statuscustbody_edi_status: —
Externalidexternalid: —
Fulfilment channel ordercustbody_fulfilment_channel_order: —
Marketplace shippingcustbody_marketplace_shipping: —
Ns os sales channel namecustbody_ns_os_sales_channel_name: —
Ns os sales channel numbercustbody_ns_os_sales_channel_number: —
Ns os sales error codecustbody_ns_os_sales_error_code: —
Ns os sales order idcustbody_ns_os_sales_order_id: —
Ns os sales order statuscustbody_ns_os_sales_order_status: —
Ns os sales setup rec idcustbody_ns_os_sales_setup_rec_id: —
Ns os sales ship exp bat idcustbody_ns_os_sales_ship_exp_bat_id: —
Ns os sales shipping carriercustbody_ns_os_sales_shipping_carrier: —
Ns os sales shipping methodcustbody_ns_os_sales_shipping_method: —
Ns os sales warehouse namecustbody_ns_os_sales_warehouse_name: —
Nsts wodm credit memo typecustbody_nsts_wodm_credit_memo_type: —
Nsts wodm deduct mngmt idcustbody_nsts_wodm_deduct_mngmt_id: —
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: —
Sourcesource: —
Walmart order idcustbody_walmart_order_id: —
Websitewebsite: —
Wms atlas reason for returncustbody_wms_atlas_reason_for_return: —
Wmsse freighttermscustbody_wmsse_freightterms: —
Wmsse ordertypecustbody_wmsse_ordertype: —
Wmsse thirdpartyaccountnumbercustbody_wmsse_thirdpartyaccountnumber: —
Woocom transaction idcustbody_woocom_transaction_id: —
Woocommerce coupon codecustbody_woocommerce_coupon_code: —
Woocommerce order idcustbody_woocommerce_order_id: —
Woocommerce order statuscustbody_woocommerce_order_status: —
Woorefundidcustbody_woorefundid: —

Custom fields

Custom fields · 110 fields · 34 with a value · 76 empty

15699 exclude from ep processcustbody_15699_exclude_from_ep_process: No
23custbody23: 1,444.99
24custbody24: 2
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: 31/5/2023 10:27:38
Sale partnercustbody_sale_partner: Rafael Martinez
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: 2
So wo countcustbody_so_wo_count: 2
Time corder reatedcustbody_time_corder_reated: 13:05 PM
Walcommfeeaddcbcustbody_walcommfeeaddcb: No
Wm wfsordercustbody_wm_wfsorder: No
Wrm reg hid updateexpirecustbody_wrm_reg_hid_updateexpire: No

No value 76

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

Others

Others · 7 fields · 5 with a value · 2 empty

Canhavestackablecanhavestackable: Yes
Ignoreavsignoreavs: No
Ignoreavsvisignoreavsvis: Yes
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: 1957251
Entitynexus refidentitynexus_refid: 1
Entryformquerystringentryformquerystring: e=T&id=21188170
Haslineshaslines: Yes
Idid: 21188170
InternalIdInternalId: 21188170
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
Pacejet freight terms refidcustbody_pacejet_freight_terms_refid: 1
Paymenteventholdreason refidpaymenteventholdreason_refid: ACCEPT
Paymenteventmagiczerousedpaymenteventmagiczeroused: No
Paymenteventresult refidpaymenteventresult_refid: ACCEPT
Paymentmethod refidpaymentmethod_refid: 4
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: 924
Rectype 159 1115 maxnkeyrectype_159_1115_maxnkey: 0
Rectype 400 3093 maxnkeyrectype_400_3093_maxnkey: 7
Sale partner refidcustbody_sale_partner_refid: 681267
Salesrep refidsalesrep_refid: 681267
StatusRefstatusRef: fullyBilled
Subsidiary refidsubsidiary_refid: 1
Suppressusereventsandemailssuppressusereventsandemails: No
Tax affecting address fields before recalctax_affecting_address_fields_before_recalc: cityVONOREstateTNzip37885countryUS
Templatestoredtemplatestored: Yes
Typetype: salesord
Versionversion: 9

No value 75

10184 customer entity bank refidcustbody_10184_customer_entity_bank_refid: —
2 refidcustbody2_refid: —
Amz order setup refidcustbody_amz_order_setup_refid: —
Billaddresslist refidbilladdresslist_refid: —
Bol file refidcustbody_bol_file_refid: —
Bulkbulk: —
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: —
Originatororiginator: —
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: —
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: —
Terms refidterms_refid: —
Transaction region refidcustbody_transaction_region_refid: —
Trantypepermchecktrantypepermcheck: —
Warningnotificationsfieldwarningnotificationsfield: —
Wms atlas reason for return refidcustbody_wms_atlas_reason_for_return_refid: —
Wmsse freightterms refidcustbody_wmsse_freightterms_refid: —
Wmsse ordertype refidcustbody_wmsse_ordertype_refid: —
Wrm claimnumber refidcustbody_wrm_claimnumber_refid: —
Wrm replacementso refidcustbody_wrm_replacementso_refid: —
Wrm so returnauthorization refidcustbody_wrm_so_returnauthorization_refid: —

Document	Number	Date	Step	Amount
Invoice	INV512322	6/28/2023	Order Bill/Invoice	1,444.99
Item Fulfillment	IF321283	6/28/2023	Receipt/Fulfillment
Customer Deposit	CDS14464	5/31/2023	Sales Order/Deposit	1,444.99
Work Order	WOS54727	5/31/2023	Special Order
Work Order	WOS54728	5/31/2023	Special Order