Please explain the process of Importing particular data (on-hand quantity in our case) from oracle a

I know the outline,

1) through any custom package pull data from oracle and insert into BIIO_ON_HAND table.

     my question: Is there any particular structure we need to follow for creating this table.
     I mean i have 1 row for on-hand quantity and other rows are item_name, org-id.

     Do I need other rows as well.

2) create a series in Demantra.

   

3) integration interface creation for importing on-hand.

4) create workflow so that integration interafce runs and you can see the data in series.

But my question is that how to mapp the on-hand quatity to particular levels. is there any step I am missing. So, that whenever user open the worksheet at any level they can properly see the on-hand quantity for correct item in series.