Payroll Flat Tax Records (UPR19900)

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

Easily find this page again using the shortlink:

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 IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

       ['Payroll Flat Tax Records'].ACTINDX AS 'Payroll Flat Tax Records-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
       UPR19900 AS ['Payroll Flat Tax Records']
       GL00105 AS ['Account Index Master']
                     ['Payroll Flat Tax Records'].ACTINDX = ['Account Index Master'].ACTINDX
3ACCTAMNT SearchAccount AmountDLR19_RBS0_UTR$Currency19
4ACCTTYPE SearchAccount TypeDDL_Account_TypeInteger0
5STATECD SearchState CodeSTR2_State_CodeString2
6PAYRCORD SearchPay RecordSTR6_Payroll_CodeString6
7PAYTYPE SearchPay TypeDDL_Pay_TypesInteger0
8GROSWAGS SearchGross WagesDLR11_$S2Currency14
9GROSWAGS_1 SearchGross Wages[1]DLR11_$S2Currency14
10GROSWAGS_2 SearchGross Wages[2]DLR11_$S2Currency14
11GROSWAGS_3 SearchGross Wages[3]DLR11_$S2Currency14
12GROSWAGS_4 SearchGross Wages[4]DLR11_$S2Currency14
13GROSWAGS_5 SearchGross Wages[5]DLR11_$S2Currency14
14GROSWAGS_6 SearchGross Wages[6]DLR11_$S2Currency14
15GROSWAGS_7 SearchGross Wages[7]DLR11_$S2Currency14
16GROSWAGS_8 SearchGross Wages[8]DLR11_$S2Currency14
17GROSWAGS_9 SearchGross Wages[9]DLR11_$S2Currency14
18GROSWAGS_10 SearchGross Wages[10]DLR11_$S2Currency14
19GROSWAGS_11 SearchGross Wages[11]DLR11_$S2Currency14
20GROSWAGS_12 SearchGross Wages[12]DLR11_$S2Currency14
21FFEDTXRT SearchFlat Federal Tax RateINT4_%2Integer4
22FLSTTXRT SearchFlat State Tax RateINT4_%2Integer4
23DEX_ROW_ID Searchintint10

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 *