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 TypeLength
1USERID SearchUser IDSTR15_User_IDString15
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_LBAUString15
3EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
4COMPTRTP SearchComputer TRX TypeDDL_TRX_TypeInteger0
5UPRTRXCD SearchUPR TRX CodeSTR6_Payroll_CodeString6
6TRXAUFLG SearchTRX Audit FlagTrue/FalseBoolean0
7TRXAUFLG_1 SearchTRX Audit Flag[1]True/FalseBoolean0
8TRXAUFLG_2 SearchTRX Audit Flag[2]True/FalseBoolean0
9TRXAUFLG_3 SearchTRX Audit Flag[3]True/FalseBoolean0
10TRXAUFLG_4 SearchTRX Audit Flag[4]True/FalseBoolean0
11TRXAUFLG_5 SearchTRX Audit Flag[5]True/FalseBoolean0
12TRXAUFLG_6 SearchTRX Audit Flag[6]True/FalseBoolean0
13TRXAUFLG_7 SearchTRX Audit Flag[7]True/FalseBoolean0
14TRXAUFLG_8 SearchTRX Audit Flag[8]True/FalseBoolean0
15TRXAUFLG_9 SearchTRX Audit Flag[9]True/FalseBoolean0
16TRXAUFLG_10 SearchTRX Audit Flag[10]True/FalseBoolean0
17TRXBEGDT SearchTRX Beginning DateDTDate8
18TRXENDDT SearchTRX Ending DateDTDate8
19TRXHRUNT SearchTRX Hours/UnitsLI6_S2Long Integer6
20PAYRTAMT SearchPay Rate AmountDLR11_$S2Currency14
21HRLYPYRT SearchHourly Pay RateDLR11_$U2Currency14
22VARDBAMT SearchVariable Ded/Ben AmountDLR11_$S2Currency14
23VARDBPCT SearchVariable Ded/Ben PercentLI8_S5%Long Integer8
24DEPRTMNT SearchDepartmentSTR6_Payroll_CodeString6
25JOBTITLE SearchJob TitleSTR6_Payroll_CodeString6
26STATECD SearchState CodeSTR2_State_CodeString2
27LOCALTAX SearchLocal TaxSTR6_Payroll_CodeString6
28WRKRCOMP SearchWorkers CompSTR6_Payroll_CodeString6
29DAYSWRDK SearchDays WorkedLI6_S2Long Integer6
30SUTASTAT SearchSuta StateSTR2_State_CodeString2
31WKSWRKD SearchWeeks WorkedLI6_S2Long Integer6
32SHFTPREM SearchShift PremiumDLR11_$S2Currency14
33SALCHG SearchSalary ChangeDDL_Salary_ChangeInteger0
34DEX_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 Transaction Audit (UPR10303)

Leave a Reply

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