All Indexes |
| |
Table Name |
Index Name |
Definition |
| 1. |
ADDRESS |
pk_address |
address_key |
| 2. |
ADDRESS_TYPE |
idx_address_type1 |
address_type |
| 3. |
ADDRESS_TYPE |
pk_address_type |
address_type_key |
| 4. |
ADP_ORGANIZATION |
pk_adp_organization |
organization_key |
| 5. |
ADP_SETUP |
pk_adp_setup |
adp_setup_key |
| 6. |
AIR_DETAIL |
pk_air_detail |
expense_data_key |
| 7. |
ALTERNATE |
pk_alternate |
alternate_key, person_key, role_key |
| 8. |
APPROVAL_CHAIN |
pk_approval_chain |
chain_key, person_key |
| 9. |
APPROVAL_HISTORY |
pk_approval_history |
approval_history_key |
| 10. |
APPROVER |
pk_approver |
person_key, approver_key |
| 11. |
BATCH |
pk_batch |
batch_key |
| 12. |
BILLING_INFO |
pk_billing_info |
vendor_key |
| 13. |
BUSINESS_MEETING_DETAIL |
pk_business_meeting_detail |
expense_data_key |
| 14. |
CASH_RETURN_DETAIL |
pk_cash_return_detail |
expense_data_key |
| 15. |
CATEGORY_ASSIGNMENT |
pk_category_assignment |
category_key, project_key |
| 16. |
CELL_PHONE_DETAIL |
pk_cell_phone_detail |
expense_data_key |
| 17. |
CHAIN |
idx_chain1 |
chain_name |
| 18. |
CHAIN |
pk_chain |
chain_key |
| 19. |
COMPANY_CAR_DETAIL |
idx_company_car_detail1 |
vehicle_number |
| 20. |
COMPANY_CAR_DETAIL |
idx_company_car_detail2 |
vehicle_number, odo_end |
| 21. |
COMPANY_CAR_DETAIL |
pk_company_car_detail |
expense_data_key |
| 22. |
CONTACT |
pk_contact |
contact_key |
| 23. |
CONTACT_ADDRESS |
pk_contact_address |
contact_key, address_key, address_type_key |
| 24. |
CONTACT_EMAIL |
pk_contact_email |
contact_key, email_key, email_type_key |
| 25. |
CONTACT_PHONE |
pk_contact_phone |
contact_key, phone_key, phone_type_key |
| 26. |
CONTACT_TYPE |
idx_contact_type1 |
contact_type |
| 27. |
CONTACT_TYPE |
pk_contact_type |
contact_type_key |
| 28. |
CREDIT_CARD |
pk_credit_card |
credit_card_key |
| 29. |
CREDIT_CARD_IMPORT |
pk_credit_card_import |
credit_card_import_key |
| 30. |
CURRENCY |
idx_currency1 |
currency_code |
| 31. |
CURRENCY |
pk_currency |
currency_key |
| 32. |
CUSTOMER |
idx_customer1 |
customer_code |
| 33. |
CUSTOMER |
idx_customer2 |
left_visit |
| 34. |
CUSTOMER |
pk_customer |
customer_key |
| 35. |
CUSTOMER_ADDRESS |
pk_customer_address |
customer_key, address_key, address_type_key |
| 36. |
CUSTOMER_APPROVER |
pk_customer_approver |
project_key, person_key |
| 37. |
CUSTOMER_ASSIGNMENT |
pk_customer_assignment |
customer_key, project_key |
| 38. |
CUSTOMER_CONTACT |
pk_customer_contact |
customer_key, contact_key, contact_type_key |
| 39. |
CUSTOMER_EMAIL |
pk_customer_email |
customer_key, email_key, email_type_key |
| 40. |
CUSTOMER_PHONE |
pk_customer_phone |
customer_key, phone_key, phone_type_key |
| 41. |
CUSTOMER_TYPE |
idx_customer_type1 |
customer_type |
| 42. |
CUSTOMER_TYPE |
pk_customer_type |
customer_type_key |
| 43. |
DEFAULT_TIME |
pk_default_time |
person_key |
| 44. |
DEFAULT_TIME_DATA |
pk_default_time_data |
default_data_key |
| 45. |
EMAIL |
pk_email |
email_key |
| 46. |
EMAIL_TEMPLATE |
pk_email_template |
name |
| 47. |
EMAIL_TYPE |
idx_email_type1 |
email_type |
| 48. |
EMAIL_TYPE |
pk_email_type |
email_type_key |
| 49. |
ENTERTAINMENT_DETAIL |
pk_entertainment_detail |
expense_data_key |
| 50. |
EXP_CUST_APPROVAL_STATUS |
pk_exp_cust_approval_status |
expense_report_key, project_key |
| 51. |
EXPENSE_DATA |
pk_expense_data |
expense_data_key |
| 52. |
EXPENSE_DATA_ALLOCATION |
pk_expense_data_allocation |
expense_data_allocation_key |
| 53. |
EXPENSE_HISTORY |
pk_expense_history |
expense_history_key |
| 54. |
EXPENSE_PM_APPROVAL_STATUS |
pk_expense_pm_approval_status |
expense_report_key, project_key |
| 55. |
EXPENSE_PROJECT_ALLOCATION |
pk_expense_project_allocation |
expense_project_allocation_key |
| 56. |
EXPENSE_REPORT |
pk_expense_report |
expense_report_key |
| 57. |
EXPENSE_TYPE |
pk_expense_type |
expense_type_key |
| 58. |
EXPENSE_TYPE_VENDOR_ASSIGNMENT |
pk_etype_vendor_assignment |
expense_type_key, vendor_key |
| 59. |
FLEET |
pk_fleet |
fleet_key |
| 60. |
HISTORY_ALLOCATION |
pk_history_allocation |
history_allocation_key |
| 61. |
HISTORY_APPROVAL_HISTORY |
pk_history_approval_history |
history_approval_history_key |
| 62. |
HISTORY_EXPENSE_DATA |
pk_history_expense_data |
history_expense_data_key |
| 63. |
HISTORY_EXPENSE_REPORT |
idx_history_expense_report1 |
voucher_number |
| 64. |
HISTORY_EXPENSE_REPORT |
idx_history_expense_report2 |
owner_key |
| 65. |
HISTORY_EXPENSE_REPORT |
idx_history_expense_report3 |
date_completed |
| 66. |
HISTORY_EXPENSE_REPORT |
pk_history_expense_report |
history_expense_report_key |
| 67. |
HOLIDAY |
pk_holiday |
holiday_key |
| 68. |
HR |
pk_hr |
person_key |
| 69. |
LODGING_DETAIL |
pk_lodging_detail |
expense_data_key |
| 70. |
MANAGER_APPROVAL_STATUS |
pk_manager_approval_status |
person_time_key, project_key |
| 71. |
MEMBER |
pk_member |
person_key, role_key |
| 72. |
MILEAGE_DETAIL |
pk_mileage_detail |
expense_data_key |
| 73. |
MILEAGE_RATES |
pk_mileage_rates |
begin_date |
| 74. |
MPX_MAPPING |
pk_mpx_mapping |
task_key |
| 75. |
PAY_CODE |
idx_pay_code1 |
pay_code |
| 76. |
PAY_CODE |
pk_pay_code |
pay_code_key |
| 77. |
PAYMENT_METHOD |
pk_payment_method |
payment_method_key |
| 78. |
PAYROLL |
pk_payroll |
person_key |
| 79. |
PERSON |
idx_person1 |
username |
| 80. |
PERSON |
idx_person2 |
customer_key |
| 81. |
PERSON |
pk_person |
person_key |
| 82. |
PERSON_TIME |
idx_person_time1 |
time_period_key, begin_date, person_key, time_key |
| 83. |
PERSON_TIME |
idx_person_time2 |
control_key |
| 84. |
PERSON_TIME |
idx_person_time3 |
status |
| 85. |
PERSON_TIME |
pk_person_time |
person_time_key |
| 86. |
PERSON_TIME_DATA |
idx_person_time_data_gwb1 |
project_key, task_key |
| 87. |
PERSON_TIME_DATA |
idx_person_time_data1 |
person_time_key, work_date, project_key, task_key, project_type_key, pay_code_key, adjusted_number |
| 88. |
PERSON_TIME_DATA |
idx_person_time_data2 |
project_key, person_time_key |
| 89. |
PERSON_TIME_DATA |
idx_person_time_data3 |
batch_key |
| 90. |
PERSON_TIME_DATA |
idx_person_time_data4 |
adjusted_number |
| 91. |
PERSON_TIME_DATA |
pk_person_time_data |
time_data_key |
| 92. |
PERSON_TIME_DATA_HISTORY |
pk_person_time_data_history |
time_data_key, modified_date |
| 93. |
PHONE |
pk_phone |
phone_key |
| 94. |
PHONE_TYPE |
idx_phone_type1 |
phone_type |
| 95. |
PHONE_TYPE |
pk_phone_type |
phone_type_key |
| 96. |
PO |
pk_po |
po_key |
| 97. |
PO_ASSIGNMENT |
pk_po_assignment |
po_key, person_key |
| 98. |
PROJECT |
idx_project1 |
customer_key, project_code |
| 99. |
PROJECT |
idx_project2 |
project_status_key |
| 100. |
PROJECT |
idx_project3 |
assignment_flag |
| 101. |
PROJECT |
pk_project |
project_key |
| 102. |
PROJECT_ASSIGNMENT |
pk_project_assignment |
project_key, person_key |
| 103. |
PROJECT_CATEGORY |
idx_project_category1 |
category_code |
| 104. |
PROJECT_CATEGORY |
pk_project_category |
category_key |
| 105. |
PROJECT_CONTACT |
pk_project_contact |
project_key, contact_key, contact_type_key |
| 106. |
PROJECT_NOTE |
pk_project_note |
project_note_key |
| 107. |
PROJECT_NOTE_TYPE |
pk_project_note_type |
project_note_type_key |
| 108. |
PROJECT_STATUS |
idx_status1 |
status |
| 109. |
PROJECT_STATUS |
pk_project_status |
project_status_key |
| 110. |
PROJECT_TYPE |
idx_project_type1 |
project_type |
| 111. |
PROJECT_TYPE |
pk_project_type |
project_type_key |
| 112. |
PTD_AUDIT_TRAIL |
pk_ptd_audit_trail |
time_data_key, audit_date |
| 113. |
REQUEST_ALLOCATION |
pk_request_allocation |
request_allocation_key |
| 114. |
REQUEST_EXPENSE_DATA |
pk_request_expense_data |
request_expense_data_key |
| 115. |
REQUEST_EXPENSE_REPORT |
pk_request_expense_report |
request_expense_report_key |
| 116. |
ROLE |
pk_role |
role_key |
| 117. |
SEQUENCE_NUMBER |
pk_sequence_number |
table_name |
| 118. |
STANDARD_MILEAGE_FROM |
pk_standard_mileage_from |
stand_mileage_from_key |
| 119. |
STANDARD_MILEAGE_TO |
pk_standard_mileage_to |
stand_mileage_to_key |
| 120. |
TASK |
pk_task |
task_key |
| 121. |
TASK_ASSIGNMENT |
pk_task_assignment |
project_key, person_key, task_key |
| 122. |
TIME_CUST_APPROVAL_STATUS |
pk_time_cust_approval_status |
person_time_key, project_key |
| 123. |
TIME_PERIOD |
pk_time_period |
time_period_key, begin_date |
| 124. |
TIME_PERIOD_HISTORY |
pk_time_period_history |
person_key, time_period_key, begin_date |
| 125. |
TIME_PERIOD_SETUP |
idx_time_period_setup1 |
period_name |
| 126. |
TIME_PERIOD_SETUP |
pk_time_period_setup |
time_period_key |
| 127. |
USER_DEFINITION |
pk_user_definition |
table_name, field_name, locale |
| 128. |
VALID_PAYCODE |
pk_valid_pay_code |
project_key, pay_code_key |
| 129. |
VALID_TIME_PERIOD |
pk_valid_time_period |
code |
| 130. |
VENDOR |
pk_vendor |
vendor_key |