APR Transaction Import WORK (APR10100)

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

Display Name: APR Transaction Import WORK
Physical Name: APR10100
Technical Name: APR_Trx_Import_WORK

Group Display Name: HRM Solution Series
Group Technical Name: APR

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	COMPTRNM	Computer TRX Number	Long Integer	LI8_U0	8
2	BACHNUMB	Batch Number	String	STR15_LBAU	15
3	EMPLOYID	Employee ID	String	STR15_Employee_ID	15
4	COMPTRTP	Computer TRX Type	Integer	DDL_TRX_Type	0
5	UPRTRXCD	UPR TRX Code	String	STR6_Payroll_Code	6
6	TRXBEGDT	TRX Beginning Date	Date	DT	8
7	TRXENDDT	TRX Ending Date	Date	DT	8
8	TRXHRUNT	TRX Hours/Units	Long Integer	LI6_S2	6
9	DAYSWRDK	Days Worked	Long Integer	LI6_S2	6
10	WKSWRKD	Weeks Worked	Long Integer	LI6_S2	6
11	INTERID	Intercompany ID	String	STR5_IC_ID	5
	Key to the Company Master (SY01500). Click to show/hide SELECT ['APR Transaction Import WORK'].INTERID AS 'APR Transaction Import WORK-Intercompany ID' ,['Company Master'].INTERID AS 'Company Master-Intercompany ID' FROM APR10100 AS ['APR Transaction Import WORK'] INNER JOIN DYNAMICS..SY01500 AS ['Company Master'] ON ['APR Transaction Import WORK'].INTERID = ['Company Master'].INTERID
12	DEPRTMNT	Department	String	STR6_Payroll_Code	6
13	JOBTITLE	Job Title	String	STR6_Payroll_Code	6
14	LOCATNID	Location ID	String	STR15_Location_ID	15
15	SHFTCODE	Shift Code	String	STR6_Payroll_Code	6
16	STATECD	State Code	String	STR2_State_Code	2
17	SUTASTAT	Suta State	String	STR2_State_Code	2
18	PAYRTAMT	Pay Rate Amount	Currency	DLR11_$S2	14
19	APR_Import_Group	APR Import Group	String	STR15_LBAU	15