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 Group Display Name: HRM Solution Series
Physical Name: APR_APR30300
Technical Name: APR_Pay_Run_HIST
Group Technical Name: APR
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | USERID  | User ID | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['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 | ||||||
| 2 | ACTINDX | Account Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['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 | ||||||
| 3 | AUCTRLCD | Audit Control Code | String | STR13_LBAU | 13 | |
| 4 | BLDCHDID | Build Check Default ID | String | STR15_Build_Check_Default_ID | 15 | |
| 5 | BLDCHKDT | Build Check Date | Date | DT | 8 | |
| 6 | BLDCHTIM | Build Check Time | Time | TM6 | 6 | |
| 7 | PYRNTYPE | Pay Run Type | Integer | GB | 0 | |
| 8 | COMPPYRN | Computer Pay Run Type | Integer | GB | 0 | |
| 9 | EMPCLRNG | Employee Class Range | Integer | GB | 0 | |
| 10 | STTEMPCL | Start Employee Class | String | STR15_Employee_Class | 15 | |
| 11 | ENEMPCLS | End Employee Class | String | STR15_Employee_Class | 15 | |
| 12 | EMPIDRNG | Employee ID Range | Integer | GB | 0 | |
| 13 | STTEMPID | Start Employee ID | String | STR15_Employee_ID | 15 | |
| 14 | ENDEMPL | End Employee ID | String | STR15_Employee_ID | 15 | |
| 15 | PYRNSTDT | Pay Run Start Date | Date | DT | 8 | |
| 16 | PYRNENDT | Pay Run End Date | Date | DT | 8 | |
| 17 | PYRNIWLY | Pay Run Includes Weekly | Boolean | CB_Pay_Run_Weekly | 0 | |
| 18 | PYRNIBWK | Pay Run Includes Biweekly | Boolean | CB_Pay_Run_Biweekly | 0 | |
| 19 | PRNISMLY | Pay Run Includes Semimonthly | Boolean | CB_Pay_Run_Semimonthly | 0 | |
| 20 | PYRNIMLY | Pay Run Includes Monthly | Boolean | CB_Pay_Run_Monthly | 0 | |
| 21 | PYRNIQLY | Pay Run Includes Quarterly | Boolean | CB_Pay_Run_Quarterly | 0 | |
| 22 | PYRNISAN | Pay Run Includes Semiannually | Boolean | CB_Pay_Run_Semiannually | 0 | |
| 23 | PYRNIANN | Pay Run Includes Annually | Boolean | CB_Pay_Run_Annually | 0 | |
| 24 | PYRNIDMS | Pay Run Includes Daily/Misc | Boolean | CB_Pay_Run_Daily/Misc | 0 | |
| 25 | PYRNISRY | Pay Run Includes Salary | Boolean | CB_Pay_Run_Salary | 0 | |
| 26 | PYRNIPSN | Pay Run Includes Pension | Boolean | CB_Pay_Run_Pension | 0 | |
| 27 | PYRNIEIC | Pay Run Includes EIC | Boolean | CB_Pay_Run_EIC | 0 | |
| 28 | PYRNIPTP | Pay Run Include Pay Types | Integer | GB | 0 | |
| 29 | PYRNIDED | Pay Run Include Deductions | Integer | GB | 0 | |
| 30 | PYRNIBFT | Pay Run Include Benefits | Integer | GB | 0 | |
| 31 | DAYSWRDK | Days Worked | Long Integer | LI6_S2 | 6 | |
| 32 | WKSWRKD | Weeks Worked | Long Integer | LI6_S2 | 6 | |
| 33 | BLCHWREX | Build Check Warnings Exist | Boolean | YN | 0 | |
| 34 | BDCHEREX | Build Check Errors Exist | Boolean | YN | 0 | |
| 35 | PRCHKPTD | Precheck Printed | Boolean | YN | 0 | |
| 36 | PYRLCHPS | Payroll Check Printing Started | Boolean | CB | 0 | |
| 37 | CHEKDATE | Check Date | Date | DATE | 6 | |
| 38 | POSTEDDT | Posted Date | Date | DATE | 6 | |
| 39 | NUMOFTRX | Number Of TRX | Long Integer | LI6_U0 | 6 | |
| 40 | NUMOFEMP | Number of Employees | Integer | INT5_U0 | 5 | |
| 41 | CNTRLTRX | Control TRX Count | Long Integer | LI6_U0 | 6 | |
| 42 | CTRLEMPCT | Control Employee Count | Integer | INT5_S0 | 5 | |
| 43 | APPROVL | Approval | Boolean | CB_Approval | 0 | |
| 44 | APPRVLDT | Approval Date | Date | DATE | 6 | |
| 45 | APRVLUSERID | Approval User ID | String | STR15_User_ID | 15 | |