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. account
2. accrual_period
3. accrual_plan
4. accrual_schedule
5. acct_cost_pool_tree
6. acct_fin_tree
7. acct_org_access
8. acct_org_access_hierarchy
9. acct_org_access_parent
10. address
11. adhoc_criteria_set
12. adhoc_criteria_value
13. adp_organization
14. adp_setup
15. air_detail
16. alternate
17. approval_chain
18. approval_history
19. assignment_display
20. attachment
21. bank_account
22. bank_reconciliation
23. bank_reconciliation_detail
24. batch
25. billing_info
26. billing_setup
27. billing_setup_history
28. billing_type
29. budget
30. budget_detail
31. budget_name
32. budget_organization
33. business_meeting_detail
34. business_week
35. cash_return_detail
36. cell_phone_detail
37. chain
38. change_reason
39. check_print_history
40. column_width_criteria
41. company_car_detail
42. contact_address
43. contact_address_type
44. contact_email
45. contact_email_type
46. contact_phone
47. contact_phone_type
48. cost_element
49. cost_element_account
50. cost_element_invc_fltr
51. cost_element_type_invc_fltr
52. cost_plus_invc_sect_fmt
53. cost_plus_post_detail
54. cost_pool
55. cost_pool_basis
56. cost_pool_basis_calc
57. cost_pool_calc
58. cost_pool_group
59. cost_pool_group_calc
60. cost_pool_source
61. cost_pool_source_calc
62. cost_report
63. cost_report_element
64. cost_struct
65. cost_struct_labor
66. cost_struct_odc
67. cost_struct_pool
68. cost_struct_pool_rate
69. credit_card
70. criteria_set
71. criteria_value
72. currency
73. customer
74. customer_account
75. customer_address
76. customer_assignment
77. customer_attachment
78. customer_contact
79. customer_org
80. customer_payment
81. customer_payment_included_inv
82. customer_payment_included_pmt
83. customer_payment_unapplied
84. customer_type
85. dashboard_chart
86. dashboard_list
87. dashboard_section
88. data_version
89. dbversion
90. dbversion_history
91. dbversion_patch
92. deposit
93. deposit_included
94. email_template
95. employee_type
96. employee_type_account
97. employee_type_expense_type
98. employee_type_pay_code
99. entertainment_detail
100. exp_cust_approval_status
101. expense_data
102. expense_data_allocation
103. expense_history
104. expense_invc_sect_fmt
105. expense_plan
106. expense_pm_approval_status
107. expense_project_allocation
108. expense_project_budget
109. expense_report
110. expense_report_attachment
111. expense_task_budget
112. expense_type
113. expense_type_account
114. expense_type_invc_fltr
115. expense_type_vendor_assignment
116. export_criteria_set
117. export_criteria_value
118. export_template
119. export_template_data
120. fee_cap_adjustment
121. fee_method
122. fin_document
123. fin_document_attachment
124. fin_document_detail
125. fin_document_detail_expense
126. fin_document_detail_project
127. fin_document_recurring
128. fiscal_month
129. fiscal_month_org_feature_close
130. fiscal_quarter
131. fiscal_week
132. fiscal_year
133. fiscal_year_org_close
134. fixed_price
135. fixed_price_invc_sect_fmt
136. fleet
137. fp_revenue_schedule
138. funding_cap_adjustment
139. general_alert_prefs
140. general_ledger
141. holiday
142. image_setup
143. imported_air_detail
144. imported_credit_card_expense
145. imported_expense_data
146. imported_lodging_detail
147. invc_sect_fmt
148. invc_sect_fmt_tot_grp
149. invcd_cost_plus_post_detail
150. invcd_document_expense
151. invcd_expense
152. invcd_fee_cap_adjustment
153. invcd_fixed_price
154. invcd_funding_cap_adjustment
155. invcd_prebilled_labor
156. invcd_project
157. invcd_time
158. invoice
159. invoice_addl_fmt
160. invoice_format
161. invoice_number
162. journal_cost_plus_detail
163. journal_document_expense
164. journal_entry
165. journal_expense
166. journal_fee_cap_adjustment
167. journal_fixed_price
168. journal_funding_cap_adjustment
169. journal_onetime_charge
170. journal_prebilled_labor
171. journal_time
172. labor_category
173. labor_category_account
174. labor_category_assign_rate
175. labor_category_assignment
176. labor_category_invc_fltr
177. labor_category_rate
178. labor_invc_sect_fmt
179. leave_request
180. leave_request_approval
181. list_criteria
182. list_criteria_set
183. list_criteria_value
184. location
185. lodging_allowable_detail
186. lodging_detail
187. lodging_per_diem_detail
188. manager_approval_status
189. member
190. mie_allowable_detail
191. mie_per_diem_detail
192. mileage_detail
193. mileage_rate
194. mileage_rate_set
195. note_comment_attachment
196. onetime_charge
197. onetime_charge_type
198. onetime_charge_type_account
199. onetime_charge_type_invc_fltr
200. org_access_hierarchy
201. org_access_legal_entity
202. org_access_parent
203. org_access_person
204. org_cost_pool_tree
205. org_fin_tree
206. org_tree
207. password_reset_request
208. pay_code
209. pay_code_account
210. pay_code_mapping
211. payment_method
212. payment_method_account
213. payment_term
214. payroll
215. per_diem_mie_breakdown
216. per_diem_rate
217. person
218. person_account
219. person_accrual
220. person_accrual_plan
221. person_rate
222. person_time
223. person_time_data
224. person_time_data_history
225. person_time_data_tito
226. person_time_data_tito_history
227. person_time_day
228. person_time_day_tito
229. plan_set
230. plan_set_history
231. plan_set_name
232. planned_time
233. post_history
234. posting_group
235. posting_group_source
236. prebill_invc_sect_fmt
237. prebilled_labor
238. proficiency
239. project
240. project_account
241. project_alert
242. project_alert_prefs
243. project_alert_recipient
244. project_assignment
245. project_budget_history
246. project_budget_snapshot
247. project_controller
248. project_criteria_set
249. project_criteria_value
250. project_expense_type
251. project_fee
252. project_invoice
253. project_invoice_addl_fmt
254. project_invoice_contributor
255. project_location
256. project_note
257. project_note_attachment
258. project_note_audit
259. project_note_comment
260. project_note_role
261. project_note_status
262. project_note_type
263. project_pay_code
264. project_post_history
265. project_status
266. project_type
267. project_type_account
268. project_type_exp_type_acct
269. qrtz_blob_triggers
270. qrtz_calendars
271. qrtz_cron_triggers
272. qrtz_fired_triggers
273. qrtz_job_details
274. qrtz_locks
275. qrtz_paused_trigger_grps
276. qrtz_scheduler_state
277. qrtz_simple_triggers
278. qrtz_simprop_triggers
279. qrtz_triggers
280. request_allocation
281. request_expense_data
282. request_expense_report
283. res_req_labor_category
284. res_req_location
285. res_req_planner
286. res_req_resource
287. resource_request
288. resource_request_budget
289. resource_request_history
290. resource_request_skill
291. role
292. sequence_number
293. shared_criteria_set
294. shared_criteria_value
295. skill
296. skill_assignment
297. skill_type
298. task
299. task_account
300. task_alert
301. task_alert_recipient
302. task_assignment
303. task_budget_history
304. task_budget_snapshot
305. task_depends
306. time_cust_approval_status
307. time_period
308. time_period_setup
309. udf_entity
310. udf_option
311. udf_setup
312. unanet_access
313. unanet_lock
314. unanet_properties
315. unanet_properties_history
316. vat_location
317. vendor
318. vendor_invoice
319. vendor_org
320. vendor_payment
321. vendor_payment_included
322. vendor_payment_unapplied
Views
1. access_customer_view
2. assignment_view
3. customer_invoice_activity
4. customer_payment_activity
5. customer_payment_export_view
6. expense_budget_view
7. journal_view
8. vendor_invoice_activity
9. vendor_payment_1099_view
10. vendor_payment_activity
11. vendor_payment_export_view
Other Pages
All Columns