FND Design Data [Home] [Help]

Table: PA_BILL_RATES_ALL

Product: PA - Projects
Description: Information about bill rates and markups of standard bill rate schedules
Implementation/DBA Data: TablePA.PA_BILL_RATES_ALL
Primary Key: PA_BILL_RATES_PK
  1. ColumnBILL_RATE_ORGANIZATION_ID
  2. ColumnSTD_BILL_RATE_SCHEDULE
  3. ColumnPERSON_ID
  4. ColumnSTART_DATE_ACTIVE
  5. ColumnJOB_ID
  6. ColumnEXPENDITURE_TYPE
  7. ColumnNON_LABOR_RESOURCE
  8. ColumnORG_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PA_BILL_RATES_ALL FK Joins to TablePA_STD_BILL_RATE_SCHEDULES_ALL PA_BILL_RATES_ALL.BILL_RATE_ORGANIZATION_ID
PA_BILL_RATES_ALL.STD_BILL_RATE_SCHEDULE
PA_BILL_RATES_ALL.ORG_ID
PA_BILL_RATES_ALL FK Joins to TablePA_EXPENDITURE_TYPES PA_BILL_RATES_ALL.EXPENDITURE_TYPE
PA_BILL_RATES_ALL FK Joins to TablePA_NON_LABOR_RESOURCES PA_BILL_RATES_ALL.NON_LABOR_RESOURCE
PA_BILL_RATES_ALL FK Joins to TablePER_JOBS PA_BILL_RATES_ALL.JOB_ID
PA_BILL_RATES_ALL FK Joins to TableFND_CURRENCIES PA_BILL_RATES_ALL.RATE_CURRENCY_CODE