liuminghui
75 lines
4.7 KiB
SQL
75 lines
4.7 KiB
SQL
-- `pay_bill` 增加税率
|
|
ALTER TABLE `bms`.`pay_bill` ADD COLUMN `tax_rate` decimal(8,4) NOT NULL DEFAULT 0.0000 COMMENT '税率，0.06 表示 6%' AFTER `confirm_time`;
|
|
|
|
-- `pay_bill` 增加不含税金额
|
|
ALTER TABLE `bms`.`pay_bill` ADD COLUMN `amount_net` decimal(18,2) NOT NULL DEFAULT 0.00 COMMENT '不含税金额' AFTER `tax_rate`;
|
|
|
|
-- `pay_bill` 增加税额
|
|
ALTER TABLE `bms`.`pay_bill` ADD COLUMN `tax_amount` decimal(18,2) NOT NULL DEFAULT 0.00 COMMENT '税额' AFTER `amount_net`;
|
|
|
|
-- `pay_bill` 增加折本位币汇率
|
|
ALTER TABLE `bms`.`pay_bill` ADD COLUMN `exchange_rate` decimal(18,6) NOT NULL DEFAULT 1.000000 COMMENT '折人民币汇率' AFTER `tax_amount`;
|
|
|
|
-- `pay_bill` 增加本位币金额
|
|
ALTER TABLE `bms`.`pay_bill` ADD COLUMN `base_amount` decimal(18,2) NOT NULL DEFAULT 0.00 COMMENT '本位币金额，人民币' AFTER `exchange_rate`;
|
|
|
|
-- `pay_bill` 增加汇率日期
|
|
ALTER TABLE `bms`.`pay_bill` ADD COLUMN `rate_date` date DEFAULT NULL COMMENT '汇率日期' AFTER `base_amount`;
|
|
|
|
-- `pay_bill` 增加账期天数
|
|
ALTER TABLE `bms`.`pay_bill` ADD COLUMN `term_days` int(11) DEFAULT NULL COMMENT '账期天数，来自供应商应付账期' AFTER `rate_date`;
|
|
|
|
-- `pay_bill` 增加提交人
|
|
ALTER TABLE `bms`.`pay_bill` ADD COLUMN `submit_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '提交审核人' AFTER `term_days`;
|
|
|
|
-- `pay_bill_line` 增加税率
|
|
ALTER TABLE `bms`.`pay_bill_line` ADD COLUMN `tax_rate` decimal(8,4) NOT NULL DEFAULT 0.0000 COMMENT '税率，0.06 表示 6%' AFTER `diff_status`;
|
|
|
|
-- `pay_bill_line` 增加不含税金额
|
|
ALTER TABLE `bms`.`pay_bill_line` ADD COLUMN `amount_net` decimal(18,4) NOT NULL DEFAULT 0.0000 COMMENT '不含税金额' AFTER `tax_rate`;
|
|
|
|
-- `pay_bill_line` 增加税额
|
|
ALTER TABLE `bms`.`pay_bill_line` ADD COLUMN `tax_amount` decimal(18,4) NOT NULL DEFAULT 0.0000 COMMENT '税额' AFTER `amount_net`;
|
|
|
|
-- `pay_bill_line` 增加本位币金额
|
|
ALTER TABLE `bms`.`pay_bill_line` ADD COLUMN `base_amount` decimal(18,4) NOT NULL DEFAULT 0.0000 COMMENT '本位币金额，人民币' AFTER `tax_amount`;
|
|
|
|
-- `prc_pay_bill_fee` 增加结算供应商
|
|
ALTER TABLE `bms`.`prc_pay_bill_fee` ADD COLUMN `settle_supplier_id` bigint(20) DEFAULT NULL COMMENT '结算供应商ID，空表示还没标明付款对象' AFTER `statement_line_id`;
|
|
|
|
-- `prc_pay_bill_fee` 增加结算供应商名称
|
|
ALTER TABLE `bms`.`prc_pay_bill_fee` ADD COLUMN `settle_supplier_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '结算供应商名称' AFTER `settle_supplier_id`;
|
|
|
|
-- `prc_pay_bill_fee` 增加结算供应商索引
|
|
ALTER TABLE `bms`.`prc_pay_bill_fee` ADD INDEX `idx_pay_fee_settle` (`settle_supplier_id`, `statement_line_id`);
|
|
|
|
-- `pay_bill_file` 增加不含税金额
|
|
ALTER TABLE `bms`.`pay_bill_file` ADD COLUMN `amount_net` decimal(18,2) DEFAULT NULL COMMENT '不含税金额' AFTER `tax_amount`;
|
|
|
|
-- `pay_bill_file` 增加销方
|
|
ALTER TABLE `bms`.`pay_bill_file` ADD COLUMN `seller_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '销方名称' AFTER `amount_net`;
|
|
|
|
-- `pay_bill_file` 增加已勾稽金额
|
|
ALTER TABLE `bms`.`pay_bill_file` ADD COLUMN `matched_amount` decimal(18,2) NOT NULL DEFAULT 0.00 COMMENT '已勾稽到账单的金额' AFTER `seller_name`;
|
|
|
|
-- `pay_bill_file` 增加币种
|
|
ALTER TABLE `bms`.`pay_bill_file` ADD COLUMN `currency` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '币种' AFTER `matched_amount`;
|
|
|
|
-- `pay_payment` 增加汇率
|
|
ALTER TABLE `bms`.`pay_payment` ADD COLUMN `exchange_rate` decimal(18,6) NOT NULL DEFAULT 1.000000 COMMENT '折人民币汇率' AFTER `bank_fee`;
|
|
|
|
-- `pay_payment` 增加本位币金额
|
|
ALTER TABLE `bms`.`pay_payment` ADD COLUMN `base_amount` decimal(18,2) NOT NULL DEFAULT 0.00 COMMENT '本位币金额，人民币' AFTER `exchange_rate`;
|
|
|
|
-- `pay_payment` 增加已核销金额
|
|
ALTER TABLE `bms`.`pay_payment` ADD COLUMN `alloc_amount` decimal(18,2) NOT NULL DEFAULT 0.00 COMMENT '已核销到账单的金额' AFTER `base_amount`;
|
|
|
|
-- `pay_payment_alloc` 增加核销状态
|
|
ALTER TABLE `bms`.`pay_payment_alloc` ADD COLUMN `alloc_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'ACTIVE' COMMENT 'ACTIVE有效 REVERSED已反核销' AFTER `alloc_amount`;
|
|
|
|
-- `pay_payment_alloc` 增加反核销人
|
|
ALTER TABLE `bms`.`pay_payment_alloc` ADD COLUMN `reverse_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '反核销人' AFTER `alloc_status`;
|
|
|
|
-- `pay_payment_alloc` 增加反核销时间
|
|
ALTER TABLE `bms`.`pay_payment_alloc` ADD COLUMN `reverse_time` datetime DEFAULT NULL COMMENT '反核销时间' AFTER `reverse_by`;
|