Equipment Master File

Import File: SVEQ0001.CSV (Comma) or SVEQ0001.TXT (Tab)
Warehouse File: SV_Equipment_MSTR_IMP_WHSE
Destination File: SV_Equipment_MSTR(SV00400)
Quicksearch File: SV_Equipment_Quicksearch (SV00055)

*Indicates validated fields, and must contain data.

*Indicates validated fields, but can be left empty.

If importing equipment groups, 'Wennsoft Master Equipment ID' (7,G) for all group items must be the same as the lead item's 'Equipment ID' (3,C). The lead item's 'Component Flag' (8,H) must be 0 and 'Wennsoft Master Equipment ID' (7,G) must be blank. The group items' 'Component Flag' (8,H) must be 1.

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 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 Model Number	String	20	22
14	N	Signature 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