Payroll Deduction Master (UPR00500)

azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Deduction Master (UPR00500)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Deduction Master
Physical Name: UPR00500
Technical Name: UPR_MSTR_Deduction

Group Display Name: Payroll Employee Master
Group Technical Name: Payroll Employee Master

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
2DEDUCTON SearchDeductionSTR6_Payroll_CodeString86
3INACTIVE SearchInactiveCB_InactiveBoolean20
4DEDBEGDT SearchDeduction Beg DateDTDate48
5DEDENDDT SearchDeduction End DateDTDate48
6VARDEDTN SearchVariable DeductionCB_VariableBoolean20
7DEDNFREQ SearchDeduction FrequencyDDL_Ded/Ben FrequencyInteger20
8TXSHANTY SearchTax Sheltered AnnuityCB_Tax_Sheltered_AnnuityBoolean20
9SFRFEDTX SearchSheltered From Federal TaxCB_Federal_TaxBoolean20
10SHFRFICA SearchSheltered From FICACB_FICA_Social_SecurityBoolean20
11SHFRSTTX SearchSheltered From State TaxCB_State_TaxBoolean20
12SFRLCLTX SearchSheltered From Local TaxCB_Local_TaxBoolean20
13BSDORCDS SearchBased On RecordsGBInteger20
14DEDNMTHD SearchDeduction MethodDDL_Deduction_MethodInteger20
15DEDFRMLA SearchDeduction FormulaGBInteger20
16DEDNPRCT SearchDeduction PercentDLR8_U5%Currency108
17DEDNPRCT_1 SearchDeduction Percent[1]DLR8_U5%Currency108
18DEDNPRCT_2 SearchDeduction Percent[2]DLR8_U5%Currency108
19DEDNPRCT_3 SearchDeduction Percent[3]DLR8_U5%Currency108
20DEDNPRCT_4 SearchDeduction Percent[4]DLR8_U5%Currency108
21DEDNPRCT_5 SearchDeduction Percent[5]DLR8_U5%Currency108
22DEDCAMNT SearchDeduction AmountDLR11_$S2Currency1014
23DEDCAMNT_1 SearchDeduction Amount[1]DLR11_$S2Currency1014
24DEDCAMNT_2 SearchDeduction Amount[2]DLR11_$S2Currency1014
25DEDCAMNT_3 SearchDeduction Amount[3]DLR11_$S2Currency1014
26DEDCAMNT_4 SearchDeduction Amount[4]DLR11_$S2Currency1014
27DEDCAMNT_5 SearchDeduction Amount[5]DLR11_$S2Currency1014
28DEDTRMAX SearchDeduction Tier MaxDLR11_$U2Currency1014
29DEDTRMAX_1 SearchDeduction Tier Max[1]DLR11_$U2Currency1014
30DEDTRMAX_2 SearchDeduction Tier Max[2]DLR11_$U2Currency1014
31DEDTRMAX_3 SearchDeduction Tier Max[3]DLR11_$U2Currency1014
32DEDTRMAX_4 SearchDeduction Tier Max[4]DLR11_$U2Currency1014
33DEDTRMAX_5 SearchDeduction Tier Max[5]DLR11_$U2Currency1014
34DETRMXUN SearchDeduction Tier Max UnitsLI9_U2Long Integer49
35DETRMXUN_1 SearchDeduction Tier Max Units[1]LI9_U2Long Integer49
36DETRMXUN_2 SearchDeduction Tier Max Units[2]LI9_U2Long Integer49
37DETRMXUN_3 SearchDeduction Tier Max Units[3]LI9_U2Long Integer49
38DETRMXUN_4 SearchDeduction Tier Max Units[4]LI9_U2Long Integer49
39DETRMXUN_5 SearchDeduction Tier Max Units[5]LI9_U2Long Integer49
40DEPYPRMX SearchDeduction Pay Period MaxDLR11_$S2Currency1014
41DEDYRMAX SearchDeduction Year MaxDLR11_$S2Currency1014
42DEDLTMAX SearchDeduction Lifetime MaxDLR11_$S2Currency1014
43W2BXNMBR SearchW2 Box NumberINT2_U0Integer22
44W2BXLABL SearchW2 Box LabelSTR6String86
45LTDDEDTN SearchLTD DeductionDLR11_$S2Currency1014
46NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Payroll Deduction Master'].NOTEINDX AS 'Payroll Deduction Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       UPR00500 AS ['Payroll Deduction Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Payroll Deduction Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
47NOTEINDX2 SearchNote Index2DLR14Currency1014
48DATAENTDFLT SearchData Entry DefaultCB_DataEntryDefaultBoolean20
49EARNINGSCODE SearchEarnings CodeSTR15_Earnings_CodeString1615
50COURTDATE SearchCourt DateDATE_LDate40
51COURTNAME SearchCourt NameSTR30String3230
52DOCDESCR SearchDocument DescriptionSTR30String3230
53ORIGINALAMOUNT SearchOriginal AmountDLR11_$U2Currency1014
54AMNTTAKEN SearchAmount TakenDLR11_$U2Currency1014
55VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['Payroll Deduction Master'].VENDORID AS 'Payroll Deduction Master-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       UPR00500 AS ['Payroll Deduction Master']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['Payroll Deduction Master'].VENDORID = ['PM Vendor Master File'].VENDORID
56FEDMAXDED SearchFederal Maximum DeductionSTR15_Max_CodeString1615
57STATEMAXDED SearchState Maximum DeductionSTR15_Max_CodeString1615
58W2BXNMBR2 SearchW2 Box Number 2INT2_U0Integer22
59W2BXLABL2 SearchW2 Box Label 2STR6String86
60W2BXNMBR3 SearchW2 Box Number 3INT2_U0Integer22
61W2BXLABL3 SearchW2 Box Label 3STR6String86
62W2BXNMBR4 SearchW2 Box Number 4INT2_U0Integer22
63W2BXLABL4 SearchW2 Box Label 4STR6String86
64Deduction_Fiscal_Yr_Max SearchDeduction Fiscal Year MaxDLR11_$S2Currency1014
65SHFRFICAMED SearchSheltered From FICA MedicareCB_FICA_MedicareBoolean20
66DEX_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.

azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Deduction Master (UPR00500)

Leave a Reply

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