SVC_Contract_Price_Book_Line (SVC00651)

azurecurve Products FieldService (949)ProjectSVC_Contract_Price_Book_Line (SVC00651)

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

Display Name: SVC_Contract_Price_Book_Line
Physical Name: SVC00651
Technical Name: SVC_Contract_Price_Book_Line

Group Display Name: Service Table Group
Group Technical Name: Service

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	UNITPRCT	Unit Percent	Currency	DLR5_%2	8
2	Contract_Price_Percent	Contract Price Percent	Integer	DDL_Contract_Option_Price_Percent	0
3	OPTTYPE	Option Type	String	STR10_LBAU	10
4	Contract_Cumulative_Pric	Contract Cumulative Price	Boolean	CB	0
5	ITMCLSCD	Item Class Code	String	STR10_Class_ID	10
	Key to the Item Class Setup (IV40400). Click to show/hide SELECT ['SVC_Contract_Price_Book_Line'].ITMCLSCD AS 'SVC_Contract_Price_Book_Line-Item Class Code' ,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code' FROM SVC00651 AS ['SVC_Contract_Price_Book_Line'] INNER JOIN IV40400 AS ['Item Class Setup'] ON ['SVC_Contract_Price_Book_Line'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD
6	UNITPRCE	Unit Price	Currency	DLR17_RBS0_STR$	17
7	UNITCOST	Unit Cost	Currency	DLR17_RBS0_UTR$	17
8	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['SVC_Contract_Price_Book_Line'].ITEMNMBR AS 'SVC_Contract_Price_Book_Line-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM SVC00651 AS ['SVC_Contract_Price_Book_Line'] INNER JOIN IV00101 AS ['Item Master'] ON ['SVC_Contract_Price_Book_Line'].ITEMNMBR = ['Item Master'].ITEMNMBR
9	CUSTCLAS	Customer Class	String	STR15_Customer_Class	15
10	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['SVC_Contract_Price_Book_Line'].CUSTNMBR AS 'SVC_Contract_Price_Book_Line-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SVC00651 AS ['SVC_Contract_Price_Book_Line'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SVC_Contract_Price_Book_Line'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
11	PRICSHED	Price Schedule	String	STR10_Schedule	10

azurecurve Products FieldService (949)ProjectSVC_Contract_Price_Book_Line (SVC00651)

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply