DIA Payroll Work Deduction TEMP (APR_DIA10300)

azurecurve Products HRM Solution Series (1911)PayrollDIA Payroll Work Deduction TEMP (APR_DIA10300)

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

Product: HRM Solution Series (1911)
Series:

Display Name: DIA Payroll Work Deduction TEMP
Physical Name: APR_DIA10300
Technical Name: APR_DIA_TEMP_Work_Deduction

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

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	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['DIA Payroll Work Deduction TEMP'].USERID AS 'DIA Payroll Work Deduction TEMP-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM APR_DIA10300 AS ['DIA Payroll Work Deduction TEMP'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['DIA Payroll Work Deduction TEMP'].USERID = ['Users Master'].USERID
4	PYRNTYPE	Pay Run Type	Integer	GB	0
5	EMPLOYID	Employee ID	String	STR15_Employee_ID	15
6	TRXNUMBER	TRX Number	Long Integer	LI8_U0	8
7	DEDUCTON	Deduction	String	STR6_Payroll_Code	6
8	TXSHANTY	Tax Sheltered Annuity	Boolean	CB_Tax_Sheltered_Annuity	0
9	DEDNSQNC	Deduction Sequence	Integer	INT	0
10	VARDEDTN	Variable Deduction	Boolean	CB_Variable	0
11	VARDBAMT	Variable Ded/Ben Amount	Currency	DLR11_$S2	14
12	VARDBPCT	Variable Ded/Ben Percent	Long Integer	LI8_S5%	8
13	DEDNFREQ	Deduction Frequency	Integer	DDL_Ded/Ben Frequency	0
14	TTLDEDTN	Total Deduction	Currency	DLR11_$S2	14
15	BCHSOURC	Batch Source	String	STR15	15
16	PRTRXSRC	Payroll TRX Source	Long Integer	LI8_U0	8
17	LASTUSER	Last User	String	User_ID	15
18	LSTDTEDT	Last Date Edited	Date	DT_Date	6
19	TRXBEGDT	TRX Beginning Date	Date	DT	8
20	TRXENDDT	TRX Ending Date	Date	DT	8
21	BLDCHWRG	Build Check Warnings	Long Integer	ML_Build_Check_Warnings	0
22	BLDCHERR	Build Check Errors	Long Integer	ML_Build_Check_Errors	0
23	DEDNMTHD	Deduction Method	Integer	DDL_Deduction_Method	0
24	PRCSSQNC	Process Sequence	Integer	INT	0
25	SEQCOUNT	Sequence Count	Long Integer	Long Int	8
26	SEQUENCESUM	Sequence Sum	Currency	DLR19_QTY_RBS0_STR	19
27	CALCCHKERRS	Calc Check Errors	Long Integer	ML_Calc_Check_Errors	0
28	ATTEMPTEDAMT	Attempted Amount	Currency	DLR19_RBSO_STR$	19
29	SPLITMTHD	Split Method	Integer	DDL_Split_Method	0
30	MAXAMOUNT	Maximum Amount	Currency	DLR19_RBSO_STR$	19
31	BASEDONWAGES	Based On Wages	Currency	DLR11_$S2	14
32	TTLDDTNS	Total Deductions	Currency	DLR11_$S2	14

azurecurve Products HRM Solution Series (1911)PayrollDIA Payroll Work Deduction TEMP (APR_DIA10300)

Click to show/hide

Leave a Reply Cancel reply