Unanet Data Model

TABLES
1. ADDRESS
2. ADDRESS_TYPE
3. ADP_ORGANIZATION
4. ADP_SETUP
5. AIR_DETAIL
6. ALTERNATE
7. APPROVAL_CHAIN
8. APPROVAL_HISTORY
9. APPROVER
10. ATTACHMENT
11. BATCH
12. BILLING_INFO
13. BUSINESS_MEETING_DETAIL
14. CASH_RETURN_DETAIL
15. CATEGORY_ASSIGNMENT
16. CELL_PHONE_DETAIL
17. CHAIN
18. COMPANY_CAR_DETAIL
19. CONTACT
20. CONTACT_ADDRESS
21. CONTACT_EMAIL
22. CONTACT_PHONE
23. CONTACT_TYPE
24. CREDIT_CARD
25. CREDIT_CARD_IMPORT
26. CURRENCY
27. CUSTOMER
28. CUSTOMER_ADDRESS
29. CUSTOMER_APPROVER
30. CUSTOMER_ASSIGNMENT
31. CUSTOMER_CONTACT
32. CUSTOMER_EMAIL
33. CUSTOMER_PHONE
34. CUSTOMER_TYPE
35. DBVERSION
36. DEFAULT_TIME
37. DEFAULT_TIME_DATA
38. EMAIL
39. EMAIL_TEMPLATE
40. EMAIL_TYPE
41. ENTERTAINMENT_DETAIL
42. EXP_CUST_APPROVAL_STATUS
43. EXPENSE_DATA
44. EXPENSE_DATA_ALLOCATION
45. EXPENSE_HISTORY
46. EXPENSE_PM_APPROVAL_STATUS
47. EXPENSE_PROJECT_ALLOCATION
48. EXPENSE_REPORT
49. EXPENSE_TYPE
50. EXPENSE_TYPE_VENDOR_ASSIGNMENT
51. FLEET
52. HISTORY_ALLOCATION
53. HISTORY_APPROVAL_HISTORY
54. HISTORY_EXPENSE_DATA
55. HISTORY_EXPENSE_REPORT
56. HOLIDAY
57. HR
58. LODGING_DETAIL
59. MANAGER_APPROVAL_STATUS
60. MEMBER
61. MILEAGE_DETAIL
62. MILEAGE_RATES
63. MPX_MAPPING
64. PAY_CODE
65. PAYMENT_METHOD
66. PAYROLL
67. PERSON
68. PERSON_TIME
69. PERSON_TIME_DATA
70. PERSON_TIME_DATA_HISTORY
71. PHONE
72. PHONE_TYPE
73. PO
74. PO_ASSIGNMENT
75. PROJECT
76. PROJECT_ASSIGNMENT
77. PROJECT_CATEGORY
78. PROJECT_CONTACT
79. PROJECT_NOTE
80. PROJECT_NOTE_TYPE
81. PROJECT_STATUS
82. PROJECT_TYPE
83. PTD_AUDIT_TRAIL
84. REQUEST_ALLOCATION
85. REQUEST_EXPENSE_DATA
86. REQUEST_EXPENSE_REPORT
87. ROLE
88. SEQUENCE_NUMBER
89. STANDARD_MILEAGE_FROM
90. STANDARD_MILEAGE_TO
91. TASK
92. TASK_ASSIGNMENT
93. TIME_CUST_APPROVAL_STATUS
94. TIME_PERIOD
95. TIME_PERIOD_HISTORY
96. TIME_PERIOD_SETUP
97. USER_DEFINITION
98. VALID_PAYCODE
99. VALID_TIME_PERIOD
100. VENDOR
101. XUNA_IN_TIME
VIEWS
1. DETAIL_DATA_VIEW
2. EXPENSE_APPROVAL_VIEW
3. EXPENSE_DATA_VIEW
4. EXPENSE_PROJECT_VIEW
5. EXPORT_EXPENSE_VIEW
6. FINANCIAL_DATA_VIEW
7. MARGIN_VIEW
8. PERSON_CUSTOMER_VIEW
9. PROJECT_ASSIGNMENT_VIEW
10. PROJECT_LIST_VIEW
11. RATES_VIEW
12. SEARCH_PROJECT_VIEW
13. TEST
14. TIME_DATA_VIEW
15. TIMESHEET_DATA
16. TIMESHEET_HOURS_VIEW
17. TIMESHEET_STATUS_VIEW
18. VENDOR_ASSIGNED_VIEW

Show all Foreign Keys

Show all Check Constraints

Show all Indexes

Copyright 1998, 1999 Computer Strategies, Inc., All Rights Reserved.
Last revised: May 25, 2000 11:25:17 AM EDT