Serial Master (SVC00300)

azurecurve Products FieldService (949)ProjectSerial Master (SVC00300)

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

Display Name: Serial Master
Physical Name: SVC00300
Technical Name: SVC_Serial_MSTR

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	EQUIPID	Equipment ID	Long Integer	Long Int	8
2	SERLNMBR	Serial Number	String	STR20_LBAU	20
3	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['Serial Master'].ITEMNMBR AS 'Serial Master-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM SVC00300 AS ['Serial Master'] INNER JOIN IV00101 AS ['Item Master'] ON ['Serial Master'].ITEMNMBR = ['Item Master'].ITEMNMBR
4	REFRENCE	Reference	String	STR30	30
5	Version	Version	String	STR20	20
6	SRLSTAT	Equipment Status	String	STR10_LBAU	10
7	INSTDTE	Install Date	Date	DT_Date	6
8	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['Serial Master'].CUSTNMBR AS 'Serial Master-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SVC00300 AS ['Serial Master'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['Serial Master'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
9	ADRSCODE	Address Code	String	STR15_Address_Code	15
10	ADDRESS1	Address 1	String	STR60	60
11	ADDRESS2	Address 2	String	STR60	60
12	CITY	City	String	STR35	35
13	STATE	State	String	STR30_State	29
14	ZIP	Zip	String	STR10	10
15	COUNTRY	Country	String	STR60	60
16	CNTCPRSN	Contact Person	String	STR60	60
17	LSTPMDTE	Last PM Date	Date	DT_Date	6
18	LSTSRVDTE	Last Service Date	Date	DT_Date	6
19	TECHID	Tech ID	String	STR10_LBAU	10
20	TECHID2	Tech ID2	String	STR10_LBAU	10
21	OFFID	Office ID	String	STR10_LBAU	10
22	SVCAREA	Service Area	String	STR10_LBAU	10
23	TIMEZONE	TimeZone	String	STR3_LBU	3
24	WARRCDE	Warranty Code	String	STR10_LBAU	10
25	WARREND	Warranty End	Date	DT_Date	6
26	WARRSTART	Warranty Start	Date	DT_Date	6
27	SLRWARR	Seller Warranty Code	String	STR10_LBAU	10
28	SLRWEND	Seller Warranty End	Date	DT_Date	6
29	SLRWSTART	Seller Warranty Start	Date	DT_Date	6
30	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Serial Master'].NOTEINDX AS 'Serial Master-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM SVC00300 AS ['Serial Master'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Serial Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
31	MTTR	MTTR	Currency	CURR_MTTR	10
32	MTBF	MTBF	Currency	CURR_MTTR	10
33	MTBI	MTBI	Currency	CURR_MTTR	10
34	Last_Calc_Date	Last Calc Date	Date	DATE_L	0
35	Meters	Meters	LI_Meter_Reading	Long Integer	8
36	Meters_1	Meters[1]	Long Integer	LI_Meter_Reading	8
37	Meters_2	Meters[2]	Long Integer	LI_Meter_Reading	8
38	Meters_3	Meters[3]	Long Integer	LI_Meter_Reading	8
39	Meters_4	Meters[4]	Long Integer	LI_Meter_Reading	8
40	Meters_5	Meters[5]	Long Integer	LI_Meter_Reading	8
41	Dailys_1	Dailys[1]	Currency	Consumption_Rate	0
42	Dailys_2	Dailys[2]	Currency	Consumption_Rate	0
43	Dailys	Dailys	Consumption_Rate	Currency	0
44	Dailys_3	Dailys[3]	Currency	Consumption_Rate	0
45	Dailys_4	Dailys[4]	Currency	Consumption_Rate	0
46	Dailys_5	Dailys[5]	Currency	Consumption_Rate	0
47	MTBFs_1	MTBFs[1]	Currency	CURR_MTTR	10
48	MTBFs_2	MTBFs[2]	Currency	CURR_MTTR	10
49	MTBFs	MTBFs	CURR_MTTR	Currency	10
50	MTBFs_3	MTBFs[3]	Currency	CURR_MTTR	10
51	MTBFs_4	MTBFs[4]	Currency	CURR_MTTR	10
52	MTBFs_5	MTBFs[5]	Currency	CURR_MTTR	10
53	Meter_Deltas_1	Meter_Deltas[1]	Long Integer	LI_Meter_Reading	8
54	Meter_Deltas_2	Meter_Deltas[2]	Long Integer	LI_Meter_Reading	8
55	Meter_Deltas_3	Meter_Deltas[3]	Long Integer	LI_Meter_Reading	8
56	Meter_Deltas_4	Meter_Deltas[4]	Long Integer	LI_Meter_Reading	8
57	Meter_Deltas	Meter_Deltas	LI_Meter_Reading	Long Integer	8
58	Meter_Deltas_5	Meter_Deltas[5]	Long Integer	LI_Meter_Reading	8
59	SVC_PM_Date	SVC PM Month	Integer	SVC_DDL_Month	0
60	SVC_PM_Day	SVC PM Day	Integer	SVC_PM_Day	2
61	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['Serial Master'].VENDORID AS 'Serial Master-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM SVC00300 AS ['Serial Master'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['Serial Master'].VENDORID = ['PM Vendor Master File'].VENDORID
62	ADDRESS3	Address 3	String	STR60	60
63	USERDEF1	User Defined 1	String	STR20	20
64	USERDEF2	User Defined 2	String	STR20	20
65	USRDEF03	User Defined 3	String	STR20	20
66	USRDEF04	User Defined 4	String	STR20	20
67	USRDEF05	User Defined 5	String	STR20	20
68	SVC_Serial_ID	SVC Serial ID	String	STR20_LBAU	20
69	QUANTITY	QTY	Currency	DLR17_QTY_RBS0_STR	17
70	SVC_Asset_Tag	SVC Asset Tag	String	STR20_LBAU	20
71	Shipped_Date	Shipped Date	Date	DT_Date	6
72	SVC_Register_Date	SVC Register Date	Date	DT_Date	6
73	SOPNUMBE	SOP Number	String	STR20_SOP_Number	17

azurecurve Products FieldService (949)ProjectSerial Master (SVC00300)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply