| Previous: document_type_invc_fltr | Unanet Data Model | Next: employee_type |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | email_template_key | decimal(15) | |||
| 2. | name | varchar(50) | ||||
| 3. | type | decimal(3) | ((0)) | |||
| 4. | modifiable | char(1) | ('N') | |||
| 5. | description | varchar(250) | ||||
| 6. | subject | varchar(250) | ||||
| 7. | message | varchar(2000) | ||||
| 8. | enabled | char(1) | ||||
| Table | Column | Foreign Key Name |
| po_format_options | email_template_key | fk_po_format_options9 |
| project_invoice | email_template_key | fk_project_invoice12 |
| Name | Definition |
| cc_enabled | ([enabled]='N' OR [enabled]='Y') |
| cc_modifiable | ([modifiable]='N' OR [modifiable]='Y') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_email_template | true | email_template_key | Asc |
| idx_email_template1 | true | name | Asc |
| type |