'AffiliateId'=>Array('type'=>'int','formatter'=>'kLEFTFormatter','error_msgs'=>Array('invalid_option'=>'!la_error_UserNotFound!'),'options'=>Array(0=>'lu_None'),'left_sql'=>'SELECT %s FROM '.TABLE_PREFIX.'Affiliates af LEFT JOIN '.TABLE_PREFIX.'Users u ON u.PortalUserId = af.PortalUserId WHERE %s','left_key_field'=>'af.AffiliateId','left_title_field'=>'IF(u.Email = "", u.Username, u.Email)','not_null'=>1,'default'=>0),
'PaymentTypeId'=>Array('type'=>'int','formatter'=>'kOptionsFormatter','options_sql'=>'SELECT Name, PaymentTypeId FROM '.TABLE_PREFIX.'AffiliatePaymentTypes WHERE Status = 1 ORDER BY IsPrimary DESC, Priority DESC, Name ASC','option_key_field'=>'PaymentTypeId','option_title_field'=>'Name','not_null'=>1,'default'=>0),