Using ARIBD.IDINVC in analytics

[ramam1]

Hola,
I'm developing a VB based report to categorize cash applications in a period by item (ie for last week how much $ in payments where applied - summarize by item code). I'm working my way through the logic and I prefer to join (or at least query) into ARIBD using an IDINVC (that I pull from AROBP). I notice that of the 150k+ entries in ARIBD not one has an IDINVC. What's going on?
thanks for any help [and feel free to clue me on a better approach]
ram

 

[ettienne]

IDINVC is located in ARIBH.

 

[DjangMan]

AROBL has CNTBTCH and CNTITEM which you can use to link to ARIBD as well.

 

[ramam1]

Thanks folks. I suppose IDINVC is present in ARIBD either for legacy reasons or perhaps to enable a feature or module we don't have.
cheers

 

[ettienne]

Huh? IDINVC is not in ARIBD...

 

[DjangMan]

It's there. Right after AUDTORG. Empty.

 

[ettienne]

Ah I missed it, browsed over it too quickly I suppose.