| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | T2SDB | Supplemental Database Code | String | UDC (00 SD) | 4 | 0 | Allow NULL? |
| 2 | T2TYDT | Type Data | String | Generic Edit | 2 | 0 | Allow NULL? |
| 3 | T2CLS | Data Type Classification | String | UDC (00 CL) | 4 | 0 | Allow NULL? |
| 4 | T2DSPM | Display Mode - Code or Narrative | Character | UDC (H00 DS) | 1 | 0 | Allow NULL? |
| 5 | T2DSS5 | Display Sequence- 5.2 | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 6 | T2DL01 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 7 | T2SY | Product Code | String | UDC (98 SY) | 4 | 0 | Allow NULL? |
| 8 | T2SY1 | System Code | String | UDC (98 SY) | 4 | 0 | Allow NULL? |
| 9 | T2SY2 | System Code | String | UDC (98 SY) | 4 | 0 | Allow NULL? |
| 10 | T2RT | User Defined Codes | String | Generic Edit | 2 | 0 | Allow NULL? |
| 11 | T2RT1 | User Defined Codes | String | Generic Edit | 2 | 0 | Allow NULL? |
| 12 | T2RT2 | User Defined Codes | String | Generic Edit | 2 | 0 | Allow NULL? |
| 13 | T2GDC1 | User Defined Code Title | String | Generic Edit | 10 | 0 | Allow NULL? |
| 14 | T2GDC2 | User Defined Amount Title | String | Generic Edit | 10 | 0 | Allow NULL? |
| 15 | T2GDC3 | Remark 1 Column Title | String | Generic Edit | 30 | 0 | Allow NULL? |
| 16 | T2GDC4 | Remark 2 Column Title | String | Generic Edit | 30 | 0 | Allow NULL? |
| 17 | T2GDC5 | Date #1 Column Title | String | Generic Edit | 10 | 0 | Allow NULL? |
| 18 | T2GDC6 | Date #2 Column Title | String | Generic Edit | 10 | 0 | Allow NULL? |
| 19 | T2GDC7 | Amount 2 Row Title | String | Generic Edit | 10 | 0 | Allow NULL? |
| 20 | T2GDCA | User Date Column Title | String | Generic Edit | 10 | 0 | Allow NULL? |
| 21 | T2GDC0 | User Defined Quantity Title | String | Generic Edit | 10 | 0 | Allow NULL? |
| 22 | T2GDCC | User Days Column Title | String | Generic Edit | 10 | 0 | Allow NULL? |
| 23 | T2GDC8 | Order Column Title | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | T2GDCD | User Address Column Title | String | Generic Edit | 10 | 0 | Allow NULL? |
| 25 | T2AT1 | Search Type | String | UDC (01 ST) | 3 | 0 | Allow NULL? |
| 26 | T2EAP | Application ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 27 | T2PGM | Program Name | String | Generic Edit | 10 | 0 | Allow NULL? |
| 28 | T2VERS | Version History | String | Generic Edit | 10 | 0 | Allow NULL? |
| 29 | T2USER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 30 | T2JOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 31 | T2UPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 32 | T2TDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 33 | T2GDCE | Remark 3 Column Title | String | Generic Edit | 30 | 0 | Allow NULL? |
| 34 | T2GDCF | User Time Column Title | String | Generic Edit | 10 | 0 | Allow NULL? |