| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | EFEQGP | Equipment Group | String | Generic Edit | 30 | 0 | Allow NULL? |
| 2 | EFEQSP | Equipment Subgroup | String | Generic Edit | 30 | 0 | Allow NULL? |
| 3 | EFICLC | Include Children | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 4 | EFCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 5 | EFMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 6 | EFLOC | Business Unit - Location | String | Generic Edit | 12 | 0 | Allow NULL? |
| 7 | EFAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 8 | EFLANO | Address Number - Lessor/Rentor/Mortgagor | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 9 | EFEQST | Equipment Status | String | UDC (12 ES) | 2 | 0 | Allow NULL? |
| 10 | EFAAID | Parent Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 11 | EFPRODM | Product Model | String | UDC (17 PM) | 8 | 0 | Allow NULL? |
| 12 | EFPRODF | Product Family | String | UDC (17 PA) | 8 | 0 | Allow NULL? |
| 13 | EFMMCU | Branch | String | Generic Edit | 12 | 0 | Allow NULL? |
| 14 | EFNUMB | Asset Item Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 15 | EFKIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 16 | EFACL1 | Major Accounting Class | String | UDC (12 C1) | 3 | 0 | Allow NULL? |
| 17 | EFACL2 | Major Equipment Class | String | UDC (12 C2) | 3 | 0 | Allow NULL? |
| 18 | EFACL3 | Manufacturer | String | UDC (12 C3) | 3 | 0 | Allow NULL? |
| 19 | EFACL4 | Model Year | String | UDC (12 C4) | 3 | 0 | Allow NULL? |
| 20 | EFACL5 | Usage Miles or Hours | String | UDC (12 C5) | 3 | 0 | Allow NULL? |
| 21 | EFACL6 | Category Code - F/A 6 | String | UDC (12 C6) | 3 | 0 | Allow NULL? |
| 22 | EFACL7 | Category Code - F/A 7 | String | UDC (12 C7) | 3 | 0 | Allow NULL? |
| 23 | EFACL8 | Category Code - F/A 8 | String | UDC (12 C8) | 3 | 0 | Allow NULL? |
| 24 | EFACL9 | Category Code - F/A 9 | String | UDC (12 C9) | 3 | 0 | Allow NULL? |
| 25 | EFACL0 | Category Code - F/A 10 (Rate Group) | String | UDC (12 C0) | 3 | 0 | Allow NULL? |
| 26 | EFFA1 | Category Code - F/A 11 | String | UDC (12 F1) | 3 | 0 | Allow NULL? |
| 27 | EFFA2 | Category Code - F/A 12 | String | UDC (12 F2) | 3 | 0 | Allow NULL? |
| 28 | EFFA3 | Category Code - F/A 13 | String | UDC (12 F3) | 3 | 0 | Allow NULL? |
| 29 | EFFA4 | Category Code - F/A 14 | String | UDC (12 F4) | 3 | 0 | Allow NULL? |
| 30 | EFFA5 | Category Code - F/A 15 | String | UDC (12 F5) | 3 | 0 | Allow NULL? |
| 31 | EFFA6 | Category Code - F/A 16 | String | UDC (12 F6) | 3 | 0 | Allow NULL? |
| 32 | EFFA7 | Category Code - F/A 17 | String | UDC (12 F7) | 3 | 0 | Allow NULL? |
| 33 | EFFA8 | Category Code - F/A 18 | String | UDC (12 F8) | 3 | 0 | Allow NULL? |
| 34 | EFFA9 | Category Code - F/A 19 | String | UDC (12 F9) | 3 | 0 | Allow NULL? |
| 35 | EFFA0 | Category Code - F/A 20 | String | UDC (12 F0) | 3 | 0 | Allow NULL? |
| 36 | EFFA21 | Category Code - F/A 21 | String | UDC (12 21) | 10 | 0 | Allow NULL? |
| 37 | EFFA22 | Category Code - F/A 22 | String | UDC (12 22) | 10 | 0 | Allow NULL? |
| 38 | EFFA23 | Category Code - F/A 23 | String | UDC (12 23) | 10 | 0 | Allow NULL? |
| 39 | EFZE01 | Category Code - Equipment 01 | String | UDC (17 B1) | 10 | 0 | Allow NULL? |
| 40 | EFZE02 | Category Code - Equipment 02 | String | UDC (17 B2) | 10 | 0 | Allow NULL? |
| 41 | EFZE03 | Category Code - Equipment 03 | String | UDC (17 B3) | 10 | 0 | Allow NULL? |
| 42 | EFZE04 | Category Code - Equipment 04 | String | UDC (17 B4) | 10 | 0 | Allow NULL? |
| 43 | EFZE05 | Category Code - Equipment 05 | String | UDC (17 B5) | 10 | 0 | Allow NULL? |
| 44 | EFZE06 | Category Code - Equipment 06 | String | UDC (17 B6) | 10 | 0 | Allow NULL? |
| 45 | EFZE07 | Category Code - Equipment 07 | String | UDC (17 B7) | 10 | 0 | Allow NULL? |
| 46 | EFZE08 | Category Code - Equipment 08 | String | UDC (17 B8) | 10 | 0 | Allow NULL? |
| 47 | EFZE09 | Category Code - Equipment 09 | String | UDC (17 B9) | 10 | 0 | Allow NULL? |
| 48 | EFZE10 | Category Code - Equipment 10 | String | UDC (17 B0) | 10 | 0 | Allow NULL? |
| 49 | EFUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 50 | EFPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 51 | EFMKEY | Machine Key | String | Generic Edit | 15 | 0 | Allow NULL? |
| 52 | EFUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 53 | EFUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |