20118 SJ Operations LLC Closed Won
Balance0.99US Dollar
Overdue0.99
Sales repLuis MelendezSpa World Corporation
Latest 2 of 2 orders. See all with filters
| Order # | Date | Status | Location | Total |
|---|---|---|---|---|
| SOS2871498 | Jun 3, 2024 | Billed | Miami | 1,897.00 |
| SOS2868182 | May 10, 2024 | Billed | Miami | 1,599.99 |
Latest 2 of 2 invoices. See all with filters
| Invoice # | Date | Status | Location | Total | Amount due |
|---|---|---|---|---|---|
| INV574885 | Jun 6, 2024 | Paid In Full | Miami | 1,897.00 | – |
| INV571875 | May 15, 2024 | Paid In Full | Miami | 1,599.99 | – |
General
General · 15 fields · 9 with a value · 6 empty
- Company namecompanyname
- SJ Operations LLC
- Customerentityid
- 20118 SJ Operations LLC
- 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
- jassie@elegantshowersystems.com
- Email preferenceemailpreference
- Default
- Email subscription statusglobalsubscriptionstatus
- Soft Opt-Out
- Emailtransactionsemailtransactions
- No
- Faxfax
- (380) 214-2446
- Faxtransactionsfaxtransactions
- No
- Phonephone
- (614) 962-0071
- Sendemailsendemail
- No
- Websiteurl
- http://elegantshowersystems.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 · 7 with a value · 7 empty
- Billaddr1billaddr1
- 240 Harwood Ct
- Billaddresseebilladdressee
- SJ Operations LLC
- Default addressdefaultaddress
- Jaskirat Ghuman SJ Operations LLC 240 Harwood Ct Delaware OH 43015 (614) 962-0071
- Hasbillingaddresshasbillingaddress
- Yes
- Hasshippingaddresshasshippingaddress
- Yes
- Shipaddr1shipaddr1
- 6605 Longshore St
- Shipaddresseeshipaddressee
- SJ Operations LLC
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
- 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 · 20 with a value · 12 empty
- Balancebalance
- 0.99
- Billattentionbillattention
- Jaskirat Ghuman
- Billcitybillcity
- Delaware
- Billcountrybillcountry
- US
- Billstatebillstate
- OH
- Billzipbillzip
- 43015
- Creditholdoverridecreditholdoverride
- Auto
- Currencycurrency
- US Dollar
- Currencyprecisioncurrencyprecision
- 2
- Customer freight termscustentity_customer_freight_terms
- Prepaid and Charge
- Daysoverduedaysoverdue
- 15
- Deposit balancedepositbalance
- 0.00
- Isbudgetapprovedisbudgetapproved
- No
- Overdue balanceoverduebalance
- 0.99
- Polymorphcontainscreditlimitpolymorphcontainscreditlimit
- Yes
- Receivablesaccountreceivablesaccount
- Use System Preference
- Taxabletaxable
- No
- Taxexempttaxexempt
- Yes
- Taxroundingtaxrounding
- Round Off
- Unbilled ordersunbilledorders
- 0.00
No value 12
- Account numberaccountnumber
- —
- Credit limitcreditlimit
- —
- 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
- 4/15/2024 9:23 am
- Esc last modified datecustentity_esc_last_modified_date_dt
- Apr 18, 2024
- Last modifiedlastmodifieddate
- 4/18/2024 1:15 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
- 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
- 2641343
- 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
- 20118
- Entitytitleentitytitle
- 20118 SJ Operations LLC
- Freeformstatepreffreeformstatepref
- No
- Giveaccesschangedgiveaccesschanged
- No
- Haschildrenhaschildren
- No
- Hasparenthasparent
- No
- Hasshippinghasshipping
- No
- InitiallyOverrideAllowedinitiallyOverrideAllowed
- No
- Intercoreceivablesacctprefintercoreceivablesacctpref
- 732
- Isautogeneratedrepresentingentityisautogeneratedrepresentingentity
- No
- Monthlyclosingmonthlyclosing
- End of the Month
- Nameorignameorig
- 20118
- Origbinactiveorigbinactive
- No
- Origgiveaccessoriggiveaccess
- No
- Origsubstatusorigsubstatus
- 2
- Propagateactivitypropagateactivity
- No
- Receivablesacctprefreceivablesacctpref
- 122
- Sessioncountrysessioncountry
- US
- Shipattentionshipattention
- JASSIE GHUMAN
- Shipcityshipcity
- Dublin
- Shipcompleteshipcomplete
- No
- Shipcountryshipcountry
- US
- Shipping countryshipping_country
- United States
- Shippingcarriershippingcarrier
- More
- Shipstateshipstate
- OH
- Shipzipshipzip
- 43017
- 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=2641343
- Globalsubscriptionstatus refidglobalsubscriptionstatus_refid
- 2
- Idid
- 2641343
- InternalIdInternalId
- 2641343
- 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
- 15
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.
6605 Longshore St
Default shipping
JASSIE GHUMAN
SJ Operations LLC
6605 Longshore St
Dublin OH 43017
(614) 962-0071
240 Harwood Ct
Default billing
Jaskirat Ghuman
SJ Operations LLC
240 Harwood Ct
Delaware OH 43015
(614) 962-0071
4400 Bellaire Ave
Andrew Miller
4400 Bellaire Ave
4400 Bellaire Ave
Dublin OH 43017
No contacts on file.
| Currency | Balance | Overdue | Deposits | Unbilled orders |
|---|---|---|---|---|
| 1 | 0.99 | 0.99 | 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 |
|---|---|---|---|---|---|---|
| 20118 SJ Operations LLC FW Credit Application.msg | MISCBINARY | 4620 | 4/18/2024 1:15 pm | 4/18/2024 1:15 pm | Andrea T Augustin | ar accounting |
| SJ Operations Credit report.jpg.TXT | PLAINTEXT | 5 | 4/15/2024 10:17 am | 4/15/2024 10:17 am | Andrea T Augustin | ar accounting |
| SJ Operations Docs.jpg | JPGIMAGE | 2615 | 4/15/2024 9:22 am | 4/15/2024 9:22 am | Milena Mendoza | Accounts Receivable |