Alias: PSLD#

Unique Keys: _
Child Table:
_
Parent Table: _

Sundry Line Details

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
PSL_IDNumber(10)IDYlink to P2K_PR_SUNDRY_LINES
PPC_IDNumber(10)IDYlink to P2K_PR_PAY_COMPONENTS
PEL_IDNumber(10)ID link to P2K_PR_ELEMENTS
MVR_IDNumber(10)ID link to P2K_AM_USER_VARIABLES
SPM_IDNumber(10)ID link to P2K_SA_PREMIUMS
PC_ACTIONVarchar2(1)X_PC_ACTIONY
PC_DETAIL_TYPEVarchar2(2)X_PC_DETAIL_TYPEY
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
PC_CALC_METHODVarchar2(2)X_PC_CALC_METHOD
DESCRIPTIONVarchar2(50)DESCRIPTION
WAGE_RATENumber(18)AMT12V6
WAGE_RATE_OVERRIDENumber(18)AMT12V6
RATE_BASISVarchar2(2)X_RATE_BASIS
RATE_BASIS_OVERRIDEVarchar2(2)X_RATE_BASIS
AMOUNTNumber(18)AMT12V6
AMOUNT_OVERRIDENumber(18)AMT12V6
USER_VARIABLE_OVERRIDENumber(18)AMT12V6
DISTRIBUTION_DR_MASKVarchar2(50)DISTRIBUTION
DISTRIBUTION_CR_MASKVarchar2(50)DISTRIBUTION
PC_RATE_SOURCEVarchar2(2)X_PC_RATE_SOURCE
HIGHER_OF_RATEVarchar2(1)X_HIGHER_OF_RATE
PPH_IDNumber(10)ID link to P2K_PR_PAY_HEADERS
DSC_IDNumber(10)ID link to P2K_CM_STATISTIC_COMPONENTS

User Fields: Allowed
Audit Logging: Not Allowed