Payroll Work Pay Code (UPR10203)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Work Pay Code
Physical Name: UPR10203
Technical Name: UPR_WORK_Pay_Type

Group Display Name: Payroll Check Work
Group Technical Name: Payroll Check Work

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	USERID	User ID	STR15_User_ID	String	16	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Payroll Work Pay Code'].USERID AS 'Payroll Work Pay Code-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM UPR10203 AS ['Payroll Work Pay Code'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Payroll Work Pay Code'].USERID = ['Users Master'].USERID
2	PYRNTYPE	Pay Run Type	GB	Integer	2	0
3	EMPLOYID	Employee ID	STR15_Employee_ID	String	16	15
4	TRXNUMBER	TRX Number	LI8_U0	Long Integer	4	8
5	PAYRCORD	Pay Record	STR6_Payroll_Code	String	8	6
6	PRCSSQNC	Process Sequence	INT	Integer	2	0
7	PAYTYPE	Pay Type	DDL_Pay_Types	Integer	2	0
8	BSPAYRCD	Base Pay Record	STR6_Payroll_Code	String	8	6
9	BSPAYTYP	Base Pay Type	DDL_Pay_Types	Integer	2	0
10	BSDONRTE	Based On Rate	DLR11_$S2	Currency	10	14
11	PAYRTAMT	Pay Rate Amount	DLR11_$S2	Currency	10	14
12	PAYUNIT	Pay Unit	STR25	String	26	25
13	PAYUNPER	Pay Unit Period	DDL_Pay_Periods	Integer	2	0
14	PAYPEROD	Pay Period	DDL_Pay_Periods	Integer	2	0
15	PAYPRPRD	Pay Per Period	DLR11_$S2	Currency	10	14
16	PAYADVNC	Pay Advance	DLR11_$U2	Currency	10	14
17	TIMETYPE_I	Time Type	DDL_Time_Types	Integer	2	0
18	TIMEAVAILABLE	Time Available	DLR11_S2	Currency	10	11
19	ACRUVACN	Accrue Vacation	CB_Vacation	Boolean	2	0
20	ACRUSTIM	Accrue Sick Time	CB_Sick_Time	Boolean	2	0
21	RPTASWGS	Report As Wages	CB_Report_As_Wages	Boolean	2	0
22	DAYSWRDK	Days Worked	LI6_S2	Long Integer	4	6
23	WKSWRKD	Weeks Worked	LI6_S2	Long Integer	4	6
24	RECEIPTS	Receipts	DLR11_$S2	Currency	10	14
25	TipType	Tip Type	DDL_Type_of_Tips	Integer	2	0
26	DEPRTMNT	Department	STR6_Payroll_Code	String	8	6
27	JOBTITLE	Job Title	STR6_Payroll_Code	String	8	6
28	STATECD	State Code	STR2_State_Code	String	4	2
29	LOCALTAX	Local Tax	STR6_Payroll_Code	String	8	6
30	SUTASTAT	Suta State	STR2_State_Code	String	4	2
31	WRKRCOMP	Workers Comp	STR6_Payroll_Code	String	8	6
32	UNTSTOPY	Units To Pay	DLR11_S2	Currency	10	11
33	ADJUNITS	Adjusted Units	DLR11_$S2	Currency	10	14
34	TOTALPAY	Total Pay	DLR11_$S2	Currency	10	14
35	BCHSOURC	Batch Source	STR15	String	16	15
36	PRTRXSRC	Payroll TRX Source	LI8_U0	Long Integer	4	8
37	LASTUSER	Last User	User_ID	String	16	15
	The key to the Users Master (SY01400). Click to show/hide SELECT ['Payroll Work Pay Code'].LASTUSER AS 'Payroll Work Pay Code-Last User' ,['Users Master'].USERID AS 'Users Master-User ID' FROM UPR10203 AS ['Payroll Work Pay Code'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Payroll Work Pay Code'].LASTUSER = ['Users Master'].USERID
38	LSTDTEDT	Last Date Edited	DT_Date	Date	4	6
39	TRXBEGDT	TRX Beginning Date	DT	Date	4	8
40	TRXENDDT	TRX Ending Date	DT	Date	4	8
41	BLDCHWRG	Build Check Warnings	ML_Build_Check_Warnings	Long Integer	4	0
42	BLDCHERR	Build Check Errors	ML_Build_Check_Errors	Long Integer	4	0
43	SHFTCODE	Shift Code	STR6_Payroll_Code	String	8	6
44	SHFTPREM	Shift Premium	DLR11_$S2	Currency	10	14
45	DEX_ROW_ID		int	int	10	10
	DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurve Products Microsoft Dynamics GP (0)PayrollPayroll Work Pay Code (UPR10203)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply