Customer 2012 1st Choice Home Improvement Inc

Order #	Date	Status	Location	Total
SOS222600	Aug 27, 2019	Billed	Miami	142.50
SOS218425	Jul 24, 2019	Billed	Miami	4,171.00
SOSWC3602	Nov 30, 2018	Cancelled	Miami	3,847.00
SOSWC5528	Nov 30, 2018	Billed	Miami	3,847.00

Invoice #	Date	Status	Location	Total	Amount due
INVS226722	Aug 8, 2019	Paid In Full	Miami	4,171.00	–
INVSWC5355	Mar 7, 2019	Paid In Full	Miami	3,847.08	–
226920	Jan 18, 2019	Paid In Full	Miami	0.00	–
215448	Jan 1, 2019	Paid In Full	Miami	273.55	–
215441	Oct 15, 2018	Paid In Full	Miami	1,249.33	–
214808	Oct 10, 2018	Paid In Full	Miami	474.16	–

General

General · 15 fields · 10 with a value · 5 empty

Company namecompanyname: 1st Choice Home Improvement Inc
Customerentityid: 2012 1st Choice Home Improvement Inc
External IDexternalid: 1st Choice Home Improvement
Has online accessgiveaccess: No
Inactiveisinactive: No
Is a projectisjob: No
Is an individualisperson: No
Print transactionsprinttransactions: No
Subsidiarysubsidiary: Spa World Corporation
Unsubscribed from emailsunsubscribe: No

No value 5

Commentscomments: —
Imageimage: —
Negative number formatnegativenumberformat: —
Number formatnumberformat: —
Parent customerparent: —

Contact

Contact · 24 fields · 7 with a value · 17 empty

Emailemail: steve@1stchoicehomeimprovements.com
Email preferenceemailpreference: PDF
Email subscription statusglobalsubscriptionstatus: Soft Opt-In
Emailtransactionsemailtransactions: No
Faxtransactionsfaxtransactions: No
Phonephone: (850) 476-8887
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 · 7 with a value · 7 empty

Billaddr1billaddr1: 445 Corday Street Suite 1
Billaddresseebilladdressee: 1st Choice Home Improvements Inc
Default addressdefaultaddress: Stephen Smart 1st Choice Home Improvements Inc 445 Corday Street Suite 1 Pensacola FL 32503 United States
Hasbillingaddresshasbillingaddress: Yes
Hasshippingaddresshasshippingaddress: Yes
Shipaddr1shipaddr1: 445 Corday Street Suite 1
Shipaddresseeshipaddressee: 1st Choice Home Improvements Inc

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-Lost Customer

No value 7

Campaigncategorycampaigncategory: —
Campaigneventcampaignevent: —
Lead sourceleadsource: —
Partnerpartner: —
Sourcewebsitesourcewebsite: —
Stagenamestagename: —
Territoryterritory: —

Financial

Financial · 32 fields · 21 with a value · 11 empty

Account numberaccountnumber: 1st Choice Home Improvements Inc
Balancebalance: 0.00
Billattentionbillattention: Stephen Smart
Billcitybillcity: Pensacola
Billcountrybillcountry: US
Billstatebillstate: FL
Billzipbillzip: 32503
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
Receivablesaccountreceivablesaccount: Use System Preference
Taxabletaxable: No
Taxexempttaxexempt: Yes
Taxroundingtaxrounding: Round Off
Unbilled ordersunbilledorders: 0.00

No value 11

Credit limitcreditlimit: —
Daysoverduedaysoverdue: —
Defaultbankaccountdefaultbankaccount: —
Origcurrencyorigcurrency: —
Parent currencyparent_currency: —
Price levelpricelevel: —
Resale numberresalenumber: —
Tax reg nocustentity_tax_reg_no: —
Taxfractionunittaxfractionunit: —
Taxitemtaxitem: —
Vatregnumbervatregnumber: —

Dates

Dates · 7 fields · 4 with a value · 3 empty

Date createddatecreated: 2/1/2019 3:24 pm
Esc last modified datecustentity_esc_last_modified_date_dt: Dec 27, 2022
Last modifiedlastmodifieddate: 12/27/2022 1:10 pm
Start datestartdate_dt: Aug 27, 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: 5
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 · 46 with a value · 17 empty

Accessroleaccessrole: Customer Center
Accesstabchangedaccesstabchanged: No
Alcoholrecipienttypealcoholrecipienttype: Consumer
Buyingreasonbuyingreason: Previous Customer
Curridcurrid: 4166
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: 2012
Entitytitleentitytitle: 2012 1st Choice Home Improvement Inc
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: 2012
Origbinactiveorigbinactive: No
Origgiveaccessoriggiveaccess: No
Origsubstatusorigsubstatus: 1
Printoncheckasprintoncheckas: 1st Choice Home Improvements Inc
Propagateactivitypropagateactivity: No
Receivablesacctprefreceivablesacctpref: 122
Salesreadinesssalesreadiness: Hot
Sessioncountrysessioncountry: US
Shipattentionshipattention: Stephen Smart
Shipcityshipcity: Pensacola
Shipcompleteshipcomplete: Yes
Shipcountryshipcountry: US
Shipping countryshipping_country: United States
Shippingcarriershippingcarrier: More
Shipstateshipstate: FL
Shipzipshipzip: 32503
Submitnext tsubmitnext_t: custjob
Submitnext ysubmitnext_y: CUSTOMER
Templatestoredtemplatestored: No
Thirdpartycountrythirdpartycountry: United States
Typetype: custjob
Webleadweblead: No

No value 17

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

System & IDs

System & IDs · 70 fields · 31 with a value · 39 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: PDF
Entitystatus refidentitystatus_refid: 16
Entryformquerystringentryformquerystring: stage=CUSTOMER&e=T&id=4166
Globalsubscriptionstatus refidglobalsubscriptionstatus_refid: 1
Idid: 4166
InternalIdInternalId: 4166
Monthlyclosing refidmonthlyclosing_refid: 31
Origcurrency refidorigcurrency_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: No
Versionversion: 64

No value 39

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: —
Pricelevel refidpricelevel_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: —