Payroll Transaction Audit (UPR10303)

azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Transaction Audit (UPR10303)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Transaction Audit
Physical Name: UPR10303
Technical Name: UPR_TRX_Audit

Group Display Name: Payroll Transactions
Group Technical Name: Payroll Transactions

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Payroll Transaction Audit'].USERID AS 'Payroll Transaction Audit-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       UPR10303 AS ['Payroll Transaction Audit']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Payroll Transaction Audit'].USERID = ['Users Master'].USERID
2BACHNUMB SearchBatch NumberSTR15_LBAUString1615
3EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
4COMPTRTP SearchComputer TRX TypeDDL_TRX_TypeInteger20
5UPRTRXCD SearchUPR TRX CodeSTR6_Payroll_CodeString86
6TRXAUFLG SearchTRX Audit FlagTrue/FalseBoolean20
7TRXAUFLG_1 SearchTRX Audit Flag[1]True/FalseBoolean20
8TRXAUFLG_2 SearchTRX Audit Flag[2]True/FalseBoolean20
9TRXAUFLG_3 SearchTRX Audit Flag[3]True/FalseBoolean20
10TRXAUFLG_4 SearchTRX Audit Flag[4]True/FalseBoolean20
11TRXAUFLG_5 SearchTRX Audit Flag[5]True/FalseBoolean20
12TRXAUFLG_6 SearchTRX Audit Flag[6]True/FalseBoolean20
13TRXAUFLG_7 SearchTRX Audit Flag[7]True/FalseBoolean20
14TRXAUFLG_8 SearchTRX Audit Flag[8]True/FalseBoolean20
15TRXAUFLG_9 SearchTRX Audit Flag[9]True/FalseBoolean20
16TRXAUFLG_10 SearchTRX Audit Flag[10]True/FalseBoolean20
17TRXBEGDT SearchTRX Beginning DateDTDate48
18TRXENDDT SearchTRX Ending DateDTDate48
19TRXHRUNT SearchTRX Hours/UnitsLI6_S2Long Integer46
20PAYRTAMT SearchPay Rate AmountDLR11_$S2Currency1014
21HRLYPYRT SearchHourly Pay RateDLR11_$U2Currency1014
22VARDBAMT SearchVariable Ded/Ben AmountDLR11_$S2Currency1014
23VARDBPCT SearchVariable Ded/Ben PercentLI8_S5%Long Integer48
24DEPRTMNT SearchDepartmentSTR6_Payroll_CodeString86
25JOBTITLE SearchJob TitleSTR6_Payroll_CodeString86
26STATECD SearchState CodeSTR2_State_CodeString42
27LOCALTAX SearchLocal TaxSTR6_Payroll_CodeString86
28WRKRCOMP SearchWorkers CompSTR6_Payroll_CodeString86
29DAYSWRDK SearchDays WorkedLI6_S2Long Integer46
30SUTASTAT SearchSuta StateSTR2_State_CodeString42
31WKSWRKD SearchWeeks WorkedLI6_S2Long Integer46
32SHFTPREM SearchShift PremiumDLR11_$S2Currency1014
33SALCHG SearchSalary ChangeDDL_Salary_ChangeInteger20
34DEX_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 Transaction Audit (UPR10303)

Leave a Reply

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