Hello,

I am curious to know why tfgld415 has a lot less transactions than tfgld418. I know there is some ref integrity between these tables, but some transactions either don't post into the tfgld415 table or else they are removed later on. We don't archive or compress our integrations.

We use PCS, and have no rows in tfgld411, 413, 414 (if that explains anything).

Thanks in advance.

Hi,
The major reason is that tfgld418 has a records against both debit lines from tfgld410 and credit lines from tfgld417, while tfgld415 has only one record against both debit and credit lines.

Moshe

I think that tfgld415 transactions are removed once the integration transacton is posted.

Hi,
Maria is right,...tfgld415 has not posted records . Once they are posted they are removed, as it happens with tfgld416.
Pedro