Table: subsidiary

InternalId custrecord_hns_sub_industrynumber_hlp prevparent prevparent_refid state1taxnumber mainaddress_text showsubsidiaryname custrecord_subsidiary_branch_id custrecord_company_brn CALENDARSYSTEM CALENDARSYSTEM_refid checklayout checklayout_refid country country_refid CSV_COLUMN_DELIMITER CSV_COLUMN_DELIMITER_refid CSV_DECIMAL_DELIMITER CSV_DECIMAL_DELIMITER_refid currency currency_refid CUSTCENTEREMAILTEMPLATE CUSTCENTEREMAILTEMPLATE_refid DATEFORMAT DATEFORMAT_refid DEFAULT_ADVANCE_ACCT_FOR_EXPREPT DEFAULT_ADVANCE_ACCT_FOR_EXPREPT_refid defaultcaseprofile defaultcaseprofile_refid CHECKTYPE CHECKTYPE_refid DEFAULTAPACCOUNTFOREXPREPT DEFAULTAPACCOUNTFOREXPREPT_refid DEFAULTVENDORPAYMENTACCOUNT DEFAULTVENDORPAYMENTACCOUNT_refid tranprefix edition iselimination federalidnumber externalid fax FIRSTDAYOFWEEK FIRSTDAYOFWEEK_refid fiscalcalendar fiscalcalendar_refid custrecord_hns_sub_industrynumber custrecord_hns_sub_industryclassif custrecord_hns_sub_industryclassif_refid custrecord_hns_sub_industrydescription id legalname LONGDATEFORMAT LONGDATEFORMAT_refid name NEGATIVE_NUMBER_FORMAT NEGATIVE_NUMBER_FORMAT_refid NUMBERFORMAT NUMBERFORMAT_refid parent parent_refid PARTCENTEREMAILTEMPLATE PARTCENTEREMAILTEMPLATE_refid PHONEFORMAT PHONEFORMAT_refid returnaddress_text email roundtime roundtime_refid SEARCHSORTING SEARCHSORTING_refid shippingaddress_text SPELL_LOCALE SPELL_LOCALE_refid ssnortin dropdownstate state dropdownstate_refid custrecord_subnav_subsidiary_logo custrecord_subnav_subsidiary_logo_refid isinactive logo logo_refid pagelogo pagelogo_refid taxfiscalcalendar taxfiscalcalendar_refid custrecord_pt_sub_taxonomy_reference custrecord_pt_sub_taxonomy_reference_refid TIMEFORMAT TIMEFORMAT_refid TIMEZONE TIMEZONE_refid traninternalprefix custrecord_company_uen EMAILACCESSTEMPLATE EMAILACCESSTEMPLATE_refid receiptamount receiptquantitydiff receiptquantity purchaseorderamount purchaseorderquantitydiff purchaseorderquantity VENDORPREPAYMENTACCOUNT VENDORPREPAYMENTACCOUNT_refid url addrlanguage currencyvalue customwhence defaultaddrbook defaultaddressee entryformquerystring freeformstatepref haschildren mainaddress2_set mainaddress_defaultvalue mainaddress_key mainaddress_type nsbrowserenv origbinactive origparent parentcountry parentcurrency parentstate returnaddress2_set returnaddress_defaultvalue returnaddress_key returnaddress_type selectedtab sessioncountry shippingaddress2_set shippingaddress_defaultvalue shippingaddress_key shippingaddress_type showDropdownStateInitially type vendbillmatchkey lastmodifieddate
1 SW Corp 5701 NW 35th Ave Miami FL 33142 United States F Gregorian Calendar Gregorian Standard Check Layout 50 United States US Comma COMMA Period PERIOD US Dollar 1 Standard Customer Center Access Email -207 M/D/YYYY M/D/YYYY Spa World Corporation 1 Voucher VOUCHER S US F 134310494 Sunday 1 Standard Fiscal Calendar 1 1 Spa World Corporation Month D, YYYY Month D, YYYY Spa World Corporation 0 0 Standard Partner Center Access Email -208 (123) 456-7890 (123) 456-7890 5701 NW 35th Ave Miami FL 33142 United States no_reply@swcorp.com Language Specific LANGUAGE_SPECIFIC 5701 NW 35th Ave Miami FL 33142 United States American AMERICAN Florida FL FL SWCORP_114x30px.jpg 2340 F SWCORP_114x30px.jpg 2340 SWCORP_114x30px.jpg 2340 Standard Fiscal Calendar 1 hh:mm AM/PM h:mm a (GMT-05:00) Eastern Time (US & Canada) America/New_York Standard User Access Email -206 .01 .01 .01 .01 en_US 1 e=T&id=1 F T var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 1 addr F US 1 FL var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); 13 addr US var subrecord = nlapiViewSubrecord('shippingaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('shippingaddress_text', addresstext); 14 shipaddr T subsidiary 1 1/30/2023 10:49 am
2 Spa World Corporation 1 Homemart Products Inc 5701 NW 35th Avenue Miami FL 33142 United States F Gregorian Calendar Gregorian Standard Check Layout 50 United States US Comma COMMA Period PERIOD US Dollar 1 Standard Customer Center Access Email -207 M/D/YYYY M/D/YYYY Spa World Corporation 1 Voucher VOUCHER HMP US F 461497767 Sunday 1 Standard Fiscal Calendar 1 2 Homemart Products, Inc Month D, YYYY Month D, YYYY Homemart Products Inc 0 0 Spa World Corporation 1 Standard Partner Center Access Email -208 (123) 456-7890 (123) 456-7890 5701 NW 35th Ave Miami FL 33142 United States Language Specific LANGUAGE_SPECIFIC 5701 NW 35th Ave Miami FL 33142 United States American AMERICAN Florida FL FL homemartproductsLOGO.PNG 2756 F homemartproductsLOGO.PNG 2756 homemartproductsLOGO.PNG 2756 Standard Fiscal Calendar 1 hh:mm AM/PM h:mm a (GMT-05:00) Eastern Time (US & Canada) America/New_York Standard User Access Email -206 homemartproducts.com en_US 1 e=T&id=2 F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 2 addr F 1 US 1 FL var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); 18 addr US var subrecord = nlapiViewSubrecord('shippingaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('shippingaddress_text', addresstext); 17 shipaddr T subsidiary 10/13/2021 4:33 pm
3 Spa World Corporation 1 Electronic Payroll Processing Corp 5701 NW 35th Ave Miami FL 33142 United States F Gregorian Calendar Gregorian Standard Check Layout 50 United States US Comma COMMA Period PERIOD US Dollar 1 Standard Customer Center Access Email -207 M/D/YYYY M/D/YYYY Spa World Corporation 1 Voucher VOUCHER EPP US F 475484814 Sunday 1 Standard Fiscal Calendar 1 3 Electronic Payroll Processing Corp Month D, YYYY Month D, YYYY Electronic Payroll Processing Corp 0 0 Spa World Corporation 1 Standard Partner Center Access Email -208 (123) 456-7890 (123) 456-7890 5701 NW 35th Ave Miami FL 33142 United States netsuite@swcorp.com Language Specific LANGUAGE_SPECIFIC 5701 NW 35th Ave Miami FL 33142 United States American AMERICAN Florida FL FL F Standard Fiscal Calendar 1 hh:mm AM/PM h:mm a (GMT-05:00) Eastern Time (US & Canada) America/New_York Standard User Access Email -206 en_US 1 e=T&id=3 F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 6 addr F 1 US 1 FL var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); 22 addr US var subrecord = nlapiViewSubrecord('shippingaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('shippingaddress_text', addresstext); 21 shipaddr T subsidiary 10/13/2021 4:27 pm
4 Spa World Corporation 1 Remodel Kingdom LLC 5701 NW 35th Ave Miami FL 33142 United States F Gregorian Calendar Gregorian Standard Check Layout 50 United States US Comma COMMA Period PERIOD US Dollar 1 Standard Customer Center Access Email -207 M/D/YYYY M/D/YYYY Spa World Corporation 1 Voucher VOUCHER RKD US F 830712022 Sunday 1 Standard Fiscal Calendar 1 4 Remodel Kingdom LLC Month D, YYYY Month D, YYYY Remodel Kingdom LLC 0 0 Spa World Corporation 1 Standard Partner Center Access Email -208 (123) 456-7890 (123) 456-7890 5701 NW 35th Ave Miami FL 33142 United States netsuite@swcorp.com Language Specific LANGUAGE_SPECIFIC 5701 NW 35th Ave Miami FL 33142 United States American AMERICAN Florida FL FL REMODELKINGDOM_114x30px.jpg 2338 T REMODELKINGDOM_114x30px.jpg 2338 REMODELKINGDOM_114x30px.jpg 2338 Standard Fiscal Calendar 1 hh:mm AM/PM h:mm a (GMT-05:00) Eastern Time (US & Canada) America/New_York Standard User Access Email -206 remodelkingdom.com en_US 1 e=T&id=4 F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 7 addr T 1 US 1 FL var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); 26 addr US var subrecord = nlapiViewSubrecord('shippingaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('shippingaddress_text', addresstext); 25 shipaddr T subsidiary 11/27/2018 1:41 pm
5 Spa World Corporation 1 Anzzi LLC 1 Oakwood Blvd Suite 200 Hollywood FL 33020 United States F Gregorian Calendar Gregorian Standard Check Layout 50 United States US Comma COMMA Period PERIOD US Dollar 1 Standard Customer Center Access Email -207 M/D/YYYY M/D/YYYY Spa World Corporation 1 Voucher VOUCHER ANZ US F 821366060 Sunday 1 Standard Fiscal Calendar 1 5 Anzzi LLC Month D, YYYY Month D, YYYY Anzzi LLC 0 0 Spa World Corporation 1 Standard Partner Center Access Email -208 (123) 456-7890 (123) 456-7890 5701 NW 35th Ave Miami FL 33142 United States netsuite@swcorp.com Language Specific LANGUAGE_SPECIFIC 5701 NW 35th Ave Miami FL 33142 United States American AMERICAN Florida FL FL ANZZI_114x30px.jpg 2335 F ANZZI_114x30px.jpg 2335 ANZZI_114x30px.jpg 2335 Standard Fiscal Calendar 1 hh:mm AM/PM h:mm a (GMT-05:00) Eastern Time (US & Canada) America/New_York Standard User Access Email -206 anzzi.com en_US 1 e=T&id=5 F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 8 addr F 1 US 1 FL var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); 16 addr US var subrecord = nlapiViewSubrecord('shippingaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('shippingaddress_text', addresstext); 15 shipaddr T subsidiary 11/27/2018 1:30 pm
6 Spa World Corporation 1 Depot Lot LLC 398 E Dania Beach Blvd Num 455 Dania Beach FL 33004 United States F Gregorian Calendar Gregorian Standard Check Layout 50 United States US Comma COMMA Period PERIOD US Dollar 1 Standard Customer Center Access Email -207 M/D/YYYY M/D/YYYY Spa World Corporation 1 Voucher VOUCHER DPL US F 825392235 Sunday 1 Standard Fiscal Calendar 1 6 Depot Lot LLC Month D, YYYY Month D, YYYY Depot Lot LLC 0 0 Spa World Corporation 1 Standard Partner Center Access Email -208 (123) 456-7890 (123) 456-7890 398 E Dania Beach Blvd Num 455 Dania Beach FL 33004 United States netsuite@swcorp.com Language Specific LANGUAGE_SPECIFIC 398 E Dania Beach Blvd Num 455 Dania Beach FL 33004 United States American AMERICAN Florida FL FL depotlotLOGO 2757 F depotlotLOGO 2757 depotlotLOGO 2757 Standard Fiscal Calendar 1 hh:mm AM/PM h:mm a (GMT-05:00) Eastern Time (US & Canada) America/New_York Standard User Access Email -206 depotlot.com en_US 1 e=T&id=6 F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 9 addr F 1 US 1 FL var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); 20 addr US var subrecord = nlapiViewSubrecord('shippingaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('shippingaddress_text', addresstext); 19 shipaddr T subsidiary 11/27/2018 1:31 pm
7 Spa World Corporation 1 Spa World Sales Corporation 1 Oakwood Blvd Ste 200 Hollywood FL 33020 United States F Gregorian Calendar Gregorian Standard Check Layout 50 United States US Comma COMMA Period PERIOD US Dollar 1 Standard Customer Center Access Email -207 M/D/YYYY M/D/YYYY Spa World Corporation 1 Voucher VOUCHER SPS US F 823366048 Sunday 1 Standard Fiscal Calendar 1 7 Spa World Sales Corporation Month D, YYYY Month D, YYYY Spa World Sales Corporation 0 0 Spa World Corporation 1 Standard Partner Center Access Email -208 (123) 456-7890 (123) 456-7890 1 Oakwood Blvd Ste 200 Hollywood FL 33142 United States netsuite@swcorp.com Language Specific LANGUAGE_SPECIFIC 1 Oakwoood Blvd Ste 200 Hollywood FL 33020 United States American AMERICAN Florida FL FL F Standard Fiscal Calendar 1 hh:mm AM/PM h:mm a (GMT-05:00) Eastern Time (US & Canada) America/New_York Standard User Access Email -206 en_US 1 e=T&id=7 F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 10 addr F 1 US 1 FL var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); 28 addr US var subrecord = nlapiViewSubrecord('shippingaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('shippingaddress_text', addresstext); 27 shipaddr T subsidiary 1/30/2023 11:29 am
8 Spa World Corporation 1 X Elimination Sub FL F Gregorian Calendar Gregorian Standard Check Layout 50 United States US Comma COMMA Period PERIOD US Dollar 1 Standard Customer Center Access Email -207 M/D/YYYY M/D/YYYY Spa World Corporation 1 Voucher VOUCHER ELM US T Sunday 1 Standard Fiscal Calendar 1 8 Month D, YYYY Month D, YYYY X Elimination Sub 0 0 Spa World Corporation 1 Standard Partner Center Access Email -208 (123) 456-7890 (123) 456-7890 netsuite@swcorp.com Language Specific LANGUAGE_SPECIFIC American AMERICAN Florida FL FL F Standard Fiscal Calendar 1 hh:mm AM/PM h:mm a (GMT-05:00) Eastern Time (US & Canada) America/New_York Standard User Access Email -206 en_US 1 e=T&id=8 F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 11 addr F 1 US 1 FL var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); addr US var subrecord = nlapiViewSubrecord('shippingaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('shippingaddress_text', addresstext); shipaddr T subsidiary 9/11/2018 12:44 pm
9 Spa World Corporation 1 Galei Opa LLC 5701 NW 35th Ave. Miami FL 33142 United States F Gregorian Calendar Gregorian Standard Check Layout 50 United States US Comma COMMA Period PERIOD US Dollar 1 Standard Customer Center Access Email -207 M/D/YYYY M/D/YYYY Spa World Corporation 1 Voucher VOUCHER GAL US F 900745695 Sunday 1 Standard Fiscal Calendar 1 9 Galei Opa, LLC Month D, YYYY Month D, YYYY Galei Opa, LLC 0 0 Spa World Corporation 1 Standard Partner Center Access Email -208 (123) 456-7890 (123) 456-7890 5701 NW 35th Ave. Miami FL 33142 Language Specific LANGUAGE_SPECIFIC 5701 NW 35th Ave. Miami FL 33142 American AMERICAN Florida FL FL F Standard Fiscal Calendar 1 hh:mm AM/PM h:mm a (GMT-05:00) Eastern Time (US & Canada) America/New_York Standard User Access Email -206 en_US 1 e=T&id=9 F F var subrecord = nlapiViewSubrecord('mainaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('mainaddress_text', addresstext); 12 addr F 1 US 1 FL var subrecord = nlapiViewSubrecord('returnaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('returnaddress_text', addresstext); 24 addr US var subrecord = nlapiViewSubrecord('shippingaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('shippingaddress_text', addresstext); 23 shipaddr T subsidiary 11/27/2018 1:30 pm
Page 1