aurora_standard.gary14
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| item_code | varchar(20) | YES | ||||
| calc_avg_unit_cost | decimal(12,0) | YES | ||||
| doc_no | int(11) | YES | ||||
| warehouse_code | varchar(10) | YES | ||||
| qty | decimal(10,0) | YES | ||||
| cost | decimal(12,0) | YES | ||||
| posted_amt | decimal(12,0) | YES | ||||
| correct_amt | decimal(12,0) | YES | ||||
| diff | decimal(12,0) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |