aurora_standard.stfactvd
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| orig_journal | varchar(2) | YES | ||||
| doc_no | int(11) | YES | MUL | |||
| book_ref | varchar(6) | YES | ||||
| depr_date | date | YES | ||||
| depr_amount | decimal(12,2) | YES | ||||
| depr_dept | varchar(3) | YES | ||||
| act_status | varchar(1) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |