-- 采购申请对齐采购台账字段：新增/编辑申请单要与新增采购台账字段一致
|
-- 执行库：product-inventory-management（各租户库同）
|
ALTER TABLE `purchase_application`
|
ADD COLUMN `purchase_contract_number` varchar(50) DEFAULT NULL COMMENT '采购合同号' AFTER `convert_time`,
|
ADD COLUMN `recorder_id` bigint DEFAULT NULL COMMENT '录入人id' AFTER `purchase_contract_number`,
|
ADD COLUMN `entry_date` date DEFAULT NULL COMMENT '录入日期' AFTER `recorder_id`,
|
ADD COLUMN `execution_date` date DEFAULT NULL COMMENT '签订日期' AFTER `entry_date`,
|
ADD COLUMN `best_arrival_date` date DEFAULT NULL COMMENT '最佳到站日期' AFTER `execution_date`,
|
ADD COLUMN `application_submit_time` datetime DEFAULT NULL COMMENT '申请提交时间' AFTER `best_arrival_date`,
|
ADD COLUMN `purchase_category` varchar(50) DEFAULT NULL COMMENT '采购类别：客存、代储、采购入库、采购直销' AFTER `application_submit_time`,
|
ADD COLUMN `logistics_method` varchar(50) DEFAULT NULL COMMENT '物流方式：厂家配送、委外物流、客户自提' AFTER `purchase_category`,
|
ADD COLUMN `pickup_method` varchar(50) DEFAULT NULL COMMENT '提货方式：暂不提货、提货' AFTER `logistics_method`,
|
ADD COLUMN `oil_depot_id` bigint DEFAULT NULL COMMENT '采购油库id' AFTER `pickup_method`,
|
ADD COLUMN `customer_name` varchar(100) DEFAULT NULL COMMENT '客户名称' AFTER `oil_depot_id`,
|
ADD COLUMN `purchase_quantity` int DEFAULT NULL COMMENT '采购数量（吨）' AFTER `customer_name`,
|
ADD COLUMN `purchase_order_status` varchar(50) DEFAULT NULL COMMENT '采购申请订单状态' AFTER `purchase_quantity`;
|
|
-- 采购申请产品明细新增预警数量（与采购台账明细 warn_num 对齐）
|
ALTER TABLE `purchase_application_product`
|
ADD COLUMN `warn_num` decimal(10, 2) DEFAULT NULL COMMENT '预警数量' AFTER `quantity`;
|
