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 TypeLength
1AUCTRLCD SearchAudit Control CodeSTR13_LBAUString13
2CHEKNMBR SearchCheck NumberSTR20_Document_NumberString20
3PYADNMBR SearchPayment/Adjustment NumberLI8_U0Long Integer8
4VOIDED SearchVoidedCBBoolean0
5CHEKDATE SearchCheck DateDATEDate6
6POSTEDDT SearchPosted DateDATEDate6
7EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
8EMPLNAME SearchEmployee NameSTR40String40
9GRWGPRN SearchGross Wages/Pay RunDLR11_$S2Currency14
10FDWDGPRN SearchFederal Withholding/Pay RunDLR11_$S2Currency14
11FDTXTIPS SearchFederal Tax on TipsDLR11_$S2Currency14
12FICAMWPR SearchFICA/Medicare Withholding/Pay RunDLR11_$S2Currency14
13FICMTPTX SearchFICA/Med Tax on TipsDLR11_$S2Currency14
14Uncollected_FICAMed_TaxP SearchUncollected FICA/Med Tax/Pay RunDLR11_$S2Currency14
15FCASWPR SearchFICA/Social Security Withholding/Pay RunDLR11_$S2Currency14
16FICSTPTX SearchFICA/SS Tax on TipsDLR11_$S2Currency14
17Uncollected_FICASS_TaxP SearchUncollected FICA/SS Tax/Pay RunDLR11_$S2Currency14
18ADEICPMT SearchAdvance EIC PaymentDLR11_RU2NC_Year_EndCurrency14
19Reported_Tips SearchReported TipsDLR11_$S2Currency14
20Charged_Tips SearchCharged TipsDLR11_$S2Currency14
21ALOCTIPS SearchAllocated TipsDLR11_RU2NC_Year_EndCurrency14
22TTLDDTNS SearchTotal DeductionsDLR11_$S2Currency14
23TTLBNFTS SearchTotal BenefitsDLR11_$S2Currency14
24NTWPYRN SearchNet Wages/Pay RunDLR11_$S2Currency14
25CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString15
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_CodeString6
27SOCSCNUM SearchSocial Security NumberSTR15_Social_Security_NumberString15
28VACTMACC SearchVacation Time AccruedDLR6_S2Currency6
29VACTMLBL SearchVacation Time LiabilityDLR11_$S2Currency14
30VACAVLBL SearchVacation AvailableLI6_S2Long Integer6
31SKTMACCR SearchSick Time AccruedDLR6_S2Currency6
32SKTMLBTY SearchSick Time LiabilityDLR11_$S2Currency14
33SIKTIMAV SearchSick Time AvailableLI6_S2Long Integer6
34TOTLTAXS SearchTotal TaxesDLR11_$S2Currency14
35Voided_by_Void_Checks SearchVoided by Void ChecksCBBoolean0
36FDWGPYRN SearchFederal Wages/Pay RunDLR11_$S2Currency14
37Federal_TipsPay_Run SearchFederal Tips/Pay RunDLR11_$S2Currency14
38FICASSWP SearchFICA/Social Security Wages/Pay RunDLR11_$S2Currency14
39FICASS_TipsPay_Run SearchFICA/SS Tips/Pay RunDLR11_$S2Currency14
40FICAMWGP SearchFICA/Medicare Wages/Pay RunDLR11_$S2Currency14
41FICAMed_TipsPay_Run SearchFICA/Med Tips/Pay RunDLR11_$S2Currency14
42Reported_Receipts SearchReported ReceiptsDLR11_$S2Currency14
43Charged_Receipts SearchCharged ReceiptsDLR11_$S2Currency14
44YEAR1 SearchYearYearInteger4
45ISCHECK SearchIsCheckCBBoolean0
46RSNCHKVD SearchReason Check VoidedSTR30String30
47COMPPYRN SearchComputer Pay Run TypeGBInteger0
48EFICASSWH SearchEmployer FICA/Social Security WithholdingDLR11_$S2Currency14
49EFICASS_Tax_On_Tips SearchEmployer FICA/SS Tax On TipsDLR11_$S2Currency14
50EFICAMWPR SearchEmployer FICA/Medicare WithholdingDLR11_$S2Currency14
51EFICAMed_Tax_On_Tips SearchEmployer FICA/Med Tax On TipsDLR11_$S2Currency14
52PayPeriodBeginDate SearchPay Period Begin DateDTDate8
53PayPeriodEndDate SearchPay Period End DateDTDate8
54DEX_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.

Leave a Reply

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