SV_Revenue_Recognition_WORK (SV00547)

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

Display Name: SV_Revenue_Recognition_WORK
Physical Name: SV00547
Technical Name: SV_Revenue_Recognition_WORK

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	YEAR1	Year	Year	Integer	4
2	PERIODID	Period ID	INT3	Integer	3
3	CUSTNMBR	Customer Number	STR15_RM_Customer_Number	String	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['SV_Revenue_Recognition_WORK'].CUSTNMBR AS 'SV_Revenue_Recognition_WORK-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SV00547 AS ['SV_Revenue_Recognition_WORK'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SV_Revenue_Recognition_WORK'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
4	ADRSCODE	Address Code	STR15_Address_Code	String	15
5	Contract_Number	WS Contract Number	STR10	String	10
6	WSCONTSQ	WS Contract Number Sequence	LI_Sequence_Number	Long Integer	10
7	Actual_Equipment	Actual Equipment	DLR14_RBS0_STR$	Currency	14
8	Actual_Material	Actual Material	DLR14_RBS0_STR$	Currency	14
9	Actual_Labor	Actual Labor	DLR14_RBS0_STR$	Currency	14
10	Actual_Subs	Actual Subs	DLR14_RBS0_STR$	Currency	14
11	Actual_Other	Actual Other	DLR14_RBS0_STR$	Currency	14
12	TTD_Billed	TTD Billed	DLR14_RBS0_STR$	Currency	14
13	YTD_Equipment	YTD Equipment	DLR14_RBS0_STR$	Currency	14
14	YTD_Material	YTD Material	DLR14_RBS0_STR$	Currency	14
15	YTD_Labor	YTD Labor	DLR14_RBS0_STR$	Currency	14
16	YTD_Subcontractor	YTD Subcontractor	DLR14_RBS0_STR$	Currency	14
17	YTD_Other	YTD Other	DLR14_RBS0_STR$	Currency	14
18	TTD_Contract_Earned	TTD Contract Earned	DLR14_RBS0_STR$	Currency	14
19	Division	Division	DDL_Division	Integer	0