FND Design Data [Home] [Help]

Table: CN_PERIOD_STATUSES_ALL

Product: CN - Incentive Compensation
Description: Status of the Sales Compensation accounting periods. In addition to the GL status.
Implementation/DBA Data: TableCN.CN_PERIOD_STATUSES_ALL
Primary Key: CN_PERIOD_STATUSES_PK
  1. ColumnPERIOD_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
CN_PERIOD_STATUSES_ALL FK Joins to TableGL_PERIODS CN_PERIOD_STATUSES_ALL.PERIOD_SET_NAME
CN_PERIOD_STATUSES_ALL.PERIOD_NAME
TableCN_COMMISSION_LINES_ALL FK Joins to CN_PERIOD_STATUSES_ALL CN_COMMISSION_LINES_ALL.PROCESSED_PERIOD_ID
TableCN_COMM_LINES_API_ALL FK Joins to CN_PERIOD_STATUSES_ALL CN_COMM_LINES_API_ALL.PROCESSED_PERIOD_ID
TableCN_PAYMENT_API_ALL FK Joins to CN_PERIOD_STATUSES_ALL CN_PAYMENT_API_ALL.PERIOD_ID
TableCN_PAYRUNS_ALL FK Joins to CN_PERIOD_STATUSES_ALL CN_PAYRUNS_ALL.ACCOUNTING_PERIOD_ID
TableCN_PAYRUNS_ALL FK Joins to CN_PERIOD_STATUSES_ALL CN_PAYRUNS_ALL.PAY_PERIOD_ID
TableCN_PERIOD_QUOTAS_ALL FK Joins to CN_PERIOD_STATUSES_ALL CN_PERIOD_QUOTAS_ALL.PERIOD_ID
TableCN_PROCESS_BATCHES_ALL FK Joins to CN_PERIOD_STATUSES_ALL CN_PROCESS_BATCHES_ALL.PERIOD_ID
TableCN_SRP_PERIODS_ALL FK Joins to CN_PERIOD_STATUSES_ALL CN_SRP_PERIODS_ALL.PERIOD_ID
TableCN_SRP_PERIOD_QUOTAS_ALL FK Joins to CN_PERIOD_STATUSES_ALL CN_SRP_PERIOD_QUOTAS_ALL.PERIOD_ID