Payroll Transaction History (UPR30300)

azurecurve Products Microsoft Dynamics GP (0)PayrollPayroll Transaction History (UPR30300)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Transaction History
Physical Name: UPR30300
Technical Name: UPR_Transaction_HIST

Group Display Name: Payroll Transaction History
Group Technical Name: Payroll Transaction History

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CMRECNUM	Record Number	Currency	DLR_Document_Number	19
2	AUCTRLCD	Audit Control Code	String	STR13_LBAU	13
3	EMPLOYID	Employee ID	String	STR15_Employee_ID	15
4	CHEKNMBR	Check Number	String	STR20_Document_Number	20
5	PYADNMBR	Payment/Adjustment Number	Long Integer	LI8_U0	8
6	TRXNUMBER	TRX Number	Long Integer	LI8_U0	8
7	YEAR1	Year	Integer	Year	4
8	CHEKDATE	Check Date	Date	DATE	6
9	DEPRTMNT	Department	String	STR6_Payroll_Code	6
10	PYRLRTYP	Payroll Record Type	Integer	DDL_Payroll_Record_Type	0
11	PAYROLCD	Payroll Code	String	STR6_Payroll_Code	6
12	TRXSORCE	TRX Source	String	STR13	13
13	DOCTYPE	Document Type	Integer	DDL_Document_Type	0
14	JOBTITLE	Job Title	String	STR6_Payroll_Code	6
15	TRXBEGDT	TRX Beginning Date	Date	DT	8
16	TRXENDDT	TRX Ending Date	Date	DT	8
17	UNTSTOPY	Units To Pay	Currency	DLR11_S2	11
18	PAYRATE	Pay Rate	Currency	DLR11_$S2	14
19	UPRTRXAM	UPR TRX Amount	Currency	DLR11_$S2	14
20	TIMETYPE_I	Time Type	Integer	DDL_Time_Types	0
21	TIMEAVAILABLE	Time Available	Currency	DLR11_S2	11
22	TipType	Tip Type	Integer	DDL_Type_of_Tips	0
23	RECEIPTS	Receipts	Currency	DLR11_$S2	14
24	PAYADVNC	Pay Advance	Currency	DLR11_$U2	14
25	STATECD	State Code	String	STR2_State_Code	2
26	LOCALTAX	Local Tax	String	STR6_Payroll_Code	6
27	WRKRCOMP	Workers Comp	String	STR6_Payroll_Code	6
28	USWHPSTD	User Who Posted	String	User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Payroll Transaction History'].USWHPSTD AS 'Payroll Transaction History-User Who Posted' ,['Users Master'].USERID AS 'Users Master-User ID' FROM UPR30300 AS ['Payroll Transaction History'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Payroll Transaction History'].USWHPSTD = ['Users Master'].USERID
29	LSTDTEDT	Last Date Edited	Date	DT_Date	6
30	LASTUSER	Last User	String	User_ID	15
	The key to the Users Master (SY01400). Click to show/hide SELECT ['Payroll Transaction History'].LASTUSER AS 'Payroll Transaction History-Last User' ,['Users Master'].USERID AS 'Users Master-User ID' FROM UPR30300 AS ['Payroll Transaction History'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Payroll Transaction History'].LASTUSER = ['Users Master'].USERID
31	SHFTCODE	Shift Code	String	STR6_Payroll_Code	6
32	SHFTPREM	Shift Premium	Currency	DLR11_$S2	14
33	TXBLWAGS	Taxable Wages	Currency	DLR11_$S2	14
34	DAYSWRDK	Days Worked	Long Integer	LI6_S2	6
35	WKSWRKD	Weeks Worked	Long Integer	LI6_S2	6
36	SUTASTAT	Suta State	String	STR2_State_Code	2
37	SBJTFUTA	Subject To Futa	Boolean	CB_Futa	0
38	BSDONRTE	Based On Rate	Currency	DLR11_$S2	14
39	EMPLCLAS	Employee Class	String	STR15_Employee_Class	15

azurecurve Products Microsoft Dynamics GP (0)PayrollPayroll Transaction History (UPR30300)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply