Analysis of KDR missing group info Look at BatchID 33667 KDR - Victrack Rent and Calls - Calls ServiceID is "KDC01PWS" in Bilmax21 under VICTRACK INV003299 BatchID: 33667 DEPT3161 CENTRE4357 from tServiceID 75570|KDC01PWS|KDC01PWS|340|KDC|||4156||199|1261|1848||||1176|||||Feb 02 2010 12:00AM||||||||||||||||||||||||||1|W|Feb 02 2010 08:17AM|Jul 07 2010 12:33PM|edouglas|||||||||| field 8 is CustomerCentreID|int|no|4|10|0|yes|(n/a)|(n/a)| and has [4156] from tCentre 4156|0465|1|Dec 14 2009 12:00AM||2885| field 6 is DepartmentID|int|no|4|10|0|yes|(n/a)|(n/a)| and has [2885] from tDepartment 2885|KDR VICTORIA PTY LTD|1502|Oct 15 2009 12:00AM||1| field 3 is GroupID|int|no|4|10|0|yes|(n/a)|(n/a)| and has [1502] from tGroup 1502|1063|KDR VICTORIA PTY LTD|Oct 15 2009 12:00AM||1| field 2 is CustomerID|int|no|4|10|0|yes|(n/a)|(n/a)| and has [1063] from tCustromer 1063|KDR|KDR VICTORIA PTY LTD|10002087|KDR VICTORIA PTY LTD|ATTN NEIL ROBE... SQL to get customet Hierarcky is... SELECT dbo.tServiceID.ID AS ServiceIDID, dbo.tServiceID.ServiceID, dbo.tCentre.ID AS CentreID, dbo.tCentre.Description AS CentreDesc, dbo.tDepartment.ID As DeptID, dbo.tDepartment.Description AS DeptDesc, dbo.tGroup.ID AS GrpID, dbo.tGroup.Description AS GrpDesc, dbo.tCustomer.ID AS CustID, dbo.tCustomer.ShipTo, dbo.tCustomer.FullName FROM dbo.tServiceID INNER JOIN dbo.tCentre ON dbo.tServiceID.CustomerCentreID = dbo.tCentre.ID INNER JOIN dbo.tServiceID INNER JOIN dbo.tCentre ON dbo.tServiceID.CustomerCentreID = dbo.tCentre.ID INNER JOIN dbo.tDepartment ON dbo.tCentre.DepartmentID = dbo.tDepartment.ID INNER JOIN dbo.tGroup ON dbo.tDepartment.GroupID = dbo.tGroup.ID INNER JOIN dbo.tCustomer ON dbo.tGroup.CustomerID = dbo.tCustomer.ID ORDER BY 1 and for "KDC01PWS" has 75570|KDC01PWS|4156|0465|2885|KDR VICTORIA PTY LTD|1502|KDR VICTORIA PTY LTD|1063|KDR|KDR VICTORIA PTY LTD| which is translated to t21group4.unl which has... CENTRE4156|KDC01PWS|E|5|KDC01PWS (SERVICE75570)|KDC01PWS (SERVICE75570)|KDC01PWS (SERVICE75570)| and from cde summary sql... |33667|828.80|617.64|0.00|0.00|1446.44|199|VicTrack Rent and Calls|10|Network Services|l|TQ|KDC01PWS|PWS PRESTON TRAM WORKSHOPS||4357|0464|||M09PWDO|W|3161|PRESTON TRAM WORKSHOPS||Feb 02 2010 12:00AM||2010/04|