| | |
| | | master_id BIGINT, -- 生产加工id |
| | | purchase_id BIGINT, -- 采购id |
| | | coal_plan_id BIGINT, -- 煤质方案id |
| | | type BIGINT, -- 煤料类型 1-成品 2-原料 |
| | | |
| | | deleted INTEGER DEFAULT 0, -- 软删除标志,0=未删除,1=已删除 |
| | | create_by VARCHAR(255), -- 创建该记录的用户 |
| | |
| | | COMMENT ON COLUMN pending_inventory.price_including_tax IS '单价(含税)'; |
| | | COMMENT ON COLUMN pending_inventory.total_price_including_tax IS '总价(含税)'; |
| | | COMMENT ON COLUMN pending_inventory.registrant IS '登记人'; |
| | | COMMENT ON COLUMN pending_inventory.type IS '煤料类型 1-成品 2-原料'; |
| | | COMMENT ON COLUMN pending_inventory.registration_time IS '登记时间'; |
| | | COMMENT ON COLUMN pending_inventory.price_excluding_tax IS '单价(不含税)'; |
| | | COMMENT ON COLUMN pending_inventory.total_price_excluding_tax IS '总价(不含税)'; |