| | |
|---|
| | | 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'; |
|---|
| | | COMMENT ON COLUMN official_inventory.coal_plan_id IS '煤质方案id'; |
|---|
| | | COMMENT ON COLUMN official_inventory.pending_id IS '待入库id'; |
|---|
| | | COMMENT ON COLUMN official_inventory.price_excluding_tax IS '不含税单价'; |
|---|
| | | COMMENT ON COLUMN official_inventory.total_price_excluding_tax IS '不含税总价'; |
|---|
| | | |
|---|
| | | COMMENT ON COLUMN official_inventory.deleted IS '软删除标志，0=未删除，1=已删除'; |
|---|
| | | COMMENT ON COLUMN official_inventory.create_by IS '创建该记录的用户'; |
|---|
