aurora_standard.chmardyd
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| fac_no | varchar(3) | YES | ||||
| rev_from_date | date | YES | ||||
| age_date | date | YES | MUL | |||
| age_year | decimal(4,0) | YES | ||||
| age_month | decimal(2,0) | YES | ||||
| age_fc | varchar(2) | YES | ||||
| fc_group | char(3) | YES | ||||
| tot_rev | decimal(16,2) | YES | ||||
| avg_rev | decimal(16,2) | YES | ||||
| tot_ar | decimal(16,2) | YES | ||||
| ar_days | smallint(6) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |