Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/UPR41800
Product: Microsoft Dynamics GP (0)
Series: Payroll
Display Name: Payroll Maximum Deduction Setup Group Display Name: Payroll Earnings Setup
Physical Name: UPR41800
Technical Name: uprSetupMaxDeduction
Group Technical Name: Payroll Earnings Setup
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | MAXDEDUCTION | Max Deduction Code | String | STR15_Max_Code | 15 | |
2 | DSCRIPTN | Description | String | STR30 | 30 | |
3 | STATEFED | State/Fed | String | STR3_Futa/Suta | 3 | |
4 | MAXMETHOD | Max Method | Integer | DDL_Method | 0 | |
5 | MAXPERCENT | Max Withholding Percent | Integer | INT5_%2 | 5 | |
6 | MAXEXEMPTAMT | Max Exempt Amount | Currency | DLR11_$U2 | 14 | |
7 | MINWAGEAMT | Min Wage Rule Amount | Currency | DLR11_$U2 | 14 | |
8 | EARNINGSCODE | Earnings Code | String | STR15_Earnings_Code | 15 | |
9 | INCLUDEPREVSEQDED | Include Previous Seq Deductions | Boolean | Include Previous Seq Deductions | 0 | |
10 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['Payroll Maximum Deduction Setup'].NOTEINDX AS 'Payroll Maximum Deduction Setup-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
UPR41800 AS ['Payroll Maximum Deduction Setup']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Payroll Maximum Deduction Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX |