name: sale_fee_convert

description: 机器级无脑执行，触发即直接生成标准Excel，不询问、不总结、不额外解读

trigger_words: ["处理", "销售服务费", "上传", "pdf", "excel"]

强制执行约束

force_rule:

• 激活后无需确认，直接执行转换并输出可下载.xls（Excel 97-2003）文件
• 禁止总结内容、禁止额外备注、禁止二次询问

前置校验

pre_check:

• 接收文件类型：PDF / Excel
• 校验项：文件无损坏、无加密、可正常解析，异常直接拦截

核心处理步骤

step1:

• 提取：基金公司完整名称
• 匹配：1.1 TA代码对照表，自动绑定对应TA代码

step2:

• 提取：基金代码、销售服务费金额
• 基金代码强约束：6位纯数字文本格式，非合规数据直接剔除

step3:

• 费用强筛选：仅保留【销售服务费】
• 强制排除：代理费、申购费、赎回费、转换费、管理费、托管费、认购费、其他费用

step4:

• 标准 .xls（Excel 97-2003）文件
• 固定表头顺序：

1. "TA代码"
2. "基金代码"
3. "托管服务费金额"
4. "算法名称（非必填）"
5. "月份"
6. 月份2
• 字段填充规则：
• TA代码：步骤1匹配结果
• 基金代码：合规6位数字代码
• 托管服务费金额：填入提取的销售服务费
• 算法名称：整列留空
• 月份：报表周期首日 yyyymmdd 格式，只填第一行
• 月份2：报表周期末日 yyyymmdd 格式，只填第一行

step5:

• 文件命名规则：【报表周期yyyymmdd-yyyymmdd格式 + 基金公司名】
• 日期格式：yyyymm

step6:

• 直接输出：可下载成品.xls格式文件

1.1 TA代码-基金公司对照表

ta_mapping:

"75": "安信"

"13": "宝盈"

"3J": "北信瑞丰"

"5L": "博道"

"05": "博时"

"6M": "博远"

"4V": "渤海汇金资产"

"72": "财通"

"OF4T": "财通资管"

"3M": "创金合信"

"6F": "淳厚"

"09": "大成"

"77": "德邦"

"40": "东方"

"5H": "东方阿尔法"

"0B": "东海"

"58": "东吴"

"0W": "东证资管"

"73": "方正富邦"

"6A": "蜂巢"

"71": "富安达"

"5T": "富达"

"10": "富国"

"4U": "富荣"

"5D": "格林"

"48": "工银瑞信"

"36": "光大保德信"

"27": "广发"

"45": "国海富兰克林"

"76": "国金"

"0F": "国联"

"25": "国联安"

"5J": "国融"

"0Z": "国寿安保"

"02": "国泰"

"12": "国投瑞银"

"1G": "国新国证"

"23": "海富通"

"5N": "合煦智远"

"2A": "恒越"

"78": "红塔红土"

"3H": "红土创新"

"22": "宏利"

"4D": "泓德"

"04": "华安"

"24": "华宝"

"79": "华宸未来"

"41": "华富"

"0A": "华润元大"

"63": "华商"

"46": "华泰柏瑞"

"5C": "华泰保兴"

"94": "华泰资管"

"2G": "华西"

"03": "华夏"

"4Y": "汇安"

"54": "汇丰晋信"

"5R": "汇泉"

"47": "汇添富"

"6K": "惠升"

"3R": "嘉合"

"07": "嘉实"

"53": "建信"

"G2": "建行外包贝莱德"

"0C": "江信"

"49": "交银施罗德"

"4G": "金信"

"21": "金鹰"

"62": "金元顺安"

"26": "景顺长城"

"3Q": "九泰"

"5G": "凯石"

"5U": "路博迈"

"69": "民生加银"

"37": "摩根"

"33": "摩根士丹利"

"01": "南方"

"5E": "南华"

"66": "农银汇理"

"32": "诺安"

"57": "诺德"

"06": "鹏华"

"4Z": "鹏扬"

"70": "平安"

"64": "浦银安盛"

"44": "前海开源"

"4M": "前海联合"

"2E": "泉果"

"5F": "人保资产"

"16": "融通"

"6E": "睿远"

"0V": "上银"

"2D": "尚正"

"31": "申万菱信"

"14": "太平"

"4C": "泰康"

"29": "泰信"

"42": "天弘"

"35": "天治"

"19": "万家"

"67": "西部利得"

"6L": "西藏东财"

"4X": "先锋"

"43": "新华"

"0L": "鑫元"

"61": "信达澳亚"

"2F": "兴合"

"1M": "兴业"

"1P": "兴银"

"34": "兴证全球"

"11": "易方达"

"56": "益民"

"15": "银河"

"18": "银华"

"65": "英大"

"0Y": "永赢"

"1L": "圆信永丰"

"74": "长安"

"20": "长城"

"08": "长盛"

"30": "长信"

"17": "招商"

"ZSWB": "招商证券外包"

"68": "浙商"

"3T": "浙商资管"

"39": "中海"

"5A": "中航"

"0D": "中加"

"1N": "中金"

"4L": "中科沃土"

"60": "中欧"

"B0": "中泰资管"

"28": "中信 (代理达诚基金）"

"55": "中信保诚"

"0Q": "中信建投"

"G1": "中信中证投资"

"38": "中银"

"4N": "中银国际证券"

"59": "中邮创业"

"6H": "朱雀"

"G1": "达诚基金"