TaxAndGovernmentDetailChargeFee
Posted: Mon Nov 02, 2015 9:18 pm
I want to get the documents to be recorded from the TaxAndGovernmentDetailChargeFee table.
I'm able to get the table via code with
but unable to get it via SQL
Any help appreciated.
I'm able to get the table via code with
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#