Payroll Benefit Setup (UPR40800)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Benefit Setup
Physical Name: UPR40800
Technical Name: UPR_SETP_Benefit

Group Display Name: Payroll Benefit Setup
Group Technical Name: Payroll Benefit Setup

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1BENEFIT SearchBenefitStringSTR6_Payroll_Code6
2DSCRIPTN SearchDescriptionStringSTR3030
3INACTIVE SearchInactiveBooleanCB_Inactive0
4BNFBEGDT SearchBenefit Beg DateDateDT8
5BNFENDDT SearchBenefit End DateDateDT8
6VARBENFT SearchVariable BenefitBooleanCB_Variable0
7BNFTFREQ SearchBenefit FrequencyIntegerDDL_Ded/Ben Frequency0
8TAXABLE SearchTaxableBooleanCB_Taxable0
9SBJTFDTX SearchSubject To Federal TaxBooleanCB_Federal0
10SBJTSSEC SearchSubject To Social SecurityBooleanCB_FICA_Social_Security0
11SBJTMCAR SearchSubject To MedicareBooleanCB_FICA_Medicare0
12SBJTSTTX SearchSubject To State TaxBooleanCB_State0
13SBJTLTAX SearchSubject To Local TaxBooleanCB_Local0
14SBJTFUTA SearchSubject To FutaBooleanCB_Futa0
15SBJTSUTA SearchSubject To SutaBooleanCB_Suta0
16FFEDTXRT SearchFlat Federal Tax RateIntegerINT4_%24
17FLSTTXRT SearchFlat State Tax RateIntegerINT4_%24
18BORCDTYP SearchBased On Record TypeIntegerDDL_Based_On_Record_Type0
19BSDORCDS SearchBased On RecordsIntegerGB0
20BNFTMTHD SearchBenefit MethodIntegerDDL_Benefit_Method0
21BNFFRMLA SearchBenefit FormulaIntegerGB0
22BNFPRCNT SearchBenefit PercentDLR8_U5%Currency8
23BNFPRCNT_1 SearchBenefit Percent[1]CurrencyDLR8_U5%8
24BNFPRCNT_2 SearchBenefit Percent[2]CurrencyDLR8_U5%8
25BNFPRCNT_3 SearchBenefit Percent[3]CurrencyDLR8_U5%8
26BNFPRCNT_4 SearchBenefit Percent[4]CurrencyDLR8_U5%8
27BNFPRCNT_5 SearchBenefit Percent[5]CurrencyDLR8_U5%8
28BNFITAMT_1 SearchBenefit Amount[1]CurrencyDLR11_$U214
29BNFITAMT_2 SearchBenefit Amount[2]CurrencyDLR11_$U214
30BNFITAMT SearchBenefit AmountDLR11_$U2Currency14
31BNFITAMT_3 SearchBenefit Amount[3]CurrencyDLR11_$U214
32BNFITAMT_4 SearchBenefit Amount[4]CurrencyDLR11_$U214
33BNFITAMT_5 SearchBenefit Amount[5]CurrencyDLR11_$U214
34BNFTRMAX_1 SearchBenefit Tier Max[1]CurrencyDLR11_$U214
35BNFTRMAX_2 SearchBenefit Tier Max[2]CurrencyDLR11_$U214
36BNFTRMAX SearchBenefit Tier MaxDLR11_$U2Currency14
37BNFTRMAX_3 SearchBenefit Tier Max[3]CurrencyDLR11_$U214
38BNFTRMAX_4 SearchBenefit Tier Max[4]CurrencyDLR11_$U214
39BNFTRMAX_5 SearchBenefit Tier Max[5]CurrencyDLR11_$U214
40BNTRMXUN_1 SearchBenefit Tier Max Units[1]Long IntegerLI9_U29
41BNTRMXUN_2 SearchBenefit Tier Max Units[2]Long IntegerLI9_U29
42BNTRMXUN_3 SearchBenefit Tier Max Units[3]Long IntegerLI9_U29
43BNTRMXUN_4 SearchBenefit Tier Max Units[4]Long IntegerLI9_U29
44BNTRMXUN SearchBenefit Tier Max UnitsLI9_U2Long Integer9
45BNTRMXUN_5 SearchBenefit Tier Max Units[5]Long IntegerLI9_U29
46BNPAYPMX SearchBenefit Pay Period MaxCurrencyDLR11_$U214
47BNFYRMAX SearchBenefit Year MaxCurrencyDLR11_$U214
48BNFLFMAX SearchBenefit Lifetime MaxCurrencyDLR11_$U214
49W2BXNMBR SearchW2 Box NumberIntegerINT2_U02
50W2BXLABL SearchW2 Box LabelStringSTR66
51NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Payroll Benefit Setup'].NOTEINDX AS 'Payroll Benefit Setup-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       UPR40800 AS ['Payroll Benefit Setup']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Payroll Benefit Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX
52DATAENTDFLT SearchData Entry DefaultBooleanCB_DataEntryDefault0
53EMPLRMAXMAT SearchEmployer Maximum MatchCurrencyDLR8_U5%8
54W2BXNMBR2 SearchW2 Box Number 2IntegerINT2_U02
55W2BXLABL2 SearchW2 Box Label 2StringSTR66
56W2BXNMBR3 SearchW2 Box Number 3IntegerINT2_U02
57W2BXLABL3 SearchW2 Box Label 3StringSTR66
58W2BXNMBR4 SearchW2 Box Number 4IntegerINT2_U02
59W2BXLABL4 SearchW2 Box Label 4StringSTR66
60Benefit_Fiscal_Max SearchBenefit Fiscal MaxCurrencyDLR11_$U214

Leave a Reply

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