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_document_item decimal(15)   Table
  journal_document_labor 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
  po_expense_line_descriptor decimal(15)   Table
  po_expnse_consol_all_view decimal(15)   View
  po_expnse_consol_approved_view decimal(15)   View
  po_expnse_consol_view decimal(15)   View
  po_item_consol_all_view decimal(15)   View
  po_item_consol_approved_view decimal(15)   View
  po_item_consol_view decimal(15)   View
  po_item_line_descriptor decimal(15)   Table
  po_labor_consol_all_view decimal(15)   View
  po_labor_consol_approved_view decimal(15)   View
  po_labor_consol_view decimal(15)   View
  po_labor_line_descriptor decimal(15)   Table
  posting_group_source decimal(15)   Table
  pr_expense_line_descriptor decimal(15)   Table
  pr_expnse_consol_all_view decimal(15)   View
  pr_expnse_consol_approved_view decimal(15)   View
  pr_item_consol_all_view decimal(15)   View
  pr_item_consol_approved_view decimal(15)   View
  pr_item_line_descriptor decimal(15)   Table
  pr_labor_consol_all_view decimal(15)   View
  pr_labor_consol_approved_view decimal(15)   View
  pr_labor_line_descriptor 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
  vi_funding_cap_adjustment decimal(15)   Table
  vi_included_expense decimal(15)   Table
  vi_included_time 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
  item char(1) ('Y') 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
  po_format char(1)   Table
  posting_group char(1) ('Y') Table
  project_type char(1) ('Y') Table
  task char(1)   Table
  udf_setup char(1) ('N') Table
  unit_of_measure char(1) ('Y') 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
  fin_document_detail_item decimal(18,2)   Table
  fin_document_detail_labor 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_document_item decimal(18,2)   Table
  journal_document_labor 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
  po_consol_all_view decimal(38,2)   View
  po_consol_approved_view decimal(38,2)   View
  po_consol_view decimal(38,2)   View
  po_expense_line decimal(18,2)   Table
  po_expnse_consol_all_view decimal(38,2)   View
  po_expnse_consol_approved_view decimal(38,2)   View
  po_expnse_consol_view decimal(38,2)   View
  po_item_consol_all_view decimal(38,2)   View
  po_item_consol_approved_view decimal(38,2)   View
  po_item_consol_view decimal(38,2)   View
  po_item_line decimal(18,2)   Table
  po_labor_consol_all_view decimal(38,2)   View
  po_labor_consol_approved_view decimal(38,2)   View
  po_labor_consol_view decimal(38,2)   View
  po_labor_line decimal(18,2)   Table
  pr_consol_all_view decimal(38,2)   View
  pr_consol_approved_view decimal(38,2)   View
  pr_expense_line decimal(18,2)   Table
  pr_expnse_consol_all_view decimal(38,2)   View
  pr_expnse_consol_approved_view decimal(38,2)   View
  pr_item_consol_all_view decimal(38,2)   View
  pr_item_consol_approved_view decimal(38,2)   View
  pr_item_line decimal(18,2)   Table
  pr_labor_consol_all_view decimal(38,2)   View
  pr_labor_consol_approved_view decimal(38,2)   View
  pr_labor_line decimal(18,2)   Table
  prebilled_labor decimal(18,3)   Table
  purchase_order decimal(18,2)   Table
  purchase_requisition decimal(18,2)   Table
  request_expense_data decimal(15,3)   Table
  request_expense_report decimal(18,3)   Table
  vi_funding_cap_adjustment decimal(18,2)   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_group_type chain tinyint   Table
approval_history_key approval_history decimal(15)   Table
approval_type approval_group_submitter tinyint   Table
  project_controller tinyint   Table
approved exp_cust_approval_status char(1)   Table
  expense_pm_approval_status char(1)   Table
  manager_approval_status char(1)   Table
  po_cust_approval_status char(1)   Table
  po_pm_approval_status char(1)   Table
  pr_cust_approval_status char(1)   Table
  pr_pm_approval_status char(1)   Table
  time_cust_approval_status char(1)   Table
  vi_cust_approval_status char(1)   Table
  vi_pm_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
attached_by attachment_reference decimal(15)   Table
attached_timestamp attachment_reference varchar(10)   Table
attachment_data attachment blob   Table
attachment_key attachment decimal(15)   Table
  attachment_reference 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
  shared_document decimal(15)   Table
attachment_length attachment decimal(15)   Table
attachment_mime_type attachment varchar(255)   Table
attachment_name attachment varchar(255)   Table
attachment_reference_key attachment_reference decimal(15)   Table
  po_attachment_reference decimal(15)   Table
  pr_attachment_reference decimal(15)   Table
attendees business_meeting_detail integer   Table
audit_trail change_reason char(1) ('N') Table
auto_correct_rounding invoice 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 po_format_options varchar(255)   Table
  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
  item_uom_rate 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
  po_consol_all_view timestamp   View
  po_consol_approved_view timestamp   View
  po_consol_view timestamp   View
  po_expense_assignment timestamp   Table
  po_expense_line timestamp   Table
  po_expnse_consol_all_view timestamp   View
  po_expnse_consol_approved_view timestamp   View
  po_expnse_consol_view timestamp   View
  po_item_consol_all_view timestamp   View
  po_item_consol_approved_view timestamp   View
  po_item_consol_view timestamp   View
  po_item_line timestamp   Table
  po_labor_assignment timestamp   Table
  po_labor_consol_all_view timestamp   View
  po_labor_consol_approved_view timestamp   View
  po_labor_consol_view timestamp   View
  po_labor_line timestamp   Table
  pr_expense_line timestamp ('01/01/1900') Table
  pr_expnse_consol_all_view timestamp   View
  pr_expnse_consol_approved_view timestamp   View
  pr_item_consol_all_view timestamp   View
  pr_item_consol_approved_view timestamp   View
  pr_item_line timestamp ('01/01/1900') Table
  pr_labor_consol_all_view timestamp   View
  pr_labor_consol_approved_view timestamp   View
  pr_labor_line timestamp ('01/01/1900') Table
  project_assignment timestamp ('01/01/1900') Table
  project_item_uom_rate timestamp   Table
  purchase_order timestamp   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
  fin_document_detail_item decimal(15,5)   Table
  fin_document_detail_labor decimal(18,2)   Table
  funding_cap_adjustment decimal(18,2)   Table
bill_by item char(1)   Table
  project_item char(1)   Table
bill_by_method_type bill_by_method_type_invc_fltr char(1)   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_markup item_uom_rate decimal(5,2)   Table
  project_item_uom_rate decimal(5,2) ((0)) 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
  fin_document_detail_item decimal(15,5)   Table
  fin_document_detail_labor decimal(15,5)   Table
  item_uom_rate decimal(15,5)   Table
  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
  project_item_uom_rate decimal(15,5) ((0)) 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 po_format_options decimal(15)   Table
  project_invoice decimal(15)   Table
bill_to_city invoice varchar(60)   Table
bill_to_contact_key po_format_options decimal(15)   Table
  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_open_access_view varchar(1)   View
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_open_access_view varchar(1)   View
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_document_item tinyint   Table
  journal_document_labor 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 po_format_options varchar(255)   Table
  project_invoice varchar(255)   Table
chain_key approval_chain decimal(15)   Table
  approval_group_submitter decimal(15)   Table
  chain decimal(15)   Table
  purchase_order decimal(15)   Table
  purchase_requisition decimal(15)   Table
  vendor_invoice 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_date po_consol_all_view timestamp   View
  po_consol_approved_view timestamp   View
  po_consol_view timestamp   View
  po_expense_line_descriptor timestamp   Table
  po_expnse_consol_all_view timestamp   View
  po_expnse_consol_approved_view timestamp   View
  po_expnse_consol_view timestamp   View
  po_item_consol_all_view timestamp   View
  po_item_consol_approved_view timestamp   View
  po_item_consol_view timestamp   View
  po_item_line_descriptor timestamp   Table
  po_labor_consol_all_view timestamp   View
  po_labor_consol_approved_view timestamp   View
  po_labor_consol_view timestamp   View
  po_labor_line_descriptor timestamp   Table
  purchase_order timestamp   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
  item varchar(25)   Table
  time_period_setup char(1)   Table
col1_field invc_sect_fmt tinyint   Table
col1_heading invc_sect_fmt varchar(40)   Table
col1_subtotal_amount invc_sect_fmt char(1) ('N') Table
col1_subtotal_itd_qty invc_sect_fmt char(1) ('N') Table
col1_subtotal_qty invc_sect_fmt char(1) ('N') Table
col2_field invc_sect_fmt tinyint   Table
col2_heading invc_sect_fmt varchar(40)   Table
col2_subtotal_amount invc_sect_fmt char(1) ('N') Table
col2_subtotal_itd_qty invc_sect_fmt char(1) ('N') Table
col2_subtotal_qty invc_sect_fmt char(1) ('N') Table
col3_field invc_sect_fmt tinyint   Table
col3_heading invc_sect_fmt varchar(40)   Table
col3_subtotal_amount invc_sect_fmt char(1) ('N') Table
col3_subtotal_itd_qty invc_sect_fmt char(1) ('N') Table
col3_subtotal_qty invc_sect_fmt char(1) ('N') Table
col4_field invc_sect_fmt tinyint   Table
col4_heading invc_sect_fmt varchar(40)   Table
col4_subtotal_amount invc_sect_fmt char(1) ('N') Table
col4_subtotal_itd_qty invc_sect_fmt char(1) ('N') Table
col4_subtotal_qty 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
  fin_document_approval 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
  purchase_order_approval varchar(2000)   Table
  purchase_requisition_approval varchar(2000)   Table
  request_expense_data varchar(2000)   Table
  resource_request_history varchar(2000)   Table
  shared_document varchar(2000)   Table
commitment_date po_consol_view timestamp   View
  purchase_order timestamp   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_hours po_labor_consol_all_view char(1)   View
  po_labor_consol_approved_view char(1)   View
  po_labor_consol_view char(1)   View
  po_labor_line_descriptor char(1) ('N') Table
  pr_labor_consol_all_view char(1)   View
  pr_labor_consol_approved_view char(1)   View
  pr_labor_line_descriptor char(1) ('N') Table
control_key person_time decimal(15)   Table
control_quantity po_item_consol_all_view char(1)   View
  po_item_consol_approved_view char(1)   View
  po_item_consol_view char(1)   View
  po_item_line_descriptor char(1) ('N') Table
  pr_item_consol_all_view char(1)   View
  pr_item_consol_approved_view char(1)   View
  pr_item_line_descriptor char(1) ('N') Table
controller expense_history decimal(15)   Table
  leave_request decimal(15)   Table
controller_key expense_report decimal(15)   Table
  purchase_order decimal(15)   Table
  purchase_requisition decimal(15)   Table
  vendor_invoice decimal(15)   Table
copy_to_po pr_attachment_reference char(1) ('N') 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
  fin_document_det_proj_item decimal(15,5)   Table
  fin_document_det_proj_labor decimal(15,5)   Table
  item_uom_rate decimal(15,5)   Table
  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
  po_labor_assignment decimal(15,5)   Table
  project_assignment decimal(15,5)   Table
  project_item_uom_rate decimal(15,5) ((0)) 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
  fin_document_detail_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
  fin_document_detail_item 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
  shared_document 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
  shared_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
current_po_key po_expnse_consol_view decimal(15)   View
  po_item_consol_view decimal(15)   View
  po_labor_consol_view decimal(15)   View
customer_address_key customer_address decimal(15)   Table
customer_approves_first exp_cust_approval_status char(1)   Table
  po_cust_approval_status char(1)   Table
  pr_cust_approval_status char(1)   Table
  project char(1) ('N') Table
  time_cust_approval_status char(1)   Table
  vi_cust_approval_status char(1)   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_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
  shared_document 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_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 po_format_options char(1)   Table
  project_invoice char(1)   Table
delivery_receipt_req po_format_options char(1) ('N') Table
  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
  attachment_reference 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
  item 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
  po_consol_all_view varchar(128)   View
  po_consol_approved_view varchar(128)   View
  po_consol_view varchar(128)   View
  po_expense_line_descriptor varchar(128)   Table
  po_expnse_consol_all_view varchar(128)   View
  po_expnse_consol_approved_view varchar(128)   View
  po_expnse_consol_view varchar(128)   View
  po_format varchar(128)   Table
  po_item_consol_all_view varchar(128)   View
  po_item_consol_approved_view varchar(128)   View
  po_item_consol_view varchar(128)   View
  po_item_line_descriptor varchar(128)   Table
  po_labor_consol_all_view varchar(128)   View
  po_labor_consol_approved_view varchar(128)   View
  po_labor_consol_view varchar(128)   View
  po_labor_line_descriptor varchar(128)   Table
  posting_group varchar(2000)   Table
  pr_consol_all_view varchar(128)   View
  pr_consol_approved_view varchar(128)   View
  pr_expense_line_descriptor varchar(128)   Table
  pr_expnse_consol_all_view varchar(128)   View
  pr_expnse_consol_approved_view varchar(128)   View
  pr_item_consol_all_view varchar(128)   View
  pr_item_consol_approved_view varchar(128)   View
  pr_item_line_descriptor varchar(128)   Table
  pr_labor_consol_all_view varchar(128)   View
  pr_labor_consol_approved_view varchar(128)   View
  pr_labor_line_descriptor varchar(128)   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
  purchase_order varchar(128)   Table
  purchase_requisition varchar(128)   Table
  resource_request varchar(2000)   Table
  shared_document varchar(128)   Table
  skill varchar(2000)   Table
  skill_type varchar(2000)   Table
  time_period_setup varchar(100)   Table
  unit_of_measure varchar(128)   Table
detail_1099_amount vendor_payment_1099_view decimal(38,6)   View
detail_proj_show_code po_format char(1) ('N') Table
detail_proj_show_org_code po_format char(1) ('N') Table
detail_proj_show_title po_format char(1) ('N') Table
detail_task_show_name po_format char(1) ('N') Table
detail_task_show_number po_format char(1) ('N') Table
detail_type fin_document_detail char(1)   Table
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_consol po_format_options char(1) ('N') Table
display_consol_detail po_format_options char(1) ('N') Table
display_sequence cost_pool smallint   Table
  cost_struct_pool smallint   Table
display_single po_format_options char(1) ('N') Table
document_date fin_document timestamp   Table
  po_consol_view timestamp   View
  purchase_order timestamp   Table
  purchase_requisition timestamp   Table
document_number cost_pool_calc varchar(15)   Table
  fin_document varchar(15)   Table
  general_ledger varchar(50)   Table
  po_consol_all_view varchar(15)   View
  po_consol_approved_view varchar(15)   View
  po_consol_view varchar(15)   View
  post_history varchar(15)   Table
  pr_consol_all_view varchar(15)   View
  pr_consol_approved_view varchar(15)   View
  purchase_order varchar(15)   Table
  purchase_requisition varchar(15)   Table
  shared_document varchar(15)   Table
document_org_key shared_document decimal(15)   Table
document_type document_type_invc_fltr varchar(2)   Table
  fin_document tinyint   Table
dtl_date vendor_payment_1099_view timestamp   View
dtl_reference vendor_payment_1099_view varchar(55)   View
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
  po_format_options decimal(15)   Table
  project_invoice decimal(15)   Table
email_with_po po_attachment_reference char(1) ('N') Table
emailed_by invoice decimal(15)   Table
  purchase_order decimal(15)   Table
emailed_timestamp invoice timestamp   Table
  purchase_order 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
  item_uom_rate 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
  po_consol_all_view timestamp   View
  po_consol_approved_view timestamp   View
  po_consol_view timestamp   View
  po_expense_assignment timestamp   Table
  po_expense_line timestamp   Table
  po_expnse_consol_all_view timestamp   View
  po_expnse_consol_approved_view timestamp   View
  po_expnse_consol_view timestamp   View
  po_item_consol_all_view timestamp   View
  po_item_consol_approved_view timestamp   View
  po_item_consol_view timestamp   View
  po_item_line timestamp   Table
  po_labor_assignment timestamp   Table
  po_labor_consol_all_view timestamp   View
  po_labor_consol_approved_view timestamp   View
  po_labor_consol_view timestamp   View
  po_labor_line timestamp   Table
  pr_expense_line timestamp ('12/31/2099') Table
  pr_expnse_consol_all_view timestamp   View
  pr_expnse_consol_approved_view timestamp   View
  pr_item_consol_all_view timestamp   View
  pr_item_consol_approved_view timestamp   View
  pr_item_line timestamp ('12/31/2099') Table
  pr_labor_consol_all_view timestamp   View
  pr_labor_consol_approved_view timestamp   View
  pr_labor_line timestamp ('12/31/2099') Table
  project_assignment timestamp ('12/31/2099') Table
  project_item_uom_rate timestamp   Table
  purchase_order timestamp   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
exp_sub_po_required project char(1) ('N') Table
  task char(1) ('P') Table
expected_value po_consol_all_view decimal(18,2)   View
  po_consol_approved_view decimal(18,2)   View
  po_consol_view decimal(18,2)   View
  pr_consol_all_view decimal(18,2)   View
  pr_consol_approved_view decimal(18,2)   View
  purchase_order decimal(18,2)   Table
  purchase_requisition decimal(18,2)   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
  task char(1) ('P') Table
expense_budget_type expense_budget_view integer   View
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
  vi_included_expense decimal(15)   Table
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_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 project_approval_view varchar(1)   View
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_request project_approval_view varchar(1)   View
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(15)   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_det_proj_expense decimal(15)   Table
  fin_document_detail_item decimal(15)   Table
  item decimal(15)   Table
  po_expense_assignment decimal(15)   Table
  po_expense_line_descriptor decimal(15)   Table
  po_expnse_consol_all_view decimal(15)   View
  po_expnse_consol_approved_view decimal(15)   View
  po_expnse_consol_view decimal(15)   View
  pr_expense_line_descriptor decimal(15)   Table
  pr_expnse_consol_all_view decimal(15)   View
  pr_expnse_consol_approved_view decimal(15)   View
  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 item varchar(128)   Table
  pay_code_mapping varchar(15)   Table
external_comments po_consol_all_view varchar(2000)   View
  po_consol_approved_view varchar(2000)   View
  po_consol_view varchar(2000)   View
  po_expense_line varchar(2000)   Table
  po_expnse_consol_all_view varchar(2000)   View
  po_expnse_consol_approved_view varchar(2000)   View
  po_expnse_consol_view varchar(2000)   View
  po_item_consol_all_view varchar(2000)   View
  po_item_consol_approved_view varchar(2000)   View
  po_item_consol_view varchar(2000)   View
  po_item_line varchar(2000)   Table
  po_labor_consol_all_view varchar(2000)   View
  po_labor_consol_approved_view varchar(2000)   View
  po_labor_consol_view varchar(2000)   View
  po_labor_line varchar(2000)   Table
  pr_consol_all_view varchar(2000)   View
  pr_consol_approved_view varchar(2000)   View
  pr_expense_line varchar(2000)   Table
  pr_expnse_consol_all_view varchar(2000)   View
  pr_expnse_consol_approved_view varchar(2000)   View
  pr_item_consol_all_view varchar(2000)   View
  pr_item_consol_approved_view varchar(2000)   View
  pr_item_line varchar(2000)   Table
  pr_labor_consol_all_view varchar(2000)   View
  pr_labor_consol_approved_view varchar(2000)   View
  pr_labor_line varchar(2000)   Table
  purchase_order varchar(2000)   Table
  purchase_requisition varchar(2000)   Table
external_id task decimal(15)   Table
extract_date journal_cost_plus_detail timestamp   Table
  journal_document_expense timestamp   Table
  journal_document_item timestamp   Table
  journal_document_labor 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
fca_key vendor_payment_1099_view decimal(15)   View
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_approval_key fin_document_approval decimal(15)   Table
fin_document_det_expense_key cost_plus_post_detail decimal(15)   Table
fin_document_det_item_key cost_plus_post_detail decimal(15)   Table
fin_document_det_labor_key cost_plus_post_detail decimal(15)   Table
fin_document_detail_key customer_payment_export_view decimal(15)   View
  fin_document_det_proj_expense decimal(15)   Table
  fin_document_det_proj_item decimal(15)   Table
  fin_document_det_proj_labor decimal(15)   Table
  fin_document_detail decimal(15)   Table
  fin_document_detail_expense decimal(15)   Table
  fin_document_detail_item decimal(15)   Table
  fin_document_detail_labor decimal(15)   Table
  fin_document_detail_po decimal(15)   Table
  invcd_document_expense decimal(15)   Table
  invcd_document_item decimal(15)   Table
  invcd_document_labor decimal(15)   Table
  journal_document_expense decimal(15)   Table
  journal_document_item decimal(15)   Table
  journal_document_labor 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_approval 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
  vi_cust_approval_status decimal(15)   Table
  vi_funding_cap_adjustment decimal(15)   Table
  vi_pm_approval_status 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_document_item decimal(15)   Table
  journal_document_labor 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
  vi_funding_cap_adjustment decimal(15)   Table
  vi_included_expense decimal(15)   Table
  vi_included_time decimal(15)   Table
generate_invoice project_invoice char(1) ('N') Table
generate_po_form po_format_options char(1) ('N') Table
gl_customer_key fin_document_detail_expense decimal(15)   Table
  fin_document_detail_item decimal(15)   Table
  fin_document_detail_labor 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
  fin_document_det_proj_labor decimal(15,2) ((0)) Table
  leave_request decimal(15,2)   Table
  po_labor_consol_all_view decimal(38,2)   View
  po_labor_consol_approved_view decimal(38,2)   View
  po_labor_consol_view decimal(38,2)   View
  po_labor_line decimal(15,2)   Table
  pr_labor_consol_all_view decimal(38,2)   View
  pr_labor_consol_approved_view decimal(38,2)   View
  pr_labor_line 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
  po_format 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 labor_invc_sect_fmt char(1) ('N') Table
inception_to_date_qty cost_plus_invc_sect_fmt char(1) ('N') Table
  expense_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(31,7)   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
internal_comments po_consol_all_view varchar(2000)   View
  po_consol_approved_view varchar(2000)   View
  po_consol_view varchar(2000)   View
  po_expense_line varchar(2000)   Table
  po_expnse_consol_all_view varchar(2000)   View
  po_expnse_consol_approved_view varchar(2000)   View
  po_expnse_consol_view varchar(2000)   View
  po_item_consol_all_view varchar(2000)   View
  po_item_consol_approved_view varchar(2000)   View
  po_item_consol_view varchar(2000)   View
  po_item_line varchar(2000)   Table
  po_labor_consol_all_view varchar(2000)   View
  po_labor_consol_approved_view varchar(2000)   View
  po_labor_consol_view varchar(2000)   View
  po_labor_line varchar(2000)   Table
  pr_consol_all_view varchar(2000)   View
  pr_consol_approved_view varchar(2000)   View
  pr_expense_line varchar(2000)   Table
  pr_expnse_consol_all_view varchar(2000)   View
  pr_expnse_consol_approved_view varchar(2000)   View
  pr_item_consol_all_view varchar(2000)   View
  pr_item_consol_approved_view varchar(2000)   View
  pr_item_line varchar(2000)   Table
  pr_labor_consol_all_view varchar(2000)   View
  pr_labor_consol_approved_view varchar(2000)   View
  pr_labor_line varchar(2000)   Table
  purchase_order varchar(2000)   Table
  purchase_requisition varchar(2000)   Table
invc_sect_fmt_key bill_by_method_type_invc_fltr decimal(15)   Table
  cost_element_invc_fltr decimal(15)   Table
  cost_element_type_invc_fltr decimal(15)   Table
  cost_plus_invc_sect_fmt decimal(15)   Table
  document_type_invc_fltr 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
  fin_document_detail_item decimal(15)   Table
  fin_document_detail_labor 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_document_item decimal(15)   Table
  invcd_document_labor 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_document_item decimal(15)   Table
  journal_document_labor 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_assignment_flag project char(1) ('N') Table
  task char(1) ('P') Table
item_description journal_view varchar(128)   View
item_key fin_document_det_proj_item decimal(15)   Table
  item decimal(15)   Table
  item_uom decimal(15)   Table
  item_uom_rate decimal(15)   Table
  po_item_consol_all_view decimal(15)   View
  po_item_consol_approved_view decimal(15)   View
  po_item_consol_view decimal(15)   View
  po_item_line_descriptor decimal(15)   Table
  pr_item_consol_all_view decimal(15)   View
  pr_item_consol_approved_view decimal(15)   View
  pr_item_line_descriptor decimal(15)   Table
  project_item decimal(15)   Table
  project_item_uom_rate decimal(15)   Table
item_task_required project char(1) ('N') Table
item_uom_rate_key item_uom_rate decimal(15)   Table
journal_key journal_cost_plus_detail decimal(15)   Table
  journal_document_expense decimal(15)   Table
  journal_document_item decimal(15)   Table
  journal_document_labor 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_document_item timestamp   Table
  journal_document_labor 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
  fin_document_det_proj_labor decimal(15)   Table
  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
  po_labor_assignment decimal(15)   Table
  po_labor_consol_all_view decimal(15)   View
  po_labor_consol_approved_view decimal(15)   View
  po_labor_consol_view decimal(15)   View
  po_labor_line_descriptor decimal(15)   Table
  pr_labor_consol_all_view decimal(15)   View
  pr_labor_consol_approved_view decimal(15)   View
  pr_labor_line_descriptor 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
  shared_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
  shared_document timestamp   Table
lead_project_key project_invoice_contributor decimal(15)   Table
leave_balance project char(1) ('N') Table
leave_request project_approval_view varchar(1)   View
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
  po_consol_all_view decimal(15)   View
  po_consol_approved_view decimal(15)   View
  po_consol_view decimal(15)   View
  pr_consol_all_view decimal(15)   View
  pr_consol_approved_view decimal(15)   View
  purchase_order decimal(15)   Table
  purchase_requisition decimal(15)   Table
  shared_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
line_id po_expense_line_descriptor tinyint   Table
  po_expnse_consol_all_view tinyint   View
  po_expnse_consol_approved_view tinyint   View
  po_expnse_consol_view tinyint   View
  po_item_consol_all_view tinyint   View
  po_item_consol_approved_view tinyint   View
  po_item_consol_view tinyint   View
  po_item_line_descriptor tinyint   Table
  po_labor_consol_all_view tinyint   View
  po_labor_consol_approved_view tinyint   View
  po_labor_consol_view tinyint   View
  po_labor_line_descriptor tinyint   Table
  pr_expense_line_descriptor tinyint   Table
  pr_expnse_consol_all_view tinyint   View
  pr_expnse_consol_approved_view tinyint   View
  pr_item_consol_all_view tinyint   View
  pr_item_consol_approved_view tinyint   View
  pr_item_line_descriptor tinyint   Table
  pr_labor_consol_all_view tinyint   View
  pr_labor_consol_approved_view tinyint   View
  pr_labor_line_descriptor tinyint   Table
line_po_key po_expnse_consol_all_view decimal(15)   View
  po_expnse_consol_approved_view decimal(15)   View
  po_expnse_consol_view decimal(15)   View
  po_item_consol_all_view decimal(15)   View
  po_item_consol_approved_view decimal(15)   View
  po_item_consol_view decimal(15)   View
  po_labor_consol_all_view decimal(15)   View
  po_labor_consol_approved_view decimal(15)   View
  po_labor_consol_view decimal(15)   View
line_pr_key pr_expnse_consol_all_view decimal(15)   View
  pr_expnse_consol_approved_view decimal(15)   View
  pr_item_consol_all_view decimal(15)   View
  pr_item_consol_approved_view decimal(15)   View
  pr_labor_consol_all_view decimal(15)   View
  pr_labor_consol_approved_view decimal(15)   View
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_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
  section_status 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
  fin_document_detail_item decimal(5,2)   Table
  project_expense_type decimal(5,2)   Table
master_markup expense_budget_view decimal(5,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
mod_number po_consol_all_view smallint   View
  po_consol_approved_view smallint   View
  po_consol_view smallint   View
  pr_consol_all_view smallint   View
  pr_consol_approved_view smallint   View
  purchase_order smallint   Table
  purchase_requisition smallint   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
  item varchar(128)   Table
  list_criteria_set varchar(50)   Table
  onetime_charge_type varchar(50)   Table
  po_format varchar(50)   Table
  project_criteria_set varchar(50)   Table
  shared_criteria_set varchar(50)   Table
  unit_of_measure varchar(25)   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 varchar(1)   View
open_status project_status char(1)   Table
order_by_list export_template varchar(4000)   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_document_item decimal(15)   Table
  journal_document_labor 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
  po_expense_line_descriptor decimal(15)   Table
  po_expnse_consol_all_view decimal(15)   View
  po_expnse_consol_approved_view decimal(15)   View
  po_expnse_consol_view decimal(15)   View
  po_item_consol_all_view decimal(15)   View
  po_item_consol_approved_view decimal(15)   View
  po_item_consol_view decimal(15)   View
  po_item_line_descriptor decimal(15)   Table
  po_labor_consol_all_view decimal(15)   View
  po_labor_consol_approved_view decimal(15)   View
  po_labor_consol_view decimal(15)   View
  po_labor_line_descriptor decimal(15)   Table
  pr_expense_line_descriptor decimal(15)   Table
  pr_expnse_consol_all_view decimal(15)   View
  pr_expnse_consol_approved_view decimal(15)   View
  pr_item_consol_all_view decimal(15)   View
  pr_item_consol_approved_view decimal(15)   View
  pr_item_line_descriptor decimal(15)   Table
  pr_labor_consol_all_view decimal(15)   View
  pr_labor_consol_approved_view decimal(15)   View
  pr_labor_line_descriptor decimal(15)   Table
  shared_document decimal(15)   Table
  vendor_invoice decimal(15)   Table
  vendor_payment decimal(15)   Table
  vendor_payment_unapplied decimal(15)   Table
  vi_funding_cap_adjustment decimal(15)   Table
  vi_included_expense decimal(15)   Table
  vi_included_time 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_po_key po_attachment_reference decimal(15)   Table
  po_consol_all_view decimal(15)   View
  po_consol_approved_view decimal(15)   View
  po_consol_view decimal(15)   View
  po_expense_line_descriptor decimal(15)   Table
  po_expnse_consol_all_view decimal(15)   View
  po_expnse_consol_approved_view decimal(15)   View
  po_expnse_consol_view decimal(15)   View
  po_item_consol_all_view decimal(15)   View
  po_item_consol_approved_view decimal(15)   View
  po_item_consol_view decimal(15)   View
  po_item_line_descriptor decimal(15)   Table
  po_labor_consol_all_view decimal(15)   View
  po_labor_consol_approved_view decimal(15)   View
  po_labor_consol_view decimal(15)   View
  po_labor_line_descriptor decimal(15)   Table
  purchase_order decimal(15)   Table
orig_pr_key pr_attachment_reference decimal(15)   Table
  pr_consol_all_view decimal(15)   View
  pr_consol_approved_view decimal(15)   View
  pr_expense_line_descriptor decimal(15)   Table
  pr_expnse_consol_all_view decimal(15)   View
  pr_expnse_consol_approved_view decimal(15)   View
  pr_item_consol_all_view decimal(15)   View
  pr_item_consol_approved_view decimal(15)   View
  pr_item_line_descriptor decimal(15)   Table
  pr_labor_consol_all_view decimal(15)   View
  pr_labor_consol_approved_view decimal(15)   View
  pr_labor_line_descriptor decimal(15)   Table
  purchase_requisition 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
owning_org_key po_consol_all_view decimal(15)   View
  po_consol_approved_view decimal(15)   View
  po_consol_view decimal(15)   View
  pr_consol_all_view decimal(15)   View
  pr_consol_approved_view decimal(15)   View
  purchase_order decimal(15)   Table
  purchase_requisition decimal(15)   Table
owning_po_key po_expnse_consol_all_view decimal(15)   View
  po_expnse_consol_approved_view decimal(15)   View
  po_expnse_consol_view decimal(15)   View
  po_item_consol_all_view decimal(15)   View
  po_item_consol_approved_view decimal(15)   View
  po_item_consol_view decimal(15)   View
  po_labor_consol_all_view decimal(15)   View
  po_labor_consol_approved_view decimal(15)   View
  po_labor_consol_view decimal(15)   View
owning_pr_key pr_expnse_consol_all_view decimal(15)   View
  pr_expnse_consol_approved_view decimal(15)   View
  pr_item_consol_all_view decimal(15)   View
  pr_item_consol_approved_view decimal(15)   View
  pr_labor_consol_all_view decimal(15)   View
  pr_labor_consol_approved_view decimal(15)   View
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
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
  po_consol_all_view decimal(15)   View
  po_consol_approved_view decimal(15)   View
  po_consol_view decimal(15)   View
  project_invoice decimal(15)   Table
  purchase_order 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
  fin_document_approval decimal(15)   Table
  purchase_order_approval decimal(15)   Table
  purchase_requisition_approval decimal(15)   Table
performed_for expense_history decimal(15)   Table
  fin_document_approval decimal(15)   Table
  purchase_order_approval decimal(15)   Table
  purchase_requisition_approval 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_group_submitter 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
  po_expense_assignment decimal(15)   Table
  po_expense_line_descriptor decimal(15)   Table
  po_expnse_consol_all_view decimal(15)   View
  po_expnse_consol_approved_view decimal(15)   View
  po_expnse_consol_view decimal(15)   View
  po_item_consol_all_view decimal(15)   View
  po_item_consol_approved_view decimal(15)   View
  po_item_consol_view decimal(15)   View
  po_item_line_descriptor decimal(15)   Table
  po_labor_assignment decimal(15)   Table
  po_labor_consol_all_view decimal(15)   View
  po_labor_consol_approved_view decimal(15)   View
  po_labor_consol_view decimal(15)   View
  po_labor_line_descriptor decimal(15)   Table
  pr_expense_line_descriptor decimal(15)   Table
  pr_expnse_consol_all_view decimal(15)   View
  pr_expnse_consol_approved_view decimal(15)   View
  pr_item_consol_all_view decimal(15)   View
  pr_item_consol_approved_view decimal(15)   View
  pr_item_line_descriptor decimal(15)   Table
  pr_labor_consol_all_view decimal(15)   View
  pr_labor_consol_approved_view decimal(15)   View
  pr_labor_line_descriptor 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
  section_status 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_approves_before_mgr expense_pm_approval_status char(1)   Table
  manager_approval_status char(1)   Table
  po_pm_approval_status char(1)   Table
  pr_pm_approval_status char(1)   Table
  project char(1)   Table
  vi_pm_approval_status char(1)   Table
po_amount_control pr_consol_all_view char(1)   View
  pr_consol_approved_view char(1)   View
  purchase_requisition char(1)   Table
po_approval_key purchase_order_approval decimal(15)   Table
po_attachment_reference_key po_expense_line_attachment_ref decimal(15)   Table
  po_item_line_attachment_ref decimal(15)   Table
  po_labor_line_attachment_ref decimal(15)   Table
  po_summary_attachment_ref decimal(15)   Table
po_expense_assignment_key po_expense_assignment decimal(15)   Table
po_expense_line_descriptor_key expense_data_allocation decimal(15)   Table
  fin_document_detail_po decimal(15)   Table
  po_expense_assignment decimal(15)   Table
  po_expense_line decimal(15)   Table
  po_expense_line_descriptor decimal(15)   Table
  po_expnse_consol_all_view decimal(15)   View
  po_expnse_consol_approved_view decimal(15)   View
  po_expnse_consol_view decimal(15)   View
  vi_funding_cap_adjustment decimal(15)   Table
po_expense_line_key po_expense_line decimal(15)   Table
  po_expense_line_attachment_ref decimal(15)   Table
  po_expnse_consol_all_view decimal(15)   View
  po_expnse_consol_approved_view decimal(15)   View
  po_expnse_consol_view decimal(15)   View
po_form_title person varchar(240)   Table
po_format_key po_format decimal(15)   Table
  po_format_options decimal(15)   Table
po_header_description po_format varchar(128)   Table
po_item_line_descriptor_key fin_document_detail_po decimal(15)   Table
  po_item_consol_all_view decimal(15)   View
  po_item_consol_approved_view decimal(15)   View
  po_item_consol_view decimal(15)   View
  po_item_line decimal(15)   Table
  po_item_line_descriptor decimal(15)   Table
  vi_funding_cap_adjustment decimal(15)   Table
po_item_line_key po_item_consol_all_view decimal(15)   View
  po_item_consol_approved_view decimal(15)   View
  po_item_consol_view decimal(15)   View
  po_item_line decimal(15)   Table
  po_item_line_attachment_ref decimal(15)   Table
po_key expense_data_allocation decimal(15)   Table
  fin_document_detail_po decimal(15)   Table
  person_time_data decimal(15)   Table
  po_consol_view decimal(15)   View
  po_cust_approval_status decimal(15)   Table
  po_expense_assignment decimal(15)   Table
  po_expense_line decimal(15)   Table
  po_expense_line_attachment_ref decimal(15)   Table
  po_expense_line_descriptor decimal(15)   Table
  po_format_options decimal(15)   Table
  po_item_line decimal(15)   Table
  po_item_line_attachment_ref decimal(15)   Table
  po_item_line_descriptor decimal(15)   Table
  po_labor_assignment decimal(15)   Table
  po_labor_line decimal(15)   Table
  po_labor_line_attachment_ref decimal(15)   Table
  po_labor_line_descriptor decimal(15)   Table
  po_pm_approval_status decimal(15)   Table
  po_summary_attachment_ref decimal(15)   Table
  purchase_order decimal(15)   Table
  purchase_order_approval decimal(15)   Table
  vendor_invoice decimal(15)   Table
  vi_funding_cap_adjustment decimal(15)   Table
po_labor_assignment_key po_labor_assignment decimal(15)   Table
po_labor_line_descriptor_key fin_document_detail_po decimal(15)   Table
  person_time_data decimal(15)   Table
  po_labor_assignment decimal(15)   Table
  po_labor_consol_all_view decimal(15)   View
  po_labor_consol_approved_view decimal(15)   View
  po_labor_consol_view decimal(15)   View
  po_labor_line decimal(15)   Table
  po_labor_line_descriptor decimal(15)   Table
  vi_funding_cap_adjustment decimal(15)   Table
po_labor_line_key po_labor_consol_all_view decimal(15)   View
  po_labor_consol_approved_view decimal(15)   View
  po_labor_consol_view decimal(15)   View
  po_labor_line decimal(15)   Table
  po_labor_line_attachment_ref decimal(15)   Table
po_owner_key po_consol_all_view decimal(15)   View
  po_consol_approved_view decimal(15)   View
  po_consol_view decimal(15)   View
  purchase_order decimal(15)   Table
po_signature_key person decimal(15)   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_fp_billable post_history char(1)   Table
post_fp_revenue post_history char(1)   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
  fin_document_detail_item decimal(15)   Table
  fin_document_detail_labor 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_document_item decimal(15)   Table
  journal_document_labor 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
pr_approval_key purchase_requisition_approval decimal(15)   Table
pr_attachment_reference_key pr_expense_line_attachment_ref decimal(15)   Table
  pr_item_line_attachment_ref decimal(15)   Table
  pr_labor_line_attachment_ref decimal(15)   Table
  pr_summary_attachment_ref decimal(15)   Table
pr_expense_line_descriptor_key po_expense_line_descriptor decimal(15)   Table
  po_expnse_consol_all_view decimal(15)   View
  po_expnse_consol_approved_view decimal(15)   View
  po_expnse_consol_view decimal(15)   View
  pr_expense_line decimal(15)   Table
  pr_expense_line_descriptor decimal(15)   Table
  pr_expnse_consol_all_view decimal(15)   View
  pr_expnse_consol_approved_view decimal(15)   View
pr_expense_line_key pr_expense_line decimal(15)   Table
  pr_expense_line_attachment_ref decimal(15)   Table
  pr_expnse_consol_all_view decimal(15)   View
  pr_expnse_consol_approved_view decimal(15)   View
pr_item_line_descriptor_key po_item_consol_all_view decimal(15)   View
  po_item_consol_approved_view decimal(15)   View
  po_item_consol_view decimal(15)   View
  po_item_line_descriptor decimal(15)   Table
  pr_item_consol_all_view decimal(15)   View
  pr_item_consol_approved_view decimal(15)   View
  pr_item_line decimal(15)   Table
  pr_item_line_descriptor decimal(15)   Table
pr_item_line_key pr_item_consol_all_view decimal(15)   View
  pr_item_consol_approved_view decimal(15)   View
  pr_item_line decimal(15)   Table
  pr_item_line_attachment_ref decimal(15)   Table
pr_key po_consol_all_view decimal(15)   View
  po_consol_approved_view decimal(15)   View
  po_consol_view decimal(15)   View
  po_expnse_consol_all_view decimal(15)   View
  po_expnse_consol_approved_view decimal(15)   View
  po_item_consol_all_view decimal(15)   View
  po_item_consol_approved_view decimal(15)   View
  po_labor_consol_all_view decimal(15)   View
  po_labor_consol_approved_view decimal(15)   View
  pr_cust_approval_status decimal(15)   Table
  pr_expense_line decimal(15)   Table
  pr_expense_line_attachment_ref decimal(15)   Table
  pr_expense_line_descriptor decimal(15)   Table
  pr_item_line decimal(15)   Table
  pr_item_line_attachment_ref decimal(15)   Table
  pr_item_line_descriptor decimal(15)   Table
  pr_labor_line decimal(15)   Table
  pr_labor_line_attachment_ref decimal(15)   Table
  pr_labor_line_descriptor decimal(15)   Table
  pr_pm_approval_status decimal(15)   Table
  pr_summary_attachment_ref decimal(15)   Table
  purchase_order decimal(15)   Table
  purchase_requisition decimal(15)   Table
  purchase_requisition_approval decimal(15)   Table
pr_labor_line_descriptor_key po_labor_consol_all_view decimal(15)   View
  po_labor_consol_approved_view decimal(15)   View
  po_labor_consol_view decimal(15)   View
  po_labor_line_descriptor decimal(15)   Table
  pr_labor_consol_all_view decimal(15)   View
  pr_labor_consol_approved_view decimal(15)   View
  pr_labor_line decimal(15)   Table
  pr_labor_line_descriptor decimal(15)   Table
pr_labor_line_key pr_labor_consol_all_view decimal(15)   View
  pr_labor_consol_approved_view decimal(15)   View
  pr_labor_line decimal(15)   Table
  pr_labor_line_attachment_ref decimal(15)   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
  purchase_order decimal(15)   Table
printed_ind check_print_history char(1) ('N') Table
printed_timestamp check_print_history timestamp   Table
  invoice timestamp   Table
  purchase_order 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_document_viewer_open project_open_access_view varchar(1)   View
project_item_uom_rate_key project_item_uom_rate decimal(15)   Table
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_approval decimal(15)   Table
  fin_document_det_proj_expense decimal(15)   Table
  fin_document_det_proj_item decimal(15)   Table
  fin_document_det_proj_labor 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_document_item decimal(15)   Table
  journal_document_labor 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
  po_consol_all_view decimal(15)   View
  po_consol_approved_view decimal(15)   View
  po_consol_view decimal(15)   View
  po_cust_approval_status decimal(15)   Table
  po_expense_assignment decimal(15)   Table
  po_expense_line_descriptor decimal(15)   Table
  po_expnse_consol_all_view decimal(15)   View
  po_expnse_consol_approved_view decimal(15)   View
  po_expnse_consol_view decimal(15)   View
  po_item_consol_all_view decimal(15)   View
  po_item_consol_approved_view decimal(15)   View
  po_item_consol_view decimal(15)   View
  po_item_line_descriptor decimal(15)   Table
  po_labor_assignment decimal(15)   Table
  po_labor_consol_all_view decimal(15)   View
  po_labor_consol_approved_view decimal(15)   View
  po_labor_consol_view decimal(15)   View
  po_labor_line_descriptor decimal(15)   Table
  po_pm_approval_status decimal(15)   Table
  pr_consol_all_view decimal(15)   View
  pr_consol_approved_view decimal(15)   View
  pr_cust_approval_status decimal(15)   Table
  pr_expense_line_descriptor decimal(15)   Table
  pr_expnse_consol_all_view decimal(15)   View
  pr_expnse_consol_approved_view decimal(15)   View
  pr_item_consol_all_view decimal(15)   View
  pr_item_consol_approved_view decimal(15)   View
  pr_item_line_descriptor decimal(15)   Table
  pr_labor_consol_all_view decimal(15)   View
  pr_labor_consol_approved_view decimal(15)   View
  pr_labor_line_descriptor decimal(15)   Table
  pr_pm_approval_status 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_approval_view decimal(15)   View
  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_item decimal(15)   Table
  project_item_uom_rate decimal(15)   Table
  project_location decimal(15)   Table
  project_note decimal(15)   Table
  project_open_access_view decimal(15)   View
  project_pay_code decimal(15)   Table
  project_post_history decimal(15)   Table
  project_restrict_access decimal(15)   Table
  purchase_order decimal(15)   Table
  purchase_order_approval decimal(15)   Table
  purchase_requisition decimal(15)   Table
  purchase_requisition_approval decimal(15)   Table
  request_allocation decimal(15)   Table
  resource_request decimal(15)   Table
  shared_document 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
  vi_cust_approval_status decimal(15)   Table
  vi_pm_approval_status decimal(15)   Table
project_manager_key assignment_view decimal(15)   View
project_manager_open project_open_access_view varchar(1)   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_po_viewer_open project_open_access_view varchar(1)   View
project_pr_viewer_open project_open_access_view varchar(1)   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_det_proj_expense decimal(15)   Table
  fin_document_det_proj_item decimal(15)   Table
  fin_document_det_proj_labor 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
project_viewer_open project_open_access_view varchar(1)   View
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
ptd_key vendor_payment_1099_view decimal(15)   View
purchase_approval_amount person decimal(15,2)   Table
purchase_email person char(1)   Table
purchase_order project_approval_view varchar(1)   View
purchase_request project_approval_view varchar(1)   View
purchaser_key po_consol_all_view decimal(15)   View
  po_consol_approved_view decimal(15)   View
  po_consol_view decimal(15)   View
  pr_consol_all_view decimal(15)   View
  pr_consol_approved_view decimal(15)   View
  purchase_order decimal(15)   Table
  purchase_requisition decimal(15)   Table
purpose entertainment_detail varchar(2000)   Table
  expense_report varchar(2000)   Table
  project varchar(2000)   Table
  request_expense_report varchar(2000)   Table
qty_tp_to_show cost_plus_invc_sect_fmt char(1)   Table
quantity fin_document_det_proj_item decimal(15,6) ((0)) Table
  general_ledger decimal(18,3)   Table
  person_time_data decimal(15,2)   Table
  person_time_data_history decimal(15,2)   Table
  po_item_consol_all_view decimal(38,6)   View
  po_item_consol_approved_view decimal(38,6)   View
  po_item_consol_view decimal(38,6)   View
  po_item_line decimal(15,6)   Table
  pr_item_consol_all_view decimal(38,6)   View
  pr_item_consol_approved_view decimal(38,6)   View
  pr_item_line decimal(15,6)   Table
quantity_precision unit_of_measure tinyint   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
  po_item_consol_all_view decimal(15,5)   View
  po_item_consol_approved_view decimal(15,5)   View
  po_item_consol_view decimal(15,5)   View
  po_item_line_descriptor decimal(15,5)   Table
  po_labor_consol_all_view decimal(15,5)   View
  po_labor_consol_approved_view decimal(15,5)   View
  po_labor_consol_view decimal(15,5)   View
  po_labor_line_descriptor decimal(15,5)   Table
  pr_item_consol_all_view decimal(15,5)   View
  pr_item_consol_approved_view decimal(15,5)   View
  pr_item_line_descriptor decimal(15,5)   Table
  pr_labor_consol_all_view decimal(15,5)   View
  pr_labor_consol_approved_view decimal(15,5)   View
  pr_labor_line_descriptor 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 po_format_options char(1) ('N') Table
  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
receiver_key po_consol_all_view decimal(15)   View
  po_consol_approved_view decimal(15)   View
  po_consol_view decimal(15)   View
  purchase_order decimal(15)   Table
  vendor_invoice decimal(15)   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
  po_consol_all_view varchar(25)   View
  po_consol_approved_view varchar(25)   View
  po_consol_view varchar(25)   View
  po_expense_line_descriptor varchar(25)   Table
  po_expnse_consol_all_view varchar(25)   View
  po_expnse_consol_approved_view varchar(25)   View
  po_expnse_consol_view varchar(25)   View
  po_item_consol_all_view varchar(25)   View
  po_item_consol_approved_view varchar(25)   View
  po_item_consol_view varchar(25)   View
  po_item_line_descriptor varchar(25)   Table
  po_labor_consol_all_view varchar(25)   View
  po_labor_consol_approved_view varchar(25)   View
  po_labor_consol_view varchar(25)   View
  po_labor_line_descriptor varchar(25)   Table
  pr_consol_all_view varchar(25)   View
  pr_consol_approved_view varchar(25)   View
  pr_expense_line_descriptor varchar(25)   Table
  pr_expnse_consol_all_view varchar(25)   View
  pr_expnse_consol_approved_view varchar(25)   View
  pr_item_consol_all_view varchar(25)   View
  pr_item_consol_approved_view varchar(25)   View
  pr_item_line_descriptor varchar(25)   Table
  pr_labor_consol_all_view varchar(25)   View
  pr_labor_consol_approved_view varchar(25)   View
  pr_labor_line_descriptor varchar(25)   Table
  purchase_order varchar(25)   Table
  purchase_requisition varchar(25)   Table
registration company_car_detail decimal(18,3)   Table
reimbursable payment_method char(1) ('N') Table
remit_to_address_key po_format_options decimal(15)   Table
  project_invoice decimal(15)   Table
remit_to_city invoice varchar(60)   Table
remit_to_contact_key po_format_options decimal(15)   Table
  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 pr_consol_all_view decimal(15)   View
  pr_consol_approved_view decimal(15)   View
  purchase_requisition decimal(15)   Table
  resource_request decimal(15)   Table
required udf_setup char(1) ('N') Table
required_by_date po_consol_all_view timestamp   View
  po_consol_approved_view timestamp   View
  po_consol_view timestamp   View
  po_expense_line timestamp   Table
  po_expnse_consol_all_view timestamp   View
  po_expnse_consol_approved_view timestamp   View
  po_expnse_consol_view timestamp   View
  po_item_consol_all_view timestamp   View
  po_item_consol_approved_view timestamp   View
  po_item_consol_view timestamp   View
  po_item_line timestamp   Table
  pr_consol_all_view timestamp   View
  pr_consol_approved_view timestamp   View
  pr_expense_line timestamp   Table
  pr_expnse_consol_all_view timestamp   View
  pr_expnse_consol_approved_view timestamp   View
  pr_item_consol_all_view timestamp   View
  pr_item_consol_approved_view timestamp   View
  pr_item_line timestamp   Table
  purchase_order timestamp   Table
  purchase_requisition timestamp   Table
resource_assigner_open project_open_access_view varchar(1)   View
resource_key res_req_resource decimal(15)   Table
resource_planner_open project_open_access_view varchar(1)   View
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_open_access_view varchar(1)   View
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
  fin_document_approval varchar(2000)   Table
  purchase_order_approval varchar(2000)   Table
  purchase_requisition_approval 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
  fin_document_approval char(1) ('N') Table
  purchase_order_approval char(1) ('N') Table
  purchase_requisition_approval char(1) ('N') Table
review_timestamp fin_document_approval timestamp   Table
  purchase_order_approval timestamp   Table
  purchase_requisition_approval timestamp   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
role_description role varchar(50)   Table
role_key alternate decimal(15)   Table
  approval_history decimal(15)   Table
  expense_history decimal(15)   Table
  fin_document_approval 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
  project_restrict_access decimal(15)   Table
  purchase_order_approval decimal(15)   Table
  purchase_requisition_approval 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
shared_document_key attachment_reference decimal(15)   Table
ship_to_address_key po_format_options decimal(15)   Table
  project_invoice decimal(15)   Table
ship_to_city invoice varchar(60)   Table
ship_to_contact_key po_format_options decimal(15)   Table
  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
  invc_sect_fmt_tot_grp 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_bill_rate expense_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_cost_rate 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_external_comments po_format char(1) ('N') Table
show_hours 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_itd_qty invc_sect_fmt_tot_grp 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_qty cost_plus_invc_sect_fmt char(1) ('N') Table
  expense_invc_sect_fmt char(1) ('N') Table
  invc_sect_fmt_tot_grp 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_tot_amount invc_sect_fmt char(1) ('Y') Table
show_section_tot_itd_qty invc_sect_fmt char(1) ('N') Table
show_section_tot_qty invc_sect_fmt char(1) ('N') 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
show_user01 po_format char(1) ('N') Table
show_user02 po_format char(1) ('N') Table
show_user03 po_format char(1) ('N') Table
show_user04 po_format char(1) ('N') Table
show_user05 po_format char(1) ('N') Table
show_user06 po_format char(1) ('N') Table
show_user07 po_format char(1) ('N') Table
show_user08 po_format char(1) ('N') Table
show_user09 po_format char(1) ('N') Table
show_user10 po_format char(1) ('N') Table
show_user11 po_format char(1) ('N') Table
show_user12 po_format char(1) ('N') Table
show_user13 po_format char(1) ('N') Table
show_user14 po_format char(1) ('N') Table
show_user15 po_format char(1) ('N') Table
show_user16 po_format char(1) ('N') Table
show_user17 po_format char(1) ('N') Table
show_user18 po_format char(1) ('N') Table
show_user19 po_format char(1) ('N') Table
show_user20 po_format char(1) ('N') Table
sic_code customer varchar(10)   Table
sign_field adp_setup char(1)   Table
signer_key po_format decimal(15)   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
  fin_document varchar(25)   Table
  fin_document_approval varchar(25)   Table
  leave_request varchar(25)   Table
  leave_request_approval varchar(25)   Table
  person_time varchar(25)   Table
  po_consol_all_view integer   View
  po_consol_approved_view varchar(25)   View
  po_consol_view varchar(25)   View
  pr_consol_all_view integer   View
  pr_consol_approved_view varchar(25)   View
  project_status varchar(50)   Table
  purchase_order varchar(25)   Table
  purchase_order_approval varchar(25)   Table
  purchase_requisition varchar(25)   Table
  purchase_requisition_approval varchar(25)   Table
  request_expense_report varchar(255)   Table
  resource_request varchar(25)   Table
  resource_request_history varchar(25)   Table
  section_status char(1) ('Y') Table
  task varchar(50)   Table
  unanet_access char(1) ('N') Table
status_date resource_request timestamp   Table
  resource_request_history timestamp   Table
status_timestamp fin_document_approval timestamp   Table
  leave_request timestamp   Table
  leave_request_approval timestamp   Table
  po_consol_view timestamp   View
  purchase_order timestamp   Table
  purchase_order_approval timestamp   Table
  purchase_requisition timestamp   Table
  purchase_requisition_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
summary_proj_show_code po_format char(1) ('N') Table
summary_proj_show_org_code po_format char(1) ('N') Table
summary_proj_show_title po_format char(1) ('N') Table
summary_task_show_name po_format char(1) ('N') Table
summary_task_show_number po_format char(1) ('N') 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
  cost_plus_post_detail decimal(15)   Table
  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_det_proj_expense decimal(15)   Table
  fin_document_det_proj_item decimal(15)   Table
  fin_document_det_proj_labor 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
  po_consol_all_view decimal(15)   View
  po_consol_approved_view decimal(15)   View
  po_consol_view decimal(15)   View
  po_expense_assignment decimal(15)   Table
  po_expense_line_descriptor decimal(15)   Table
  po_expnse_consol_all_view decimal(15)   View
  po_expnse_consol_approved_view decimal(15)   View
  po_expnse_consol_view decimal(15)   View
  po_item_consol_all_view decimal(15)   View
  po_item_consol_approved_view decimal(15)   View
  po_item_consol_view decimal(15)   View
  po_item_line_descriptor decimal(15)   Table
  po_labor_assignment decimal(15)   Table
  po_labor_consol_all_view decimal(15)   View
  po_labor_consol_approved_view decimal(15)   View
  po_labor_consol_view decimal(15)   View
  po_labor_line_descriptor decimal(15)   Table
  pr_consol_all_view decimal(15)   View
  pr_consol_approved_view decimal(15)   View
  pr_expense_line_descriptor decimal(15)   Table
  pr_expnse_consol_all_view decimal(15)   View
  pr_expnse_consol_approved_view decimal(15)   View
  pr_item_consol_all_view decimal(15)   View
  pr_item_consol_approved_view decimal(15)   View
  pr_item_line_descriptor decimal(15)   Table
  pr_labor_consol_all_view decimal(15)   View
  pr_labor_consol_approved_view decimal(15)   View
  pr_labor_line_descriptor decimal(15)   Table
  purchase_order decimal(15)   Table
  purchase_requisition 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 project_approval_view varchar(1)   View
time_assignment_flag project char(1) ('Y') Table
  task char(1) ('P') 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
  vi_included_time 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 po_format_options varchar(255)   Table
  project_invoice varchar(255)   Table
to_location air_detail varchar(100)   Table
  imported_air_detail varchar(100)   Table
  mileage_detail varchar(100)   Table
token column_width_criteria varchar(16)   Table
  section_status varchar(16)   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_sub_po_required project char(1) ('N') Table
  task char(1) ('P') 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) ((20)) 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
uom_key fin_document_det_proj_item decimal(15)   Table
  item_uom decimal(15)   Table
  item_uom_rate decimal(15)   Table
  po_item_consol_all_view decimal(15)   View
  po_item_consol_approved_view decimal(15)   View
  po_item_consol_view decimal(15)   View
  po_item_line_descriptor decimal(15)   Table
  pr_item_consol_all_view decimal(15)   View
  pr_item_consol_approved_view decimal(15)   View
  pr_item_line_descriptor decimal(15)   Table
  project_item_uom_rate decimal(15)   Table
  unit_of_measure decimal(15)   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_contact varchar(128)   Table
  customer_org varchar(128)   Table
  expense_type varchar(128)   Table
  person varchar(128)   Table
  po_consol_all_view varchar(128)   View
  po_consol_approved_view varchar(128)   View
  po_consol_view varchar(128)   View
  pr_consol_all_view varchar(128)   View
  pr_consol_approved_view varchar(128)   View
  project varchar(128)   Table
  project_assignment varchar(128)   Table
  project_note varchar(128)   Table
  project_note_audit varchar(128)   Table
  purchase_order varchar(128)   Table
  purchase_requisition varchar(128)   Table
  shared_document varchar(128)   Table
  task varchar(128)   Table
  task_assignment varchar(128)   Table
  vendor_org varchar(128)   Table
user02 customer varchar(128)   Table
  customer_contact varchar(128)   Table
  customer_org varchar(128)   Table
  expense_type varchar(128)   Table
  person varchar(128)   Table
  po_consol_all_view varchar(128)   View
  po_consol_approved_view varchar(128)   View
  po_consol_view varchar(128)   View
  pr_consol_all_view varchar(128)   View
  pr_consol_approved_view varchar(128)   View
  project varchar(128)   Table
  project_assignment varchar(128)   Table
  project_note varchar(128)   Table
  project_note_audit varchar(128)   Table
  purchase_order varchar(128)   Table
  purchase_requisition varchar(128)   Table
  shared_document varchar(128)   Table
  task varchar(128)   Table
  task_assignment varchar(128)   Table
  vendor_org varchar(128)   Table
user03 customer varchar(128)   Table
  customer_contact varchar(128)   Table
  customer_org varchar(128)   Table
  expense_type varchar(128)   Table
  person varchar(128)   Table
  po_consol_all_view varchar(128)   View
  po_consol_approved_view varchar(128)   View
  po_consol_view varchar(128)   View
  pr_consol_all_view varchar(128)   View
  pr_consol_approved_view varchar(128)   View
  project varchar(128)   Table
  project_assignment varchar(128)   Table
  project_note varchar(128)   Table
  project_note_audit varchar(128)   Table
  purchase_order varchar(128)   Table
  purchase_requisition varchar(128)   Table
  shared_document varchar(128)   Table
  task varchar(128)   Table
  task_assignment varchar(128)   Table
  vendor_org varchar(128)   Table
user04 customer varchar(128)   Table
  customer_contact varchar(128)   Table
  customer_org varchar(128)   Table
  expense_type varchar(128)   Table
  person varchar(128)   Table
  po_consol_all_view varchar(128)   View
  po_consol_approved_view varchar(128)   View
  po_consol_view varchar(128)   View
  pr_consol_all_view varchar(128)   View
  pr_consol_approved_view varchar(128)   View
  project varchar(128)   Table
  project_assignment varchar(128)   Table
  project_note varchar(128)   Table
  project_note_audit varchar(128)   Table
  purchase_order varchar(128)   Table
  purchase_requisition varchar(128)   Table
  shared_document varchar(128)   Table
  task varchar(128)   Table
  task_assignment varchar(128)   Table
  vendor_org varchar(128)   Table
user05 customer varchar(128)   Table
  customer_contact varchar(128)   Table
  customer_org varchar(128)   Table
  expense_type varchar(128)   Table
  person varchar(128)   Table
  po_consol_all_view varchar(128)   View
  po_consol_approved_view varchar(128)   View
  po_consol_view varchar(128)   View
  pr_consol_all_view varchar(128)   View
  pr_consol_approved_view varchar(128)   View
  project varchar(128)   Table
  project_assignment varchar(128)   Table
  project_note varchar(128)   Table
  project_note_audit varchar(128)   Table
  purchase_order varchar(128)   Table
  purchase_requisition varchar(128)   Table
  shared_document varchar(128)   Table
  task varchar(128)   Table
  task_assignment varchar(128)   Table
  vendor_org varchar(128)   Table
user06 customer varchar(128)   Table
  customer_contact varchar(128)   Table
  customer_org varchar(128)   Table
  expense_type varchar(128)   Table
  person varchar(128)   Table
  po_consol_all_view varchar(128)   View
  po_consol_approved_view varchar(128)   View
  po_consol_view varchar(128)   View
  pr_consol_all_view varchar(128)   View
  pr_consol_approved_view varchar(128)   View
  project varchar(128)   Table
  project_note varchar(128)   Table
  project_note_audit varchar(128)   Table
  purchase_order varchar(128)   Table
  purchase_requisition varchar(128)   Table
  shared_document varchar(128)   Table
  task varchar(128)   Table
  vendor_org varchar(128)   Table
user07 customer varchar(128)   Table
  customer_contact varchar(128)   Table
  customer_org varchar(128)   Table
  expense_type varchar(128)   Table
  person varchar(128)   Table
  po_consol_all_view varchar(128)   View
  po_consol_approved_view varchar(128)   View
  po_consol_view varchar(128)   View
  pr_consol_all_view varchar(128)   View
  pr_consol_approved_view varchar(128)   View
  project varchar(128)   Table
  project_note varchar(128)   Table
  project_note_audit varchar(128)   Table
  purchase_order varchar(128)   Table
  purchase_requisition varchar(128)   Table
  shared_document varchar(128)   Table
  task varchar(128)   Table
  vendor_org varchar(128)   Table
user08 customer varchar(128)   Table
  customer_contact varchar(128)   Table
  customer_org varchar(128)   Table
  expense_type varchar(128)   Table
  person varchar(128)   Table
  po_consol_all_view varchar(128)   View
  po_consol_approved_view varchar(128)   View
  po_consol_view varchar(128)   View
  pr_consol_all_view varchar(128)   View
  pr_consol_approved_view varchar(128)   View
  project varchar(128)   Table
  project_note varchar(128)   Table
  project_note_audit varchar(128)   Table
  purchase_order varchar(128)   Table
  purchase_requisition varchar(128)   Table
  shared_document varchar(128)   Table
  task varchar(128)   Table
  vendor_org varchar(128)   Table
user09 customer varchar(128)   Table
  customer_contact varchar(128)   Table
  customer_org varchar(128)   Table
  expense_type varchar(128)   Table
  person varchar(128)   Table
  po_consol_all_view varchar(128)   View
  po_consol_approved_view varchar(128)   View
  po_consol_view varchar(128)   View
  pr_consol_all_view varchar(128)   View
  pr_consol_approved_view varchar(128)   View
  project varchar(128)   Table
  project_note varchar(128)   Table
  project_note_audit varchar(128)   Table
  purchase_order varchar(128)   Table
  purchase_requisition varchar(128)   Table
  shared_document varchar(128)   Table
  task varchar(128)   Table
  vendor_org varchar(128)   Table
user10 customer varchar(128)   Table
  customer_contact varchar(128)   Table
  customer_org varchar(128)   Table
  expense_type varchar(128)   Table
  person varchar(128)   Table
  po_consol_all_view varchar(128)   View
  po_consol_approved_view varchar(128)   View
  po_consol_view varchar(128)   View
  pr_consol_all_view varchar(128)   View
  pr_consol_approved_view varchar(128)   View
  project varchar(128)   Table
  project_note varchar(128)   Table
  project_note_audit varchar(128)   Table
  purchase_order varchar(128)   Table
  purchase_requisition varchar(128)   Table
  shared_document varchar(128)   Table
  task varchar(128)   Table
  vendor_org varchar(128)   Table
user11 customer varchar(128)   Table
  customer_contact varchar(128)   Table
  customer_org varchar(128)   Table
  expense_type varchar(128)   Table
  person varchar(128)   Table
  po_consol_all_view varchar(128)   View
  po_consol_approved_view varchar(128)   View
  po_consol_view varchar(128)   View
  pr_consol_all_view varchar(128)   View
  pr_consol_approved_view varchar(128)   View
  project varchar(128)   Table
  project_note varchar(128)   Table
  project_note_audit varchar(128)   Table
  purchase_order varchar(128)   Table
  purchase_requisition varchar(128)   Table
  shared_document varchar(128)   Table
  task varchar(128)   Table
  vendor_org varchar(128)   Table
user12 customer varchar(128)   Table
  customer_contact varchar(128)   Table
  customer_org varchar(128)   Table
  expense_type varchar(128)   Table
  person varchar(128)   Table
  po_consol_all_view varchar(128)   View
  po_consol_approved_view varchar(128)   View
  po_consol_view varchar(128)   View
  pr_consol_all_view varchar(128)   View
  pr_consol_approved_view varchar(128)   View
  project varchar(128)   Table
  project_note varchar(128)   Table
  project_note_audit varchar(128)   Table
  purchase_order varchar(128)   Table
  purchase_requisition varchar(128)   Table
  shared_document varchar(128)   Table
  task varchar(128)   Table
  vendor_org varchar(128)   Table
user13 customer varchar(128)   Table
  customer_contact varchar(128)   Table
  customer_org varchar(128)   Table
  expense_type varchar(128)   Table
  person varchar(128)   Table
  po_consol_all_view varchar(128)   View
  po_consol_approved_view varchar(128)   View
  po_consol_view varchar(128)   View
  pr_consol_all_view varchar(128)   View
  pr_consol_approved_view varchar(128)   View
  project varchar(128)   Table
  project_note varchar(128)   Table
  project_note_audit varchar(128)   Table
  purchase_order varchar(128)   Table
  purchase_requisition varchar(128)   Table
  shared_document varchar(128)   Table
  task varchar(128)   Table
  vendor_org varchar(128)   Table
user14 customer varchar(128)   Table
  customer_contact varchar(128)   Table
  customer_org varchar(128)   Table
  expense_type varchar(128)   Table
  person varchar(128)   Table
  po_consol_all_view varchar(128)   View
  po_consol_approved_view varchar(128)   View
  po_consol_view varchar(128)   View
  pr_consol_all_view varchar(128)   View
  pr_consol_approved_view varchar(128)   View
  project varchar(128)   Table
  project_note varchar(128)   Table
  project_note_audit varchar(128)   Table
  purchase_order varchar(128)   Table
  purchase_requisition varchar(128)   Table
  shared_document varchar(128)   Table
  task varchar(128)   Table
  vendor_org varchar(128)   Table
user15 customer varchar(128)   Table
  customer_contact varchar(128)   Table
  customer_org varchar(128)   Table
  expense_type varchar(128)   Table
  person varchar(128)   Table
  po_consol_all_view varchar(128)   View
  po_consol_approved_view varchar(128)   View
  po_consol_view varchar(128)   View
  pr_consol_all_view varchar(128)   View
  pr_consol_approved_view varchar(128)   View
  project varchar(128)   Table
  project_note varchar(128)   Table
  project_note_audit varchar(128)   Table
  purchase_order varchar(128)   Table
  purchase_requisition varchar(128)   Table
  shared_document varchar(128)   Table
  task varchar(128)   Table
  vendor_org varchar(128)   Table
user16 customer varchar(128)   Table
  customer_contact varchar(128)   Table
  customer_org varchar(128)   Table
  expense_type varchar(128)   Table
  person varchar(128)   Table
  po_consol_all_view varchar(128)   View
  po_consol_approved_view varchar(128)   View
  po_consol_view varchar(128)   View
  pr_consol_all_view varchar(128)   View
  pr_consol_approved_view varchar(128)   View
  project varchar(128)   Table
  project_note varchar(128)   Table
  project_note_audit varchar(128)   Table
  purchase_order varchar(128)   Table
  purchase_requisition varchar(128)   Table
  shared_document varchar(128)   Table
  task varchar(128)   Table
  vendor_org varchar(128)   Table
user17 customer varchar(128)   Table
  customer_contact varchar(128)   Table
  customer_org varchar(128)   Table
  expense_type varchar(128)   Table
  person varchar(128)   Table
  po_consol_all_view varchar(128)   View
  po_consol_approved_view varchar(128)   View
  po_consol_view varchar(128)   View
  pr_consol_all_view varchar(128)   View
  pr_consol_approved_view varchar(128)   View
  project varchar(128)   Table
  project_note varchar(128)   Table
  project_note_audit varchar(128)   Table
  purchase_order varchar(128)   Table
  purchase_requisition varchar(128)   Table
  shared_document varchar(128)   Table
  task varchar(128)   Table
  vendor_org varchar(128)   Table
user18 customer varchar(128)   Table
  customer_contact varchar(128)   Table
  customer_org varchar(128)   Table
  expense_type varchar(128)   Table
  person varchar(128)   Table
  po_consol_all_view varchar(128)   View
  po_consol_approved_view varchar(128)   View
  po_consol_view varchar(128)   View
  pr_consol_all_view varchar(128)   View
  pr_consol_approved_view varchar(128)   View
  project varchar(128)   Table
  project_note varchar(128)   Table
  project_note_audit varchar(128)   Table
  purchase_order varchar(128)   Table
  purchase_requisition varchar(128)   Table
  shared_document varchar(128)   Table
  task varchar(128)   Table
  vendor_org varchar(128)   Table
user19 customer varchar(128)   Table
  customer_contact varchar(128)   Table
  customer_org varchar(128)   Table
  expense_type varchar(128)   Table
  person varchar(128)   Table
  po_consol_all_view varchar(128)   View
  po_consol_approved_view varchar(128)   View
  po_consol_view varchar(128)   View
  pr_consol_all_view varchar(128)   View
  pr_consol_approved_view varchar(128)   View
  project varchar(128)   Table
  project_note varchar(128)   Table
  project_note_audit varchar(128)   Table
  purchase_order varchar(128)   Table
  purchase_requisition varchar(128)   Table
  shared_document varchar(128)   Table
  task varchar(128)   Table
  vendor_org varchar(128)   Table
user20 customer varchar(128)   Table
  customer_contact varchar(128)   Table
  customer_org varchar(128)   Table
  expense_type varchar(128)   Table
  person varchar(128)   Table
  po_consol_all_view varchar(128)   View
  po_consol_approved_view varchar(128)   View
  po_consol_view varchar(128)   View
  pr_consol_all_view varchar(128)   View
  pr_consol_approved_view varchar(128)   View
  project varchar(128)   Table
  project_note varchar(128)   Table
  project_note_audit varchar(128)   Table
  purchase_order varchar(128)   Table
  purchase_requisition varchar(128)   Table
  shared_document 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 project_approval_view varchar(1)   View
vendor_invoice_key expense_data_allocation decimal(15)   Table
  person_time_data decimal(15)   Table
  vi_included_expense decimal(15)   Table
  vi_included_time decimal(15)   Table
vendor_invoice_person person char(1) ('N') Table
vendor_key billing_info decimal(15)   Table
  expense_data decimal(15)   Table
  expense_type_vendor_assignment decimal(15)   Table
  shared_document decimal(15)   Table
  vendor decimal(15)   Table
vendor_name expense_data varchar(255)   Table
  imported_expense_data varchar(255)   Table
vendor_org_key po_consol_all_view decimal(15)   View
  po_consol_approved_view decimal(15)   View
  po_consol_view decimal(15)   View
  pr_consol_all_view decimal(15)   View
  pr_consol_approved_view decimal(15)   View
  purchase_order decimal(15)   Table
  purchase_requisition decimal(15)   Table
  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
vi_funding_cap_adjustment_key vi_funding_cap_adjustment decimal(15)   Table
vi_overage po_consol_all_view char(1)   View
  po_consol_approved_view char(1)   View
  po_consol_view char(1)   View
  po_expense_line char(1)   Table
  po_expnse_consol_all_view char(1)   View
  po_expnse_consol_approved_view char(1)   View
  po_expnse_consol_view char(1)   View
  po_item_consol_all_view char(1)   View
  po_item_consol_approved_view char(1)   View
  po_item_consol_view char(1)   View
  po_item_line char(1)   Table
  po_labor_consol_all_view char(1)   View
  po_labor_consol_approved_view char(1)   View
  po_labor_consol_view char(1)   View
  po_labor_line char(1)   Table
  purchase_order char(1)   Table
view_id adhoc_criteria_set varchar(50)   Table
voided_by cost_pool_group_calc decimal(15)   Table
voided_expense_report_key expense_report 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_expense_report_key expense_report decimal(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_document_item decimal(18,2)   Table
  invcd_document_labor 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_document_item decimal(15,5)   Table
  invcd_document_labor decimal(15,5)   Table
  invcd_time decimal(15,5)   Table
  journal_view decimal(15,5)   View
writeoff_cost invcd_document_expense decimal(18,2)   Table
  invcd_document_item 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_document_item decimal(5,2)   Table
  invcd_expense decimal(5,2)   Table
  journal_view decimal(5,2)   View
writeoff_quantity invcd_cost_plus_post_detail decimal(19,6)   Table
  invcd_document_item decimal(15,6)   Table
  invcd_document_labor decimal(15,2)   Table
  invcd_time decimal(15,2)   Table
  journal_view decimal(19,6)   View
zip billing_info varchar(9)   Table