Payroll Check History (UPR30100)

azurecurve Products Microsoft Dynamics GP (0)PayrollPayroll Check History (UPR30100)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Check History
Physical Name: UPR30100
Technical Name: UPR_Check_HIST

Group Display Name: Payroll Check History
Group Technical Name: Payroll Check History

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	AUCTRLCD	Audit Control Code	String	STR13_LBAU	13
2	CHEKNMBR	Check Number	String	STR20_Document_Number	20
3	PYADNMBR	Payment/Adjustment Number	Long Integer	LI8_U0	8
4	VOIDED	Voided	Boolean	CB	0
5	CHEKDATE	Check Date	Date	DATE	6
6	POSTEDDT	Posted Date	Date	DATE	6
7	EMPLOYID	Employee ID	String	STR15_Employee_ID	15
8	EMPLNAME	Employee Name	String	STR40	40
9	GRWGPRN	Gross Wages/Pay Run	Currency	DLR11_$S2	14
10	FDWDGPRN	Federal Withholding/Pay Run	Currency	DLR11_$S2	14
11	FDTXTIPS	Federal Tax on Tips	Currency	DLR11_$S2	14
12	FICAMWPR	FICA/Medicare Withholding/Pay Run	Currency	DLR11_$S2	14
13	FICMTPTX	FICA/Med Tax on Tips	Currency	DLR11_$S2	14
14	Uncollected_FICAMed_TaxP	Uncollected FICA/Med Tax/Pay Run	Currency	DLR11_$S2	14
15	FCASWPR	FICA/Social Security Withholding/Pay Run	Currency	DLR11_$S2	14
16	FICSTPTX	FICA/SS Tax on Tips	Currency	DLR11_$S2	14
17	Uncollected_FICASS_TaxP	Uncollected FICA/SS Tax/Pay Run	Currency	DLR11_$S2	14
18	ADEICPMT	Advance EIC Payment	Currency	DLR11_RU2NC_Year_End	14
19	Reported_Tips	Reported Tips	Currency	DLR11_$S2	14
20	Charged_Tips	Charged Tips	Currency	DLR11_$S2	14
21	ALOCTIPS	Allocated Tips	Currency	DLR11_RU2NC_Year_End	14
22	TTLDDTNS	Total Deductions	Currency	DLR11_$S2	14
23	TTLBNFTS	Total Benefits	Currency	DLR11_$S2	14
24	NTWPYRN	Net Wages/Pay Run	Currency	DLR11_$S2	14
25	CHEKBKID	Checkbook ID	String	STR15_Checkbook_ID	15
	Key to the CM Checkbook Master (CM00100). Click to show/hide SELECT ['Payroll Check History'].CHEKBKID AS 'Payroll Check History-Checkbook ID' ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID' FROM UPR30100 AS ['Payroll Check History'] INNER JOIN CM00100 AS ['CM Checkbook Master'] ON ['Payroll Check History'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
26	DEPRTMNT	Department	String	STR6_Payroll_Code	6
27	SOCSCNUM	Social Security Number	String	STR15_Social_Security_Number	15
28	VACTMACC	Vacation Time Accrued	Currency	DLR6_S2	6
29	VACTMLBL	Vacation Time Liability	Currency	DLR11_$S2	14
30	VACAVLBL	Vacation Available	Long Integer	LI6_S2	6
31	SKTMACCR	Sick Time Accrued	Currency	DLR6_S2	6
32	SKTMLBTY	Sick Time Liability	Currency	DLR11_$S2	14
33	SIKTIMAV	Sick Time Available	Long Integer	LI6_S2	6
34	TOTLTAXS	Total Taxes	Currency	DLR11_$S2	14
35	Voided_by_Void_Checks	Voided by Void Checks	Boolean	CB	0
36	FDWGPYRN	Federal Wages/Pay Run	Currency	DLR11_$S2	14
37	Federal_TipsPay_Run	Federal Tips/Pay Run	Currency	DLR11_$S2	14
38	FICASSWP	FICA/Social Security Wages/Pay Run	Currency	DLR11_$S2	14
39	FICASS_TipsPay_Run	FICA/SS Tips/Pay Run	Currency	DLR11_$S2	14
40	FICAMWGP	FICA/Medicare Wages/Pay Run	Currency	DLR11_$S2	14
41	FICAMed_TipsPay_Run	FICA/Med Tips/Pay Run	Currency	DLR11_$S2	14
42	Reported_Receipts	Reported Receipts	Currency	DLR11_$S2	14
43	Charged_Receipts	Charged Receipts	Currency	DLR11_$S2	14
44	YEAR1	Year	Integer	Year	4
45	ISCHECK	IsCheck	Boolean	CB	0
46	RSNCHKVD	Reason Check Voided	String	STR30	30
47	COMPPYRN	Computer Pay Run Type	Integer	GB	0
48	EFICASSWH	Employer FICA/Social Security Withholding	Currency	DLR11_$S2	14
49	EFICASS_Tax_On_Tips	Employer FICA/SS Tax On Tips	Currency	DLR11_$S2	14
50	EFICAMWPR	Employer FICA/Medicare Withholding	Currency	DLR11_$S2	14
51	EFICAMed_Tax_On_Tips	Employer FICA/Med Tax On Tips	Currency	DLR11_$S2	14
52	PayPeriodBeginDate	Pay Period Begin Date	Date	DT	8
53	PayPeriodEndDate	Pay Period End Date	Date	DT	8

azurecurve Products Microsoft Dynamics GP (0)PayrollPayroll Check History (UPR30100)

Click to show/hide

Leave a Reply Cancel reply