13085 A J Sterling Closed Won
Balance0.00US Dollar
Overdue0.00
Sales repDaphness Fils-AimeSpa World Corporation
Latest 1 of 1 orders. See all with filters
| Order # | Date | Status | Location | Total |
|---|---|---|---|---|
| SOS2547103 | Jun 1, 2020 | Billed | Miami | 1,999.00 |
Latest 1 of 1 invoices. See all with filters
| Invoice # | Date | Status | Location | Total | Amount due |
|---|---|---|---|---|---|
| INV276687 | Jun 16, 2020 | Paid In Full | Miami | 1,999.00 | – |
General
General · 15 fields · 8 with a value · 7 empty
- Customerentityid
- 13085 A J Sterling
- Has online accessgiveaccess
- No
- Inactiveisinactive
- No
- Is a projectisjob
- No
- Is an individualisperson
- Yes
- Print transactionsprinttransactions
- No
- Subsidiarysubsidiary
- Spa World Corporation
- Unsubscribed from emailsunsubscribe
- Yes
No value 7
- Commentscomments
- —
- Company namecompanyname
- —
- External IDexternalid
- —
- Imageimage
- —
- Negative number formatnegativenumberformat
- —
- Number formatnumberformat
- —
- Parent customerparent
- —
Contact
Contact · 24 fields · 10 with a value · 14 empty
- Emailemail
- ajsterling@aol.com
- Email preferenceemailpreference
- Default
- Email subscription statusglobalsubscriptionstatus
- Soft Opt-Out
- Emailtransactionsemailtransactions
- No
- Faxtransactionsfaxtransactions
- No
- First namefirstname
- A
- Last namelastname
- Sterling
- Middle namemiddlename
- Justin
- Phonephone
- (510) 772-0014
- Sendemailsendemail
- No
No value 14
- Altemailaltemail
- —
- Alternate phonealtphone
- —
- Contactcontact
- —
- Email hc vencustentity_email_hc_ven
- —
- Faxfax
- —
- 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
- 44 Sierra Ave
- Billaddresseebilladdressee
- A J Sterling
- Default addressdefaultaddress
- A J Sterling 44 Sierra Ave Piedmont CA 94611 (510) 772-0014
- Hasbillingaddresshasbillingaddress
- Yes
- Hasshippingaddresshasshippingaddress
- Yes
- Shipaddr1shipaddr1
- 44 Sierra Ave
- Shipaddresseeshipaddressee
- A J Sterling
No value 7
- 2663 email address notifcustentity_2663_email_address_notif
- —
- Billaddr2billaddr2
- —
- Billaddr3billaddr3
- —
- Defaultaddrbookdefaultaddrbook
- —
- Defaultaddresseedefaultaddressee
- —
- Shipaddr2shipaddr2
- —
- Shipaddr3shipaddr3
- —
Sales & marketing
Sales & marketing · 12 fields · 3 with a value · 9 empty
- Sales repsalesrep
- Daphness Fils-Aime
- Stagestage
- CUSTOMER
- Statusentitystatus
- CUSTOMER-Closed Won
No value 9
- Campaigncategorycampaigncategory
- —
- Campaigneventcampaignevent
- —
- Categorycategory
- —
- Defaultorderprioritydefaultorderpriority
- —
- Lead sourceleadsource
- —
- Partnerpartner
- —
- Sourcewebsitesourcewebsite
- —
- Stagenamestagename
- —
- Territoryterritory
- —
Financial
Financial · 32 fields · 18 with a value · 14 empty
- Balancebalance
- 0.00
- Billcitybillcity
- Piedmont
- Billcountrybillcountry
- US
- Billstatebillstate
- CA
- Billzipbillzip
- 94611
- Creditholdoverridecreditholdoverride
- Auto
- Currencycurrency
- US Dollar
- Currencyprecisioncurrencyprecision
- 2
- Customer freight termscustentity_customer_freight_terms
- Prepaid
- 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 14
- Account numberaccountnumber
- —
- Billattentionbillattention
- —
- 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
- 6/5/2020 5:27 pm
- Esc last modified datecustentity_esc_last_modified_date_dt
- Dec 27, 2022
- Last modifiedlastmodifieddate
- 12/27/2022 1:47 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 · 14 with a value · 28 empty
- 1custentity1
- 1
- 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 · 41 with a value · 22 empty
- Accessroleaccessrole
- Customer Center
- Accesstabchangedaccesstabchanged
- No
- Alcoholrecipienttypealcoholrecipienttype
- Consumer
- Curridcurrid
- 506236
- 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
- 13085
- Entitytitleentitytitle
- 13085 A J Sterling
- Freeformstatepreffreeformstatepref
- No
- Giveaccesschangedgiveaccesschanged
- No
- Haschildrenhaschildren
- No
- Hasparenthasparent
- No
- Hasshippinghasshipping
- No
- InitiallyOverrideAllowedinitiallyOverrideAllowed
- No
- Intercoreceivablesacctprefintercoreceivablesacctpref
- 732
- Isautogeneratedrepresentingentityisautogeneratedrepresentingentity
- No
- Monthlyclosingmonthlyclosing
- End of the Month
- Nameorignameorig
- 13085
- Origbinactiveorigbinactive
- No
- Origgiveaccessoriggiveaccess
- No
- Origsubstatusorigsubstatus
- 2
- Propagateactivitypropagateactivity
- No
- Receivablesacctprefreceivablesacctpref
- 122
- Sessioncountrysessioncountry
- US
- Shipcityshipcity
- Piedmont
- Shipcompleteshipcomplete
- No
- Shipcountryshipcountry
- US
- Shipping countryshipping_country
- United States
- Shippingcarriershippingcarrier
- More
- Shipstateshipstate
- CA
- Shipzipshipzip
- 94611
- Submitnext tsubmitnext_t
- custjob
- Submitnext ysubmitnext_y
- CUSTOMER
- Templatestoredtemplatestored
- No
- Thirdpartycountrythirdpartycountry
- United States
- Typetype
- custjob
- Webleadweblead
- No
No value 22
- Accesshelpaccesshelp
- —
- Assignedwebsiteassignedwebsite
- —
- Buyingreasonbuyingreason
- —
- Buyingtimeframebuyingtimeframe
- —
- Customwhencecustomwhence
- —
- Estimatedbudgetestimatedbudget
- —
- Isindividualisindividual
- —
- Newaccesshelpnewaccesshelp
- —
- Origaccessroleorigaccessrole
- —
- Otherrelationshipsotherrelationships
- —
- Parentsubsidiaryparentsubsidiary
- —
- Prefccprocessorprefccprocessor
- —
- Printoncheckasprintoncheckas
- —
- Reminderdaysreminderdays
- —
- Representingsubsidiaryrepresentingsubsidiary
- —
- Salesreadinesssalesreadiness
- —
- Sendtransactionsviasendtransactionsvia
- —
- Shipattentionshipattention
- —
- 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
- 1
- 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=506236
- Globalsubscriptionstatus refidglobalsubscriptionstatus_refid
- 2
- Idid
- 506236
- InternalIdInternalId
- 506236
- Monthlyclosing refidmonthlyclosing_refid
- 31
- Origcurrency refidorigcurrency_refid
- 1
- Receivablesaccount refidreceivablesaccount_refid
- -10
- Salesrep refidsalesrep_refid
- 234903
- 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
- 21
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.
44 Sierra Ave
Default billing Default shipping
A J Sterling
44 Sierra Ave
Piedmont CA 94611
(510) 772-0014
5623 bacon Rd
A J Sterling
5623 bacon Rd
Oakland CA 94619
(510) 772-0014
| Name | Role | Has access | |
|---|---|---|---|
| 13085 A J Sterling | 14 | ajsterling@aol.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 |
No files are attached to this customer.