Payroll Distribution History Header (UPR30400)

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

Display Name: Payroll Distribution History Header
Physical Name: UPR30400
Technical Name: UPR_Distribution_HIST_HDR

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	AUCTRLCD	Audit Control Code	String	STR13_LBAU	13
2	POSTEDDT	Posted Date	Date	DATE	6
3	USWHPSTD	User Who Posted	String	User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Payroll Distribution History Header'].USWHPSTD AS 'Payroll Distribution History Header-User Who Posted' ,['Users Master'].USERID AS 'Users Master-User ID' FROM UPR30400 AS ['Payroll Distribution History Header'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Payroll Distribution History Header'].USWHPSTD = ['Users Master'].USERID
4	HISTRMVD	History Removed	Boolean	True/False	0
5	BACHNUMB	Batch Number	String	STR15_LBAU	15
6	NUMOFTRX	Number Of TRX	Long Integer	LI6_U0	6
7	NUMOFEMP	Number of Employees	Integer	INT5_U0	5
8	CNTRLTRX	Control TRX Count	Long Integer	LI6_U0	6
9	CTRLEMPCT	Control Employee Count	Integer	INT5_S0	5
10	APPROVL	Approval	Boolean	CB_Approval	0
11	APRVLUSERID	Approval User ID	String	STR15_User_ID	15
	The key to the Users Master (SY01400). Click to show/hide SELECT ['Payroll Distribution History Header'].APRVLUSERID AS 'Payroll Distribution History Header-Approval User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM UPR30400 AS ['Payroll Distribution History Header'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Payroll Distribution History Header'].APRVLUSERID = ['Users Master'].USERID
12	APPRVLDT	Approval Date	Date	DATE	6