Payroll Check History (UPR30100)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Check History
Physical Name: UPR30100
Technical Name: UPR_Check_HIST

Group Display Name: Payroll Check History
Group Technical Name: Payroll Check History

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1AUCTRLCD SearchAudit Control CodeSTR13_LBAUString1413
2CHEKNMBR SearchCheck NumberSTR20_Document_NumberString2220
3PYADNMBR SearchPayment/Adjustment NumberLI8_U0Long Integer48
4VOIDED SearchVoidedCBBoolean20
5CHEKDATE SearchCheck DateDATEDate46
6POSTEDDT SearchPosted DateDATEDate46
7EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
8EMPLNAME SearchEmployee NameSTR40String4240
9GRWGPRN SearchGross Wages/Pay RunDLR11_$S2Currency1014
10FDWDGPRN SearchFederal Withholding/Pay RunDLR11_$S2Currency1014
11FDTXTIPS SearchFederal Tax on TipsDLR11_$S2Currency1014
12FICAMWPR SearchFICA/Medicare Withholding/Pay RunDLR11_$S2Currency1014
13FICMTPTX SearchFICA/Med Tax on TipsDLR11_$S2Currency1014
14Uncollected_FICAMed_TaxP SearchUncollected FICA/Med Tax/Pay RunDLR11_$S2Currency1014
15FCASWPR SearchFICA/Social Security Withholding/Pay RunDLR11_$S2Currency1014
16FICSTPTX SearchFICA/SS Tax on TipsDLR11_$S2Currency1014
17Uncollected_FICASS_TaxP SearchUncollected FICA/SS Tax/Pay RunDLR11_$S2Currency1014
18ADEICPMT SearchAdvance EIC PaymentDLR11_RU2NC_Year_EndCurrency1014
19Reported_Tips SearchReported TipsDLR11_$S2Currency1014
20Charged_Tips SearchCharged TipsDLR11_$S2Currency1014
21ALOCTIPS SearchAllocated TipsDLR11_RU2NC_Year_EndCurrency1014
22TTLDDTNS SearchTotal DeductionsDLR11_$S2Currency1014
23TTLBNFTS SearchTotal BenefitsDLR11_$S2Currency1014
24NTWPYRN SearchNet Wages/Pay RunDLR11_$S2Currency1014
25CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['Payroll Check History'].CHEKBKID AS 'Payroll Check History-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       UPR30100 AS ['Payroll Check History']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Payroll Check History'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
26DEPRTMNT SearchDepartmentSTR6_Payroll_CodeString86
27SOCSCNUM SearchSocial Security NumberSTR15_Social_Security_NumberString1615
28VACTMACC SearchVacation Time AccruedDLR6_S2Currency106
29VACTMLBL SearchVacation Time LiabilityDLR11_$S2Currency1014
30VACAVLBL SearchVacation AvailableLI6_S2Long Integer46
31SKTMACCR SearchSick Time AccruedDLR6_S2Currency106
32SKTMLBTY SearchSick Time LiabilityDLR11_$S2Currency1014
33SIKTIMAV SearchSick Time AvailableLI6_S2Long Integer46
34TOTLTAXS SearchTotal TaxesDLR11_$S2Currency1014
35Voided_by_Void_Checks SearchVoided by Void ChecksCBBoolean20
36FDWGPYRN SearchFederal Wages/Pay RunDLR11_$S2Currency1014
37Federal_TipsPay_Run SearchFederal Tips/Pay RunDLR11_$S2Currency1014
38FICASSWP SearchFICA/Social Security Wages/Pay RunDLR11_$S2Currency1014
39FICASS_TipsPay_Run SearchFICA/SS Tips/Pay RunDLR11_$S2Currency1014
40FICAMWGP SearchFICA/Medicare Wages/Pay RunDLR11_$S2Currency1014
41FICAMed_TipsPay_Run SearchFICA/Med Tips/Pay RunDLR11_$S2Currency1014
42Reported_Receipts SearchReported ReceiptsDLR11_$S2Currency1014
43Charged_Receipts SearchCharged ReceiptsDLR11_$S2Currency1014
44YEAR1 SearchYearYearInteger24
45ISCHECK SearchIsCheckCBBoolean20
46RSNCHKVD SearchReason Check VoidedSTR30String3230
47COMPPYRN SearchComputer Pay Run TypeGBInteger20
48EFICASSWH SearchEmployer FICA/Social Security WithholdingDLR11_$S2Currency1014
49EFICASS_Tax_On_Tips SearchEmployer FICA/SS Tax On TipsDLR11_$S2Currency1014
50EFICAMWPR SearchEmployer FICA/Medicare WithholdingDLR11_$S2Currency1014
51EFICAMed_Tax_On_Tips SearchEmployer FICA/Med Tax On TipsDLR11_$S2Currency1014
52PayPeriodBeginDate SearchPay Period Begin DateDTDate48
53PayPeriodEndDate SearchPay Period End DateDTDate48
54DEX_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 *