SV_Equipment_Quicksearch_Archive (SVA0055)

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

Display Name: SV_Equipment_Quicksearch_Archive
Physical Name: SVA0055
Technical Name: SV_Equipment_Quicksearch_Archive

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	Wennsoft_Affiliate	Wennsoft Affiliate	STR15_LBAU	String	15
2	Wennsoft_Region	Wennsoft Region	STR15_LBAU	String	15
3	Wennsoft_Branch	Wennsoft Branch	STR15_LBAU	String	15
4	CUSTNMBR	Customer Number	STR15_RM_Customer_Number	String	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['SV_Equipment_Quicksearch_Archive'].CUSTNMBR AS 'SV_Equipment_Quicksearch_Archive-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SVA0055 AS ['SV_Equipment_Quicksearch_Archive'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SV_Equipment_Quicksearch_Archive'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
5	CUSTNAME	Customer Name	STR64_Customer_Name	String	64
6	ADRSCODE	Address Code	STR15_Address_Code	String	15
7	LOCATNNM	Location Name	STR30	String	30
8	Equipment_ID	Equipment ID	STR30	String	30
9	Equipment_Type	Equipment Type	STR30	String	30
10	Manufacturer_ID	Manufacturer ID	STR15_LBAU	String	15
11	Wennsoft_Serial_Number	Wennsoft Serial Number	STR40	String	40
12	Wennsoft_Model_Number	Wennsoft Model Number	STR20	String	20
13	User_Define_1a	User Define 1a	STR30	String	30
14	Location_Equipment	Location Equipment	STR50_LBU	String	50
15	Contract_Number	WS Contract Number	STR10	String	10
16	CMPTFLAG	Component Flag	CB_Component_Item	Boolean	0
17	Wennsoft_Master_Equip_ID	Wennsoft Master Equipment ID	STR30	String	30