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|