| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | DEPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 2 | DEVERS | Version History | String | Generic Edit | 10 | 0 | Allow NULL? |
| 3 | DETY | Record Code | Character | UDC (H00 TY) | 1 | 0 | Allow NULL? |
| 4 | DESQN | Option Prompt Line | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 5 | DEOPT# | Processing Option Number | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 6 | DEDWTY | DREAM Writer File Type | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 7 | DEFILN | Based on File | String | Generic Edit | 10 | 0 | Allow NULL? |
| 8 | DEPFX | Prefix - File | String | Generic Edit | 2 | 0 | Allow NULL? |
| 9 | DEMID | Member ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 10 | DEFMAT | Format Name | String | Generic Edit | 10 | 0 | Allow NULL? |
| 11 | DELGF | File - Logical File Name | String | Generic Edit | 10 | 0 | Allow NULL? |
| 12 | DEJEX | Job to Execute | String | Generic Edit | 10 | 0 | Allow NULL? |
| 13 | DEEXCL | User Exclusive (0/1/2/3/4) | Character | UDC (H98 EX) | 1 | 0 | Allow NULL? |
| 14 | DEOUTM | Output Media | String | UDC (H98 OU) | 3 | 0 | Allow NULL? |
| 15 | DEUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 16 | DEVCD | Date - Last Changed | Date | Generic Edit | 6 | 0 | |
| 17 | DEVED | Date - Last Executed | Date | Generic Edit | 6 | 0 | |
| 18 | DEPTSP | Print Specifications Cover Page (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 19 | DEPTIN | Print Help Instructions (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 20 | DEHJBQ | Hold on Job Queue | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 21 | DETXT1 | Processing Option Text | String | Generic Edit | 50 | 0 | Allow NULL? |
| 22 | DEKOPT | Optional Item | Character | UDC (H00 KO) | 1 | 0 | Allow NULL? |
| 23 | DEFLDN | Data Field Name | String | Generic Edit | 6 | 0 | Allow NULL? |
| 24 | DEDTAS | Data Item Size | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 25 | DEDTAT | Data Item Type | Character | UDC (98 DT) | 1 | 0 | Allow NULL? |
| 26 | DECDEC | Display Decimals | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 27 | DEEC | Edit Code | Character | UDC (98 EC) | 1 | 0 | Allow NULL? |
| 28 | DEDFLD | Prompt - Date Field | Character | UDC (H00 DF) | 1 | 0 | Allow NULL? |
| 29 | DERJST | Right Justify (0/1/2) | Character | UDC | 1 | 0 | Allow NULL? |
| 30 | DEAO | And/Or Selection | Character | UDC (00 AO) | 1 | 0 | Allow NULL? |
| 31 | DESVL | Selection value | String | Generic Edit | 25 | 0 | Allow NULL? |
| 32 | DEVALR | Relationship | String | UDC (00 VA) | 2 | 0 | Allow NULL? |
| 33 | DESTY | Selection type | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 34 | DEMCRG | Processing Option Display Level | Character | UDC (00 LD) | 1 | 0 | Allow NULL? |
| 35 | DEAALL | Select - Allow *ALL | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 36 | DESAD | Sequence (A/D) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 37 | DETXTO | Text Only (1/0) | Character | UDC (H00 TW) | 1 | 0 | Allow NULL? |
| 38 | DELTOT | Level of Totaling | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 39 | DEPAGE | Page Skip | Character | UDC (H98 PA) | 1 | 0 | Allow NULL? |
| 40 | DETYT | Type Report Totaling | Character | UDC (H98 TY) | 1 | 0 | Allow NULL? |
| 41 | DEOQSO | OPNQRYF Sequential Only | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 42 | DEOQOP | OPNQRYF Optimize Option | Character | UDC | 1 | 0 | Allow NULL? |
| 43 | DEOQOO | OPNQRYF Output Open Option | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 44 | DEOQOU | OPNQRYF Update Open Option | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 45 | DEOQOD | OPNQRYF Delete Open Option | Character | Generic Edit | 1 | 0 | Allow NULL? |