aurora_standard.stpinchd
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| orig_journal | varchar(2) | YES | ||||
| doc_no | int(11) | YES | ||||
| old_inv_no | varchar(15) | YES | ||||
| new_inv_no | varchar(15) | YES | ||||
| old_inv_desc | varchar(30) | YES | ||||
| new_inv_desc | varchar(30) | YES | ||||
| old_po_no | varchar(10) | YES | ||||
| new_po_no | varchar(10) | YES | ||||
| input_by | int(11) | YES | ||||
| date_changed | date | YES | ||||
| time_changed | varchar(5) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |