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

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 IDSTR15_User_IDString15
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 IndexLI_14Long Integer14
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 CodeSTR13_LBAUString13
4BLDCHDID SearchBuild Check Default IDSTR15_Build_Check_Default_IDString15
5BLDCHKDT SearchBuild Check DateDTDate8
6BLDCHTIM SearchBuild Check TimeTM6Time6
7PYRNTYPE SearchPay Run TypeGBInteger0
8COMPPYRN SearchComputer Pay Run TypeGBInteger0
9EMPCLRNG SearchEmployee Class RangeGBInteger0
10STTEMPCL SearchStart Employee ClassSTR15_Employee_ClassString15
11ENEMPCLS SearchEnd Employee ClassSTR15_Employee_ClassString15
12EMPIDRNG SearchEmployee ID RangeGBInteger0
13STTEMPID SearchStart Employee IDSTR15_Employee_IDString15
14ENDEMPL SearchEnd Employee IDSTR15_Employee_IDString15
15PYRNSTDT SearchPay Run Start DateDTDate8
16PYRNENDT SearchPay Run End DateDTDate8
17PYRNIWLY SearchPay Run Includes WeeklyCB_Pay_Run_WeeklyBoolean0
18PYRNIBWK SearchPay Run Includes BiweeklyCB_Pay_Run_BiweeklyBoolean0
19PRNISMLY SearchPay Run Includes SemimonthlyCB_Pay_Run_SemimonthlyBoolean0
20PYRNIMLY SearchPay Run Includes MonthlyCB_Pay_Run_MonthlyBoolean0
21PYRNIQLY SearchPay Run Includes QuarterlyCB_Pay_Run_QuarterlyBoolean0
22PYRNISAN SearchPay Run Includes SemiannuallyCB_Pay_Run_SemiannuallyBoolean0
23PYRNIANN SearchPay Run Includes AnnuallyCB_Pay_Run_AnnuallyBoolean0
24PYRNIDMS SearchPay Run Includes Daily/MiscCB_Pay_Run_Daily/MiscBoolean0
25PYRNISRY SearchPay Run Includes SalaryCB_Pay_Run_SalaryBoolean0
26PYRNIPSN SearchPay Run Includes PensionCB_Pay_Run_PensionBoolean0
27PYRNIEIC SearchPay Run Includes EICCB_Pay_Run_EICBoolean0
28PYRNIPTP SearchPay Run Include Pay TypesGBInteger0
29PYRNIDED SearchPay Run Include DeductionsGBInteger0
30PYRNIBFT SearchPay Run Include BenefitsGBInteger0
31DAYSWRDK SearchDays WorkedLI6_S2Long Integer6
32WKSWRKD SearchWeeks WorkedLI6_S2Long Integer6
33BLCHWREX SearchBuild Check Warnings ExistYNBoolean0
34BDCHEREX SearchBuild Check Errors ExistYNBoolean0
35PRCHKPTD SearchPrecheck PrintedYNBoolean0
36PYRLCHPS SearchPayroll Check Printing StartedCBBoolean0
37CHEKDATE SearchCheck DateDATEDate6
38POSTEDDT SearchPosted DateDATEDate6
39NUMOFTRX SearchNumber Of TRXLI6_U0Long Integer6
40NUMOFEMP SearchNumber of EmployeesINT5_U0Integer5
41CNTRLTRX SearchControl TRX CountLI6_U0Long Integer6
42CTRLEMPCT SearchControl Employee CountINT5_S0Integer5
43APPROVL SearchApprovalCB_ApprovalBoolean0
44APPRVLDT SearchApproval DateDATEDate6
45APRVLUSERID SearchApproval User IDSTR15_User_IDString15
46DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

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

Leave a Reply

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