#  I'm converting a query from the HDWPROD view DWGL\_POSTED\_ACTUAL\_LINES to the HDWUTS/DWCENPRD view DW\_TRANSACTION\_DETAILS\_F\_SV and I'm getting budget journals. Why would that be? 

 



In HDWPROD, we have 3 different views for each type of journal, Actual (DWGL\_POSTED\_ACTUAL\_LINES), Budget (DWGL\_POSTED\_BUDGET\_LINES), and Encumbrance (DWGL\_POSTED\_ENCUMBRANCE\_LINES), as well as one view that combines all 3 (DWGL\_POSTED\_JE\_LINES). For this initial release of journal detail to DWCENPRD, we have only provided a single view, DW\_TRANSACTION\_DETAILS\_F\_SV, which is comparable to HDWPROD's DWGL\_POSTED\_JE\_LINES view. To eliminate budget journals from your DW\_TRANSACTION\_DETAILS\_F\_SV query, pull in the DW\_AMOUNT\_TYPES\_D\_V dimension, join the amount\_type\_keys between the two views, and add a limit on column DW\_AMOUNT\_TYPES\_D\_V.amount\_type\_cd="A".



 

 

 



 

 See also:- [ Financial Accounting & Reporting ](/faq/financial-reporting)