[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CN_SRP_PERIODS_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | CN |
| FND Design Data: |  CN.CN_SRP_PERIODS_ALL
|
| Subobject Name: | |
| Status: | VALID |
CN_SRP_PERIODS stores detailed information about a salesperson's
compensation
You need one row for each period in which the salesperson is active.
The user cannot directly insert into this table. Rows are automaticall
y
created when you define a new salesperson. One row is created
for each period forward from and including the salesperson's
start period (RA_SALESREPS.START_PROCESING_PERIOD_ID).
Rows are never deleted.
.
SRP_PERIOD_ID is the unique system generated primary key
invisible to the user.
.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| CN_SRP_PERIODS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 SRP_PERIOD_ID
ORG_ID
|
| CN_SRP_PERIODS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
SALESREP_ID
PERIOD_ID
QUOTA_ID
CREDIT_TYPE_ID
ROLE_ID
ORG_ID
|
| CN_SRP_PERIODS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PERIOD_ID
SALESREP_ID
|
| CN_SRP_PERIODS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
QUOTA_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORG_ID | NUMBER | (15) | Organization identifier | |
| SRP_PERIOD_ID | NUMBER | (15) | Yes | Primary key |
| SALESREP_ID | NUMBER | (15) | Yes | Salesperson unique identifier |
| PERIOD_ID | NUMBER | (15) | Yes | Sales compensation period unique identifier |
| SRP_PLAN_ASSIGN_ID | NUMBER | (15) | Salesperson compensation plan unique identifier | |
| STATUS | VARCHAR2 | (10) | ||
| CALC_BATCH_ID | NUMBER | (15) | ||
| PERIOD_TYPE_ID | NUMBER | (15) | ||
| CASH_DTD | NUMBER | |||
| CASH_CTD | NUMBER | |||
| CASH_BBD | NUMBER | |||
| CASH_BBC | NUMBER | |||
| DUE_DTD | NUMBER | |||
| DUE_CTD | NUMBER | |||
| DUE_BBD | NUMBER | |||
| DUE_BBC | NUMBER | |||
| COMMISSION_EARNED_DTD | NUMBER | |||
| COMMISSION_EARNED_CTD | NUMBER | |||
| COMMISSION_EARNED_BBD | NUMBER | |||
| COMMISSION_EARNED_BBC | NUMBER | |||
| BONUS_EARNED_DTD | NUMBER | |||
| BONUS_EARNED_CTD | NUMBER | |||
| BONUS_EARNED_BBD | NUMBER | |||
| BONUS_EARNED_BBC | NUMBER | |||
| DRAW_NONREC_DTD | NUMBER | |||
| DRAW_NONREC_CTD | NUMBER | |||
| DRAW_NONREC_BBD | NUMBER | |||
| DRAW_NONREC_BBC | NUMBER | |||
| PAYROLL_DUE_DTD | NUMBER | |||
| PAYROLL_DUE_CTD | NUMBER | |||
| PAYROLL_DUE_BBD | NUMBER | |||
| PAYROLL_DUE_BBC | NUMBER | |||
| PAYROLL_TRANSFER_DTD | NUMBER | |||
| PAYROLL_TRANSFER_CTD | NUMBER | |||
| PAYROLL_TRANSFER_BBD | NUMBER | |||
| PAYROLL_TRANSFER_BBC | NUMBER | |||
| DRAW_PAYABLE_DTD | NUMBER | |||
| DRAW_PAYABLE_CTD | NUMBER | |||
| DRAW_PAYABLE_BBD | NUMBER | |||
| DRAW_PAYABLE_BBC | NUMBER | |||
| MISC_EARNED_DTD | NUMBER | |||
| MISC_EARNED_CTD | NUMBER | |||
| MISC_EARNED_BBD | NUMBER | |||
| MISC_EARNED_BBC | NUMBER | |||
| TRANSFERRED | NUMBER | |||
| CLASSIFIED | NUMBER | |||
| UNCLASSIFIED | NUMBER | |||
| DIRECT_PAYED | NUMBER | |||
| DIRECT_UNPAYED | NUMBER | |||
| INDIRECT_PAYED | NUMBER | |||
| CALCULATED | NUMBER | |||
| UNCALCULATED | NUMBER | |||
| SUB_CALCULATED | NUMBER | |||
| SUB_UNCALCULATED | NUMBER | |||
| BALANCE10_DTD | NUMBER | System generated balance | ||
| BALANCE10_CTD | NUMBER | System generated balance | ||
| BALANCE10_BBD | NUMBER | System generated balance | ||
| BALANCE10_BBC | NUMBER | System generated balance | ||
| BALANCE11_DTD | NUMBER | System generated balance | ||
| BALANCE11_CTD | NUMBER | System generated balance | ||
| BALANCE11_BBD | NUMBER | System generated balance | ||
| BALANCE11_BBC | NUMBER | System generated balance | ||
| BALANCE12_DTD | NUMBER | System generated balance | ||
| BALANCE12_CTD | NUMBER | System generated balance | ||
| BALANCE12_BBD | NUMBER | System generated balance | ||
| BALANCE12_BBC | NUMBER | System generated balance | ||
| BALANCE13_DTD | NUMBER | System generated balance | ||
| BALANCE13_CTD | NUMBER | System generated balance | ||
| BALANCE13_BBD | NUMBER | System generated balance | ||
| BALANCE13_BBC | NUMBER | System generated balance | ||
| BALANCE14_DTD | NUMBER | System generated balance | ||
| BALANCE14_CTD | NUMBER | System generated balance | ||
| BALANCE14_BBD | NUMBER | System generated balance | ||
| BALANCE14_BBC | NUMBER | System generated balance | ||
| BALANCE15_DTD | NUMBER | System generated balance | ||
| BALANCE15_CTD | NUMBER | System generated balance | ||
| BALANCE15_BBD | NUMBER | System generated balance | ||
| BALANCE15_BBC | NUMBER | System generated balance | ||
| BALANCE16_DTD | NUMBER | System generated balance | ||
| BALANCE16_CTD | NUMBER | System generated balance | ||
| BALANCE16_BBD | NUMBER | System generated balance | ||
| BALANCE16_BBC | NUMBER | System generated balance | ||
| BALANCE17_DTD | NUMBER | System generated balance | ||
| BALANCE17_CTD | NUMBER | System generated balance | ||
| BALANCE17_BBD | NUMBER | System generated balance | ||
| BALANCE17_BBC | NUMBER | System generated balance | ||
| BALANCE18_DTD | NUMBER | System generated balance | ||
| BALANCE18_CTD | NUMBER | System generated balance | ||
| BALANCE18_BBD | NUMBER | System generated balance | ||
| BALANCE18_BBC | NUMBER | System generated balance | ||
| BALANCE19_DTD | NUMBER | System generated balance | ||
| BALANCE19_CTD | NUMBER | System generated balance | ||
| BALANCE19_BBD | NUMBER | System generated balance | ||
| BALANCE19_BBC | NUMBER | System generated balance | ||
| BALANCE20_DTD | NUMBER | System generated balance | ||
| BALANCE20_CTD | NUMBER | System generated balance | ||
| BALANCE20_BBD | NUMBER | System generated balance | ||
| BALANCE20_BBC | NUMBER | System generated balance | ||
| BALANCE21_DTD | NUMBER | System generated balance | ||
| BALANCE21_CTD | NUMBER | System generated balance | ||
| BALANCE21_BBD | NUMBER | System generated balance | ||
| BALANCE21_BBC | NUMBER | System generated balance | ||
| BALANCE22_DTD | NUMBER | System generated balance | ||
| BALANCE22_CTD | NUMBER | System generated balance | ||
| BALANCE22_BBD | NUMBER | System generated balance | ||
| BALANCE22_BBC | NUMBER | System generated balance | ||
| BALANCE23_DTD | NUMBER | System generated balance | ||
| BALANCE23_CTD | NUMBER | System generated balance | ||
| BALANCE23_BBD | NUMBER | System generated balance | ||
| BALANCE23_BBC | NUMBER | System generated balance | ||
| BALANCE24_DTD | NUMBER | System generated balance | ||
| BALANCE24_CTD | NUMBER | System generated balance | ||
| BALANCE24_BBD | NUMBER | System generated balance | ||
| BALANCE24_BBC | NUMBER | System generated balance | ||
| BALANCE25_DTD | NUMBER | System generated balance | ||
| BALANCE25_CTD | NUMBER | System generated balance | ||
| BALANCE25_BBD | NUMBER | System generated balance | ||
| BALANCE25_BBC | NUMBER | System generated balance | ||
| CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
| CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| PROCESSING_STATUS_CODE | VARCHAR2 | (30) | ||
| PROCESS_ALL_FLAG | VARCHAR2 | (1) | ||
| REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
| PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
| CONSISTENCY_FLAG | VARCHAR2 | (1) | whether consistent or not | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
| START_DATE | DATE | Start Date | ||
| END_DATE | DATE | End Date | ||
| CREDIT_TYPE_ID | NUMBER | (15) | Yes | Credit type identifier |
| ROLE_ID | NUMBER | (15) | Role identifier | |
| PAY_GROUP_ID | NUMBER | (15) | Pay Group Identifier | |
| PAID_FLAG | VARCHAR2 | (1) | Paid Flag | |
| BALANCE1_DTD | NUMBER | Period to date amount paid. Not include recoverd or waived amount. | ||
| BALANCE1_CTD | NUMBER | Period to date amount recovered and waived | ||
| BALANCE1_BBD | NUMBER | Begin balance of amount paid. Not include recoverd or waived amount. | ||
| BALANCE1_BBC | NUMBER | Begin balance of amount recovered and waived | ||
| BALANCE2_DTD | NUMBER | Period to date earnings | ||
| BALANCE2_CTD | NUMBER | Period to date earnings paid | ||
| BALANCE2_BBD | NUMBER | Begin balance of earnings | ||
| BALANCE2_BBC | NUMBER | Begin balance of earnings paid | ||
| BALANCE3_DTD | NUMBER | System generated balance | ||
| BALANCE3_CTD | NUMBER | Period to date earnings | ||
| BALANCE3_BBD | NUMBER | System generated balance | ||
| BALANCE3_BBC | NUMBER | Begin balance of earnings | ||
| BALANCE4_DTD | NUMBER | Period to date recoverable paid | ||
| BALANCE4_CTD | NUMBER | Period to date recovered paid | ||
| BALANCE4_BBD | NUMBER | Begin balance of recoverable paid | ||
| BALANCE4_BBC | NUMBER | Begin balance of recovered paid | ||
| BALANCE5_DTD | NUMBER | Period to date non recoverable paid and waived recovery paid | ||
| BALANCE5_CTD | NUMBER | Period to date non recoverable paid and waived recovery paid | ||
| BALANCE5_BBD | NUMBER | Begin balance of non recoverable paid and waived recovery paid | ||
| BALANCE5_BBC | NUMBER | Begin balance of non recoverable paid and waived recovery paid | ||
| BALANCE6_DTD | NUMBER | System generated balance | ||
| BALANCE6_CTD | NUMBER | System generated balance | ||
| BALANCE6_BBD | NUMBER | System generated balance | ||
| BALANCE6_BBC | NUMBER | System generated balance | ||
| BALANCE7_DTD | NUMBER | System generated balance | ||
| BALANCE7_CTD | NUMBER | System generated balance | ||
| BALANCE7_BBD | NUMBER | System generated balance | ||
| BALANCE7_BBC | NUMBER | System generated balance | ||
| BALANCE8_DTD | NUMBER | System generated balance | ||
| BALANCE8_CTD | NUMBER | System generated balance | ||
| BALANCE8_BBD | NUMBER | System generated balance | ||
| BALANCE8_BBC | NUMBER | System generated balance | ||
| BALANCE9_DTD | NUMBER | System generated balance | ||
| BALANCE9_CTD | NUMBER | System generated balance | ||
| BALANCE9_BBD | NUMBER | System generated balance | ||
| BALANCE9_BBC | NUMBER | System generated balance | ||
| BALANCE26_DTD | NUMBER | System generated balance | ||
| BALANCE26_CTD | NUMBER | System generated balance | ||
| BALANCE26_BBD | NUMBER | System generated balance | ||
| BALANCE26_BBC | NUMBER | System generated balance | ||
| BALANCE27_DTD | NUMBER | System generated balance | ||
| BALANCE27_CTD | NUMBER | System generated balance | ||
| BALANCE27_BBD | NUMBER | System generated balance | ||
| BALANCE27_BBC | NUMBER | System generated balance | ||
| BALANCE28_DTD | NUMBER | System generated balance | ||
| BALANCE28_CTD | NUMBER | System generated balance | ||
| BALANCE28_BBD | NUMBER | System generated balance | ||
| BALANCE28_BBC | NUMBER | System generated balance | ||
| BALANCE29_DTD | NUMBER | System generated balance | ||
| BALANCE29_CTD | NUMBER | System generated balance | ||
| BALANCE29_BBD | NUMBER | System generated balance | ||
| BALANCE29_BBC | NUMBER | System generated balance | ||
| BALANCE30_DTD | NUMBER | System generated balance | ||
| BALANCE30_CTD | NUMBER | System generated balance | ||
| BALANCE30_BBD | NUMBER | System generated balance | ||
| BALANCE30_BBC | NUMBER | System generated balance | ||
| BALANCE31_DTD | NUMBER | System generated balance | ||
| BALANCE31_CTD | NUMBER | System generated balance | ||
| BALANCE31_BBD | NUMBER | System generated balance | ||
| BALANCE31_BBC | NUMBER | System generated balance | ||
| BALANCE32_DTD | NUMBER | System generated balance | ||
| BALANCE32_CTD | NUMBER | System generated balance | ||
| BALANCE32_BBD | NUMBER | System generated balance | ||
| BALANCE32_BBC | NUMBER | System generated balance | ||
| BALANCE33_DTD | NUMBER | System generated balance | ||
| BALANCE33_CTD | NUMBER | System generated balance | ||
| BALANCE33_BBD | NUMBER | System generated balance | ||
| BALANCE33_BBC | NUMBER | System generated balance | ||
| SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
| QUOTA_ID | NUMBER | Plan Element unique identifier |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_ID
, SRP_PERIOD_ID
, SALESREP_ID
, PERIOD_ID
, SRP_PLAN_ASSIGN_ID
, STATUS
, CALC_BATCH_ID
, PERIOD_TYPE_ID
, CASH_DTD
, CASH_CTD
, CASH_BBD
, CASH_BBC
, DUE_DTD
, DUE_CTD
, DUE_BBD
, DUE_BBC
, COMMISSION_EARNED_DTD
, COMMISSION_EARNED_CTD
, COMMISSION_EARNED_BBD
, COMMISSION_EARNED_BBC
, BONUS_EARNED_DTD
, BONUS_EARNED_CTD
, BONUS_EARNED_BBD
, BONUS_EARNED_BBC
, DRAW_NONREC_DTD
, DRAW_NONREC_CTD
, DRAW_NONREC_BBD
, DRAW_NONREC_BBC
, PAYROLL_DUE_DTD
, PAYROLL_DUE_CTD
, PAYROLL_DUE_BBD
, PAYROLL_DUE_BBC
, PAYROLL_TRANSFER_DTD
, PAYROLL_TRANSFER_CTD
, PAYROLL_TRANSFER_BBD
, PAYROLL_TRANSFER_BBC
, DRAW_PAYABLE_DTD
, DRAW_PAYABLE_CTD
, DRAW_PAYABLE_BBD
, DRAW_PAYABLE_BBC
, MISC_EARNED_DTD
, MISC_EARNED_CTD
, MISC_EARNED_BBD
, MISC_EARNED_BBC
, TRANSFERRED
, CLASSIFIED
, UNCLASSIFIED
, DIRECT_PAYED
, DIRECT_UNPAYED
, INDIRECT_PAYED
, CALCULATED
, UNCALCULATED
, SUB_CALCULATED
, SUB_UNCALCULATED
, BALANCE10_DTD
, BALANCE10_CTD
, BALANCE10_BBD
, BALANCE10_BBC
, BALANCE11_DTD
, BALANCE11_CTD
, BALANCE11_BBD
, BALANCE11_BBC
, BALANCE12_DTD
, BALANCE12_CTD
, BALANCE12_BBD
, BALANCE12_BBC
, BALANCE13_DTD
, BALANCE13_CTD
, BALANCE13_BBD
, BALANCE13_BBC
, BALANCE14_DTD
, BALANCE14_CTD
, BALANCE14_BBD
, BALANCE14_BBC
, BALANCE15_DTD
, BALANCE15_CTD
, BALANCE15_BBD
, BALANCE15_BBC
, BALANCE16_DTD
, BALANCE16_CTD
, BALANCE16_BBD
, BALANCE16_BBC
, BALANCE17_DTD
, BALANCE17_CTD
, BALANCE17_BBD
, BALANCE17_BBC
, BALANCE18_DTD
, BALANCE18_CTD
, BALANCE18_BBD
, BALANCE18_BBC
, BALANCE19_DTD
, BALANCE19_CTD
, BALANCE19_BBD
, BALANCE19_BBC
, BALANCE20_DTD
, BALANCE20_CTD
, BALANCE20_BBD
, BALANCE20_BBC
, BALANCE21_DTD
, BALANCE21_CTD
, BALANCE21_BBD
, BALANCE21_BBC
, BALANCE22_DTD
, BALANCE22_CTD
, BALANCE22_BBD
, BALANCE22_BBC
, BALANCE23_DTD
, BALANCE23_CTD
, BALANCE23_BBD
, BALANCE23_BBC
, BALANCE24_DTD
, BALANCE24_CTD
, BALANCE24_BBD
, BALANCE24_BBC
, BALANCE25_DTD
, BALANCE25_CTD
, BALANCE25_BBD
, BALANCE25_BBC
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROCESSING_STATUS_CODE
, PROCESS_ALL_FLAG
, REQUEST_ID
, PROGRAM_ID
, CONSISTENCY_FLAG
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, START_DATE
, END_DATE
, CREDIT_TYPE_ID
, ROLE_ID
, PAY_GROUP_ID
, PAID_FLAG
, BALANCE1_DTD
, BALANCE1_CTD
, BALANCE1_BBD
, BALANCE1_BBC
, BALANCE2_DTD
, BALANCE2_CTD
, BALANCE2_BBD
, BALANCE2_BBC
, BALANCE3_DTD
, BALANCE3_CTD
, BALANCE3_BBD
, BALANCE3_BBC
, BALANCE4_DTD
, BALANCE4_CTD
, BALANCE4_BBD
, BALANCE4_BBC
, BALANCE5_DTD
, BALANCE5_CTD
, BALANCE5_BBD
, BALANCE5_BBC
, BALANCE6_DTD
, BALANCE6_CTD
, BALANCE6_BBD
, BALANCE6_BBC
, BALANCE7_DTD
, BALANCE7_CTD
, BALANCE7_BBD
, BALANCE7_BBC
, BALANCE8_DTD
, BALANCE8_CTD
, BALANCE8_BBD
, BALANCE8_BBC
, BALANCE9_DTD
, BALANCE9_CTD
, BALANCE9_BBD
, BALANCE9_BBC
, BALANCE26_DTD
, BALANCE26_CTD
, BALANCE26_BBD
, BALANCE26_BBC
, BALANCE27_DTD
, BALANCE27_CTD
, BALANCE27_BBD
, BALANCE27_BBC
, BALANCE28_DTD
, BALANCE28_CTD
, BALANCE28_BBD
, BALANCE28_BBC
, BALANCE29_DTD
, BALANCE29_CTD
, BALANCE29_BBD
, BALANCE29_BBC
, BALANCE30_DTD
, BALANCE30_CTD
, BALANCE30_BBD
, BALANCE30_BBC
, BALANCE31_DTD
, BALANCE31_CTD
, BALANCE31_BBD
, BALANCE31_BBC
, BALANCE32_DTD
, BALANCE32_CTD
, BALANCE32_BBD
, BALANCE32_BBC
, BALANCE33_DTD
, BALANCE33_CTD
, BALANCE33_BBD
, BALANCE33_BBC
, SECURITY_GROUP_ID
, QUOTA_ID
FROM CN.CN_SRP_PERIODS_ALL;
CN.CN_SRP_PERIODS_ALL does not reference any database object
CN.CN_SRP_PERIODS_ALL is referenced by following:
APPS
CN_SRP_PERIODS
CN_SRP_PERIODS_ALL
|
|
|
|