INV581727 Open

General

Checkcommittedcheckcommitted

No

Created fromcreatedfrom

Sales Order #SOS2879117

Customer PO #otherrefnum

34579184

Customformcustomform

Spa World - Product Invoice

Invoice #tranid

INV581727

Isonlinetransactionisonlinetransaction

No

Istransformedbillistransformedbill

Yes

Istransformedtransactionistransformedtransaction

Yes

Linkedlinked

No

Locationlocation

Miami

Locationusesbinslocationusesbins

Yes

Nexus countrynexus_country

US

Originalnexusoriginalnexus

United States FL

Originalnexuscountryoriginalnexuscountry

US

Recordcreatedbyrecordcreatedby

2015389

Statusstatus

Open

Subsidiarysubsidiary

Spa World Corporation

Tax nexusnexus

United States FL

To be emailedtobeemailed

No

To be faxedtobefaxed

No

To be printedtobeprinted

No

Transactionnumbertransactionnumber

CUSTINVC396297

Voidedvoided

No

Warnnexuschangewarnnexuschange

No

Weekendpreferenceweekendpreference

ASIS

Classclass

—

Departmentdepartment

—

Memomemo

—

Message to customermessage

—

Messageselmessagesel

—

Opportunityopportunity

—

Customer

Balancebalance

3,163,512.06

Companyidcompanyid

49

Credholdentitycredholdentity

49

Credholdoverridecredholdoverride

Yes

Custcurrepcustcurrep

1168891

Customerentity

5001 Home Depot.com

Daysoverduedaysoverdue

220

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,163,512.06

Prevrepprevrep

1168891

Sales repsalesrep

Danny Cruz

10184 customer entity bankcustbody_10184_customer_entity_bank

—

Credlimcredlim

—

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

Carriercarrier

nonups

Hasfedexfreightservicehasfedexfreightservice

No

Itemshippingcostfxrateitemshippingcostfxrate

1

Pj sssdeliverycustbody_pj_sssdelivery

No

Ship methodshipmethod

UPS Ground

Ship toshipaddress

Joe Jacks 955 N Randall Rd C/O THD Ship to Store #1934 Elgin IL 60123 (847) 622-9441

Shipcountryshipcountry

US

Shipisresidentialshipisresidential

No

Shipoverrideshipoverride

No

Shippingaddress keyshippingaddress_key

16049400

Shippingaddress textshippingaddress_text

Joe Jacks 955 N Randall Rd C/O THD Ship to Store #1934 Elgin IL 60123 (847) 622-9441

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

IL

Shipzipshipzip

60123

Tracking numberslinkedtrackingnumbers

221977722

Amz shipment idcustbody_amz_shipment_id

—

Carrier codecustbody_carrier_code

—

Delivery termscustbody_delivery_terms

—

Doshippingrecalcdoshippingrecalc

—

Fedexservicenamefedexservicename

—

FOBfob

—

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

—

Tracking numberstrackingnumbers

—

Billing

Address country state mapaddress_country_state_map

[303455:US_WA][303459:US_CA][251838:US_CT][245856:US_MI][272432:US_MA][243441:US_FL][1520574:US_MN][1520886:US_PA][972934:US_TX][45132:US_FL][89541:CA_ON][102706:US_NY][45947:US_NY][95874:US_MD][89133:US_NY][1939798:US_AR][436572:US][90749:US_CA][204453:US_MT][237904:US_NM][193024:US_FL][176729:US_MA][233281:US_MD][182568:US][222945:US_CT][237906:US_NC][187798:US_FL][236996:US_NC][182770:US][1607753:US_VA][1623679:US_NC][1609376:US_NV][465556:US_CO][1816960:US_CT][1672008:US_WV][395277:US_CO][359755:US_MN][1071106:US_TX][1096326:US_PA][855371:US_AZ][1155017:US_PA][1123067:US_CT][1136229:US_NY][6023:US_FL][6024:US_GA][1452258:US_CO][1435015:US_WV][1709947:US_TX][2:US_GA][138329:US_NJ][109232:US_VA][155413:US_WI][159452:US_NJ][626573:US_CA][353820:US_AZ][314635:US_WA][353716:US_WA][326508:US_PA][8732:US_WA][14337:US_PA][11112:US_WA][1364909:US_MD][1365114:US_MD][1364910:US_MD][1365113:US_MD][1979433:US_TX][1912995:US_OH][1912893:US_CO][1979230:US_WA][1809:US_FL][1810:US_FL][546925:US_GA][2055890:US_ND][2317053:US_CO][2247710:US_MI][2287413:US_TX][2247709:US_FL][2280767:US_OK][2382707:US_CA][2405071:US_NM][2465049:US_UT][2465050:US_UT][8178063:US_MO][7891412:US_IL][7995105:US_FL][8078431:US_MO][7963175:US_CA][8110042:US_CA][8060652:US_AZ][7891515:US_WA][8236079:US_IN][8199284:US_ID][7891513:US_TX][8053122:US_GA][8241194:US_MO][7891514:US_CA][8030465:US_NC][8078028:US_GA][8146683:US_FL][8110041:US_MN][8199387:US_NY][8236181:US_CA][7909539:US_PA][7946078:US_VA][8236183:US_TX][8919721:US_CA][8677522:US_MN][8677523:US_MN][8931121:US_FL][8995414:US_AK][8995415:US_AK][8953066:US_TN][8887529:US_CA][8953367:US_TX][8656700:US_UT][8919519:US_CO][8919520:US_NV][8953062:US_NY][8897277:US_AZ][8966949:US_IA][8967356:US_LA][8995817:US_VA][8896773:US_OH][9025778:US_OH][8760569:US_MD][8789112:US_ME][8789113:US_FL][8789117:US_MA][8789118:US_TN][8789116:US_MD][8760570:US_CA][8656801:US_WI][8716343:US_NV][8801525:US_TX][8815813:US_NY][8870777:US_PA][8806172:US_FL][8855322:US_OR][8855320:US_IL][8825055:US_LA][8866020:US_AZ][8866013:US_NC][8875385:US_PA][8486375:US_AL][8616542:US_OH][8571332:US_PA][8547179:US_RI][8606611:US_MD][8625780:US_PA][8546768:US_IN][8547286:US_MS][8553009:US_OH][8266436:US_IL][8599999:US_PA][8546765:US_KY][8606301:US_NJ][8571331:US_GA][8364559:US_MS][8364558:US_FL][8380565:US_TX][8380568:US_WA][8428324:US_CA][8299705:US_CO][8311796:US_KY][8407177:US_CT][8301942:US_WA][8320730:US_GA][8460575:US_CO][8364557:US_FL][8311695:US_WA][8299707:US_IL][2645863:US_MO][2511117:US][2642137:US_MS][2548036:US_AL][3115909:US_NM][3372871:US_TX][3207479:US_FL][3347887:US_MS][3472241:US_WA][3472242:US_WA][3207476:US_IL][3207478:US_UT][3372769:US_VA][3384039:US_MO][3486907:US_WA][3345258:US_TX][3842876:US_AL][3629082:US_TN][3629083:US_TN][3629084:US_TN][3729097:US_ID][3781712:US_WA][3629085:US_TN][3842775:US_AL][3522697:US_MI][3644693:US_NJ][3578330:US_AR][3788346:US_OH][3880136:US_TN][4269858:US_NJ][4159644:US_NM][4485885:US_NY][4458948:US_CA][4472038:US_TX][4362094:US_TN][4631702:US_WA][4502254:US_MI][4669849:US_NM][4472037:US_TX][4523163:US_LA][4482835:US_NE][4501432:US_CA][4706265:US_FL][4478514:US_HI][4688354:US_TX][4688355:US_NC][4334240:US_CA][4501431:US_CA][4514764:US_GA][4471829:US_CA][4471831:US_CA][4764536:US_CA][4941215:US_NE][5001413:US_MS][4999874:US_SC][4756396:US_WA][4999876:US_OK][4872077:US_HI][4892880:US_VA][4892881:US_VA][4774818:US_AZ][4779331:US_ID][4720020:US_FL][5423338:US_OK][5434976:US_CA][5435487:US_OH][5267648:US_UT][5441936:US_KY][5531534:US_AR][5567633:US_IL][5374157:US_HI][5435078:US_MI][5441634:US_KY][5323486:US_FL][5483399:US_TN][5173417:US_TX][5435080:US_CO][5467651:US_AR][5474831:US_MA][5213143:US_NV][5578917:US_UT][5772883:US_TN][5612873:US_CA][5772479:US_OR][5963929:US_CA][5578409:US_UT][5626765:US_NJ][5662241:US_TX][5737447:US_FL][5839658:US_AL][5727687:US_OK][5772480:US_NM][5907492:US_VA][5617484:US_OR][5926495:US_MT][5728397:US_WA][5610427:US_TX][5627166:US_OH][5609615:US_OH][6072502:US_FL][6249242:US_PA][6289405:US_NY][6292556:US_MD][6028513:US_WY][6120841:US_IL][6347830:US_DE][6121847:US_TX][6094391:US_AZ][6297281:US_IL][6337652:US_ME][6347727:US_PA][6338356:US_TN][6090931:US_AR][6091640:US_IL][6154771:US_TX][6249550:US_GA][6061627:US_NV][6249245:US_MN][6154562:US_IA][6152131:US_CO][6289607:US_GA][6364740:US_GA][6151928:US_TX][6090930:US_PA][6091742:US_IL][6350556:US_UT][6094905:US_CA][6028514:US_CT][6364741:US_OK][6032962:US_OR][6154770:US_SC][6902277:US_IL][6928284:US_VT][6746298:US_TX][6936573:US_VT][6936676:US_IA][6980301:US_AR][6845420:US_CA][6993099:US_AR][6776887:US_GA][6936572:US_FL][6721501:US_SC][6989658:US_NJ][6777808:US_NY][6936878:US_CA][6947877:US_WA][6980802:US_ID][6735003:US_MI][6902481:US_OR][6928183:US_FL][6812227:US_NJ][6837946:US_PA][6811112:US_NC][6883941:US_OR][7000534:US_NY][7000535:US_AZ][6845928:US_FL][6757443:US_FL][6947876:US_WA][6944339:US_TN][6883940:US_FL][6951704:US_TX][6887945:US_FL][6391036:US_IL][6442266:US_TX][6640840:US_FL][6640839:US_MA][6640850:US_AL][6640853:US_NH][6640854:US_TX][6438619:US_CA][6640966:US_MS][6640964:US_GA][6526886:US_CA][6640738:US_NJ][6607455:US_CO][6660563:US_MN][6640857:US_IL][6625972:US_MD][6640855:US_TN][6640860:US_NH][6607460:US_AZ][6640848:US_CA][6526283:US_IL][6688966:US_ID][6524156:US_VA][6640737:US_FL][6472387:US_NJ][6640969:US_FL][6640843:US_UT][6640844:US_FL][6640851:US_CT][6640859:US_CA][6668842:US_DC][6697818:US_GA][6544821:US_IL][6640845:US_PA][6605739:US_TX][6475219:US_KY][6640856:US_FL][6640962:US_FL][6640842:US_AZ][6526987:US_FL][6524157:US_VA][6640971:US_MN][6641174:US_NC][6640846:US_UT][7761566:US_CO][7633836:US_IL][7797521:US_GA][7797823:US_OK][7797924:US_KS][7735299:US_MD][7833834:US_MA][7646405:US_FL][7744273:US_MD][7833228:US_NM][7535220:US_CO][7806669:US_NH][7665096:US_IL][7806567:US_TX][7514824:US_AR][7514926:US_PA][7490083:US_TX][7490584:US_NJ][7569410:US_CA][7867439:US_WI][7569717:US_TN][7699459:US_IA][9294632:US_MO][9097275:US_GA][9063193:US_GA][9230035:US_NH][9330229:US_TX][9294631:US_ID][9347358:US_TX][9298260:US_DE][9298261:US_DE][9321468:US_VA][9346856:US_GA][9321065:US_SC][9417680:US_CT][9417681:US_NJ][9417782:US_VA][9320963:US_MI][9369723:US_SC][9417677:US_AL][9417678:US_NH][9417679:US_NH][9218975:US_AZ][9346753:US_TX][9155439:US_CA][9155442:US_CA][9156247:US_IN][9063294:US_MN][9107241:US_RI][9085300:US_FL][9100921:US_AR][9206309:US_CA][9287824:US_GA][9085302:US_IL][9097274:US_GA][9097276:US_OH][9075344:US_ID][9254320:US_NJ][9166512:US_GA][9165904:US_IL][9155644:US_OK][9063295:US_MN][9242677:US_IL][9133090:US_MO][9259066:US_TX][9287218:US_SC][9097277:US_WA][9135017:US_OR][9223424:US_FL][9223526:US_FL][9223527:US_NM][9036039:US_TX][9144863:US_TX][7351033:US_ME][7351542:US_PA][7351440:US_VA][7219538:US_FL][7219536:US_CA][7284712:US_NM][7107223:US_AR][7258958:US_AZ][7451913:US_MA][7106921:US_NC][7229205:US_GA][7127487:US_FL][7285314:US_ID][7443347:US_OH][7328780:US_NY][7053939:US_NJ][7261686:US_CA][9592234:US_MI][9592235:US_PA][9592336:US_NJ][9594869:US_OH][9555038:US_MD][9592233:US_NY][9618627:US_IL][9577626:US_GA][9583539:US_TX][9565633:US_FL][9583543:US_UT][9554330:US_FL][9565531:US_MN][9594466:US_NH][9554329:US_NJ][9555036:US_FL][9577521:US_CA][9647357:US_MD][9647559:US_CO][9647256:US_FL][9442742:US_GA][9577623:US_MA][9645729:US_TN][9584756:US_CT][9565229:US_FL][9493295:US_CA][9718346:US_AL][9718447:US_MA][9454478:US_FL][9493297:US_FL][9493293:US_CA][9493294:US_NY][9677646:US_OR][9718548:US_MI][9744103:US_MA][9430459:US_TX][9493296:US_CA][9787126:US_WA][9760089:US_WA][9818094:US_WA][9870018:US_MD][9859667:US_WA][9936150:US_WI][9831066:US_FL][9870321:US_LA][9848735:US_CT][10932578:US_NJ][10783618:US_IL][10916793:US_PA][10849581:US_IL][12806408:US][5539302:US_FL]

Bill tobilladdress

Chris Duplesis HOME DEPOT.COM 2455 Paces Ferry Road Atlanta GA 30339 (850) 557-5018

Billingaddress keybillingaddress_key

16050097

Billingaddress textbillingaddress_text

Chris Duplesis HOME DEPOT.COM 2455 Paces Ferry Road Atlanta GA 30339 (850) 557-5018

Billingaddress typebillingaddress_type

shipaddr

Billingaddress2 setbillingaddress2_set

var subrecord = nlapiViewSubrecord('billingaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('billingaddress_text', addresstext);

Billisresidentialbillisresidential

No

Billaddresslistbilladdresslist

—

Billingaddress defaultvaluebillingaddress_defaultvalue

—

Defaultaddrbookdefaultaddrbook

—

Defaultaddresseedefaultaddressee

—

Previous billaddresslistprevious_billaddresslist

—

Amounts & tax

Amount dueamountremaining

1,199.25

Amount paidamountpaid

0.00

Amountremainingtotalboxamountremainingtotalbox

1,199.25

Balreadyrefundedbalreadyrefunded

No

Currencycurrency

US Dollar

Currencynamecurrencyname

US Dollar

Currencyprecisioncurrencyprecision

2

Currencysymbolcurrencysymbol

USD

Disablepromotionrecalcdisablepromotionrecalc

No

Discount totaldiscounttotal

0.00

Duedaysduedays

60

Estgrossprofitestgrossprofit

983.32

Estgrossprofitpercentestgrossprofitpercent

81.99

Exchange rateexchangerate

1.00

Expcostdiscprintexpcostdiscprint

No

Installmentcountinstallmentcount

0

Isbasecurrencyisbasecurrency

Yes

Iseditbilledtransactionwithpromotioniseditbilledtransactionwithpromotion

No

Isinstallmentisinstallment

No

Islegacypromoislegacypromo

No

Itemcostdiscprintitemcostdiscprint

No

Linkedclosedperioddiscountslinkedclosedperioddiscounts

No

Mindaysmindays

0

Oldrevenuecommitmentoldrevenuecommitment

No

Origcurrencyorigcurrency

1

Origexchangerateorigexchangerate

1.00

Origtotalorigtotal

1,199.25

Origtotal2origtotal2

1,199.25

Overallunbilledordersoverallunbilledorders

411,279.94

Payment termsterms

Net 60

Persistedtermspersistedterms

3

Primarycurrencyprimarycurrency

1.00

Primarycurrencyfxrateprimarycurrencyfxrate

1.00

Promotionappliedpromotionapplied

No

Stc amount after discountcustbody_stc_amount_after_discount

1,199.25

Stc tax after discountcustbody_stc_tax_after_discount

0.00

Stc total after discountcustbody_stc_total_after_discount

1,199.25

Subtotalsubtotal

1,199.25

Tax totaltaxtotal

0.00

Timediscprinttimediscprint

No

Totaltotal

1,199.25

Totalcostestimatetotalcostestimate

215.93

Unbilledordersunbilledorders

411,279.94

Amz discount totalcustbody_amz_discount_total

—

Amz total taxcustbody_amz_total_tax

—

Couponcodecouponcode

—

Discdaysdiscdays

—

Discountamountdiscountamount

—

Discountastotaldiscountastotal

—

Discountistaxablediscountistaxable

—

Discountitemdiscountitem

—

Discountratediscountrate

—

Discounttax1amountdatadiscounttax1amountdata

—

Discounttax2amountdatadiscounttax2amountdata

—

Discpctdiscpct

—

Expcostdiscacctexpcostdiscacct

—

Expcostdiscamountexpcostdiscamount

—

Expcostdiscountexpcostdiscount

—

Expcostdiscrateexpcostdiscrate

—

Expcosttaxcodeexpcosttaxcode

—

Expcosttaxrate1expcosttaxrate1

—

Intercostatusintercostatus

—

Itemcostdiscamountitemcostdiscamount

—

Itemcostdiscountitemcostdiscount

—

Itemcostdiscrateitemcostdiscrate

—

Itemcosttaxcodeitemcosttaxcode

—

Itemcosttaxrate1itemcosttaxrate1

—

Ns refund idcustbody_ns_refund_id

—

Persistedpromocodepersistedpromocode

—

Promo codepromocode

—

Promocodepluginimplpromocodepluginimpl

—

Promodiscountpromodiscount

—

Promotionidspromotionids

—

St amountcustbody_st_amount

—

Stc discountpercentcustbody_stc_discountpercent

—

Taxamount2overridetaxamount2override

—

Taxamountoverridetaxamountoverride

—

Taxperiodtaxperiod

—

Timediscamounttimediscamount

—

Timediscounttimediscount

—

Timediscratetimediscrate

—

Timetaxcodetimetaxcode

—

Timetaxrate1timetaxrate1

—

Payment

Applied depositscustbody_applied_deposits

—

Customerpaymentcustomerpayment

—

Payment methodcustbody_payment_method

—

Payout idcustbody_payout_id

—

Stc payment transaction idcustbody_stc_payment_transaction_id

—

Wrm so returnauthorizationcustbody_wrm_so_returnauthorization

—

Dates

Createdcreateddate

7/23/2024 4:41 pm

Datedrivendatedriven

No

Due dateduedate_dt

Sep 21, 2024

Esc created datecustbody_esc_created_date_dt

Jul 23, 2024

Esc last modified datecustbody_esc_last_modified_date_dt

Jul 23, 2024

Invoice datetrandate_dt

Jul 23, 2024

Last modifiedlastmodifieddate

7/23/2024 6:41 pm

Prevdateprevdate_dt

Jul 23, 2024

Recordcreateddaterecordcreateddate

07/14/2024 18:25:53

Saleseffectivedatesaleseffectivedate_dt

Jul 23, 2024

Ship dateshipdate_dt

Jul 23, 2024

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

—

Discountdatediscountdate_dt

—

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

—

Pp epp_e_dt

—

Pp spp_s_dt

—

Sii operation datecustbody_sii_operation_date_dt

—

So formula ship datecustbody_so_formula_ship_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

Amazon fbacustbody_amazon_fba

No

Amazon prime sfcustbody_amazon_prime_sf

No

Cancel order in ebaycustbody_cancel_order_in_ebay

No

Edi statuscustbody_edi_status

EDI Invoice Sent

Is ebay ordercustbody_is_ebay_order

No

Issynchedcustbody_issynched

Yes

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

Nsts wodm write off amountcustbody_nsts_wodm_write_off_amount

10.00

Nsts wodm write off limitcustbody_nsts_wodm_write_off_limit

1

Nsts wodm write off percentcustbody_nsts_wodm_write_off_percent

0.50

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

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

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

—

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

—

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

15699 exclude from ep processcustbody_15699_exclude_from_ep_process

No

24custbody24

1

25custbody25

0

6custbody6

No

Address updatedcustbody_address_updated

No

Amz business ordercustbody_amz_business_order

No

Amz is premium ordercustbody_amz_is_premium_order

No

Amz is primecustbody_amz_is_prime

No

Awaiting inventorycustbody_awaiting_inventory

No

Call confirmedcustbody_call_confirmed

No

Can in houzzcustbody_can_in_houzz

No

Castlegate ordercustbodycastlegate_order

No

Comission paidcustbody_comission_paid

No

Hj tc asntypecustbodyhj_tc_asntype

Pick and Pack

Hj tc dccodecustbodyhj_tc_dccode

1934

Hj tc edideptnocustbodyhj_tc_edideptno

29

Hj tc storecodecustbodyhj_tc_storecode

8119

Hj tc udf1custbodyhj_tc_udf1

34579184

Hj tc udf5custbodyhj_tc_udf5

7/14/2024

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

23/7/2024 13:41:14

Scpq trns sowo convertedcustbody_scpq_trns_sowo_converted

No

Send register requestcustbody_send_register_request

No

Sii article 61dcustbody_sii_article_61d

No

Sii article 72 73custbody_sii_article_72_73

No

Sii is third partycustbody_sii_is_third_party

No

Sii not reported in timecustbody_sii_not_reported_in_time

No

So line countcustbody_so_line_count

1

So wo countcustbody_so_wo_count

0

Time corder reatedcustbody_time_corder_reated

16:07 PM

Walcommfeeaddcbcustbody_walcommfeeaddcb

No

Wm wfsordercustbody_wm_wfsorder

No

Wrm reg hid updateexpirecustbody_wrm_reg_hid_updateexpire

No

2custbody2

—

22custbody22

—

23custbody23

—

3custbody3

—

4110 customregnumcustbody_4110_customregnum

—

7custbody7

—

Amz adjustment idcustbody_amz_adjustment_id

—

Amz fee stcustbody_amz_fee_st

—

Amz gift wrap chargescustbody_amz_gift_wrap_charges

—

Amz order setupcustbody_amz_order_setup

—

Amz order urlcustbody_amz_order_url

—

B2c ponumcustbody_b2c_ponum

—

Bol filecustbody_bol_file

—

Bol file urlcustbody_bol_file_url

—

Castlgate wsaidcustbody_castlgate_wsaid

—

Counterparty vatcustbody_counterparty_vat

—

Country of origincustbody_country_of_origin

—

Custbody order urlcustbodycustbody_order_url

—

Custbody sale partner cscustbodycustbody_sale_partner_cs

—

Doc num summ invoicecustbody_doc_num_summ_invoice

—

Establishment codecustbody_establishment_code

—

Hj tc autopacktemplatecustbodyhj_tc_autopacktemplate

—

Hj tc markforcodecustbodyhj_tc_markforcode

—

Hj tc udf2custbodyhj_tc_udf2

—

Hj tc udf3custbodyhj_tc_udf3

—

Hj tc udf4custbodyhj_tc_udf4

—

Houzz order idcustbody_houzz_order_id

—

Houzz storecustbody_houzz_store

—

Itr nexuscustbody_itr_nexus

—

Mode of transportcustbody_mode_of_transport

—

Nexus notccustbody_nexus_notc

—

Notccustbody_notc

—

Ns markerplace setupcustbody_ns_markerplace_setup

—

Order notescustbody_order_notes

—

Package height iftrancustbody_package_height_iftran

—

Package lengthcustbody_package_length

—

Package width iftranscustbody_package_width_iftrans

—

Po acceptidcustbody_po_acceptid

—

Product added on trancustbody_product_added_on_tran

—

Refno originvoicecustbody_refno_originvoice

—

Regime codecustbody_regime_code

—

Regime code of supplycustbody_regime_code_of_supply

—

Sale partnercustbody_sale_partner

—

Scpq iframecustbody_scpq_iframe

—

Scpq trns wos createdcustbody_scpq_trns_wos_created

—

Settlement idcustbody_settlement_id

—

Setup recordcustbody_setup_record

—

Sii code issued invcustbody_sii_code_issued_inv

—

Sii correction typecustbody_sii_correction_type

—

Sii exempt detailscustbody_sii_exempt_details

—

Sii external referencecustbody_sii_external_reference

—

Sii intra txn typecustbody_sii_intra_txn_type

—

Sii issued inv typecustbody_sii_issued_inv_type

—

Sii land registercustbody_sii_land_register

—

Sii orig invoicecustbody_sii_orig_invoice

—

Sii property locationcustbody_sii_property_location

—

Sii registration codecustbody_sii_registration_code

—

Sii registration msgcustbody_sii_registration_msg

—

Sii registration statuscustbody_sii_registration_status

—

Sii spcl scheme code salescustbody_sii_spcl_scheme_code_sales

—

So closed reasoncustbody_so_closed_reason

—

Ssp created fromcustbody_ssp_created_from

—

St amz settle idcustbody_st_amz_settle_id

—

Stc daysuntilexpirycustbody_stc_daysuntilexpiry

—

Sw related so numbercustbody_sw_related_so_number

—

Sw related wo numbercustbody_sw_related_wo_number

—

Transaction regioncustbody_transaction_region

—

Warehouse idcustbody_warehouse_id

—

Wf po numbercustbody_wf_po_number

—

Wm purchase idcustbody_wm_purchase_id

—

Wrm claimnumbercustbody_wrm_claimnumber

—

Wrm replacementsocustbody_wrm_replacementso

—

Others

Accountaccount

11010 Total Accounts Receivable : Accounts Receivable

Canhavestackablecanhavestackable

Yes

Custpage taf subsidiarycachecustpage_taf_subsidiarycache

{"1":"US","5":"US","6":"US","3":"US","9":"US","2":"US","4":"US","7":"US","8":"US"}

Custpage wrm invoice warranty accesscustpage_wrm_invoice_warranty_access

Yes

Custpage wrm lineitem cachecustpage_wrm_lineitem_cache

{}

Finchrgfinchrg

No

Iseitf81oniseitf81on

No

Isfulfilledisfulfilled

Yes

Linkedrevrecjelinkedrevrecje

No

Postingperiodpostingperiod

Jul 2024

Ppsetbyuserppsetbyuser

No

Semailsemail

info@homedepot.com

Sendorderfulfillmentemailsendorderfulfillmentemail

Yes

Tranline0 locationtranline0_location

1

Allownonglchangesallownonglchanges

—

Bulkprocsubmissionbulkprocsubmission

—

Intercotransactionintercotransaction

—

Periodclosedperiodclosed

—

Ppsetbyuservalueppsetbyuservalue

—

Previousopportunitypreviousopportunity

—

Tranline0 classtranline0_class

—

Tranline0 departmenttranline0_department

—

System & IDs

Account refidaccount_refid

122

Baserecordtypebaserecordtype

invoice

Createdfrom refidcreatedfrom_refid

28057586

Currency refidcurrency_refid

1

Customform refidcustomform_refid

179

Dbstrantypedbstrantype

CustInvc

Editionedition

US

Entity refidentity_refid

49

Entitynexus refidentitynexus_refid

1

Entryformquerystringentryformquerystring

e=T&id=28207349

Haslineshaslines

Yes

Hj tc asntype refidcustbodyhj_tc_asntype_refid

2

Idid

28207349

InternalIdInternalId

28207349

Inventorydetailuitypeinventorydetailuitype

LOH_STRICT_VALIDATION

Location refidlocation_refid

1

Nexus refidnexus_refid

1

Nsts wodm write off limit refidcustbody_nsts_wodm_write_off_limit_refid

1

Ntypentype

Invoice

Ntype refidntype_refid

7

Orderleveldataorderleveldata

[]

Originalnexus refidoriginalnexus_refid

1

Pacejet freight terms refidcustbody_pacejet_freight_terms_refid

3

Postingperiod refidpostingperiod_refid

132

Rectype 159 1115 maxnkeyrectype_159_1115_maxnkey

0

Rectype 400 3093 maxnkeyrectype_400_3093_maxnkey

7

Salesrep refidsalesrep_refid

1168891

Shipmethod refidshipmethod_refid

9598

StatusRefstatusRef

open

Subsidiary refidsubsidiary_refid

1

Tax affecting address fields before recalctax_affecting_address_fields_before_recalc

cityElginstateILzip60123countryUS

Templatestoredtemplatestored

Yes

Terms refidterms_refid

3

Typetype

custinvc

Versionversion

2

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

—

Bulkprocsubmission refidbulkprocsubmission_refid

—

Class refidclass_refid

—

Couponcode refidcouponcode_refid

—

Custbody sale partner cs refidcustbodycustbody_sale_partner_cs_refid

—

Customwhencecustomwhence

—

Delivery terms refidcustbody_delivery_terms_refid

—

Department refiddepartment_refid

—

Discountitem refiddiscountitem_refid

—

Errornotificationsfielderrornotificationsfield

—

Expcostdiscount refidexpcostdiscount_refid

—

Expcosttaxcode refidexpcosttaxcode_refid

—

Hj tc autopacktemplate refidcustbodyhj_tc_autopacktemplate_refid

—

Houzz store refidcustbody_houzz_store_refid

—

Intercostatus refidintercostatus_refid

—

Intercotransaction refidintercotransaction_refid

—

Itemcostdiscount refiditemcostdiscount_refid

—

Itemcosttaxcode refiditemcosttaxcode_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

—

Opportunity refidopportunity_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

—

Sale partner refidcustbody_sale_partner_refid

—

Selectedtabselectedtab

—

Setup record refidcustbody_setup_record_refid

—

Shadow shipaddressshadow_shipaddress

—

Shipaddresslist refidshipaddresslist_refid

—

Shipping label file refidcustbody_shipping_label_file_refid

—

Shopify store refidcustbody_shopify_store_refid

—

Sii correction type refidcustbody_sii_correction_type_refid

—

Sii exempt details refidcustbody_sii_exempt_details_refid

—

Sii intra txn type refidcustbody_sii_intra_txn_type_refid

—

Sii issued inv type refidcustbody_sii_issued_inv_type_refid

—

Sii orig invoice refidcustbody_sii_orig_invoice_refid

—

Sii property location refidcustbody_sii_property_location_refid

—

Sii registration code refidcustbody_sii_registration_code_refid

—

Sii registration status refidcustbody_sii_registration_status_refid

—

Sii spcl scheme code sales refidcustbody_sii_spcl_scheme_code_sales_refid

—

So closed reason refidcustbody_so_closed_reason_refid

—

Sw related so number refidcustbody_sw_related_so_number_refid

—

Sw related wo number refidcustbody_sw_related_wo_number_refid

—

Synceventfieldsynceventfield

—

Timediscount refidtimediscount_refid

—

Timetaxcode refidtimetaxcode_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

—