| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | DTDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 2 | DTTNTP | Transaction Type | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 3 | DTIRPT | Include In Integrity Report | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 4 | DTLTTC | Consolidate Lot Trace Track | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 5 | DTILTT | Display Lot Trace Track | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 6 | DTNATN | NatureOfTransaction | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 7 | DTCTPA | Commit Procurement Orders | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 8 | DTOCAT | Category of Order | String | Generic Edit | 2 | 0 | Allow NULL? |
| 9 | DTOTQY | Other Quantity (1/2) | Character | UDC | 1 | 0 | Allow NULL? |
| 10 | DTRELV | RelieveOnHand | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 11 | DTIBOR | InterbranchOrder | String | Generic Edit | 2 | 0 | Allow NULL? |
| 12 | DTSY | Product Code | String | UDC (98 SY) | 4 | 0 | Allow NULL? |
| 13 | DTORNN | Order Type Next Number | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 14 | DTCSCT | Service/Warranty Case Type | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 15 | DTCSOT | Service Order Type | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 16 | DTCSKT | Service/Warranty Contract Type | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 17 | DTCRTK | Create S/WM Contract | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 18 | DTA101 | Engineering Project Management Type | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 19 | DTA102 | Create Fixed Asset | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 20 | DTA103 | Commit Manufacturing Document | Character | Generic Edit (00 OO) | 1 | 0 | Allow NULL? |
| 21 | DTA104 | Equipment Maintenance Document | Character | Generic Edit (00 OO) | 1 | 0 | Allow NULL? |
| 22 | DTA105 | Ship and Debit Y/N | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 23 | DTA106 | Publish Externally | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 24 | DTA107 | Generic Character 7 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 25 | DTA108 | Generic Character 8 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 26 | DTA109 | Recommend Cartons | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 27 | DTA110 | Send Status Notification | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 28 | DTA111 | Generic Character11 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 29 | DTA112 | Cross Docking Supply | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 30 | DTA113 | Generic Character13 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 31 | DTA114 | Generic Character14 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 32 | DTA115 | Generic Character15 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 33 | DTA116 | Generic Character16 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 34 | DTA117 | Generic Character17 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 35 | DTA118 | Generic Character18 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 36 | DTA119 | Generic Character19 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 37 | DTA120 | Generic Character20 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 38 | DTA201 | Work Order Type | String | UDC (48 OT) | 2 | 0 | Allow NULL? |
| 39 | DTA202 | Generic 2 String 02 | String | Generic Edit | 2 | 0 | Allow NULL? |
| 40 | DTA203 | Generic 2 String 03 | String | Generic Edit | 2 | 0 | Allow NULL? |
| 41 | DTA204 | Carton Creation Status | String | UDC (46 RS) | 2 | 0 | Allow NULL? |
| 42 | DTA205 | Carton Change Status | String | UDC (46 RS) | 2 | 0 | Allow NULL? |
| 43 | DTA301 | Generic String 01 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 44 | DTA302 | Generic String 02 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 45 | DTA303 | Generic String 03 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 46 | DTA304 | Generic String 04 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 47 | DTA305 | Generic String 05 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 48 | DTUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 49 | DTPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 50 | DTJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 51 | DTUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 52 | DTTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 53 | DTDTSQ | Document Type Sequencing Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |