Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/UPR41400
Product: Microsoft Dynamics GP (0)
Series: Payroll
Display Name: Payroll Local Tax Setup Group Display Name: Payroll Local Tax Setup
Physical Name: UPR41400
Technical Name: UPR_SETP_Local_Tax
Group Technical Name: Payroll Local Tax Setup
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | LOCALTAX ![]() | Local Tax | String | STR6_Payroll_Code | 6 | |
2 | DSCRIPTN ![]() | Description | String | STR30 | 30 | |
3 | LCLTXCAL_1 ![]() | Local Tax Calculation[1] | Integer | INT | 0 | |
4 | LCLTXCAL ![]() | Local Tax Calculation | INT | Integer | 0 | |
5 | LCLTXCAL_2 ![]() | Local Tax Calculation[2] | Integer | INT | 0 | |
6 | LCLTXCAL_3 ![]() | Local Tax Calculation[3] | Integer | INT | 0 | |
7 | LCLTXCAL_4 ![]() | Local Tax Calculation[4] | Integer | INT | 0 | |
8 | LCLTXCAL_5 ![]() | Local Tax Calculation[5] | Integer | INT | 0 | |
9 | EXMTAMNT ![]() | Exemption Amount | Currency | DLR11_$U2 | 14 | |
10 | MNTXBLWG ![]() | Minimum Taxable Wages | Currency | DLR11_$U2 | 14 | |
11 | MYTDTXWG ![]() | Minimum YTD Taxable Wages | Currency | DLR11_$S2 | 14 | |
12 | LCLTAXRT ![]() | Local Tax Rate | Long Integer | LI8_U5% | 8 | |
13 | LCLTXAMT ![]() | Local Tax Amount | Currency | DLR11_$U2 | 14 | |
14 | MAXPERYR ![]() | Maximum Per Year | Currency | DLR11_$U2 | 14 | |
15 | INACTIVE ![]() | Inactive | Boolean | CB_Inactive | 0 | |
16 | NOTEINDX ![]() | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['Payroll Local Tax Setup'].NOTEINDX AS 'Payroll Local Tax Setup-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
UPR41400 AS ['Payroll Local Tax Setup']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Payroll Local Tax Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
17 | STDDMTHD ![]() | Standard Deduction Method | Integer | GB | 0 | |
18 | STDDPCNT ![]() | Standard Deduction Percent | Long Integer | LI8_U5% | 8 | |
19 | STDDEDAM ![]() | Standard Deduction Amount | Currency | DLR11_$S2 | 14 | |
20 | STDEDMAX ![]() | Standard Deduction Maximum | Currency | DLR11_$S2 | 14 | |
21 | STDEDMIN ![]() | Standard Deduction Minimum | Currency | DLR11_$S2 | 14 | |
22 | TAXTYPE ![]() | Tax Type | Integer | Tax_Type_DDL | 0 |