Table: location

InternalId mainaddress_text custrecord_5826_loc_branch_id defaultallocationpriority tranprefix externalid includeinsupplyplanning id latitude custrecord_location_id isinactive locationtype locationtype_refid logo logo_refid longitude makeinventoryavailable makeinventoryavailablestore name custrecord_ntlocationid parent parent_refid returnaddress_text subsidiary subsidiary_refid timezone timezone_refid traninternalprefix usebins usewarehousemanagement custrecord_wmsse_wms_account custrecord_wmsse_wms_account_refid custrecord_wmsse_make_wh_site customwhence defaultaddrbook defaultaddressee entryformquerystring hasbins haschildren hasopensalesorders hastransactions mainaddress2_set mainaddress_defaultvalue mainaddress_key mainaddress_type nsbrowserenv origbinactive origparent returnaddress2_set returnaddress_defaultvalue returnaddress_key returnaddress_type selectedtab type lastmodifieddate
1 SW Corp 5703 NW 35th Ave Miami FL 33142 (305) 330-1146 T 1 F Warehouse 2 T T Miami Spa World Corporation 1 (GMT-05:00) Eastern Time (US & Canada) America/New_York T T T e=T&id=1 T T T T var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 4 addr F var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); addr location 4/23/2024 4:33 am
3 Miami Returns Location F 3 F F F Miami Returns Location Miami 1 Spa World Corporation 1 (GMT-05:00) Eastern Time (US & Canada) America/New_York T T T e=T&id=3 F F F T var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 229 addr F 1 var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); addr location 5/3/2024 9:50 am
4 Homemart Products Inc United States F 4 F F T Homemart Products Inc Spa World Corporation : Homemart Products Inc 2 (GMT-05:00) Eastern Time (US & Canada) America/New_York F F F e=T&id=4 F F F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 231 addr F var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); addr location 12/17/2018 9:13 am
7 Electronic Payroll Processing United States F 7 F F T Electronic Payroll Processing Spa World Corporation : Electronic Payroll Processing Corp 3 (GMT-05:00) Eastern Time (US & Canada) America/New_York F F F e=T&id=7 F F F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 2480 addr F var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); addr location 12/17/2018 9:12 am
8 Spa World Sales Corporation United States F 8 F F T Spa World Sales Corporation Spa World Corporation : Spa World Sales Corporation 7 (GMT-05:00) Eastern Time (US & Canada) America/New_York F F F e=T&id=8 F F F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 2481 addr F var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); addr location 12/17/2018 9:16 am
9 AMAZON FBA 2 T 9 T T F AMAZON FBA 2 Spa World Corporation 1 (GMT-05:00) Eastern Time (US & Canada) America/New_York F F F e=T&id=9 F F F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 417369 addr T var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); addr location 6/3/2020 7:32 pm
10 CastleGate-Wayfair T 10 F Warehouse 2 T F CastleGate-Wayfair Spa World Corporation 1 (GMT-05:00) Eastern Time (US & Canada) America/New_York F T T e=T&id=10 F F F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 769963 addr F var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); addr location 4/23/2024 4:36 am
11 Walmart.com/Jet.com 2301 Corporation Parkway Waco TX 76712 (305) 330-1146 F 11 T F F Walmart Walmart.com/Jet.com 2301 Corporation Parkway Waco TX 76712 Spa World Corporation 1 (GMT-05:00) Eastern Time (US & Canada) America/New_York F F F e=T&id=11 F F F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 1219051 addr T var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); 1219052 addr location 2/8/2022 2:44 pm
12 China F 12 T Warehouse 2 F F China Spa World Corporation 1 (GMT+08:00) Beijing, Chongqing, Hong Kong, Urumqi Asia/Hong_Kong F T F e=T&id=12 F F F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 1510342 addr T var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); addr location 5/20/2021 4:38 pm
13 HOUZZ 5701 NW 35TH AVE MIAMI FL 33142 (800) 368-4268 F 13 T F F HOUZZ HOUZZ 5701 NW 35TH AVE MIAMI FL 33142 (800) 368-4268 Spa World Corporation 1 (GMT-05:00) Eastern Time (US & Canada) America/New_York F F F e=T&id=13 F F F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 1900328 addr T var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); 1900329 addr location 5/20/2021 4:39 pm
14 AMAZON FBA F 14 F T F AMAZON FBA Spa World Corporation 1 (GMT-05:00) Eastern Time (US & Canada) America/New_York F T F e=T&id=14 F F F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 2130317 addr F var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); addr location 11/17/2023 10:16 am
15 Drop Ship Location F 15 F T F Drop Ship Location Spa World Corporation 1 (GMT-05:00) Eastern Time (US & Canada) America/New_York F F F e=T&id=15 F F F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 2247211 addr F var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); addr location 6/23/2020 12:23 pm
16 Zoro C/O Spa World 5703 NW 35th Ave Harwood Heights IL 60706 F 16 F F F Zoro ZORO C/O SPA WORLD 5701 NW 35TH AVE MIAMI FL 33142 Spa World Corporation 1 (GMT-05:00) Eastern Time (US & Canada) America/New_York F F F e=T&id=16 F F F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 2838207 addr F var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); 4878114 addr location 8/5/2021 3:57 pm
17 TOTAL LOSS F 17 T T T TOTAL LOSS Spa World Corporation 1 (GMT-05:00) Eastern Time (US & Canada) America/New_York T T F e=T&id=17 F F F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 2870866 addr T var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); addr location 5/20/2021 6:00 pm
18 RECON CYC F 18 T T F RECON CYC Spa World Corporation 1 (GMT-05:00) Eastern Time (US & Canada) America/New_York T F F e=T&id=18 F F F T var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 3258633 addr T var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); addr location 5/20/2021 4:39 pm
19 BizDev F 19 F Warehouse 2 T T BizDev Spa World Corporation 1 (GMT-05:00) Eastern Time (US & Canada) America/New_York T T T e=T&id=19 F F F T var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 3361777 addr F var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); addr location 4/23/2024 4:35 am
20 G Thinker Equipment Company Taoyuan Village Hengjie Town Haishu Ningbo China T 20 F T F G-thinker Spa World Corporation 1 (GMT-05:00) Eastern Time (US & Canada) America/New_York F F F e=T&id=20 F F F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 7795852 addr F var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); addr location 8/18/2022 11:39 am
21 Ebay F 21 F Warehouse 2 T F Ebay Spa World Corporation 1 (GMT-05:00) Eastern Time (US & Canada) America/New_York F T T e=T&id=21 F F F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 8675434 addr F var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); addr location 4/23/2024 4:36 am
22 LOWES F 22 F T T LOWES Spa World Corporation 1 (GMT-05:00) Eastern Time (US & Canada) America/New_York T F F e=T&id=22 F F F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 8838656 addr F var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); addr location 11/13/2022 3:02 am
23 SW Corp 5703 NW 35TH AVE MIAMI FL 33142 (305) 330-1146 F 23 F T T Costco Spa World Corporation 1 (GMT-05:00) Eastern Time (US & Canada) America/New_York T F F e=T&id=23 F F F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 9304778 addr F var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); addr location 1/2/2023 6:01 pm
24 WALMART F 24 F Warehouse 2 T F WALMART Spa World Corporation 1 (GMT-05:00) Eastern Time (US & Canada) America/New_York F T T e=T&id=24 F F F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 12167967 addr F var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); addr location 4/23/2024 4:36 am
Page 1