Payroll Work Post (UPR10209)

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

Display Name: Payroll Work Post
Physical Name: UPR10209
Technical Name: UPR_WORK_Post

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 Post'].USERID AS 'Payroll Work Post-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM UPR10209 AS ['Payroll Work Post'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Payroll Work Post'].USERID = ['Users Master'].USERID
2	EMPLOYID	Employee ID	String	STR15_Employee_ID	15
3	PYRNTYPE	Pay Run Type	Integer	GB	0
4	PYRLRTYP	Payroll Record Type	Integer	DDL_Payroll_Record_Type	0
5	TRXNUMBER	TRX Number	Long Integer	LI8_U0	8
6	SEQNUMBR	Sequence Number	Long Integer	LI_Sequence_Number	10
7	ACTINDX	Account Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Payroll Work Post'].ACTINDX AS 'Payroll Work Post-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM UPR10209 AS ['Payroll Work Post'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Payroll Work Post'].ACTINDX = ['Account Index Master'].ACTINDX
8	AMNTOPST	Amount To Post	Currency	DLR11_$S2	14
9	CHEKNMBR	Check Number	String	STR20_Document_Number	20
10	POSTEDDT	Posted Date	Date	DATE	6
11	DEPRTMNT	Department	String	STR6_Payroll_Code	6
12	JOBTITLE	Job Title	String	STR6_Payroll_Code	6
13	PAYROLCD	Payroll Code	String	STR6_Payroll_Code	6
14	UPRACTYP	UPR Account Type	Integer	DDL_UPR_Account_Type	0
15	PYADNMBR	Payment/Adjustment Number	Long Integer	LI8_U0	8