aurora_standard.stiserld
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| item_code | varchar(20) | YES | MUL | |||
| warehouse_code | varchar(10) | YES | ||||
| seq_no | bigint(20) unsigned | NO | PRI | auto_increment | ||
| lot_no | varchar(20) | YES | ||||
| serial_no | varchar(20) | YES | ||||
| lot_qty | decimal(10,2) | YES | ||||
| cost | decimal(12,2) | YES | ||||
| vend_code | varchar(6) | YES | ||||
| exp_date | date | YES |