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:

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 SearchDeductionStringSTR6_Payroll_Code6
2DSCRIPTN SearchDescriptionStringSTR3030
3INACTIVE SearchInactiveBooleanCB_Inactive0
4DEDBEGDT SearchDeduction Beg DateDateDT8
5DEDENDDT SearchDeduction End DateDateDT8
6VARDEDTN SearchVariable DeductionBooleanCB_Variable0
7DEDNFREQ SearchDeduction FrequencyIntegerDDL_Ded/Ben Frequency0
8TXSHANTY SearchTax Sheltered AnnuityBooleanCB_Tax_Sheltered_Annuity0
9SFRFEDTX SearchSheltered From Federal TaxBooleanCB_Federal_Tax0
10SHFRFICA SearchSheltered From FICABooleanCB_FICA_Social_Security0
11SHFRSTTX SearchSheltered From State TaxBooleanCB_State_Tax0
12SFRLCLTX SearchSheltered From Local TaxBooleanCB_Local_Tax0
13BSDORCDS SearchBased On RecordsIntegerGB0
14DEDNMTHD SearchDeduction MethodIntegerDDL_Deduction_Method0
15DEDFRMLA SearchDeduction FormulaIntegerGB0
16DEDCAMNT_1 SearchDeduction Amount[1]CurrencyDLR11_$S214
17DEDCAMNT_2 SearchDeduction Amount[2]CurrencyDLR11_$S214
18DEDCAMNT_3 SearchDeduction Amount[3]CurrencyDLR11_$S214
19DEDCAMNT_4 SearchDeduction Amount[4]CurrencyDLR11_$S214
20DEDCAMNT_5 SearchDeduction Amount[5]CurrencyDLR11_$S214
21DEDNPRCT_1 SearchDeduction Percent[1]CurrencyDLR8_U5%8
22DEDNPRCT_2 SearchDeduction Percent[2]CurrencyDLR8_U5%8
23DEDNPRCT_3 SearchDeduction Percent[3]CurrencyDLR8_U5%8
24DEDNPRCT_4 SearchDeduction Percent[4]CurrencyDLR8_U5%8
25DEDNPRCT_5 SearchDeduction Percent[5]CurrencyDLR8_U5%8
26DEDTRMAX_1 SearchDeduction Tier Max[1]CurrencyDLR11_$U214
27DEDTRMAX_2 SearchDeduction Tier Max[2]CurrencyDLR11_$U214
28DEDTRMAX_3 SearchDeduction Tier Max[3]CurrencyDLR11_$U214
29DEDTRMAX_4 SearchDeduction Tier Max[4]CurrencyDLR11_$U214
30DEDTRMAX_5 SearchDeduction Tier Max[5]CurrencyDLR11_$U214
31DETRMXUN_1 SearchDeduction Tier Max Units[1]Long IntegerLI9_U29
32DETRMXUN_2 SearchDeduction Tier Max Units[2]Long IntegerLI9_U29
33DETRMXUN_3 SearchDeduction Tier Max Units[3]Long IntegerLI9_U29
34DETRMXUN_4 SearchDeduction Tier Max Units[4]Long IntegerLI9_U29
35DETRMXUN_5 SearchDeduction Tier Max Units[5]Long IntegerLI9_U29
36DEPYPRMX SearchDeduction Pay Period MaxCurrencyDLR11_$S214
37DEDYRMAX SearchDeduction Year MaxCurrencyDLR11_$S214
38DEDLTMAX SearchDeduction Lifetime MaxCurrencyDLR11_$S214
39W2BXNMBR SearchW2 Box NumberIntegerINT2_U02
40W2BXLABL SearchW2 Box LabelStringSTR66
41NOTEINDX SearchNote IndexCurrencyDLR1414
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 DefaultBooleanCB_DataEntryDefault0
43DEDTYPE SearchDeduction TypeIntegerDDL_Deduction_Type0
44GARNCAT SearchGarnishment CategoryIntegerDDL_Garnishment_Cat0
45EARNINGSCODE SearchEarnings CodeStringSTR15_Earnings_Code15
46SEQNUMBR SearchSequence NumberLong IntegerLI_Sequence_Number10
47W2BXNMBR2 SearchW2 Box Number 2IntegerINT2_U02
48W2BXLABL2 SearchW2 Box Label 2StringSTR66
49W2BXNMBR3 SearchW2 Box Number 3IntegerINT2_U02
50W2BXLABL3 SearchW2 Box Label 3StringSTR66
51W2BXNMBR4 SearchW2 Box Number 4IntegerINT2_U02
52W2BXLABL4 SearchW2 Box Label 4StringSTR66
53Deduction_Fiscal_Yr_Max SearchDeduction Fiscal Year MaxCurrencyDLR11_$S214
54SHFRFICAMED SearchSheltered From FICA MedicareBooleanCB_FICA_Medicare0
55CHANGEBY_I SearchChange ByStringSTR15_User_ID15
56CHANGEDATE_I SearchChange DateDateDT8
57CHANGEREASON_I SearchChange ReasonStringSTR30_I30
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 *