| id |
bigint(20)
|
|
|
|
| item_type |
enum('asset', 'consumable')
|
utf8mb4_unicode_ci
|
|
|
| item_id |
int(11)
|
|
|
|
| warehouse_id |
int(11)
|
|
|
 浏览不相关的值
|
| movement_date |
date
|
|
|
|
| voucher_number |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| source_destination |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| quantity_in |
decimal(12,2)
|
|
|
|
| quantity_out_actual |
decimal(12,2)
|
|
|
|
| quantity_out_other |
decimal(12,2)
|
|
|
|
| disposal_reason_id |
int(11)
|
|
|
|
| item_condition |
enum('new', 'used', 'needs_maintenance', 'damaged')
|
utf8mb4_unicode_ci
|
|
|
| balance_after |
decimal(14,2)
|
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| created_by |
int(11)
|
|
|
|
| created_at |
timestamp
|
|
|
|
