| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | RXNUMB | Asset Item Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | RXSRVT | Service Type | String | UDC (12 ST) | 8 | 0 | Allow NULL? |
| 3 | RXTYPF | Forecast Type | String | UDC (34 DF) | 2 | 0 | Allow NULL? |
| 4 | RXFQT | Quantity - Forecast | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 5 | RXTDT | Date - Scheduled Tickler | Date | Generic Edit | 6 | 0 | |
| 6 | RXHRSO | Hours - Estimated | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 7 | RXAMLC | Amount - Estimated Labor | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 8 | RXAMMC | Amount - Estimated Material | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 9 | RXMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 10 | RXESDN | Estimated Downtime Hours | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 11 | RXDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 12 | RXMMCU | Branch | String | Generic Edit | 12 | 0 | Allow NULL? |
| 13 | RXDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 14 | RXTYPS | Type - W.O. | Character | UDC (00 TY) | 1 | 0 | Allow NULL? |
| 15 | RXPRTS | Priority - W.O. | Character | UDC (00 PR) | 1 | 0 | Allow NULL? |
| 16 | RXSRST | Status Code W.O. | String | UDC (00 SS) | 2 | 0 | Allow NULL? |
| 17 | RXDL01 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 18 | RXWR01 | Categories - Work Order 01 | String | UDC (00 W1) | 4 | 0 | Allow NULL? |
| 19 | RXWR02 | Categories - Work Order 02 | String | UDC (00 W2) | 3 | 0 | Allow NULL? |
| 20 | RXWR03 | Categories - Work Order 03 | String | UDC (00 W3) | 3 | 0 | Allow NULL? |
| 21 | RXWR04 | Categories - Work Order 04 | String | UDC (00 W4) | 3 | 0 | Allow NULL? |
| 22 | RXWR05 | Categories - Work Order 05 | String | UDC (00 W5) | 3 | 0 | Allow NULL? |
| 23 | RXWR06 | EnterpriseOne Consulting - Status | String | UDC (00 W6) | 3 | 0 | Allow NULL? |
| 24 | RXWR07 | EnterpriseOne Consulting - Service Type | String | UDC (00 W7) | 3 | 0 | Allow NULL? |
| 25 | RXWR08 | EnterpriseOne Consulting - Skill Type | String | UDC (00 W8) | 3 | 0 | Allow NULL? |
| 26 | RXWR09 | E1 Consulting - Experience Level | String | UDC (00 W9) | 3 | 0 | Allow NULL? |
| 27 | RXWR10 | Categories - Work Order 10 | String | UDC (00 W0) | 3 | 0 | Allow NULL? |
| 28 | RXANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 29 | RXANPA | Supervisor | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 30 | RXAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 31 | RXSAID | Service Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 32 | RXMCUW | Dispatch Group - Work Centers | String | Generic Edit | 12 | 0 | Allow NULL? |
| 33 | RXMCULT | Lead Craft | String | Generic Edit | 12 | 0 | Allow NULL? |
| 34 | RXWSCHF | Maintenance Schedule Flag | Character | UDC (13 WS) | 1 | 0 | Allow NULL? |
| 35 | RXWONA | Work Order Number Assigned | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 36 | RXITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 37 | RXTBM | Type Bill of Material | String | UDC (40 TB) | 3 | 0 | Allow NULL? |
| 38 | RXTRT | Type of Routing | String | UDC (40 TR) | 3 | 0 | Allow NULL? |
| 39 | RXUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 40 | RXPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 41 | RXMKEY | Machine Key | String | Generic Edit | 15 | 0 | Allow NULL? |
| 42 | RXUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 43 | RXUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
