SV_Service_Tasks_MSTR_Archive (SVA0302)

azurecurve Products WennSoft Products (131)3rd PartySV_Service_Tasks_MSTR_Archive (SVA0302)

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

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

Display Name: SV_Service_Tasks_MSTR_Archive
Physical Name: SVA0302
Technical Name: SV_Service_Tasks_MSTR_Archive

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CUSTNMBR	Customer Number	STR15_RM_Customer_Number	String	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['SV_Service_Tasks_MSTR_Archive'].CUSTNMBR AS 'SV_Service_Tasks_MSTR_Archive-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SVA0302 AS ['SV_Service_Tasks_MSTR_Archive'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SV_Service_Tasks_MSTR_Archive'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2	ADRSCODE	Address Code	STR15_Address_Code	String	15
3	Service_Call_ID	Service Call ID	STR17_LBAU	String	17
4	Equipment_ID	Equipment ID	STR30	String	30
5	Wennsoft_Master_Equip_ID	Wennsoft Master Equipment ID	STR30	String	30
6	CMPTFLAG	Component Flag	CB_Component_Item	Boolean	0
7	Task_Line_Number	Task Line Number	LI_Sequence_Number	Long Integer	10
8	Task_Code	Task Code	STR10	String	10
9	Sub_Task_Line_Number	Sub Task Line Number	LI_Sequence_Number	Long Integer	10
10	Sub_Task_Code	Sub Task Code	STR10	String	10
11	Task_List_ID	Task List ID	STR10_LBAU	String	10
12	Task_Description	Task Description	STR60	String	60
13	Task_Description_Long	Task Description Long	STR255	String	255
14	Skill_Level	Skill Level	STR15_LBAU	String	15
15	Location_Equipment	Location Equipment	STR50_LBU	String	50
16	Completion_Date	SV Completion Date	DT	Date	8
17	Resolution_Code	Resolution Code	STR10	String	10
18	Trouble_Code	Trouble Code	STR10	String	10
19	Task_Status	Task Status	STR10_LBAU	String	10
20	System	WS System	STR15_LBAU	String	15
21	Major	WS Major	STR15_LBAU	String	15
22	Sub_1	Sub 1	STR15_LBAU	String	15
23	Sub_2	Sub 2	STR15_LBAU	String	15
24	Sub_3	Sub 3	STR15_LBAU	String	15
25	Sub_4	Sub 4	STR15_LBAU	String	15
26	Estimate_Total_Cost	Estimate Total Cost	DLR14_RBS0_STR$	Currency	14
27	Estimate_Hours	Estimate Hours	LI6_S2	Long Integer	6
28	Estimate_Labor	Estimate Labor	DLR14_RBS0_STR$	Currency	14
29	Estimate_Equipment	Estimate Equipment	DLR14_RBS0_STR$	Currency	14
30	Estimate_Material	Estimate Material	DLR14_RBS0_STR$	Currency	14
31	Estimate_Subs	Estimate Subs	DLR14_RBS0_STR$	Currency	14
32	Estimate_Other	Estimate Other	DLR14_RBS0_STR$	Currency	14
33	Estimate_Labor_1	Estimate Labor 1	DLR14_RBS0_STR$	Currency	14
34	Estimate_Labor_1_Hours	Estimate Labor 1 Hours	LI6_S2	Long Integer	6
35	Estimate_Labor_2	Estimate Labor 2	DLR14_RBS0_STR$	Currency	14
36	Estimate_Labor_2_Hours	Estimate Labor 2 Hours	LI6_S2	Long Integer	6
37	Estimate_Labor_3	Estimate Labor 3	DLR14_RBS0_STR$	Currency	14
38	Estimate_Labor_3_Hours	Estimate Labor 3 Hours	LI6_S2	Long Integer	6
39	Estimate_Labor_4	Estimate Labor 4	DLR14_RBS0_STR$	Currency	14
40	Estimate_Labor_4_Hours	Estimate Labor 4 Hours	LI6_S2	Long Integer	6
41	Estimate_Labor_5	Estimate Labor 5	DLR14_RBS0_STR$	Currency	14
42	Estimate_Labor_5_Hours	Estimate Labor 5 Hours	LI6_S2	Long Integer	6
43	Billable_Equipment	Billable Equipment	DLR14_RBS0_STR$	Currency	14
44	Billable_Material	Billable Material	DLR14_RBS0_STR$	Currency	14
45	Billable_Subs	Billable Subs	DLR14_RBS0_STR$	Currency	14
46	Billable_Other	Billable Other	DLR14_RBS0_STR$	Currency	14
47	Billable_Labor_1	Billable Labor 1	DLR14_RBS0_STR$	Currency	14
48	Billable_Labor_2	Billable Labor 2	DLR14_RBS0_STR$	Currency	14
49	Billable_Labor_3	Billable Labor 3	DLR14_RBS0_STR$	Currency	14
50	Billable_Labor_4	Billable Labor 4	DLR14_RBS0_STR$	Currency	14
51	Billable_Labor_5	Billable Labor 5	DLR14_RBS0_STR$	Currency	14
52	Material_Kit_Required	Material Kit Required	STR30_Item_Number	String	30
53	Material_Kit_Quantity	Material Kit Quantity	LI_7	Long Integer	7
54	Tool_Kit_Required	Tool Kit Required	STR15_LBAU	String	15
55	SV_Actual_Time	SV Actual Time	LI6_S2	Long Integer	6
56	Coverage_Code	Coverage Code	INT5_U0	Integer	5
57	ITEMTYPE	Item Type	DDL_Item_Type	Integer	0
58	Equipment_Type	Equipment Type	STR30	String	30
59	Wennsoft_Affiliate	Wennsoft Affiliate	STR15_LBAU	String	15
60	Wennsoft_Region	Wennsoft Region	STR15_LBAU	String	15
61	Wennsoft_Branch	Wennsoft Branch	STR15_LBAU	String	15
62	CREATDDT	Created Date	DT	Date	8
63	CRUSRID	Created User ID	STR15_User_ID	String	15
64	MODIFDT	Modified Date	DT	Date	8
65	Modified_Time	Modified Time	TM6	Time	6
66	MDFUSRID	Modified User ID	STR15	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SV_Service_Tasks_MSTR_Archive'].MDFUSRID AS 'SV_Service_Tasks_MSTR_Archive-Modified User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SVA0302 AS ['SV_Service_Tasks_MSTR_Archive'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SV_Service_Tasks_MSTR_Archive'].MDFUSRID = ['Users Master'].USERID
67	Time_Zone	Time Zone	STR3	String	3
68	Task_User_Define1	Task User Define1	STR20	String	20
69	Task_User_Define2	Task User Define2	STR20	String	20
70	Task_User_Define3	Task User Define3	STR30	String	30
71	Task_User_Define4	Task User Define4	STR30	String	30
72	Task_User_Define5	Task User Define5	LI6_S2	Long Integer	6
73	Task_User_Define6	Task User Define6	LI6_S2	Long Integer	6
74	Task_User_Define7	Task User Define7	LI6_S2	Long Integer	6
75	Task_User_Define8	Task User Define8	LI6_S2	Long Integer	6
76	Task_User_Define9	Task User Define9	DT	Date	8
77	Task_User_Define10	Task User Define10	DT	Date	8
78	Task_User_Define11	Task User Define11	DT	Date	8
79	Task_User_Define12	Task User Define12	DT	Date	8
80	Task_User_Define13	Task User Define13	DLR14_RBS0_STR$	Currency	14
81	Task_User_Define14	Task User Define14	DLR14_RBS0_STR$	Currency	14
82	Task_User_Define15	Task User Define15	DLR14_RBS0_STR$	Currency	14
83	Task_User_Define16	Task User Define16	DLR14_RBS0_STR$	Currency	14
84	Task_User_Define17	Task User Define17	DLR14_RBS0_STR$	Currency	14
85	Task_User_Define18	Task User Define18	CB	Boolean	0
86	Task_User_Define19	Task User Define19	CB	Boolean	0
87	Task_User_Define20	Task User Define20	CB	Boolean	0
88	Task_User_Define21	Task User Define21	CB	Boolean	0
89	Run_Units	Run Units	DLR14_RBS0_STR$	Currency	14
90	Current_Run_Units	Current Run Units	DLR14_RBS0_STR$	Currency	14
91	Last_Run_Units	Last Run Units	DLR14_RBS0_STR$	Currency	14
92	User_Define_1a	User Define 1a	STR30	String	30
93	Task_Comment_1	Task Comment 1	STR120	String	120
94	Task_Comment_2	Task Comment 2	STR120	String	120
95	Task_Comment_3	Task Comment 3	STR120	String	120

azurecurve Products WennSoft Products (131)3rd PartySV_Service_Tasks_MSTR_Archive (SVA0302)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply