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 | Local Tax Calculation | INT | Integer | 0 | |
4 | LCLTXCAL_1 | Local Tax Calculation[1] | Integer | INT | 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 |