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_group_submitter
19. approval_history
20. assignment_display
21. attachment
22. attachment_reference
23. bank_account
24. bank_reconciliation
25. bank_reconciliation_detail
26. batch
27. bill_by_method_type_invc_fltr
28. billing_info
29. billing_setup
30. billing_setup_history
31. billing_type
32. budget
33. budget_detail
34. budget_name
35. budget_organization
36. business_meeting_detail
37. business_week
38. cash_return_detail
39. cell_phone_detail
40. chain
41. change_reason
42. check_print_history
43. column_width_criteria
44. company_car_detail
45. contact_address
46. contact_address_type
47. contact_category
48. contact_email
49. contact_email_type
50. contact_phone
51. contact_phone_type
52. cost_element
53. cost_element_account
54. cost_element_invc_fltr
55. cost_element_type_invc_fltr
56. cost_plus_invc_sect_fmt
57. cost_plus_post_detail
58. cost_pool
59. cost_pool_basis
60. cost_pool_basis_calc
61. cost_pool_calc
62. cost_pool_group
63. cost_pool_group_calc
64. cost_pool_source
65. cost_pool_source_calc
66. cost_report
67. cost_report_element
68. cost_struct
69. cost_struct_labor
70. cost_struct_odc
71. cost_struct_pool
72. cost_struct_pool_rate
73. credit_card
74. criteria_set
75. criteria_value
76. currency
77. customer
78. customer_account
79. customer_address
80. customer_assignment
81. customer_attachment
82. customer_contact
83. customer_contact_category
84. customer_org
85. customer_payment
86. customer_payment_included_inv
87. customer_payment_included_pmt
88. customer_payment_unapplied
89. customer_type
90. dashboard_chart
91. dashboard_list
92. dashboard_section
93. data_version
94. dbversion
95. dbversion_history
96. dbversion_patch
97. deposit
98. deposit_included
99. document_type_invc_fltr
100. email_template
101. employee_type
102. employee_type_account
103. employee_type_expense_type
104. employee_type_pay_code
105. entertainment_detail
106. exp_cust_approval_status
107. expense_data
108. expense_data_allocation
109. expense_history
110. expense_invc_sect_fmt
111. expense_plan
112. expense_pm_approval_status
113. expense_project_allocation
114. expense_project_budget
115. expense_report
116. expense_report_attachment
117. expense_task_budget
118. expense_type
119. expense_type_account
120. expense_type_invc_fltr
121. expense_type_vendor_assignment
122. export_criteria_set
123. export_criteria_value
124. export_template
125. export_template_data
126. fee_cap_adjustment
127. fee_method
128. fin_document
129. fin_document_approval
130. fin_document_attachment
131. fin_document_det_proj_expense
132. fin_document_det_proj_item
133. fin_document_det_proj_labor
134. fin_document_detail
135. fin_document_detail_expense
136. fin_document_detail_item
137. fin_document_detail_labor
138. fin_document_detail_po
139. fin_document_recurring
140. fiscal_month
141. fiscal_month_org_feature_close
142. fiscal_quarter
143. fiscal_week
144. fiscal_year
145. fiscal_year_org_close
146. fixed_price
147. fixed_price_invc_sect_fmt
148. fleet
149. fp_revenue_schedule
150. funding_cap_adjustment
151. general_alert_prefs
152. general_ledger
153. holiday
154. image_setup
155. imported_air_detail
156. imported_credit_card_expense
157. imported_expense_data
158. imported_lodging_detail
159. invc_sect_fmt
160. invc_sect_fmt_tot_grp
161. invcd_cost_plus_post_detail
162. invcd_document_expense
163. invcd_document_item
164. invcd_document_labor
165. invcd_expense
166. invcd_fee_cap_adjustment
167. invcd_fixed_price
168. invcd_funding_cap_adjustment
169. invcd_prebilled_labor
170. invcd_project
171. invcd_time
172. invoice
173. invoice_addl_fmt
174. invoice_format
175. invoice_number
176. item
177. item_uom
178. item_uom_rate
179. journal_cost_plus_detail
180. journal_document_expense
181. journal_document_item
182. journal_document_labor
183. journal_entry
184. journal_expense
185. journal_fee_cap_adjustment
186. journal_fixed_price
187. journal_funding_cap_adjustment
188. journal_onetime_charge
189. journal_prebilled_labor
190. journal_time
191. labor_category
192. labor_category_account
193. labor_category_assign_rate
194. labor_category_assignment
195. labor_category_invc_fltr
196. labor_category_rate
197. labor_invc_sect_fmt
198. leave_request
199. leave_request_approval
200. list_criteria
201. list_criteria_set
202. list_criteria_value
203. location
204. lodging_allowable_detail
205. lodging_detail
206. lodging_per_diem_detail
207. manager_approval_status
208. member
209. mie_allowable_detail
210. mie_per_diem_detail
211. mileage_detail
212. mileage_rate
213. mileage_rate_set
214. note_comment_attachment
215. onetime_charge
216. onetime_charge_type
217. onetime_charge_type_account
218. onetime_charge_type_invc_fltr
219. org_access_hierarchy
220. org_access_legal_entity
221. org_access_parent
222. org_access_person
223. org_cost_pool_tree
224. org_fin_tree
225. org_tree
226. password_reset_request
227. pay_code
228. pay_code_account
229. pay_code_mapping
230. pay_code_rate
231. payment_method
232. payment_method_account
233. payment_term
234. payroll
235. per_diem_mie_breakdown
236. per_diem_rate
237. person
238. person_account
239. person_accrual
240. person_accrual_plan
241. person_rate
242. person_time
243. person_time_data
244. person_time_data_history
245. person_time_data_tito
246. person_time_data_tito_history
247. person_time_day
248. person_time_day_tito
249. plan_set
250. plan_set_history
251. plan_set_name
252. planned_time
253. po_attachment_reference
254. po_cust_approval_status
255. po_expense_assignment
256. po_expense_line
257. po_expense_line_attachment_ref
258. po_expense_line_descriptor
259. po_format
260. po_format_options
261. po_item_line
262. po_item_line_attachment_ref
263. po_item_line_descriptor
264. po_labor_assignment
265. po_labor_line
266. po_labor_line_attachment_ref
267. po_labor_line_descriptor
268. po_pm_approval_status
269. po_summary_attachment_ref
270. post_history
271. posting_group
272. posting_group_source
273. pr_attachment_reference
274. pr_cust_approval_status
275. pr_expense_line
276. pr_expense_line_attachment_ref
277. pr_expense_line_descriptor
278. pr_item_line
279. pr_item_line_attachment_ref
280. pr_item_line_descriptor
281. pr_labor_line
282. pr_labor_line_attachment_ref
283. pr_labor_line_descriptor
284. pr_pm_approval_status
285. pr_summary_attachment_ref
286. prebill_invc_sect_fmt
287. prebilled_labor
288. proficiency
289. project
290. project_account
291. project_alert
292. project_alert_prefs
293. project_alert_recipient
294. project_assignment
295. project_budget_history
296. project_budget_snapshot
297. project_controller
298. project_criteria_set
299. project_criteria_value
300. project_expense_type
301. project_fee
302. project_invoice
303. project_invoice_addl_fmt
304. project_invoice_contributor
305. project_item
306. project_item_uom_rate
307. project_location
308. project_note
309. project_note_attachment
310. project_note_audit
311. project_note_comment
312. project_note_role
313. project_note_status
314. project_note_type
315. project_pay_code
316. project_post_history
317. project_restrict_access
318. project_status
319. project_type
320. project_type_account
321. project_type_exp_type_acct
322. purchase_order
323. purchase_order_approval
324. purchase_requisition
325. purchase_requisition_approval
326. qrtz_blob_triggers
327. qrtz_calendars
328. qrtz_cron_triggers
329. qrtz_fired_triggers
330. qrtz_job_details
331. qrtz_locks
332. qrtz_paused_trigger_grps
333. qrtz_scheduler_state
334. qrtz_simple_triggers
335. qrtz_simprop_triggers
336. qrtz_triggers
337. request_allocation
338. request_expense_data
339. request_expense_report
340. res_req_labor_category
341. res_req_location
342. res_req_planner
343. res_req_resource
344. resource_request
345. resource_request_budget
346. resource_request_history
347. resource_request_skill
348. role
349. section_status
350. sequence_number
351. shared_criteria_set
352. shared_criteria_value
353. shared_document
354. skill
355. skill_assignment
356. skill_type
357. task
358. task_account
359. task_alert
360. task_alert_recipient
361. task_assignment
362. task_budget_history
363. task_budget_snapshot
364. task_depends
365. time_cust_approval_status
366. time_period
367. time_period_setup
368. udf_entity
369. udf_option
370. udf_setup
371. unanet_access
372. unanet_lock
373. unanet_properties
374. unanet_properties_history
375. unit_of_measure
376. vat_location
377. vendor
378. vendor_invoice
379. vendor_org
380. vendor_payment
381. vendor_payment_included
382. vendor_payment_unapplied
383. vi_cust_approval_status
384. vi_funding_cap_adjustment
385. vi_included_expense
386. vi_included_time
387. vi_pm_approval_status
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. po_consol_all_view
9. po_consol_approved_view
10. po_consol_view
11. po_expnse_consol_all_view
12. po_expnse_consol_approved_view
13. po_expnse_consol_view
14. po_item_consol_all_view
15. po_item_consol_approved_view
16. po_item_consol_view
17. po_labor_consol_all_view
18. po_labor_consol_approved_view
19. po_labor_consol_view
20. pr_consol_all_view
21. pr_consol_approved_view
22. pr_expnse_consol_all_view
23. pr_expnse_consol_approved_view
24. pr_item_consol_all_view
25. pr_item_consol_approved_view
26. pr_labor_consol_all_view
27. pr_labor_consol_approved_view
28. project_approval_view
29. project_open_access_view
30. vendor_invoice_activity
31. vendor_payment_1099_view
32. vendor_payment_activity
33. vendor_payment_export_view
Other Pages
All Columns