SV_Contract_Task_Schedule (SV00585)

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

Display Name: SV_Contract_Task_Schedule
Physical Name: SV00585
Technical Name: SV_Contract_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_Contract_Task_Schedule'].CUSTNMBR AS 'SV_Contract_Task_Schedule-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SV00585 AS ['SV_Contract_Task_Schedule'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SV_Contract_Task_Schedule'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2	ADRSCODE	Address Code	STR15_Address_Code	String	15
3	Contract_Number	WS Contract Number	STR10	String	10
4	WSCONTSQ	WS Contract Number Sequence	LI_Sequence_Number	Long Integer	10
5	Equipment_ID	Equipment ID	STR30	String	30
6	Schedule_Date	Schedule Date	DATE	Date	6
7	Original_Schedule_Date	Original Schedule Date	DATE	Date	6
8	Schedule_Modified_Flag	Schedule Modified Flag	Boolean	Boolean	0
9	Week_of_Month	Week of Month	INT1	Integer	1
10	Day_of_the_Week	SV Day of the Week	long	Long Integer	8
11	Contract_Year	Contract Year	INT	Integer	0
12	Scheduled_Time	Scheduled Time	LI6_S2	Long Integer	6
13	Service_Call_ID	Service Call ID	STR17_LBAU	String	17
14	Estimate_Hours	Estimate Hours	LI6_S2	Long Integer	6
15	Task_Code	Task Code	STR10	String	10
16	Contract_Task_List_ID	Contract Task List ID	STR10_LBAU	String	10
17	Required	Required	CB	Boolean	0