Table: partner

InternalId defaultaddress custentity_scpq_allow_console_ce altemail custentity_esc_annual_revenue custentity_my_brn bcn subpartnerlogin category class class_refid comments companyname contact contact_refid shipping_country shipping_country_refid datecreated custentity_hj_tc_default_asn custentity_hj_tc_default_asn_refid custentity_hj_tc_autopacktemplate custentity_hj_tc_autopacktemplate_refid department department_refid edition_refid custentity_2663_payment_method custentity_2663_eft_file_format custentity_2663_eft_file_format_refid email custentity_2663_email_address_notif emailpreference emailpreference_refid centertype externalid faqty faqtymax fax newaccesshelp giveaccess globalsubscriptionstatus globalsubscriptionstatus_refid image image_refid isinactive isperson custentity_esc_industry custentity_esc_industry_refid id isfaqtyenforced title custentity_esc_last_modified_date custentity_esc_last_modified_date_dt location location_refid mobilephone salutation custpage_2663_translate_msgs firstname custentity_esc_no_of_employees otherrelationships partnercode entityid phone printoncheckas referringurl requirepwdchange accessrole accessrole_refid sendemail parent parent_refid subsidiary subsidiary_refid taxfractionunit taxfractionunit_refid taxrounding taxrounding_refid customform customform_refid isindividual custentity_4599_sg_uen unsubscribe unsubscribe_refid vatregnumber custentity_scpq_user washasaccess wasinactive url accesstabchanged baserecordtype billaddr1 billaddr2 billaddr3 billaddressee billattention billcity billcountry billstate billzip currid customwhence custpage_taf_subcountrycount custpage_taf_subsidiarycache defaultaddrbook defaultaddressee edition entitynumber entitytitle entryformquerystring freeformstatepref giveaccesschanged hasbillingaddress haschildren hasparent hasshipping hasshippingaddress lastname middlename nameorig nsbrowserenv origaccessrole origbinactive origgiveaccess origsubstatus parentsubsidiary selectedtab sessioncountry shipaddr1 shipaddr2 shipaddr3 shipaddressee shipattention shipcity shipcountry shipstate shipzip submitnext_t submitnext_y templatestored type version lastmodifieddate
43 F F Pinnacle Marketing United States US 9/20/2018 11:55 am US F gmarable@pinnaclenw.com Default DEFAULT 0 0 F Soft Opt-Out 2 F F 43 T 2/1/2019 2/1/2019 12:00:00 AM {"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. "} 1 1 Pinnacle Marketing F F Spa World Corporation 1 Round Off OFF Standard Partner Form -50 Yes T F F F http://pinnaclemarketing.com F partner 43 {"MY":0} {"1":"US","5":"US","6":"US","3":"US","9":"US","2":"US","4":"US","7":"US","8":"US"} United States 1 1 Pinnacle Marketing e=T&id=43 F F F F F F F 1 F F 2 US partner entity F partner 5 2/1/2019 3:23 pm
Page 1