Payroll Work Header (UPR10202)

azurecurve Products Microsoft Dynamics GP (0)PayrollPayroll Work Header (UPR10202)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Work Header
Physical Name: UPR10202
Technical Name: UPR_WORK_HDR

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 Header'].USERID AS 'Payroll Work Header-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM UPR10202 AS ['Payroll Work Header'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Payroll Work Header'].USERID = ['Users Master'].USERID
2	PYRNTYPE	Pay Run Type	Integer	GB	0
3	EMPLOYID	Employee ID	String	STR15_Employee_ID	15
4	POSTED	Posted	Boolean	True/False	0
5	PYSTLTEX	Pay Subject To Local Tax Exists	Boolean	CB	0
6	CHEKNMBR	Check Number	String	STR20_Document_Number	20
7	CHEKDATE	Check Date	Date	DATE	6
8	CHEKBKID	Checkbook ID	String	STR15_Checkbook_ID	15
	Key to the CM Checkbook Master (CM00100). Click to show/hide SELECT ['Payroll Work Header'].CHEKBKID AS 'Payroll Work Header-Checkbook ID' ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID' FROM UPR10202 AS ['Payroll Work Header'] INNER JOIN CM00100 AS ['CM Checkbook Master'] ON ['Payroll Work Header'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
9	PYADNMBR	Payment/Adjustment Number	Long Integer	LI8_U0	8
10	ACTINDX	Account Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Payroll Work Header'].ACTINDX AS 'Payroll Work Header-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM UPR10202 AS ['Payroll Work Header'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Payroll Work Header'].ACTINDX = ['Account Index Master'].ACTINDX
11	ADFDWHDG	Additional Federal Withholding	Currency	DLR11_$S2	14
12	ESTFEDWH	Estimated Federal Withholding	Currency	DLR11_$U2	14
13	HWKVCACR	Hours Worked For Vacation Accrual	Currency	DLR6_S2	6
14	HWKSKACR	Hours Worked For Sick Accrual	Currency	DLR6_S2	6
15	VACTMACC	Vacation Time Accrued	Currency	DLR6_S2	6
16	SKTMACCR	Sick Time Accrued	Currency	DLR6_S2	6
17	VACTMLBL	Vacation Time Liability	Currency	DLR11_$S2	14
18	SKTMLBTY	Sick Time Liability	Currency	DLR11_$S2	14
19	VACAVLBL	Vacation Available	Long Integer	LI6_S2	6
20	SIKTIMAV	Sick Time Available	Long Integer	LI6_S2	6
21	GRWGPRN	Gross Wages/Pay Run	Currency	DLR11_$S2	14
22	NTWPYRN	Net Wages/Pay Run	Currency	DLR11_$S2	14
23	FEDWGARR	Federal Wage Array	DLR11	Currency	14
24	FEDWGARR_1	Federal Wage Array[1]	Currency	DLR11	14
25	FEDWGARR_2	Federal Wage Array[2]	Currency	DLR11	14
26	FEDWGARR_3	Federal Wage Array[3]	Currency	DLR11	14
27	FEDWGARR_4	Federal Wage Array[4]	Currency	DLR11	14
28	FEDWGARR_5	Federal Wage Array[5]	Currency	DLR11	14
29	FEDWGARR_6	Federal Wage Array[6]	Currency	DLR11	14
30	FEDWGARR_7	Federal Wage Array[7]	Currency	DLR11	14
31	FEDWGARR_8	Federal Wage Array[8]	Currency	DLR11	14
32	Federal_Tips_Array_1	Federal Tips Array[1]	Currency	DLR11_$S2	14
33	Federal_Tips_Array_2	Federal Tips Array[2]	Currency	DLR11_$S2	14
34	Federal_Tips_Array	Federal Tips Array	DLR11_$S2	Currency	14
35	Federal_Tips_Array_3	Federal Tips Array[3]	Currency	DLR11_$S2	14
36	Federal_Tips_Array_4	Federal Tips Array[4]	Currency	DLR11_$S2	14
37	Federal_Tips_Array_5	Federal Tips Array[5]	Currency	DLR11_$S2	14
38	Federal_Tips_Array_6	Federal Tips Array[6]	Currency	DLR11_$S2	14
39	Federal_Tips_Array_7	Federal Tips Array[7]	Currency	DLR11_$S2	14
40	Federal_Tips_Array_8	Federal Tips Array[8]	Currency	DLR11_$S2	14
41	FDWGPYRN	Federal Wages/Pay Run	Currency	DLR11_$S2	14
42	Federal_TipsPay_Run	Federal Tips/Pay Run	Currency	DLR11_$S2	14
43	ANFDWHDG	Annualized Federal Withholding	Currency	DLR11_$S2	14
44	FDWDGPRN	Federal Withholding/Pay Run	Currency	DLR11_$S2	14
45	FDTXTIPS	Federal Tax on Tips	Currency	DLR11_$S2	14
46	FICASSWP	FICA/Social Security Wages/Pay Run	Currency	DLR11_$S2	14
47	FICASS_TipsPay_Run	FICA/SS Tips/Pay Run	Currency	DLR11_$S2	14
48	FCASWPR	FICA/Social Security Withholding/Pay Run	Currency	DLR11_$S2	14
49	FICSTPTX	FICA/SS Tax on Tips	Currency	DLR11_$S2	14
50	Uncollected_FICASS_TaxP	Uncollected FICA/SS Tax/Pay Run	Currency	DLR11_$S2	14
51	FICAMWGP	FICA/Medicare Wages/Pay Run	Currency	DLR11_$S2	14
52	FICAMed_TipsPay_Run	FICA/Med Tips/Pay Run	Currency	DLR11_$S2	14
53	FICAMWPR	FICA/Medicare Withholding/Pay Run	Currency	DLR11_$S2	14
54	FICMTPTX	FICA/Med Tax on Tips	Currency	DLR11_$S2	14
55	Uncollected_FICAMed_TaxP	Uncollected FICA/Med Tax/Pay Run	Currency	DLR11_$S2	14
56	EICWPYRN	EIC Wages/Pay Run	Currency	DLR11_$S2	14
57	EPFICASS	Employer FICA/Social Security	Currency	DLR11_$S2	14
58	EFICAMCR	Employer FICA/Medicare	Currency	DLR11_$S2	14
59	Charged_Receipts	Charged Receipts	Currency	DLR11_$S2	14
60	Reported_Receipts	Reported Receipts	Currency	DLR11_$S2	14
61	Hours_Worked_For_Minimum	Hours Worked For Minimum Wage	Currency	DLR11_$S2	14
62	Min_Wage_Bal_Applicable	Min Wage Bal Applicable Pay	Currency	DLR11_$S2	14
63	Reported_Tips	Reported Tips	Currency	DLR11_$S2	14
64	Charged_Tips	Charged Tips	Currency	DLR11_$S2	14
65	ALOCTIPS	Allocated Tips	Currency	DLR11_RU2NC_Year_End	14
66	TipType	Tip Type	Integer	DDL_Type_of_Tips	0
67	POSTEDDT	Posted Date	Date	DATE	6
68	GRWGFREIC	Gross Wages For EIC	Currency	DLR11_$S2	14
69	CALCCHKERRS	Calc Check Errors	Long Integer	ML_Calc_Check_Errors	0
70	EFICASSWH	Employer FICA/Social Security Withholding	Currency	DLR11_$S2	14
71	EFICASS_Tax_On_Tips	Employer FICA/SS Tax On Tips	Currency	DLR11_$S2	14
72	EFICAMWPR	Employer FICA/Medicare Withholding	Currency	DLR11_$S2	14
73	EFICAMed_Tax_On_Tips	Employer FICA/Med Tax On Tips	Currency	DLR11_$S2	14
74	PayPeriodBeginDate	Pay Period Begin Date	Date	DT	8
75	PayPeriodEndDate	Pay Period End Date	Date	DT	8

azurecurve Products Microsoft Dynamics GP (0)PayrollPayroll Work Header (UPR10202)

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply