SV_Broadcast_Warehouse_MSTR (SV333333)

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

Display Name: SV_Broadcast_Warehouse_MSTR
Physical Name: SV333333
Technical Name: SV_Broadcast_Warehouse_MSTR

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	Service_Call_ID	Service Call ID	STR17_LBAU	String	17
2	CUSTNMBR	Customer Number	STR15_RM_Customer_Number	String	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['SV_Broadcast_Warehouse_MSTR'].CUSTNMBR AS 'SV_Broadcast_Warehouse_MSTR-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SV333333 AS ['SV_Broadcast_Warehouse_MSTR'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SV_Broadcast_Warehouse_MSTR'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
3	ADRSCODE	Address Code	STR15_Address_Code	String	15
4	ADDRESS1	Address 1	STR60	String	60
5	ADDRESS2	Address 2	STR60	String	60
6	CITY	City	STR35	String	35
7	STATE	State	STR30_State	String	29
8	ZIP	Zip	STR10	String	10
9	COUNTRY	Country	STR60	String	60
10	Service_Description	Service Description	STR30_LBAU	String	30
11	Type_of_Problem	Type of Problem	STR30	String	30
12	Date_of_Service_Call	Date of Service Call	DT	Date	8
13	Type_Call_Short	Type Call Short	STR3_LBAU	String	3
14	Priority_of_Call	Priority of Call	STR1	String	1
15	User_Define_1a	User Define 1a	STR30	String	30
16	User_Define_2a	User Define 2a	STR30	String	30
17	User_Define_3a	User Define 3a	STR30	String	30
18	User_Define_4a	User Define 4a	STR30	String	30
19	Status_of_Call	Status of Call	STR10_LBAU	String	10
20	Completion_Date	SV Completion Date	DT	Date	8
21	Technician	Technician	STR10_LBAU	String	10
22	Scheduled_Time	Scheduled Time	LI6_S2	Long Integer	6