t sql .. whats the relation between LEDGERJOURNALTABLE and GeneralJournalAccountEntry

(0) Share

Report

Posted on by shelpaya

406

Dear All,

could anyone help me to create the relation between [LEDGERJOURNALTABLE] and below query,

SELECT * FROM
MAINACCOUNT
LEFT OUTER JOIN DimensionAttributeValueCombination ON MAINACCOUNT.RECID = DimensionAttributeValueCombination.MAINACCOUNT
LEFT OUTER JOIN GeneralJournalAccountEntry ON DimensionAttributeValueCombination.RECID = GeneralJournalAccountEntry.LEDGERDIMENSION
LEFT OUTER JOIN GeneralJournalEntry ON GeneralJournalEntry.RECID = GeneralJournalAccountEntry.GENERALJOURNALENTRY

thanks a lot.

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Mea_ 60,284 on at

Like (1)

Report

Hi Mohamed Shelpaya,

Please read this blog post to find relation mycsharpdeveloper.wordpress.com/.../relation-between-ledgerjournaltable-and-generaljournalentry

Was this reply helpful? Yes No
shelpaya 406 on at

Like (0)

Report

Dear ievgen Miroshikov,

thank's alot .

Best Regards.

Was this reply helpful? Yes No