!!!Alias: PSLD Unique Keys: ___\\ Child Table: ___\\ Parent Table: ___\\ \\ 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|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[PC_CALC_METHOD]|Varchar2(2)|[X_PC_CALC_METHOD]| | |[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| | |[WAGE_RATE]|Number(18)|[AMT12V6|AMTnn]| | |[WAGE_RATE_OVERRIDE]|Number(18)|[AMT12V6|AMTnn]| | |[RATE_BASIS]|Varchar2(2)|[X_RATE_BASIS]| | |[RATE_BASIS_OVERRIDE]|Varchar2(2)|[X_RATE_BASIS]| | |[AMOUNT]|Number(18)|[AMT12V6|AMTnn]| | |[AMOUNT_OVERRIDE]|Number(18)|[AMT12V6|AMTnn]| | |[USER_VARIABLE_OVERRIDE]|Number(18)|[AMT12V6|AMTnn]| | |[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\\