SV_Quote_Task_Schedule (SV00548)

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

Display Name: SV_Quote_Task_Schedule
Physical Name: SV00548
Technical Name: SV_Quote_Task_Schedule

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CUSTNMBR	Customer Number	STR15_RM_Customer_Number	String	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['SV_Quote_Task_Schedule'].CUSTNMBR AS 'SV_Quote_Task_Schedule-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SV00548 AS ['SV_Quote_Task_Schedule'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SV_Quote_Task_Schedule'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2	ADRSCODE	Address Code	STR15_Address_Code	String	15
3	Quote_Number	Quote Number	STR10	String	10
4	Equipment_ID	Equipment ID	STR30	String	30
5	Schedule_Date	Schedule Date	DATE	Date	6
6	Original_Schedule_Date	Original Schedule Date	DATE	Date	6
7	Schedule_Modified_Flag	Schedule Modified Flag	Boolean	Boolean	0
8	Week_of_Month	Week of Month	INT1	Integer	1
9	Day_of_the_Week	SV Day of the Week	long	Long Integer	8
10	Contract_Year	Contract Year	INT	Integer	0
11	Scheduled_Time	Scheduled Time	LI6_S2	Long Integer	6
12	Service_Call_ID	Service Call ID	STR17_LBAU	String	17
13	Estimate_Hours	Estimate Hours	LI6_S2	Long Integer	6
14	Task_Code	Task Code	STR10	String	10
15	Quote_Task_List_ID	Quote Task List ID	STR10_LBAU	String	10
16	Required	Required	CB	Boolean	0