_8.customer_claim_adjustment_reason_codes
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| ccarc_id | int(11) | NO | PRI | auto_increment | primary key | |
| ccarc_cli_id | int(11) | NO | Client id | |||
| ccarc_cus_id | int(11) | NO | Customer id | |||
| ccarc_code | varchar(3) | NO | MUL | |||
| ccarc_desc | text | NO | ||||
| ccarc_mnemonic | text | NO | ||||
| ccarc_denial | tinyint(1) | NO | 0 | Indicates whether CARC should be denied 1:denial 0:not denial | ||
| ccarc_billing_code | int(11) | YES | ||||
| ccarc_modified | timestamp | YES | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | ||
| ccarc_created | timestamp | YES | CURRENT_TIMESTAMP |
References
| Local Column | References |
|---|