Service Bill of Material Detail (SVC06201)

azurecurve Products FieldService (949)ProjectService Bill of Material Detail (SVC06201)

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

Display Name: Service Bill of Material Detail
Physical Name: SVC06201
Technical Name: SVC_Service_BOM_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	SERVICEBOM	Service BOM	String	STR30_Item_Number	30
2	SEQUENCE1	Sequence	Currency	DLR19_$S2	19
3	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['Service Bill of Material Detail'].ITEMNMBR AS 'Service Bill of Material Detail-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM SVC06201 AS ['Service Bill of Material Detail'] INNER JOIN IV00101 AS ['Item Master'] ON ['Service Bill of Material Detail'].ITEMNMBR = ['Item Master'].ITEMNMBR
4	ITEMDESC	Item Description	String	STR100	100
5	QUANTITY	QTY	Currency	DLR17_QTY_RBS0_STR	17
6	EFFDATE	Effective Date0	Date	DT_Date	6
7	EXPNDATE	Expiration Date	Date	DT_Date	6
8	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Service Bill of Material Detail'].NOTEINDX AS 'Service Bill of Material Detail-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM SVC06201 AS ['Service Bill of Material Detail'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Service Bill of Material Detail'].NOTEINDX = ['Record Notes Master'].NOTEINDX

azurecurve Products FieldService (949)ProjectService Bill of Material Detail (SVC06201)