What does the value BKTRAND.DDLINK mean?

[vbdbcoder]

Hello,

I remember seeing someone posted this question before. But I don't know where to find the answer.

In BKTRAND table, the field DDLINK stores the value of the source transaction (maybe module + type + batch # + entry #). Is there any help on how it works ? E.g. 224651000000000001 means an AR receipt in my BK transaction, since I did the BK reverse. Does the value record what AR batch and\or Entry ?

Thanks!

 

[DjangMan]

There should be a field in the table for the module. Here's the breakdown of GLPOST.DRILLDNLK which will give you an idea of how to parse the DDLINK field.

GLPOST.DRILLDNLK = 224850000000000001

The field is parsed as follows:

1st Digit = Width of Posting Sequence number [2 in this case]

2nd Digit = Width of Batch number [2 in this case]

3rd & 4th digits = Posting Sequence [48] (starting at position 3)

5th & 6th digits = Batch Number [50] (starting after Posting Sequence)

Remaining digits = Entry Number

 

[vbdbcoder]

Thanks !

This is great tip!