| 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 |