| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP07: Payroll |
1 | F07821 | Company Form Count Table | 3 | JG | TFYE | Type of Form | Character | UDC | 1 | 0 |
2 | F07822 | Company Federal Control Table | 7 | JI | TFYE | Type of Form | Character | UDC | 1 | 0 |
3 | F07824 | Company State/Local Control Table | 6 | JD | TFYE | Type of Form | Character | UDC | 1 | 0 |
4 | F07825 | Company Special Handling Control Table | 6 | JA | TFYE | Type of Form | Character | UDC | 1 | 0 |
5 | F07830 | Employee Federal Control Table | 6 | Y0 | TFYE | Type of Form | Character | UDC | 1 | 0 |
6 | F07831 | Employee State/Local Control Table | 6 | YB | TFYE | Type of Form | Character | UDC | 1 | 0 |
7 | F07832 | Employee Special Handling Control Table | 5 | YH | TFYE | Type of Form | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 07Y / TF (Type of Year-End Form) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | 0 | W-2 | | Y |
2 | 1 | W-2c | | Y |
3 | 2 | 499R-2 | | Y |
4 | 3 | 499R-2C | | Y |
5 | 4 | 1099-Misc | | Y |
6 | 5 | 1099-R | | Y |
7 | 6 | 1099-MscC | | Y |
8 | 7 | 1099-RC | | Y |
9 | A | W-3 | | Y |
10 | B | W-3c | | Y |
11 | C | 499R-3 | | Y |
12 | D | 499R-3C | | Y |
13 | E | 1096 | | Y |