SET FOREIGN_KEY_CHECKS = 0;
CREATE TABLE `jiedao`.`ecw_receipt_bank_writeoff_range`
(
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`write_off_down` int NOT NULL DEFAULT 10000 COMMENT '核销比例下界（除以100）',
`write_off_up` int NOT NULL DEFAULT 10000 COMMENT '核销比例上界（除以100）',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`creator` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
`updater` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
`deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT = '银行收款明细自动核销比例设置表'
ROW_FORMAT = DYNAMIC;
CREATE TABLE `jiedao`.`ecw_receipt_invoice`
(
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`invoice_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '开票编号',
`receipt_id` bigint NOT NULL COMMENT '收款单id',
`receipt_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '收款单号（例：SKD001）',
`apply_user_id` bigint NOT NULL COMMENT '申请人id',
`invoice_remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开票资料备注',
`apply_user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '申请人姓名',
`invoice_header` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '发票抬头',
`taxpayer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '纳税人识别号',
`tax_rate` decimal(10, 2) NOT NULL COMMENT '税率',
`invoice_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开票电话',
`account_bank` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开户行',
`invoice_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开票地址',
`account_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开户账号',
`invoice_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发票号码',
`invoice_item` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开票项目',
`invoice_type_id` int NULL DEFAULT NULL COMMENT '开票类型(字典表 invoicing_type)',
`invoice_info_save_time` datetime NULL DEFAULT NULL COMMENT '发票信息最后修改时间',
`invoicer_id` bigint NULL DEFAULT NULL COMMENT '开发票人id',
`invoice_time` datetime NULL DEFAULT NULL COMMENT '开票时间',
`currency_id` bigint NULL DEFAULT NULL COMMENT '开票币种符号',
`invoice_money` decimal(15, 2) NULL DEFAULT NULL COMMENT '开票金额',
`invoice_info_remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开票信息备注',
`cancel_user_id` bigint NULL DEFAULT NULL COMMENT '开票取消人',
`cancel_time` datetime NULL DEFAULT NULL COMMENT '开票取消时间',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新者',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT = '收款单开票信息'
ROW_FORMAT = Dynamic;
CREATE TABLE `jiedao`.`ecw_receipt_log`
(
`id` bigint NOT NULL COMMENT '主键',
`receipt_link` int NULL DEFAULT NULL COMMENT '收款单环节',
`operator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作人',
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
`bmp_status` int NULL DEFAULT NULL COMMENT '审批流程',
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
`creator` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
`updater` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
`deleted` tinyint(1) NULL DEFAULT NULL COMMENT '删除标志',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT = '收款单日志'
ROW_FORMAT = DYNAMIC;
CREATE TABLE `jiedao`.`ecw_receipt_invoice_log`
(
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`invoice_id` bigint NULL DEFAULT NULL COMMENT '发票id',
`invoicing_link` int NULL DEFAULT NULL COMMENT '开票环节',
`operator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作人',
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
`bpm_status` int NULL DEFAULT NULL COMMENT '审批流程',
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
`creator` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
`updater` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
`deleted` tinyint(1) NULL DEFAULT NULL COMMENT '删除标志',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT = '收款单日志'
ROW_FORMAT = DYNAMIC;
ALTER TABLE `jiedao`.`ecw_bank_account`
ADD COLUMN `ba_country` bigint NULL DEFAULT NULL COMMENT '国家' AFTER `ba_type`;
ALTER TABLE `jiedao`.`ecw_bank_account`
ADD COLUMN `ba_income_belong` bigint NULL DEFAULT NULL COMMENT '归属' AFTER `ba_country`;
ALTER TABLE `jiedao`.`ecw_bank_account`
ADD COLUMN `ba_currency` int NULL DEFAULT NULL COMMENT '币种' AFTER `ba_income_belong`;
ALTER TABLE `jiedao`.`ecw_bank_account`
ADD COLUMN `ba_balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '余额' AFTER `ba_currency`;
ALTER TABLE `jiedao`.`ecw_receipt`
ADD COLUMN `receipt_item_status` int NULL DEFAULT NULL COMMENT '明细状态' AFTER `order_no`;
ALTER TABLE `jiedao`.`ecw_receipt`
ADD COLUMN `invoicing_status` int NULL DEFAULT NULL COMMENT '开票状态' AFTER `receipt_item_status`;
ALTER TABLE `jiedao`.`ecw_receipt`
ADD COLUMN `invoice_data_status` int NULL DEFAULT NULL COMMENT '开票资料状态' AFTER `invoicing_status`;
ALTER TABLE `jiedao`.`ecw_receipt`
ADD COLUMN `invoice_id` bigint NULL DEFAULT NULL COMMENT '开票id' AFTER `invoice_data_status`;
ALTER TABLE `jiedao`.`ecw_receipt`
ADD COLUMN `generate_path` int NULL DEFAULT 0 COMMENT '生成路径' AFTER `invoice_id`;
ALTER TABLE `jiedao`.`ecw_receipt_item`
ADD COLUMN `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '流水号' AFTER `bmp_id`;
ALTER TABLE `jiedao`.`ecw_receipt_item`
ADD COLUMN `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注' AFTER `serial_number`;
ALTER TABLE `jiedao`.`ecw_receivable`
ADD COLUMN `write_off_amount` decimal(10, 2) NOT NULL COMMENT '核销金额' AFTER `remark`;
ALTER TABLE `jiedao`.`ecw_receivable`
ADD COLUMN `base_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '基准金额' AFTER `write_off_amount`;
ALTER TABLE `jiedao`.`ecw_receivable`
ADD COLUMN `base_currency_id` int NULL DEFAULT NULL COMMENT '基准币种' AFTER `base_amount`;
SET FOREIGN_KEY_CHECKS = 1;