Unanet Data Model

Important!! This data model detail is provided for your convenience only. Accessing the tables directly for the purposes of reading entries is not discouraged, however, note that the Unanet Data Model is subject to change with each new version. Please do not make any changes to the database schema. The Unanet software may not function properly if you change table names, field names, data types, etc.

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. DTPROPERTIES
39. EMAIL
40. EMAIL_TEMPLATE
41. EMAIL_TYPE
42. ENTERTAINMENT_DETAIL
43. EXP_CUST_APPROVAL_STATUS
44. EXPENSE_DATA
45. EXPENSE_DATA_ALLOCATION
46. EXPENSE_HISTORY
47. EXPENSE_PM_APPROVAL_STATUS
48. EXPENSE_PROJECT_ALLOCATION
49. EXPENSE_REPORT
50. EXPENSE_TYPE
51. EXPENSE_TYPE_VENDOR_ASSIGNMENT
52. EXPORT_FIELDS_ORDER
53. EXPORT_TEMPLATE
54. EXPORT_TEMPLATE_DATA
55. FLEET
56. HOLIDAY
57. HR
58. IMPORTED_AIR_DETAIL
59. IMPORTED_CREDIT_CARD_EXPENSE
60. IMPORTED_EXPENSE_DATA
61. IMPORTED_LODGING_DETAIL
62. LODGING_DETAIL
63. MANAGER_APPROVAL_STATUS
64. MEMBER
65. MILEAGE_DETAIL
66. MILEAGE_RATES
67. MPX_MAPPING
68. PAY_CODE
69. PAY_CODE_MAPPING
70. PAYMENT_METHOD
71. PAYROLL
72. PERSON
73. PERSON_DILUTION
74. PERSON_RATE
75. PERSON_TIME
76. PERSON_TIME_DATA
77. PERSON_TIME_DATA_HISTORY
78. PHONE
79. PHONE_TYPE
80. PO
81. PO_ASSIGNMENT
82. PROJECT
83. PROJECT_ASSIGNMENT
84. PROJECT_CATEGORY
85. PROJECT_CONTACT
86. PROJECT_NOTE
87. PROJECT_NOTE_TYPE
88. PROJECT_PAY_CODE
89. PROJECT_STATUS
90. PROJECT_TYPE
91. PTD_AUDIT_TRAIL
92. REQUEST_ALLOCATION
93. REQUEST_EXPENSE_DATA
94. REQUEST_EXPENSE_REPORT
95. ROLE
96. SEQUENCE_NUMBER
97. STANDARD_MILEAGE_FROM
98. STANDARD_MILEAGE_TO
99. TASK
100. TASK_ASSIGNMENT
101. TIME_CUST_APPROVAL_STATUS
102. TIME_PERIOD
103. TIME_PERIOD_HISTORY
104. TIME_PERIOD_SETUP
105. USER_DEFINITION
106. VALID_PAYCODE
107. VALID_TIME_PERIOD
108. VAT_LOCATION
109. VENDOR
VIEWS
1. DETAIL_DATA_VIEW
2. EXPENSE_APPROVAL_VIEW
3. EXPENSE_DATA_ALLOCATION_VIEW
4. EXPENSE_DATA_VIEW
5. EXPENSE_PROJECT_VIEW
6. EXPORT_EXPENSE_VIEW
7. FINANCIAL_DATA_VIEW
8. MARGIN_VIEW
9. PERSON_CUSTOMER_VIEW
10. PROJECT_ASSIGNMENT_VIEW
11. PROJECT_CUSTOMER_VIEW
12. PROJECT_LIST_VIEW
13. RATES_VIEW
14. SEARCH_PROJECT_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-2001 Computer Strategies, Inc., All Rights Reserved.
Last revised: March 26, 2001 10:15:56 AM EST