aurora_standard.stxchrtv
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| acct_no | int(11) | YES | ||||
| acct_type | varchar(15) | YES | ||||
| acct_desc | varchar(30) | YES | ||||
| acct_cat | varchar(1) | YES | ||||
| processing_seq | varchar(1) | YES | ||||
| incr_with_crdt | varchar(1) | YES | ||||
| subtotal_group | varchar(30) | YES | ||||
| department | varchar(3) | YES | ||||
| period_month | varchar(2) | YES | ||||
| period_year | varchar(4) | YES | ||||
| activity | decimal(12,2) | YES | ||||
| balance | decimal(12,2) | YES | ||||
| this_month | decimal(12,2) | YES | ||||
| budget | decimal(12,2) | YES | ||||
| fac_no | varchar(3) | YES |