Query to get costing and Element link
Summary
SQL Query to get costing segment columns and element link name columnContent
Hi All,
I want to pull the costing segments along with credit, debit amounts and element link name column. I have developed a query as shown below but gives me duplicates and not the correct credit, debit amounts. Can someone please check this query and correct if I have to add any table or join in it.
SELECT DISTINCT
A.ELE_NAME,
A.ELE_CLASS,
A.ELE_ELIG_NAME,
A.COST_Charging_Dept,
A.COST_Charge_To_Dept,
A.OFFSET_Charging_Dept,
A.OFFSET_Charge_To_Dept,
Tagged:
0