2431 Royal Plumbing Lost Customer

Balance0.00US Dollar

Overdue0.00Terms: Net 30

Sales repMark BarnathanSpa World Corporation

Latest 25 of 38 orders. See all with filters

Order #	Date	Status	Location	Total
SOS2830210	Nov 2, 2023	Billed	Miami	4,533.70
SOS2830035	Nov 1, 2023	Billed	Miami	3,411.00
SOS2819970	Sep 11, 2023	Billed	Miami	3,410.91
SOS2692797	May 3, 2022	Billed	Miami	4,220.00
SOS2692798	May 3, 2022	Billed	Miami	4,220.00
SOS2650296	Nov 18, 2021	Billed	Miami	4,220.00
SOS2635364	Sep 1, 2021	Billed	Miami	2,720.00
SOS2621417	Jun 24, 2021	Billed	Miami	4,220.00
SOS2619563	Jun 15, 2021	Billed	Miami	4,220.00
SOS2618309	Jun 8, 2021	Billed	Miami	4,220.00
SOS2572233	Nov 4, 2020	Billed	Miami	4,220.00
SOS2572128	Nov 4, 2020	Billed	Miami	2,720.00
SOS2565963	Sep 28, 2020	Billed	Miami	3,220.00
SOS2563411	Sep 11, 2020	Billed	Miami	3,220.00
SOS2560856	Aug 26, 2020	Billed	Miami	4,220.00
SOS2559979	Aug 21, 2020	Billed	Miami	3,220.00
SOS2557705	Aug 6, 2020	Billed	Miami	3,220.00
SOS2555181	Jul 24, 2020	Billed	Miami	4,220.00
SOS2550626	Jun 26, 2020	Billed	Miami	4,220.00
SOS2550252	Jun 24, 2020	Billed	Miami	4,220.00
SOS2545079	May 27, 2020	Billed	Miami	4,220.00
SOS2531864	Mar 25, 2020	Billed	Miami	3,995.00
SOS246374	Feb 11, 2020	Billed	Miami	2,495.00
SOS241952	Jan 15, 2020	Billed	Miami	2,495.00
SOS236495	Dec 10, 2019	Billed	Miami	3,995.00

Latest 25 of 39 invoices. See all with filters

Invoice #	Date	Status	Location	Total	Amount due
INV538432	Nov 14, 2023	Paid In Full	Miami	4,533.70	–
INV537373	Nov 7, 2023	Paid In Full	Miami	3,411.00	–
INV528309	Sep 20, 2023	Paid In Full	Miami	3,410.91	–
INV428170	Jul 5, 2022	Paid In Full	Miami	4,220.00	–
INV428171	Jul 5, 2022	Paid In Full	Miami	4,220.00	–
INV384158	Jan 31, 2022	Paid In Full	Miami	4,220.00	–
INV358338	Sep 15, 2021	Paid In Full	Miami	2,720.00	–
INV343585	Jun 24, 2021	Paid In Full	Miami	4,220.00	–
INV341929	Jun 15, 2021	Paid In Full	Miami	4,220.00	–
INV341447	Jun 11, 2021	Paid In Full	Miami	4,220.00	–
INV301557	Nov 24, 2020	Paid In Full	Miami	4,220.00	–
INV301366	Nov 23, 2020	Paid In Full	Miami	2,720.00	–
INV295495	Oct 19, 2020	Paid In Full	Miami	3,220.00	–
INV294657	Oct 13, 2020	Paid In Full	Miami	3,220.00	–
INV291056	Sep 21, 2020	Paid In Full	Miami	3,220.00	–
INV288415	Sep 3, 2020	Paid In Full	Miami	4,220.00	–
INV286422	Aug 19, 2020	Paid In Full	Miami	3,220.00	–
INV285023	Aug 10, 2020	Paid In Full	Miami	4,220.00	–
INV281116	Jul 16, 2020	Paid In Full	Miami	4,220.00	–
INV281117	Jul 16, 2020	Paid In Full	Miami	4,220.00	–
INV276474	Jun 15, 2020	Paid In Full	Miami	4,220.00	–
INVS262463	Apr 7, 2020	Paid In Full	Miami	3,995.00	–
INVS254100	Feb 25, 2020	Paid In Full	Miami	2,495.00	–
INVS248799	Jan 23, 2020	Paid In Full	Miami	2,495.00	–
INVS243953	Dec 19, 2019	Paid In Full	Miami	3,995.00	–

Hide empty fields Show technical names

Financial

Financial · 32 fields · 22 with a value · 10 empty

Account numberaccountnumber: Royal Plumbing
Balancebalance: 0.00
Billcitybillcity: Prairie City
Billcountrybillcountry: US
Billstatebillstate: IA
Billzipbillzip: 50228
Credit limitcreditlimit: 5000.00
Creditholdoverridecreditholdoverride: Off
Currencycurrency: US Dollar
Currencyprecisioncurrencyprecision: 2
Customer freight termscustentity_customer_freight_terms: Prepaid
Deposit balancedepositbalance: 0.00
Isbudgetapprovedisbudgetapproved: No
Overdue balanceoverduebalance: 0.00
Payment termsterms: Net 30
Polymorphcontainscreditlimitpolymorphcontainscreditlimit: Yes
Price levelpricelevel: WHOLESALE
Receivablesaccountreceivablesaccount: Use System Preference
Taxabletaxable: No
Taxexempttaxexempt: Yes
Taxroundingtaxrounding: Round Off
Unbilled ordersunbilledorders: 0.00

No value 10

Billattentionbillattention: —
Daysoverduedaysoverdue: —
Defaultbankaccountdefaultbankaccount: —
Origcurrencyorigcurrency: —
Parent currencyparent_currency: —
Resale numberresalenumber: —
Tax reg nocustentity_tax_reg_no: —
Taxfractionunittaxfractionunit: —
Taxitemtaxitem: —
Vatregnumbervatregnumber: —

Custom fields

Custom fields · 42 fields · 14 with a value · 28 empty

1custentity1: 35
2663 customer refundcustentity_2663_customer_refund: No
2663 direct debitcustentity_2663_direct_debit: No
Naw trans need approvalcustentity_naw_trans_need_approval: No
Nsts wodm claim ar deductioncustentity_nsts_wodm_claim_ar_deduction: No
Nsts wodm exclude customercustentity_nsts_wodm_exclude_customer: No
Scpq usercustentity_scpq_user: No
Ship hc vendorcustentity_ship_hc_vendor: No
Spa world anzzi productcustentity_spa_world_anzzi_product: No
Spa world atlantis tubcustentity_spa_world_atlantis_tub: No
Spa world steam spacustentity_spa_world_steam_spa: No
Spa world walkin tubcustentity_spa_world_walkin_tub: No
Wmsse asn requiredcustentity_wmsse_asn_required: No
Woocom cust created by scriptcustentity_woocom_cust_created_by_script: No

No value 28

4599 sg uencustentity_4599_sg_uen: —
9572 custref file formatcustentity_9572_custref_file_format: —
9572 dd file formatcustentity_9572_dd_file_format: —
9572 ddcust entitybank subcustentity_9572_ddcust_entitybank_sub: —
9572 ddcust entitybnkformatcustentity_9572_ddcust_entitybnkformat: —
9572 refcust entitybnkformatcustentity_9572_refcust_entitybnkformat: —
9572 refundcust entitybnk subcustentity_9572_refundcust_entitybnk_sub: —
9997 dd file formatcustentity_9997_dd_file_format: —
Diccustentity_dic: —
Esc annual revenuecustentity_esc_annual_revenue: —
Esc industrycustentity_esc_industry: —
Esc no of employeescustentity_esc_no_of_employees: —
Hj tc autopacktemplatecustentity_hj_tc_autopacktemplate: —
Hj tc default asncustentity_hj_tc_default_asn: —
Icocustentity_ico: —
Link lsacustentity_link_lsa: —
Link name lsacustentity_link_name_lsa: —
My brncustentity_my_brn: —
Ns os customer idcustentity_ns_os_customer_id: —
Ntcustomeridcustentity_ntcustomerid: —
Pacejet freight term overridecustentity_pacejet_freight_term_override: —
Pacejet freightacctoverridecustentity_pacejet_freightacctoverride: —
Pacejet ship from overridecustentity_pacejet_ship_from_override: —
Pacejet shipvia overridecustentity_pacejet_shipvia_override: —
Shopify customer idcustentity_shopify_customer_id: —
Sii idcustentity_sii_id: —
Sii id typecustentity_sii_id_type: —
Wayfair customer namecustentity_wayfair_customer_name: —

Others

Others · 63 fields · 45 with a value · 18 empty

Accessroleaccessrole: Customer Center
Accesstabchangedaccesstabchanged: No
Alcoholrecipienttypealcoholrecipienttype: Consumer
Buyingreasonbuyingreason: Previous Customer
Curridcurrid: 1841
Custpage 2663 translate msgscustpage_2663_translate_msgs: {"commision":"If you uncheck the Eligible for Commission field, you will no longer be able to pay commissions for this {value} using EFT.","invalsep":"Please use semicolon(;) to separate email addresses.","invalidemail":"Please enter a valid email address. "}
Custpage cs msgscustpage_cs_msgs: {"ERR_INVALID_VATREGNO":"VAT Registration number {0} is NOT valid.","INFO_VALID_VATREGNO":"VAT Registration number {0} is valid."}
Custpage itr subsidiarycachecustpage_itr_subsidiarycache: {"1":"US","5":"US","6":"US","3":"US","9":"US","2":"US","4":"US","7":"US","8":"US"}
Custpage taf subcountrycountcustpage_taf_subcountrycount: {"MY":0}
Custpage taf subsidiarycachecustpage_taf_subsidiarycache: {"1":"US","5":"US","6":"US","3":"US","9":"US","2":"US","4":"US","7":"US","8":"US"}
Endbeforestartendbeforestart: No
Entitynumberentitynumber: 2431
Entitytitleentitytitle: 2431 Royal Plumbing
Estimatedbudgetestimatedbudget: 0.00
Freeformstatepreffreeformstatepref: No
Giveaccesschangedgiveaccesschanged: No
Haschildrenhaschildren: No
Hasparenthasparent: No
Hasshippinghasshipping: No
InitiallyOverrideAllowedinitiallyOverrideAllowed: No
Intercoreceivablesacctprefintercoreceivablesacctpref: 732
Isautogeneratedrepresentingentityisautogeneratedrepresentingentity: No
Monthlyclosingmonthlyclosing: End of the Month
Nameorignameorig: 2431
Origbinactiveorigbinactive: No
Origgiveaccessoriggiveaccess: No
Origsubstatusorigsubstatus: 2
Printoncheckasprintoncheckas: Royal Plumbing
Propagateactivitypropagateactivity: No
Receivablesacctprefreceivablesacctpref: 122
Salesreadinesssalesreadiness: Hot
Sessioncountrysessioncountry: US
Shipcityshipcity: Prairie City
Shipcompleteshipcomplete: Yes
Shipcountryshipcountry: US
Shipping countryshipping_country: United States
Shippingcarriershippingcarrier: More
Shipstateshipstate: IA
Shipzipshipzip: 50228
Submitnext tsubmitnext_t: custjob
Submitnext ysubmitnext_y: CUSTOMER
Templatestoredtemplatestored: No
Thirdpartycountrythirdpartycountry: United States
Typetype: custjob
Webleadweblead: No

No value 18

Accesshelpaccesshelp: —
Assignedwebsiteassignedwebsite: —
Buyingtimeframebuyingtimeframe: —
Customwhencecustomwhence: —
Isindividualisindividual: —
Newaccesshelpnewaccesshelp: —
Origaccessroleorigaccessrole: —
Otherrelationshipsotherrelationships: —
Parentsubsidiaryparentsubsidiary: —
Prefccprocessorprefccprocessor: —
Reminderdaysreminderdays: —
Representingsubsidiaryrepresentingsubsidiary: —
Sendtransactionsviasendtransactionsvia: —
Shipattentionshipattention: —
Shippingitemshippingitem: —
Thirdpartyacctthirdpartyacct: —
Thirdpartycarrierthirdpartycarrier: —
Thirdpartyzipcodethirdpartyzipcode: —

System & IDs

System & IDs · 70 fields · 32 with a value · 38 empty

Accessrole refidaccessrole_refid: 14
Alcoholrecipienttype refidalcoholrecipienttype_refid: CONSUMER
Baserecordtypebaserecordtype: customer
Buyingreason refidbuyingreason_refid: 4
Category refidcategory_refid: 3
Creditholdoverride refidcreditholdoverride_refid: OFF
Currency refidcurrency_refid: 1
Customer freight terms refidcustentity_customer_freight_terms_refid: 1
Customformcustomform: Spa World - Customer Form
Customform refidcustomform_refid: 124
Editionedition: United States
Edition refidedition_refid: US
Emailpreference refidemailpreference_refid: PDF
Entitystatus refidentitystatus_refid: 16
Entryformquerystringentryformquerystring: stage=CUSTOMER&e=T&id=1841
Globalsubscriptionstatus refidglobalsubscriptionstatus_refid: 2
Idid: 1841
InternalIdInternalId: 1841
Monthlyclosing refidmonthlyclosing_refid: 31
Origcurrency refidorigcurrency_refid: 1
Pricelevel refidpricelevel_refid: 1
Receivablesaccount refidreceivablesaccount_refid: -10
Salesreadiness refidsalesreadiness_refid: 3
Salesrep refidsalesrep_refid: 588
Shipping country refidshipping_country_refid: US
Shippingcarrier refidshippingcarrier_refid: nonups
Subsidiary refidsubsidiary_refid: 1
Taxrounding refidtaxrounding_refid: OFF
Terms refidterms_refid: 2
Thirdpartycountry refidthirdpartycountry_refid: US
Unsubscribe refidunsubscribe_refid: Yes
Versionversion: 330

No value 38

9572 custref file format refidcustentity_9572_custref_file_format_refid: —
9572 dd file format refidcustentity_9572_dd_file_format_refid: —
9572 ddcust entitybank sub refidcustentity_9572_ddcust_entitybank_sub_refid: —
9572 ddcust entitybnkformat refidcustentity_9572_ddcust_entitybnkformat_refid: —
9572 refcust entitybnkformat refidcustentity_9572_refcust_entitybnkformat_refid: —
9572 refundcust entitybnk sub refidcustentity_9572_refundcust_entitybnk_sub_refid: —
9997 dd file format refidcustentity_9997_dd_file_format_refid: —
Assignedwebsite refidassignedwebsite_refid: —
Buyingtimeframe refidbuyingtimeframe_refid: —
Campaigncategory refidcampaigncategory_refid: —
Campaignevent refidcampaignevent_refid: —
Contact refidcontact_refid: —
Defaultbankaccount refiddefaultbankaccount_refid: —
Esc industry refidcustentity_esc_industry_refid: —
Hj tc autopacktemplate refidcustentity_hj_tc_autopacktemplate_refid: —
Hj tc default asn refidcustentity_hj_tc_default_asn_refid: —
Image refidimage_refid: —
Leadsource refidleadsource_refid: —
Negativenumberformat refidnegativenumberformat_refid: —
Nsbrowserenvnsbrowserenv: —
Numberformat refidnumberformat_refid: —
Pacejet freight term override refidcustentity_pacejet_freight_term_override_refid: —
Pacejet freightacctoverride refidcustentity_pacejet_freightacctoverride_refid: —
Pacejet ship from override refidcustentity_pacejet_ship_from_override_refid: —
Pacejet shipvia override refidcustentity_pacejet_shipvia_override_refid: —
Parent refidparent_refid: —
Partner refidpartner_refid: —
Prefccprocessor refidprefccprocessor_refid: —
Representingsubsidiary refidrepresentingsubsidiary_refid: —
Selectedtabselectedtab: —
Shippingitem refidshippingitem_refid: —
Sii id type refidcustentity_sii_id_type_refid: —
Sourcewebsite refidsourcewebsite_refid: —
Tax contact refidcustentity_tax_contact_refid: —
Taxfractionunit refidtaxfractionunit_refid: —
Taxitem refidtaxitem_refid: —
Territory refidterritory_refid: —
Thirdpartycarrier refidthirdpartycarrier_refid: —

Fields without a value are shown as “—”. Payment card and password fields are never shown.

Currency	Balance	Overdue	Deposits	Unbilled orders
1	0.00	0.00	0.00	0.00

Subscription	Subscribed	Last changed
2	No	12/4/2018 5:05 pm
1	No	12/4/2018 5:05 pm
4	No	12/4/2018 5:05 pm
5	No	12/4/2018 5:05 pm
3	No	12/4/2018 5:05 pm

Only the details of each file are in the archive. The files themselves are not available here.

Name	Type	Size (KB)	Added	Modified	Owner	Folder
ROYAL PLUMBING CRDIT INTL.txt	PLAINTEXT	5	3/6/2020 11:40 am	10/7/2020 5:21 am	-System-	Attachments Received

2431 Royal Plumbing Lost Customer

General

Contact

Address

Sales & marketing

Financial

Dates

Custom fields

Others

System & IDs