| Previous: chain | Unanet Data Model | Next: check_print_history |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | change_reason_key | decimal(15) | |||
| 2. | change_reason_code | varchar(50) | ||||
| 3. | description | varchar(2000) | ||||
| 4. | active | char(1) | ('Y') | |||
| 5. | audit_trail | char(1) | ('N') | |||
| 6. | adjustment | char(1) | ('N') | |||
| Name | Definition |
| cc_cr_active | ([active]='N' OR [active]='Y') |
| cc_cr_adjustment | ([adjustment]='N' OR [adjustment]='Y') |
| cc_cr_audit_trail | ([audit_trail]='N' OR [audit_trail]='Y') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_change_reason | true | change_reason_key | Asc |