Skip to main content
Dynamics 365 Community / Forums / Finance forum / Connection between Sub...
Suggested answer

Connection between SubBillDeferralScheduleTable and SubBillScheduleTable via SubBillDetailLine

editSubscribe (0) ShareShare
ReportReport
Posted on by 15
 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