mo-daq-all/mo-daq/db/init.sql

CREATE TABLE `daq_report_base_info`
(
    `id`            int(11) NOT NULL AUTO_INCREMENT COMMENT '主键Id',
    `file_id`       int(11) NOT NULL,
    `report_date`   datetime     DEFAULT NULL COMMENT '报告日期',
    `report_name`   varchar(255) DEFAULT NULL COMMENT '报告名称',
    `report_type`   varchar(255) DEFAULT NULL COMMENT '报告类型',
    `with_contacts` tinyint(4) NOT NULL DEFAULT '0' COMMENT '观点报告是否存在管理人联系信息（包括联系电话、地址、姓名等敏感信息）',
    `isvalid`       int(11) DEFAULT '1' COMMENT '记录的有效性；1-有效；0-无效；',
    `creatorid`     int(11) DEFAULT NULL COMMENT '创建者Id;第一次创建时与Creator值相同，修改时与修改人值相同',
    `updaterid`     int(11) DEFAULT NULL COMMENT '修改者Id;第一次创建时与Creator值相同，修改时与修改人值相同',
    `createtime`    datetime     DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间,默认第一次创建的getdate()时间',
    `updatetime`    datetime     DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间;第一次创建时与CreatTime值相同，修改时与修改时间相同',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COMMENT='报告基础信息表';

CREATE TABLE `daq_report_fund_info`
(
    `id`                        int(11) NOT NULL AUTO_INCREMENT COMMENT '主键，自动递增',
    `file_id`                   int(11) NOT NULL,
    `fund_name`                 varchar(255)   DEFAULT NULL COMMENT '基金的名称',
    `fund_code`                 varchar(50)    DEFAULT NULL COMMENT '基金的唯一识别代码',
    `company_name`              varchar(255)   DEFAULT NULL COMMENT '基金管理人的名称',
    `currency`                  varchar(20)    DEFAULT NULL COMMENT '基金交易使用的货币种类',
    `custodian_name`            varchar(255)   DEFAULT NULL COMMENT '基金托管人',
    `advisor_name`              varchar(255)   DEFAULT NULL COMMENT '投资顾问',
    `operation_type`            varchar(20)    DEFAULT NULL COMMENT '基金运作方式',
    `inception_date`            date           DEFAULT NULL COMMENT '基金成立日期',
    `investment_objective`      text COMMENT '投资目标',
    `fund_strategy_description` text COMMENT '投资策略',
    `secondary_benchmark`       varchar(255)   DEFAULT NULL COMMENT '业绩比较基准',
    `risk_return_desc`          text COMMENT '风险收益特征',
    `due_date`                  date           DEFAULT NULL COMMENT '基金到期日期',
    `reviewed`                  int(11) DEFAULT NULL COMMENT '信息披露报告是否经托管机构复核',
    `leverage`                  decimal(22, 6) DEFAULT NULL COMMENT '杠杆比例',
    `leverage_note`             text COMMENT '杠杆比例描述',
    `industry_trend`            text COMMENT '行业趋势',
    `fund_manager`              text COMMENT '基金经理描述',
    `isvalid`                   tinyint(4) NOT NULL DEFAULT '1' COMMENT '记录的有效性；1-有效；0-无效',
    `creatorid`                 int(11) NOT NULL COMMENT '创建者Id',
    `updaterid`                 int(11) NOT NULL COMMENT '修改者Id',
    `createtime`                datetime       DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `updatetime`                datetime       DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COMMENT='报告解析结果之基金信息表';

CREATE TABLE `daq_report_fund_transaction`
(
    `id`                        int(11) NOT NULL AUTO_INCREMENT COMMENT '主键Id',
    `file_id`                   int(11) NOT NULL,
    `fund_account`              varchar(100)   DEFAULT NULL COMMENT '基金账户编号',
    `fund_name`                 varchar(100)   DEFAULT NULL COMMENT '基金名称',
    `distributor`               varchar(100)   DEFAULT NULL COMMENT '销售此基金产品的经销商或银行',
    `transaction_type`          varchar(50)    DEFAULT NULL COMMENT '业务类型（例如：申购、赎回）',
    `business_reason`           varchar(100)   DEFAULT NULL COMMENT '业务操作的原因或类型说明',
    `status`                    varchar(50)    DEFAULT NULL COMMENT '交易确认的状态（例如：已确认、待处理等）',
    `holding_date`              date           DEFAULT NULL COMMENT '交易确认的日期',
    `apply_date`                date           DEFAULT NULL COMMENT '申请的日期',
    `apply_amount`              decimal(22, 6) DEFAULT NULL COMMENT '申请的金额',
    `apply_share`               decimal(22, 6) DEFAULT NULL COMMENT '申请的基金份额数量',
    `amount`                    decimal(22, 6) DEFAULT NULL COMMENT '确认的金额',
    `share`                     decimal(22, 6) DEFAULT NULL COMMENT '确认的基金份额数量',
    `net_amount`                decimal(22, 6) DEFAULT NULL COMMENT '净认购/申购的金额，确认净额',
    `nav`                       decimal(22, 6) DEFAULT NULL COMMENT '单位净值',
    `confirmation_ratio`        decimal(22, 6) DEFAULT NULL COMMENT '确认比例',
    `ta_confirmation_number`    varchar(100)   DEFAULT NULL COMMENT '交易授权确认编号',
    `ta_number`                 varchar(100)   DEFAULT NULL COMMENT 'TA代码',
    `apply_no`                  varchar(100)   DEFAULT NULL COMMENT '申请单号',
    `share_balance`             decimal(22, 6) DEFAULT NULL COMMENT '份额余额',
    `share_category`            varchar(50)    DEFAULT NULL COMMENT '份额类别',
    `large_redemption_type`     varchar(50)    DEFAULT NULL COMMENT '巨额赎回方式',
    `reward_mark`               varchar(50)    DEFAULT NULL COMMENT '提成或保底标志',
    `holding_days`              int(11) DEFAULT NULL COMMENT '持有天数',
    `share_registry_date`       date           DEFAULT NULL COMMENT '份额明细注册日期',
    `fee`                       decimal(22, 6) DEFAULT NULL COMMENT '总费用',
    `interest`                  decimal(22, 6) DEFAULT NULL COMMENT '利息',
    `interest_to_fund_assets`   decimal(22, 6) DEFAULT NULL COMMENT '利息转份额/利息归基金资产',
    `trade_fee`                 decimal(22, 6) DEFAULT NULL COMMENT '交易费',
    `default_fee`               decimal(22, 6) DEFAULT NULL COMMENT '违约金',
    `performance_fee`           decimal(22, 6) DEFAULT NULL COMMENT '业绩报酬',
    `fee_discounts`             decimal(22, 6) DEFAULT NULL COMMENT '费用折扣',
    `performance_fee_discounts` decimal(22, 6) DEFAULT NULL COMMENT '业绩报酬折扣',
    `dividend_type`             varchar(50)    DEFAULT NULL COMMENT '分红方式',
    `dividend_registry_date`    date           DEFAULT NULL COMMENT '分红登记日',
    `dividend_payment_date`     date           DEFAULT NULL COMMENT '红利发放日',
    `base_share_dividend`       decimal(22, 6) DEFAULT NULL COMMENT '分红基数份额',
    `dividend_mode`             varchar(50)    DEFAULT NULL COMMENT '分红模式',
    `unit_dividend`             decimal(22, 6) DEFAULT NULL COMMENT '单位分红',
    `dividend_per_unit`         decimal(22, 6) DEFAULT NULL COMMENT '每单位分红',
    `total_dividend_amount`     decimal(22, 6) DEFAULT NULL COMMENT '红利总额',
    `actual_cash_dividend`      decimal(22, 6) DEFAULT NULL COMMENT '实发现金红利',
    `frozen_shares`             decimal(22, 6) DEFAULT NULL COMMENT '冻结份额',
    `frozen_amount`             decimal(22, 6) DEFAULT NULL COMMENT '冻结金额',
    `actual_performance_amount` decimal(22, 6) DEFAULT NULL COMMENT '实际业绩提成金额',
    `actual_performance_share`  decimal(22, 6) DEFAULT NULL COMMENT '实际提成份额',
    `isvalid`                   int(11) DEFAULT '1' COMMENT '记录的有效性；1-有效；0-无效；',
    `creatorid`                 int(11) DEFAULT NULL COMMENT '创建者Id;第一次创建时与Creator值相同，修改时与修改人值相同',
    `updaterid`                 int(11) DEFAULT NULL COMMENT '修改者Id;第一次创建时与Creator值相同，修改时与修改人值相同',
    `createtime`                datetime       DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间,默认第一次创建的getdate()时间',
    `updatetime`                datetime       DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间;第一次创建时与CreatTime值相同，修改时与修改时间相同',
    `is_sync`                   tinyint(3) NOT NULL DEFAULT '0' COMMENT '是否同步(0-否；1-是)',
    PRIMARY KEY (`id`),
    KEY                         `file_id` (`file_id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COMMENT='交易流水表';

CREATE TABLE `daq_report_investor_info`
(
    `id`                 int(11) NOT NULL AUTO_INCREMENT COMMENT '主键，自动递增',
    `file_id`            int(11) NOT NULL,
    `investor_name`      varchar(255) DEFAULT NULL COMMENT '投资人的姓名',
    `investor_type`      varchar(50)  DEFAULT NULL COMMENT '投资人的类别（例如：个人、机构）',
    `certificate_type`   varchar(50)  DEFAULT NULL COMMENT '证件类型（例如：身份证、护照）',
    `certificate_number` varchar(50)  DEFAULT NULL COMMENT '投资人证件号码',
    `fund_account`       varchar(50)  DEFAULT NULL COMMENT '基金账户编号',
    `trading_account`    varchar(50)  DEFAULT NULL COMMENT '投资者交易账号',
    `isvalid`            tinyint(4) NOT NULL DEFAULT '1' COMMENT '记录的有效性；1-有效；0-无效',
    `creatorid`          int(11) NOT NULL COMMENT '创建者Id',
    `updaterid`          int(11) NOT NULL COMMENT '修改者Id',
    `createtime`         datetime     DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `updatetime`         datetime     DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
    PRIMARY KEY (`id`),
    KEY                  `file_id` (`file_id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COMMENT='报告解析结果之投资者信息表';

CREATE TABLE `daq_mailbox_info`
(
    `id`          int(11) NOT NULL AUTO_INCREMENT COMMENT '主键Id',
    `type`        int(11) DEFAULT NULL COMMENT '邮箱类型:1-QQ邮箱,2-腾讯企业邮箱,3-网易邮箱,4-新浪邮箱,99-其他',
    `email`       varchar(255) DEFAULT NULL COMMENT '邮箱账号',
    `password`    varchar(255) DEFAULT NULL COMMENT '邮箱密码',
    `protocol`    varchar(255) DEFAULT NULL COMMENT '协议',
    `server`      varchar(255) DEFAULT NULL COMMENT '收件服务器',
    `port`        varchar(255) DEFAULT NULL COMMENT '端口',
    `cron`        varchar(255) DEFAULT NULL COMMENT 'cron表达式',
    `open_status` int(11) DEFAULT '0' COMMENT '是否开启，0-不开启，1-开启',
    `description` text COMMENT '备注信息',
    `isvalid`     int(11) DEFAULT '1' COMMENT '记录的有效性；1-有效；0-无效；',
    `creatorid`   int(11) DEFAULT NULL COMMENT '创建者Id;第一次创建时与Creator值相同，修改时与修改人值相同',
    `updaterid`   int(11) DEFAULT NULL COMMENT '修改者Id;第一次创建时与Creator值相同，修改时与修改人值相同',
    `createtime`  datetime     DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间,默认第一次创建的getdate()时间',
    `updatetime`  datetime     DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间;第一次创建时与CreatTime值相同，修改时与修改时间相同',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COMMENT='邮箱信息表';

CREATE TABLE `daq_email_file_info`
(
    `id`         int(11) NOT NULL AUTO_INCREMENT COMMENT '主键Id',
    `email_id`   int(11) NOT NULL COMMENT '邮件id',
    `fund_id`    int(11) DEFAULT NULL COMMENT '基金id',
    `file_name`  varchar(255)  NOT NULL COMMENT '附件名称',
    `file_path`  varchar(1024) NOT NULL COMMENT '附件路径',
    `ai_parse`   tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否利用ai工具来解析的',
    `ai_file_id` varchar(64) DEFAULT NULL COMMENT 'ai解析时上传的文件id（方便重新解析）',
    `isvalid`    tinyint(4) NOT NULL DEFAULT '1' COMMENT '记录的有效性；1-有效；0-无效',
    `creatorid`  int(11) NOT NULL COMMENT '创建者Id',
    `updaterid`  int(11) NOT NULL COMMENT '修改者Id',
    `createtime` datetime    DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `updatetime` datetime    DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COMMENT='邮件附件信息表';

CREATE TABLE `daq_email_parse_info`
(
    `id`           int(11) NOT NULL AUTO_INCREMENT COMMENT '主键Id',
    `sender_email` varchar(255) DEFAULT NULL COMMENT '邮件发送方',
    `email`        varchar(255) DEFAULT NULL COMMENT '邮箱地址',
    `email_key`    varchar(64)  DEFAULT NULL,
    `email_date`   datetime     DEFAULT NULL COMMENT '邮箱日期',
    `parse_date`   datetime     DEFAULT NULL COMMENT '解析日期',
    `email_title`  varchar(255) DEFAULT NULL COMMENT '邮件主题',
    `email_type`   int(11) DEFAULT NULL,
    `parse_status` int(11) DEFAULT NULL COMMENT '解析状态',
    `fail_reason`  text COMMENT '失败原因',
    `attr_size`    int(11) DEFAULT NULL COMMENT '附件文件大小，byte',
    `isvalid`      int(11) DEFAULT '1' COMMENT '记录的有效性；1-有效；0-无效；',
    `creatorid`    int(11) DEFAULT NULL COMMENT '创建者Id;第一次创建时与Creator值相同，修改时与修改人值相同',
    `updaterid`    int(11) DEFAULT NULL COMMENT '修改者Id;第一次创建时与Creator值相同，修改时与修改人值相同',
    `createtime`   datetime     DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间,默认第一次创建的getdate()时间',
    `updatetime`   datetime     DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间;第一次创建时与CreatTime值相同，修改时与修改时间相同',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COMMENT='邮件解析信息表';

CREATE TABLE `daq_email_field_mapping`
(
    `id`         int(11) NOT NULL AUTO_INCREMENT COMMENT '主键Id',
    `code`       varchar(255) DEFAULT NULL COMMENT '字段编码',
    `name`       text COMMENT '字段(多个以英文逗号隔开)',
    `type`       int(11) DEFAULT NULL COMMENT '3-定期报告，4-交易流水确认函，0-共用的',
    `isvalid`    int(11) DEFAULT '1' COMMENT '记录的有效性；1-有效；0-无效；',
    `creatorid`  int(11) DEFAULT NULL COMMENT '创建者Id;第一次创建时与Creator值相同，修改时与修改人值相同',
    `updaterid`  int(11) DEFAULT NULL COMMENT '修改者Id;第一次创建时与Creator值相同，修改时与修改人值相同',
    `createtime` datetime     DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间,默认第一次创建的getdate()时间',
    `updatetime` datetime     DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间;第一次创建时与CreatTime值相同，修改时与修改时间相同',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COMMENT='邮件字段映射表';

CREATE TABLE `daq_task_record`
(
    `id`         int(11) NOT NULL AUTO_INCREMENT COMMENT '主键Id',
    `task_key`   varchar(50) NOT NULL COMMENT '任务的标识',
    `start_time` datetime DEFAULT NULL COMMENT '任务开始执行的时间',
    `end_time`   datetime DEFAULT NULL COMMENT '任务执行结束时的时间',
    `status`     int(4) DEFAULT '0' COMMENT '任务执行状态，0-执行中，1-执行完成，2-执行失败',
    `err_msg`    text COMMENT '任务执行失败时的信息',
    `createtime` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间,默认第一次创建的getdate()时间',
    `updatetime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间;第一次创建时与CreatTime值相同，修改时与修改时间相同',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COMMENT='任务执行记录表（轮询任务的执行记录表，前面的任务未执行完成时不允许重复执行）';



INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('fundName', '基金名称,产品名称,产品全称,基金产品,名称,资产名称,账户名称,账套名称,子产品名称,项目名称,产品名称全称', 0, 1, null, null, '2025-02-20 15:54:06', '2025-05-07 14:24:43');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('fundCode', '备案编码,协会备案编号,协会备案编码,协会备案代码,基金协会代码,产品编码,产品代码,产品备案号,产品备案编码,基金代码,基金编码,资产代码,代码,子产品代码,协会代码,基金编号', 0, 1, null, null, null, '2025-05-12 11:56:07');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('companyName', '管理人,基金管理人', 0, 1, null, null, '2025-02-20 15:54:06', '2025-02-20 15:54:06');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('currency', '币种,货币种类', 4, 1, null, null, '2025-02-20 16:05:35', '2025-02-20 16:05:35');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('investorName', '投资人,客户名称,投资者名称,投资者姓名,投资者,投资人名称,委托人名称,委托人姓名', 4, 1, null, null, '2025-02-20 16:05:35', '2025-03-18 16:07:36');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('investorType', '投资人类别,投资者类型,投资人类型', 4, 1, null, null, '2025-02-20 16:05:35', '2025-02-22 09:18:54');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('certificateType', '证件类型,投资者证件类型', 4, 1, null, null, '2025-02-20 16:05:35', '2025-02-20 16:05:35');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('certificateNumber', '证件号码,投资者证件号码', 4, 1, null, null, '2025-02-20 16:05:35', '2025-02-20 16:05:35');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('fundAccount', '基金账号,投资者基金账号', 4, 1, null, null, '2025-02-20 16:05:35', '2025-02-20 16:05:35');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('tradingAccount', '交易账号,投资者交易账号', 4, 1, null, null, '2025-02-20 16:05:35', '2025-02-20 16:05:35');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('distributor', '销售商,销售机构,网点', 4, 1, null, null, '2025-02-20 16:05:35', '2025-02-20 16:05:35');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('nav', '单位净值,单位净值元,当日单位净值,今日单位净值,计提前单位净值,实际净值,基金净值,资产份额净值,资产份额净值元,份额净值,基金份额净值,基金份额净值元,基金单位净值,虚拟净值提取前单位净值,报告期期末单位净值,虚拟计提前单位净值,试算前单位净值,期末单位净值,子产品单位净值,产品单位净值,本级别单位净值,委托资产份额净值元,期末基金份额净值', 0, 1, null, null, '2025-02-20 17:17:20', '2025-05-09 16:03:05');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('transactionType', '业务类型,业务代码,业务类别', 4, 1, null, null, '2025-02-20 18:07:51', '2025-03-11 18:32:56');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('businessReason', '业务类型原因,失败原因,原因', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-20 18:08:10');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('status', '确认状态', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-20 18:08:10');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('holdingDate', '确认日期,交易确认日期', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-20 18:08:10');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('applyDate', '申请日期', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-20 18:08:10');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('applyAmount', '申请的金额,申请金额,申请金额(元)', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-22 11:04:39');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('applyShare', '申请的份额,申请份额,申请的基金份额数量', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-20 18:08:10');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('amount', '确认的金额,确认金额,确认金额(元),业绩报酬计提金额,再投资金额,再投资红利金额,原确认金额', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-22 11:04:39');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('share', '确认的份额,确认份额,扣减份额,再投资份额,持有份额', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-28 17:28:30');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('netAmount', '净认购/申购的金额,确认净额', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-20 18:08:10');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('fee', '交易费,手续费用,交易费(元),手续费用(元),总费用,总费用(元),再投资费用', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-22 11:04:38');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('confirmationRatio', '确认比例', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-20 18:08:10');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('taConfirmationNumber', 'TA确认号,TA确认编号,确认单号,TA确认单号', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-22 11:04:38');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('interest', '利息,利息(元)', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-22 11:04:38');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('interestToFundAssets', '利息转份额,利息归基金资产', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-20 18:08:10');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('applyNo', '申请单号', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('shareBalance', '份额余额', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('shareCategory', '份额类别', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('largeRedemptionType', '巨额赎回方式', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('tradeFee', '交易费,交易费(元)', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('defaultFee', '违约金,违约金(元)', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('performanceFee', '业绩报酬,业绩报酬(元)', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('feeDiscounts', '费用折扣', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('performanceFeeDiscounts', '业绩报酬折扣', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('dividendRegistryDate', '分红登记日', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('dividendPaymentDate', '红利发放日,红利下发日', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('baseShareDividend', '分红基数份额,分红总份额', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('dividendMode', '分红模式', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('unitDividend', '单位分红', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('dividendPerUnit', '每单位分红', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('totalDividendAmount', '红利总额,分红总金额', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('actualCashDividend', '实发现金红利,实际所得现金红利', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('frozenShares', '冻结份额', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('frozenAmount', '冻结金额', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('actualPerformanceAmount', '实际业绩提成金额,实际提成金额', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('actualPerformanceShare', '实际提成份额,实际业绩提成份额', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('rewardMark', '提成或保底标志', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('holdingDays', '持有天数', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('shareRegistryDate', '份额明细注册日期', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('taNumber', 'TA代码', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO daq_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('dividendType', '分红方式', 4, 1, null, null, '2025-02-22 13:41:57', '2025-02-28 17:30:31');