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 TypeSQL DB LengthKeyable Length
1ISTIPPAY SearchIs Tips PayBooleanBoolean20
2ACTINDX SearchAccount IndexLI_14Long Integer414
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 AmountDLR19_RBS0_UTR$Currency1019
4ACCTTYPE SearchAccount TypeDDL_Account_TypeInteger20
5STATECD SearchState CodeSTR2_State_CodeString42
6PAYRCORD SearchPay RecordSTR6_Payroll_CodeString86
7PAYTYPE SearchPay TypeDDL_Pay_TypesInteger20
8GROSWAGS SearchGross WagesDLR11_$S2Currency1014
9GROSWAGS_1 SearchGross Wages[1]DLR11_$S2Currency1014
10GROSWAGS_2 SearchGross Wages[2]DLR11_$S2Currency1014
11GROSWAGS_3 SearchGross Wages[3]DLR11_$S2Currency1014
12GROSWAGS_4 SearchGross Wages[4]DLR11_$S2Currency1014
13GROSWAGS_5 SearchGross Wages[5]DLR11_$S2Currency1014
14GROSWAGS_6 SearchGross Wages[6]DLR11_$S2Currency1014
15GROSWAGS_7 SearchGross Wages[7]DLR11_$S2Currency1014
16GROSWAGS_8 SearchGross Wages[8]DLR11_$S2Currency1014
17GROSWAGS_9 SearchGross Wages[9]DLR11_$S2Currency1014
18GROSWAGS_10 SearchGross Wages[10]DLR11_$S2Currency1014
19GROSWAGS_11 SearchGross Wages[11]DLR11_$S2Currency1014
20GROSWAGS_12 SearchGross Wages[12]DLR11_$S2Currency1014
21FFEDTXRT SearchFlat Federal Tax RateINT4_%2Integer24
22FLSTTXRT SearchFlat State Tax RateINT4_%2Integer24
23DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

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

Leave a Reply

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