| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | J0YEID | Year-End ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 2 | J0TAXYR | Tax Year | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 3 | J0VER | Version | String | Generic Edit | 10 | 0 | Allow NULL? |
| 4 | J0CO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 5 | J0TXIDS | Tax ID Summarization | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 6 | J0WBT4 | Work File Build Status - T4 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 7 | J0WBR1 | Work File Build Status - Releve1 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 8 | J0WBT4A | Work File Build Status - T4A | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 9 | J0WBR2 | Work File Build Status - Releve2 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 10 | J0WBNR4 | Work File Build Status - NR4 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 11 | J0T4PRTS | Canada - T4 Form Print Status | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | J0REL1S | Canada - Releve1 Form Print Status | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 13 | J0T4AS | Canada - T4A Form Print Status | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 14 | J0RELS2 | Canada - Releve2 Form Print Status | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 15 | J0NR4S | Canada - NR4 Form Print Status | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 16 | J0MBT4 | Mag Media Build Status - T4 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 17 | J0MBR1 | Mag Media Build Status - Releve1 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 18 | J0MBT4A | Mag Media Build Status - T4A | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 19 | J0MBR2 | Mag Media Build Status - Releve2 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 20 | J0MBNR4 | Mag Media Build Status - NR4 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 21 | J0ART4 | Audit Report Status - T4 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 22 | J0ARR1 | Audit Report Status - Releve1 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 23 | J0ART4A | Audit Report Status - T4A | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 24 | J0ARR2 | Audit Report Status - Releve2 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 25 | J0ARNR4 | Audit Report Status - NR4 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 26 | J0ARCS | Archive Status | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 27 | J0ADJRE | Adjustment Reset | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 28 | J0EEOM | Ethnic Code | String | UDC (06 M) | 2 | 0 | Allow NULL? |
| 29 | J0PCCV | Payroll Category Code Value | String | Generic Edit | 10 | 0 | Allow NULL? |
| 30 | J0NRCT | Recipient Type | Character | UDC (77Y RT) | 1 | 0 | Allow NULL? |
| 31 | J0ICC1 | Income Code 1 | String | UDC (77 IC) | 10 | 0 | Allow NULL? |
| 32 | J0CC1 | Currency Code 1 | String | UDC (77 CU) | 3 | 0 | Allow NULL? |
| 33 | J0EXC1 | Exemption Code 1 | String | UDC (77 EX) | 3 | 0 | Allow NULL? |
| 34 | J0R2PR | Type of Retirement Account | String | Generic Edit | 10 | 0 | Allow NULL? |
| 35 | J0UPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 36 | J0UPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 37 | J0PID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 38 | J0JOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 39 | J0USER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |