| | |
| | | "source_line_id" bigint DEFAULT NULL, |
| | | "source_doc_code" varchar(64) DEFAULT NULL, |
| | | "work_order_id" bigint DEFAULT NULL, |
| | | "reel_no" varchar(128) DEFAULT NULL, |
| | | "task_id" bigint DEFAULT NULL, |
| | | "workstation_id" bigint DEFAULT NULL, |
| | | "process_id" bigint DEFAULT NULL, |
| | |
| | | "quantity" decimal(12,2) DEFAULT NULL, |
| | | "batch_id" bigint DEFAULT NULL, |
| | | "batch_code" varchar(255) DEFAULT NULL, |
| | | "reel_no" varchar(128) DEFAULT NULL, |
| | | "expire_date" timestamp DEFAULT NULL, |
| | | "lot_number" varchar(128) DEFAULT NULL, |
| | | "quality_status" int DEFAULT NULL, |
| | |
| | | "quantity" decimal(12,2) DEFAULT NULL, |
| | | "batch_id" bigint DEFAULT NULL, |
| | | "batch_code" varchar(255) DEFAULT NULL, |
| | | "reel_no" varchar(128) DEFAULT NULL, |
| | | "warehouse_id" bigint DEFAULT NULL, |
| | | "location_id" bigint DEFAULT NULL, |
| | | "area_id" bigint DEFAULT NULL, |
| | |
| | | "source_doc_id" bigint DEFAULT NULL, |
| | | "source_line_id" bigint DEFAULT NULL, |
| | | "source_doc_code" varchar(64) DEFAULT NULL, |
| | | "reel_no" varchar(128) DEFAULT NULL, |
| | | "client_id" bigint DEFAULT NULL, |
| | | "batch_code" varchar(64) DEFAULT NULL, |
| | | "item_id" bigint NOT NULL, |
| | |
| | | "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY, |
| | | "code" varchar(128) DEFAULT NULL, |
| | | "item_id" bigint DEFAULT NULL, |
| | | "reel_no" varchar(128) DEFAULT NULL, |
| | | "produce_date" timestamp DEFAULT NULL, |
| | | "expire_date" timestamp DEFAULT NULL, |
| | | "receipt_date" timestamp DEFAULT NULL, |