Future Effective Payroll Deduction Setup History (APR_BLM33100)

azurecurveProductsHRM Solution Series (1911)PayrollFuture Effective Payroll Deduction Setup History (APR_BLM33100)

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

Product: HRM Solution Series (1911)
Series: Payroll

Display Name: Future Effective Payroll Deduction Setup History
Physical Name: APR_BLM33100
Technical Name: APR_BLM_PRDeduction_History

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1DEDUCTON SearchDeductionSTR6_Payroll_CodeString6
2DSCRIPTN SearchDescriptionSTR30String30
3INACTIVE SearchInactiveCB_InactiveBoolean0
4DEDBEGDT SearchDeduction Beg DateDTDate8
5DEDENDDT SearchDeduction End DateDTDate8
6VARDEDTN SearchVariable DeductionCB_VariableBoolean0
7DEDNFREQ SearchDeduction FrequencyDDL_Ded/Ben FrequencyInteger0
8TXSHANTY SearchTax Sheltered AnnuityCB_Tax_Sheltered_AnnuityBoolean0
9SFRFEDTX SearchSheltered From Federal TaxCB_Federal_TaxBoolean0
10SHFRFICA SearchSheltered From FICACB_FICA_Social_SecurityBoolean0
11SHFRSTTX SearchSheltered From State TaxCB_State_TaxBoolean0
12SFRLCLTX SearchSheltered From Local TaxCB_Local_TaxBoolean0
13BSDORCDS SearchBased On RecordsGBInteger0
14DEDNMTHD SearchDeduction MethodDDL_Deduction_MethodInteger0
15DEDFRMLA SearchDeduction FormulaGBInteger0
16DEDCAMNT_1 SearchDeduction Amount[1]DLR11_$S2Currency14
17DEDCAMNT_2 SearchDeduction Amount[2]DLR11_$S2Currency14
18DEDCAMNT_3 SearchDeduction Amount[3]DLR11_$S2Currency14
19DEDCAMNT_4 SearchDeduction Amount[4]DLR11_$S2Currency14
20DEDCAMNT_5 SearchDeduction Amount[5]DLR11_$S2Currency14
21DEDNPRCT_1 SearchDeduction Percent[1]DLR8_U5%Currency8
22DEDNPRCT_2 SearchDeduction Percent[2]DLR8_U5%Currency8
23DEDNPRCT_3 SearchDeduction Percent[3]DLR8_U5%Currency8
24DEDNPRCT_4 SearchDeduction Percent[4]DLR8_U5%Currency8
25DEDNPRCT_5 SearchDeduction Percent[5]DLR8_U5%Currency8
26DEDTRMAX_1 SearchDeduction Tier Max[1]DLR11_$U2Currency14
27DEDTRMAX_2 SearchDeduction Tier Max[2]DLR11_$U2Currency14
28DEDTRMAX_3 SearchDeduction Tier Max[3]DLR11_$U2Currency14
29DEDTRMAX_4 SearchDeduction Tier Max[4]DLR11_$U2Currency14
30DEDTRMAX_5 SearchDeduction Tier Max[5]DLR11_$U2Currency14
31DETRMXUN_1 SearchDeduction Tier Max Units[1]LI9_U2Long Integer9
32DETRMXUN_2 SearchDeduction Tier Max Units[2]LI9_U2Long Integer9
33DETRMXUN_3 SearchDeduction Tier Max Units[3]LI9_U2Long Integer9
34DETRMXUN_4 SearchDeduction Tier Max Units[4]LI9_U2Long Integer9
35DETRMXUN_5 SearchDeduction Tier Max Units[5]LI9_U2Long Integer9
36DEPYPRMX SearchDeduction Pay Period MaxDLR11_$S2Currency14
37DEDYRMAX SearchDeduction Year MaxDLR11_$S2Currency14
38DEDLTMAX SearchDeduction Lifetime MaxDLR11_$S2Currency14
39W2BXNMBR SearchW2 Box NumberINT2_U0Integer2
40W2BXLABL SearchW2 Box LabelSTR6String6
41NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Future Effective Payroll Deduction Setup History'].NOTEINDX AS 'Future Effective Payroll Deduction Setup History-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       APR_BLM33100 AS ['Future Effective Payroll Deduction Setup History']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Future Effective Payroll Deduction Setup History'].NOTEINDX = ['Record Notes Master'].NOTEINDX
42DATAENTDFLT SearchData Entry DefaultCB_DataEntryDefaultBoolean0
43DEDTYPE SearchDeduction TypeDDL_Deduction_TypeInteger0
44GARNCAT SearchGarnishment CategoryDDL_Garnishment_CatInteger0
45EARNINGSCODE SearchEarnings CodeSTR15_Earnings_CodeString15
46SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
47W2BXNMBR2 SearchW2 Box Number 2INT2_U0Integer2
48W2BXLABL2 SearchW2 Box Label 2STR6String6
49W2BXNMBR3 SearchW2 Box Number 3INT2_U0Integer2
50W2BXLABL3 SearchW2 Box Label 3STR6String6
51W2BXNMBR4 SearchW2 Box Number 4INT2_U0Integer2
52W2BXLABL4 SearchW2 Box Label 4STR6String6
53Deduction_Fiscal_Yr_Max SearchDeduction Fiscal Year MaxDLR11_$S2Currency14
54SHFRFICAMED SearchSheltered From FICA MedicareCB_FICA_MedicareBoolean0
55CHANGEBY_I SearchChange BySTR15_User_IDString15
56CHANGEDATE_I SearchChange DateDTDate8
57CHANGEREASON_I SearchChange ReasonSTR30_IString30
58DEX_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 Deduction Setup History (APR_BLM33100)

Leave a Reply

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