Alias: PSLD#

(P2K_PR_SUNDRY_LINE_DETAILS)

Unique Keys:
Child Table:
Parent Table: P2K_PR_SUNDRY_LINES
ERD: ERD-PR40

Sundry Line Details

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
PSL_ID	Number(10)	ID	Y	link to P2K_PR_SUNDRY_LINES
PPC_ID	Number(10)	ID	Y	link to P2K_PR_PAY_COMPONENTS
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
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
USER_VARIABLE_OVERRIDE	Number(18)	AMT12V6
DISTRIBUTION_DR_MASK	Varchar2(50)	DISTRIBUTION
DISTRIBUTION_CR_MASK	Varchar2(50)	DISTRIBUTION
PC_RATE_SOURCE	Varchar2(2)	X_PC_RATE_SOURCE
HIGHER_OF_RATE	Varchar2(1)	X_HIGHER_OF_RATE
PPH_ID	Number(10)	ID		link to P2K_PR_PAY_HEADERS
DSC_ID	Number(10)	ID		link to P2K_CM_STATISTIC_COMPONENTS

User Fields: Allowed
Audit Logging: Not Allowed

---

Notes #

Click to create a new notes page