| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | DIJOBS | Job Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | DIACTN | Action Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 3 | DIEV03 | J.D. EnterpriseOne Point 03 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 4 | DIVERS | Version History | String | Generic Edit | 10 | 0 | Allow NULL? |
| 5 | DICONO | Change Request Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 6 | DIMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 7 | DICO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 8 | DIDL01 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 9 | DIRMK | Name - Remark | String | Generic Edit | 30 | 0 | Allow NULL? |
| 10 | DICREF | Change Request Reference Number 1 | String | Generic Edit | 25 | 0 | Allow NULL? |
| 11 | DICRF2 | Change Request Reference Number 2 | String | Generic Edit | 10 | 0 | Allow NULL? |
| 12 | DICRF3 | Change Request Reference Number 3 | String | Generic Edit | 12 | 0 | Allow NULL? |
| 13 | DIAREQ | Address Number - Requested By | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 14 | DIANO | Address Number - Originator | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 15 | DIAPRV | Address Number - Approved by | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 16 | DIBSTC | Status Code | Character | UDC (53 ST) | 1 | 0 | Allow NULL? |
| 17 | DIPRTC | Priority Code | Character | UDC (53 PR) | 1 | 0 | Allow NULL? |
| 18 | DITYPB | Type Change Request | Character | UDC (53 TY) | 1 | 0 | Allow NULL? |
| 19 | DIREQB | Number - Requote | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 20 | DIRQBD | Date - Requote (Julian) | Date | Generic Edit | 6 | 0 | |
| 21 | DIOREQ | Owner Change Required | Character | UDC (53 OR) | 1 | 0 | Allow NULL? |
| 22 | DIPPCO | Planned Change Order Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 23 | DIDRQJ | Date - Requested | Date | Generic Edit | 6 | 0 | |
| 24 | DIAPRD | Date - Approved (Julian) | Date | Generic Edit | 6 | 0 | |
| 25 | DIPNST | Date - Planned Start (Julian) | Date | Generic Edit | 6 | 0 | |
| 26 | DIPNFN | Date - Planned Finish (Julian) | Date | Generic Edit | 6 | 0 | |
| 27 | DIUDT1 | Transport Reason Code | Date | Generic Edit | 6 | 0 | |
| 28 | DIUDT2 | Date - User Defined #2 | Date | Generic Edit | 6 | 0 | |
| 29 | DIUDT3 | Date - User Defined #3 | Date | Generic Edit | 6 | 0 | |
| 30 | DIRB01 | Initiated By | String | UDC (53 01) | 3 | 0 | Allow NULL? |
| 31 | DIRB02 | Area | String | UDC (53 02) | 3 | 0 | Allow NULL? |
| 32 | DIRB03 | Category Code - Change Orders 03 | String | UDC (53 03) | 3 | 0 | Allow NULL? |
| 33 | DIRB04 | Category Code - Change Orders 04 | String | UDC (53 04) | 3 | 0 | Allow NULL? |
| 34 | DIRB05 | Category Code - Change Orders 05 | String | UDC (53 05) | 3 | 0 | Allow NULL? |
| 35 | DIRB06 | Category Code - Change Orders 06 | String | UDC (53 06) | 3 | 0 | Allow NULL? |
| 36 | DIRB07 | Category Code - Change Orders 07 | String | UDC (53 07) | 3 | 0 | Allow NULL? |
| 37 | DIRB08 | Category Code - Change Orders 08 | String | UDC (53 08) | 3 | 0 | Allow NULL? |
| 38 | DIRB09 | Category Code - Change Orders 09 | String | UDC (53 09) | 3 | 0 | Allow NULL? |
| 39 | DIRB10 | Category Code - Change Orders 10 | String | UDC (53 10) | 3 | 0 | Allow NULL? |
| 40 | DICRFC | Change Request Reference # - Compressed | String | Generic Edit | 20 | 0 | Allow NULL? |
| 41 | DISBLI | Subledger Inactive Code | Character | UDC (00 SI) | 1 | 0 | Allow NULL? |
| 42 | DIEXTD | Days - Extend | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 43 | DIRQDD | Days - Required | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 44 | DICSCH | Construction Schedule | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 45 | DICRRM | Currency Mode-Foreign or Domestic Entry | Character | UDC (H00 CY) | 1 | 0 | Allow NULL? |
| 46 | DICRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 47 | DICRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 48 | DIUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 49 | DIPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 50 | DIJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 51 | DIUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 52 | DIUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |