APR Pay Run History (APR_APR30300)

azurecurveProductsHRM Solution Series (1911)PayrollAPR Pay Run History (APR_APR30300)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/APR_APR30300

Product: HRM Solution Series (1911)
Series:

Display Name: APR Pay Run History
Physical Name: APR_APR30300
Technical Name: APR_Pay_Run_HIST

Group Display Name: HRM Solution Series
Group Technical Name: APR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['APR Pay Run History'].USERID AS 'APR Pay Run History-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       APR_APR30300 AS ['APR Pay Run History']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['APR Pay Run History'].USERID = ['Users Master'].USERID
2ACTINDX SearchAccount IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['APR Pay Run History'].ACTINDX AS 'APR Pay Run History-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       APR_APR30300 AS ['APR Pay Run History']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['APR Pay Run History'].ACTINDX = ['Account Index Master'].ACTINDX
3AUCTRLCD SearchAudit Control CodeStringSTR13_LBAU13
4BLDCHDID SearchBuild Check Default IDStringSTR15_Build_Check_Default_ID15
5BLDCHKDT SearchBuild Check DateDateDT8
6BLDCHTIM SearchBuild Check TimeTimeTM66
7PYRNTYPE SearchPay Run TypeIntegerGB0
8COMPPYRN SearchComputer Pay Run TypeIntegerGB0
9EMPCLRNG SearchEmployee Class RangeIntegerGB0
10STTEMPCL SearchStart Employee ClassStringSTR15_Employee_Class15
11ENEMPCLS SearchEnd Employee ClassStringSTR15_Employee_Class15
12EMPIDRNG SearchEmployee ID RangeIntegerGB0
13STTEMPID SearchStart Employee IDStringSTR15_Employee_ID15
14ENDEMPL SearchEnd Employee IDStringSTR15_Employee_ID15
15PYRNSTDT SearchPay Run Start DateDateDT8
16PYRNENDT SearchPay Run End DateDateDT8
17PYRNIWLY SearchPay Run Includes WeeklyBooleanCB_Pay_Run_Weekly0
18PYRNIBWK SearchPay Run Includes BiweeklyBooleanCB_Pay_Run_Biweekly0
19PRNISMLY SearchPay Run Includes SemimonthlyBooleanCB_Pay_Run_Semimonthly0
20PYRNIMLY SearchPay Run Includes MonthlyBooleanCB_Pay_Run_Monthly0
21PYRNIQLY SearchPay Run Includes QuarterlyBooleanCB_Pay_Run_Quarterly0
22PYRNISAN SearchPay Run Includes SemiannuallyBooleanCB_Pay_Run_Semiannually0
23PYRNIANN SearchPay Run Includes AnnuallyBooleanCB_Pay_Run_Annually0
24PYRNIDMS SearchPay Run Includes Daily/MiscBooleanCB_Pay_Run_Daily/Misc0
25PYRNISRY SearchPay Run Includes SalaryBooleanCB_Pay_Run_Salary0
26PYRNIPSN SearchPay Run Includes PensionBooleanCB_Pay_Run_Pension0
27PYRNIEIC SearchPay Run Includes EICBooleanCB_Pay_Run_EIC0
28PYRNIPTP SearchPay Run Include Pay TypesIntegerGB0
29PYRNIDED SearchPay Run Include DeductionsIntegerGB0
30PYRNIBFT SearchPay Run Include BenefitsIntegerGB0
31DAYSWRDK SearchDays WorkedLong IntegerLI6_S26
32WKSWRKD SearchWeeks WorkedLong IntegerLI6_S26
33BLCHWREX SearchBuild Check Warnings ExistBooleanYN0
34BDCHEREX SearchBuild Check Errors ExistBooleanYN0
35PRCHKPTD SearchPrecheck PrintedBooleanYN0
36PYRLCHPS SearchPayroll Check Printing StartedBooleanCB0
37CHEKDATE SearchCheck DateDateDATE6
38POSTEDDT SearchPosted DateDateDATE6
39NUMOFTRX SearchNumber Of TRXLong IntegerLI6_U06
40NUMOFEMP SearchNumber of EmployeesIntegerINT5_U05
41CNTRLTRX SearchControl TRX CountLong IntegerLI6_U06
42CTRLEMPCT SearchControl Employee CountIntegerINT5_S05
43APPROVL SearchApprovalBooleanCB_Approval0
44APPRVLDT SearchApproval DateDateDATE6
45APRVLUSERID SearchApproval User IDStringSTR15_User_ID15
azurecurveProductsHRM Solution Series (1911)PayrollAPR Pay Run History (APR_APR30300)

Leave a Reply

Your email address will not be published. Required fields are marked *