...
Tab Position (.txt file) | Excel Column (.csv file) | Field Name | Storage Type | Keyable | Storage |
---|---|---|---|---|---|
1 | A | *Customer Number | String | 15 | 16 |
2 | B | *Address Code | String | 15 | 16 |
3 | C | *Equipment ID | String | 30 | 30 |
4 | D | User ID | String | 15 | 16 |
5 | E | Technician ID | String | 15 | 16 |
6 | F | Technician Team | String | 15 | 16 |
7 | G | Signature Wennsoft Master Equipment ID | String | 15 | 16 |
8 | H | Component Flag | Check Box | 1 | 2 |
9 | I | Component Qty | Integer | 4 | 2 |
10 | J | Corporate Customer Number | String | 15 | 16 |
11 | K | **Manufacturer ID | String | 15 | 16 |
12 | L | **Equipment Type | String | 30 | 32 |
13 | M | Signature Wennsoft Model Number | String | 20 | 22 |
14 | N | Signature Wennsoft Serial Number | String | 40 | 42 |
15 | O | Installed By Long Description | String | 40 | 42 |
16 | P | Extended Warranty Type | String | 30 | 32 |
17 | Q | Extended Warranty Expiration | Date | 8 | 4 |
18 | R | Warranty Expiration | Date | 8 | 4 |
19 | S | Install Date | Date | 8 | 4 |
20 | T | Location Equipment | String | 50 | 52 |
21 | U | Contract Number | String | 10 | 12 |
22 | V | User Define 1a | String | 30 | 32 |
23 | W | User Define 2a | String | 30 | 32 |
24 | X | User Define 3a | String | 30 | 32 |
25 | Y | User Define 4a | String | 30 | 32 |
26 | Z | User Define 5a | String | 30 | 32 |
27 | AA | User Define 9a | Date | 8 | 4 |
28 | AB | Start Up Date | Date | 6 | 4 |
29 | AC | Shutdown Month | Integer | 2 | 2 |
30 | AD | Startup Month | Integer | 2 | 2 |
31 | AE | Operating Hours Per Month | Integer | 4 | 2 |
32 | AF | Total Controls Per Unit | Integer | 4 | 2 |
33 | AG | Total Controls Qty | Integer | 4 | 2 |
34 | AH | Shutdown Jan | Integer | 2 | 2 |
35 | AI | Shutdown Feb | Integer | 2 | 2 |
36 | AJ | Shutdown Mar | Integer | 2 | 2 |
37 | AK | Shutdown Apr | Integer | 2 | 2 |
38 | AL | Shutdown May | Integer | 2 | 2 |
39 | AM | Shutdown Jun | Integer | 2 | 2 |
40 | AN | Shutdown Jul | Integer | 2 | 2 |
41 | AO | Shutdown Aug | Integer | 2 | 2 |
42 | AP | Shutdown Sep | Integer | 2 | 2 |
43 | AQ | Shutdown Oct | Integer | 2 | 2 |
44 | AR | Shutdown Nov | Integer | 2 | 2 |
45 | AS | Shutdown Dec | Integer | 2 | 2 |
46 | AT | Auto Date | Date | 6 | 4 |
47 | AU | PM Group | String | 3 | 4 |
48 | AV | ID 1 | String | 10 | 12 |
49 | AW | ID 2 | String | 10 | 12 |
50 | AX | Service User Define 1 | String | 20 | 22 |
51 | AY | Service User Define 2 | String | 20 | 22 |
52 | AZ | Service User Define 3 | String | 30 | 32 |
53 | BA | Service User Define 4 | String | 30 | 32 |
54 | BB | Service User Define 5 | Long Integer | 6 | 4 |
55 | BC | Service User Define 6 | Long Integer | 6 | 4 |
56 | BD | Service User Define 7 | Long Integer | 6 | 4 |
57 | BE | Service User Define 8 | Long Integer | 6 | 4 |
58 | BF | Service User Define 9 | Date | 8 | 4 |
59 | BG | Service User Define 10 | Date | 8 | 4 |
60 | BH | Service User Define 11 | Date | 8 | 4 |
61 | BI | Service User Define 12 | Date | 8 | 4 |
62 | BJ | Service User Define 18 | Check Box | 1 | 2 |
63 | BK | Service User Define 19 | Check Box | 1 | 2 |
64 | BL | Service User Define 20 | Check Box | 1 | 2 |
65 | BM | Service User Define 21 | Check Box | 1 | 2 |
66 | BN | Service User Define 22 | Currency | 14 | 10 |
67 | BO | Service User Define 23 | Currency | 14 | 10 |
68 | BP | Service User Define 24 | Currency | 14 | 10 |
69 | BQ | Service User Define 25 | Currency | 14 | 10 |
70 | BR | Out of Service Flag | Check Box | 1 | 2 |
71 | BS | Out of Service Date | Date | 1 | 2 |
72 | BT | Out of Service Time | Time | 6 | 4 |
73 | BU | Out of Service By | String | 15 | 16 |
74 | BV | Out of Service Reason | String | 30 | 32 |
75 | BW | WSBarCodeID | String | 50 | 50 |
76 | BX | Startup By | String | 50 | 50 |
77 | BY | Startup Job Number | String | 17 | 17 |
78 | BZ | Shipped Date | Date | ||
79 | CA | Vibration Date | Date | ||
80 | CB | Overhaul Date | Date | ||
81 | CC | ECT Date | Date | ||
82 | CD | Conversion Date | Date | ||
83 | CE | Blanket PO Check Box | Tiny Integer | ||
84 | CF | Blanket PO Number | String | 17 | 17 |
85 | CG | Original Blanket PO Amount | Currency | ||
86 | CH | Blanket PO Amount Spent | Currency | ||
87 | CI | Blanket PO Amount Remaining | Currency | ||
88 | CJ | Blanket PO Expiration Date | Date |