Payroll Transaction Audit (UPR10303)

azurecurve Products Microsoft 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 No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	USERID	User ID	String	STR15_User_ID	15
	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
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	UPRTRXCD	UPR TRX Code	String	STR6_Payroll_Code	6
6	TRXAUFLG	TRX Audit Flag	True/False	Boolean	0
7	TRXAUFLG_1	TRX Audit Flag[1]	Boolean	True/False	0
8	TRXAUFLG_2	TRX Audit Flag[2]	Boolean	True/False	0
9	TRXAUFLG_3	TRX Audit Flag[3]	Boolean	True/False	0
10	TRXAUFLG_4	TRX Audit Flag[4]	Boolean	True/False	0
11	TRXAUFLG_5	TRX Audit Flag[5]	Boolean	True/False	0
12	TRXAUFLG_6	TRX Audit Flag[6]	Boolean	True/False	0
13	TRXAUFLG_7	TRX Audit Flag[7]	Boolean	True/False	0
14	TRXAUFLG_8	TRX Audit Flag[8]	Boolean	True/False	0
15	TRXAUFLG_9	TRX Audit Flag[9]	Boolean	True/False	0
16	TRXAUFLG_10	TRX Audit Flag[10]	Boolean	True/False	0
17	TRXBEGDT	TRX Beginning Date	Date	DT	8
18	TRXENDDT	TRX Ending Date	Date	DT	8
19	TRXHRUNT	TRX Hours/Units	Long Integer	LI6_S2	6
20	PAYRTAMT	Pay Rate Amount	Currency	DLR11_$S2	14
21	HRLYPYRT	Hourly Pay Rate	Currency	DLR11_$U2	14
22	VARDBAMT	Variable Ded/Ben Amount	Currency	DLR11_$S2	14
23	VARDBPCT	Variable Ded/Ben Percent	Long Integer	LI8_S5%	8
24	DEPRTMNT	Department	String	STR6_Payroll_Code	6
25	JOBTITLE	Job Title	String	STR6_Payroll_Code	6
26	STATECD	State Code	String	STR2_State_Code	2
27	LOCALTAX	Local Tax	String	STR6_Payroll_Code	6
28	WRKRCOMP	Workers Comp	String	STR6_Payroll_Code	6
29	DAYSWRDK	Days Worked	Long Integer	LI6_S2	6
30	SUTASTAT	Suta State	String	STR2_State_Code	2
31	WKSWRKD	Weeks Worked	Long Integer	LI6_S2	6
32	SHFTPREM	Shift Premium	Currency	DLR11_$S2	14
33	SALCHG	Salary Change	Integer	DDL_Salary_Change	0

azurecurve Products Microsoft Dynamics GP (0)PayrollPayroll Transaction Audit (UPR10303)

Click to show/hide

Leave a Reply Cancel reply