Payroll Transactions (UPR10302)

azurecurve Products Microsoft Dynamics GP (0)PayrollPayroll 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 No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	COMPTRNM	Computer TRX Number	Long Integer	LI8_U0	8
2	BACHNUMB	Batch Number	String	STR15_LBAU	15
3	EMPLOYID	Employee ID	String	STR15_Employee_ID	15
4	COMPTRTP	Computer TRX Type	Integer	DDL_TRX_Type	0
5	SALCHG	Salary Change	Integer	DDL_Salary_Change	0
6	UPRTRXCD	UPR TRX Code	String	STR6_Payroll_Code	6
7	TRXBEGDT	TRX Beginning Date	Date	DT	8
8	TRXENDDT	TRX Ending Date	Date	DT	8
9	TRXHRUNT	TRX Hours/Units	Long Integer	LI6_S2	6
10	HRLYPYRT	Hourly Pay Rate	Currency	DLR11_$U2	14
11	PAYRTAMT	Pay Rate Amount	Currency	DLR11_$S2	14
12	VARDBAMT	Variable Ded/Ben Amount	Currency	DLR11_$S2	14
13	VARDBPCT	Variable Ded/Ben Percent	Long Integer	LI8_S5%	8
14	RECEIPTS	Receipts	Currency	DLR11_$S2	14
15	DAYSWRDK	Days Worked	Long Integer	LI6_S2	6
16	WKSWRKD	Weeks Worked	Long Integer	LI6_S2	6
17	DEPRTMNT	Department	String	STR6_Payroll_Code	6
18	JOBTITLE	Job Title	String	STR6_Payroll_Code	6
19	STATECD	State Code	String	STR2_State_Code	2
20	LOCALTAX	Local Tax	String	STR6_Payroll_Code	6
21	SUTASTAT	Suta State	String	STR2_State_Code	2
22	WRKRCOMP	Workers Comp	String	STR6_Payroll_Code	6
23	LASTUSER	Last User	String	User_ID	15
	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
24	LSTDTEDT	Last Date Edited	Date	DT_Date	6
25	TRXSORCE	TRX Source	String	STR13	13
26	DOCTYPE	Document Type	Integer	DDL_Document_Type	0
27	VOIDED	Voided	Boolean	CB	0
28	NOTEINDX	Note Index	Currency	DLR14	14
	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
29	INADDNTOSAL	In Addition To Salary	Boolean	CB_In_Addition_To_Salary	0
30	SHFTCODE	Shift Code	String	STR6_Payroll_Code	6
31	SHFTPREM	Shift Premium	Currency	DLR11_$S2	14
32	JOBNUMBR	Job Number	String	STR17_LBAU	17
33	UNIONCD	Union Code	String	STR6	6

azurecurve Products Microsoft Dynamics GP (0)PayrollPayroll Transactions (UPR10302)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply