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