Wiki: P 2 K_PR_PAY_LINE

Alias: PPLD#

(P2K_PR_PAY_LINE_DETAILS)

Unique Keys:
Child Table:
Parent Table:
ERD: ERD-PR55

Pay Line Details

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
PPC_ID	Number(10)	ID	Y	link to P2K_PR_PAY_COMPONENTS
PPL_ID	Number(10)	ID	Y	link to P2K_PR_PAY_LINES
PEL_ID	Number(10)	ID		link to P2K_PR_ELEMENTS
MVR_ID	Number(10)	ID		link to P2K_AM_USER_VARIABLES
SPM_ID	Number(10)	ID		link to P2K_SA_PREMIUMS
DSC_ID	Number(10)	ID		link to P2K_CM_STATISTIC_COMPONENTS
PAY_LINE_DETAIL_STATUS	Varchar2(2)	X_PAY_LINE_DETAIL_STATUS	Y
PC_ACTION	Varchar2(1)	X_PC_ACTION	Y
PC_DETAIL_TYPE	Varchar2(2)	X_PC_DETAIL_TYPE	Y
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
PC_CALC_METHOD	Varchar2(2)	X_PC_CALC_METHOD
DESCRIPTION	Varchar2(50)	DESCRIPTION
WAGE_RATE	Number(18)	AMT12V6
WAGE_RATE_OVERRIDE	Number(18)	AMT12V6
RATE_BASIS	Varchar2(2)	X_RATE_BASIS
RATE_BASIS_OVERRIDE	Varchar2(2)	X_RATE_BASIS
AMOUNT	Number(18)	AMT12V6
AMOUNT_OVERRIDE	Number(18)	AMT12V6
AMOUNT_PROCESSED	Number(18)	AMT12V6
RETRO_AMOUNT	Number(18)	AMT12V6
USER_VARIABLE_OVERRIDE	Number(18)	AMT12V6
DISTRIBUTION_CR_MASK	Varchar2(50)	DISTRIBUTION
PC_RATE_SOURCE	Varchar2(2)	X_PC_RATE_SOURCE
HIGHER_OF_RATE	Varchar2(1)	X_HIGHER_OF_RATE
DISTRIBUTION_DR_MASK	Varchar2(50)	DISTRIBUTION
AUDIT_TEXT	Varchar2(4000)	VARCHAR4000
REFERENCE_ID	Number(10)	NUMBER10
JOURNALIZED_BY	Varchar2(2)	X_JOURNALIZED_BY
PWCC_ID	Number(10)	ID		link to P2K_PR_WC_CLASSES
ENTERED_VALUE	Number(18)	AMT12V6
ENTERED_VALUE_SOURCE	Varchar2(50)	VARCHAR50
TRANSACTION_POINTER	Varchar2(30)	VARCHAR30
REFERENCE_ID_HOD	Number(10)	NUMBER10
REFERENCE_ID_REVERSAL	Number(10)	NUMBER10

User Fields: Not Allowed
Audit Logging: Not Allowed