Skip to main content

Hi All, im looking to produce a report to output the multilevel materials and components on a finished serialized part or even at the shop order level rather than serial level.

I cant find a view in IFS and am having difficulty finding which tables and views will allow me to make a query to establish this connection.

i have tried to describe the kind of connection im looking for below but for N levels and N components


shop ord
	component a
		shop ord
			component 1
				shop ord
					component #
					component #
			component 2
				shop ord
					component #
					component #
	component B
		shop ord
			component 1
				shop ord
					component #
					component #
			component 2
				shop ord
					component #
					component #

any help or support anyone can offer to point me in the right direction will be appreciated.

 

 

 

Likely starting points would be the Shop Order As-Built Structure for information during the build and prior to receipt into stock and the As-Built Structure for after the part has been produced and received into stock.

Reply


Terms & ConditionsCookie settings