| Previous: customer_attachment | Unanet Data Model | Next: customer_contact_category |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | customer_contact_key | decimal(15) | |||
| 2. | customer_key | decimal(15) | customer | fk_customer_contact1 | ||
| 3. | first_name | varchar(50) | ||||
| 4. | last_name | varchar(50) | ||||
| 5. | middle_initial | char(1) | ||||
| 6. | suffix | varchar(10) | ||||
| 7. | salutation | varchar(120) | ||||
| 8. | title | varchar(240) | ||||
| 9. | active | char(1) | ('Y') | |||
| 10. | default_bill_to | char(1) | ('N') | |||
| 11. | default_ship_to | char(1) | ('N') | |||
| 12. | default_remit_to | char(1) | ('N') | |||
| 13. | comments | varchar(2000) | ||||
| 14. | created_timestamp | datetime | ||||
| 15. | created_by | decimal(15) | person | fk_customer_contact2 | ||
| 16. | last_updated_timestamp | datetime | ||||
| 17. | last_updated_by | decimal(15) | person | fk_customer_contact3 | ||
| 18. | user01 | varchar(128) | ||||
| 19. | user02 | varchar(128) | ||||
| 20. | user03 | varchar(128) | ||||
| 21. | user04 | varchar(128) | ||||
| 22. | user05 | varchar(128) | ||||
| 23. | user06 | varchar(128) | ||||
| 24. | user07 | varchar(128) | ||||
| 25. | user08 | varchar(128) | ||||
| 26. | user09 | varchar(128) | ||||
| 27. | user10 | varchar(128) | ||||
| 28. | user11 | varchar(128) | ||||
| 29. | user12 | varchar(128) | ||||
| 30. | user13 | varchar(128) | ||||
| 31. | user14 | varchar(128) | ||||
| 32. | user15 | varchar(128) | ||||
| 33. | user16 | varchar(128) | ||||
| 34. | user17 | varchar(128) | ||||
| 35. | user18 | varchar(128) | ||||
| 36. | user19 | varchar(128) | ||||
| 37. | user20 | varchar(128) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| customer_key | customer | customer_key | fk_customer_contact1 |
| created_by | person | person_key | fk_customer_contact2 |
| last_updated_by | person | person_key | fk_customer_contact3 |
| Table | Column | Foreign Key Name |
| contact_address | customer_contact_key | fk_contact_address1 |
| contact_email | customer_contact_key | fk_contact_email1 |
| contact_phone | customer_contact_key | fk_contact_phone1 |
| customer_contact_category | customer_contact_key | fk_customer_contact_category1 |
| po_format_options | bill_to_contact_key | fk_po_format_options6 |
| po_format_options | remit_to_contact_key | fk_po_format_options8 |
| po_format_options | ship_to_contact_key | fk_po_format_options7 |
| project_invoice | bill_to_contact_key | fk_project_invoice7 |
| project_invoice | remit_to_contact_key | fk_project_invoice9 |
| project_invoice | ship_to_contact_key | fk_project_invoice11 |
| Name | Definition |
| cc_cust_contact_active | ([active]='N' OR [active]='Y') |
| cc_cust_contact_bill | ([default_bill_to]='N' OR [default_bill_to]='Y') |
| cc_cust_contact_remit | ([default_remit_to]='N' OR [default_remit_to]='Y') |
| cc_cust_contact_ship | ([default_ship_to]='N' OR [default_ship_to]='Y') |
| cc_cust_created_timestamp | ([created_timestamp]>='1900-01-01' AND [created_timestamp]<='2099-12-31') |
| cc_cust_last_updated_timestamp | ([last_updated_timestamp]>='1900-01-01' AND [last_updated_timestamp]<='2099-12-31') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_customer_contact | true | customer_contact_key | Asc |
| idx_customer_contact1 | false | customer_key | Asc |