Payroll Unemployment Setup (UPR40100)

azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Unemployment Setup (UPR40100)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/UPR40100

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Unemployment Setup
Physical Name: UPR40100
Technical Name: UPR_SETP_Futa/Suta

Group Display Name: Payroll Unemployment Setup
Group Technical Name: Payroll Unemployment Setup

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1FUTASUTA SearchFuta/SutaStringSTR3_Futa/Suta3
2DSCRIPTN SearchDescriptionStringSTR3030
3EPRIDNBR SearchEmployer ID NumberStringSTR9_Employer_ID_Number9
4ESTIDNBR SearchEmployer State ID NumberStringSTR2020
5FUSUTXRT SearchFuta/Suta Tax RateLong IntegerLI7_U57
6FUSUWLMT SearchFuta/Suta Wage LimitCurrencyDLR11_$U214
7INTXSHAN SearchInclude Tax Shelter AnnuitiesBooleanCB_Tax_Sheltered_Annuities0
8INPRSTWG SearchInclude Previous State WagesBooleanCB_Previous_State_Wages0
9NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Payroll Unemployment Setup'].NOTEINDX AS 'Payroll Unemployment Setup-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       UPR40100 AS ['Payroll Unemployment Setup']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Payroll Unemployment Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX
10Stat_Tax_ID SearchState Tax IDStringSTR2020
11TXENTYCD SearchTaxing Entity CodeStringSTR5_Taxing_Entity_Code5
12OTHSTDAT SearchOther State DataStringSTR1010
13STCNTRLNUM SearchState Control NumberStringSTR77
14SUPPDAT1 SearchSupplemental Data 1StringSTR7575
15SUPPDAT2 SearchSupplemental Data 2StringSTR7575
16EmployerKind SearchEmployer KindIntegerDDL_Employer_Kind0
17PayerKind SearchPayer KindIntegerDDL_Payer_Kind0
azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Unemployment Setup (UPR40100)

Leave a Reply

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