P 2 K_PR_PAY_TRANSACTIONS

Alias: PTR#

(P2K_PR_PAY_TRANSACTIONS)

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


Pay Transactions

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
PBT_IDNumber(10)IDYlink to P2K_PR_BATCHES
PPH_IDNumber(10)ID link to P2K_PR_PAY_HEADERS
SPM_IDNumber(10)ID link to P2K_SA_PREMIUMS
DPS_IDNumber(10)ID link to P2K_CM_POSITIONS
DJB_IDNumber(10)ID link to P2K_CM_JOBS
DTX_IDNumber(10)ID link to P2K_CM_TAX_JURISDICTIONS
DDP_IDNumber(10)ID link to P2K_CM_DEPARTMENTS
EAS_IDNumber(10)IDYlink to P2K_HR_ASSIGNMENTS
DWR_IDNumber(10)IDYlink to P2K_CM_WORK_RULES
MEX_ID_GENERATEDNumber(10)ID link to P2K_AM_EXECUTIONS
DTC_IDNumber(10)ID link to P2K_CM_TIME_CODES
DCC_IDNumber(10)ID link to P2K_CM_COST_CENTERS
MEX_ID_INTO_PAYROLLNumber(10)ID link to P2K_AM_EXECUTIONS
PAY_TRAN_STATUSVarchar2(2)X_PAY_TRAN_STATUSY
PAY_TRAN_SOURCEVarchar2(2)X_PAY_TRAN_SOURCEY
START_DATEDate()DATEY
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
END_DATEDate()DATE
TIME_OR_AMOUNTNumber(18)AMT12V6
SCHEDULED_TIMENumber(9)AMT5V4
WAGE_RATENumber(18)AMT12V6
RATE_BASISVarchar2(2)X_RATE_BASIS
DISTRIBUTION_MASKVarchar2(50)DISTRIBUTION
WORK_IN_PROCESSVarchar2(1)TOGGLE
REFERENCE_INFOVarchar2(2000)VARCHAR2000
AUDIT_TEXTVarchar2(4000)VARCHAR4000
RATE_OVERRIDDENVarchar2(1)TOGGLE
WORK_ORDERVarchar2(50)VARCHAR50
TRANSACTION_POINTERVarchar2(30)VARCHAR30
USE_ALTERNATE_TIME_CODEVarchar2(1)TOGGLE
EQUIPMENT_CODEVarchar2(30)VARCHAR30
POSTED_EQUIPMENTVarchar2(1)TOGGLE

Derived Fields#

Column Name
DRV_EAS_ID_CODE
DRV_GENERATED_BY
DRV_LEAVE
DRV_OTHER
DRV_REG
DRV_TOTAL_HOURS
DRV_UPDATED_BY

User Fields: Allowed
Audit Logging: Not Allowed


Notes #

Click to create a new notes page