Future Effective Payroll Benefit Setup (APR_BLM42100)

azurecurveProductsHRM Solution Series (1911)PayrollFuture Effective Payroll Benefit Setup (APR_BLM42100)

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

Product: HRM Solution Series (1911)
Series: Payroll

Display Name: Future Effective Payroll Benefit Setup
Physical Name: APR_BLM42100
Technical Name: APR_BLM_PRBenefit

Group Display Name: HRM Solution Series
Group Technical Name: APR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1BENEFIT SearchBenefitSTR6_Payroll_CodeString6
2DSCRIPTN SearchDescriptionSTR30String30
3INACTIVE SearchInactiveCB_InactiveBoolean0
4BNFBEGDT SearchBenefit Beg DateDTDate8
5BNFENDDT SearchBenefit End DateDTDate8
6VARBENFT SearchVariable BenefitCB_VariableBoolean0
7BNFTFREQ SearchBenefit FrequencyDDL_Ded/Ben FrequencyInteger0
8TAXABLE SearchTaxableCB_TaxableBoolean0
9SBJTFDTX SearchSubject To Federal TaxCB_FederalBoolean0
10SBJTSSEC SearchSubject To Social SecurityCB_FICA_Social_SecurityBoolean0
11SBJTMCAR SearchSubject To MedicareCB_FICA_MedicareBoolean0
12SBJTSTTX SearchSubject To State TaxCB_StateBoolean0
13SBJTLTAX SearchSubject To Local TaxCB_LocalBoolean0
14SBJTFUTA SearchSubject To FutaCB_FutaBoolean0
15SBJTSUTA SearchSubject To SutaCB_SutaBoolean0
16FFEDTXRT SearchFlat Federal Tax RateINT4_%2Integer4
17FLSTTXRT SearchFlat State Tax RateINT4_%2Integer4
18BORCDTYP SearchBased On Record TypeDDL_Based_On_Record_TypeInteger0
19BSDORCDS SearchBased On RecordsGBInteger0
20BNFTMTHD SearchBenefit MethodDDL_Benefit_MethodInteger0
21BNFFRMLA SearchBenefit FormulaGBInteger0
22BNFPRCNT_1 SearchBenefit Percent[1]DLR8_U5%Currency8
23BNFPRCNT_2 SearchBenefit Percent[2]DLR8_U5%Currency8
24BNFPRCNT_3 SearchBenefit Percent[3]DLR8_U5%Currency8
25BNFPRCNT_4 SearchBenefit Percent[4]DLR8_U5%Currency8
26BNFPRCNT_5 SearchBenefit Percent[5]DLR8_U5%Currency8
27BNFITAMT_1 SearchBenefit Amount[1]DLR11_$U2Currency14
28BNFITAMT_2 SearchBenefit Amount[2]DLR11_$U2Currency14
29BNFITAMT_3 SearchBenefit Amount[3]DLR11_$U2Currency14
30BNFITAMT_4 SearchBenefit Amount[4]DLR11_$U2Currency14
31BNFITAMT_5 SearchBenefit Amount[5]DLR11_$U2Currency14
32BNFTRMAX_1 SearchBenefit Tier Max[1]DLR11_$U2Currency14
33BNFTRMAX_2 SearchBenefit Tier Max[2]DLR11_$U2Currency14
34BNFTRMAX_3 SearchBenefit Tier Max[3]DLR11_$U2Currency14
35BNFTRMAX_4 SearchBenefit Tier Max[4]DLR11_$U2Currency14
36BNFTRMAX_5 SearchBenefit Tier Max[5]DLR11_$U2Currency14
37BNTRMXUN_1 SearchBenefit Tier Max Units[1]LI9_U2Long Integer9
38BNTRMXUN_2 SearchBenefit Tier Max Units[2]LI9_U2Long Integer9
39BNTRMXUN_3 SearchBenefit Tier Max Units[3]LI9_U2Long Integer9
40BNTRMXUN_4 SearchBenefit Tier Max Units[4]LI9_U2Long Integer9
41BNTRMXUN_5 SearchBenefit Tier Max Units[5]LI9_U2Long Integer9
42BNPAYPMX SearchBenefit Pay Period MaxDLR11_$U2Currency14
43BNFYRMAX SearchBenefit Year MaxDLR11_$U2Currency14
44BNFLFMAX SearchBenefit Lifetime MaxDLR11_$U2Currency14
45W2BXNMBR SearchW2 Box NumberINT2_U0Integer2
46W2BXLABL SearchW2 Box LabelSTR6String6
47NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Future Effective Payroll Benefit Setup'].NOTEINDX AS 'Future Effective Payroll Benefit Setup-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       APR_BLM42100 AS ['Future Effective Payroll Benefit Setup']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Future Effective Payroll Benefit Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX
48DATAENTDFLT SearchData Entry DefaultCB_DataEntryDefaultBoolean0
49EMPLRMAXMAT SearchEmployer Maximum MatchDLR8_U5%Currency8
50W2BXNMBR2 SearchW2 Box Number 2INT2_U0Integer2
51W2BXLABL2 SearchW2 Box Label 2STR6String6
52W2BXNMBR3 SearchW2 Box Number 3INT2_U0Integer2
53W2BXLABL3 SearchW2 Box Label 3STR6String6
54W2BXNMBR4 SearchW2 Box Number 4INT2_U0Integer2
55W2BXLABL4 SearchW2 Box Label 4STR6String6
56Benefit_Fiscal_Max SearchBenefit Fiscal MaxDLR11_$U2Currency14
57DEX_ROW_ID Searchintint10

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.

azurecurveProductsHRM Solution Series (1911)PayrollFuture Effective Payroll Benefit Setup (APR_BLM42100)

Leave a Reply

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