P 2 K_PR_SUNDRY_LINE_DETAILS

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 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

Notes #

Click to create a new notes page

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation