'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.'PortalUser pu ON pu.PortalUserId = af.PortalUserId WHERE `%s` = \'%s\'','left_key_field'=>'AffiliateId','left_title_field'=>'Login','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),