20099 Lens Remodeling and Contracting Services Closed Won
Balance0.00US Dollar
Overdue0.00
Sales repLuis MelendezSpa World Corporation
Latest 1 of 1 orders. See all with filters
| Order # | Date | Status | Location | Total |
|---|---|---|---|---|
| SOS2856455 | Mar 6, 2024 | Billed | Miami | 450.00 |
Latest 1 of 1 invoices. See all with filters
| Invoice # | Date | Status | Location | Total | Amount due |
|---|---|---|---|---|---|
| INV561366 | Mar 13, 2024 | Paid In Full | Miami | 450.00 | – |
General
General · 15 fields · 9 with a value · 6 empty
- Company namecompanyname
- Lens Remodeling and Contracting Services
- Customerentityid
- 20099 Lens Remodeling and Contracting Services
- 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 · 9 with a value · 15 empty
- Emailemail
- len@lensrmc.com
- Email preferenceemailpreference
- Default
- Email subscription statusglobalsubscriptionstatus
- Soft Opt-Out
- Emailtransactionsemailtransactions
- No
- Faxfax
- (732) 851-7559
- Faxtransactionsfaxtransactions
- No
- Phonephone
- (732) 851-7555
- Sendemailsendemail
- No
- Websiteurl
- http://www.lensrmc.com
No value 15
- Altemailaltemail
- —
- Alternate phonealtphone
- —
- Contactcontact
- —
- Email hc vencustentity_email_hc_ven
- —
- 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
- —
Address
Address · 14 fields · 9 with a value · 5 empty
- Billaddr1billaddr1
- 28 Harrison Ave
- Billaddr2billaddr2
- Suite 912-913
- Billaddresseebilladdressee
- Lens Remodeling and Contracting Services
- Default addressdefaultaddress
- Len Marcu Lens Remodeling and Contracting Services 28 Harrison Ave Suite 912-913 Englishtown NJ 07726 (732) 851-7555
- Hasbillingaddresshasbillingaddress
- Yes
- Hasshippingaddresshasshippingaddress
- Yes
- Shipaddr1shipaddr1
- 28 Harrison Ave
- Shipaddr2shipaddr2
- Suite 912-913
- Shipaddresseeshipaddressee
- Lens Remodeling and Contracting Services
No value 5
- 2663 email address notifcustentity_2663_email_address_notif
- —
- Billaddr3billaddr3
- —
- Defaultaddrbookdefaultaddrbook
- —
- Defaultaddresseedefaultaddressee
- —
- Shipaddr3shipaddr3
- —
Sales & marketing
Sales & marketing · 12 fields · 3 with a value · 9 empty
- Sales repsalesrep
- Luis Melendez
- Stagestage
- CUSTOMER
- Statusentitystatus
- CUSTOMER-Closed Won
No value 9
- Campaigncategorycampaigncategory
- —
- Campaigneventcampaignevent
- —
- Categorycategory
- —
- Defaultorderprioritydefaultorderpriority
- —
- Lead sourceleadsource
- —
- Partnerpartner
- —
- Sourcewebsitesourcewebsite
- —
- Stagenamestagename
- —
- Territoryterritory
- —
Financial
Financial · 32 fields · 19 with a value · 13 empty
- Balancebalance
- 0.00
- Billattentionbillattention
- Len Marcu
- Billcitybillcity
- Englishtown
- Billcountrybillcountry
- US
- Billstatebillstate
- NJ
- Billzipbillzip
- 07726
- 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
- Polymorphcontainscreditlimitpolymorphcontainscreditlimit
- Yes
- Receivablesaccountreceivablesaccount
- Use System Preference
- Taxabletaxable
- No
- Taxexempttaxexempt
- Yes
- Taxroundingtaxrounding
- Round Off
- Unbilled ordersunbilledorders
- 0.00
No value 13
- Account numberaccountnumber
- —
- Credit limitcreditlimit
- —
- Daysoverduedaysoverdue
- —
- Defaultbankaccountdefaultbankaccount
- —
- Origcurrencyorigcurrency
- —
- Parent currencyparent_currency
- —
- Payment termsterms
- —
- Price levelpricelevel
- —
- Resale numberresalenumber
- —
- Tax reg nocustentity_tax_reg_no
- —
- Taxfractionunittaxfractionunit
- —
- Taxitemtaxitem
- —
- Vatregnumbervatregnumber
- —
Dates
Dates · 7 fields · 3 with a value · 4 empty
- Date createddatecreated
- 3/5/2024 10:10 am
- Esc last modified datecustentity_esc_last_modified_date_dt
- Mar 5, 2024
- Last modifiedlastmodifieddate
- 3/5/2024 11:12 am
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
- 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 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 · 42 with a value · 21 empty
- Accessroleaccessrole
- Customer Center
- Accesstabchangedaccesstabchanged
- No
- Alcoholrecipienttypealcoholrecipienttype
- Consumer
- Curridcurrid
- 2573800
- 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
- 20099
- Entitytitleentitytitle
- 20099 Lens Remodeling and Contracting Services
- Freeformstatepreffreeformstatepref
- No
- Giveaccesschangedgiveaccesschanged
- No
- Haschildrenhaschildren
- No
- Hasparenthasparent
- No
- Hasshippinghasshipping
- No
- InitiallyOverrideAllowedinitiallyOverrideAllowed
- No
- Intercoreceivablesacctprefintercoreceivablesacctpref
- 732
- Isautogeneratedrepresentingentityisautogeneratedrepresentingentity
- No
- Monthlyclosingmonthlyclosing
- End of the Month
- Nameorignameorig
- 20099
- Origbinactiveorigbinactive
- No
- Origgiveaccessoriggiveaccess
- No
- Origsubstatusorigsubstatus
- 2
- Propagateactivitypropagateactivity
- No
- Receivablesacctprefreceivablesacctpref
- 122
- Sessioncountrysessioncountry
- US
- Shipattentionshipattention
- Len Marcu
- Shipcityshipcity
- Englishtown
- Shipcompleteshipcomplete
- No
- Shipcountryshipcountry
- US
- Shipping countryshipping_country
- United States
- Shippingcarriershippingcarrier
- More
- Shipstateshipstate
- NJ
- Shipzipshipzip
- 07726
- Submitnext tsubmitnext_t
- custjob
- Submitnext ysubmitnext_y
- CUSTOMER
- Templatestoredtemplatestored
- No
- Thirdpartycountrythirdpartycountry
- United States
- Typetype
- custjob
- Webleadweblead
- No
No value 21
- Accesshelpaccesshelp
- —
- Assignedwebsiteassignedwebsite
- —
- Buyingreasonbuyingreason
- —
- Buyingtimeframebuyingtimeframe
- —
- Customwhencecustomwhence
- —
- Estimatedbudgetestimatedbudget
- —
- Isindividualisindividual
- —
- Newaccesshelpnewaccesshelp
- —
- Origaccessroleorigaccessrole
- —
- Otherrelationshipsotherrelationships
- —
- Parentsubsidiaryparentsubsidiary
- —
- Prefccprocessorprefccprocessor
- —
- Printoncheckasprintoncheckas
- —
- Reminderdaysreminderdays
- —
- Representingsubsidiaryrepresentingsubsidiary
- —
- Salesreadinesssalesreadiness
- —
- Sendtransactionsviasendtransactionsvia
- —
- Shippingitemshippingitem
- —
- Thirdpartyacctthirdpartyacct
- —
- Thirdpartycarrierthirdpartycarrier
- —
- Thirdpartyzipcodethirdpartyzipcode
- —
System & IDs
System & IDs · 70 fields · 27 with a value · 43 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=2573800
- Globalsubscriptionstatus refidglobalsubscriptionstatus_refid
- 2
- Idid
- 2573800
- InternalIdInternalId
- 2573800
- Monthlyclosing refidmonthlyclosing_refid
- 31
- Origcurrency refidorigcurrency_refid
- 1
- Receivablesaccount refidreceivablesaccount_refid
- -10
- Salesrep refidsalesrep_refid
- 2476621
- Shipping country refidshipping_country_refid
- US
- Shippingcarrier refidshippingcarrier_refid
- nonups
- Subsidiary refidsubsidiary_refid
- 1
- Taxrounding refidtaxrounding_refid
- OFF
- Thirdpartycountry refidthirdpartycountry_refid
- US
- Unsubscribe refidunsubscribe_refid
- Yes
- Versionversion
- 14
No value 43
- 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
- —
- Terms refidterms_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.
28 Harrison Ave
Default billing Default shipping
Len Marcu
Lens Remodeling and Contracting Services
28 Harrison Ave
Suite 912-913
Englishtown NJ 07726
(732) 851-7555
No contacts on file.
| 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 |
|---|---|---|---|---|---|---|
| Lens SW App.pdf | 136 | 3/5/2024 11:12 am | 3/5/2024 11:12 am | Andrea T Augustin | ar accounting | |
| Lens W9.pdf | 235 | 3/5/2024 11:12 am | 3/5/2024 11:12 am | Andrea T Augustin | ar accounting | |
| M240305 (13).TXT | PLAINTEXT | 5 | 3/5/2024 11:11 am | 3/5/2024 11:11 am | Andrea T Augustin | ar accounting |