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