Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/UPR00300
Product: Microsoft Dynamics GP (0)
Series: Payroll
Display Name: Payroll Tax Information Master Group Display Name: Payroll Employee Master
Physical Name: UPR00300
Technical Name: UPR_MSTR_Tax_Info
Group Technical Name: Payroll Employee Master
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | NOTEINDX  | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['Payroll Tax Information Master'].NOTEINDX AS 'Payroll Tax Information Master-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
UPR00300 AS ['Payroll Tax Information Master']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Payroll Tax Information Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
| 2 | EMPLOYID | Employee ID | String | STR15_Employee_ID | 15 | |
| 3 | EXMFRFED | Exempt From Federal | Boolean | CB_Exempt_From_Federal_Withholding | 0 | |
| 4 | FDFLGSTS | Federal Filing Status | String | STR6_Payroll_Code | 6 | |
| 5 | FEDEXMPT | Federal Exemptions | Integer | INT2_U0 | 2 | |
| 6 | ADFDWHDG | Additional Federal Withholding | Currency | DLR11_$S2 | 14 | |
| 7 | ESTFEDWH | Estimated Federal Withholding | Currency | DLR11_$U2 | 14 | |
| 8 | STATECD | State Code | String | STR2_State_Code | 2 | |
| 9 | LOCALTAX | Local Tax | String | STR6_Payroll_Code | 6 | |
| 10 | W2BF942E | W2 Box For 942 Employee | Boolean | CB_942_Employee | 0 | |
| 11 | W2BFDCSD | W2 Box For Deceased | Boolean | CB_Deceased | 0 | |
| 12 | W2BFDCMP | W2 Box For Deferred Compensation | Boolean | CB_Deferred_Compensation | 0 | |
| 13 | W2BFLREP | W2 Box For Legal Representative | Boolean | CB_Legal_Representative | 0 | |
| 14 | W2BFPPLN | W2 Box For Pension Plan | Boolean | CB_Pension_Plan | 0 | |
| 15 | W2BFSTEM | W2 Box For Statutory Employee | Boolean | CB_Statutory_Employee | 0 | |
| 16 | MCRQGEMP | Medicare Qualified Govt Employee | Boolean | CB_Medicare_Qualified_Govt_Employee | 0 | |
| 17 | EICFLGST | EIC Filing Status | String | STR6_Payroll_Code | 6 | |
| 18 | NYTXDiff | Withhold NY Tax Diff | Boolean | CB_Withhold_NY_Diff | 0 | |
| 19 | QualifiedHire | 941 Qualified Hire | Boolean | CB_941_Qualified_Hire | 0 | |
| 20 | MarriedWithholdAsSingle | Married Withhold As Single | Boolean | Boolean | 0 | |
| 21 | DependentClaimAmt | Dependent Claim Amt | Currency | DLR11_$S2 | 14 | |