SV_Revenue_Recognition_WORK_Archive (SVA0547)

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

Display Name: SV_Revenue_Recognition_WORK_Archive
Physical Name: SVA0547
Technical Name: SV_Revenue_Recognition_WORK_Archive

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_Archive'].CUSTNMBR AS 'SV_Revenue_Recognition_WORK_Archive-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SVA0547 AS ['SV_Revenue_Recognition_WORK_Archive'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SV_Revenue_Recognition_WORK_Archive'].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