Payroll Local Tax Setup (UPR41400)

azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Local Tax Setup (UPR41400)

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
Physical Name: UPR41400
Technical Name: UPR_SETP_Local_Tax

Group Display Name: Payroll Local Tax Setup
Group Technical Name: Payroll Local Tax Setup

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1LOCALTAX SearchLocal TaxStringSTR6_Payroll_Code6
2DSCRIPTN SearchDescriptionStringSTR3030
3LCLTXCAL SearchLocal Tax CalculationINTInteger0
4LCLTXCAL_1 SearchLocal Tax Calculation[1]IntegerINT0
5LCLTXCAL_2 SearchLocal Tax Calculation[2]IntegerINT0
6LCLTXCAL_3 SearchLocal Tax Calculation[3]IntegerINT0
7LCLTXCAL_4 SearchLocal Tax Calculation[4]IntegerINT0
8LCLTXCAL_5 SearchLocal Tax Calculation[5]IntegerINT0
9EXMTAMNT SearchExemption AmountCurrencyDLR11_$U214
10MNTXBLWG SearchMinimum Taxable WagesCurrencyDLR11_$U214
11MYTDTXWG SearchMinimum YTD Taxable WagesCurrencyDLR11_$S214
12LCLTAXRT SearchLocal Tax RateLong IntegerLI8_U5%8
13LCLTXAMT SearchLocal Tax AmountCurrencyDLR11_$U214
14MAXPERYR SearchMaximum Per YearCurrencyDLR11_$U214
15INACTIVE SearchInactiveBooleanCB_Inactive0
16NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['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
17STDDMTHD SearchStandard Deduction MethodIntegerGB0
18STDDPCNT SearchStandard Deduction PercentLong IntegerLI8_U5%8
19STDDEDAM SearchStandard Deduction AmountCurrencyDLR11_$S214
20STDEDMAX SearchStandard Deduction MaximumCurrencyDLR11_$S214
21STDEDMIN SearchStandard Deduction MinimumCurrencyDLR11_$S214
22TAXTYPE SearchTax TypeIntegerTax_Type_DDL0
azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Local Tax Setup (UPR41400)

Leave a Reply

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