Order SOS251313 - NetSuite Backup

	#	Item	Description	Qty	Fulfilled	Rate	Amount
	1	HD3260SHWR	Soho 3260: Right: White: Hydro: Friction Heater: PneumaticControl: Color Match Trim	1.00	1.00	1,034.80	1,800.00

	8	UPGRADELEVEL-Level 1	Please add AIR JETS and COLOR MATCH	1.00	1.00	0.00	0.00

	9	27OFLOWKIT-NKL	27 in. Waste Overflow Kit, Brushed Nickel	1.00	1.00		0.00

Subtotal	1,800.00
Total	1,800.00

General

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

Can be unapprovedcanbeunapproved: No
Checkcommittedcheckcommitted: No
Customer PO #otherrefnum: Scott 3-5-2020
Customformcustomform: Spa World - Sales Order
Isonlinetransactionisonlinetransaction: No
Istransformedbillistransformedbill: No
Istransformedtransactionistransformedtransaction: No
Linkedlinked: Yes
Locationlocation: Miami
Locationusesbinslocationusesbins: Yes
Memomemo: Ordering dual jetted Pontormo Tub
Nexus countrynexus_country: US
Order #tranid: SOS251313
Order statusorderstatus: Billed
Originalnexusoriginalnexus: United States FL
Originalnexuscountryoriginalnexuscountry: US
Origstatusorigstatus: G
Recordcreatedbyrecordcreatedby: 778
Statusstatus: Billed
Subsidiarysubsidiary: Spa World Corporation
Tax nexusnexus: United States FL
To be emailedtobeemailed: No
To be faxedtobefaxed: No
To be printedtobeprinted: No
Transactionnumbertransactionnumber: SALESORD60622
Voidedvoided: No
Warnnexuschangewarnnexuschange: No
Weekendpreferenceweekendpreference: ASIS

No value 7

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

Customer

Customer · 29 fields · 17 with a value · 12 empty

Balancebalance: 0.00
Companyidcompanyid: 4780
Credholdentitycredholdentity: 4780
Credholdoverridecredholdoverride: Yes
Customerentity: 5009 Homemart Products
Daysoverduedaysoverdue: 0
Emailemail: info@homemartproducts.com
Entity nexus countryentity_nexus_country: US
Entityfieldnameentityfieldname: entity
Entitynameentityname: 5009 Homemart Products
Entitynexusentitynexus: United States FL
Manualcreditholdmanualcredithold: No
Overallbalanceoverallbalance: 0.00
Overrideholdoverridehold: No
Overrideholdcheckedoverrideholdchecked: No
Prevrepprevrep: 778
Sales repsalesrep: Rene A Alfonso

No value 12

10184 customer entity bankcustbody_10184_customer_entity_bank: —
Credlimcredlim: —
Custcurrepcustcurrep: —
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 toshipaddress: Scott Nickolaisen 349 Queensbury St Thousand Oaks CA 91360 (805) 381-1970
Shipaddresslistshipaddresslist: 349 Queensbury St
Shipcompleteshipcomplete: Yes
Shipcountryshipcountry: US
Shipisresidentialshipisresidential: Yes
Shipoverrideshipoverride: No
Shippingaddress keyshippingaddress_key: 1786408
Shippingaddress textshippingaddress_text: Scott Nickolaisen 349 Queensbury St Thousand Oaks CA 91360 (805) 381-1970
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: 91360
Signaturerequiredsignaturerequired: No
Tracking numberslinkedtrackingnumbers: 503635740
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 methodshipmethod: —
Ship method usedcustbody_ship_method_used: —
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 · 4 with a value · 8 empty

Address country state mapaddress_country_state_map: [287012:US_AZ][251122:US_CA][250817:US_MD][282899:US][270899:US_VA][270900:US_VA][281377:US_FL][282900:US_OH][1508560:US_PA][1520678:US_MD][1515220:US_FL][1515118:US_CA][1535864:US_CO][1518247:US_TN][1535863:US_CO][1527526:US_AL][1516138:US_CA][794851:US_TX][801784:US_VA][818348:US_GA][824070:US_AZ][797670:CA_ON][817241:US_MA][1314344:US_ME][794852:US_CO][817642:US_VA][1840240:US_UT][934172:US][965007:US_OH][956063:US_NY][965009:US_OH][930956:US_CA][951942:US_CA][956064:US_WA][959574:US_TX][918702:US_NM][965006:US_OH][1322197:US_DC][960287:US_CO][1318878:US_CA][50190:US_CA][1060654:US_WA][1238674:US_KY][50187:US_CA][49975:US_CO][45537:US_NY][49980:US_NY][50394:US_AL][46357:US_CA][95770:CA_QC][45535:US_MI][62169:US_AZ][40779:US_CA][44204:US_NV][44003:US_VA][90646:US_FL][49979:US_NC][97486:US_AZ][50797:US_CO][57637:US_VA][45953:US_TX][45538:US_SC][44206:US_IL][97487:US_MA][39651:US_NJ][40272:US_NY][91151:US_FL][40783:US_IL][44310:US_VA][91152:US_NY][44924:US_NJ][40984:US_IL][50183:US_FL][57021:US_FL][91254:US_MS][419222:US_CA][441201:US_WA][436573:CA_ON][425361:US_NY][62168:US_MA][44923:US_FL][45645:US_NJ][50393:US_NJ][44926:US_TN][40475:US_SC][46354:US_GA][45642:US_MT][46356:US_NY][50186:US_FL][39955:US_AZ][45234:US_NY][50392:US_NJ][49874:US_GA][45950:US_CA][50189:US_CA][50184:US_CO][50391:US_PA][45540:US_AZ][40478:US_WA][49977:US_NJ][95771:US_NJ][46359:US_CT][181961:US_NY][212940:US_NY][207979:US][182972:US_CO][45133:US_NY][1613860:US_CA][1609582:US_TX][1613657:US_TX][1596611:US_CA][1596612:US_CA][1611218:US_NJ][1598746:US_CA][1598747:US_CA][1598748:US_CA][1599153:US_SC][1599151:US_OH][1601301:US_MD][1621224:US_NJ][1626226:US_NJ][1306185:US_PA][425766:US_PA][434336:US_CA][434337:US_CA][1340085:US_PA][1413975:US_NM][1037743:US_CA][1345629:US_NY][1372578:US_NY][1352364:US_NY][1365120:US_CO][1344621:US_WI][1065978:US_FL][1364911:US_GA][1755553:US_NH][1744805:US_TN][1744804:US_TN][1744906:US_VA][486029:US_TN][457990:US_FL][453546:US_NM][1782970:US_IL][1786111:US_AL][1744800:US_TN][1627640:US_TX][1664014:US_TX][1651155:US_OH][1639540:US_MD][1651979:US_WI][1640557:US_FL][1671501:US_AZ][1664721:US_NJ][1654795:US_AZ][1655803:US_CA][1627944:US_CA][1665128:US_TN][1671500:US_AZ][1663305:US_NJ][1655802:US_CA][1630492:US_CA][398111:US_CA][398314:US_CA][393072:US_LA][395279:US_LA][381295:US_FL][429994:US_NY][429993:US_NY][396190:US_CA][372911:US_MI][382005:US_CA][1343799:US_ND][1071513:US_MN][1076639:US_CA][1386362:US_MN][1375800:US_NY][1357600:US_AZ][1357601:US_AZ][1097139:US_FL][1098952:US_OH][1076641:US_CA][1107098:US_OK][1092208:US_MA][1418415:US_NY][860509:US][849742:US_OK][851454:US_KY][829406:US_CA][902583:US_MI][865422:US_IN][855577:US_CA][890612:US_CA][849741:US_OK][885479:US_CO][1130098:US_CA][1134211:US_OH][1172220:US_NJ][1130299:US_OH][1161960:US_TX][1123470:US_TN][1139040:US_OH][1199540:US_TX][1193285:US_IL][1156833:US_CA][1122965:CA_QC][1194503:US_IL][1157345:US_TX][1161759:US_MI][1122966:CA][1172422:US_WI][1154404:US_CT][1199435:US_CA][1167894:US_MI][1017258:US][991546:US_NY][1372476:US_CT][1012535:US_CA][1012536:US_CA][1002869:US_WI][1017359:US_FL][1003784:US_VA][1002871:US_WI][977876:US_TX][1012534:US_CT][410013:US_NC][409912:US_NC][523960:US_FL][517504:US_OH][512763:US_FL][541050:US_TX][80786:US_NJ][1060655:US_ID][1452255:US_TX][1452256:US_AZ][1485187:US_CA][1460346:CA_AB][1460347:CA][1460348:CA][1491849:US_AZ][1483660:US_NY][1439044:US_TX][1439045:US_TX][1460349:CA][1438737:US_FL][1452977:US_ID][1460036:US_CA][1460962:US_CA][1452154:US_AZ][1439046:US_TX][1498025:US_AZ][1479848:US_NY][1452153:US_AZ][1485191:US_ID][1460342:US_PA][1460343:US_PA][1459935:US_CA][1463896:US_CO][1710053:US_CA][1281794:US_NY][1285835:US_NY][1258368:US_NY][1276768:US_NY][1251207:US_CA][1287057:US_FL][1364502:US_FL][1322087:US_FL][1369157:US_NM][730085:US_GA][734310:US_VA][755100:US_GA][602108:US_CO][582568:US_TX][603014:US_CA][602106:US_MI][609584:US_OH][605936:US_NY][585601:US_CO][603822:US_MI][606037:US_NY][110341:US_CA][129771:US_PA][128261:US_NY][168260:US_MI][168262:US][111552:US_FL][156027:US_CA][125757:US_WI][109537:US_LA][135294:US_PA][168261:US][627786:US_OK][638837:US_NY][633707:US_CO][621447:US_GA][625863:US_FL][627184:US_CA][626571:US_NJ][617016:US_NC][349304:US_NY][309187:US_IL][1305682:US_ND][1499340:US_CA][21208:US_SC][21211:US_FL][21213:US_IL][17171:US_AZ][9908:US_CA][16955:US_CA][16848:US_NY][24134:US_TN][17170:US_OH][9896:US_VA][24129:US_CA][14133:US_MI][9781:US_VA][14134:US_NJ][17056:US_CA][18284:US_LA][16953:US_CA][21206:US_VA][39648:US_TX][39545:US_FL][9893:US_MA][49872:US_GA][11110:US_MI][39546:US_NC][24127:US_LA][9898:US_AZ][21204:US_MO][21207:CA_QC][44921:US_NY][11115:US_CA][44313:US_CA][24122:US_NC][16851:US_CA][24126:US_OH][17060:US_NY][9887:US_IL][8943:US_FL][17162:US_NY][17172:US_AZ][9900:US_AZ][17061:US_AR][9903:US_MA][11009:US_NV][9573:CA_ON][17165:US_FL][16544:US_PA][16545:US_PA][14132:US_MD][18081:US_TX][9784:US_NJ][11113:US_NY][24132:US_IN][9904:US_AL][44002:US_VA][24130:US_DC][9901:US_WY][18393:US_CA][21205:US_MO][44205:US_NM][9780:US_NY][1418108:US_WA][1427753:US_FL][1205775:US_AL][1404542:US_NV][1427045:US_FL][1431473:US_CA][1352465:US_VA][1393376:US_CO][1426941:US_FL][1397008:US_MN][1427043:US_FL][1426736:US_GA][1386363:US_NJ][1228121:US_MI][1414878:US_CA][1937890:US_CO][1937992:US_OH][1574461:US_FL][1559565:US_IN][1546812:US_NC][1561489:US_CA][1581130:US_AZ][1574250:US_NY][1578408:US_CT][1560981:US_CA][1573335:US_FL][1547019:US_NC][1590911:US_CA][1546917:US_CA][1585486:US_MD][1580522:US_FL][1580521:US_MN][1546816:US_AZ][1578093:US_CA][1256454:US_FL][1250901:US_WI][1281493:US_AL][1276970:US_NM][1261689:US_FL][1261690:US_CA][1250798:US_NY][1282304:US_DC][1306186:US_PA][1312814:US_FL][1307799:US_CO][683744:US_PA][1312812:US_TX][658719:US_CA][679831:US_TN][685260:US_UT][677914:US_FL][1983041:US_IA][436365:US_CA][579441:US_CA][565757:US_NH][1261793:US_OH][1343802:US_IL][1238879:US_PA][1258364:US_TX][1236867:US_GA][2053976:US_IA][2248613:US_FL][2398248:US_AZ][2600278:US_IL][318350:US_IA]
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 8

Bill tobilladdress: —
Billaddresslistbilladdresslist: —
Billingaddress defaultvaluebillingaddress_defaultvalue: —
Billingaddress keybillingaddress_key: —
Billingaddress textbillingaddress_text: —
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,363.07
Estgrossprofitpercentestgrossprofitpercent: 75.73
Exchange rateexchangerate: 1.00
Installmentcountinstallmentcount: 0
Isbasecurrencyisbasecurrency: Yes
Iseditbilledtransactionwithpromotioniseditbilledtransactionwithpromotion: No
Islegacypromoislegacypromo: No
Linkedclosedperioddiscountslinkedclosedperioddiscounts: No
Oldrevenuecommitmentoldrevenuecommitment: No
Origcurrencyorigcurrency: 1
Origexchangerateorigexchangerate: 1.00
Origtotalorigtotal: 1,800.00
Origtotal2origtotal2: 1,800.00
Overallunbilledordersoverallunbilledorders: 0.00
Primarycurrencyprimarycurrency: 1.00
Primarycurrencyfxrateprimarycurrencyfxrate: 1.00
Promotionappliedpromotionapplied: No
Stc amount after discountcustbody_stc_amount_after_discount: 1,800.00
Stc tax after discountcustbody_stc_tax_after_discount: 0.00
Stc total after discountcustbody_stc_total_after_discount: 1,800.00
Subtotalsubtotal: 1,800.00
Tax totaltaxtotal: 0.00
Totaltotal: 1,800.00
Totalcostestimatetotalcostestimate: 436.93
Unbilledordersunbilledorders: 0.00

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 · 22 with a value · 10 empty

Authcodeauthcode: 06791D
Authorizedamountauthorizedamount: 0
Collectedamountcollectedamount: 1800
Getauthgetauth: No
Inputpnrefnuminputpnrefnum: 5834253459416659304271
Ispaymethundepfundsispaymethundepfunds: Yes
Isrecurringpaymentisrecurringpayment: No
Payment methodpaymentmethod: VISA
Paymentcancelablepaymentcancelable: No
Paymenteventholdreasonpaymenteventholdreason: Operation was successful
Paymenteventpurchasedatasentpaymenteventpurchasedatasent: No
Paymenteventresultpaymenteventresult: Accept
Paymenteventtypepaymenteventtype: CAPTURE
Paymenteventupdatedbypaymenteventupdatedby: Aaugustin@swcorp.com
Paymentmethodtypeidpaymentmethodtypeid: 1
Paymentoperationpaymentoperation: Authorization
Paymentprocessingmodepaymentprocessingmode: SAVE_ONLY
Paymentsessionpaymentsession: 39754
Paymentsessionamountpaymentsessionamount: 1,800.00
Paymethtypepaymethtype: creditcard
Pnrefnumpnrefnum: 5834253459416659304271
Threedstatuscodevisthreedstatuscodevis: No

No value 10

Applied depositscustbody_applied_deposits: —
Expectedpaymentstatusexpectedpaymentstatus: —
Payment methodcustbody_payment_method: —
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: 3/5/2020 1:03 pm
Createdcreateddate: 3/5/2020 11:22 am
Esc created datecustbody_esc_created_date_dt: Mar 5, 2020
Esc last modified datecustbody_esc_last_modified_date_dt: Mar 16, 2020
Last modifiedlastmodifieddate: 3/16/2020 4:42 pm
Order datetrandate_dt: Mar 5, 2020
Paymenteventdatepaymenteventdate: 3/5/2020 8:22 am
Prevdateprevdate_dt: Mar 5, 2020
Recordcreateddaterecordcreateddate: 03/05/2020 08:22:24
Saleseffectivedatesaleseffectivedate_dt: Mar 5, 2020
Ship dateshipdate_dt: Mar 6, 2020
So formula ship datecustbody_so_formula_ship_date_dt: Mar 11, 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: —
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: Third Party Billing
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 · 31 with a value · 79 empty

15699 exclude from ep processcustbody_15699_exclude_from_ep_process: No
25custbody25: 3
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: 5/3/2020 8:3:0
Sale partnercustbody_sale_partner: Rene A Alfonso
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: 11:03 AM
Walcommfeeaddcbcustbody_walcommfeeaddcb: No
Wm wfsordercustbody_wm_wfsorder: No
Wrm reg hid updateexpirecustbody_wrm_reg_hid_updateexpire: No

No value 79

2custbody2: —
22custbody22: —
23custbody23: —
24custbody24: —
3custbody3: —
4110 customregnumcustbody_4110_customregnum: —
7custbody7: —
Amz adjustment idcustbody_amz_adjustment_id: —
Amz fee stcustbody_amz_fee_st: —
Amz gift wrap chargescustbody_amz_gift_wrap_charges: —
Amz order setupcustbody_amz_order_setup: —
Amz order urlcustbody_amz_order_url: —
B2c ponumcustbody_b2c_ponum: —
Bol filecustbody_bol_file: —
Bol file urlcustbody_bol_file_url: —
Castlgate wsaidcustbody_castlgate_wsaid: —
Counterparty vatcustbody_counterparty_vat: —
Country of origincustbody_country_of_origin: —
Custbody order urlcustbodycustbody_order_url: —
Custbody sale partner cscustbodycustbody_sale_partner_cs: —
Doc num summ invoicecustbody_doc_num_summ_invoice: —
Establishment codecustbody_establishment_code: —
Hj tc asntypecustbodyhj_tc_asntype: —
Hj tc autopacktemplatecustbodyhj_tc_autopacktemplate: —
Hj tc dccodecustbodyhj_tc_dccode: —
Hj tc edideptnocustbodyhj_tc_edideptno: —
Hj tc markforcodecustbodyhj_tc_markforcode: —
Hj tc storecodecustbodyhj_tc_storecode: —
Hj tc udf1custbodyhj_tc_udf1: —
Hj tc udf2custbodyhj_tc_udf2: —
Hj tc udf3custbodyhj_tc_udf3: —
Hj tc udf4custbodyhj_tc_udf4: —
Hj tc udf5custbodyhj_tc_udf5: —
Houzz order idcustbody_houzz_order_id: —
Houzz storecustbody_houzz_store: —
Itr nexuscustbody_itr_nexus: —
Mode of transportcustbody_mode_of_transport: —
Nexus notccustbody_nexus_notc: —
Notccustbody_notc: —
Ns markerplace setupcustbody_ns_markerplace_setup: —
Order notescustbody_order_notes: —
Package height iftrancustbody_package_height_iftran: —
Package lengthcustbody_package_length: —
Package width iftranscustbody_package_width_iftrans: —
Po acceptidcustbody_po_acceptid: —
Product added on trancustbody_product_added_on_tran: —
Refno originvoicecustbody_refno_originvoice: —
Regime codecustbody_regime_code: —
Regime code of supplycustbody_regime_code_of_supply: —
Scpq iframecustbody_scpq_iframe: —
Scpq trns wos createdcustbody_scpq_trns_wos_created: —
Settlement idcustbody_settlement_id: —
Setup recordcustbody_setup_record: —
Sii code issued invcustbody_sii_code_issued_inv: —
Sii correction typecustbody_sii_correction_type: —
Sii exempt detailscustbody_sii_exempt_details: —
Sii external referencecustbody_sii_external_reference: —
Sii intra txn typecustbody_sii_intra_txn_type: —
Sii issued inv typecustbody_sii_issued_inv_type: —
Sii land registercustbody_sii_land_register: —
Sii orig invoicecustbody_sii_orig_invoice: —
Sii property locationcustbody_sii_property_location: —
Sii registration codecustbody_sii_registration_code: —
Sii registration msgcustbody_sii_registration_msg: —
Sii registration statuscustbody_sii_registration_status: —
Sii spcl scheme code salescustbody_sii_spcl_scheme_code_sales: —
So closed reasoncustbody_so_closed_reason: —
So line countcustbody_so_line_count: —
Ssp created fromcustbody_ssp_created_from: —
St amz settle idcustbody_st_amz_settle_id: —
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 · 45 with a value · 73 empty

Baserecordtypebaserecordtype: salesorder
Bnopostmainbnopostmain: Yes
Currency refidcurrency_refid: 1
Customform refidcustomform_refid: 157
Dbstrantypedbstrantype: SalesOrd
Editionedition: US
Entity refidentity_refid: 4780
Entitynexus refidentitynexus_refid: 1
Entryformquerystringentryformquerystring: e=T&id=2973797
Haslineshaslines: Yes
Idid: 2973797
InternalIdInternalId: 2973797
Inventorydetailuitypeinventorydetailuitype: LOH_LOOSE_VALIDATION
Location refidlocation_refid: 1
Methodrequireslineleveldatamethodrequireslineleveldata: Yes
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: 3
Paymenteventholdreason refidpaymenteventholdreason_refid: ACCEPT
Paymenteventmagiczerousedpaymenteventmagiczeroused: No
Paymenteventresult refidpaymenteventresult_refid: ACCEPT
Paymentmethod refidpaymentmethod_refid: 5
Paymentoperation refidpaymentoperation_refid: AUTHORIZATION
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: 887
Rectype 159 1115 maxnkeyrectype_159_1115_maxnkey: 0
Rectype 400 3093 maxnkeyrectype_400_3093_maxnkey: 7
Sale partner refidcustbody_sale_partner_refid: 778
Salesrep refidsalesrep_refid: 778
Shipaddresslist refidshipaddresslist_refid: 1613860
StatusRefstatusRef: fullyBilled
Subsidiary refidsubsidiary_refid: 1
Suppressusereventsandemailssuppressusereventsandemails: No
Tax affecting address fields before recalctax_affecting_address_fields_before_recalc: cityThousand OaksstateCAzip91360countryUS
Templatestoredtemplatestored: Yes
Typetype: salesord
Versionversion: 5

No value 73

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: —
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: —
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
Cash Sale	CSS2645	3/16/2020	Order Bill/Invoice	1,800.00
Item Fulfillment	IF60125	3/16/2020	Receipt/Fulfillment
Work Order	WOS11837	3/5/2020	Special Order