Along with consolidation journal data, can we extract information like status, created, name of CJ

Summary:

We have requirement where consolidation journal data needs to be pushed to another application (ADLE), but along with the data of consolidation journal the client also requires, following details to be extracted from FCCS:

Journal_ID

Journal_Name

Journal_Category (User / System)

Journal_Source (Manual, Translation, Elimination, Consolidation, Data Management, etc.)

Journal_Status (Posted)

Journal_Date

Created_By

Post_Timestamp

Journal_Line_Number

Journal_Line_Description

Debit_Amount_Input_Currency

Credit_Amount_Input_Currency

Net_Amount_Input_Currency

Debit_Amount_Reporting_Currency (USD)

Credit_Amount_Reporting_Currency (USD)

Net_Amount_Reporting_Currency (USD)

Input_Currency_Code

Reporting_Currency_Code (USD)