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