Payroll Work Header (UPR10202)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Work Header
Physical Name: UPR10202
Technical Name: UPR_WORK_HDR

Group Display Name: Payroll Check Work
Group Technical Name: Payroll Check Work

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Payroll Work Header'].USERID AS 'Payroll Work Header-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       UPR10202 AS ['Payroll Work Header']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Payroll Work Header'].USERID = ['Users Master'].USERID
2PYRNTYPE SearchPay Run TypeGBInteger20
3EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
4POSTED SearchPostedTrue/FalseBoolean20
5PYSTLTEX SearchPay Subject To Local Tax ExistsCBBoolean20
6CHEKNMBR SearchCheck NumberSTR20_Document_NumberString2220
7CHEKDATE SearchCheck DateDATEDate46
8CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['Payroll Work Header'].CHEKBKID AS 'Payroll Work Header-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       UPR10202 AS ['Payroll Work Header']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Payroll Work Header'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
9PYADNMBR SearchPayment/Adjustment NumberLI8_U0Long Integer48
10ACTINDX SearchAccount IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Payroll Work Header'].ACTINDX AS 'Payroll Work Header-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       UPR10202 AS ['Payroll Work Header']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Payroll Work Header'].ACTINDX = ['Account Index Master'].ACTINDX
11ADFDWHDG SearchAdditional Federal WithholdingDLR11_$S2Currency1014
12ESTFEDWH SearchEstimated Federal WithholdingDLR11_$U2Currency1014
13HWKVCACR SearchHours Worked For Vacation AccrualDLR6_S2Currency106
14HWKSKACR SearchHours Worked For Sick AccrualDLR6_S2Currency106
15VACTMACC SearchVacation Time AccruedDLR6_S2Currency106
16SKTMACCR SearchSick Time AccruedDLR6_S2Currency106
17VACTMLBL SearchVacation Time LiabilityDLR11_$S2Currency1014
18SKTMLBTY SearchSick Time LiabilityDLR11_$S2Currency1014
19VACAVLBL SearchVacation AvailableLI6_S2Long Integer46
20SIKTIMAV SearchSick Time AvailableLI6_S2Long Integer46
21GRWGPRN SearchGross Wages/Pay RunDLR11_$S2Currency1014
22NTWPYRN SearchNet Wages/Pay RunDLR11_$S2Currency1014
23FEDWGARR SearchFederal Wage ArrayDLR11Currency1014
24FEDWGARR_1 SearchFederal Wage Array[1]DLR11Currency1014
25FEDWGARR_2 SearchFederal Wage Array[2]DLR11Currency1014
26FEDWGARR_3 SearchFederal Wage Array[3]DLR11Currency1014
27FEDWGARR_4 SearchFederal Wage Array[4]DLR11Currency1014
28FEDWGARR_5 SearchFederal Wage Array[5]DLR11Currency1014
29FEDWGARR_6 SearchFederal Wage Array[6]DLR11Currency1014
30FEDWGARR_7 SearchFederal Wage Array[7]DLR11Currency1014
31FEDWGARR_8 SearchFederal Wage Array[8]DLR11Currency1014
32Federal_Tips_Array SearchFederal Tips ArrayDLR11_$S2Currency1014
33Federal_Tips_Array_1 SearchFederal Tips Array[1]DLR11_$S2Currency1014
34Federal_Tips_Array_2 SearchFederal Tips Array[2]DLR11_$S2Currency1014
35Federal_Tips_Array_3 SearchFederal Tips Array[3]DLR11_$S2Currency1014
36Federal_Tips_Array_4 SearchFederal Tips Array[4]DLR11_$S2Currency1014
37Federal_Tips_Array_5 SearchFederal Tips Array[5]DLR11_$S2Currency1014
38Federal_Tips_Array_6 SearchFederal Tips Array[6]DLR11_$S2Currency1014
39Federal_Tips_Array_7 SearchFederal Tips Array[7]DLR11_$S2Currency1014
40Federal_Tips_Array_8 SearchFederal Tips Array[8]DLR11_$S2Currency1014
41FDWGPYRN SearchFederal Wages/Pay RunDLR11_$S2Currency1014
42Federal_TipsPay_Run SearchFederal Tips/Pay RunDLR11_$S2Currency1014
43ANFDWHDG SearchAnnualized Federal WithholdingDLR11_$S2Currency1014
44FDWDGPRN SearchFederal Withholding/Pay RunDLR11_$S2Currency1014
45FDTXTIPS SearchFederal Tax on TipsDLR11_$S2Currency1014
46FICASSWP SearchFICA/Social Security Wages/Pay RunDLR11_$S2Currency1014
47FICASS_TipsPay_Run SearchFICA/SS Tips/Pay RunDLR11_$S2Currency1014
48FCASWPR SearchFICA/Social Security Withholding/Pay RunDLR11_$S2Currency1014
49FICSTPTX SearchFICA/SS Tax on TipsDLR11_$S2Currency1014
50Uncollected_FICASS_TaxP SearchUncollected FICA/SS Tax/Pay RunDLR11_$S2Currency1014
51FICAMWGP SearchFICA/Medicare Wages/Pay RunDLR11_$S2Currency1014
52FICAMed_TipsPay_Run SearchFICA/Med Tips/Pay RunDLR11_$S2Currency1014
53FICAMWPR SearchFICA/Medicare Withholding/Pay RunDLR11_$S2Currency1014
54FICMTPTX SearchFICA/Med Tax on TipsDLR11_$S2Currency1014
55Uncollected_FICAMed_TaxP SearchUncollected FICA/Med Tax/Pay RunDLR11_$S2Currency1014
56EICWPYRN SearchEIC Wages/Pay RunDLR11_$S2Currency1014
57EPFICASS SearchEmployer FICA/Social SecurityDLR11_$S2Currency1014
58EFICAMCR SearchEmployer FICA/MedicareDLR11_$S2Currency1014
59Charged_Receipts SearchCharged ReceiptsDLR11_$S2Currency1014
60Reported_Receipts SearchReported ReceiptsDLR11_$S2Currency1014
61Hours_Worked_For_Minimum SearchHours Worked For Minimum WageDLR11_$S2Currency1014
62Min_Wage_Bal_Applicable SearchMin Wage Bal Applicable PayDLR11_$S2Currency1014
63Reported_Tips SearchReported TipsDLR11_$S2Currency1014
64Charged_Tips SearchCharged TipsDLR11_$S2Currency1014
65ALOCTIPS SearchAllocated TipsDLR11_RU2NC_Year_EndCurrency1014
66TipType SearchTip TypeDDL_Type_of_TipsInteger20
67POSTEDDT SearchPosted DateDATEDate46
68GRWGFREIC SearchGross Wages For EICDLR11_$S2Currency1014
69CALCCHKERRS SearchCalc Check ErrorsML_Calc_Check_ErrorsLong Integer40
70EFICASSWH SearchEmployer FICA/Social Security WithholdingDLR11_$S2Currency1014
71EFICASS_Tax_On_Tips SearchEmployer FICA/SS Tax On TipsDLR11_$S2Currency1014
72EFICAMWPR SearchEmployer FICA/Medicare WithholdingDLR11_$S2Currency1014
73EFICAMed_Tax_On_Tips SearchEmployer FICA/Med Tax On TipsDLR11_$S2Currency1014
74PayPeriodBeginDate SearchPay Period Begin DateDTDate48
75PayPeriodEndDate SearchPay Period End DateDTDate48
76DEX_ROW_ID Searchintint1010

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.

Leave a Reply

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