Service Call Master History (SVC30200)

azurecurve Products FieldService (949)ProjectService Call Master History (SVC30200)

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

Display Name: Service Call Master History
Physical Name: SVC30200
Technical Name: SVC_Service_MSTR_HIST

Group Display Name: Service History Table Group
Group Technical Name: Service History

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CALLNBR	Service Call Number	String	STR10_LBAU	10
2	SRVRECTYPE	Service Record Type	Integer	DDL_Service_Record_Type	0
3	SRVSTAT	Service Call Status	String	STR3_LBU	3
4	SRVTYPE	Service Type	String	STR10_LBAU	10
5	SVCDESCR	Service Description	String	STR60	60
6	priorityLevel	priorityLevel	Integer	INT4	4
7	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['Service Call Master History'].CUSTNMBR AS 'Service Call Master History-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SVC30200 AS ['Service Call Master History'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['Service Call Master History'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
8	Customer_Reference	Customer Reference	String	STR20	20
9	ADRSCODE	Address Code	String	STR15_Address_Code	15
10	CUSTNAME	Customer Name	String	STR64_Customer_Name	64
11	ADDRESS1	Address 1	String	STR60	60
12	ADDRESS2	Address 2	String	STR60	60
13	CITY	City	String	STR35	35
14	STATE	State	String	STR30_State	29
15	ZIP	Zip	String	STR10	10
16	CNTCPRSN	Contact Person	String	STR60	60
17	PHONE1	Phone 1	String	Phone_Number	14
18	OFFID	Office ID	String	STR10_LBAU	10
19	SVCAREA	Service Area	String	STR10_LBAU	10
20	TECHID	Tech ID	String	STR10_LBAU	10
21	TIMEZONE	TimeZone	String	STR3_LBU	3
22	ENTDTE	Entry Date	Date	DT_Date	6
23	ENTTME	Entry Time	Time	TM6	6
24	Notify_Date	Notify Date	Date	DATE_L	0
25	Notify_Time	Notify Time	Time	TM6	6
26	ETADTE	ETA Date	Date	DT_Date	6
27	ETATME	ETA Time	Time	TM6	6
28	DISPDTE	Dispatch Date	Date	DT_Date	6
29	DISPTME	Dispatch Time	Time	TM6	6
30	ARRIVDTE	Arrival Date	Date	DT_Date	6
31	ARRIVTME	Arrival Time	Time	TM6	6
32	COMPDTE	Complete Date	Date	DT_Date	6
33	COMPTME	Complete Time	Time	TM6	6
34	Response_Date	Response Date	Date	DT_Date	6
35	Response_Time	Response Time	Time	TM6	6
36	PRICELVL	Price Level	String	STR15_LBAU	15
37	PYMTRMID	Payment Terms ID	String	STR20_Payment_Terms_ID	20
	Key to the Payment Terms Master (SY03300). Click to show/hide SELECT ['Service Call Master History'].PYMTRMID AS 'Service Call Master History-Payment Terms ID' ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID' FROM SVC30200 AS ['Service Call Master History'] INNER JOIN SY03300 AS ['Payment Terms Master'] ON ['Service Call Master History'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
38	SLPRSNID	Salesperson ID	String	STR15_Salesperson_ID	15
	Key to the RM Salesperson Master (RM00301). Click to show/hide SELECT ['Service Call Master History'].SLPRSNID AS 'Service Call Master History-Salesperson ID' ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID' FROM SVC30200 AS ['Service Call Master History'] INNER JOIN RM00301 AS ['RM Salesperson Master'] ON ['Service Call Master History'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
39	LABSTOTPRC	Labor Sub Total Price	Currency	DLR17_RBS0_STR$	17
40	LABPCT	Labor Pct	Currency	DLR5_%2	8
41	LABSTOTCST	Labor Sub Total Cost	Currency	DLR17_RBS0_STR$	17
42	PARSTOTPRC	Part Sub Total Price	Currency	DLR17_RBS0_STR$	17
43	PARTPCT	Part Pct	Currency	DLR5_%2	8
44	PARSTOTCST	Part Sub Total Cost	Currency	DLR17_RBS0_STR$	17
45	MSCSTOTPRC	Misc Sub Total Price	Currency	DLR17_RBS0_STR$	17
46	MISCPCT	Misc Pct	Currency	DLR5_%2	8
47	MISSTOTCST	Misc Sub Total Cost	Currency	DLR17_RBS0_STR$	17
48	TAXSCHID	Tax Schedule ID	String	STR15_Tax_Schedule_ID	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Service Call Master History'].TAXSCHID AS 'Service Call Master History-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM SVC30200 AS ['Service Call Master History'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Service Call Master History'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
49	TAXEXMT1	Tax Exempt 1	String	STR25	25
50	TAXEXMT2	Tax Exempt 2	String	STR25	25
51	PRETAXTOT	PreTax Total	Currency	DLR17_RBS0_STR$	17
52	TAXAMNT	Tax Amount	Currency	DLR17_RBS0_UTR$	17
53	TOTAL	Total	Currency	Dollar19	19
54	Invoiced_Amount	Invoiced Amount	Currency	DLR19_$U2	19
55	METER1	Meter 1	Long Integer	LI_Meter_Reading	8
56	METER2	Meter 2	Long Integer	LI_Meter_Reading	8
57	METER3	Meter 3	Long Integer	LI_Meter_Reading	8
58	PORDNMBR	Purchase Order Number	String	Purchase Order Number	20
59	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Service Call Master History'].NOTEINDX AS 'Service Call Master History-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM SVC30200 AS ['Service Call Master History'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Service Call Master History'].NOTEINDX = ['Record Notes Master'].NOTEINDX
60	NOTFYFLAG	Notify Flag	Boolean	CB	0
61	USERDEF1	User Defined 1	String	STR20	20
62	USERDEF2	User Defined 2	String	STR20	20
63	USRDEF03	User Defined 3	String	STR20	20
64	USRDEF04	User Defined 4	String	STR20	20
65	USRDEF05	User Defined 5	String	STR20	20
66	MSTRRECTYPE	Master Service Record Type	Integer	DDL_Service_Record_Type	0
67	MSTRCALLNBR	Master Service Call Number	String	STR10	10
68	ESCDATE	Escalation Date	Date	DT_Date	6
69	ESCTIME	Escalation Time	Time	TM6	6
70	Escalation_Level	Escalation Level	Long Integer	LI_Sequence_Number	10
71	SPLTTERMS	Split Terms Code	String	STR10_LBAU	10
72	Callback	Callback	Boolean	CB	0
73	PROJCTID	Project ID	String	STR15	15
74	ProjectRef1	ProjectRef1	STR15	String	15
75	ProjectRef1_1	ProjectRef1[1]	String	STR15	15
76	ProjectRef1_2	ProjectRef1[2]	String	STR15	15
77	ProjectRef1_3	ProjectRef1[3]	String	STR15	15
78	ProjectRef1_4	ProjectRef1[4]	String	STR15	15
79	CONSTS	Contract Record Type	Integer	DDL_Contract_Status	0
80	CONTNBR	Contract Number	String	STR11	11
81	SVC_Contract_Line_SEQ	SVC_Contract_Line_SEQ_Number	Currency	Sequence_Number	19
82	ETTR	ETTR	Currency	CURR_MTTR	10
83	SVC_On_Hold	SVC On Hold	Boolean	SVC On Hold	0
84	Print_to_Web	Print to Web	Boolean	CB	0
85	Meters_1	Meters[1]	Long Integer	LI_Meter_Reading	8
86	Meters_2	Meters[2]	Long Integer	LI_Meter_Reading	8
87	Meters	Meters	LI_Meter_Reading	Long Integer	8
88	Meters_3	Meters[3]	Long Integer	LI_Meter_Reading	8
89	Meters_4	Meters[4]	Long Integer	LI_Meter_Reading	8
90	Meters_5	Meters[5]	Long Integer	LI_Meter_Reading	8
91	Meter_Internal_Uses_1	Meter Internal Uses[1]	Long Integer	LI_Meter_Reading	8
92	Meter_Internal_Uses_2	Meter Internal Uses[2]	Long Integer	LI_Meter_Reading	8
93	Meter_Internal_Uses	Meter Internal Uses	LI_Meter_Reading	Long Integer	8
94	Meter_Internal_Uses_3	Meter Internal Uses[3]	Long Integer	LI_Meter_Reading	8
95	Meter_Internal_Uses_4	Meter Internal Uses[4]	Long Integer	LI_Meter_Reading	8
96	Meter_Internal_Uses_5	Meter Internal Uses[5]	Long Integer	LI_Meter_Reading	8
97	Bill_To_Customer	Bill To Customer	String	STR15_RM_Customer_Number	15
98	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Service Call Master History'].CURNCYID AS 'Service Call Master History-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM SVC30200 AS ['Service Call Master History'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Service Call Master History'].CURNCYID = ['Currency Setup'].CURNCYID
99	SVC_Bill_To_Address_Code	SVC Bill To Address Code	String	STR15_Address_Code	15
100	CURRNIDX	Currency Index	Integer	INT3	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Service Call Master History'].CURRNIDX AS 'Service Call Master History-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM SVC30200 AS ['Service Call Master History'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Service Call Master History'].CURRNIDX = ['Currency Setup'].CURRNIDX
101	RATETPID	Rate Type ID	String	STR15_Rate_Type_ID	15
	Key to the Multicurrency Rate Type Setup (MC40100). Click to show/hide SELECT ['Service Call Master History'].RATETPID AS 'Service Call Master History-Rate Type ID' ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID' FROM SVC30200 AS ['Service Call Master History'] INNER JOIN MC40100 AS ['Multicurrency Rate Type Setup'] ON ['Service Call Master History'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
102	EXGTBLID	Exchange Table ID	String	STR15_Exchange_Table_ID	15
	Key to the Multicurrency Exchange Rate Maintenance (MC00100). Click to show/hide SELECT ['Service Call Master History'].EXGTBLID AS 'Service Call Master History-Exchange Table ID' ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID' FROM SVC30200 AS ['Service Call Master History'] INNER JOIN DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance'] ON ['Service Call Master History'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
103	XCHGRATE	Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
104	EXCHDATE	Exchange Date	Date	DT_Date	6
105	DECPLACS	Decimal Places	Integer	DDL_Decimal_Places	0
106	TIME1	Time	Time	TM6	6
107	RATECALC	Rate Calc Method	Integer	INT	0
108	VIEWMODE	View Mode	Integer	INT	0
109	ISMCTRX	IS MC Trx	Integer	INT	0
110	EXPNDATE	Expiration Date	Date	DT_Date	6
111	DENXRATE	Denomination Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
112	MCTRXSTT	MC Transaction State	Integer	INT1	1
113	ORIGMISSTOTCST	Originating Misc Sub Total Cost	Currency	DLR17_RBS0_STR$	17
114	ORIGMSCSTOTPRC	Originating Misc Sub Total Price	Currency	DLR17_RBS0_STR$	17
115	ORIGLABSUBTOTCOST	Originating Labor Sub Total Cost	Currency	DLR17_RBS0_STR$	17
116	ORIGLABSTOTPRC	Originating Labor Sub Total Price	Currency	DLR17_RBS0_STR$	17
117	ORIGPARSTOTCST	Originating Part Sub Total Cost	Currency	DLR17_RBS0_STR$	17
118	ORIGPARSTOTPRC	Originating Part Sub Total Price	Currency	DLR17_RBS0_STR$	17
119	ORIGPRETAXTOT	Originating PreTax Total	Currency	DLR17_RBS0_STR$	17
120	ORTAXAMT	Originating Tax Amount	Currency	DLR17_RBS0_UTR$	17
121	ORIGTOTAL	Originating Service Total	Currency	Dollar19	19
122	Orig_Invoiced_Amount	Originating Invoiced Amount	Currency	DLR19_$U2	19
123	ADDRESS3	Address 3	String	STR60	60
124	COUNTRY	Country	String	STR60	60
125	SVC_Pre600	SVC_Pre600	Boolean	CB	0
126	SVC_FO_ID	SVC FO ID	String	STR50	50
127	Replaces_1	Replaces[1]	Boolean	CB	0
128	Replaces_2	Replaces[2]	Boolean	CB	0
129	Replaces_3	Replaces[3]	Boolean	CB	0
130	Replaces	Replaces	CB	Boolean	0
131	Replaces_4	Replaces[4]	Boolean	CB	0
132	Replaces_5	Replaces[5]	Boolean	CB	0
133	Workflow_Approval_Status	Workflow Approval Status	Integer	DDL_WorkflowApprovalStatus	0
134	Workflow_Priority	Workflow Priority	Integer	DDL_WorkflowPriority	0

azurecurve Products FieldService (949)ProjectService Call Master History (SVC30200)

Leave a Reply Cancel reply