Payroll Transactions (UPR10302)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Transactions
Physical Name: UPR10302
Technical Name: UPR_TRX_Batch_Detail

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1COMPTRNM SearchComputer TRX NumberLong IntegerLI8_U08
2BACHNUMB SearchBatch NumberStringSTR15_LBAU15
3EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
4COMPTRTP SearchComputer TRX TypeIntegerDDL_TRX_Type0
5SALCHG SearchSalary ChangeIntegerDDL_Salary_Change0
6UPRTRXCD SearchUPR TRX CodeStringSTR6_Payroll_Code6
7TRXBEGDT SearchTRX Beginning DateDateDT8
8TRXENDDT SearchTRX Ending DateDateDT8
9TRXHRUNT SearchTRX Hours/UnitsLong IntegerLI6_S26
10HRLYPYRT SearchHourly Pay RateCurrencyDLR11_$U214
11PAYRTAMT SearchPay Rate AmountCurrencyDLR11_$S214
12VARDBAMT SearchVariable Ded/Ben AmountCurrencyDLR11_$S214
13VARDBPCT SearchVariable Ded/Ben PercentLong IntegerLI8_S5%8
14RECEIPTS SearchReceiptsCurrencyDLR11_$S214
15DAYSWRDK SearchDays WorkedLong IntegerLI6_S26
16WKSWRKD SearchWeeks WorkedLong IntegerLI6_S26
17DEPRTMNT SearchDepartmentStringSTR6_Payroll_Code6
18JOBTITLE SearchJob TitleStringSTR6_Payroll_Code6
19STATECD SearchState CodeStringSTR2_State_Code2
20LOCALTAX SearchLocal TaxStringSTR6_Payroll_Code6
21SUTASTAT SearchSuta StateStringSTR2_State_Code2
22WRKRCOMP SearchWorkers CompStringSTR6_Payroll_Code6
23LASTUSER SearchLast UserStringUser_ID15
The key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Payroll Transactions'].LASTUSER AS 'Payroll Transactions-Last User'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       UPR10302 AS ['Payroll Transactions']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Payroll Transactions'].LASTUSER = ['Users Master'].USERID
24LSTDTEDT SearchLast Date EditedDateDT_Date6
25TRXSORCE SearchTRX SourceStringSTR1313
26DOCTYPE SearchDocument TypeIntegerDDL_Document_Type0
27VOIDED SearchVoidedBooleanCB0
28NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Payroll Transactions'].NOTEINDX AS 'Payroll Transactions-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       UPR10302 AS ['Payroll Transactions']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Payroll Transactions'].NOTEINDX = ['Record Notes Master'].NOTEINDX
29INADDNTOSAL SearchIn Addition To SalaryBooleanCB_In_Addition_To_Salary0
30SHFTCODE SearchShift CodeStringSTR6_Payroll_Code6
31SHFTPREM SearchShift PremiumCurrencyDLR11_$S214
32JOBNUMBR SearchJob NumberStringSTR17_LBAU17
33UNIONCD SearchUnion CodeStringSTR66

Leave a Reply

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