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）文件
- 固定表头顺序：
- "TA代码"
- "基金代码"
- "托管服务费金额"
- "算法名称（非必填）"
- "月份"
- 月份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": "达诚基金"
