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 IDStringSTR15_User_ID15
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 NumberStringSTR15_LBAU15
3EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
4COMPTRTP SearchComputer TRX TypeIntegerDDL_TRX_Type0
5UPRTRXCD SearchUPR TRX CodeStringSTR6_Payroll_Code6
6TRXAUFLG SearchTRX Audit FlagTrue/FalseBoolean0
7TRXAUFLG_1 SearchTRX Audit Flag[1]BooleanTrue/False0
8TRXAUFLG_2 SearchTRX Audit Flag[2]BooleanTrue/False0
9TRXAUFLG_3 SearchTRX Audit Flag[3]BooleanTrue/False0
10TRXAUFLG_4 SearchTRX Audit Flag[4]BooleanTrue/False0
11TRXAUFLG_5 SearchTRX Audit Flag[5]BooleanTrue/False0
12TRXAUFLG_6 SearchTRX Audit Flag[6]BooleanTrue/False0
13TRXAUFLG_7 SearchTRX Audit Flag[7]BooleanTrue/False0
14TRXAUFLG_8 SearchTRX Audit Flag[8]BooleanTrue/False0
15TRXAUFLG_9 SearchTRX Audit Flag[9]BooleanTrue/False0
16TRXAUFLG_10 SearchTRX Audit Flag[10]BooleanTrue/False0
17TRXBEGDT SearchTRX Beginning DateDateDT8
18TRXENDDT SearchTRX Ending DateDateDT8
19TRXHRUNT SearchTRX Hours/UnitsLong IntegerLI6_S26
20PAYRTAMT SearchPay Rate AmountCurrencyDLR11_$S214
21HRLYPYRT SearchHourly Pay RateCurrencyDLR11_$U214
22VARDBAMT SearchVariable Ded/Ben AmountCurrencyDLR11_$S214
23VARDBPCT SearchVariable Ded/Ben PercentLong IntegerLI8_S5%8
24DEPRTMNT SearchDepartmentStringSTR6_Payroll_Code6
25JOBTITLE SearchJob TitleStringSTR6_Payroll_Code6
26STATECD SearchState CodeStringSTR2_State_Code2
27LOCALTAX SearchLocal TaxStringSTR6_Payroll_Code6
28WRKRCOMP SearchWorkers CompStringSTR6_Payroll_Code6
29DAYSWRDK SearchDays WorkedLong IntegerLI6_S26
30SUTASTAT SearchSuta StateStringSTR2_State_Code2
31WKSWRKD SearchWeeks WorkedLong IntegerLI6_S26
32SHFTPREM SearchShift PremiumCurrencyDLR11_$S214
33SALCHG SearchSalary ChangeIntegerDDL_Salary_Change0
azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Transaction Audit (UPR10303)

Leave a Reply

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