User Guide‎ > ‎

Merge Code for Payslip

for Mail Merge Word/Excel Documents 

[BATCH_NO]
[PERIOD]
[PERIOD_FROM]
[PERIOD_FROM_LONG]
[PERIOD_TO]
[PERIOD_TO_LONG]
[JOIN_DATE]
[JOIN_DATE_LONG]
[TERMN_DATE]
[TERMN_DATE_LONG]
[POSTED]
[EE_NO]
[EE_NAME]
[CALL_NAME]
[EENAME]
[CHI_NAME]
[DEPT_CODE]
[DEPARTMENT]
[EE_CLASS]
[COST_CENTRE]
[POSITION]
[EMAIL]
[HAVE_EMAIL]
[EMAIL_PAYSLIP]
[HKID]
[SALARY_PAY_DATE]
[SALARY_PAY_DATE_LONG]
[MPF_CONTRIBUTION_DATE]
[MPF_CONTRIBUTION_DATE_LONG]
[MPF_CPERD1]
[MPF_CPERD1_LONG]
[MPF_CPERD2]
[MPF_CPERD2_LONG]
[MPF_EMPLOYER_ID]
[AUTOPAY]
[PAID_BY]
[CHEQUE_NO]
[WORKS_DAYS]
[DECRYPT_BASIC_SAL_REF]
[DECRYPT_BASIC_SAL]
[DECRYPT_HDY_PAY]
[HDY_LEAVE]
[DECRYPT_ANN_PAY]
[ANN_LEAVE]
[DECRYPT_SICK_PAY]
[DECRYPT_SICK_PAY_LM]
[DECRYPT_SICK_PAY_C]
[SICK_LEAVE]
[SICK_LEAVE_LM]
[DECRYPT_SICK_PAY2]
[DECRYPT_SICK_PAY2_LM]
[DECRYPT_SICK_PAY2_C]
[SICK_LEAVE2]
[SICK_LEAVE2_LM]
[DECRYPT_MATERNITYLEAVE_PAY]
[DECRYPT_MATERNITYLEAVE_PAY_LM]
[DECRYPT_MATERNITYLEAVE_PAY_C]
[MATERNITYLEAVE_DAY]
[MATERNITYLEAVE_DAY_LM]
[DECRYPT_OT_PAY]
[DECRYPT_OT_PAY2]
[DECRYPT_OT_PAY3]
[DECRYPT_OT_PAY4]
[DECRYPT_OT_PAY5]
[DECRYPT_OT_PAY6]
[DECRYPT_OT_PAY7]
[DECRYPT_OT_PAY8]
[DECRYPT_DEDUCTION_AMT]
[DECRYPT_ALLOWANCE]
[ALLOWANCE_DESC]
[DECRYPT_ALLOWANCE2]
[ALLOWANCE2_DESC]
[DECRYPT_DOUBLE_PAY]
[DECRYPT_BONUS]
[DECRYPT_PAY_TYPE1_AMT]
[DECRYPT_PAY_TYPE2_AMT]
[DECRYPT_PAY_TYPE3_AMT]
[DECRYPT_PAY_TYPE4_AMT]
[DECRYPT_PAY_TYPE5_AMT]
[DECRYPT_PAY_TYPE6_AMT]
[DECRYPT_PAY_TYPE7_AMT]
[DECRYPT_PAY_TYPE8_AMT]
[DECRYPT_PAY_TYPE9_AMT]
[DECRYPT_PAY_TYPE10_AMT]
[DECRYPT_PAY_TYPE11_AMT]
[DECRYPT_PAY_TYPE12_AMT]
[DECRYPT_PAY_TYPE13_AMT]
[DECRYPT_PAY_TYPE14_AMT]
[DECRYPT_PAY_TYPE15_AMT]
[DECRYPT_OTHER_EARNING1]
[DECRYPT_OTHER_EARNING2]
[DECRYPT_OTHER_EARNING3]
[DECRYPT_OTHER_EARNING4]
[DECRYPT_OTHER_EARNING5]
[DECRYPT_OTHER_EARNING6]
[DECRYPT_OTHER_EARNING7]
[DECRYPT_OTHER_EARNING8]
[DECRYPT_OTHER_EARNING9]
[DECRYPT_OTHER_EARNING10]
[DECRYPT_OTHER_EARNING11]
[DECRYPT_OTHER_EARNING12]
[DECRYPT_OTHER_EARNING13]
[DECRYPT_OTHER_EARNING14]
[DECRYPT_OTHER_EARNING15]
[DECRYPT_OTHER_DEDUCTION1]
[DECRYPT_OTHER_DEDUCTION2]
[DECRYPT_OTHER_DEDUCTION3]
[DECRYPT_OTHER_DEDUCTION4]
[DECRYPT_OTHER_DEDUCTION5]
[DECRYPT_OTHER_DEDUCTION6]
[DECRYPT_OTHER_DEDUCTION7]
[DECRYPT_OTHER_DEDUCTION8]
[DECRYPT_OTHER_DEDUCTION9]
[DECRYPT_OTHER_DEDUCTION10]
[DECRYPT_OTHER_DEDUCTION11]
[DECRYPT_OTHER_DEDUCTION12]
[DECRYPT_OTHER_DEDUCTION13]
[DECRYPT_OTHER_DEDUCTION14]
[DECRYPT_OTHER_DEDUCTION15]
[DECRYPT_NOPAY_PAY]
[DECRYPT_NOPAY_PAY_LM]
[DECRYPT_NOPAY_PAY_C]
[DECRYPT_GROSS_SALARY]
[PFUND_TYPE]
[DECRYPT_PFUND_EE_PAY]
[DECRYPT_PFUND_ER_PAY]
[DECRYPT_MPF_VLYEE]
[DECRYPT_MPF_VLYER]
[DECRYPT_CURRENT_MONTH_TOTAL_PAY]
[DECRYPT_PREPAID_TOTAL_PAY]
[DECRYPT_TOTAL_NET_PAY]
[DECRYPT_TOTAL_PAY]
[DECRYPT_TOTAL_PAY_AUTOPAY]
[DECRYPT_TOTAL_PAY_CHEQUE]
[PAY_TYPE1_DESC]
[PAY_TYPE2_DESC]
[PAY_TYPE3_DESC]
[PAY_TYPE4_DESC]
[PAY_TYPE5_DESC]
[PAY_TYPE6_DESC]
[PAY_TYPE7_DESC]
[PAY_TYPE8_DESC]
[PAY_TYPE9_DESC]
[PAY_TYPE10_DESC]
[PAY_TYPE11_DESC]
[PAY_TYPE12_DESC]
[PAY_TYPE13_DESC]
[PAY_TYPE14_DESC]
[PAY_TYPE15_DESC]
[DECRYPT_AVERAGE_DAILY_WAGE]
[DECRYPT_AVERAGE_MONTHLY_WAGE]
[DECRYPT_REGARDED_WAGE]
[REGARDED_DAYS]
[DECRYPT_PAY_RATE]
[DECRYPT_PAY_RATE_LM]
[DECRYPT_PAY_RATE2]
[DECRYPT_PAY_RATE3]
[DECRYPT_PAY_RATE4]
[DECRYPT_PAY_RATE5]
[DECRYPT_PAY_RATE6]
[WORK_TIME]
[WORK_TIME_LM]
[WORK_TIME2]
[WORK_TIME3]
[WORK_TIME4]
[WORK_TIME5]
[WORK_TIME6]
[DECRYPT_WORK_PAY]
[DECRYPT_WORK_PAY_LM]
[DECRYPT_WORK_PAY_C]
[DECRYPT_WORK_PAY2]
[DECRYPT_WORK_PAY3]
[DECRYPT_WORK_PAY4]
[DECRYPT_WORK_PAY5]
[DECRYPT_WORK_PAY6]
[COMPANY_NAME]
[ALTERNATE_NAME]
[REMARK]
[IS_REMARKS]
[REMARKS2]
[IS_REMARKS2]
[AnnualLeaveBalanceAsOf]
[MONTH_NAME]
[NORMAL_WORKING_DAYS]
[ADDITIONAL_ANN_LEAVE]
[PAY_FREQUENCY]
[YTD_EARNINGS]
[YTD_EEMC]
[YTD_ERMC]
[YTD_FULLPAY_SICKLEAVE_TAKEN]
[AL_ENTITLEMENT_TO]
[AL_ENTITLEMENT_TO_LONG]
[REASON_CODE]
[TERMN_REASON]
[CONTRACT_END_DATE]
[CONTRACT_END_DATE_LONG]
[PROBATION_END_DATE]
[PROBATION_END_DATE_LONG]

System Word Template Location: [HRPro Shared Folder]\Template\ScrPLFPA\
User Word Template Location: [HRPro Shared Folder]\dbXXXX\Template\ScrPLFPA\


See also: