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

Categories:

BI and Analytics

Financial Management

All responses (1)

Answers (0)

Suggested answer

Waed Ayyad 5,451 Super User 2024 Season 2 on at

Like (0)

Report

Connection between SubBillDeferralScheduleTable and SubBillScheduleTable via SubBillDetailLine

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