SV_Master_Contract_Amt_Summary (SV90010)

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

Display Name: SV_Master_Contract_Amt_Summary
Physical Name: SV90010
Technical Name: SV_Master_Contract_Amt_Summary

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_Master_Contract_Amt_Summary'].CUSTNMBR AS 'SV_Master_Contract_Amt_Summary-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SV90010 AS ['SV_Master_Contract_Amt_Summary'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SV_Master_Contract_Amt_Summary'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2	ADRSCODE	Address Code	STR15_Address_Code	String	15
3	Corporate_Contract_Nbr	Corporate Contract Number	STR20_LBAU	String	20
4	WSMSTRCONTSQ	WS Master Contract Seq Number	LI_Sequence_Number	Long Integer	10
5	Contract_Number	WS Contract Number	STR10	String	10
6	WSCONTSQ	WS Contract Number Sequence	LI_Sequence_Number	Long Integer	10
7	Contract_Amount	Contract Amount	DLR14_RBS0_UTR$	Currency	14
8	Billing_Equipment	Billing Equipment	DLR14_RBS0_STR$	Currency	14
9	Billing_Material	Billing Material	DLR14_RBS0_STR$	Currency	14
10	Billing_Labor	Billing Labor	DLR14_RBS0_STR$	Currency	14
11	Billing_Subs	Billing Subs	DLR14_RBS0_STR$	Currency	14
12	Billing_Other	Billing Other	DLR14_RBS0_STR$	Currency	14
13	Billing_Percentage_Equip	Billing Percentage Equip	DLR5_%2	Currency	8
14	Billing_Pct_Material	Billing Percentage Material	DLR5_%2	Currency	8
15	Billing_Percentage_Labor	Billing Percentage Labor	DLR5_%2	Currency	8
16	Billing_Percentage_Subs	Billing Percentage Subs	DLR5_%2	Currency	8
17	Billing_Percentage_Other	Billing Percentage Other	DLR5_%2	Currency	8