System Configuration (SVC00303)

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

Display Name: System Configuration
Physical Name: SVC00303
Technical Name: SVC_Serial_MSTR_System

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['System Configuration'].CUSTNMBR AS 'System Configuration-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SVC00303 AS ['System Configuration'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['System Configuration'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2	ADRSCODE	Address Code	String	STR15_Address_Code	15
3	EQUIPID	Equipment ID	Long Integer	Long Int	8
4	SERLNMBR	Serial Number	String	STR20_LBAU	20
5	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['System Configuration'].ITEMNMBR AS 'System Configuration-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM SVC00303 AS ['System Configuration'] INNER JOIN IV00101 AS ['Item Master'] ON ['System Configuration'].ITEMNMBR = ['Item Master'].ITEMNMBR
6	ITEMDESC	Item Description	String	STR100	100
7	INSTDTE	Install Date	Date	DT_Date	6
8	QUANTITY	QTY	Currency	DLR17_QTY_RBS0_STR	17
9	CNFGLVL	Config Level	Integer	INT4	4
10	CNFGSEQ	Config Sequence	Integer	INT4	4
11	PARLEVEL	Parent Level	Integer	INT4	4
12	PARSEQ	Parent Sequence	Integer	INT4	4
13	CHDFLAG	Child Flag	Boolean	Boolean	0