SV_Equipment_MSTR_Archive (SVA0400)

azurecurve Products WennSoft Products (131)3rd PartySV_Equipment_MSTR_Archive (SVA0400)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVA0400

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: SV_Equipment_MSTR_Archive
Physical Name: SVA0400
Technical Name: SV_Equipment_MSTR_Archive

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	ADRSCODE	Address Code	STR15_Address_Code	String	15
2	CUSTNMBR	Customer Number	STR15_RM_Customer_Number	String	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['SV_Equipment_MSTR_Archive'].CUSTNMBR AS 'SV_Equipment_MSTR_Archive-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SVA0400 AS ['SV_Equipment_MSTR_Archive'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SV_Equipment_MSTR_Archive'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
3	Equipment_ID	Equipment ID	STR30	String	30
4	Wennsoft_Affiliate	Wennsoft Affiliate	STR15_LBAU	String	15
5	Wennsoft_Region	Wennsoft Region	STR15_LBAU	String	15
6	Wennsoft_Branch	Wennsoft Branch	STR15_LBAU	String	15
7	USERID	User ID	STR15_User_ID	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SV_Equipment_MSTR_Archive'].USERID AS 'SV_Equipment_MSTR_Archive-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SVA0400 AS ['SV_Equipment_MSTR_Archive'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SV_Equipment_MSTR_Archive'].USERID = ['Users Master'].USERID
8	Technician_ID	Technician ID	STR15_Employee_ID	String	15
9	Technician_Team	Technician Team	STR15_LBAU	String	15
10	Wennsoft_Master_Equip_ID	Wennsoft Master Equipment ID	STR30	String	30
11	CMPTFLAG	Component Flag	CB_Component_Item	Boolean	0
12	Component_Qty	Component Qty	INT5	Integer	4
13	CPRCSTNM	Corporate Customer Number	STR15_RM_Customer_Number	String	15
14	Manufacturer_ID	Manufacturer ID	STR15_LBAU	String	15
15	Equipment_Type	Equipment Type	STR30	String	30
16	Wennsoft_Model_Number	Wennsoft Model Number	STR20	String	20
17	Wennsoft_Serial_Number	Wennsoft Serial Number	STR40	String	40
18	Equip_Description_Long	Equip Description Long	STR255	String	255
19	Installed_By_Long_Desc	Installed By Long Description	STR40	String	40
20	Extended_Warranty_Type	Extended Warranty Type	STR30	String	30
21	Extended_Warr_Expiration	Extended Warranty Experation	DT	Date	8
22	Warranty_Expiration	Warranty Experation	DT	Date	8
23	Install_Date	Install Date	DT	Date	8
24	Location_Equipment	Location Equipment	STR50_LBU	String	50
25	Contract_Number	WS Contract Number	STR10	String	10
26	Bar_Code_ID	WSBarCodeID	STR50	String	50
27	OptimalCharge	OptimalCharge	DLR14_TS2	Currency	14
28	RefrigerantTypeID	RefrigerantTypeID	LI	Long Integer	0
29	User_Define_1a	User Define 1a	STR30	String	30
30	User_Define_2a	User Define 2a	STR30	String	30
31	User_Define_3a	User Define 3a	STR30	String	30
32	User_Define_4a	User Define 4a	STR30	String	30
33	User_Define_5a	User Define 5a	STR30	String	30
34	User_Define_9a	User Define 9a	DT	Date	8
35	Start_Up_Date	Start Up Date	DATE	Date	6
36	Shutdown_Month	Shutdown Month	INT2	Integer	2
37	Startup_Month	Startup Month	INT2	Integer	2
38	Operating_Hrs_Per_Month	Operating Hours Per Month	INT5	Integer	4
39	Total_Controls_Per_Unit	Total Controls Per Unit	INT5	Integer	4
40	Total_Controls_Qty	Total Controls Qty	INT5	Integer	4
41	Shutdown_Jan	Shutdown Jan	INT2	Integer	2
42	Shutdown_Feb	Shutdown Feb	INT2	Integer	2
43	Shutdown_Mar	Shutdown Mar	INT2	Integer	2
44	Shutdown_Apr	Shutdown Apr	INT2	Integer	2
45	Shutdown_May	Shutdown May	INT2	Integer	2
46	Shutdown_Jun	Shutdown Jun	INT2	Integer	2
47	Shutdown_Jul	Shutdown Jul	INT2	Integer	2
48	Shutdown_Aug	Shutdown Aug	INT2	Integer	2
49	Shutdown_Sep	Shutdown Sep	INT2	Integer	2
50	Shutdown_Oct	Shutdown Oct	INT2	Integer	2
51	Shutdown_Nov	Shutdown Nov	INT2	Integer	2
52	Shutdown_Dec	Shutdown Dec	INT2	Integer	2
53	Auto_Date	Auto Date	DATE	Date	6
54	PM_Group	PM Group	STR3_LBAU	String	3
55	ID_1	ID 1	STR10_LBAU	String	10
56	ID_2	ID 2	STR10_LBAU	String	10
57	Startup_By	Startup By	STR50	String	50
58	Startup_Job_Number	Startup Job Number	STR17_LBAU	String	17
59	Shipped_Date	Shipped Date	DATE	Date	6
60	Vibration_Date	Vibration Date	DATE	Date	6
61	Overhaul_Date	Overhaul Date	DATE	Date	6
62	ECT_Date	ECT Date	DATE	Date	6
63	Conversion_Date	Conversion Date	DATE	Date	6
64	Blanket_PO_CB	Blanket PO Checkbox	CB	Boolean	0
65	Blanket_PO_Number	Blanket PO Number	STR17	String	17
66	Orig_Blanket_PO_Amt	Original Blanket PO Amount	DLR19_RBS0_STR$	Currency	19
67	Blanket_PO_Amt_Spent	Blanket PO Amount Spent	DLR19_RBS0_STR$	Currency	19
68	Blanket_PO_Amt__Remainin	Blanket PO Amount Remaining	DLR19_RBS0_STR$	Currency	19
69	Blanket_PO_Exp_Date	Blanket PO Expiration Date	DATE	Date	6
70	Service_User_Define_1	Service User Define 1	STR20	String	20
71	Service_User_Define_2	Service User Define 2	STR20	String	20
72	Service_User_Define_3	Service User Define 3	STR30	String	30
73	Service_User_Define_4	Service User Define 4	STR30	String	30
74	Service_User_Define_5	Service User Define 5	LI6_S2	Long Integer	6
75	Service_User_Define_6	Service User Define 6	LI6_S2	Long Integer	6
76	Service_User_Define_7	Service User Define 7	LI6_S2	Long Integer	6
77	Service_User_Define_8	Service User Define 8	LI6_S2	Long Integer	6
78	Service_User_Define_9	Service User Define 9	DT	Date	8
79	Service_User_Define_10	Service User Define 10	DT	Date	8
80	Service_User_Define_11	Service User Define 11	DT	Date	8
81	Service_User_Define_12	Service User Define 12	DT	Date	8
82	Service_User_Define_18	Service User Define 18	CB	Boolean	0
83	Service_User_Define_19	Service User Define 19	CB	Boolean	0
84	Service_User_Define_20	Service User Define 20	CB	Boolean	0
85	Service_User_Define_21	Service User Define 21	CB	Boolean	0
86	Service_User_Define_22	Service User Define 22	DLR14_RBS0_STR$	Currency	14
87	Service_User_Define_23	Service User Define 23	DLR14_RBS0_STR$	Currency	14
88	Service_User_Define_24	Service User Define 24	DLR14_RBS0_STR$	Currency	14
89	Service_User_Define_25	Service User Define 25	DLR14_RBS0_STR$	Currency	14
90	MODIFDT	Modified Date	DT	Date	8
91	Modified_Time	Modified Time	TM6	Time	6
92	MDFUSRID	Modified User ID	STR15	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SV_Equipment_MSTR_Archive'].MDFUSRID AS 'SV_Equipment_MSTR_Archive-Modified User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SVA0400 AS ['SV_Equipment_MSTR_Archive'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SV_Equipment_MSTR_Archive'].MDFUSRID = ['Users Master'].USERID
93	Time_Zone	Time Zone	STR3	String	3
94	WSReserved_CB1	WSReserved CB1	CB	Boolean	0
95	WSReserved_CB2	WSReserved CB2	CB	Boolean	0
96	WSReserved_CB3	WSReserved CB3	CB	Boolean	0
97	WSReserved_CB4	WSReserved CB4	CB	Boolean	0
98	WSReserved_CB5	WSReserved CB5	CB	Boolean	0
99	WSReserved_CB6	WSReserved CB6	CB	Boolean	0
100	WSReserved_CB7	WSReserved CB7	CB	Boolean	0
101	WSReserved_CB8	WSReserved CB8	CB	Boolean	0
102	WSReserved_CB9	WSReserved CB9	CB	Boolean	0
103	WSReserved_CB10	WSReserved CB10	CB	Boolean	0
104	WSReserved_STR1	WSReserved STR1	STR10	String	10
105	WSReserved_STR2	WSReserved STR2	STR10	String	10
106	Out_of_Service_Flag	Out of Service Flag	CB_Out_Of_Service_Flag	Boolean	0
107	Out_of_Service_Date	Out of Service Date	DATE	Date	6
108	Out_of_Service_Time	Out of Service Time	TM6	Time	6
109	Out_of_Service_By	Out of Service By	STR15	String	15
110	Out_of_Service_Reason	Out of Service Reason	STR30	String	30
111	Inactive_Retired_Flag	Inactive/Retired Flag	CB_Inactive/Retired	Boolean	0
112	Equipment_Description2	Equipment Description2	STR50	String	50
113	ITEMNMBR	Item Number	STR30_Item_Number	String	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['SV_Equipment_MSTR_Archive'].ITEMNMBR AS 'SV_Equipment_MSTR_Archive-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM SVA0400 AS ['SV_Equipment_MSTR_Archive'] INNER JOIN IV00101 AS ['Item Master'] ON ['SV_Equipment_MSTR_Archive'].ITEMNMBR = ['Item Master'].ITEMNMBR
114	SERLNMBR	Serial Number	STR20_LBAU	String	20

azurecurve Products WennSoft Products (131)3rd PartySV_Equipment_MSTR_Archive (SVA0400)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply