| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP04: Accounts Payable |
| 1 | F04514 | 1099 Merged Worktables (F045141:F045143) | 28 | G1 | ST | 1099 State Code | String | UDC | 2 | 0 |
| 2 | F045141 | 1099 G/L Worktable | 28 | G1 | ST | 1099 State Code | String | UDC | 2 | 0 |
| 3 | F045143 | 1099 A/P Worktable | 28 | G1 | ST | 1099 State Code | String | UDC | 2 | 0 |
| 4 | F04514WF | K Record Workfile | 1 | KR | ST | 1099 State Code | String | UDC | 2 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 04 / ST (1099 State Code) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | . | | N |
| 2 | 01 | Alabama | | N |
| 3 | 04 | Arizona | | N |
| 4 | 05 | Arkansas | | N |
| 5 | 06 | California | | N |
| 6 | 07 | Colorado | | Y |
| 7 | 08 | Connecticut | | Y |
| 8 | 10 | Delaware | | N |
| 9 | 11 | District Of Columbia | | N |
| 10 | 13 | Georgia | | N |
| 11 | 15 | Hawaii | | N |
| 12 | 16 | Idaho | | N |
| 13 | 18 | Indiana | | N |
| 14 | 19 | Iowa | | N |
| 15 | 20 | Kansas | | N |
| 16 | 22 | Louisiana | | Y |
| 17 | 23 | Maine | | N |
| 18 | 24 | Maryland | | Y |
| 19 | 25 | Massachusetts | | N |
| 20 | 27 | Minnesota | | N |
| 21 | 28 | Mississippi | | N |
| 22 | 29 | Missouri | | N |
| 23 | 30 | Montana | | N |
| 24 | 31 | Nebraska | | Y |
| 25 | 34 | New Jersey | | N |
| 26 | 35 | New Mexico | | N |
| 27 | 37 | North Carolina | | N |
| 28 | 38 | Noth Dakota | | N |
| 29 | 39 | Ohio | | Y |
| 30 | 41 | Oregon | | N |
| 31 | 45 | South Carolina | | N |
| 32 | 47 | Tennessee | | N |
| 33 | 49 | Utah | | Y |
| 34 | 51 | Virginia | | Y |
| 35 | 55 | Wisconsin | | N |
