aurora_standard.chmerapc
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| fac_no | varchar(3) | YES | ||||
| provider_no | varchar(20) | YES | MUL | |||
| remit_type | varchar(4) | YES | ||||
| pay_type_in | varchar(3) | YES | ||||
| pay_type_out | varchar(3) | YES | ||||
| era_payer | varchar(1) | YES | ||||
| era_code | varchar(10) | YES | ||||
| era_descrip | varchar(60) | YES | ||||
| era_batch_code | varchar(1) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |