All Columns

Column Name	Table/View Name	Data Type	Default Value	Table or View
blob_data	qrtz_blob_triggers	blob		Table
bool_prop_1	qrtz_simprop_triggers	varchar(1)		Table
bool_prop_2	qrtz_simprop_triggers	varchar(1)		Table
calendar	qrtz_calendars	blob		Table
calendar_name	qrtz_calendars	varchar(200)		Table
	qrtz_triggers	varchar(200)		Table
checkin_interval	qrtz_scheduler_state	bigint		Table
cron_expression	qrtz_cron_triggers	varchar(120)		Table
dec_prop_1	qrtz_simprop_triggers	decimal(13,4)		Table
dec_prop_2	qrtz_simprop_triggers	decimal(13,4)		Table
description	qrtz_job_details	varchar(250)		Table
	qrtz_triggers	varchar(250)		Table
end_time	qrtz_triggers	bigint		Table
entry_id	qrtz_fired_triggers	varchar(95)		Table
fired_time	qrtz_fired_triggers	bigint		Table
instance_name	qrtz_fired_triggers	varchar(200)		Table
	qrtz_scheduler_state	varchar(200)		Table
int_prop_1	qrtz_simprop_triggers	integer		Table
int_prop_2	qrtz_simprop_triggers	integer		Table
is_durable	qrtz_job_details	varchar(1)		Table
is_nonconcurrent	qrtz_fired_triggers	varchar(1)		Table
	qrtz_job_details	varchar(1)		Table
is_update_data	qrtz_job_details	varchar(1)		Table
job_class_name	qrtz_job_details	varchar(250)		Table
job_data	qrtz_job_details	blob		Table
	qrtz_triggers	blob		Table
job_group	qrtz_fired_triggers	varchar(200)		Table
	qrtz_job_details	varchar(200)		Table
	qrtz_triggers	varchar(200)		Table
job_name	qrtz_fired_triggers	varchar(200)		Table
	qrtz_job_details	varchar(200)		Table
	qrtz_triggers	varchar(200)		Table
last_checkin_time	qrtz_scheduler_state	bigint		Table
lock_name	qrtz_locks	varchar(40)		Table
long_prop_1	qrtz_simprop_triggers	bigint		Table
long_prop_2	qrtz_simprop_triggers	bigint		Table
misfire_instr	qrtz_triggers	smallint		Table
next_fire_time	qrtz_triggers	bigint		Table
prev_fire_time	qrtz_triggers	bigint		Table
priority	qrtz_fired_triggers	integer		Table
	qrtz_triggers	integer		Table
repeat_count	qrtz_simple_triggers	bigint		Table
repeat_interval	qrtz_simple_triggers	bigint		Table
requests_recovery	qrtz_fired_triggers	varchar(1)		Table
	qrtz_job_details	varchar(1)		Table
sched_name	qrtz_blob_triggers	varchar(120)		Table
	qrtz_calendars	varchar(120)		Table
	qrtz_cron_triggers	varchar(120)		Table
	qrtz_fired_triggers	varchar(120)		Table
	qrtz_job_details	varchar(120)		Table
	qrtz_locks	varchar(120)		Table
	qrtz_paused_trigger_grps	varchar(120)		Table
	qrtz_scheduler_state	varchar(120)		Table
	qrtz_simple_triggers	varchar(120)		Table
	qrtz_simprop_triggers	varchar(120)		Table
	qrtz_triggers	varchar(120)		Table
start_time	qrtz_triggers	bigint		Table
state	qrtz_fired_triggers	varchar(16)		Table
str_prop_1	qrtz_simprop_triggers	varchar(512)		Table
str_prop_2	qrtz_simprop_triggers	varchar(512)		Table
str_prop_3	qrtz_simprop_triggers	varchar(512)		Table
times_triggered	qrtz_simple_triggers	bigint		Table
time_zone_id	qrtz_cron_triggers	varchar(80)		Table
trigger_group	qrtz_blob_triggers	varchar(200)		Table
	qrtz_cron_triggers	varchar(200)		Table
	qrtz_fired_triggers	varchar(200)		Table
	qrtz_paused_trigger_grps	varchar(200)		Table
	qrtz_simple_triggers	varchar(200)		Table
	qrtz_simprop_triggers	varchar(200)		Table
	qrtz_triggers	varchar(200)		Table
trigger_name	qrtz_blob_triggers	varchar(200)		Table
	qrtz_cron_triggers	varchar(200)		Table
	qrtz_fired_triggers	varchar(200)		Table
	qrtz_simple_triggers	varchar(200)		Table
	qrtz_simprop_triggers	varchar(200)		Table
	qrtz_triggers	varchar(200)		Table
trigger_state	qrtz_triggers	varchar(16)		Table
trigger_type	qrtz_triggers	varchar(8)		Table
access_type	org_access_person	decimal(1)		Table
account_code	account	varchar(25)		Table
	journal_view	varchar(25)		View
	task	varchar(64)		Table
account_key	account	decimal(15)		Table
	acct_org_access	decimal(15)		Table
	acct_org_access_hierarchy	decimal(15)		Table
	acct_org_access_parent	decimal(15)		Table
	bank_account	decimal(15)		Table
	budget_detail	decimal(15)		Table
	cost_element_account	decimal(15)		Table
	cost_pool_basis	decimal(15)		Table
	cost_pool_basis_calc	decimal(15)		Table
	cost_pool_source	decimal(15)		Table
	cost_pool_source_calc	decimal(15)		Table
	customer_account	decimal(15)		Table
	customer_payment	decimal(15)		Table
	customer_payment_unapplied	decimal(15)		Table
	deposit	decimal(15)		Table
	employee_type_account	decimal(15)		Table
	expense_type_account	decimal(15)		Table
	fin_document_detail	decimal(15)		Table
	general_ledger	decimal(15)		Table
	journal_cost_plus_detail	decimal(15)		Table
	journal_document_expense	decimal(15)		Table
	journal_expense	decimal(15)		Table
	journal_fee_cap_adjustment	decimal(15)		Table
	journal_fixed_price	decimal(15)		Table
	journal_funding_cap_adjustment	decimal(15)		Table
	journal_onetime_charge	decimal(15)		Table
	journal_prebilled_labor	decimal(15)		Table
	journal_time	decimal(15)		Table
	journal_view	decimal(15)		View
	labor_category_account	decimal(15)		Table
	onetime_charge_type_account	decimal(15)		Table
	pay_code_account	decimal(15)		Table
	payment_method_account	decimal(15)		Table
	person_account	decimal(15)		Table
	posting_group_source	decimal(15)		Table
	project_account	decimal(15)		Table
	project_type_account	decimal(15)		Table
	project_type_exp_type_acct	decimal(15)		Table
	task_account	decimal(15)		Table
	vendor_invoice	decimal(15)		Table
	vendor_payment	decimal(15)		Table
	vendor_payment_1099_view	decimal(15)		View
	vendor_payment_unapplied	decimal(15)		Table
account_number	billing_info	varchar(255)		Table
	cost_element	varchar(128)		Table
	customer	varchar(25)		Table
	expense_type	varchar(2000)		Table
	labor_category	varchar(50)		Table
	project	varchar(128)		Table
	request_expense_data	varchar(2000)		Table
	vendor_org	varchar(40)		Table
account_source	posting_group_source	char(1)	('0')	Table
accrual_hours	accrual_schedule	decimal(15,12)		Table
accrual_period_key	accrual_period	decimal(15)		Table
	person_accrual	decimal(15)		Table
accrual_plan	accrual_plan	varchar(50)		Table
accrual_plan_key	accrual_period	decimal(15)		Table
	accrual_plan	decimal(15)		Table
	accrual_schedule	decimal(15)		Table
	person_accrual	decimal(15)		Table
	person_accrual_plan	decimal(15)		Table
accrual_schedule_key	accrual_schedule	decimal(15)		Table
accrued_hours	person_accrual	decimal(17,12)		Table
acknowledge_timestamp	unanet_access	timestamp		Table
action_date	approval_history	timestamp		Table
	project_note	timestamp		Table
	project_note_audit	timestamp		Table
active	account	char(1)		Table
	accrual_plan	char(1)	('Y')	Table
	bank_account	char(1)		Table
	budget_name	char(1)	('Y')	Table
	change_reason	char(1)	('Y')	Table
	contact_category	char(1)	('Y')	Table
	cost_pool	char(1)	('Y')	Table
	cost_pool_group	char(1)		Table
	cost_struct	char(1)	('Y')	Table
	customer	char(1)	('Y')	Table
	customer_contact	char(1)	('Y')	Table
	customer_org	char(1)	('Y')	Table
	employee_type	char(1)		Table
	fee_method	char(1)	('Y')	Table
	image_setup	char(1)	('Y')	Table
	invoice_format	char(1)	('N')	Table
	invoice_number	char(1)		Table
	labor_category	char(1)	('Y')	Table
	location	char(1)	('Y')	Table
	onetime_charge_type	char(1)		Table
	pay_code	char(1)		Table
	payment_method	char(1)	('Y')	Table
	payment_term	char(1)		Table
	person	char(1)		Table
	plan_set	char(1)	('N')	Table
	plan_set_name	char(1)	('N')	Table
	posting_group	char(1)	('Y')	Table
	project_type	char(1)	('Y')	Table
	task	char(1)		Table
	udf_setup	char(1)	('N')	Table
	vat_location	char(1)	('Y')	Table
	vendor_org	char(1)	('Y')	Table
activity	entertainment_detail	varchar(100)		Table
actual_rate	cost_struct_pool_rate	decimal(15,12)	((0))	Table
actuals_formula	cost_report_element	varchar(3500)		Table
	fee_method	varchar(3500)		Table
actuals_through_date	post_history	timestamp		Table
additional_pay	person_time_data	decimal(15,5)	((0))	Table
address_key	address	decimal(15)		Table
	contact_address	decimal(15)		Table
	customer_address	decimal(15)		Table
adhoc_criteria_set_key	adhoc_criteria_set	decimal(15)		Table
	adhoc_criteria_value	decimal(15)		Table
adjusted_head	person_time_data	char(1)	('Y')	Table
	person_time_day	char(1)	('N')	Table
adjusted_number	person_time_data	decimal(15)		Table
	person_time_day	decimal(15)		Table
adjustment	change_reason	char(1)	('N')	Table
adjustment_date	person_time	timestamp		Table
adjustment_reason	person_time_data	varchar(2000)		Table
	person_time_day	varchar(2000)		Table
adjustment_status	approval_history	varchar(25)		Table
	person_time	varchar(25)		Table
admin_only_access	time_period	char(1)	('N')	Table
administrative	project_type	char(1)		Table
adp_code	adp_organization	varchar(16)		Table
	adp_setup	varchar(32)		Table
adp_setup_key	adp_setup	decimal(15)		Table
adp_type	adp_setup	varchar(32)		Table
alert_key	project_alert	decimal(15)		Table
	project_alert_recipient	decimal(15)		Table
	task_alert	decimal(15)		Table
	task_alert_recipient	decimal(15)		Table
alert_type	project_alert	decimal(2)		Table
	task_alert	decimal(2)		Table
alertable	task	char(1)	('N')	Table
alignment	export_template_data	varchar(10)	('LEFT')	Table
alloc_amount	cost_pool_basis_calc	decimal(18,2)		Table
allocation	expense_data_allocation	decimal(6,3)		Table
	expense_project_allocation	decimal(6,3)		Table
	request_allocation	decimal(6,3)		Table
allow_for_non_employee	payment_method	char(1)	('N')	Table
allow_new_timesheets	time_period	char(1)	('Y')	Table
allow_self_plan	project	char(1)	('C')	Table
allow_user_adjustments	time_period	char(1)	('N')	Table
	time_period_setup	char(1)	('N')	Table
alt_text	image_setup	varchar(128)		Table
alternate_for_key	approval_history	decimal(15)		Table
	leave_request_approval	decimal(15)		Table
	resource_request_history	decimal(15)		Table
alternate_key	alternate	decimal(15)		Table
amount	budget_detail	decimal(18,2)		Table
	cost_pool_basis	decimal(18,2)		Table
	cost_pool_basis_calc	decimal(18,2)		Table
	cost_pool_source_calc	decimal(18,2)		Table
	expense_budget_view	decimal(18,3)		View
	expense_data	decimal(18,3)		Table
	expense_data_allocation	decimal(18,3)		Table
	expense_plan	decimal(18,3)		Table
	expense_project_budget	decimal(18,3)		Table
	expense_report	decimal(18,3)		Table
	expense_task_budget	decimal(18,3)		Table
	fin_document_detail_expense	decimal(18,2)		Table
	fixed_price	decimal(18,2)		Table
	fp_revenue_schedule	decimal(18,2)		Table
	imported_expense_data	decimal(18,3)		Table
	invoice	decimal(18,2)		Table
	journal_cost_plus_detail	decimal(18,2)		Table
	journal_document_expense	decimal(18,2)		Table
	journal_expense	decimal(18,2)		Table
	journal_fee_cap_adjustment	decimal(18,2)		Table
	journal_fixed_price	decimal(18,2)		Table
	journal_funding_cap_adjustment	decimal(18,2)		Table
	journal_onetime_charge	decimal(18,2)		Table
	journal_prebilled_labor	decimal(18,2)		Table
	journal_time	decimal(18,2)		Table
	journal_view	decimal(18,2)		View
	onetime_charge	decimal(18,2)		Table
	prebilled_labor	decimal(18,3)		Table
	request_expense_data	decimal(15,3)		Table
	request_expense_report	decimal(18,3)		Table
amount_currency_code	imported_expense_data	varchar(25)		Table
ap_payment_type	payment_method	char(1)		Table
applied	customer_invoice_activity	decimal(38,2)		View
	customer_payment_activity	decimal(38,2)		View
	vendor_invoice_activity	decimal(38,2)		View
	vendor_payment_activity	decimal(38,2)		View
applied_amount	customer_payment_included_inv	decimal(18,2)	((0))	Table
	customer_payment_included_pmt	decimal(18,2)	((0))	Table
	vendor_payment_included	decimal(18,2)	((0))	Table
applied_fin_document_key	customer_payment	decimal(15)		Table
	vendor_payment	decimal(15)		Table
applied_general_ledger_key	customer_payment_included_inv	decimal(15)		Table
	customer_payment_included_pmt	decimal(15)		Table
	vendor_payment_included	decimal(15)		Table
approval_history_key	approval_history	decimal(15)		Table
approved	approval_history	char(1)		Table
	exp_cust_approval_status	char(1)		Table
	expense_pm_approval_status	char(1)		Table
	manager_approval_status	char(1)		Table
	time_cust_approval_status	char(1)		Table
ar_balance	invoice_format	char(1)	('N')	Table
ar_payment_type	payment_method	char(1)		Table
area_id	adhoc_criteria_set	varchar(50)		Table
assignable	role	char(1)		Table
assignee	project_note_audit	decimal(15)		Table
assignee_person_key	project_note	decimal(15)		Table
assignment_email	person	char(1)	('Y')	Table
assignment_flag	project	char(1)		Table
assignment_key	assignment_view	decimal(15)		View
assignment_type	assignment_view	integer		View
attachment_data	attachment	blob		Table
attachment_key	attachment	decimal(15)		Table
	bank_account	decimal(15)		Table
	customer_attachment	decimal(15)		Table
	expense_report_attachment	decimal(15)		Table
	fin_document_attachment	decimal(15)		Table
	image_setup	decimal(15)		Table
	note_comment_attachment	decimal(15)		Table
	project_note_attachment	decimal(15)		Table
attachment_length	attachment	decimal(15)		Table
attachment_mime_type	attachment	varchar(255)		Table
attachment_name	attachment	varchar(255)		Table
attendees	business_meeting_detail	integer		Table
audit_trail	change_reason	char(1)	('N')	Table
balance	customer_payment_activity	decimal(38,2)		View
	vendor_payment_activity	decimal(38,2)		View
bank_account_key	bank_account	decimal(15)		Table
	bank_reconciliation	decimal(15)		Table
	check_print_history	decimal(15)		Table
	customer_payment	decimal(15)		Table
	deposit	decimal(15)		Table
	vendor_payment	decimal(15)		Table
bank_account_number	bank_account	varchar(30)		Table
bank_name	bank_account	varchar(50)		Table
bank_reconciliation_key	bank_reconciliation	decimal(15)		Table
	bank_reconciliation_detail	decimal(15)		Table
bank_routing_number	bank_account	varchar(9)		Table
basis_method	cost_pool	char(1)		Table
batch_key	batch	decimal(15)		Table
	person_time_data	decimal(15)		Table
batch_number	batch	decimal(15)		Table
batch_timestamp	batch	timestamp		Table
bcc_email	project_invoice	varchar(255)		Table
begin_date	account	timestamp		Table
	accrual_period	timestamp		Table
	accrual_plan	timestamp		Table
	assignment_view	timestamp		View
	customer	timestamp		Table
	expense_budget_view	timestamp		View
	expense_plan	timestamp	('01/01/1900')	Table
	expense_project_budget	timestamp	('01/01/1900')	Table
	expense_task_budget	timestamp	('01/01/1900')	Table
	fiscal_month	timestamp		Table
	fiscal_quarter	timestamp		Table
	fiscal_week	timestamp		Table
	fiscal_year	timestamp		Table
	labor_category_assign_rate	timestamp		Table
	labor_category_rate	timestamp		Table
	leave_request	timestamp		Table
	mileage_rate	timestamp		Table
	pay_code_rate	timestamp		Table
	person_accrual_plan	timestamp		Table
	person_rate	timestamp		Table
	person_time	timestamp		Table
	planned_time	timestamp		Table
	project_assignment	timestamp	('01/01/1900')	Table
	resource_request	timestamp		Table
	resource_request_budget	timestamp		Table
	task_assignment	timestamp	('01/01/1900')	Table
	time_period	timestamp		Table
begin_date1	time_period_setup	timestamp		Table
begin_date2	accrual_plan	timestamp		Table
	time_period_setup	timestamp		Table
beginning_balance	bank_reconciliation	decimal(18,3)		Table
bill_amount	cost_plus_post_detail	decimal(18,2)		Table
	expense_data_allocation	decimal(18,3)		Table
	fee_cap_adjustment	decimal(18,2)		Table
	fin_document_detail_expense	decimal(18,2)		Table
	funding_cap_adjustment	decimal(18,2)		Table
bill_customer	person_time_data	decimal(15)		Table
	project_assignment	decimal(15)		Table
	task_assignment	decimal(15)		Table
bill_customer_code	assignment_view	varchar(25)		View
bill_customer_key	assignment_view	decimal(15)		View
bill_date	fixed_price	timestamp		Table
	prebilled_labor	timestamp		Table
bill_pool_rate_type	billing_setup	char(1)		Table
	billing_setup_history	char(1)		Table
	post_history	char(1)		Table
bill_rate	assignment_view	decimal(15,5)		View
	labor_category_assign_rate	decimal(15,5)		Table
	labor_category_rate	decimal(15,5)		Table
	person_rate	decimal(15,5)		Table
	person_time_data	decimal(15,5)		Table
	planned_time	decimal(15,5)		Table
	project_assignment	decimal(15,5)		Table
	task_assignment	decimal(15,5)		Table
bill_rate_source	assignment_view	char(1)		View
	planned_time	char(1)	('P')	Table
	project	char(1)	('P')	Table
	project_assignment	char(1)	('P')	Table
	task_assignment	char(1)	('P')	Table
bill_to_address_key	project_invoice	decimal(15)		Table
bill_to_city	invoice	varchar(60)		Table
bill_to_contact_key	project_invoice	decimal(15)		Table
bill_to_country	invoice	varchar(60)		Table
bill_to_first_name	invoice	varchar(50)		Table
bill_to_last_name	invoice	varchar(50)		Table
bill_to_middle_initial	invoice	char(1)		Table
bill_to_postal_code	invoice	varchar(16)		Table
bill_to_state_province	invoice	varchar(60)		Table
bill_to_street1	invoice	varchar(255)		Table
bill_to_street2	invoice	varchar(255)		Table
bill_to_street3	invoice	varchar(2000)		Table
bill_to_suffix	invoice	varchar(10)		Table
billable	expense_data_allocation	char(1)		Table
	project_type	char(1)		Table
	request_expense_data	char(1)		Table
billable_post_history_key	fixed_price	decimal(15)		Table
billed_account_key	invoice	decimal(15)		Table
billed_organization_key	invoice	decimal(15)		Table
billing_manager_open	project	char(1)	('Y')	Table
billing_setup_history_key	billing_setup_history	decimal(15)		Table
billing_through	invoice	timestamp		Table
billing_type_key	billing_type	decimal(15)		Table
	project	decimal(15)		Table
	task	decimal(15)		Table
billing_viewer_open	project	char(1)	('Y')	Table
block_out	planned_time	char(1)	('N')	Table
breakfast_amount	mie_allowable_detail	decimal(15,3)	((0.000))	Table
	per_diem_mie_breakdown	decimal(15,3)		Table
breakfast_provided	mie_allowable_detail	char(1)	('N')	Table
	mie_per_diem_detail	char(1)	('N')	Table
budget	resource_request_budget	decimal(15,3)		Table
budget_by	resource_request	char(1)	('P')	Table
budget_detail_key	budget_detail	decimal(15)		Table
budget_formula	cost_report_element	varchar(3500)		Table
	fee_method	varchar(3500)		Table
budget_hours	assignment_view	decimal(15,2)		View
	project_assignment	decimal(15,2)		Table
	task_assignment	decimal(15,2)		Table
budget_key	budget	decimal(15)		Table
	budget_organization	decimal(15)		Table
	cost_pool_group_calc	decimal(15)		Table
budget_name	budget_name	varchar(20)		Table
budget_name_key	budget	decimal(15)		Table
	budget_name	decimal(15)		Table
budget_organization_key	budget_detail	decimal(15)		Table
	budget_organization	decimal(15)		Table
budget_units	resource_request	char(1)	('H')	Table
business_week_key	business_week	decimal(15)		Table
	person	decimal(15)	((1))	Table
calculated_by	cost_pool_group_calc	decimal(15)		Table
calculated_timestamp	cost_pool_group_calc	timestamp		Table
cap_amount	business_meeting_detail	decimal(18,3)		Table
cap_hours	accrual_schedule	decimal(15,5)		Table
cap_type	accrual_schedule	char(1)		Table
car_wash	company_car_detail	decimal(18,3)		Table
card_display	imported_credit_card_expense	varchar(4)		Table
card_number	credit_card	varchar(32)		Table
	imported_credit_card_expense	varchar(32)		Table
card_type	credit_card	varchar(32)		Table
	imported_credit_card_expense	varchar(32)		Table
carryover_ind	accrual_plan	char(1)	('N')	Table
cash_return	cash_return_detail	decimal(15,3)		Table
category	cost_element_account	tinyint		Table
	customer_account	tinyint		Table
	employee_type_account	tinyint		Table
	expense_type_account	tinyint		Table
	journal_cost_plus_detail	tinyint		Table
	journal_document_expense	tinyint		Table
	journal_expense	tinyint		Table
	journal_fee_cap_adjustment	tinyint		Table
	journal_fixed_price	tinyint		Table
	journal_funding_cap_adjustment	tinyint		Table
	journal_onetime_charge	tinyint		Table
	journal_prebilled_labor	tinyint		Table
	journal_time	tinyint		Table
	journal_view	tinyint		View
	labor_category_account	tinyint		Table
	onetime_charge_type_account	tinyint		Table
	pay_code_account	tinyint		Table
	payment_method_account	tinyint		Table
	person_account	tinyint		Table
	posting_group_source	tinyint		Table
	project_account	tinyint		Table
	project_type_account	tinyint		Table
	role	tinyint		Table
	task_account	tinyint		Table
category_1099	account	varchar(5)		Table
	vendor_payment_1099_view	varchar(5)		View
cc_email	project_invoice	varchar(255)		Table
chain_key	approval_chain	decimal(15)		Table
	chain	decimal(15)		Table
	person	decimal(15)		Table
chain_name	chain	varchar(50)		Table
change_date	expense_history	timestamp		Table
change_reason_code	change_reason	varchar(50)		Table
change_reason_key	change_reason	decimal(15)		Table
chart	criteria_set	char(1)	('N')	Table
	shared_criteria_set	char(1)	('N')	Table
chart_order	dashboard_chart	integer		Table
check_date	check_print_history	timestamp		Table
check_in_date	imported_lodging_detail	timestamp		Table
	lodging_allowable_detail	timestamp		Table
	lodging_detail	timestamp		Table
check_number	cash_return_detail	varchar(255)		Table
check_print_history_key	check_print_history	decimal(15)		Table
	vendor_payment	decimal(15)		Table
checking_account	bank_account	char(1)		Table
city	address	varchar(60)		Table
	billing_info	varchar(50)		Table
city_county_name	lodging_allowable_detail	varchar(45)		Table
	lodging_per_diem_detail	varchar(45)		Table
	mie_allowable_detail	varchar(45)		Table
	mie_per_diem_detail	varchar(45)		Table
	per_diem_rate	varchar(45)		Table
classification	customer	varchar(25)		Table
closed_by	fiscal_month_org_feature_close	decimal(15)		Table
	fiscal_year_org_close	decimal(15)		Table
closed_timestamp	fiscal_month_org_feature_close	timestamp	(getdate())	Table
	fiscal_year_org_close	timestamp		Table
code	billing_type	varchar(25)		Table
	cost_element	varchar(30)		Table
	time_period_setup	char(1)		Table
col1_field	invc_sect_fmt	tinyint		Table
col1_heading	invc_sect_fmt	varchar(40)		Table
col1_subtotal	invc_sect_fmt	char(1)	('N')	Table
col2_field	invc_sect_fmt	tinyint		Table
col2_heading	invc_sect_fmt	varchar(40)		Table
col2_subtotal	invc_sect_fmt	char(1)	('N')	Table
col3_field	invc_sect_fmt	tinyint		Table
col3_heading	invc_sect_fmt	varchar(40)		Table
col3_subtotal	invc_sect_fmt	char(1)	('N')	Table
commentor	project_note_comment	decimal(15)		Table
comments	approval_history	varchar(2000)		Table
	customer_contact	varchar(2000)		Table
	expense_data	varchar(2000)		Table
	expense_history	varchar(2000)		Table
	fin_document	varchar(2000)		Table
	imported_expense_data	varchar(2000)		Table
	leave_request	varchar(2000)		Table
	leave_request_approval	varchar(2000)		Table
	person_accrual	varchar(2000)		Table
	person_time	varchar(2000)		Table
	person_time_data	varchar(2000)		Table
	person_time_data_history	varchar(2000)		Table
	person_time_data_tito	varchar(2000)		Table
	person_time_data_tito_history	varchar(2000)		Table
	person_time_day_tito	varchar(2000)		Table
	plan_set_history	varchar(2000)		Table
	project_note_comment	varchar(2000)		Table
	request_expense_data	varchar(2000)		Table
	resource_request_history	varchar(2000)		Table
company_logo	invoice	decimal(15)		Table
	project_invoice	decimal(15)		Table
completed	task	timestamp		Table
completed_by	invoice	decimal(15)		Table
completed_date	invoice	timestamp		Table
	project	timestamp		Table
	project_budget_history	timestamp		Table
	project_budget_snapshot	timestamp		Table
	project_note	timestamp		Table
	project_note_audit	timestamp		Table
	task_budget_history	timestamp		Table
	task_budget_snapshot	timestamp		Table
contact_address_key	contact_address	decimal(15)		Table
contact_address_type	contact_address_type	varchar(50)		Table
contact_address_type_key	contact_address	decimal(15)		Table
	contact_address_type	decimal(15)		Table
contact_category_key	contact_category	decimal(15)		Table
	customer_contact_category	decimal(15)		Table
contact_category_name	contact_category	varchar(50)		Table
contact_email_key	contact_email	decimal(15)		Table
contact_email_type	contact_email_type	varchar(50)		Table
contact_email_type_key	contact_email	decimal(15)		Table
	contact_email_type	decimal(15)		Table
contact_first_name	billing_info	varchar(50)		Table
contact_last_name	billing_info	varchar(50)		Table
contact_phone_key	contact_phone	decimal(15)		Table
contact_phone_type	contact_phone_type	varchar(50)		Table
contact_phone_type_key	contact_phone	decimal(15)		Table
	contact_phone_type	decimal(15)		Table
contr_project_key	project_invoice_contributor	decimal(15)		Table
contract_number	invoice	varchar(25)		Table
	project_invoice	varchar(25)		Table
control_key	person_time	decimal(15)		Table
controller	expense_history	decimal(15)		Table
	leave_request	decimal(15)		Table
controller_key	expense_report	decimal(15)		Table
cost_account_key	expense_data_allocation	decimal(15)		Table
	expense_type	decimal(15)		Table
cost_customer	person_time_data	decimal(15)		Table
	project_assignment	decimal(15)		Table
	task_assignment	decimal(15)		Table
cost_customer_code	assignment_view	varchar(25)		View
cost_customer_key	assignment_view	decimal(15)		View
cost_element	posting_group_source	char(1)	('N')	Table
cost_element_key	cost_element	decimal(15)		Table
	cost_element_account	decimal(15)		Table
	cost_element_invc_fltr	decimal(15)		Table
	cost_plus_post_detail	decimal(15)		Table
	cost_pool	decimal(15)		Table
	cost_struct_labor	decimal(15)		Table
	cost_struct_odc	decimal(15)		Table
	cost_struct_pool	decimal(15)		Table
cost_element_type	cost_element	char(1)	('L')	Table
	cost_element_type_invc_fltr	char(1)		Table
cost_plus_post_detail_key	cost_plus_post_detail	decimal(15)		Table
	invcd_cost_plus_post_detail	decimal(15)		Table
	journal_cost_plus_detail	decimal(15)		Table
cost_pool_basis_calc_key	cost_pool_basis_calc	decimal(15)		Table
cost_pool_basis_key	cost_pool_basis	decimal(15)		Table
cost_pool_calc_key	cost_pool_basis_calc	decimal(15)		Table
	cost_pool_calc	decimal(15)		Table
	cost_pool_source_calc	decimal(15)		Table
cost_pool_group_calc_key	cost_pool_calc	decimal(15)		Table
	cost_pool_group_calc	decimal(15)		Table
cost_pool_group_key	cost_pool	decimal(15)		Table
	cost_pool_group	decimal(15)		Table
	cost_pool_group_calc	decimal(15)		Table
	cost_struct	decimal(15)		Table
cost_pool_group_name	cost_pool_group	varchar(128)		Table
cost_pool_key	cost_pool	decimal(15)		Table
	cost_pool_basis	decimal(15)		Table
	cost_pool_calc	decimal(15)		Table
	cost_pool_source	decimal(15)		Table
cost_pool_name	cost_pool	varchar(128)		Table
cost_pool_source_calc_key	cost_pool_source_calc	decimal(15)		Table
cost_pool_source_key	cost_pool_source	decimal(15)		Table
cost_post_history_key	expense_data_allocation	decimal(15)		Table
	person_time_data	decimal(15)		Table
cost_rate	assignment_view	decimal(15,5)		View
	labor_category_assign_rate	decimal(15,5)		Table
	labor_category_rate	decimal(15,5)		Table
	person_rate	decimal(15,5)		Table
	person_time_data	decimal(15,5)		Table
	planned_time	decimal(15,5)		Table
	project_assignment	decimal(15,5)		Table
	task_assignment	decimal(15,5)		Table
cost_rate_source	assignment_view	char(1)		View
	planned_time	char(1)	('P')	Table
	project	char(1)	('P')	Table
	project_assignment	char(1)	('P')	Table
	task_assignment	char(1)	('P')	Table
cost_report	cost_report	varchar(128)		Table
cost_report_element	cost_report_element	varchar(128)		Table
cost_report_element_key	cost_report_element	decimal(15)		Table
cost_report_key	cost_report	decimal(15)		Table
	cost_report_element	decimal(15)		Table
cost_struct_key	cost_struct	decimal(15)		Table
	cost_struct_labor	decimal(15)		Table
	cost_struct_odc	decimal(15)		Table
	cost_struct_pool	decimal(15)		Table
	project	decimal(15)		Table
cost_struct_labor_key	assignment_view	decimal(15)		View
	cost_struct_labor	decimal(15)		Table
	person_rate	decimal(15)		Table
	person_time_data	decimal(15)		Table
	planned_time	decimal(15)		Table
	project_assignment	decimal(15)		Table
	task_assignment	decimal(15)		Table
cost_struct_odc_key	cost_struct_odc	decimal(15)		Table
	expense_data_allocation	decimal(15)		Table
	fin_document_detail_expense	decimal(15)		Table
cost_struct_pool_key	cost_struct_pool	decimal(15)		Table
	cost_struct_pool_rate	decimal(15)		Table
cost_struct_pool_rate_key	cost_struct_pool_rate	decimal(15)		Table
cost_structure	cost_struct	varchar(128)		Table
country	address	varchar(60)		Table
country_state_name	lodging_allowable_detail	varchar(45)		Table
	lodging_per_diem_detail	varchar(45)		Table
	mie_allowable_detail	varchar(45)		Table
	mie_per_diem_detail	varchar(45)		Table
	per_diem_rate	varchar(45)		Table
cp_recalc_begin_date	post_history	timestamp		Table
cp_recalc_end_date	post_history	timestamp		Table
create_date	project_note	timestamp		Table
	project_note_comment	timestamp		Table
created	customer_attachment	timestamp	(getdate())	Table
	expense_report	timestamp		Table
	expense_report_attachment	timestamp	(getdate())	Table
	export_template	timestamp		Table
	fin_document_attachment	timestamp	(getdate())	Table
	project	timestamp		Table
	project_alert	timestamp		Table
	task_alert	timestamp		Table
created_by	bank_reconciliation	decimal(15)		Table
	customer_contact	decimal(15)		Table
	fin_document	decimal(15)		Table
	invoice	decimal(15)		Table
created_by_fin_document_key	fin_document_recurring	decimal(15)		Table
created_date	invoice	timestamp		Table
created_timestamp	bank_reconciliation	timestamp		Table
	customer_contact	timestamp		Table
	fin_document	timestamp		Table
creator_key	expense_report	decimal(15)		Table
creator_name	request_expense_report	varchar(255)		Table
creator_person_key	project_note	decimal(15)		Table
credit_account_category	onetime_charge_type	tinyint		Table
credit_amount	fin_document_detail	decimal(18,2)	((0))	Table
	general_ledger	decimal(18,2)	((0))	Table
credit_card_key	credit_card	decimal(15)		Table
criteria	adhoc_criteria_value	clob		Table
	column_width_criteria	clob		Table
	criteria_value	clob		Table
	list_criteria	clob		Table
	shared_criteria_value	clob		Table
criteria_class	criteria_set	varchar(256)		Table
	list_criteria_set	varchar(256)		Table
	project_criteria_set	varchar(256)		Table
	shared_criteria_set	varchar(256)		Table
criteria_set_key	criteria_set	decimal(15)		Table
	criteria_value	decimal(15)		Table
	dashboard_chart	decimal(15)		Table
	dashboard_list	decimal(15)		Table
criteria_type	dashboard_chart	char(1)		Table
	dashboard_list	char(1)		Table
currency	request_expense_data	varchar(100)		Table
currency_code	currency	varchar(25)		Table
currency_key	currency	decimal(15)		Table
	expense_data	decimal(15)		Table
	person	decimal(15)		Table
customer_address_key	customer_address	decimal(15)		Table
customer_approves_first	project	char(1)	('N')	Table
customer_code	access_customer_view	varchar(25)		View
	customer	varchar(25)		Table
customer_contact_key	contact_address	decimal(15)		Table
	contact_email	decimal(15)		Table
	contact_phone	decimal(15)		Table
	customer_contact	decimal(15)		Table
	customer_contact_category	decimal(15)		Table
customer_expense_approval	project	char(1)	('N')	Table
customer_key	access_customer_view	decimal(15)		View
	acct_org_access_hierarchy	decimal(15)		Table
	acct_org_access_parent	decimal(15)		Table
	bank_account	decimal(15)		Table
	budget_organization	decimal(15)		Table
	cost_pool_basis	decimal(15)		Table
	cost_pool_basis_calc	decimal(15)		Table
	cost_pool_source	decimal(15)		Table
	cost_pool_source_calc	decimal(15)		Table
	customer	decimal(15)		Table
	customer_account	decimal(15)		Table
	customer_address	decimal(15)		Table
	customer_assignment	decimal(15)		Table
	customer_attachment	decimal(15)		Table
	customer_contact	decimal(15)		Table
	customer_org	decimal(15)		Table
	expense_budget_view	decimal(15)		View
	fin_document_detail	decimal(15)		Table
	fiscal_month_org_feature_close	decimal(15)		Table
	fiscal_year_org_close	decimal(15)		Table
	general_ledger	decimal(15)		Table
	invoice	decimal(15)		Table
	org_access_hierarchy	decimal(15)		Table
	org_access_legal_entity	decimal(15)		Table
	org_access_parent	decimal(15)		Table
	person	decimal(15)		Table
	project	decimal(15)		Table
	request_allocation	decimal(15)		Table
	vendor_org	decimal(15)		Table
customer_name	customer	varchar(128)		Table
customer_org_key	customer_org	decimal(15)		Table
	customer_payment	decimal(15)		Table
customer_size	customer	integer		Table
customer_time_approval	project	char(1)	('N')	Table
customer_type	customer_type	varchar(25)		Table
customer_type_key	customer	decimal(15)		Table
	customer_type	decimal(15)		Table
cut_off_date	time_period_setup	timestamp	('12/31/2099')	Table
daily_room_rate	imported_lodging_detail	decimal(15,3)		Table
	lodging_allowable_detail	decimal(15,3)	((0.000))	Table
	lodging_per_diem_detail	decimal(15,3)	((0.000))	Table
daily_room_tax	imported_lodging_detail	decimal(15,3)		Table
	lodging_allowable_detail	decimal(15,3)	((0.000))	Table
	lodging_per_diem_detail	decimal(15,3)	((0.000))	Table
dashboard_id	dashboard_chart	varchar(128)		Table
	dashboard_list	varchar(128)		Table
	dashboard_section	varchar(128)		Table
data_type	udf_setup	decimal(15)	((3))	Table
date_completed	expense_report	timestamp		Table
	person_time	timestamp		Table
	request_expense_report	timestamp		Table
days	payment_term	decimal(3)		Table
dbversion_history_key	dbversion_history	decimal(15)		Table
debit_account_category	onetime_charge_type	tinyint		Table
debit_amount	fin_document_detail	decimal(18,2)	((0))	Table
	general_ledger	decimal(18,2)	((0))	Table
default_bill_to	customer_address	char(1)	('N')	Table
	customer_contact	char(1)	('N')	Table
default_email	export_template	varchar(250)		Table
default_filename	export_template	varchar(250)		Table
default_gl_post_org_key	customer	decimal(15)		Table
default_list	pay_code	char(1)		Table
default_remit_to	customer_address	char(1)	('N')	Table
	customer_contact	char(1)	('N')	Table
default_selected	invoice_number	char(1)		Table
	pay_code	char(1)		Table
	payment_term	char(1)		Table
default_ship_to	customer_address	char(1)	('N')	Table
	customer_contact	char(1)	('N')	Table
default_to_master_rate	labor_category_assignment	char(1)	('Y')	Table
deleteable	role	char(1)		Table
delivery_option	project_invoice	char(1)		Table
delivery_receipt_req	project_invoice	char(1)	('N')	Table
departure_date	air_detail	timestamp		Table
	imported_air_detail	timestamp		Table
deposit_amount	deposit	decimal(18,2)	((0))	Table
description	account	varchar(128)		Table
	accrual_plan	varchar(128)		Table
	batch	varchar(128)		Table
	billing_type	varchar(128)		Table
	budget_name	varchar(100)		Table
	chain	varchar(2000)		Table
	change_reason	varchar(2000)		Table
	contact_category	varchar(128)		Table
	cost_element	varchar(128)		Table
	cost_pool_group	varchar(2000)		Table
	cost_report	varchar(2000)		Table
	cost_struct	varchar(2000)		Table
	cost_struct_pool	varchar(128)		Table
	currency	varchar(2000)		Table
	customer_type	varchar(128)		Table
	email_template	varchar(250)		Table
	employee_type	varchar(128)		Table
	expense_budget_view	varchar(50)		View
	expense_plan	varchar(50)		Table
	expense_project_budget	varchar(50)		Table
	expense_task_budget	varchar(50)		Table
	expense_type	varchar(2000)		Table
	export_template	varchar(2000)		Table
	fin_document	varchar(128)		Table
	fin_document_detail	varchar(128)		Table
	fixed_price	varchar(128)		Table
	general_ledger	varchar(128)		Table
	holiday	varchar(50)		Table
	image_setup	varchar(100)		Table
	invoice	varchar(2000)		Table
	invoice_format	varchar(128)		Table
	journal_view	varchar(128)		View
	labor_category	varchar(2000)		Table
	mileage_rate_set	varchar(128)		Table
	onetime_charge	varchar(128)		Table
	pay_code	varchar(100)		Table
	payment_method	varchar(2000)		Table
	payment_term	varchar(128)		Table
	plan_set	varchar(2000)		Table
	plan_set_name	varchar(100)		Table
	posting_group	varchar(2000)		Table
	prebilled_labor	varchar(128)		Table
	proficiency	varchar(2000)		Table
	project_invoice	varchar(2000)		Table
	project_note_status	varchar(128)		Table
	project_note_type	varchar(128)		Table
	project_type	varchar(100)		Table
	resource_request	varchar(2000)		Table
	skill	varchar(2000)		Table
	skill_type	varchar(2000)		Table
	time_period_setup	varchar(100)		Table
detail_1099_amount	vendor_payment_1099_view	decimal(38,6)		View
detail_key	vendor_payment_1099_view	decimal(15)		View
dilution_bus_hours	person_time	decimal(17,4)		Table
dilution_bus_hours_factor	person_time	decimal(15,12)	((1))	Table
dilution_calc_req	person_time	char(1)	('N')	Table
dilution_factor	person_time	decimal(15,12)	((1))	Table
dilution_hours	person_time	decimal(17,4)		Table
dinner_amount	mie_allowable_detail	decimal(15,3)	((0.000))	Table
	per_diem_mie_breakdown	decimal(15,3)		Table
dinner_provided	mie_allowable_detail	char(1)	('N')	Table
	mie_per_diem_detail	char(1)	('N')	Table
disable_alerts	project_alert_prefs	char(1)	('N')	Table
discount	customer_invoice_activity	decimal(38,2)		View
	customer_payment_activity	decimal(38,2)		View
	vendor_invoice_activity	decimal(38,2)		View
	vendor_payment_activity	decimal(38,2)		View
discount_amount	customer_payment_included_inv	decimal(18,2)	((0))	Table
	invoice	decimal(18,2)		Table
	vendor_invoice	decimal(18,2)		Table
	vendor_payment_included	decimal(18,2)	((0))	Table
discount_date	invoice	timestamp		Table
	vendor_invoice	timestamp		Table
discount_days	payment_term	decimal(3)		Table
discount_general_ledger_key	customer_payment_included_inv	decimal(15)		Table
	vendor_payment_included	decimal(15)		Table
discount_percent	payment_term	decimal(5,2)		Table
display	credit_card	varchar(32)		Table
display_sequence	cost_pool	smallint		Table
	cost_struct_pool	smallint		Table
document_date	fin_document	timestamp		Table
document_number	cost_pool_calc	varchar(15)		Table
	fin_document	varchar(15)		Table
	general_ledger	varchar(50)		Table
	post_history	varchar(15)		Table
document_type	fin_document	tinyint		Table
due_date	invoice	timestamp		Table
	vendor_invoice	timestamp		Table
duration	task	decimal(5)		Table
eda_key	vendor_payment_1099_view	decimal(15)		View
edc	assignment_view	timestamp		View
editable	export_template	char(1)	('Y')	Table
	role	char(1)	('Y')	Table
eeo_code	payroll	varchar(20)		Table
eff_bill_rate	person_time_data	decimal(15,5)		Table
eff_cost_rate	person_time_data	decimal(15,5)		Table
eff_quantity	person_time_data	decimal(25,12)		Table
eff_thru_date	project_budget_snapshot	timestamp		Table
	task_budget_snapshot	timestamp		Table
effective_date	per_diem_rate	timestamp		Table
email	billing_info	varchar(100)		Table
	contact_email	varchar(255)		Table
	person	varchar(50)		Table
email_1099	customer	varchar(255)		Table
email_alert	general_alert_prefs	char(1)	('N')	Table
	project_alert_prefs	char(1)	('N')	Table
email_template_key	email_template	decimal(15)		Table
	project_invoice	decimal(15)		Table
emailed_by	invoice	decimal(15)		Table
emailed_timestamp	invoice	timestamp		Table
emp_id	person	varchar(25)		Table
employee_type	posting_group_source	char(1)	('N')	Table
employee_type_code	employee_type	varchar(25)		Table
employee_type_key	employee_type	decimal(15)		Table
	employee_type_account	decimal(15)		Table
	employee_type_expense_type	decimal(15)		Table
	employee_type_pay_code	decimal(15)		Table
	person	decimal(15)		Table
enabled	email_template	char(1)		Table
	expense_type	char(1)	('Y')	Table
	per_diem_rate	char(1)	('Y')	Table
	time_period_setup	char(1)		Table
end_date	account	timestamp		Table
	accrual_period	timestamp		Table
	assignment_view	timestamp		View
	customer	timestamp		Table
	expense_budget_view	timestamp		View
	expense_plan	timestamp	('12/31/2099')	Table
	expense_project_budget	timestamp	('12/31/2099')	Table
	expense_task_budget	timestamp	('12/31/2099')	Table
	fiscal_month	timestamp		Table
	fiscal_quarter	timestamp		Table
	fiscal_week	timestamp		Table
	fiscal_year	timestamp		Table
	labor_category_assign_rate	timestamp		Table
	labor_category_rate	timestamp		Table
	leave_request	timestamp		Table
	pay_code_rate	timestamp		Table
	person_accrual_plan	timestamp		Table
	person_rate	timestamp		Table
	planned_time	timestamp		Table
	project_assignment	timestamp	('12/31/2099')	Table
	resource_request	timestamp		Table
	resource_request_budget	timestamp		Table
	task_assignment	timestamp	('12/31/2099')	Table
	time_period	timestamp		Table
ending_balance	bank_reconciliation	decimal(18,3)		Table
enforce_role_restriction	project_note	char(1)	('N')	Table
enforce_wbs_dates	project	char(1)	('N')	Table
	project_budget_history	char(1)		Table
entity_name	udf_entity	varchar(25)		Table
entity_type	udf_entity	decimal(15)		Table
	udf_option	decimal(15)		Table
	udf_setup	decimal(15)		Table
entry_allowed	account	char(1)	('N')	Table
	customer	char(1)	('N')	Table
er_task_required	project	char(1)		Table
est_date_of_completion	project_assignment	timestamp		Table
	task_assignment	timestamp		Table
etc_hours	assignment_view	decimal(15,2)		View
	project_assignment	decimal(15,2)		Table
	task_assignment	decimal(15,2)		Table
event	plan_set_history	char(1)		Table
exceed_allowed	accrual_schedule	char(1)	('N')	Table
exceed_budget	assignment_view	char(1)		View
	project_assignment	char(1)	('N')	Table
	task_assignment	char(1)	('N')	Table
exchange_rate	currency	decimal(25,10)		Table
	expense_data	decimal(18,6)		Table
	imported_expense_data	decimal(18,6)		Table
	request_expense_data	decimal(18,6)		Table
exempt_status	person_rate	char(1)		Table
exempt_usage	pay_code	char(1)	('R')	Table
exp_bill_budget	project	decimal(15,2)		Table
	project_budget_history	decimal(15,2)		Table
	project_budget_snapshot	decimal(15,2)		Table
	task	decimal(15,2)		Table
	task_budget_history	decimal(15,2)		Table
	task_budget_snapshot	decimal(15,2)		Table
exp_bill_est_tot	project	decimal(15,2)		Table
	project_budget_history	decimal(15,2)		Table
	project_budget_snapshot	decimal(15,2)		Table
	task	decimal(15,2)		Table
	task_budget_history	decimal(15,2)		Table
	task_budget_snapshot	decimal(15,2)		Table
exp_bill_etc	project	decimal(15,2)		Table
	project_budget_history	decimal(15,2)		Table
	project_budget_snapshot	decimal(15,2)		Table
	task	decimal(15,2)		Table
	task_budget_history	decimal(15,2)		Table
	task_budget_snapshot	decimal(15,2)		Table
exp_cost_budget	project	decimal(15,2)		Table
	project_budget_history	decimal(15,2)		Table
	project_budget_snapshot	decimal(15,2)		Table
	task	decimal(15,2)		Table
	task_budget_history	decimal(15,2)		Table
	task_budget_snapshot	decimal(15,2)		Table
exp_cost_burden_budget	project	decimal(15,2)		Table
	project_budget_history	decimal(15,2)		Table
	project_budget_snapshot	decimal(15,2)		Table
	task	decimal(15,2)		Table
	task_budget_history	decimal(15,2)		Table
	task_budget_snapshot	decimal(15,2)		Table
exp_cost_est_tot	project	decimal(15,2)		Table
	project_budget_history	decimal(15,2)		Table
	project_budget_snapshot	decimal(15,2)		Table
	task	decimal(15,2)		Table
	task_budget_history	decimal(15,2)		Table
	task_budget_snapshot	decimal(15,2)		Table
exp_cost_etc	project	decimal(15,2)		Table
	project_budget_history	decimal(15,2)		Table
	project_budget_snapshot	decimal(15,2)		Table
	task	decimal(15,2)		Table
	task_budget_history	decimal(15,2)		Table
	task_budget_snapshot	decimal(15,2)		Table
exp_date	credit_card	varchar(10)		Table
expense_amount	expense_data	decimal(18,3)		Table
	imported_expense_data	decimal(18,3)		Table
	request_expense_data	decimal(18,3)		Table
expense_approval_amount	person	decimal(15,2)		Table
expense_assignment_flag	project	char(1)		Table
expense_budget_type	expense_budget_view	integer		View
expense_chain_key	person	decimal(15)		Table
expense_cost_alert	general_alert_prefs	char(1)	('N')	Table
	project_alert_prefs	char(1)	('N')	Table
expense_cost_alert_denom	general_alert_prefs	char(1)	('B')	Table
	project_alert_prefs	char(1)	('B')	Table
expense_cost_alert_pct	general_alert_prefs	decimal(3)		Table
	project_alert_prefs	decimal(3)		Table
expense_currency	expense_data	varchar(25)		Table
	expense_data_allocation	varchar(25)		Table
	expense_report	varchar(25)		Table
	request_expense_data	varchar(25)		Table
	request_expense_report	varchar(25)		Table
expense_currency_code	imported_expense_data	varchar(25)		Table
expense_data_allocation_key	cost_plus_post_detail	decimal(15)		Table
	expense_data_allocation	decimal(15)		Table
	invcd_expense	decimal(15)		Table
	journal_expense	decimal(15)		Table
	journal_view	decimal(15)		View
expense_data_key	air_detail	decimal(15)		Table
	business_meeting_detail	decimal(15)		Table
	cash_return_detail	decimal(15)		Table
	cell_phone_detail	decimal(15)		Table
	company_car_detail	decimal(15)		Table
	entertainment_detail	decimal(15)		Table
	expense_data	decimal(15)		Table
	expense_data_allocation	decimal(15)		Table
	lodging_allowable_detail	decimal(15)		Table
	lodging_detail	decimal(15)		Table
	lodging_per_diem_detail	decimal(15)		Table
	mie_allowable_detail	decimal(15)		Table
	mie_per_diem_detail	decimal(15)		Table
	mileage_detail	decimal(15)		Table
expense_date	expense_data	timestamp		Table
	imported_expense_data	timestamp		Table
	request_expense_data	timestamp		Table
expense_date_type	billing_setup	char(1)		Table
	billing_setup_history	char(1)		Table
	post_history	char(1)		Table
expense_email	person	char(1)		Table
expense_history_key	expense_history	decimal(15)		Table
expense_manager_approval	project	char(1)		Table
expense_plan_key	expense_plan	decimal(15)		Table
expense_project_allocation_key	expense_data	decimal(15)		Table
	expense_project_allocation	decimal(15)		Table
expense_project_budget_key	expense_project_budget	decimal(15)		Table
expense_report_key	exp_cust_approval_status	decimal(15)		Table
	expense_data	decimal(15)		Table
	expense_history	decimal(15)		Table
	expense_pm_approval_status	decimal(15)		Table
	expense_project_allocation	decimal(15)		Table
	expense_report	decimal(15)		Table
	expense_report_attachment	decimal(15)		Table
expense_task_budget_key	expense_task_budget	decimal(15)		Table
expense_type	expense_budget_view	varchar(25)		View
	expense_type	varchar(25)		Table
	posting_group_source	char(1)	('N')	Table
expense_type_key	cost_struct_odc	decimal(15)		Table
	employee_type_expense_type	decimal(15)		Table
	expense_budget_view	decimal(17,2)		View
	expense_data	decimal(15)		Table
	expense_plan	decimal(15)		Table
	expense_project_budget	decimal(15)		Table
	expense_task_budget	decimal(15)		Table
	expense_type	decimal(15)		Table
	expense_type_account	decimal(15)		Table
	expense_type_invc_fltr	decimal(15)		Table
	expense_type_vendor_assignment	decimal(15)		Table
	fin_document_detail_project	decimal(15)		Table
	project_expense_type	decimal(15)		Table
	project_type_exp_type_acct	decimal(15)		Table
expense_type_name	expense_budget_view	varchar(50)		View
	expense_type	varchar(50)		Table
	request_expense_data	varchar(100)		Table
expense_vat_amount	expense_data	decimal(18,3)	((0.000))	Table
	imported_expense_data	decimal(18,3)		Table
expense_vendor_key	person	decimal(15)		Table
expiration_date	per_diem_rate	timestamp		Table
expires	password_reset_request	timestamp		Table
export_criteria	export_criteria_value	clob		Table
export_criteria_set_key	export_criteria_set	decimal(15)		Table
	export_criteria_value	decimal(15)		Table
export_template_data_key	export_template_data	decimal(15)		Table
export_template_key	export_template	decimal(15)		Table
	export_template_data	decimal(15)		Table
export_template_type	export_criteria_set	varchar(25)		Table
external_code	pay_code_mapping	varchar(15)		Table
external_id	task	decimal(15)		Table
extract_date	journal_cost_plus_detail	timestamp		Table
	journal_document_expense	timestamp		Table
	journal_expense	timestamp		Table
	journal_fee_cap_adjustment	timestamp		Table
	journal_fixed_price	timestamp		Table
	journal_funding_cap_adjustment	timestamp		Table
	journal_onetime_charge	timestamp		Table
	journal_prebilled_labor	timestamp		Table
	journal_time	timestamp		Table
	journal_view	timestamp		View
extracted_by	invoice	decimal(15)		Table
extracted_date	invoice	timestamp		Table
factor	pay_code	decimal(5,3)		Table
fax	billing_info	varchar(25)		Table
feature	fiscal_month_org_feature_close	tinyint		Table
	general_ledger	tinyint		Table
	post_history	tinyint		Table
fed_exemptions	payroll	decimal(5)		Table
federal_tax_id	customer	char(9)		Table
federal_tax_id_type	customer	tinyint		Table
fee_cap_adjustment_key	fee_cap_adjustment	decimal(15)		Table
	invcd_fee_cap_adjustment	decimal(15)		Table
	journal_fee_cap_adjustment	decimal(15)		Table
fee_factor	project_fee	decimal(5,2)		Table
fee_factor_type	project_fee	char(1)	('P')	Table
fee_method	fee_method	varchar(128)		Table
fee_method_key	cost_plus_post_detail	decimal(15)		Table
	fee_cap_adjustment	decimal(15)		Table
	fee_method	decimal(15)		Table
	project_fee	decimal(15)		Table
field_name	export_template_data	varchar(60)		Table
field_number	export_template_data	integer		Table
file_name	imported_credit_card_expense	varchar(256)		Table
file_type	export_template	varchar(25)		Table
filter	pay_code_mapping	decimal(1)		Table
filter_sequence	invc_sect_fmt	tinyint		Table
filter_type	invc_sect_fmt	tinyint		Table
fin_document_detail_key	cost_plus_post_detail	decimal(15)		Table
	customer_payment_export_view	decimal(15)		View
	fin_document_detail	decimal(15)		Table
	fin_document_detail_expense	decimal(15)		Table
	fin_document_detail_project	decimal(15)		Table
	invcd_document_expense	decimal(15)		Table
	journal_document_expense	decimal(15)		Table
	vendor_payment_export_view	decimal(15)		View
fin_document_key	customer_payment	decimal(15)		Table
	customer_payment_activity	decimal(15)		View
	customer_payment_export_view	decimal(15)		View
	customer_payment_included_inv	decimal(15)		Table
	customer_payment_included_pmt	decimal(15)		Table
	customer_payment_unapplied	decimal(15)		Table
	deposit	decimal(15)		Table
	deposit_included	decimal(15)		Table
	fin_document	decimal(15)		Table
	fin_document_attachment	decimal(15)		Table
	fin_document_detail	decimal(15)		Table
	fin_document_recurring	decimal(15)		Table
	journal_entry	decimal(15)		Table
	vendor_invoice	decimal(15)		Table
	vendor_invoice_activity	decimal(15)		View
	vendor_payment	decimal(15)		Table
	vendor_payment_1099_view	decimal(15)		View
	vendor_payment_activity	decimal(15)		View
	vendor_payment_export_view	decimal(15)		View
	vendor_payment_included	decimal(15)		Table
	vendor_payment_unapplied	decimal(15)		Table
financial_org	customer	char(1)	('N')	Table
first_check_number	check_print_history	integer		Table
first_day	mie_allowable_detail	char(1)	('N')	Table
	mie_per_diem_detail	char(1)	('N')	Table
first_name	customer_contact	varchar(50)		Table
	person	varchar(50)		Table
fiscal_month_key	budget_detail	decimal(15)		Table
	fiscal_month	decimal(15)		Table
	fiscal_month_org_feature_close	decimal(15)		Table
	fiscal_week	decimal(15)		Table
	general_ledger	decimal(15)		Table
fiscal_quarter_key	fiscal_month	decimal(15)		Table
	fiscal_quarter	decimal(15)		Table
	fiscal_week	decimal(15)		Table
fiscal_week_key	fiscal_week	decimal(15)		Table
fiscal_year_key	budget	decimal(15)		Table
	cost_struct_pool_rate	decimal(15)		Table
	fiscal_month	decimal(15)		Table
	fiscal_quarter	decimal(15)		Table
	fiscal_week	decimal(15)		Table
	fiscal_year	decimal(15)		Table
	fiscal_year_org_close	decimal(15)		Table
fixed_fee_amount	project_fee	decimal(15,2)		Table
fixed_price_key	fixed_price	decimal(15)		Table
	fp_revenue_schedule	decimal(15)		Table
	invcd_fixed_price	decimal(15)		Table
	journal_fixed_price	decimal(15)		Table
fleet_key	fleet	decimal(15)		Table
format	export_template_data	varchar(256)		Table
formula	cost_struct_pool	varchar(4000)		Table
fp_revenue_schedule_key	fp_revenue_schedule	decimal(15)		Table
friday	business_week	char(1)	('Y')	Table
from_location	air_detail	varchar(100)		Table
	imported_air_detail	varchar(100)		Table
	mileage_detail	varchar(100)		Table
funded_value	invoice	decimal(15,2)		Table
	project	decimal(15,2)		Table
	project_budget_history	decimal(15,2)		Table
	task	decimal(15,2)		Table
	task_budget_history	decimal(15,2)		Table
funding_cap_adjustment_key	funding_cap_adjustment	decimal(15)		Table
	invcd_funding_cap_adjustment	decimal(15)		Table
	journal_funding_cap_adjustment	decimal(15)		Table
funding_expended_alert	general_alert_prefs	char(1)	('N')	Table
	project_alert_prefs	char(1)	('N')	Table
funding_expended_alert_pct	general_alert_prefs	decimal(3)		Table
	project_alert_prefs	decimal(3)		Table
future_charge	project	char(1)		Table
gas_cost	company_car_detail	decimal(18,3)		Table
gas_cost_gallons	company_car_detail	decimal(10,1)		Table
general_ledger_key	bank_reconciliation_detail	decimal(15)		Table
	customer_payment	decimal(15)		Table
	customer_payment_unapplied	decimal(15)		Table
	deposit	decimal(15)		Table
	deposit_included	decimal(15)		Table
	fin_document_detail	decimal(15)		Table
	general_ledger	decimal(15)		Table
	journal_cost_plus_detail	decimal(15)		Table
	journal_document_expense	decimal(15)		Table
	journal_expense	decimal(15)		Table
	journal_fee_cap_adjustment	decimal(15)		Table
	journal_fixed_price	decimal(15)		Table
	journal_funding_cap_adjustment	decimal(15)		Table
	journal_onetime_charge	decimal(15)		Table
	journal_prebilled_labor	decimal(15)		Table
	journal_time	decimal(15)		Table
	journal_view	decimal(15)		View
	vendor_invoice	decimal(15)		Table
	vendor_payment	decimal(15)		Table
	vendor_payment_unapplied	decimal(15)		Table
generate_invoice	project_invoice	char(1)	('N')	Table
gl_customer_key	fin_document_detail_expense	decimal(15)		Table
gl_post_level	post_history	tinyint		Table
gl_post_level_offset	post_history	tinyint		Table
gl_post_level_offset_alt	post_history	tinyint		Table
global_access	acct_org_access	char(1)	('Y')	Table
	org_access_person	char(1)	('N')	Table
group_by_project	invoice_format	char(1)	('N')	Table
group_by_task	invoice_format	char(1)	('N')	Table
hide_income_stmt_hdr	account	char(1)	('N')	Table
hide_vat	person	char(1)	('N')	Table
hire_date	payroll	timestamp		Table
	person	timestamp		Table
historical	person_time	char(1)	('N')	Table
hold_reason	vendor_invoice	varchar(255)		Table
	vendor_org	varchar(255)		Table
holiday_date	holiday	timestamp		Table
holiday_key	holiday	decimal(15)		Table
hotel	imported_lodging_detail	varchar(100)		Table
	lodging_detail	varchar(100)		Table
hour_increment	person	decimal(15,2)		Table
hours	business_week	decimal(4,2)	((8))	Table
	leave_request	decimal(15,2)		Table
hours_alert	general_alert_prefs	char(1)	('N')	Table
	project_alert_prefs	char(1)	('N')	Table
hours_alert_denom	general_alert_prefs	char(1)	('B')	Table
	project_alert_prefs	char(1)	('B')	Table
hours_alert_pct	general_alert_prefs	decimal(3)		Table
	project_alert_prefs	decimal(3)		Table
hours_budget	project	decimal(15,2)		Table
	project_budget_history	decimal(15,2)		Table
	project_budget_snapshot	decimal(15,2)		Table
	task	decimal(15,2)		Table
	task_budget_history	decimal(15,2)		Table
	task_budget_snapshot	decimal(15,2)		Table
hours_est_tot	project	decimal(15,2)		Table
	project_budget_history	decimal(15,2)		Table
	project_budget_snapshot	decimal(15,2)		Table
	task	decimal(15,2)		Table
	task_budget_history	decimal(15,2)		Table
	task_budget_snapshot	decimal(15,2)		Table
hours_etc	project	decimal(15,2)		Table
	project_budget_history	decimal(15,2)		Table
	project_budget_snapshot	decimal(15,2)		Table
	task	decimal(15,2)		Table
	task_budget_history	decimal(15,2)		Table
	task_budget_snapshot	decimal(15,2)		Table
hours_in_period	time_period	decimal(17,4)		Table
	time_period_setup	decimal(17,4)		Table
image_setup_key	image_setup	decimal(15)		Table
immigration_status	payroll	varchar(5)		Table
import_date	imported_expense_data	timestamp		Table
import_ind	export_template	char(1)	('N')	Table
import_source	imported_expense_data	decimal(15)		Table
imported_expense_data_key	expense_data	decimal(15)		Table
	imported_air_detail	decimal(15)		Table
	imported_credit_card_expense	decimal(15)		Table
	imported_expense_data	decimal(15)		Table
	imported_lodging_detail	decimal(15)		Table
inception_to_date	invoice_format	char(1)	('N')	Table
inception_to_date_hours	cost_plus_invc_sect_fmt	char(1)	('N')	Table
	labor_invc_sect_fmt	char(1)	('N')	Table
incidentals_amount	per_diem_mie_breakdown	decimal(15,3)		Table
incidentals_rate	per_diem_rate	decimal(15,3)		Table
include_in_1099	payment_method	char(1)	('N')	Table
included_detail_amount	vendor_payment_1099_view	decimal(20,3)		View
included_fin_document_key	customer_payment_export_view	decimal(15)		View
	customer_payment_included_pmt	decimal(15)		Table
	deposit_included	decimal(15)		Table
	vendor_payment_1099_view	decimal(15)		View
	vendor_payment_export_view	decimal(15)		View
	vendor_payment_included	decimal(15)		Table
including_fin_document_key	vendor_payment_1099_view	decimal(15)		View
indent_level	task	integer		Table
industry	customer	varchar(64)		Table
initial_timestamp	unanet_access	timestamp	(getdate())	Table
invc_sect_fmt_key	cost_element_invc_fltr	decimal(15)		Table
	cost_element_type_invc_fltr	decimal(15)		Table
	cost_plus_invc_sect_fmt	decimal(15)		Table
	expense_invc_sect_fmt	decimal(15)		Table
	expense_type_invc_fltr	decimal(15)		Table
	fixed_price_invc_sect_fmt	decimal(15)		Table
	invc_sect_fmt	decimal(15)		Table
	labor_category_invc_fltr	decimal(15)		Table
	labor_invc_sect_fmt	decimal(15)		Table
	onetime_charge_type_invc_fltr	decimal(15)		Table
	prebill_invc_sect_fmt	decimal(15)		Table
invoice_amount	customer_invoice_activity	decimal(18,2)		View
	vendor_invoice	decimal(18,2)		Table
	vendor_invoice_activity	decimal(18,2)		View
invoice_date	invoice	timestamp		Table
	vendor_invoice	timestamp		Table
invoice_format_key	invc_sect_fmt	decimal(15)		Table
	invc_sect_fmt_tot_grp	decimal(15)		Table
	invoice	decimal(15)		Table
	invoice_addl_fmt	decimal(15)		Table
	invoice_format	decimal(15)		Table
	project_invoice	decimal(15)		Table
	project_invoice_addl_fmt	decimal(15)		Table
invoice_key	cost_plus_post_detail	decimal(15)		Table
	customer_invoice_activity	decimal(15)		View
	customer_payment_export_view	decimal(15)		View
	customer_payment_included_inv	decimal(15)		Table
	expense_data_allocation	decimal(15)		Table
	fee_cap_adjustment	decimal(15)		Table
	fin_document_detail_expense	decimal(15)		Table
	fixed_price	decimal(15)		Table
	funding_cap_adjustment	decimal(15)		Table
	invcd_cost_plus_post_detail	decimal(15)		Table
	invcd_document_expense	decimal(15)		Table
	invcd_expense	decimal(15)		Table
	invcd_fee_cap_adjustment	decimal(15)		Table
	invcd_fixed_price	decimal(15)		Table
	invcd_funding_cap_adjustment	decimal(15)		Table
	invcd_prebilled_labor	decimal(15)		Table
	invcd_project	decimal(15)		Table
	invcd_time	decimal(15)		Table
	invoice	decimal(15)		Table
	invoice_addl_fmt	decimal(15)		Table
	journal_cost_plus_detail	decimal(15)		Table
	journal_document_expense	decimal(15)		Table
	journal_expense	decimal(15)		Table
	journal_fee_cap_adjustment	decimal(15)		Table
	journal_fixed_price	decimal(15)		Table
	journal_funding_cap_adjustment	decimal(15)		Table
	journal_prebilled_labor	decimal(15)		Table
	journal_time	decimal(15)		Table
	journal_view	decimal(15)		View
	onetime_charge	decimal(15)		Table
	person_time_data	decimal(15)		Table
	prebilled_labor	decimal(15)		Table
invoice_number	invoice	varchar(50)		Table
invoice_number_key	invoice_number	decimal(15)		Table
	project_invoice	decimal(15)		Table
invoice_option	invoice	char(1)	('S')	Table
	project_invoice	char(1)	('S')	Table
invoiced_to_date	invoice_format	char(1)	('N')	Table
item	data_version	varchar(50)		Table
item_description	journal_view	varchar(128)		View
journal_key	journal_cost_plus_detail	decimal(15)		Table
	journal_document_expense	decimal(15)		Table
	journal_expense	decimal(15)		Table
	journal_fee_cap_adjustment	decimal(15)		Table
	journal_fixed_price	decimal(15)		Table
	journal_funding_cap_adjustment	decimal(15)		Table
	journal_onetime_charge	decimal(15)		Table
	journal_prebilled_labor	decimal(15)		Table
	journal_time	decimal(15)		Table
	journal_view	decimal(15)		View
journal_trans_date	journal_cost_plus_detail	timestamp		Table
	journal_document_expense	timestamp		Table
	journal_expense	timestamp		Table
	journal_fee_cap_adjustment	timestamp		Table
	journal_fixed_price	timestamp		Table
	journal_funding_cap_adjustment	timestamp		Table
	journal_onetime_charge	timestamp		Table
	journal_prebilled_labor	timestamp		Table
	journal_time	timestamp		Table
	journal_view	timestamp		View
	post_history	timestamp		Table
journal_type	journal_view	varchar(2)		View
label	invc_sect_fmt	varchar(50)		Table
	invc_sect_fmt_tot_grp	varchar(50)		Table
	udf_setup	varchar(128)		Table
labor_bill_budget	project	decimal(15,2)		Table
	project_budget_history	decimal(15,2)		Table
	project_budget_snapshot	decimal(15,2)		Table
	task	decimal(15,2)		Table
	task_budget_history	decimal(15,2)		Table
	task_budget_snapshot	decimal(15,2)		Table
labor_bill_est_tot	project	decimal(15,2)		Table
	project_budget_history	decimal(15,2)		Table
	project_budget_snapshot	decimal(15,2)		Table
	task	decimal(15,2)		Table
	task_budget_history	decimal(15,2)		Table
	task_budget_snapshot	decimal(15,2)		Table
labor_bill_etc	project	decimal(15,2)		Table
	project_budget_history	decimal(15,2)		Table
	project_budget_snapshot	decimal(15,2)		Table
	task	decimal(15,2)		Table
	task_budget_history	decimal(15,2)		Table
	task_budget_snapshot	decimal(15,2)		Table
labor_category	assignment_view	varchar(50)		View
	labor_category	varchar(50)		Table
	posting_group_source	char(1)	('N')	Table
labor_category_assignment_key	labor_category_assign_rate	decimal(15)		Table
	labor_category_assignment	decimal(15)		Table
labor_category_key	assignment_view	decimal(15)		View
	labor_category	decimal(15)		Table
	labor_category_account	decimal(15)		Table
	labor_category_assignment	decimal(15)		Table
	labor_category_invc_fltr	decimal(15)		Table
	labor_category_rate	decimal(15)		Table
	person	decimal(15)		Table
	person_time_data	decimal(15)		Table
	person_time_data_history	decimal(15)		Table
	planned_time	decimal(15)		Table
	project_assignment	decimal(15)		Table
	res_req_labor_category	decimal(15)		Table
	task_assignment	decimal(15)		Table
labor_category_rate_key	labor_category_rate	decimal(15)		Table
labor_cost_alert	general_alert_prefs	char(1)	('N')	Table
	project_alert_prefs	char(1)	('N')	Table
labor_cost_alert_denom	general_alert_prefs	char(1)	('B')	Table
	project_alert_prefs	char(1)	('B')	Table
labor_cost_alert_pct	general_alert_prefs	decimal(3)		Table
	project_alert_prefs	decimal(3)		Table
labor_cost_budget	project	decimal(15,2)		Table
	project_budget_history	decimal(15,2)		Table
	project_budget_snapshot	decimal(15,2)		Table
	task	decimal(15,2)		Table
	task_budget_history	decimal(15,2)		Table
	task_budget_snapshot	decimal(15,2)		Table
labor_cost_burden_budget	project	decimal(15,2)		Table
	project_budget_history	decimal(15,2)		Table
	project_budget_snapshot	decimal(15,2)		Table
	task	decimal(15,2)		Table
	task_budget_history	decimal(15,2)		Table
	task_budget_snapshot	decimal(15,2)		Table
labor_cost_est_tot	project	decimal(15,2)		Table
	project_budget_history	decimal(15,2)		Table
	project_budget_snapshot	decimal(15,2)		Table
	task	decimal(15,2)		Table
	task_budget_history	decimal(15,2)		Table
	task_budget_snapshot	decimal(15,2)		Table
labor_cost_etc	project	decimal(15,2)		Table
	project_budget_history	decimal(15,2)		Table
	project_budget_snapshot	decimal(15,2)		Table
	task	decimal(15,2)		Table
	task_budget_history	decimal(15,2)		Table
	task_budget_snapshot	decimal(15,2)		Table
lag	task_depends	decimal(5)		Table
last_check_number	check_print_history	integer		Table
last_check_number_used	bank_account	integer		Table
last_day	mie_allowable_detail	char(1)	('N')	Table
	mie_per_diem_detail	char(1)	('N')	Table
last_etc_update_date	assignment_view	timestamp		View
	project_assignment	timestamp		Table
	task_assignment	timestamp		Table
last_modified_at	image_setup	timestamp		Table
last_modified_by	image_setup	decimal(15)		Table
last_name	customer_contact	varchar(50)		Table
	person	varchar(50)		Table
last_number	invoice_number	decimal(15)		Table
	sequence_number	decimal(15)		Table
last_project_code_seq	customer	decimal(15)	((0))	Table
	project_type	decimal(15)	((0))	Table
last_update	expense_data	timestamp	(getdate())	Table
	expense_project_allocation	timestamp	(getdate())	Table
	expense_report	timestamp	(getdate())	Table
	person_time_data	timestamp		Table
	person_time_day	timestamp		Table
last_updated	export_template	timestamp		Table
last_updated_by	customer_contact	decimal(15)		Table
	fin_document	decimal(15)		Table
last_updated_by_key	export_criteria_set	decimal(15)		Table
last_updated_date	export_criteria_set	timestamp		Table
last_updated_timestamp	customer_contact	timestamp		Table
	fin_document	timestamp		Table
lead_project_key	project_invoice_contributor	decimal(15)		Table
leave_balance	project	char(1)	('N')	Table
leave_request_approval_key	leave_request_approval	decimal(15)		Table
leave_request_email	person	char(1)	('N')	Table
leave_request_key	leave_request	decimal(15)		Table
	leave_request_approval	decimal(15)		Table
left_visit	acct_cost_pool_tree	integer		Table
	acct_fin_tree	integer		Table
	org_cost_pool_tree	integer		Table
	org_fin_tree	integer		Table
	org_tree	integer		Table
	task	decimal(15)		Table
legal_entity	customer	char(1)	('N')	Table
	posting_group_source	char(1)	('N')	Table
legal_entity_ind	access_customer_view	varchar(1)		View
legal_entity_key	bank_reconciliation	decimal(15)		Table
	budget	decimal(15)		Table
	cost_pool_group	decimal(15)		Table
	customer	decimal(15)		Table
	customer_org	decimal(15)		Table
	fin_document	decimal(15)		Table
	vendor_org	decimal(15)		Table
length	export_template_data	integer		Table
license	company_car_detail	decimal(18,3)		Table
limit_bill_to_funded	project	char(1)	('N')	Table
	task	char(1)	('N')	Table
limit_rev_to_funded	project	char(1)	('N')	Table
	task	char(1)	('N')	Table
list_criteria	list_criteria_value	clob		Table
list_criteria_set_key	list_criteria_set	decimal(15)		Table
	list_criteria_value	decimal(15)		Table
locale	currency	varchar(25)		Table
location	assignment_view	varchar(50)		View
	company_car_detail	varchar(64)		Table
	entertainment_detail	varchar(100)		Table
	expense_report	varchar(255)		Table
	imported_lodging_detail	varchar(100)		Table
	lodging_detail	varchar(100)		Table
	request_expense_report	varchar(255)		Table
location_key	assignment_view	decimal(15)		View
	location	decimal(15)		Table
	person	decimal(15)		Table
	person_time_data	decimal(15)		Table
	person_time_data_history	decimal(15)		Table
	planned_time	decimal(15)		Table
	project	decimal(15)		Table
	project_assignment	decimal(15)		Table
	project_location	decimal(15)		Table
	res_req_location	decimal(15)		Table
	task_assignment	decimal(15)		Table
	vat_location	decimal(15)		Table
location_name	location	varchar(50)		Table
	vat_location	varchar(50)		Table
location_required	project	char(1)	('N')	Table
lock_name	unanet_lock	varchar(50)		Table
locked	expense_type	char(1)		Table
	plan_set	char(1)	('N')	Table
lodging_rate	per_diem_rate	decimal(15,3)		Table
login_failures	person	decimal(3)	((0))	Table
lunch_amount	mie_allowable_detail	decimal(15,3)	((0.000))	Table
	per_diem_mie_breakdown	decimal(15,3)		Table
lunch_provided	mie_allowable_detail	char(1)	('N')	Table
	mie_per_diem_detail	char(1)	('N')	Table
maintenance	company_car_detail	decimal(18,3)		Table
manager_approval	project	char(1)		Table
manager_path	column_width_criteria	varchar(128)		Table
	criteria_set	varchar(128)		Table
	list_criteria	varchar(128)		Table
	list_criteria_set	varchar(128)		Table
	project_criteria_set	varchar(128)		Table
	shared_criteria_set	varchar(128)		Table
marital_status	payroll	char(1)		Table
markup	expense_data_allocation	decimal(5,2)	((0))	Table
	expense_plan	decimal(5,2)		Table
	expense_type	decimal(5,2)		Table
	fin_document_detail_expense	decimal(5,2)	((0))	Table
	project_expense_type	decimal(5,2)		Table
master_markup	expense_budget_view	decimal(17,2)		View
max_future_period	time_period_setup	decimal(15)		Table
max_occurrences	fin_document_recurring	integer		Table
meals_rate	per_diem_rate	decimal(15,3)		Table
medical_plan	payroll	varchar(50)		Table
memo	invoice	varchar(2000)		Table
	project_invoice	varchar(2000)		Table
message	email_template	varchar(2000)		Table
middle_initial	customer_contact	char(1)		Table
	person	char(1)		Table
mie_rate	per_diem_mie_breakdown	decimal(15,3)		Table
mileage_business	company_car_detail	decimal(10,1)		Table
mileage_personal	company_car_detail	decimal(10,1)		Table
mileage_rate_key	mileage_rate	decimal(15)		Table
mileage_rate_set	mileage_rate_set	varchar(25)		Table
mileage_rate_set_key	expense_type	decimal(15)		Table
	mileage_rate	decimal(15)		Table
	mileage_rate_set	decimal(15)		Table
miles	mileage_detail	decimal(15,2)		Table
min_width	invoice_number	decimal(2)		Table
misc	company_car_detail	decimal(18,3)		Table
misc1	cash_return_detail	varchar(255)		Table
misc2	cash_return_detail	varchar(255)		Table
misc3	cash_return_detail	varchar(255)		Table
misc4	cash_return_detail	varchar(255)		Table
misc5	cash_return_detail	varchar(255)		Table
misc_charge	imported_lodging_detail	decimal(15,3)		Table
	lodging_detail	decimal(15,3)		Table
misc_comments	company_car_detail	varchar(2000)		Table
misc_desc	imported_lodging_detail	varchar(100)		Table
	lodging_detail	varchar(100)		Table
modifiable	email_template	char(1)	('N')	Table
modified_by	billing_setup_history	decimal(15)		Table
	plan_set_history	decimal(15)		Table
	project_budget_history	decimal(15)		Table
	project_note_audit	decimal(15)		Table
	shared_criteria_set	decimal(15)		Table
	task_budget_history	decimal(15)		Table
modified_comments	person_time_data_history	varchar(2000)		Table
modified_date	billing_setup_history	timestamp		Table
	cost_struct_pool_rate	timestamp		Table
	person_time_data_history	timestamp		Table
	person_time_data_tito_history	timestamp		Table
	project_budget_history	timestamp		Table
	project_note	timestamp		Table
	project_note_audit	timestamp		Table
	project_note_comment	timestamp		Table
	shared_criteria_set	timestamp	(getdate())	Table
	task_budget_history	timestamp		Table
modified_person_key	person_time_data	decimal(15)		Table
	person_time_day	decimal(15)		Table
	project_note	decimal(15)		Table
modified_timestamp	plan_set_history	timestamp		Table
modifier	project_note_comment	decimal(15)		Table
modifier_key	cost_struct_pool_rate	decimal(15)		Table
monday	business_week	char(1)	('Y')	Table
monthly_charge	cell_phone_detail	decimal(15,3)		Table
months_of_service	accrual_schedule	decimal(4)		Table
name	adhoc_criteria_set	varchar(50)		Table
	bank_account	varchar(25)		Table
	business_week	varchar(25)		Table
	credit_card	varchar(128)		Table
	criteria_set	varchar(50)		Table
	email_template	varchar(50)		Table
	export_criteria_set	varchar(128)		Table
	export_template	varchar(128)		Table
	fiscal_year	varchar(128)		Table
	fleet	varchar(32)		Table
	image_setup	varchar(50)		Table
	invoice_format	varchar(50)		Table
	invoice_number	varchar(50)		Table
	list_criteria_set	varchar(50)		Table
	onetime_charge_type	varchar(50)		Table
	project_criteria_set	varchar(50)		Table
	shared_criteria_set	varchar(50)		Table
	vendor	varchar(255)		Table
nights_charged	imported_lodging_detail	integer		Table
	lodging_allowable_detail	integer		Table
	lodging_detail	integer		Table
	lodging_per_diem_detail	integer	((1))	Table
no_receipt_reason	expense_data	varchar(128)		Table
	imported_expense_data	varchar(128)		Table
	request_expense_data	varchar(128)		Table
node_key	acct_cost_pool_tree	decimal(15)		Table
	acct_fin_tree	decimal(15)		Table
	org_cost_pool_tree	decimal(15)		Table
	org_fin_tree	decimal(15)		Table
	org_tree	decimal(15)		Table
non_work_days_ind	leave_request	char(1)	('N')	Table
nonwork_hours	person_time_data_tito	decimal(4,2)	((0))	Table
	person_time_data_tito_history	decimal(4,2)	((0))	Table
	person_time_day_tito	decimal(4,2)		Table
note	project_note	varchar(2000)		Table
notes	export_template_data	varchar(2000)		Table
null_value	export_template_data	varchar(256)		Table
oconus_indicator	per_diem_rate	char(1)	('N')	Table
odo_end	company_car_detail	decimal(10,1)		Table
odo_start	company_car_detail	decimal(10,1)		Table
oil_cost	company_car_detail	decimal(18,3)		Table
oil_cost_quarts	company_car_detail	decimal(10,1)		Table
onetime_charge_key	journal_onetime_charge	decimal(15)		Table
	onetime_charge	decimal(15)		Table
onetime_charge_type	posting_group_source	char(1)	('N')	Table
onetime_charge_type_key	onetime_charge	decimal(15)		Table
	onetime_charge_type	decimal(15)		Table
	onetime_charge_type_account	decimal(15)		Table
	onetime_charge_type_invc_fltr	decimal(15)		Table
open_edit	assignment_view	char(1)		View
open_status	project_status	char(1)		Table
order_by_list	export_template	varchar(2000)		Table
order_number	invoice	varchar(25)		Table
	project_invoice	varchar(25)		Table
org_access_person_key	access_customer_view	decimal(15)		View
	org_access_hierarchy	decimal(15)		Table
	org_access_legal_entity	decimal(15)		Table
	org_access_parent	decimal(15)		Table
	org_access_person	decimal(15)		Table
org_code	journal_view	varchar(25)		View
org_name	journal_view	varchar(128)		View
org_source	posting_group_source	char(1)	('0')	Table
organization_key	adp_organization	decimal(15)		Table
	customer_payment	decimal(15)		Table
	customer_payment_unapplied	decimal(15)		Table
	deposit	decimal(15)		Table
	fin_document_detail	decimal(15)		Table
	general_ledger	decimal(15)		Table
	journal_cost_plus_detail	decimal(15)		Table
	journal_document_expense	decimal(15)		Table
	journal_expense	decimal(15)		Table
	journal_fee_cap_adjustment	decimal(15)		Table
	journal_fixed_price	decimal(15)		Table
	journal_funding_cap_adjustment	decimal(15)		Table
	journal_onetime_charge	decimal(15)		Table
	journal_prebilled_labor	decimal(15)		Table
	journal_time	decimal(15)		Table
	journal_view	decimal(15)		View
	vendor_invoice	decimal(15)		Table
	vendor_payment	decimal(15)		Table
	vendor_payment_unapplied	decimal(15)		Table
orig_end_date	project	timestamp		Table
	project_budget_history	timestamp		Table
	project_budget_snapshot	timestamp		Table
	task	timestamp		Table
	task_budget_history	timestamp		Table
	task_budget_snapshot	timestamp		Table
orig_fin_document_key	fin_document_recurring	decimal(15)		Table
orig_start_date	project	timestamp		Table
	project_budget_history	timestamp		Table
	project_budget_snapshot	timestamp		Table
	task	timestamp		Table
	task_budget_history	timestamp		Table
	task_budget_snapshot	timestamp		Table
output	task	varchar(50)		Table
overage	lodging_allowable_detail	decimal(15,3)	((0.000))	Table
	mie_allowable_detail	decimal(15,3)	((0.000))	Table
overage_expense_type	expense_type	decimal(15)		Table
owner_key	expense_report	decimal(15)		Table
	export_template	decimal(15)		Table
	request_expense_report	decimal(15)		Table
owner_name	request_expense_report	varchar(255)		Table
owning_customer_key	project	decimal(15)		Table
	task	decimal(15)		Table
parent_key	acct_cost_pool_tree	decimal(15)		Table
	acct_fin_tree	decimal(15)		Table
	expense_data	decimal(15)		Table
	org_cost_pool_tree	decimal(15)		Table
	org_fin_tree	decimal(15)		Table
	org_tree	decimal(15)		Table
	request_expense_data	decimal(15)		Table
parent_task	task	decimal(15)		Table
passed_to	approval_history	decimal(15)		Table
password	person	varchar(32)		Table
password_date	person	timestamp		Table
patch_id	dbversion_patch	varchar(10)		Table
pay_code	pay_code	varchar(10)		Table
	posting_group_source	char(1)	('N')	Table
pay_code_key	adp_setup	decimal(15)		Table
	employee_type_pay_code	decimal(15)		Table
	pay_code	decimal(15)		Table
	pay_code_account	decimal(15)		Table
	pay_code_mapping	decimal(15)		Table
	pay_code_rate	decimal(15)		Table
	person	decimal(15)		Table
	person_time_data	decimal(15)		Table
	person_time_data_history	decimal(15)		Table
	project	decimal(15)		Table
	project_pay_code	decimal(15)		Table
pay_code_mapping_key	pay_code_mapping	decimal(15)		Table
pay_code_rate_key	pay_code_rate	decimal(15)		Table
payee	vendor_payment	varchar(128)		Table
payee_name	vendor_org	varchar(255)		Table
payment_amount	customer_payment	decimal(18,2)		Table
	customer_payment_activity	decimal(38,2)		View
	vendor_payment	decimal(18,2)		Table
	vendor_payment_activity	decimal(38,2)		View
payment_currency_key	person	decimal(15)		Table
payment_method	posting_group_source	char(1)	('N')	Table
	request_expense_data	varchar(100)		Table
payment_method_code	payment_method	varchar(25)		Table
payment_method_key	customer_payment	decimal(15)		Table
	expense_data	decimal(15)		Table
	imported_expense_data	decimal(15)		Table
	payment_method	decimal(15)		Table
	payment_method_account	decimal(15)		Table
	person	decimal(15)		Table
	vendor_payment	decimal(15)		Table
payment_on_hold	vendor_invoice	char(1)	('N')	Table
	vendor_org	char(1)	('N')	Table
payment_term_code	payment_term	varchar(25)		Table
payment_term_key	customer_org	decimal(15)		Table
	invoice	decimal(15)		Table
	payment_term	decimal(15)		Table
	project_invoice	decimal(15)		Table
	vendor_invoice	decimal(15)		Table
	vendor_org	decimal(15)		Table
pct_complete_rule	project	char(1)	('H')	Table
	project_budget_history	char(1)		Table
pending_adjustment	approval_history	char(1)	('N')	Table
	person_time_data	char(1)	('N')	Table
	person_time_day	char(1)	('N')	Table
pending_head	person_time_data	char(1)	('Y')	Table
	person_time_day	char(1)	('N')	Table
people	business_meeting_detail	varchar(2000)		Table
	entertainment_detail	varchar(2000)		Table
per_diem_mie_breakdown_key	per_diem_mie_breakdown	decimal(15)		Table
per_diem_rate_key	per_diem_rate	decimal(15)		Table
percent_complete	project	decimal(6,3)		Table
	project_budget_history	decimal(6,3)		Table
	project_budget_snapshot	decimal(6,3)		Table
	task	decimal(6,3)		Table
	task_budget_history	decimal(6,3)		Table
	task_budget_snapshot	decimal(6,3)		Table
performed_by	expense_history	decimal(15)		Table
performed_for	expense_history	decimal(15)		Table
period_name	time_period_setup	varchar(20)		Table
period_number	fiscal_month	tinyint		Table
period_type	accrual_plan	char(1)		Table
	resource_request	varchar(10)		Table
periods	resource_request	decimal(2)		Table
person	posting_group_source	char(1)	('N')	Table
person_accrual_plan_key	person_accrual	decimal(15)		Table
	person_accrual_plan	decimal(15)		Table
person_active	assignment_view	char(1)		View
person_bill_rate	assignment_view	decimal(15,5)		View
person_code	person	varchar(25)		Table
person_cost_rate	assignment_view	decimal(15,5)		View
person_customer_code	assignment_view	varchar(25)		View
person_customer_key	assignment_view	decimal(15)		View
person_key	adhoc_criteria_set	decimal(15)		Table
	alternate	decimal(15)		Table
	approval_chain	decimal(15)		Table
	approval_history	decimal(15)		Table
	assignment_display	decimal(15)		Table
	assignment_view	decimal(15)		View
	batch	decimal(15)		Table
	column_width_criteria	decimal(15)		Table
	credit_card	decimal(15)		Table
	criteria_set	decimal(15)		Table
	dashboard_chart	decimal(15)		Table
	dashboard_list	decimal(15)		Table
	dashboard_section	decimal(15)		Table
	fin_document_detail	decimal(15)		Table
	general_alert_prefs	decimal(15)		Table
	general_ledger	decimal(15)		Table
	journal_view	decimal(15)		View
	leave_request	decimal(15)		Table
	leave_request_approval	decimal(15)		Table
	list_criteria	decimal(15)		Table
	list_criteria_set	decimal(15)		Table
	member	decimal(15)		Table
	org_access_person	decimal(15)		Table
	password_reset_request	decimal(15)		Table
	payroll	decimal(15)		Table
	person	decimal(15)		Table
	person_account	decimal(15)		Table
	person_accrual	decimal(15)		Table
	person_accrual_plan	decimal(15)		Table
	person_rate	decimal(15)		Table
	person_time	decimal(15)		Table
	planned_time	decimal(15)		Table
	project_alert_recipient	decimal(15)		Table
	project_assignment	decimal(15)		Table
	project_controller	decimal(15)		Table
	project_criteria_set	decimal(15)		Table
	resource_request_history	decimal(15)		Table
	skill_assignment	decimal(15)		Table
	task_alert_recipient	decimal(15)		Table
	task_assignment	decimal(15)		Table
person_labor_category	assignment_view	varchar(50)		View
person_labor_category_key	assignment_view	decimal(15)		View
person_location	assignment_view	varchar(50)		View
person_location_key	assignment_view	decimal(15)		View
person_rate_key	person_rate	decimal(15)		Table
person_time_key	approval_history	decimal(15)		Table
	manager_approval_status	decimal(15)		Table
	person_time	decimal(15)		Table
	person_time_data	decimal(15)		Table
	person_time_data_history	decimal(15)		Table
	person_time_day	decimal(15)		Table
	time_cust_approval_status	decimal(15)		Table
personal_calls	cell_phone_detail	decimal(15,3)		Table
phone	billing_info	varchar(25)		Table
	contact_phone	varchar(120)		Table
plan_set_history_key	plan_set_history	decimal(15)		Table
plan_set_key	expense_plan	decimal(15)		Table
	plan_set	decimal(15)		Table
	plan_set_history	decimal(15)		Table
	planned_time	decimal(15)		Table
	resource_request	decimal(15)		Table
plan_set_name	plan_set_name	varchar(20)		Table
plan_set_name_key	plan_set	decimal(15)		Table
	plan_set_name	decimal(15)		Table
planned_hours	planned_time	decimal(15,2)		Table
planned_time_key	planned_time	decimal(15)		Table
planner_key	res_req_planner	decimal(15)		Table
pm_open	project	char(1)	('Y')	Table
post_account_key	cost_pool_basis	decimal(15)		Table
	cost_pool_basis_calc	decimal(15)		Table
	cost_pool_source	decimal(15)		Table
	cost_pool_source_calc	decimal(15)		Table
post_customer_key	cost_pool_basis	decimal(15)		Table
	cost_pool_basis_calc	decimal(15)		Table
	cost_pool_source	decimal(15)		Table
	cost_pool_source_calc	decimal(15)		Table
post_date	customer_invoice_activity	timestamp		View
	customer_payment_activity	timestamp		View
	expense_report	timestamp		Table
	fin_document	timestamp		Table
	general_ledger	timestamp		Table
	invoice	timestamp		Table
	person_time_data	timestamp		Table
	person_time_day	timestamp		Table
	vendor_invoice_activity	timestamp		View
	vendor_payment_activity	timestamp		View
post_fiscal_month_key	cost_pool_group_calc	decimal(15)		Table
post_history_key	cost_plus_post_detail	decimal(15)		Table
	expense_data_allocation	decimal(15)		Table
	fee_cap_adjustment	decimal(15)		Table
	fin_document_detail_expense	decimal(15)		Table
	fixed_price	decimal(15)		Table
	fp_revenue_schedule	decimal(15)		Table
	funding_cap_adjustment	decimal(15)		Table
	journal_cost_plus_detail	decimal(15)		Table
	journal_document_expense	decimal(15)		Table
	journal_expense	decimal(15)		Table
	journal_fee_cap_adjustment	decimal(15)		Table
	journal_fixed_price	decimal(15)		Table
	journal_funding_cap_adjustment	decimal(15)		Table
	journal_prebilled_labor	decimal(15)		Table
	journal_time	decimal(15)		Table
	journal_view	decimal(15)		View
	person_time_data	decimal(15)		Table
	post_history	decimal(15)		Table
	prebilled_labor	decimal(15)		Table
	project_post_history	decimal(15)		Table
post_labor_cross_charge	post_history	char(1)	('N')	Table
post_rate_to_cost_struct	cost_pool	char(1)	('N')	Table
post_timestamp	post_history	timestamp		Table
post_to_gl	cost_pool	char(1)	('N')	Table
	cost_pool_calc	char(1)		Table
	post_history	char(1)		Table
postal_code	address	varchar(16)		Table
posted_by	cost_pool_group_calc	decimal(15)		Table
	fin_document	decimal(15)		Table
posted_by_key	accrual_period	decimal(15)		Table
	person_accrual	decimal(15)		Table
	post_history	decimal(15)		Table
posted_timestamp	accrual_period	timestamp		Table
	cost_pool_group_calc	timestamp		Table
	fin_document	timestamp		Table
	person_accrual	timestamp		Table
posting_emails	accrual_plan	varchar(2000)		Table
posting_group_key	posting_group	decimal(15)		Table
	posting_group_source	decimal(15)		Table
	project	decimal(15)		Table
posting_group_name	posting_group	varchar(50)		Table
posting_group_source_key	posting_group_source	decimal(15)		Table
posting_group_type	posting_group	char(1)		Table
posting_type	accrual_plan	char(1)	('M')	Table
pr_allowed	payment_method	char(1)	('N')	Table
prebilled_labor_key	invcd_prebilled_labor	decimal(15)		Table
	journal_prebilled_labor	decimal(15)		Table
	prebilled_labor	decimal(15)		Table
predecessor_key	task_depends	decimal(15)		Table
prefered	vendor	char(1)		Table
prefix	invoice_number	varchar(25)		Table
prevent_auto_removal	time_period	char(1)	('N')	Table
primary_ind	contact_address	char(1)	('N')	Table
	contact_email	char(1)	('N')	Table
	contact_phone	char(1)	('N')	Table
	project_controller	char(1)		Table
	res_req_planner	char(1)	('N')	Table
printed_by	check_print_history	decimal(15)		Table
	invoice	decimal(15)		Table
printed_ind	check_print_history	char(1)	('N')	Table
printed_timestamp	check_print_history	timestamp		Table
	invoice	timestamp		Table
priority_level	approval_chain	decimal(3)		Table
probability_percent	project	decimal(3)	((100))	Table
	project_budget_history	decimal(3)		Table
process_sequence	cost_struct_pool	smallint		Table
proficiency_key	proficiency	decimal(15)		Table
	resource_request_skill	decimal(15)		Table
	skill_assignment	decimal(15)		Table
proficiency_name	proficiency	varchar(50)		Table
proj_require_time_comments	project	char(1)		Table
project	posting_group_source	char(1)	('N')	Table
project_assignment_key	project_assignment	decimal(15)	((0))	Table
project_budget_history_key	project_budget_history	decimal(15)		Table
project_budget_snapshot_key	project_budget_snapshot	decimal(15)		Table
project_code	assignment_view	varchar(30)		View
	expense_budget_view	varchar(30)		View
	journal_view	varchar(30)		View
	project	varchar(30)		Table
project_color	project	varchar(16)	('green')	Table
project_controller_key	project_controller	decimal(15)	((0))	Table
project_criteria	project_criteria_value	clob		Table
project_criteria_set_key	project_criteria_set	decimal(15)		Table
	project_criteria_value	decimal(15)		Table
project_customer_code	assignment_view	varchar(25)		View
	journal_view	varchar(25)		View
project_customer_key	assignment_view	decimal(15)		View
	journal_view	decimal(15)		View
project_key	approval_history	decimal(15)		Table
	assignment_display	decimal(15)		Table
	assignment_view	decimal(15)		View
	cost_plus_post_detail	decimal(15)		Table
	customer_assignment	decimal(15)		Table
	exp_cust_approval_status	decimal(15)		Table
	expense_budget_view	decimal(15)		View
	expense_data_allocation	decimal(15)		Table
	expense_history	decimal(15)		Table
	expense_plan	decimal(15)		Table
	expense_pm_approval_status	decimal(15)		Table
	expense_project_allocation	decimal(15)		Table
	expense_project_budget	decimal(15)		Table
	expense_task_budget	decimal(15)		Table
	fee_cap_adjustment	decimal(15)		Table
	fin_document_detail_project	decimal(15)		Table
	fixed_price	decimal(15)		Table
	funding_cap_adjustment	decimal(15)		Table
	general_ledger	decimal(15)		Table
	holiday	decimal(15)		Table
	invcd_project	decimal(15)		Table
	invoice	decimal(15)		Table
	journal_cost_plus_detail	decimal(15)		Table
	journal_document_expense	decimal(15)		Table
	journal_expense	decimal(15)		Table
	journal_fee_cap_adjustment	decimal(15)		Table
	journal_fixed_price	decimal(15)		Table
	journal_funding_cap_adjustment	decimal(15)		Table
	journal_onetime_charge	decimal(15)		Table
	journal_prebilled_labor	decimal(15)		Table
	journal_time	decimal(15)		Table
	journal_view	decimal(15)		View
	labor_category_assignment	decimal(15)		Table
	manager_approval_status	decimal(15)		Table
	onetime_charge	decimal(15)		Table
	person	decimal(15)		Table
	person_accrual	decimal(15)		Table
	person_accrual_plan	decimal(15)		Table
	person_time_data	decimal(15)		Table
	person_time_data_history	decimal(15)		Table
	plan_set	decimal(15)		Table
	planned_time	decimal(15)		Table
	prebilled_labor	decimal(15)		Table
	project	decimal(15)		Table
	project_account	decimal(15)		Table
	project_alert	decimal(15)		Table
	project_alert_prefs	decimal(15)		Table
	project_assignment	decimal(15)		Table
	project_budget_history	decimal(15)		Table
	project_budget_snapshot	decimal(15)		Table
	project_controller	decimal(15)		Table
	project_criteria_set	decimal(15)		Table
	project_expense_type	decimal(15)		Table
	project_fee	decimal(15)		Table
	project_invoice	decimal(15)		Table
	project_invoice_addl_fmt	decimal(15)		Table
	project_location	decimal(15)		Table
	project_note	decimal(15)		Table
	project_pay_code	decimal(15)		Table
	project_post_history	decimal(15)		Table
	request_allocation	decimal(15)		Table
	resource_request	decimal(15)		Table
	task	decimal(15)		Table
	task_alert	decimal(15)		Table
	task_assignment	decimal(15)		Table
	task_budget_history	decimal(15)		Table
	task_budget_snapshot	decimal(15)		Table
	time_cust_approval_status	decimal(15)		Table
project_manager_key	assignment_view	decimal(15)		View
project_markup	expense_budget_view	decimal(5,2)		View
project_name	request_allocation	varchar(255)		Table
project_note_audit_key	project_note_audit	decimal(15)		Table
project_note_comment_key	note_comment_attachment	decimal(15)		Table
	project_note_comment	decimal(15)		Table
project_note_key	project_note	decimal(15)		Table
	project_note_attachment	decimal(15)		Table
	project_note_audit	decimal(15)		Table
	project_note_comment	decimal(15)		Table
	project_note_role	decimal(15)		Table
project_note_status	project_note_status	varchar(25)		Table
project_note_status_key	project_note	decimal(15)		Table
	project_note_audit	decimal(15)		Table
	project_note_status	decimal(15)		Table
project_note_type	project_note_type	varchar(25)		Table
project_note_type_key	project_note	decimal(15)		Table
	project_note_audit	decimal(15)		Table
	project_note_type	decimal(15)		Table
project_org_code	expense_budget_view	varchar(25)		View
project_required	account	char(1)	('N')	Table
project_show_customer_code	invoice_format	char(1)	('Y')	Table
project_show_project_code	invoice_format	char(1)	('Y')	Table
project_show_title	invoice_format	char(1)	('Y')	Table
project_status_key	assignment_view	decimal(15)		View
	project	decimal(15)		Table
	project_status	decimal(15)		Table
project_type	posting_group_source	char(1)	('N')	Table
	project_type	varchar(10)		Table
	request_expense_data	varchar(25)		Table
project_type_key	assignment_view	decimal(15)		View
	expense_data	decimal(15)		Table
	expense_data_allocation	decimal(15)		Table
	fin_document_detail_project	decimal(15)		Table
	person_time_data	decimal(15)		Table
	person_time_data_history	decimal(15)		Table
	project	decimal(15)		Table
	project_type	decimal(15)		Table
	project_type_account	decimal(15)		Table
	project_type_exp_type_acct	decimal(15)		Table
	task	decimal(15)		Table
property_name	unanet_properties	varchar(200)		Table
	unanet_properties_history	varchar(200)		Table
property_new_value	unanet_properties_history	varchar(4000)		Table
property_old_value	unanet_properties_history	varchar(4000)		Table
property_value	unanet_properties	varchar(4000)		Table
prorated_rate	lodging_allowable_detail	decimal(15,3)	((0.000))	Table
	lodging_per_diem_detail	decimal(15,3)	((0.000))	Table
	mie_allowable_detail	decimal(15,3)	((0.000))	Table
provider	company_car_detail	varchar(32)		Table
provisional_rate	cost_struct_pool_rate	decimal(15,12)	((0))	Table
purpose	entertainment_detail	varchar(2000)		Table
	expense_report	varchar(2000)		Table
	project	varchar(2000)		Table
	request_expense_report	varchar(2000)		Table
quantity	general_ledger	decimal(18,3)		Table
	person_time_data	decimal(15,2)		Table
	person_time_data_history	decimal(15,2)		Table
rate	company_car_detail	decimal(15,4)		Table
	cost_pool_calc	decimal(15,12)		Table
	lodging_allowable_detail	decimal(15,3)	((0.000))	Table
	lodging_per_diem_detail	decimal(15,3)	((0.000))	Table
	mie_allowable_detail	decimal(15,3)	((0.000))	Table
	mie_per_diem_detail	decimal(15,3)		Table
	mileage_detail	decimal(15,4)		Table
	mileage_rate	decimal(15,4)		Table
	pay_code_rate	decimal(15,5)		Table
rate_change	payroll	decimal(10,2)		Table
rate_change_date	payroll	timestamp		Table
rate_update_date	fiscal_year	timestamp		Table
read_receipt_req	project_invoice	char(1)	('N')	Table
receipt_included	expense_data	char(1)		Table
	imported_expense_data	char(1)		Table
	request_expense_data	char(1)		Table
receipt_required	expense_type	char(1)		Table
recipient_name_1099	customer	varchar(128)		Table
recog_pool_rate_type	billing_setup	char(1)		Table
	billing_setup_history	char(1)		Table
	post_history	char(1)		Table
recognize_amount	cost_plus_post_detail	decimal(18,2)		Table
	fee_cap_adjustment	decimal(18,2)		Table
	funding_cap_adjustment	decimal(18,2)		Table
reconciled_by	bank_reconciliation	decimal(15)		Table
reconciled_timestamp	bank_reconciliation	timestamp		Table
record_overage	expense_type	char(1)	('N')	Table
record_type	export_template_data	decimal(5)		Table
reference	fin_document	varchar(25)		Table
	fin_document_detail	varchar(25)		Table
	general_ledger	varchar(25)		Table
registration	company_car_detail	decimal(18,3)		Table
reimbursable	payment_method	char(1)	('N')	Table
remit_to_address_key	project_invoice	decimal(15)		Table
remit_to_city	invoice	varchar(60)		Table
remit_to_contact_key	project_invoice	decimal(15)		Table
remit_to_country	invoice	varchar(60)		Table
remit_to_first_name	invoice	varchar(50)		Table
remit_to_last_name	invoice	varchar(50)		Table
remit_to_middle_initial	invoice	char(1)		Table
remit_to_one_line	invoice_format	char(1)	('N')	Table
remit_to_postal_code	invoice	varchar(16)		Table
remit_to_state_province	invoice	varchar(60)		Table
remit_to_street1	invoice	varchar(255)		Table
remit_to_street2	invoice	varchar(255)		Table
remit_to_street3	invoice	varchar(2000)		Table
remit_to_suffix	invoice	varchar(10)		Table
repairs	company_car_detail	decimal(18,3)		Table
request_allocation_key	request_allocation	decimal(15)		Table
	request_expense_data	decimal(15)		Table
request_allowed	expense_type	char(1)		Table
request_expense_data_key	request_expense_data	decimal(15)		Table
request_expense_report_key	request_allocation	decimal(15)		Table
	request_expense_data	decimal(15)		Table
	request_expense_report	decimal(15)		Table
request_id	password_reset_request	varchar(64)		Table
requestor_key	resource_request	decimal(15)		Table
required	udf_setup	char(1)	('N')	Table
resource_assigner_open	project	char(1)	('Y')	Table
resource_key	res_req_resource	decimal(15)		Table
resource_request_budget_key	resource_request_budget	decimal(15)		Table
resource_request_history_key	resource_request_history	decimal(15)		Table
resource_request_key	planned_time	decimal(15)		Table
	res_req_labor_category	decimal(15)		Table
	res_req_location	decimal(15)		Table
	res_req_planner	decimal(15)		Table
	res_req_resource	decimal(15)		Table
	resource_request	decimal(15)		Table
	resource_request_budget	decimal(15)		Table
	resource_request_history	decimal(15)		Table
	resource_request_skill	decimal(15)		Table
resource_requestor_open	project	char(1)	('Y')	Table
return_date	air_detail	timestamp		Table
	imported_air_detail	timestamp		Table
rev_date	fp_revenue_schedule	timestamp		Table
rev_end_date	project	timestamp		Table
	project_budget_history	timestamp		Table
	project_budget_snapshot	timestamp		Table
	task	timestamp		Table
	task_budget_history	timestamp		Table
	task_budget_snapshot	timestamp		Table
rev_fiscal_month_key	cost_pool_group_calc	decimal(15)		Table
rev_rec_method	fixed_price	decimal(1)		Table
rev_start_date	project	timestamp		Table
	project_budget_history	timestamp		Table
	project_budget_snapshot	timestamp		Table
	task	timestamp		Table
	task_budget_history	timestamp		Table
	task_budget_snapshot	timestamp		Table
reversing	journal_entry	char(1)	('N')	Table
reversing_date	journal_entry	timestamp		Table
reversing_fin_document_key	journal_entry	decimal(15)		Table
review_comments	approval_history	varchar(2000)		Table
	expense_history	varchar(2000)		Table
review_date	approval_history	timestamp		Table
	expense_history	timestamp		Table
review_required	approval_history	char(1)	('N')	Table
	expense_history	char(1)	('N')	Table
revision	dbversion	varchar(25)		Table
right_visit	acct_cost_pool_tree	integer		Table
	acct_fin_tree	integer		Table
	org_cost_pool_tree	integer		Table
	org_fin_tree	integer		Table
	org_tree	integer		Table
	task	decimal(15)		Table
rm_open	project	char(1)	('Y')	Table
role_description	role	varchar(50)		Table
role_key	alternate	decimal(15)		Table
	approval_history	decimal(15)		Table
	expense_history	decimal(15)		Table
	leave_request_approval	decimal(15)		Table
	member	decimal(15)		Table
	org_access_person	decimal(15)		Table
	project_controller	decimal(15)		Table
	project_note_role	decimal(15)		Table
	resource_request_history	decimal(15)		Table
	role	decimal(15)		Table
role_name	role	varchar(25)		Table
room_rate	lodging_detail	decimal(15,3)		Table
round_trip	mileage_detail	char(1)		Table
salutation	customer_contact	varchar(120)		Table
saturday	business_week	char(1)	('N')	Table
season_end_date	per_diem_rate	timestamp		Table
season_start_date	per_diem_rate	timestamp		Table
section_header	udf_entity	varchar(128)		Table
section_id	dashboard_section	varchar(128)		Table
section_order	dashboard_section	decimal(2)		Table
sector	customer	varchar(64)		Table
self_assign_plans	project	char(1)	('N')	Table
separate_payment	vendor_invoice	char(1)	('N')	Table
	vendor_org	char(1)	('N')	Table
sequence	cost_report_element	smallint		Table
	expense_data	integer		Table
	expense_data_allocation	integer		Table
	expense_project_allocation	integer		Table
	fin_document_recurring	integer		Table
	invc_sect_fmt	tinyint		Table
	invoice_addl_fmt	tinyint		Table
	project_invoice_addl_fmt	tinyint		Table
	request_allocation	decimal(3)		Table
	task	integer		Table
serial	project_post_history	integer		Table
servlet_version	dbversion	varchar(25)		Table
	dbversion_history	varchar(25)		Table
shared_criteria_set_key	shared_criteria_set	decimal(15)		Table
	shared_criteria_value	decimal(15)		Table
ship_to_address_key	project_invoice	decimal(15)		Table
ship_to_city	invoice	varchar(60)		Table
ship_to_contact_key	project_invoice	decimal(15)		Table
ship_to_country	invoice	varchar(60)		Table
ship_to_first_name	invoice	varchar(50)		Table
ship_to_last_name	invoice	varchar(50)		Table
ship_to_middle_initial	invoice	char(1)		Table
ship_to_postal_code	invoice	varchar(16)		Table
ship_to_state_province	invoice	varchar(60)		Table
ship_to_street1	invoice	varchar(255)		Table
ship_to_street2	invoice	varchar(255)		Table
ship_to_street3	invoice	varchar(2000)		Table
ship_to_suffix	invoice	varchar(10)		Table
show	assignment_display	char(1)	('Y')	Table
	udf_setup	decimal(15)	((0))	Table
show_amount	invc_sect_fmt	char(1)	('Y')	Table
show_bill_date	fixed_price_invc_sect_fmt	char(1)	('N')	Table
	prebill_invc_sect_fmt	char(1)	('N')	Table
show_comment	cost_plus_invc_sect_fmt	char(1)	('N')	Table
	expense_invc_sect_fmt	char(1)	('N')	Table
	labor_invc_sect_fmt	char(1)	('N')	Table
show_company_logo	invoice	char(1)	('N')	Table
	project_invoice	char(1)	('N')	Table
show_contract_number	invoice	char(1)	('N')	Table
	project_invoice	char(1)	('N')	Table
show_cost	expense_invc_sect_fmt	char(1)	('N')	Table
show_date	cost_plus_invc_sect_fmt	char(1)	('N')	Table
	expense_invc_sect_fmt	char(1)	('N')	Table
	labor_invc_sect_fmt	char(1)	('N')	Table
show_description	expense_type	char(1)	('N')	Table
show_hours	cost_plus_invc_sect_fmt	char(1)	('N')	Table
	labor_invc_sect_fmt	char(1)	('N')	Table
show_individually	fixed_price_invc_sect_fmt	char(1)	('N')	Table
	prebill_invc_sect_fmt	char(1)	('N')	Table
show_markup_multiplier	expense_invc_sect_fmt	char(1)	('N')	Table
show_markup_percent	expense_invc_sect_fmt	char(1)	('N')	Table
show_order_number	invoice	char(1)	('N')	Table
	project_invoice	char(1)	('N')	Table
show_proj_code	invoice	char(1)	('N')	Table
	project_invoice	char(1)	('N')	Table
show_proj_funded_value	invoice	char(1)	('N')	Table
	project_invoice	char(1)	('N')	Table
show_proj_org_code	invoice	char(1)	('N')	Table
	project_invoice	char(1)	('N')	Table
show_proj_rem_funded	invoice_format	char(1)	('N')	Table
show_proj_title	invoice	char(1)	('N')	Table
	project_invoice	char(1)	('N')	Table
show_project_funded_value	invoice_format	char(1)	('N')	Table
show_project_order_number	invoice_format	char(1)	('N')	Table
show_rate	cost_plus_invc_sect_fmt	char(1)	('N')	Table
	labor_invc_sect_fmt	char(1)	('N')	Table
show_section_total	invc_sect_fmt	char(1)	('Y')	Table
show_task_funded_value	invoice_format	char(1)	('N')	Table
show_task_rem_funded	invoice_format	char(1)	('N')	Table
show_to_approver	general_alert_prefs	char(1)	('N')	Table
	project_alert_prefs	char(1)	('N')	Table
show_to_approver_alt	general_alert_prefs	char(1)	('N')	Table
	project_alert_prefs	char(1)	('N')	Table
show_to_lead	general_alert_prefs	char(1)	('N')	Table
	project_alert_prefs	char(1)	('N')	Table
show_to_lead_alt	general_alert_prefs	char(1)	('N')	Table
	project_alert_prefs	char(1)	('N')	Table
show_to_pm	general_alert_prefs	char(1)	('N')	Table
	project_alert_prefs	char(1)	('N')	Table
show_to_pm_alt	general_alert_prefs	char(1)	('N')	Table
	project_alert_prefs	char(1)	('N')	Table
sic_code	customer	varchar(10)		Table
sign_field	adp_setup	char(1)		Table
skill_key	resource_request_skill	decimal(15)		Table
	skill	decimal(15)		Table
	skill_assignment	decimal(15)		Table
skill_name	skill	varchar(50)		Table
skill_type_key	skill	decimal(15)		Table
	skill_type	decimal(15)		Table
skill_type_name	skill_type	varchar(50)		Table
sort_order	cost_element	integer	((0))	Table
	proficiency	decimal(15)	((0))	Table
	udf_option	decimal(15)	((0))	Table
source_ind	person_accrual	char(1)	('I')	Table
source_period	cost_pool	char(1)	('Y')	Table
special_situation	lodging_allowable_detail	char(1)	('N')	Table
	lodging_per_diem_detail	char(1)	('N')	Table
ssn	person	varchar(11)		Table
start_time	person_time_data_tito	timestamp		Table
	person_time_data_tito_history	timestamp		Table
	person_time_day_tito	timestamp		Table
start_with	invoice_number	decimal(5)		Table
start_with_project_code_seq	customer	decimal(15)	((1))	Table
	project_type	decimal(15)	((1))	Table
state	billing_info	varchar(5)		Table
state_province	address	varchar(60)		Table
state_worked_in	payroll	varchar(2)		Table
statement_date	bank_reconciliation	timestamp		Table
status	approval_history	varchar(25)		Table
	expense_history	varchar(25)		Table
	expense_report	varchar(25)		Table
	leave_request	varchar(25)		Table
	leave_request_approval	varchar(25)		Table
	person_time	varchar(25)		Table
	project_status	varchar(50)		Table
	request_expense_report	varchar(255)		Table
	resource_request	varchar(25)		Table
	resource_request_history	varchar(25)		Table
	task	varchar(50)		Table
	unanet_access	char(1)	('N')	Table
status_date	resource_request	timestamp		Table
	resource_request_history	timestamp		Table
status_timestamp	leave_request	timestamp		Table
	leave_request_approval	timestamp		Table
stock_symbol	customer	varchar(10)		Table
stop_time	person_time_data_tito	timestamp		Table
	person_time_data_tito_history	timestamp		Table
	person_time_day_tito	timestamp		Table
street1	address	varchar(255)		Table
	billing_info	varchar(100)		Table
street2	address	varchar(255)		Table
	billing_info	varchar(100)		Table
street3	address	varchar(2000)		Table
subject	email_template	varchar(250)		Table
submitted_by	fin_document	decimal(15)		Table
submitted_timestamp	fin_document	timestamp		Table
succeed_flag	dbversion_patch	char(1)		Table
successor_key	task_depends	decimal(15)		Table
suffix	customer_contact	varchar(10)		Table
	person	varchar(10)		Table
sui_tax_code	payroll	varchar(10)		Table
summary	expense_data	varchar(2000)		Table
	request_expense_data	varchar(2000)		Table
sunday	business_week	char(1)	('N')	Table
system_default	plan_set_name	char(1)	('N')	Table
table_name	sequence_number	varchar(50)		Table
target_path	criteria_set	varchar(128)		Table
	shared_criteria_set	varchar(128)		Table
target_rate	cost_struct_pool_rate	decimal(15,12)	((0))	Table
task	posting_group_source	char(1)	('N')	Table
task_assignment_key	task_assignment	decimal(15)	((0))	Table
task_budget_history_key	task_budget_history	decimal(15)		Table
task_budget_snapshot_key	task_budget_snapshot	decimal(15)		Table
task_group_level	invoice_format	tinyint	((0))	Table
task_id	task	integer		Table
task_key	assignment_display	decimal(15)		Table
	assignment_view	decimal(15)		View
	expense_budget_view	decimal(15)		View
	expense_data_allocation	decimal(15)		Table
	expense_plan	decimal(15)		Table
	expense_project_allocation	decimal(15)		Table
	expense_task_budget	decimal(15)		Table
	fin_document_detail_project	decimal(15)		Table
	fixed_price	decimal(15)		Table
	funding_cap_adjustment	decimal(15)		Table
	holiday	decimal(15)		Table
	journal_view	decimal(15)		View
	onetime_charge	decimal(15)		Table
	person	decimal(15)		Table
	person_accrual	decimal(15)		Table
	person_accrual_plan	decimal(15)		Table
	person_time_data	decimal(15)		Table
	person_time_data_history	decimal(15)		Table
	planned_time	decimal(15)		Table
	request_allocation	decimal(15)		Table
	resource_request	decimal(15)		Table
	task	decimal(15)		Table
	task_account	decimal(15)		Table
	task_alert	decimal(15)		Table
	task_assignment	decimal(15)		Table
	task_budget_history	decimal(15)		Table
	task_budget_snapshot	decimal(15)		Table
task_level_assignment	project	char(1)	('N')	Table
task_name	assignment_view	varchar(50)		View
	expense_budget_view	varchar(50)		View
	journal_view	varchar(50)		View
	request_allocation	varchar(255)		Table
	task	varchar(50)		Table
task_number	task	varchar(128)		Table
task_show_name	invoice_format	char(1)	('Y')	Table
task_show_number	invoice_format	char(1)	('Y')	Table
tax	lodging_detail	decimal(15,3)		Table
tbd_user	person	char(1)	('N')	Table
template_type	export_template	varchar(25)		Table
text	udf_option	varchar(128)		Table
threshold	expense_type	decimal(18,3)		Table
	project_alert	decimal(3)		Table
	task_alert	decimal(3)		Table
thursday	business_week	char(1)	('Y')	Table
ticket_number	air_detail	varchar(50)		Table
	imported_air_detail	varchar(50)		Table
time_assignment_flag	project	char(1)	('Y')	Table
time_data_key	cost_plus_post_detail	decimal(15)		Table
	invcd_time	decimal(15)		Table
	journal_time	decimal(15)		Table
	journal_view	decimal(15)		View
	person_time_data	decimal(15)		Table
	person_time_data_history	decimal(15)		Table
	person_time_data_tito	decimal(15)		Table
	person_time_data_tito_history	decimal(15)		Table
time_data_tito_key	person_time_data_tito	decimal(15)		Table
	person_time_data_tito_history	decimal(15)		Table
time_date_type	billing_setup	char(1)		Table
	billing_setup_history	char(1)		Table
	post_history	char(1)		Table
time_day_key	person_time_day	decimal(15)		Table
	person_time_day_tito	decimal(15)		Table
time_day_tito_key	person_time_day_tito	decimal(15)		Table
time_elapsed_alert	general_alert_prefs	char(1)	('N')	Table
	project_alert_prefs	char(1)	('N')	Table
time_elapsed_alert_pct	general_alert_prefs	decimal(3)		Table
	project_alert_prefs	decimal(3)		Table
time_period_key	person	decimal(15)		Table
	person_time	decimal(15)		Table
	time_period	decimal(15)		Table
	time_period_setup	decimal(15)		Table
time_vendor_key	person	decimal(15)		Table
timesheet_email	person	char(1)		Table
timesheet_lines	person	char(1)		Table
tires	company_car_detail	decimal(18,3)		Table
title	customer_contact	varchar(240)		Table
	project	varchar(2000)		Table
	project_note	varchar(128)		Table
	resource_request	varchar(128)		Table
tito_required	person	char(1)	('N')	Table
	project	char(1)	('N')	Table
to_email	project_invoice	varchar(255)		Table
to_location	air_detail	varchar(100)		Table
	imported_air_detail	varchar(100)		Table
	mileage_detail	varchar(100)		Table
tolls	company_car_detail	decimal(18,3)		Table
took_place	entertainment_detail	char(1)		Table
total_amount	check_print_history	decimal(18,2)	((0))	Table
total_bill	cell_phone_detail	decimal(15,3)		Table
total_bill_alert	general_alert_prefs	char(1)	('N')	Table
	project_alert_prefs	char(1)	('N')	Table
total_bill_alert_denom	general_alert_prefs	char(1)	('B')	Table
	project_alert_prefs	char(1)	('B')	Table
total_bill_alert_pct	general_alert_prefs	decimal(3)		Table
	project_alert_prefs	decimal(3)		Table
total_cost_alert	general_alert_prefs	char(1)	('N')	Table
	project_alert_prefs	char(1)	('N')	Table
total_cost_alert_denom	general_alert_prefs	char(1)	('B')	Table
	project_alert_prefs	char(1)	('B')	Table
total_cost_alert_pct	general_alert_prefs	decimal(3)		Table
	project_alert_prefs	decimal(3)		Table
total_expenses	expense_report	decimal(18,3)		Table
	request_expense_report	decimal(18,3)		Table
total_ind	cost_report_element	char(1)	('N')	Table
total_value	project	decimal(15,2)		Table
	project_budget_history	decimal(15,2)		Table
transaction_data_key	journal_view	decimal(15)		View
transaction_date	fin_document_detail	timestamp		Table
	general_ledger	timestamp		Table
tree_level	acct_cost_pool_tree	integer		Table
	acct_fin_tree	integer		Table
	org_cost_pool_tree	integer		Table
	org_fin_tree	integer		Table
	org_tree	integer		Table
ts_task_required	project	char(1)		Table
tuesday	business_week	char(1)	('Y')	Table
type	account	char(1)		Table
	bank_account	char(1)		Table
	budget	char(1)	('I')	Table
	email_template	decimal(3)	((0))	Table
	image_setup	decimal(1)		Table
	invc_sect_fmt	tinyint		Table
	invc_sect_fmt_tot_grp	tinyint		Table
	journal_view	char(1)		View
	task_depends	char(2)		Table
	vendor_payment_1099_view	varchar(2)		View
udf_count	udf_entity	decimal(15)	((10))	Table
udf_number	udf_option	decimal(15)		Table
	udf_setup	decimal(15)		Table
unanet_db_version	dbversion	varchar(50)		Table
	dbversion_history	varchar(50)		Table
unit	mileage_rate_set	decimal(1)		Table
update_date	dbversion	timestamp		Table
	dbversion_history	timestamp		Table
	dbversion_patch	timestamp		Table
update_rates	cost_pool_calc	char(1)		Table
updated_timestamp	unanet_properties_history	timestamp	(getdate())	Table
updater_key	unanet_properties_history	decimal(15)		Table
url	customer	varchar(128)		Table
	image_setup	varchar(128)		Table
	task	varchar(128)		Table
use_financial_orgs	post_history	char(1)		Table
use_in_rev_report	cost_report_element	char(1)	('N')	Table
use_labor_category	project	char(1)	('O')	Table
use_wbs_dates	assignment_view	char(1)		View
	expense_budget_view	char(1)		View
	expense_plan	char(1)	('N')	Table
	expense_project_budget	char(1)	('N')	Table
	expense_task_budget	char(1)	('N')	Table
	planned_time	char(1)	('N')	Table
	project_assignment	char(1)	('N')	Table
	task_assignment	char(1)	('N')	Table
use_wbs_end_date	fixed_price	char(1)		Table
user01	customer	varchar(128)		Table
	customer_org	varchar(128)		Table
	expense_type	varchar(128)		Table
	person	varchar(128)		Table
	project	varchar(128)		Table
	project_assignment	varchar(128)		Table
	project_note	varchar(128)		Table
	project_note_audit	varchar(128)		Table
	task	varchar(128)		Table
	task_assignment	varchar(128)		Table
	vendor_org	varchar(128)		Table
user02	customer	varchar(128)		Table
	customer_org	varchar(128)		Table
	expense_type	varchar(128)		Table
	person	varchar(128)		Table
	project	varchar(128)		Table
	project_assignment	varchar(128)		Table
	project_note	varchar(128)		Table
	project_note_audit	varchar(128)		Table
	task	varchar(128)		Table
	task_assignment	varchar(128)		Table
	vendor_org	varchar(128)		Table
user03	customer	varchar(128)		Table
	customer_org	varchar(128)		Table
	expense_type	varchar(128)		Table
	person	varchar(128)		Table
	project	varchar(128)		Table
	project_assignment	varchar(128)		Table
	project_note	varchar(128)		Table
	project_note_audit	varchar(128)		Table
	task	varchar(128)		Table
	task_assignment	varchar(128)		Table
	vendor_org	varchar(128)		Table
user04	customer	varchar(128)		Table
	customer_org	varchar(128)		Table
	expense_type	varchar(128)		Table
	person	varchar(128)		Table
	project	varchar(128)		Table
	project_assignment	varchar(128)		Table
	project_note	varchar(128)		Table
	project_note_audit	varchar(128)		Table
	task	varchar(128)		Table
	task_assignment	varchar(128)		Table
	vendor_org	varchar(128)		Table
user05	customer	varchar(128)		Table
	customer_org	varchar(128)		Table
	expense_type	varchar(128)		Table
	person	varchar(128)		Table
	project	varchar(128)		Table
	project_assignment	varchar(128)		Table
	project_note	varchar(128)		Table
	project_note_audit	varchar(128)		Table
	task	varchar(128)		Table
	task_assignment	varchar(128)		Table
	vendor_org	varchar(128)		Table
user06	customer	varchar(128)		Table
	customer_org	varchar(128)		Table
	expense_type	varchar(128)		Table
	person	varchar(128)		Table
	project	varchar(128)		Table
	project_note	varchar(128)		Table
	project_note_audit	varchar(128)		Table
	task	varchar(128)		Table
	vendor_org	varchar(128)		Table
user07	customer	varchar(128)		Table
	customer_org	varchar(128)		Table
	expense_type	varchar(128)		Table
	person	varchar(128)		Table
	project	varchar(128)		Table
	project_note	varchar(128)		Table
	project_note_audit	varchar(128)		Table
	task	varchar(128)		Table
	vendor_org	varchar(128)		Table
user08	customer	varchar(128)		Table
	customer_org	varchar(128)		Table
	expense_type	varchar(128)		Table
	person	varchar(128)		Table
	project	varchar(128)		Table
	project_note	varchar(128)		Table
	project_note_audit	varchar(128)		Table
	task	varchar(128)		Table
	vendor_org	varchar(128)		Table
user09	customer	varchar(128)		Table
	customer_org	varchar(128)		Table
	expense_type	varchar(128)		Table
	person	varchar(128)		Table
	project	varchar(128)		Table
	project_note	varchar(128)		Table
	project_note_audit	varchar(128)		Table
	task	varchar(128)		Table
	vendor_org	varchar(128)		Table
user10	customer	varchar(128)		Table
	customer_org	varchar(128)		Table
	expense_type	varchar(128)		Table
	person	varchar(128)		Table
	project	varchar(128)		Table
	project_note	varchar(128)		Table
	project_note_audit	varchar(128)		Table
	task	varchar(128)		Table
	vendor_org	varchar(128)		Table
user_email	export_template	char(1)	('N')	Table
username	person	varchar(55)		Table
value	export_template_data	varchar(4000)		Table
	udf_option	varchar(128)		Table
value_format	cost_report_element	char(1)	('N')	Table
vat_amount	expense_data	decimal(18,3)	((0.000))	Table
	expense_data_allocation	decimal(18,3)	((0.000))	Table
	imported_expense_data	decimal(18,3)		Table
vat_location_key	expense_data	decimal(15)		Table
	expense_data_allocation	decimal(15)		Table
vat_location_name	imported_expense_data	varchar(50)		Table
vehicle_number	company_car_detail	varchar(32)		Table
	person	varchar(32)		Table
vendor	credit_card	varchar(64)		Table
	request_expense_data	varchar(255)		Table
vendor_1099	customer	char(1)	('N')	Table
vendor_invoice_key	expense_data_allocation	decimal(15)		Table
vendor_key	billing_info	decimal(15)		Table
	expense_data	decimal(15)		Table
	expense_type_vendor_assignment	decimal(15)		Table
	vendor	decimal(15)		Table
vendor_name	expense_data	varchar(255)		Table
	imported_expense_data	varchar(255)		Table
vendor_org_key	vendor_invoice	decimal(15)		Table
	vendor_org	decimal(15)		Table
	vendor_payment	decimal(15)		Table
vendor_required	expense_type	char(1)		Table
version	data_version	decimal(15)		Table
	plan_set	decimal(3)		Table
view_id	adhoc_criteria_set	varchar(50)		Table
viewer_open	project	char(1)	('Y')	Table
voided_by	cost_pool_group_calc	decimal(15)		Table
voided_fin_document_key	fin_document	decimal(15)		Table
voided_invoice_key	invoice	decimal(15)		Table
voided_timestamp	cost_pool_group_calc	timestamp		Table
voiding_document_number	cost_pool_calc	varchar(15)		Table
voiding_fin_document_key	fin_document	decimal(15)		Table
voiding_invoice_key	invoice	decimal(15)		Table
voucher_number	request_expense_report	decimal(15)		Table
was_read	project_alert_recipient	char(1)	('N')	Table
	task_alert_recipient	char(1)	('N')	Table
wednesday	business_week	char(1)	('Y')	Table
wizard_type	expense_type	decimal(2)		Table
	imported_expense_data	decimal(2)		Table
work_date	person_time_data	timestamp		Table
	person_time_data_history	timestamp		Table
	person_time_day	timestamp		Table
writeoff	customer_invoice_activity	decimal(38,2)		View
	customer_payment_activity	decimal(38,2)		View
writeoff_amount	customer_payment_included_inv	decimal(18,2)	((0))	Table
	invcd_cost_plus_post_detail	decimal(18,2)		Table
	invcd_document_expense	decimal(18,2)		Table
	invcd_expense	decimal(18,2)		Table
	invcd_fee_cap_adjustment	decimal(18,2)		Table
	invcd_fixed_price	decimal(18,2)		Table
	invcd_funding_cap_adjustment	decimal(18,2)		Table
	invcd_time	decimal(18,2)		Table
	journal_view	decimal(18,2)		View
writeoff_bill_rate	invcd_time	decimal(15,5)		Table
	journal_view	decimal(15,5)		View
writeoff_cost	invcd_document_expense	decimal(18,2)		Table
	invcd_expense	decimal(18,2)		Table
	journal_view	decimal(18,2)		View
writeoff_general_ledger_key	customer_payment_included_inv	decimal(15)		Table
writeoff_markup	invcd_document_expense	decimal(5,2)		Table
	invcd_expense	decimal(5,2)		Table
	journal_view	decimal(5,2)		View
writeoff_quantity	invcd_cost_plus_post_detail	decimal(15,2)		Table
	invcd_time	decimal(15,2)		Table
	journal_view	decimal(15,2)		View
zip	billing_info	varchar(9)		Table