aurora_standard.styactpv
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| orig_journal | varchar(2) | YES | ||||
| doc_no | int(11) | YES | ||||
| post_no | int(11) | YES | ||||
| post_date | date | YES | ||||
| doc_date | date | YES | ||||
| ref_code | varchar(6) | YES | ||||
| doc_desc | varchar(30) | YES | ||||
| check_no | varchar(12) | YES | ||||
| pay_date | date | YES | ||||
| eop_date | date | YES | ||||
| accr_code | varchar(6) | YES | ||||
| accr_rate | decimal(18,8) | YES | ||||
| accr_hours | decimal(12,5) | YES |