20029 Advance Plumbing Supply of Walled Lake, Inc Closed Won
Balance0.00US Dollar
Overdue0.00Terms: Net 30
Orders0
Invoices0
Sales repJose PazSpa World Corporation
This customer has no orders.
This customer has no invoices.
General
General · 15 fields · 9 with a value · 6 empty
- Company namecompanyname
- Advance Plumbing Supply of Walled Lake, Inc
- Customerentityid
- 20029 Advance Plumbing Supply of Walled Lake, Inc
- Has online accessgiveaccess
- No
- Inactiveisinactive
- No
- Is a projectisjob
- No
- Is an individualisperson
- No
- Print transactionsprinttransactions
- No
- Subsidiarysubsidiary
- Spa World Corporation
- Unsubscribed from emailsunsubscribe
- Yes
No value 6
- Commentscomments
- —
- External IDexternalid
- —
- Imageimage
- —
- Negative number formatnegativenumberformat
- —
- Number formatnumberformat
- —
- Parent customerparent
- —
Contact
Contact · 24 fields · 7 with a value · 17 empty
- Emailemail
- tiffany.pupava@advanceplumbing.com
- Email preferenceemailpreference
- Default
- Email subscription statusglobalsubscriptionstatus
- Soft Opt-Out
- Emailtransactionsemailtransactions
- No
- Faxtransactionsfaxtransactions
- No
- Phonephone
- (249) 669-7474
- Sendemailsendemail
- No
No value 17
- Altemailaltemail
- —
- Alternate phonealtphone
- —
- Contactcontact
- —
- Email hc vencustentity_email_hc_ven
- —
- Faxfax
- —
- First namefirstname
- —
- Last namelastname
- —
- Middle namemiddlename
- —
- Mobilephonemobilephone
- —
- Phone hc cuscustentity_phone_hc_cus
- —
- Salutationsalutation
- —
- Tax contactcustentity_tax_contact
- —
- Tax contact firstcustentity_tax_contact_first
- —
- Tax contact lastcustentity_tax_contact_last
- —
- Tax contact middlecustentity_tax_contact_middle
- —
- Titletitle
- —
- Websiteurl
- —
Address
Address · 14 fields · 5 with a value · 9 empty
- Billaddr1billaddr1
- 1977 E. West Maple Rd
- Billaddresseebilladdressee
- Advance Plumbing Supply of Walled Lake, Inc
- Default addressdefaultaddress
- Advance Plumbing Supply of Walled Lake, Inc 1977 E. West Maple Rd Walled Lake MI 48390
- Hasbillingaddresshasbillingaddress
- Yes
- Hasshippingaddresshasshippingaddress
- No
No value 9
- 2663 email address notifcustentity_2663_email_address_notif
- —
- Billaddr2billaddr2
- —
- Billaddr3billaddr3
- —
- Defaultaddrbookdefaultaddrbook
- —
- Defaultaddresseedefaultaddressee
- —
- Shipaddr1shipaddr1
- —
- Shipaddr2shipaddr2
- —
- Shipaddr3shipaddr3
- —
- Shipaddresseeshipaddressee
- —
Sales & marketing
Sales & marketing · 12 fields · 3 with a value · 9 empty
- Sales repsalesrep
- Jose Paz
- Stagestage
- CUSTOMER
- Statusentitystatus
- CUSTOMER-Closed Won
No value 9
- Campaigncategorycampaigncategory
- —
- Campaigneventcampaignevent
- —
- Categorycategory
- —
- Defaultorderprioritydefaultorderpriority
- —
- Lead sourceleadsource
- —
- Partnerpartner
- —
- Sourcewebsitesourcewebsite
- —
- Stagenamestagename
- —
- Territoryterritory
- —
Financial
Financial · 32 fields · 21 with a value · 11 empty
- Balancebalance
- 0.00
- Billcitybillcity
- Walled Lake
- Billcountrybillcountry
- US
- Billstatebillstate
- MI
- Billzipbillzip
- 48390
- Credit limitcreditlimit
- 25000.00
- Creditholdoverridecreditholdoverride
- Auto
- Currencycurrency
- US Dollar
- Currencyprecisioncurrencyprecision
- 2
- Customer freight termscustentity_customer_freight_terms
- Prepaid and Charge
- Deposit balancedepositbalance
- 0.00
- Isbudgetapprovedisbudgetapproved
- No
- Overdue balanceoverduebalance
- 0.00
- Payment termsterms
- Net 30
- Polymorphcontainscreditlimitpolymorphcontainscreditlimit
- Yes
- Receivablesaccountreceivablesaccount
- Use System Preference
- Taxabletaxable
- No
- Taxexempttaxexempt
- Yes
- Taxroundingtaxrounding
- Round Off
- Unbilled ordersunbilledorders
- 0.00
- Vatregnumbervatregnumber
- 38-2936735
No value 11
- Account numberaccountnumber
- —
- Billattentionbillattention
- —
- Daysoverduedaysoverdue
- —
- Defaultbankaccountdefaultbankaccount
- —
- Origcurrencyorigcurrency
- —
- Parent currencyparent_currency
- —
- Price levelpricelevel
- —
- Resale numberresalenumber
- —
- Tax reg nocustentity_tax_reg_no
- —
- Taxfractionunittaxfractionunit
- —
- Taxitemtaxitem
- —
Dates
Dates · 7 fields · 3 with a value · 4 empty
- Date createddatecreated
- 9/1/2023 11:51 am
- Esc last modified datecustentity_esc_last_modified_date_dt
- Sep 1, 2023
- Last modifiedlastmodifieddate
- 9/1/2023 3:38 pm
No value 4
- Date lsacustentity_date_lsa_dt
- —
- End dateenddate_dt
- —
- Spa world customer sincecustentity_spa_world_customer_since_dt
- —
- Start datestartdate_dt
- —
Custom fields
Custom fields · 42 fields · 13 with a value · 29 empty
- 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
- Yes
- Spa world atlantis tubcustentity_spa_world_atlantis_tub
- Yes
- Spa world steam spacustentity_spa_world_steam_spa
- Yes
- Spa world walkin tubcustentity_spa_world_walkin_tub
- Yes
- Wmsse asn requiredcustentity_wmsse_asn_required
- No
- Woocom cust created by scriptcustentity_woocom_cust_created_by_script
- No
No value 29
- 1custentity1
- —
- 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 · 37 with a value · 26 empty
- Accessroleaccessrole
- Customer Center
- Accesstabchangedaccesstabchanged
- No
- Alcoholrecipienttypealcoholrecipienttype
- Consumer
- Curridcurrid
- 2266808
- 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
- 20029
- Entitytitleentitytitle
- 20029 Advance Plumbing Supply of Walled Lake, Inc
- Freeformstatepreffreeformstatepref
- No
- Giveaccesschangedgiveaccesschanged
- No
- Haschildrenhaschildren
- No
- Hasparenthasparent
- No
- Hasshippinghasshipping
- No
- InitiallyOverrideAllowedinitiallyOverrideAllowed
- No
- Intercoreceivablesacctprefintercoreceivablesacctpref
- 732
- Isautogeneratedrepresentingentityisautogeneratedrepresentingentity
- No
- Monthlyclosingmonthlyclosing
- End of the Month
- Nameorignameorig
- 20029
- Origbinactiveorigbinactive
- No
- Origgiveaccessoriggiveaccess
- No
- Origsubstatusorigsubstatus
- 2
- Propagateactivitypropagateactivity
- No
- Receivablesacctprefreceivablesacctpref
- 122
- Sessioncountrysessioncountry
- US
- Shipcompleteshipcomplete
- No
- Shipping countryshipping_country
- United States
- Shippingcarriershippingcarrier
- More
- Submitnext tsubmitnext_t
- custjob
- Submitnext ysubmitnext_y
- CUSTOMER
- Templatestoredtemplatestored
- No
- Thirdpartycountrythirdpartycountry
- United States
- Typetype
- custjob
- Webleadweblead
- No
No value 26
- Accesshelpaccesshelp
- —
- Assignedwebsiteassignedwebsite
- —
- Buyingreasonbuyingreason
- —
- Buyingtimeframebuyingtimeframe
- —
- Customwhencecustomwhence
- —
- Estimatedbudgetestimatedbudget
- —
- Isindividualisindividual
- —
- Newaccesshelpnewaccesshelp
- —
- Origaccessroleorigaccessrole
- —
- Otherrelationshipsotherrelationships
- —
- Parentsubsidiaryparentsubsidiary
- —
- Prefccprocessorprefccprocessor
- —
- Printoncheckasprintoncheckas
- —
- Reminderdaysreminderdays
- —
- Representingsubsidiaryrepresentingsubsidiary
- —
- Salesreadinesssalesreadiness
- —
- Sendtransactionsviasendtransactionsvia
- —
- Shipattentionshipattention
- —
- Shipcityshipcity
- —
- Shipcountryshipcountry
- —
- Shippingitemshippingitem
- —
- Shipstateshipstate
- —
- Shipzipshipzip
- —
- Thirdpartyacctthirdpartyacct
- —
- Thirdpartycarrierthirdpartycarrier
- —
- Thirdpartyzipcodethirdpartyzipcode
- —
System & IDs
System & IDs · 70 fields · 28 with a value · 42 empty
- Accessrole refidaccessrole_refid
- 14
- Alcoholrecipienttype refidalcoholrecipienttype_refid
- CONSUMER
- Baserecordtypebaserecordtype
- customer
- Creditholdoverride refidcreditholdoverride_refid
- AUTO
- Currency refidcurrency_refid
- 1
- Customer freight terms refidcustentity_customer_freight_terms_refid
- 2
- Customformcustomform
- Spa World - Customer Form
- Customform refidcustomform_refid
- 124
- Editionedition
- United States
- Edition refidedition_refid
- US
- Emailpreference refidemailpreference_refid
- DEFAULT
- Entitystatus refidentitystatus_refid
- 13
- Entryformquerystringentryformquerystring
- stage=CUSTOMER&e=T&id=2266808
- Globalsubscriptionstatus refidglobalsubscriptionstatus_refid
- 2
- Idid
- 2266808
- InternalIdInternalId
- 2266808
- Monthlyclosing refidmonthlyclosing_refid
- 31
- Origcurrency refidorigcurrency_refid
- 1
- Receivablesaccount refidreceivablesaccount_refid
- -10
- Salesrep refidsalesrep_refid
- 2046683
- 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
- 14
No value 42
- 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
- —
- Buyingreason refidbuyingreason_refid
- —
- Buyingtimeframe refidbuyingtimeframe_refid
- —
- Campaigncategory refidcampaigncategory_refid
- —
- Campaignevent refidcampaignevent_refid
- —
- Category refidcategory_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
- —
- Pricelevel refidpricelevel_refid
- —
- Representingsubsidiary refidrepresentingsubsidiary_refid
- —
- Salesreadiness refidsalesreadiness_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
- —
No field matches your search.
Fields without a value are shown as “—”. Payment card and password fields are never shown.
1977 E. West Maple Rd
Default billing
Advance Plumbing Supply of Walled Lake, Inc
1977 E. West Maple Rd
Walled Lake MI 48390
| Name | Role | Has access | |
|---|---|---|---|
| Tiffany Pupava | 14 | tiffany.pupava@advanceplumbing.com | No |
| Currency | Balance | Overdue | Deposits | Unbilled orders |
|---|---|---|---|---|
| 1 | 0.00 | 0.00 | 0.00 | 0.00 |
| Subscription | Subscribed | Last changed |
|---|---|---|
| 2 | No | |
| 1 | No | |
| 4 | No | |
| 5 | No | |
| 3 | No |
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 |
|---|---|---|---|---|---|---|
| 20029 Advance Plumbing Supply of Walled Lake, Inc- credit check.TXT | PLAINTEXT | 5 | 9/1/2023 3:36 pm | 9/1/2023 3:36 pm | Prismeth Perez | CC Authorization |
| Advance Plumbing Supply of Walled Lake, Inc.pdf | 4645 | 9/1/2023 11:50 am | 9/1/2023 11:50 am | Prismeth Perez | Applications |