SoftPro Developer Forum

Code: Select all

((dynamic)_order).CDFs[0].TaxesAndGovernmentFeesSection.Lines

Code: Select all

SELECT
    TAGDCF.*
FROM
	pf.[Order] AS O
	INNER JOIN pfm.[Order] AS ORD ON ORD.RootId# = O.RootID
	INNER JOIN pfm.CDF AS C ON C.RootId# = ORD.RootId# AND C.Id# BETWEEN ORD.Id# AND ORD.LastId#
	INNER JOIN pfm.CDFLine AS CL ON CL.RootId# = C.RootId# AND CL.Id# BETWEEN C.Id# AND C.LastId#
	INNER JOIN pfm.CDFCharge AS CC ON CC.RootId# = CL.RootId# AND CC.Id# BETWEEN CL.Id# AND CL.LastId#
	INNER JOIN pfm.TaxAndGovernmentDetailSection AS TAGDS ON TAGDS.RootId# = CC.RootId# AND TAGDS.Id# BETWEEN CC.Id# AND CC.LastId#
	INNER JOIN pfm.TaxAndGovernmentDetailChargeFee AS TAGDCF ON TAGDCF.RootId# = TAGDS.RootId# AND TAGDCF.Id# BETWEEN TAGDS.Id# AND TAGDS.LastId#

Code: Select all

SELECT
    TAGDCF.*
FROM
   pf.[Order] AS O
   INNER JOIN pfm.[Order] AS ORD ON ORD.RootId# = O.RootID
   INNER JOIN pfm.CDF AS C ON C.RootId# = ORD.RootId# AND C.Id# BETWEEN ORD.Id# AND ORD.LastId#
   INNER JOIN pfm.CDFLine AS CL ON CL.RootId# = C.RootId# AND CL.Id# BETWEEN C.Id# AND C.LastId#
   INNER JOIN pfm.CDFCharge AS CC ON CC.RootId# = CL.RootId# AND CC.Id# BETWEEN CL.Id# AND CL.LastId#
   INNER JOIN pfm.TaxAndGovernmentDetailChargeFee AS TAGDCF ON TAGDCF.RootId# = CC.RootId# AND TAGDCF.Id# BETWEEN CC.Id# AND CC.LastId#