aurora_standard.sticadjd
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| doc_no | int(11) | YES | MUL | |||
| page_no | int(11) | YES | ||||
| line_no | smallint(6) | YES | ||||
| item_code | varchar(20) | YES | MUL | |||
| qty_on_hand | decimal(10,2) | YES | ||||
| adj_qty | decimal(10,2) | YES | ||||
| count_qty | decimal(10,2) | YES | ||||
| l_mod_date | date | YES | ||||
| l_mod_time | varchar(8) | YES | ||||
| l_mod_id | varchar(8) | YES | ||||
| warehouse_code | varchar(10) | YES | ||||
| stock_location | varchar(12) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |