Payroll Flat Tax Records (UPR19900)

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

Display Name: Payroll Flat Tax Records
Physical Name: UPR19900
Technical Name: UPR_Flat_Tax_Records

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	ISTIPPAY	Is Tips Pay	Boolean	Boolean	0
2	ACTINDX	Account Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Payroll Flat Tax Records'].ACTINDX AS 'Payroll Flat Tax Records-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM UPR19900 AS ['Payroll Flat Tax Records'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Payroll Flat Tax Records'].ACTINDX = ['Account Index Master'].ACTINDX
3	ACCTAMNT	Account Amount	Currency	DLR19_RBS0_UTR$	19
4	ACCTTYPE	Account Type	Integer	DDL_Account_Type	0
5	STATECD	State Code	String	STR2_State_Code	2
6	PAYRCORD	Pay Record	String	STR6_Payroll_Code	6
7	PAYTYPE	Pay Type	Integer	DDL_Pay_Types	0
8	GROSWAGS	Gross Wages	DLR11_$S2	Currency	14
9	GROSWAGS_1	Gross Wages[1]	Currency	DLR11_$S2	14
10	GROSWAGS_2	Gross Wages[2]	Currency	DLR11_$S2	14
11	GROSWAGS_3	Gross Wages[3]	Currency	DLR11_$S2	14
12	GROSWAGS_4	Gross Wages[4]	Currency	DLR11_$S2	14
13	GROSWAGS_5	Gross Wages[5]	Currency	DLR11_$S2	14
14	GROSWAGS_6	Gross Wages[6]	Currency	DLR11_$S2	14
15	GROSWAGS_7	Gross Wages[7]	Currency	DLR11_$S2	14
16	GROSWAGS_8	Gross Wages[8]	Currency	DLR11_$S2	14
17	GROSWAGS_9	Gross Wages[9]	Currency	DLR11_$S2	14
18	GROSWAGS_10	Gross Wages[10]	Currency	DLR11_$S2	14
19	GROSWAGS_11	Gross Wages[11]	Currency	DLR11_$S2	14
20	GROSWAGS_12	Gross Wages[12]	Currency	DLR11_$S2	14
21	FFEDTXRT	Flat Federal Tax Rate	Integer	INT4_%2	4
22	FLSTTXRT	Flat State Tax Rate	Integer	INT4_%2	4