IDOC to JDBC mapping problem with parent/child

Hi, I am working on an interface from idoc (ORDERS.ORDERS05) to jdbc . I am then inserting the data into three tables:

header table

line item table

service item table

My data looks like this:

header

line item 1

service 1 for line item 1

service 2 for line item 1

service 3 for line item 1

line item 2

service 1 for line item 2

service 2 for line item 2

I mapped the idoc to a structure like this:

header

item

service item

This structure matches the idoc by putting the services item as a children to the item.

When I did this, I was only getting the two line items and the first set of children:

line item 1

line item 2

service 1 for line item 1

service 2 for line item 1
service 3 for line item 1

I then changed my message structure to this:

header

item

service

This structure (although it seems wrong to me since service is a child to item) gave me everything:

line item 1

line item 1

service 1 for line item 1

service 2 for line item 1

service 3 for line item 1

service 1 for line item 2

service 2 for line item 2

The only problem I had with this is that I was referencing the line item number in the service item structure and it was always giving me 00010. I have resolved this by adding the line item to the service item structure in an extension (since I was already using it). I had also tried to use CopyValue and it did not work. I am trying to understand why this was happening?

Thanks,

Katie