| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | JNMCUS | Business Unit - Subsequent | String | Generic Edit | 12 | 0 | Allow NULL? |
| 2 | JNOPTN | Option Number | String | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | JNPL | Plan Number | String | Generic Edit | 4 | 0 | Allow NULL? |
| 4 | JNELEV | Elevation | String | Generic Edit | 3 | 0 | Allow NULL? |
| 5 | JNPLNQ | Plan Qualifier | String | Generic Edit | 25 | 0 | Allow NULL? |
| 6 | JNGPPC | Gross Profit Percentage | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 7 | JNAMTO | Amount - Estimated | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 8 | JNSTRT | Date - Start (Julian) | Date | Generic Edit | 6 | 0 | |
| 9 | JNDPTP | Option Deposit Percentage | Numeric | Generic Edit | 15 | 7 | Allow NULL? |
| 10 | JNCSPR | Current Sales Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 11 | JNPSPR | Amount - Previous Sales Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 12 | JNSTRX | Date - Completion (Julian) | Date | Generic Edit | 6 | 0 | |
| 13 | JNOP01 | Option Type - Option Master | String | UDC (44 O1) | 3 | 0 | Allow NULL? |
| 14 | JNOP02 | Categories - Option Master | String | UDC (44 O2) | 3 | 0 | Allow NULL? |
| 15 | JNOP03 | Categories - Option Master | String | UDC (44 O3) | 3 | 0 | Allow NULL? |
| 16 | JNOP04 | Categories - Option Master | String | UDC (44 O4) | 3 | 0 | Allow NULL? |
| 17 | JNDL01 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 18 | JNDL02 | Description 02 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 19 | JNDL03 | Description 03 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 20 | JNDSC1 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 21 | JNDSC2 | Description - Line 2 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 22 | JNDSC3 | Description - Line 3 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 23 | JNUC01 | User Reason Code 01 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 24 | JNUC02 | User Reason Code 02 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 25 | JNUC03 | User Reason Code 03 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 26 | JNUSD1 | User Date 1 | Date | Generic Edit | 6 | 0 | |
| 27 | JNUSD2 | User Date 2 | Date | Generic Edit | 6 | 0 | |
| 28 | JNUSD3 | User Date 3 | Date | Generic Edit | 6 | 0 | |
| 29 | JNPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 30 | JNUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 31 | JNEFFF | Effective - From Date | Date | Generic Edit | 6 | 0 | |
| 32 | JNUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
