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 TypeSQL DB LengthKeyable Length
1EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
2BENEFIT SearchBenefitSTR6_Payroll_CodeString86
3INACTIVE SearchInactiveCB_InactiveBoolean20
4BNFBEGDT SearchBenefit Beg DateDTDate48
5BNFENDDT SearchBenefit End DateDTDate48
6VARBENFT SearchVariable BenefitCB_VariableBoolean20
7BNFTFREQ SearchBenefit FrequencyDDL_Ded/Ben FrequencyInteger20
8TAXABLE SearchTaxableCB_TaxableBoolean20
9SBJTFDTX SearchSubject To Federal TaxCB_FederalBoolean20
10SBJTSSEC SearchSubject To Social SecurityCB_FICA_Social_SecurityBoolean20
11SBJTMCAR SearchSubject To MedicareCB_FICA_MedicareBoolean20
12SBJTSTTX SearchSubject To State TaxCB_StateBoolean20
13SBJTLTAX SearchSubject To Local TaxCB_LocalBoolean20
14SBJTFUTA SearchSubject To FutaCB_FutaBoolean20
15SBJTSUTA SearchSubject To SutaCB_SutaBoolean20
16FFEDTXRT SearchFlat Federal Tax RateINT4_%2Integer24
17FLSTTXRT SearchFlat State Tax RateINT4_%2Integer24
18BORCDTYP SearchBased On Record TypeDDL_Based_On_Record_TypeInteger20
19BSDORCDS SearchBased On RecordsGBInteger20
20BNFTMTHD SearchBenefit MethodDDL_Benefit_MethodInteger20
21BNFFRMLA SearchBenefit FormulaGBInteger20
22BNFPRCNT SearchBenefit PercentDLR8_U5%Currency108
23BNFPRCNT_1 SearchBenefit Percent[1]DLR8_U5%Currency108
24BNFPRCNT_2 SearchBenefit Percent[2]DLR8_U5%Currency108
25BNFPRCNT_3 SearchBenefit Percent[3]DLR8_U5%Currency108
26BNFPRCNT_4 SearchBenefit Percent[4]DLR8_U5%Currency108
27BNFPRCNT_5 SearchBenefit Percent[5]DLR8_U5%Currency108
28BNFITAMT SearchBenefit AmountDLR11_$U2Currency1014
29BNFITAMT_1 SearchBenefit Amount[1]DLR11_$U2Currency1014
30BNFITAMT_2 SearchBenefit Amount[2]DLR11_$U2Currency1014
31BNFITAMT_3 SearchBenefit Amount[3]DLR11_$U2Currency1014
32BNFITAMT_4 SearchBenefit Amount[4]DLR11_$U2Currency1014
33BNFITAMT_5 SearchBenefit Amount[5]DLR11_$U2Currency1014
34BNFTRMAX SearchBenefit Tier MaxDLR11_$U2Currency1014
35BNFTRMAX_1 SearchBenefit Tier Max[1]DLR11_$U2Currency1014
36BNFTRMAX_2 SearchBenefit Tier Max[2]DLR11_$U2Currency1014
37BNFTRMAX_3 SearchBenefit Tier Max[3]DLR11_$U2Currency1014
38BNFTRMAX_4 SearchBenefit Tier Max[4]DLR11_$U2Currency1014
39BNFTRMAX_5 SearchBenefit Tier Max[5]DLR11_$U2Currency1014
40BNTRMXUN SearchBenefit Tier Max UnitsLI9_U2Long Integer49
41BNTRMXUN_1 SearchBenefit Tier Max Units[1]LI9_U2Long Integer49
42BNTRMXUN_2 SearchBenefit Tier Max Units[2]LI9_U2Long Integer49
43BNTRMXUN_3 SearchBenefit Tier Max Units[3]LI9_U2Long Integer49
44BNTRMXUN_4 SearchBenefit Tier Max Units[4]LI9_U2Long Integer49
45BNTRMXUN_5 SearchBenefit Tier Max Units[5]LI9_U2Long Integer49
46BNPAYPMX SearchBenefit Pay Period MaxDLR11_$U2Currency1014
47BNFYRMAX SearchBenefit Year MaxDLR11_$U2Currency1014
48BNFLFMAX SearchBenefit Lifetime MaxDLR11_$U2Currency1014
49W2BXNMBR SearchW2 Box NumberINT2_U0Integer22
50W2BXLABL SearchW2 Box LabelSTR6String86
51NOTEINDX SearchNote IndexDLR14Currency1014
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 BenefitDLR11_$S2Currency1014
53DATAENTDFLT SearchData Entry DefaultCB_DataEntryDefaultBoolean20
54EMPLRMAXMAT SearchEmployer Maximum MatchDLR8_U5%Currency108
55W2BXNMBR2 SearchW2 Box Number 2INT2_U0Integer22
56W2BXLABL2 SearchW2 Box Label 2STR6String86
57W2BXNMBR3 SearchW2 Box Number 3INT2_U0Integer22
58W2BXLABL3 SearchW2 Box Label 3STR6String86
59W2BXNMBR4 SearchW2 Box Number 4INT2_U0Integer22
60W2BXLABL4 SearchW2 Box Label 4STR6String86
61Benefit_Fiscal_Max SearchBenefit Fiscal MaxDLR11_$U2Currency1014
62DEX_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.

Leave a Reply

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