Payroll Flat Tax Records (UPR19900)

azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Flat Tax Records (UPR19900)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Flat Tax Records
Physical Name: UPR19900
Technical Name: UPR_Flat_Tax_Records

Group Display Name: Payroll Check Work
Group Technical Name: Payroll Check Work

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ISTIPPAY SearchIs Tips PayBooleanBoolean0
2ACTINDX SearchAccount IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Payroll Flat Tax Records'].ACTINDX AS 'Payroll Flat Tax Records-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       UPR19900 AS ['Payroll Flat Tax Records']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Payroll Flat Tax Records'].ACTINDX = ['Account Index Master'].ACTINDX
3ACCTAMNT SearchAccount AmountCurrencyDLR19_RBS0_UTR$19
4ACCTTYPE SearchAccount TypeIntegerDDL_Account_Type0
5STATECD SearchState CodeStringSTR2_State_Code2
6PAYRCORD SearchPay RecordStringSTR6_Payroll_Code6
7PAYTYPE SearchPay TypeIntegerDDL_Pay_Types0
8GROSWAGS_1 SearchGross Wages[1]CurrencyDLR11_$S214
9GROSWAGS SearchGross WagesDLR11_$S2Currency14
10GROSWAGS_2 SearchGross Wages[2]CurrencyDLR11_$S214
11GROSWAGS_3 SearchGross Wages[3]CurrencyDLR11_$S214
12GROSWAGS_4 SearchGross Wages[4]CurrencyDLR11_$S214
13GROSWAGS_5 SearchGross Wages[5]CurrencyDLR11_$S214
14GROSWAGS_6 SearchGross Wages[6]CurrencyDLR11_$S214
15GROSWAGS_7 SearchGross Wages[7]CurrencyDLR11_$S214
16GROSWAGS_8 SearchGross Wages[8]CurrencyDLR11_$S214
17GROSWAGS_9 SearchGross Wages[9]CurrencyDLR11_$S214
18GROSWAGS_10 SearchGross Wages[10]CurrencyDLR11_$S214
19GROSWAGS_11 SearchGross Wages[11]CurrencyDLR11_$S214
20GROSWAGS_12 SearchGross Wages[12]CurrencyDLR11_$S214
21FFEDTXRT SearchFlat Federal Tax RateIntegerINT4_%24
22FLSTTXRT SearchFlat State Tax RateIntegerINT4_%24
azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Flat Tax Records (UPR19900)

Leave a Reply

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