Files
MES/yawei-mes/.sql/2026-02-06_00_袁伟杰_生产订单添加销售单号.sql

10 lines
545 B
MySQL
Raw Permalink Normal View History

2026-04-02 10:38:23 +08:00
alter table sal_order
add no varchar(50) null comment '生产订单中的销售单号显示';
INSERT INTO sys_field_extend
(`source_bill`, `sort`, `field`, `field_name`, `type`, `quote_data`, `quote_field`, `formula`, `is_required`, `is_must`,
`status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `width`, `default_value`, `is_system`)
VALUES ('saleOrderEntry', 10, 'salOrder.no', '销售单号', 'text', NULL, NULL, NULL, NULL, NULL, '0', NULL, 'admin',
'2026-02-06 10:12:00', NULL, NULL, 200, NULL, 'Y');