Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/UPR10200
Product: Microsoft Dynamics GP (0)
Series: Payroll
Display Name: Payroll Work Master Group Display Name: Payroll Check Work
Physical Name: UPR10200
Technical Name: UPR_WORK_MSTR
Group Technical Name: Payroll Check Work
| 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
['Payroll Work Master'].USERID AS 'Payroll Work Master-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
UPR10200 AS ['Payroll Work Master']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Payroll Work Master'].USERID = ['Users Master'].USERID | ||||||
| 2 | AUCTRLCD | Audit Control Code | String | STR13_LBAU | 13 | |
| 3 | BLDCHDID | Build Check Default ID | String | STR15_Build_Check_Default_ID | 15 | |
| 4 | BLDCHKDT | Build Check Date | Date | DT | 8 | |
| 5 | BLDCHTIM | Build Check Time | Time | TM6 | 6 | |
| 6 | PYRNTYPE | Pay Run Type | Integer | GB | 0 | |
| 7 | COMPPYRN | Computer Pay Run Type | Integer | GB | 0 | |
| 8 | EMPCLRNG | Employee Class Range | Integer | GB | 0 | |
| 9 | STTEMPCL | Start Employee Class | String | STR15_Employee_Class | 15 | |
| 10 | ENEMPCLS | End Employee Class | String | STR15_Employee_Class | 15 | |
| 11 | EMPIDRNG | Employee ID Range | Integer | GB | 0 | |
| 12 | STTEMPID | Start Employee ID | String | STR15_Employee_ID | 15 | |
| 13 | ENDEMPL | End Employee ID | String | STR15_Employee_ID | 15 | |
| 14 | PYRNSTDT | Pay Run Start Date | Date | DT | 8 | |
| 15 | PYRNENDT | Pay Run End Date | Date | DT | 8 | |
| 16 | PYRNIWLY | Pay Run Includes Weekly | Boolean | CB_Pay_Run_Weekly | 0 | |
| 17 | PYRNIBWK | Pay Run Includes Biweekly | Boolean | CB_Pay_Run_Biweekly | 0 | |
| 18 | PRNISMLY | Pay Run Includes Semimonthly | Boolean | CB_Pay_Run_Semimonthly | 0 | |
| 19 | PYRNIMLY | Pay Run Includes Monthly | Boolean | CB_Pay_Run_Monthly | 0 | |
| 20 | PYRNIQLY | Pay Run Includes Quarterly | Boolean | CB_Pay_Run_Quarterly | 0 | |
| 21 | PYRNISAN | Pay Run Includes Semiannually | Boolean | CB_Pay_Run_Semiannually | 0 | |
| 22 | PYRNIANN | Pay Run Includes Annually | Boolean | CB_Pay_Run_Annually | 0 | |
| 23 | PYRNIDMS | Pay Run Includes Daily/Misc | Boolean | CB_Pay_Run_Daily/Misc | 0 | |
| 24 | PYRNISRY | Pay Run Includes Salary | Boolean | CB_Pay_Run_Salary | 0 | |
| 25 | PYRNIPSN | Pay Run Includes Pension | Boolean | CB_Pay_Run_Pension | 0 | |
| 26 | PYRNIEIC | Pay Run Includes EIC | Boolean | CB_Pay_Run_EIC | 0 | |
| 27 | PYRNIPTP | Pay Run Include Pay Types | Integer | GB | 0 | |
| 28 | PYRNIDED | Pay Run Include Deductions | Integer | GB | 0 | |
| 29 | PYRNIBFT | Pay Run Include Benefits | Integer | GB | 0 | |
| 30 | DAYSWRDK | Days Worked | Long Integer | LI6_S2 | 6 | |
| 31 | WKSWRKD | Weeks Worked | Long Integer | LI6_S2 | 6 | |
| 32 | BLCHWREX | Build Check Warnings Exist | Boolean | YN | 0 | |
| 33 | BDCHEREX | Build Check Errors Exist | Boolean | YN | 0 | |
| 34 | PRCHKPTD | Precheck Printed | Boolean | YN | 0 | |
| 35 | PYRLCHPS | Payroll Check Printing Started | Boolean | CB | 0 | |
| 36 | CHEKDATE | Check Date | Date | DATE | 6 | |
| 37 | POSTEDDT | Posted Date | Date | DATE | 6 | |
| 38 | NUMOFTRX | Number Of TRX | Long Integer | LI6_U0 | 6 | |
| 39 | NUMOFEMP | Number of Employees | Integer | INT5_U0 | 5 | |
| 40 | CNTRLTRX | Control TRX Count | Long Integer | LI6_U0 | 6 | |
| 41 | CTRLEMPCT | Control Employee Count | Integer | INT5_S0 | 5 | |
| 42 | APPROVL | Approval | Boolean | CB_Approval | 0 | |
| 43 | APPRVLDT | Approval Date | Date | DATE | 6 | |
| 44 | APRVLUSERID | Approval User ID | String | STR15_User_ID | 15 | |
The key to the Users Master (SY01400).
Click to show/hideSELECT
['Payroll Work Master'].APRVLUSERID AS 'Payroll Work Master-Approval User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
UPR10200 AS ['Payroll Work Master']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Payroll Work Master'].APRVLUSERID = ['Users Master'].USERID | ||||||
| 45 | PayRunIncAddlFedTax | Pay Run Include Addl Fed Tax | Boolean | CB_Federal | 0 | |
| 46 | PayRunIncAddStateTax | Pay Run Include Addl State Tax | Boolean | CB_State | 0 | |
| 47 | PayRunIncAddLocalTax | Pay Run Include Addl Local Tax | Boolean | CB_Local | 0 | |