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 TypeLength
1EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
2DEDUCTON SearchDeductionStringSTR6_Payroll_Code6
3INACTIVE SearchInactiveBooleanCB_Inactive0
4DEDBEGDT SearchDeduction Beg DateDateDT8
5DEDENDDT SearchDeduction End DateDateDT8
6VARDEDTN SearchVariable DeductionBooleanCB_Variable0
7DEDNFREQ SearchDeduction FrequencyIntegerDDL_Ded/Ben Frequency0
8TXSHANTY SearchTax Sheltered AnnuityBooleanCB_Tax_Sheltered_Annuity0
9SFRFEDTX SearchSheltered From Federal TaxBooleanCB_Federal_Tax0
10SHFRFICA SearchSheltered From FICABooleanCB_FICA_Social_Security0
11SHFRSTTX SearchSheltered From State TaxBooleanCB_State_Tax0
12SFRLCLTX SearchSheltered From Local TaxBooleanCB_Local_Tax0
13BSDORCDS SearchBased On RecordsIntegerGB0
14DEDNMTHD SearchDeduction MethodIntegerDDL_Deduction_Method0
15DEDFRMLA SearchDeduction FormulaIntegerGB0
16DEDNPRCT_1 SearchDeduction Percent[1]CurrencyDLR8_U5%8
17DEDNPRCT SearchDeduction PercentDLR8_U5%Currency8
18DEDNPRCT_2 SearchDeduction Percent[2]CurrencyDLR8_U5%8
19DEDNPRCT_3 SearchDeduction Percent[3]CurrencyDLR8_U5%8
20DEDNPRCT_4 SearchDeduction Percent[4]CurrencyDLR8_U5%8
21DEDNPRCT_5 SearchDeduction Percent[5]CurrencyDLR8_U5%8
22DEDCAMNT_1 SearchDeduction Amount[1]CurrencyDLR11_$S214
23DEDCAMNT_2 SearchDeduction Amount[2]CurrencyDLR11_$S214
24DEDCAMNT SearchDeduction AmountDLR11_$S2Currency14
25DEDCAMNT_3 SearchDeduction Amount[3]CurrencyDLR11_$S214
26DEDCAMNT_4 SearchDeduction Amount[4]CurrencyDLR11_$S214
27DEDCAMNT_5 SearchDeduction Amount[5]CurrencyDLR11_$S214
28DEDTRMAX_1 SearchDeduction Tier Max[1]CurrencyDLR11_$U214
29DEDTRMAX_2 SearchDeduction Tier Max[2]CurrencyDLR11_$U214
30DEDTRMAX SearchDeduction Tier MaxDLR11_$U2Currency14
31DEDTRMAX_3 SearchDeduction Tier Max[3]CurrencyDLR11_$U214
32DEDTRMAX_4 SearchDeduction Tier Max[4]CurrencyDLR11_$U214
33DEDTRMAX_5 SearchDeduction Tier Max[5]CurrencyDLR11_$U214
34DETRMXUN_1 SearchDeduction Tier Max Units[1]Long IntegerLI9_U29
35DETRMXUN_2 SearchDeduction Tier Max Units[2]Long IntegerLI9_U29
36DETRMXUN_3 SearchDeduction Tier Max Units[3]Long IntegerLI9_U29
37DETRMXUN_4 SearchDeduction Tier Max Units[4]Long IntegerLI9_U29
38DETRMXUN SearchDeduction Tier Max UnitsLI9_U2Long Integer9
39DETRMXUN_5 SearchDeduction Tier Max Units[5]Long IntegerLI9_U29
40DEPYPRMX SearchDeduction Pay Period MaxCurrencyDLR11_$S214
41DEDYRMAX SearchDeduction Year MaxCurrencyDLR11_$S214
42DEDLTMAX SearchDeduction Lifetime MaxCurrencyDLR11_$S214
43W2BXNMBR SearchW2 Box NumberIntegerINT2_U02
44W2BXLABL SearchW2 Box LabelStringSTR66
45LTDDEDTN SearchLTD DeductionCurrencyDLR11_$S214
46NOTEINDX SearchNote IndexCurrencyDLR1414
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 Index2CurrencyDLR1414
48DATAENTDFLT SearchData Entry DefaultBooleanCB_DataEntryDefault0
49EARNINGSCODE SearchEarnings CodeStringSTR15_Earnings_Code15
50COURTDATE SearchCourt DateDateDATE_L0
51COURTNAME SearchCourt NameStringSTR3030
52DOCDESCR SearchDocument DescriptionStringSTR3030
53ORIGINALAMOUNT SearchOriginal AmountCurrencyDLR11_$U214
54AMNTTAKEN SearchAmount TakenCurrencyDLR11_$U214
55VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
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 DeductionStringSTR15_Max_Code15
57STATEMAXDED SearchState Maximum DeductionStringSTR15_Max_Code15
58W2BXNMBR2 SearchW2 Box Number 2IntegerINT2_U02
59W2BXLABL2 SearchW2 Box Label 2StringSTR66
60W2BXNMBR3 SearchW2 Box Number 3IntegerINT2_U02
61W2BXLABL3 SearchW2 Box Label 3StringSTR66
62W2BXNMBR4 SearchW2 Box Number 4IntegerINT2_U02
63W2BXLABL4 SearchW2 Box Label 4StringSTR66
64Deduction_Fiscal_Yr_Max SearchDeduction Fiscal Year MaxCurrencyDLR11_$S214
65SHFRFICAMED SearchSheltered From FICA MedicareBooleanCB_FICA_Medicare0
azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Deduction Master (UPR00500)

Leave a Reply

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