Payroll Distribution Work (UPR10400)

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

Display Name: Payroll Distribution Work
Physical Name: UPR10400
Technical Name: UPR_Distribution_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 Distribution Work'].USERID AS 'Payroll Distribution Work-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM UPR10400 AS ['Payroll Distribution Work'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Payroll Distribution Work'].USERID = ['Users Master'].USERID
2	SRCECODE	Source Code	String	STR6	6
3	FUTASUTA	Futa/Suta	String	STR3_Futa/Suta	3
4	DEPRTMNT	Department	String	STR6_Payroll_Code	6
5	JOBTITLE	Job Title	String	STR6_Payroll_Code	6
6	PAYROLCD	Payroll Code	String	STR6_Payroll_Code	6
7	UPRACTYP	UPR Account Type	Integer	DDL_UPR_Account_Type	0
8	ACTINDX	Account Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Payroll Distribution Work'].ACTINDX AS 'Payroll Distribution Work-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM UPR10400 AS ['Payroll Distribution Work'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Payroll Distribution Work'].ACTINDX = ['Account Index Master'].ACTINDX
9	AMNTOPST	Amount To Post	Currency	DLR11_$S2	14