Connection between SubBillDeferralScheduleTable and SubBillScheduleTable via SubBillDetailLine

(0) Share

Report

Posted on by davidmvg

Hi,

We are building a SQL query/transformation for Subscription and Deferral Sub billing overview. But we have not found the connection /relationship between the /Deferral schedule number/ in the /SubBillDeferralScheduleTable/ and the /Billing schedule number/ in the / SubBillScheduleTable/

We noted that there is a possible /bridge/ table called /SubBillDetailLine/ using /SubBillScheduleDtlRecId/ in /SubBillDeferralScheduleTable/
but the connection seems to be many to many.

Since these tables are not part of the AX2012 documentation S Tables | Microsoft Learn , could some one help us to find a possible link/connection for those?

very much appriciated

David

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi @David Molina,

Thanks.

Waed Ayyad

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Was this reply helpful? Yes No