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": "达诚基金"