aurora_standard.item1
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| item_code | varchar(20) | YES | ||||
| doc_no | int(11) | YES | ||||
| cost | decimal(12,2) | YES | ||||
| ordr_qty | decimal(12,2) | YES | ||||
| line_no | int(11) | YES | ||||
| unit_cost | decimal(12,2) | YES | ||||
| charge_1 | decimal(12,2) | YES | ||||
| item_class | varchar(6) | YES | ||||
| calc_charge | decimal(12,2) | YES | ||||
| ic | varchar(1) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |