INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (0, '待开票', '0', 'invoicing_status', 0, 'default', '', NULL, '1', '2024-12-20 17:43:26', '1', '2024-12-20 17:45:36', b'0', 'To be invoiced', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (1, '已开票', '1', 'invoicing_status', 0, 'default', '', NULL, '1', '2024-12-20 17:43:52', '1', '2024-12-20 17:43:52', b'0', 'Have been invoiced', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (2, '已取消', '2', 'invoicing_status', 0, 'default', '', NULL, '1', '2024-12-20 17:44:27', '1', '2024-12-20 17:44:27', b'0', 'canceled', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (3, '不开票', '3', 'invoicing_status', 0, 'default', '', NULL, '1', '2024-12-20 17:45:21', '1', '2024-12-20 17:45:48', b'0', 'no invoicing', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (0, '未录入', '0', 'receipt_detail_status', 0, 'default', '', NULL, '1', '2024-12-20 18:07:00', '1', '2024-12-20 18:07:00', b'0', 'Not entered', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (1, '未提交', '1', 'receipt_detail_status', 0, 'default', '', NULL, '1', '2024-12-20 18:07:30', '1', '2024-12-20 18:07:30', b'0', 'unsubmitted', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (2, '部分提交', '2', 'receipt_detail_status', 0, 'default', '', NULL, '1', '2024-12-20 18:07:52', '1', '2024-12-20 18:07:52', b'0', 'Submitted in part', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (3, '未审批', '3', 'receipt_detail_status', 0, 'default', '', NULL, '1', '2024-12-20 18:08:12', '1', '2024-12-20 18:08:12', b'0', 'Not approved', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (4, '部分审批', '4', 'receipt_detail_status', 0, 'default', '', NULL, '1', '2024-12-20 18:08:38', '1', '2024-12-20 18:08:38', b'0', 'Partial approval', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (5, '全部审批', '5', 'receipt_detail_status', 0, 'default', '', NULL, '1', '2024-12-20 18:09:06', '1', '2024-12-20 18:09:06', b'0', 'All approved', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (4, '无申请记录', '4', 'invoicing_status', 0, 'default', '', NULL, '1', '2024-12-23 10:22:54', '1', '2024-12-23 10:23:09', b'0', 'no record', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (0, '已提交', '0', 'invoice_data_status', 0, 'default', '', NULL, '1', '2024-12-23 10:23:55', '1', '2024-12-25 15:02:17', b'0', 'Submit', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (1, '已驳回', '1', 'invoice_data_status', 0, 'default', '', NULL, '1', '2024-12-23 10:24:10', '1', '2024-12-25 15:02:27', b'0', 'Reject', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (0, '申请开票', '0', 'invoicing_link', 0, 'default', '', NULL, '1', '2024-12-26 13:48:53', '1', '2024-12-26 13:48:53', b'0', 'Apply Invoice', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (1, '取消开票', '1', 'invoicing_link', 0, 'default', '', NULL, '1', '2024-12-26 13:49:10', '1', '2024-12-26 13:49:10', b'0', 'Cancel Invoice', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (2, '修改开票信息', '2', 'invoicing_link', 0, 'default', '', NULL, '1', '2024-12-26 13:49:29', '1', '2024-12-26 13:49:29', b'0', 'Modify Invoice Info', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (3, '删除开票信息', '3', 'invoicing_link', 0, 'default', '', NULL, '1', '2024-12-26 13:49:51', '1', '2024-12-26 13:49:51', b'0', 'Delete Invoice Info', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (4, '驳回开票资料', '4', 'invoicing_link', 0, 'default', '', NULL, '1', '2024-12-26 13:50:06', '1', '2024-12-26 13:50:06', b'0', 'Reject Invoice Data', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (5, '提交开票', '5', 'invoicing_link', 0, 'default', '', NULL, '1', '2024-12-26 13:50:23', '1', '2024-12-26 13:50:23', b'0', 'Submit Invoice', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (6, '修改开票资料', '6', 'invoicing_link', 0, 'default', '', NULL, '1', '2024-12-26 13:50:40', '1', '2024-12-26 13:50:40', b'0', 'Modify Invoice Data', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 0, '无需审核', '2', 'invoice_data_status', 0, 'default', '', NULL, '1', '2024-12-27 14:59:20', '1', '2024-12-27 14:59:20', b'0', 'No audit required', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 4, '审批拒绝', '4', 'receipt_item_state', 0, 'default', '', NULL, '1', '2024-12-30 13:46:20', '1', '2024-12-30 13:46:20', b'0', 'Approval rejected', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 0, '单个生成', '0', 'receipt_generate_path', 0, 'default', '', NULL, '1', '2024-12-31 16:32:58', '1', '2024-12-31 16:32:58', b'0', 'single', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 1, '批量生成', '1', 'receipt_generate_path', 0, 'default', '', NULL, '1', '2024-12-31 16:34:08', '1', '2024-12-31 16:34:08', b'0', 'batch', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 0, '创建收款单', '0', 'receipt_link', 0, 'default', '', NULL, '1', '2025-01-02 17:32:06', '1', '2025-01-02 17:32:06', b'0', 'Create Receipt', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 1, '编辑收款单', '1', 'receipt_link', 0, 'default', '', NULL, '1', '2025-01-02 17:32:20', '1', '2025-01-02 17:32:20', b'0', 'Edit Receipt', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 2, '提交收款单', '2', 'receipt_link', 0, 'default', '', NULL, '1', '2025-01-02 17:33:24', '1', '2025-01-02 17:33:24', b'0', 'Submit Receipt', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 3, '反审核收款单', '3', 'receipt_link', 0, 'default', '', NULL, '1', '2025-01-02 17:33:45', '1', '2025-01-02 17:33:45', b'0', 'Reject Receipt', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 4, '审核收款单', '4', 'receipt_link', 0, 'default', '', NULL, '1', '2025-01-02 17:34:08', '1', '2025-01-02 17:34:08', b'0', 'Approve Receipt', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 5, '提交银行收款明细', '5', 'receipt_link', 0, 'default', '', NULL, '1', '2025-01-02 17:34:34', '1', '2025-01-02 17:34:34', b'0', 'Submit Bank Receipt', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 6, '反审核银行收款明细', '6', 'receipt_link', 0, 'default', '', NULL, '1', '2025-01-02 17:34:56', '1', '2025-01-02 17:34:56', b'0', 'Reject Bank Receipt', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 7, '审批银行收款明细', '7', 'receipt_link', 0, 'default', '', NULL, '1', '2025-01-02 17:35:17', '1', '2025-01-02 17:35:17', b'0', 'Approve Bank Receipt', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 8, '核销收款单', '8', 'receipt_link', 0, 'default', '', NULL, '1', '2025-01-02 17:35:36', '1', '2025-01-02 17:35:36', b'0', 'Write Off Receipt', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 9, '反核销收款单', '9', 'receipt_link', 0, 'default', '', NULL, '1', '2025-01-02 17:35:52', '1', '2025-01-02 17:35:52', b'0', 'Reject Write Off Receipt', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (0, '大于', '0', 'income_relation_symbol', 0, 'default', '', NULL, '1', '2025-01-09 13:43:35', '1', '2025-01-09 13:43:35', b'0', 'Greater than', 'supérieur à');
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (1, '等于', '1', 'income_relation_symbol', 0, 'default', '', NULL, '1', '2025-01-09 13:44:18', '1', '2025-01-09 13:44:18', b'0', 'Equal', 'égal');
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (2, '小于等于', '2', 'income_relation_symbol', 0, 'default', '', NULL, '1', '2025-01-09 13:46:19', '1', '2025-01-09 13:46:19', b'0', 'Less or equal', 'inférieur ou égal à');
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (4, '开票资料消息', '4', 'internal_message_type', 0, 'default', '', NULL, '1', '2025-01-10 15:32:05', '1', '2025-01-10 15:32:05', b'0', 'Invoicing Data Message', ' Message d\'information sur la facturation');
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (5, '开票消息', '5', 'internal_message_type', 0, 'default', '', NULL, '1', '2025-01-10 15:33:02', '1', '2025-01-10 15:33:02', b'0', 'Invoicing Message', 'Message de facturation');
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (0, '未完成', '0', 'lading_Bill_Status_Data', 0, 'default', '', NULL, '2696', '2025-01-13 17:15:41', '2696', '2025-01-13 17:15:41', b'0', 'unfinished', 'To Be Continued.');
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (1, '部分完成', '1', 'lading_Bill_Status_Data', 0, 'default', '', NULL, '2696', '2025-01-13 17:19:46', '2696', '2025-01-13 17:20:23', b'0', 'partly completed', 'Partiellement terminé en');
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (2, '已完成', '2', 'lading_Bill_Status_Data', 0, 'default', '', NULL, '2696', '2025-01-13 17:20:59', '2696', '2025-01-13 17:20:59', b'0', 'completed', 'Déjà terminé avec');
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (0, '目的国', '0', 'attribution_of_income', 0, 'default', '', NULL, '2696', '2025-01-14 16:25:16', '2696', '2025-01-14 16:25:16', b'0', 'country of destination', 'Pays de destination');
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (1, '始发国', '1', 'attribution_of_income', 0, 'default', '', NULL, '2696', '2025-01-14 16:25:53', '2696', '2025-01-14 16:25:53', b'0', 'Country of origin', 'Pays de départ');
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (0, '大于等于', 'gePickRatio', 'pickup_rate_comparison_symbols', 0, 'default', '', NULL, '1', '2025-01-15 18:15:04', '1', '2025-01-16 15:13:07', b'0', 'great than or equal to', 'Supérieur ou égal');
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (1, '小于等于', 'lePickRatio', 'pickup_rate_comparison_symbols', 0, 'default', '', NULL, '1', '2025-01-15 18:16:04', '1', '2025-01-16 15:13:44', b'0', 'less than or equal to', 'Inférieur ou égal');
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (2, '等于', 'eqPickRatio', 'pickup_rate_comparison_symbols', 0, 'default', '', NULL, '1', '2025-01-15 18:16:49', '1', '2025-01-16 15:12:40', b'0', 'equal to', 'égal à');
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (3, '不等于', 'nePickRatio', 'pickup_rate_comparison_symbols', 0, 'default', '', NULL, '1', '2025-01-15 18:17:32', '1', '2025-01-16 15:14:01', b'0', 'not equal to', 'Pas égal à');


INSERT INTO `system_dict_type` (`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES ( '开票状态', 'invoicing_status', 0, NULL, '1', '2024-12-20 17:42:06', '1', '2024-12-20 17:42:06', b'0');
INSERT INTO `system_dict_type` (`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES ( '开票资料状态', 'invoice_data_status', 0, NULL, '1', '2024-12-20 18:05:13', '1', '2024-12-20 18:05:13', b'0');
INSERT INTO `system_dict_type` (`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES ( '明细状态', 'receipt_detail_status', 0, NULL, '1', '2024-12-20 18:06:26', '1', '2024-12-20 18:06:26', b'0');
INSERT INTO `system_dict_type` (`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES ( '开票环节', 'invoicing_link', 0, '用于日志记录', '1', '2024-12-26 13:48:05', '1', '2024-12-26 13:48:05', b'0');
INSERT INTO `system_dict_type` (`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES ( '收款单生成路径', 'receipt_generate_path', 0, NULL, '1', '2024-12-31 16:31:49', '1', '2024-12-31 16:31:49', b'0');
INSERT INTO `system_dict_type` (`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES ( '收款单日志环节', 'receipt_link', 0, NULL, '1', '2025-01-02 17:31:39', '1', '2025-01-02 17:31:39', b'0');
INSERT INTO `system_dict_type` (`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES ( '银行收支明细查询关系符号', 'income_relation_symbol', 0, NULL, '1', '2025-01-09 13:17:51', '1', '2025-01-09 13:18:11', b'0');
INSERT INTO `system_dict_type` (`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES ('提单制作', 'lading_Bill_Status_Data', 0, NULL, '2696', '2025-01-13 17:14:03', '2696', '2025-01-13 17:14:03', b'0');
INSERT INTO `system_dict_type` (`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES ('收入归属', 'attribution_of_income', 0, NULL, '2696', '2025-01-14 16:23:59', '2696', '2025-01-14 16:23:59', b'0');
INSERT INTO `system_dict_type` (`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES ('提货率比较符号', 'pickup_rate_comparison_symbols', 0, NULL, '1', '2025-01-15 18:12:22', '1', '2025-01-15 18:12:22', b'0');


INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('银行账号', '', 2, 2, 1624, 'bankAccount', 'date-range', NULL, 0, '2696', '2025-01-14 16:39:59', '2696', '2025-01-14 16:39:59', b'0', b'1', 'Bank Account', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('费用明细', '', 2, 1, 1624, 'chargeDetails', 'druid', 'ecw/financial/chargeDetails', 0, '1', '2024-12-20 13:56:04', '1', '2024-12-20 13:56:04', b'0', b'1', 'chargeDetails', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('自动审批规则', '', 2, 1, 1624, 'setAutoApprovalRules', 'checkbox', 'ecw/financial/setAutoApprovalRules', 0, '1', '2024-12-20 16:34:19', '1', '2024-12-20 16:34:19', b'0', b'1', 'Automatic approval rules', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('申请开票', 'ecw:voucher:applyInvoice', 3, 13, 1634, '', '', '', 0, '1', '2024-12-23 09:24:01', '1', '2024-12-23 09:24:01', b'0', b'1', 'Apply for Invoice', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('修改收款单', 'ecw:voucher:editReceipt', 3, 7, 1634, '', '', '', 0, '1', '2024-12-23 09:27:51', '1', '2024-12-23 09:27:51', b'0', b'1', 'Modify the receipt', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('修改开票申请', 'ecw:voucher:editInvoiceApplication', 3, 2, 1634, '', '', '', 0, '1', '2024-12-23 09:32:26', '1', '2024-12-23 09:32:26', b'0', b'1', 'Modify Invoice application', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('取消开票', 'ecw:voucher:cancalInvoicing', 3, 1, 1634, '', '', '', 0, '1', '2024-12-23 09:38:04', '1', '2024-12-23 09:38:04', b'0', b'1', 'Cancel invoicing', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('开票信息', 'ecw:voucher:invoiceInformation', 3, 4, 1634, '', '', '', 0, '1', '2024-12-23 09:46:53', '1', '2024-12-23 09:46:53', b'0', b'1', 'invoice information', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('导入银行收款信息', 'ecw:voucher:importBankCollectionInfo', 3, 2, 1634, '', '', '', 0, '1', '2024-12-23 10:23:51', '1', '2024-12-23 10:23:51', b'0', b'1', 'Import bank collection information', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('开票申请/修改', '', 2, 1, 1624, 'invoiceOperate', 'bug', 'ecw/financial/invoiceOperate', 0, '1', '2024-12-23 11:17:32', '1', '2024-12-23 11:17:32', b'0', b'0', 'invoice application/amendment', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('开票管理', '', 2, 2, (SELECT tmp.id FROM(SELECT id FROM system_menu WHERE `name` = '银行账号')tmp), 'invoiceManagement', 'order', 'ecw/financial/invoiceManagement', 0, '1', '2024-12-24 18:13:46', '2696', '2025-01-14 16:44:06', b'0', b'1', 'invoiceManagement', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('收款数据审批列表', '', 2, 2, 1624, 'collectionApprovalList', 'clipboard', 'ecw/financial/collectionApprovalList', 0, '1', '2025-01-03 08:58:08', '1', '2025-01-03 08:58:08', b'0', b'1', 'collectionApprovalList', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('审批', 'ecw:collectionApprovalList:update', 3, 1, (SELECT tmp.id FROM(SELECT id FROM system_menu WHERE `name` = '收款数据审批列表')tmp), '', '', '', 0, '1', '2025-01-03 16:59:36', '1', '2025-01-03 16:59:36', b'0', b'1', 'approve', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('批量生成收款单', '', 2, 12, 1624, 'batchGenerateReceipt/:id', 'button', 'ecw/financial/batchGenerateReceipt', 0, '2696', '2025-01-08 09:57:18', '2696', '2025-01-09 10:53:46', b'0', b'0', 'batchGenerateReceipt', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('批量生成收款单列表', '', 2, 7, 1624, 'batchGenerateReceiptList', 'component', 'ecw/financial/batchGenerateReceiptList', 0, '2696', '2025-01-08 09:58:54', '2696', '2025-01-08 09:58:54', b'0', b'1', 'batchGenerateReceiptList', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('银行收支明细', '', 2, 2, (SELECT tmp.id FROM(SELECT id FROM system_menu WHERE `name` = '银行账号')tmp), 'bankBalanceDetails', 'dashboard', 'ecw/financial/bankBalanceDetails', 0, '2696', '2025-01-09 13:44:20', '2696', '2025-01-14 16:42:24', b'0', b'1', 'bank Balance Details', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('单个订单费用明细', '', 2, 4, 1624, 'orderItemCostDetails/:id/:drawee', 'theme', 'ecw/financial/orderItemCostDetails', 0, '2696', '2025-01-09 15:30:19', '2696', '2025-01-13 10:17:48', b'0', b'0', 'orderItemCostDetails', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('应收', '', 2, 1, 1624, 'receivable', 'component', NULL, 0, '2696', '2025-01-14 15:59:47', '2696', '2025-01-14 16:02:55', b'0', b'1', 'receivable', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('新应收报表', '', 2, 1, (SELECT tmp.id FROM(SELECT id FROM system_menu WHERE `name` = '应收')tmp), 'selfNoReportNew', 'skill', 'ecw/financial/selfNoReportNew', 0, '2696', '2025-01-13 13:52:48', '2696', '2025-01-14 16:04:41', b'0', b'1', 'selfNoReportNew', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('应付', '', 2, 2, 1624, 'accountsPayable', 'international', NULL, 0, '2696', '2025-01-14 16:48:14', '2696', '2025-01-14 16:48:14', b'0', b'1', 'accounts payable', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('佣金', '', 2, 5, 1624, 'commission', 'monitor', NULL, 0, '2696', '2025-01-14 16:56:29', '2696', '2025-01-14 16:56:29', b'0', b'1', 'commission', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('订单费用明细列表', '', 2, 5, (SELECT tmp.id FROM(SELECT id FROM system_menu WHERE `name` = '应收')tmp), 'selfNoReportDetailNew', 'example', 'ecw/financial/selfNoReportNew/selfNoReportDetailNew', 0, '1', '2025-01-15 13:51:19', '1', '2025-01-15 13:51:19', b'0', b'0', 'selfNoReportDetailNew', b'0', NULL, NULL);

UPDATE `system_dict_data` SET `status` = 1 WHERE `id` = 1784;
UPDATE `system_dict_data` SET `label` = '审批拒绝' WHERE `id` = 2096;

UPDATE `system_menu` SET `name` = '银行账户', `permission` = '', `menu_type` = 2, `sort` = 1, `parent_id` = (SELECT tmp.id FROM(SELECT id FROM system_menu WHERE `name` = '银行账号')tmp), `path` = 'bank-account', `icon` = 'lock', `component` = 'ecw/bankAccount/index', `status` = 0, `creator` = '', `create_time` = '2022-05-09 11:40:51', `updater` = '2696', `update_time` = '2025-01-14 16:41:12', `deleted` = b'0', `is_show_in_menu_bar` = b'1', `name_en` = 'Bank account management', `keepalive` = b'0', `redirect` = NULL, `badge_field` = NULL WHERE `id` = 1269;
UPDATE `system_menu` SET `name` = '应收款', `permission` = '', `menu_type` = 2, `sort` = 1, `parent_id` = (SELECT tmp.id FROM(SELECT id FROM system_menu WHERE `name` = '应收')tmp), `path` = 'receivable', `icon` = 'pay', `component` = 'ecw/financial/receivable', `status` = 0, `creator` = '1', `create_time` = '2022-07-15 16:29:28', `updater` = '2696', `update_time` = '2025-01-14 16:34:34', `deleted` = b'0', `is_show_in_menu_bar` = b'1', `name_en` = 'Receivables', `keepalive` = b'0', `redirect` = NULL, `badge_field` = NULL WHERE `id` = 1625;
UPDATE `system_menu` SET `name` = '应付款', `permission` = '', `menu_type` = 2, `sort` = 3, `parent_id` = (SELECT tmp.id FROM(SELECT id FROM system_menu WHERE `name` = '应付')tmp), `path` = 'payable', `icon` = 'pay', `component` = 'ecw/financial/payable', `status` = 0, `creator` = '1', `create_time` = '2022-07-15 16:31:12', `updater` = '2696', `update_time` = '2025-01-14 16:48:57', `deleted` = b'0', `is_show_in_menu_bar` = b'1', `name_en` = 'Accounts payable', `keepalive` = b'0', `redirect` = NULL, `badge_field` = NULL WHERE `id` = 1626;
UPDATE `system_menu` SET `name` = '收款单', `permission` = '', `menu_type` = 2, `sort` = 2, `parent_id` = (SELECT tmp.id FROM(SELECT id FROM system_menu WHERE `name` = '应收')tmp), `path` = 'voucher', `icon` = 'education', `component` = 'ecw/financial/voucher', `status` = 0, `creator` = '1', `create_time` = '2022-07-21 13:38:38', `updater` = '2696', `update_time` = '2025-01-14 16:36:53', `deleted` = b'0', `is_show_in_menu_bar` = b'1', `name_en` = 'receipt', `keepalive` = b'0', `redirect` = NULL, `badge_field` = NULL WHERE `id` = 1634;
UPDATE `system_menu` SET `name` = '付款单', `permission` = '', `menu_type` = 2, `sort` = 6, `parent_id` = (SELECT tmp.id FROM(SELECT id FROM system_menu WHERE `name` = '应付')tmp), `path` = 'paymentVoucher', `icon` = 'education', `component` = 'ecw/financial/paymentVoucher', `status` = 0, `creator` = '1', `create_time` = '2022-08-16 11:20:08', `updater` = '2696', `update_time` = '2025-01-14 16:50:06', `deleted` = b'0', `is_show_in_menu_bar` = b'1', `name_en` = 'Payment Doc', `keepalive` = b'0', `redirect` = NULL, `badge_field` = NULL WHERE `id` = 1656;
UPDATE `system_menu` SET `name` = '佣金应付款', `permission` = '', `menu_type` = 2, `sort` = 6, `parent_id` = (SELECT tmp.id FROM(SELECT id FROM system_menu WHERE `name` = '佣金' AND name_en = 'commission')tmp), `path` = 'commission-payable', `icon` = 'money', `component` = 'ecw/financial/commission-payable', `status` = 0, `creator` = '1', `create_time` = '2023-03-15 10:08:26', `updater` = '2696', `update_time` = '2025-01-14 16:57:21', `deleted` = b'0', `is_show_in_menu_bar` = b'1', `name_en` = 'commissionPayable', `keepalive` = b'0', `redirect` = NULL, `badge_field` = NULL WHERE `id` = 1940;
UPDATE `system_menu` SET `name` = '佣金付款单', `permission` = '', `menu_type` = 2, `sort` = 2, `parent_id` = (SELECT tmp.id FROM(SELECT id FROM system_menu WHERE `name` = '佣金'  AND name_en = 'commission')tmp), `path` = 'commission-Payment', `icon` = 'dict', `component` = 'ecw/financial/commission-Payment', `status` = 0, `creator` = '115', `create_time` = '2023-04-06 17:04:03', `updater` = '2696', `update_time` = '2025-01-14 16:58:07', `deleted` = b'0', `is_show_in_menu_bar` = b'1', `name_en` = 'Commission Payment Document', `keepalive` = b'0', `redirect` = NULL, `badge_field` = NULL WHERE `id` = 2072;
UPDATE `system_menu` SET `name` = '应收报表', `permission` = '', `menu_type` = 2, `sort` = 0, `parent_id` = (SELECT tmp.id FROM(SELECT id FROM system_menu WHERE `name` = '应收')tmp), `path` = 'self_no_report', `icon` = 'button', `component` = 'ecw/financial/selfNoReport', `status` = 0, `creator` = '115', `create_time` = '2023-07-15 23:06:11', `updater` = '2696', `update_time` = '2025-01-14 16:00:54', `deleted` = b'0', `is_show_in_menu_bar` = b'1', `name_en` = 'Self No Report', `keepalive` = b'0', `redirect` = NULL, `badge_field` = NULL WHERE `id` = 2131;
UPDATE `system_menu` SET `name` = '银行收款明细', `permission` = '', `menu_type` = 2, `sort` = 13, `parent_id` = (SELECT tmp.id FROM(SELECT id FROM system_menu WHERE `name` = '银行账号')tmp), `path` = 'BankReceiptDetails', `icon` = 'education', `component` = 'report/BankReceiptDetails/index', `status` = 0, `creator` = '1', `create_time` = '2024-06-12 21:34:58', `updater` = '2696', `update_time` = '2025-01-14 16:45:56', `deleted` = b'0', `is_show_in_menu_bar` = b'1', `name_en` = 'Receipt Details', `keepalive` = b'0', `redirect` = NULL, `badge_field` = NULL WHERE `name` = '银行收款明细';