Payroll Accounts Setup (UPR40500)

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

Display Name: Payroll Accounts Setup
Physical Name: UPR40500
Technical Name: UPR_SETP_Account

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	DEPRTMNT	Department	String	STR6_Payroll_Code	6
2	JOBTITLE	Job Title	String	STR6_Payroll_Code	6
3	PAYROLCD	Payroll Code	String	STR6_Payroll_Code	6
4	UPRACTYP	UPR Account Type	Integer	DDL_UPR_Account_Type	0
5	ACTINDX	Account Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Payroll Accounts Setup'].ACTINDX AS 'Payroll Accounts Setup-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM UPR40500 AS ['Payroll Accounts Setup'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Payroll Accounts Setup'].ACTINDX = ['Account Index Master'].ACTINDX