Payroll State Tax Master (UPR00700)

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

Display Name: Payroll State Tax Master
Physical Name: UPR00700
Technical Name: UPR_MSTR_State_Tax

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	EMPLOYID	Employee ID	String	STR15_Employee_ID	15
2	STATECD	State Code	String	STR2_State_Code	2
3	TXFLGSTS	Tax Filing Status	String	STR6_Payroll_Code	6
4	EXMFBLND	Exemption For Blind	Boolean	CB_Blind	0
5	EXFBLSPS	Exemption For Blind Spouse	Boolean	CB_Blind_Spouse	0
6	EXFORO65	Exemption For Over 65	Boolean	CB_Over_65	0
7	EXMFRSLF	Exemption For Self	Boolean	CB_Self	0
8	EXMFSPAL	Exemption For Special Allowance	Boolean	CB_Special_Allowance	0
9	EXMFRSPS	Exemption For Spouse	Boolean	CB_Spouse	0
10	EXFSPO65	Exemption For Spouse Over 65	Boolean	CB_Spouse_Over_65	0
11	PRSNEXPT	Personal Exemptions	Integer	INT	0
12	DEPNDNTS	Dependents	Integer	INT2_U0	2
13	ADNLALOW	Additional Allowances	Integer	INT2_U0	2
14	ESTDEDAL	Estimated Deduction Allowances	Integer	INT2_U0	2
15	EXMTAMNT	Exemption Amount	Currency	DLR11_$U2	14
16	ADSTWHDG	Additional State Withholding	Currency	DLR11_$S2	14
17	ESTSTWHD	Estimated State Withholding	Currency	DLR11_$U2	14
18	INACTIVE	Inactive	Boolean	CB_Inactive	0
19	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Payroll State Tax Master'].NOTEINDX AS 'Payroll State Tax Master-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM UPR00700 AS ['Payroll State Tax Master'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Payroll State Tax Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX