SV_Salesperson_Mass_Reassign_Source (SV00131)

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

Display Name: SV_Salesperson_Mass_Reassign_Source
Physical Name: SV00131
Technical Name: SV_Salesperson_Mass_Reassign_Source

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	DSCRIPTN	Description	STR30	String	30
2	Description_2	Description 2	STR30	String	30
3	SEQNUMBR	Sequence Number	LI_Sequence_Number	Long Integer	10
4	CUSTNMBR	Customer Number	STR15_RM_Customer_Number	String	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['SV_Salesperson_Mass_Reassign_Source'].CUSTNMBR AS 'SV_Salesperson_Mass_Reassign_Source-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SV00131 AS ['SV_Salesperson_Mass_Reassign_Source'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SV_Salesperson_Mass_Reassign_Source'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
5	ADRSCODE	Address Code	STR15_Address_Code	String	15
6	Service_Call_ID	Service Call ID	STR17_LBAU	String	17
7	Contract_Number	WS Contract Number	STR10	String	10
8	WSCONTSQ	WS Contract Number Sequence	LI_Sequence_Number	Long Integer	10
9	USERID	User ID	STR15_User_ID	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SV_Salesperson_Mass_Reassign_Source'].USERID AS 'SV_Salesperson_Mass_Reassign_Source-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SV00131 AS ['SV_Salesperson_Mass_Reassign_Source'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SV_Salesperson_Mass_Reassign_Source'].USERID = ['Users Master'].USERID