Payroll Work Pay Code (UPR10203)

azurecurve Products Microsoft Dynamics GP (0)PayrollPayroll 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	Length
1	USERID	User ID	String	STR15_User_ID	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	Integer	GB	0
3	EMPLOYID	Employee ID	String	STR15_Employee_ID	15
4	TRXNUMBER	TRX Number	Long Integer	LI8_U0	8
5	PAYRCORD	Pay Record	String	STR6_Payroll_Code	6
6	PRCSSQNC	Process Sequence	Integer	INT	0
7	PAYTYPE	Pay Type	Integer	DDL_Pay_Types	0
8	BSPAYRCD	Base Pay Record	String	STR6_Payroll_Code	6
9	BSPAYTYP	Base Pay Type	Integer	DDL_Pay_Types	0
10	BSDONRTE	Based On Rate	Currency	DLR11_$S2	14
11	PAYRTAMT	Pay Rate Amount	Currency	DLR11_$S2	14
12	PAYUNIT	Pay Unit	String	STR25	25
13	PAYUNPER	Pay Unit Period	Integer	DDL_Pay_Periods	0
14	PAYPEROD	Pay Period	Integer	DDL_Pay_Periods	0
15	PAYPRPRD	Pay Per Period	Currency	DLR11_$S2	14
16	PAYADVNC	Pay Advance	Currency	DLR11_$U2	14
17	TIMETYPE_I	Time Type	Integer	DDL_Time_Types	0
18	TIMEAVAILABLE	Time Available	Currency	DLR11_S2	11
19	ACRUVACN	Accrue Vacation	Boolean	CB_Vacation	0
20	ACRUSTIM	Accrue Sick Time	Boolean	CB_Sick_Time	0
21	RPTASWGS	Report As Wages	Boolean	CB_Report_As_Wages	0
22	DAYSWRDK	Days Worked	Long Integer	LI6_S2	6
23	WKSWRKD	Weeks Worked	Long Integer	LI6_S2	6
24	RECEIPTS	Receipts	Currency	DLR11_$S2	14
25	TipType	Tip Type	Integer	DDL_Type_of_Tips	0
26	DEPRTMNT	Department	String	STR6_Payroll_Code	6
27	JOBTITLE	Job Title	String	STR6_Payroll_Code	6
28	STATECD	State Code	String	STR2_State_Code	2
29	LOCALTAX	Local Tax	String	STR6_Payroll_Code	6
30	SUTASTAT	Suta State	String	STR2_State_Code	2
31	WRKRCOMP	Workers Comp	String	STR6_Payroll_Code	6
32	UNTSTOPY	Units To Pay	Currency	DLR11_S2	11
33	ADJUNITS	Adjusted Units	Currency	DLR11_$S2	14
34	TOTALPAY	Total Pay	Currency	DLR11_$S2	14
35	BCHSOURC	Batch Source	String	STR15	15
36	PRTRXSRC	Payroll TRX Source	Long Integer	LI8_U0	8
37	LASTUSER	Last User	String	User_ID	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	Date	DT_Date	6
39	TRXBEGDT	TRX Beginning Date	Date	DT	8
40	TRXENDDT	TRX Ending Date	Date	DT	8
41	BLDCHWRG	Build Check Warnings	Long Integer	ML_Build_Check_Warnings	0
42	BLDCHERR	Build Check Errors	Long Integer	ML_Build_Check_Errors	0
43	SHFTCODE	Shift Code	String	STR6_Payroll_Code	6
44	SHFTPREM	Shift Premium	Currency	DLR11_$S2	14

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

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply