CN_SRP_SUBLEDGER_ALL
CN_SRP_PERIODS stores the 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. .
Details
-
Schema: FUSION
-
Object owner: CN
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
CN_SRP_SUBLEDGER_ALL_PK |
SRP_SUBLEDGER_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
SRP_SUBLEDGER_ID | NUMBER | 18 | Yes | System Generated Primary key. | |
PARTICIPANT_ID | NUMBER | 18 | Yes | Salesperson unique identifier | |
PERIOD_ID | NUMBER | 18 | Yes | Period unique identifier | |
SRP_COMP_PLAN_ID | NUMBER | 18 | Salesperson compensation plan unique identifier | ||
PLAN_COMPONENT_ID | NUMBER | 18 | Plan Component unique identifier | ||
CASH_DTD | NUMBER | Cash Debit to Date | |||
CASH_CTD | NUMBER | Cash Credit to Date | |||
CASH_BBD | NUMBER | Cash Begin Balance Debit | |||
CASH_BBC | NUMBER | Cash Begin Balance Credit | |||
DUE_DTD | NUMBER | Due Debit to Date | |||
DUE_CTD | NUMBER | Due Credit to Date | |||
DUE_BBD | NUMBER | Due Begin Balance Debit | |||
DUE_BBC | NUMBER | Due Begin Balance Credit | |||
COMMISSION_EARNED_DTD | NUMBER | commission earned debit to date | |||
COMMISSION_EARNED_CTD | NUMBER | Commission earned credit to date | |||
COMMISSION_EARNED_BBD | NUMBER | commission earned begin balance debit | |||
COMMISSION_EARNED_BBC | NUMBER | commission earned begin balance credit | |||
BONUS_EARNED_DTD | NUMBER | Bonus earned debit to date | |||
BONUS_EARNED_CTD | NUMBER | Bonus earned credit to date | |||
BONUS_EARNED_BBD | NUMBER | Bonus earned begin balance debit | |||
BONUS_EARNED_BBC | NUMBER | Bonus earned begin balance credit | |||
DRAW_NONREC_DTD | NUMBER | Draw debit to date | |||
DRAW_NONREC_CTD | NUMBER | Draw credit to date | |||
DRAW_NONREC_BBD | NUMBER | Draw Begin balance Debit | |||
DRAW_NONREC_BBC | NUMBER | Draw Begin Balance Credit | |||
PAYROLL_DUE_DTD | NUMBER | Payroll Due debit to date | |||
PAYROLL_DUE_CTD | NUMBER | Payroll due credit to date | |||
PAYROLL_DUE_BBD | NUMBER | Payroll due begin balance debit | |||
PAYROLL_DUE_BBC | NUMBER | Payroll due begin balance credit | |||
PAYROLL_TRANSFER_DTD | NUMBER | Payroll transfer debit to date | |||
PAYROLL_TRANSFER_CTD | NUMBER | Payroll transfer credit to date | |||
PAYROLL_TRANSFER_BBD | NUMBER | Payroll transfer begin balance debit | |||
PAYROLL_TRANSFER_BBC | NUMBER | payroll transfer begin balance credit | |||
DRAW_PAYABLE_DTD | NUMBER | Draw Payable debit to date | |||
DRAW_PAYABLE_CTD | NUMBER | Draw payable credit to date | |||
DRAW_PAYABLE_BBD | NUMBER | Draw payable begin balance debit | |||
DRAW_PAYABLE_BBC | NUMBER | Draw Payable begin balance credit | |||
MISC_EARNED_DTD | NUMBER | Misc Earning debit to date | |||
MISC_EARNED_CTD | NUMBER | Misc Earning credit to date | |||
MISC_EARNED_BBD | NUMBER | Misc Earning begin balance debit | |||
MISC_EARNED_BBC | NUMBER | Misc Earning begin balance credit | |||
CONSISTENCY_FLAG | VARCHAR2 | 1 | whether consistent or not | ||
START_DATE | DATE | Start Date Effective | |||
END_DATE | DATE | End Date Effective | |||
EARNING_TYPE_ID | NUMBER | 18 | Yes | Earning type identifier | |
ROLE_ID | NUMBER | 18 | Role identifier | ||
PAY_GROUP_ID | NUMBER | 18 | 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 | Balance Column | |||
BALANCE5_BBC | NUMBER | Balance Column | |||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
CURRENCY_CODE | VARCHAR2 | 30 | Yes | Currency Code |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
CN_SRP_SUBLEDGER_ALL | cn_srp_comp_plans_all | SRP_COMP_PLAN_ID |
CN_SRP_SUBLEDGER_ALL | cn_srp_participants_all | PARTICIPANT_ID |
CN_SRP_SUBLEDGER_ALL | cn_plan_components_all_b | PLAN_COMPONENT_ID, ORG_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CN_SRP_SUBLEDGER_N1 | Non Unique | Default | PARTICIPANT_ID, PERIOD_ID, START_DATE, END_DATE, ORG_ID |
CN_SRP_SUBLEDGER_N2 | Non Unique | Default | PARTICIPANT_ID, PERIOD_ID, EARNING_TYPE_ID, CURRENCY_CODE, PLAN_COMPONENT_ID, ORG_ID |
CN_SRP_SUBLEDGER_N4 | Non Unique | Default | PLAN_COMPONENT_ID, PARTICIPANT_ID, EARNING_TYPE_ID, PERIOD_ID, ROLE_ID |
CN_SRP_SUBLEDGER_N5 | Non Unique | Default | SRP_COMP_PLAN_ID |
CN_SRP_SUBLEDGER_U1 | Unique | Default | SRP_SUBLEDGER_ID |