| | |
|---|
| | | total_price_excluding_tax DECIMAL(10, 2) NOT NULL, -- 不含税总价 |
|---|
| | | pending_replenishment DECIMAL(10, 0), -- 待补库 |
|---|
| | | registrant_id BIGINT NOT NULL, -- 登记人id |
|---|
| | | type VARCHAR(50), -- 类型 1 采购/ 2 正式 入库 |
|---|
| | | type BIGINT, -- 煤料类型 1 成品/ 2 原料 |
|---|
| | | pending_id BIGINT, -- 待入库id |
|---|
| | | coal_plan_id BIGINT, -- 煤质方案id |
|---|
| | | merge_id VARCHAR(255), -- 合并id |
|---|
| | |
|---|
| | | COMMENT ON COLUMN official_inventory.price_including_tax IS '单价（含税）'; |
|---|
| | | COMMENT ON COLUMN official_inventory.total_price_including_tax IS '总价（含税）'; |
|---|
| | | COMMENT ON COLUMN official_inventory.pending_replenishment IS '待补库'; |
|---|
| | | COMMENT ON COLUMN official_inventory.type IS '煤料类型 1 成品/ 2 原料'; |
|---|
| | | COMMENT ON COLUMN official_inventory.registrant_id IS '登记人id'; |
|---|
| | | COMMENT ON COLUMN official_inventory.registration_date IS '登记日期'; |
|---|
| | | COMMENT ON COLUMN official_inventory.merge_id IS '合并id'; |
|---|
