doubt in formatted search query

[Former Member]

HI all

This is the query i have seen in the forum

Regarding linking of the UDF size in BOM to Production Order,

you will need to create a formatted seach as the tables where the UDF exists are different.

In case your UDF is at the row level then use the following SQL

SELECT T0.U_SIZE FROM DBO.ITT1 WHERE T0.FATHER = $http://$6.0.0 AND T0.CODE = $http://$37.4.0

Set this to auto refresh Exiting Alterned column Due Date.

Can any one tell me what does the following syntax mean

T0.FATHER = $http://$6.0.0

AND

T0.CODE = $http://$37.4.0

what is 37.4.0 and 6.0.0.

or any one help me whre can i find the materials for the above things.

[former_member583013 · Accepted solution]

FATHER refers to the Parent Item Code in the BOM definition

CODE refers to the Child Item Code in the BOM definition

If you Open the Production Order and Enable System Information from the View Menu and place your Cursor on the Product No field you will see the Item No on the Task Bar.

$[/$6.0.0] - 6 refers to the Product No field on the Production Order form

Similarly in $[/$37.4.0] - 37 refers to the Item Code at the Row level 4 refers to the column number in the matrix and 0 refers to the type

Ignore the / I have used above

Suda