aurora_standard.stistatd
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| item_code | varchar(20) | YES | MUL | |||
| warehouse_code | varchar(10) | YES | ||||
| period | smallint(6) | YES | ||||
| yr | smallint(6) | YES | ||||
| cost | decimal(12,2) | YES | ||||
| sale | decimal(12,2) | YES | ||||
| cqty | decimal(10,2) | YES | ||||
| sqty | decimal(10,2) | YES | ||||
| usage_rate | decimal(10,2) | YES | ||||
| day_ostk | smallint(6) | YES | ||||
| num_stk_outs | smallint(6) | YES | ||||
| dup_sqty | decimal(10,2) | YES | ||||
| recurr_usage | decimal(10,2) | YES | ||||
| dup_recurr_usage | decimal(10,2) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |