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