2498 United Pipe and Supply Co Closed Won
Balance0.00US Dollar
Overdue0.00Terms: Net 30
Sales repJason LeGunnSpa World Corporation
Loading…
Loading…
Loading…
Latest 7 of 7 orders. See all with filters
| Order # | Date | Status | Location | Total |
|---|---|---|---|---|
| SOS2554816 | Jul 22, 2020 | Billed | Miami | 0.00 |
| SOS2544867 | May 26, 2020 | Billed | Miami | 45.00 |
| SOS252071 | Mar 9, 2020 | Closed | Miami | 45.00 |
| SOS241891 | Jan 16, 2020 | Billed | Miami | 17,346.00 |
| SOS229751 | Oct 24, 2019 | Billed | Miami | 560.00 |
| SOSWC9879 | Mar 27, 2019 | Billed | Miami | 350.00 |
| 176601 | Jan 29, 2019 | Billed | Miami | 510.00 |
Latest 8 of 8 invoices. See all with filters
| Invoice # | Date | Status | Location | Total | Amount due |
|---|---|---|---|---|---|
| INV283143 | Jul 29, 2020 | Paid In Full | Miami | 0.00 | – |
| INV272457 | May 27, 2020 | Paid In Full | Miami | 45.00 | – |
| INVS249515 | Jan 28, 2020 | Paid In Full | Miami | 17,346.00 | – |
| INVS239607 | Nov 20, 2019 | Paid In Full | Miami | 560.00 | – |
| INVSWC10218 | Apr 3, 2019 | Paid In Full | Miami | 350.00 | – |
| INVSWC2479 | Feb 19, 2019 | Paid In Full | Miami | 510.00 | – |
| INVS14856 | Feb 12, 2019 | Paid In Full | Miami | 17,274.00 | – |
| 223341 | Dec 20, 2018 | Paid In Full | Miami | 610.00 | – |
General
General · 15 fields · 10 with a value · 5 empty
- Company namecompanyname
- United Pipe and Supply Co
- Customerentityid
- 2498 United Pipe and Supply Co
- External IDexternalid
- United Pipe of Supply Co
- 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 5
- Commentscomments
- —
- Imageimage
- —
- Negative number formatnegativenumberformat
- —
- Number formatnumberformat
- —
- Parent customerparent
- —
Contact
Contact · 24 fields · 8 with a value · 16 empty
- Alternate phonealtphone
- (309) 828-8487
- Emailemail
- AP@UPSCO.ORG
- Email preferenceemailpreference
- Email subscription statusglobalsubscriptionstatus
- Soft Opt-Out
- Emailtransactionsemailtransactions
- Yes
- Faxtransactionsfaxtransactions
- No
- Phonephone
- (309) 828-8487
- Sendemailsendemail
- No
No value 16
- Altemailaltemail
- —
- 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 · 7 with a value · 7 empty
- Billaddr1billaddr1
- 13963 N 1000 East Rd
- Billaddresseebilladdressee
- United Pipe Supply Co
- Default addressdefaultaddress
- United Pipe Supply Co 13963 N 1000 East Rd Bloomington IL 61705 United States
- Hasbillingaddresshasbillingaddress
- Yes
- Hasshippingaddresshasshippingaddress
- Yes
- Shipaddr1shipaddr1
- pick up
- Shipaddresseeshipaddressee
- United Pipe Supply Co
No value 7
- 2663 email address notifcustentity_2663_email_address_notif
- —
- Billaddr2billaddr2
- —
- Billaddr3billaddr3
- —
- Defaultaddrbookdefaultaddrbook
- —
- Defaultaddresseedefaultaddressee
- —
- Shipaddr2shipaddr2
- —
- Shipaddr3shipaddr3
- —
Sales & marketing
Sales & marketing · 12 fields · 5 with a value · 7 empty
- Categorycategory
- Wholesale
- Defaultorderprioritydefaultorderpriority
- 1.00
- Sales repsalesrep
- Jason LeGunn
- Stagestage
- CUSTOMER
- Statusentitystatus
- CUSTOMER-Closed Won
No value 7
- Campaigncategorycampaigncategory
- —
- Campaigneventcampaignevent
- —
- Lead sourceleadsource
- —
- Partnerpartner
- —
- Sourcewebsitesourcewebsite
- —
- Stagenamestagename
- —
- Territoryterritory
- —
Financial
Financial · 32 fields · 21 with a value · 11 empty
- Account numberaccountnumber
- United Pipe Supply Co
- Balancebalance
- 0.00
- Billcitybillcity
- Bloomington
- Billcountrybillcountry
- US
- Billstatebillstate
- IL
- Billzipbillzip
- 61705
- Creditholdoverridecreditholdoverride
- Auto
- 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 11
- Billattentionbillattention
- —
- Credit limitcreditlimit
- —
- Daysoverduedaysoverdue
- —
- Defaultbankaccountdefaultbankaccount
- —
- Origcurrencyorigcurrency
- —
- Parent currencyparent_currency
- —
- Resale numberresalenumber
- —
- Tax reg nocustentity_tax_reg_no
- —
- Taxfractionunittaxfractionunit
- —
- Taxitemtaxitem
- —
- Vatregnumbervatregnumber
- —
Dates
Dates · 7 fields · 4 with a value · 3 empty
- Date createddatecreated
- 12/4/2018 5:07 pm
- Esc last modified datecustentity_esc_last_modified_date_dt
- Dec 27, 2022
- Last modifiedlastmodifieddate
- 12/27/2022 1:08 pm
- Start datestartdate_dt
- Oct 24, 2019
No value 3
- Date lsacustentity_date_lsa_dt
- —
- End dateenddate_dt
- —
- Spa world customer sincecustentity_spa_world_customer_since_dt
- —
Custom fields
Custom fields · 42 fields · 14 with a value · 28 empty
- 1custentity1
- 7
- 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
- 1916
- 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
- 2498
- Entitytitleentitytitle
- 2498 United Pipe and Supply Co
- 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
- 2498
- Origbinactiveorigbinactive
- No
- Origgiveaccessoriggiveaccess
- No
- Origsubstatusorigsubstatus
- 2
- Printoncheckasprintoncheckas
- United Pipe Supply Co
- Propagateactivitypropagateactivity
- No
- Receivablesacctprefreceivablesacctpref
- 122
- Salesreadinesssalesreadiness
- Hot
- Sessioncountrysessioncountry
- US
- Shipcityshipcity
- pick up
- Shipcompleteshipcomplete
- Yes
- Shipcountryshipcountry
- US
- Shipping countryshipping_country
- United States
- Shippingcarriershippingcarrier
- More
- Shipstateshipstate
- IL
- Shipzipshipzip
- pick up
- 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
- AUTO
- 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
- Entitystatus refidentitystatus_refid
- 13
- Entryformquerystringentryformquerystring
- stage=CUSTOMER&e=T&id=1916
- Globalsubscriptionstatus refidglobalsubscriptionstatus_refid
- 2
- Idid
- 1916
- InternalIdInternalId
- 1916
- Monthlyclosing refidmonthlyclosing_refid
- 31
- Origcurrency refidorigcurrency_refid
- 1
- Pricelevel refidpricelevel_refid
- 1
- Receivablesaccount refidreceivablesaccount_refid
- -10
- Salesreadiness refidsalesreadiness_refid
- 3
- Salesrep refidsalesrep_refid
- 784860
- 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
- 128
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
- —
No field matches your search.
Fields without a value are shown as “—”. Payment card and password fields are never shown.
13963 N 1000 East Rd
United Pipe of Supply Co
13963 N 1000 East Rd
Bloomington IL 61705
United States
13963 N 1000 East Rd
United Pipe of Supply Co
13963 N 1000 East Rd
Bloomington IL 61705
United States
13963 N 1000 East Rd
United Pipe of Supply Co
13963 N 1000 East Rd
Bloomington IL 61705
United States
13963 N 1000 East Rd
United Pipe of Supply Co
13963 N 1000 East Rd
Bloomington IL 61705
United States
13963 N 1000 East Rd
Default billing
United Pipe Supply Co
13963 N 1000 East Rd
Bloomington IL 61705
United States
pickup
Default shipping
United Pipe Supply Co
pick up
pick up IL pick up
13963 N 1000 East Rd
C/O Kelsey Skinner
United Pipe and Supply Co
13963 N 1000 East Rd
Bloomington IL 61705
(309) 828-8487
| Name | Role | Has access | |
|---|---|---|---|
| Tamra Branan | 14 | tamra@upsco.org | No |
| 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:07 pm |
| 1 | No | 12/4/2018 5:07 pm |
| 4 | No | 12/4/2018 5:07 pm |
| 5 | No | 12/4/2018 5:07 pm |
| 3 | No | 12/4/2018 5:07 pm |
No files are attached to this customer.