Payroll Benefit Master (UPR00600)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Benefit Master
Physical Name: UPR00600
Technical Name: UPR_MSTR_Benefit

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
2BENEFIT SearchBenefitStringSTR6_Payroll_Code6
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_1 SearchBenefit Percent[1]CurrencyDLR8_U5%8
23BNFPRCNT SearchBenefit PercentDLR8_U5%Currency8
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 Master'].NOTEINDX AS 'Payroll Benefit Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       UPR00600 AS ['Payroll Benefit Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Payroll Benefit Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
52LTDBNFIT SearchLTD BenefitCurrencyDLR11_$S214
53DATAENTDFLT SearchData Entry DefaultBooleanCB_DataEntryDefault0
54EMPLRMAXMAT SearchEmployer Maximum MatchCurrencyDLR8_U5%8
55W2BXNMBR2 SearchW2 Box Number 2IntegerINT2_U02
56W2BXLABL2 SearchW2 Box Label 2StringSTR66
57W2BXNMBR3 SearchW2 Box Number 3IntegerINT2_U02
58W2BXLABL3 SearchW2 Box Label 3StringSTR66
59W2BXNMBR4 SearchW2 Box Number 4IntegerINT2_U02
60W2BXLABL4 SearchW2 Box Label 4StringSTR66
61Benefit_Fiscal_Max SearchBenefit Fiscal MaxCurrencyDLR11_$U214

Leave a Reply

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