Query for GL Trial Balance

Dear All Goros,

We required a query which showing all TB related field like Opening balance, Activities balance & ending balance.

Also having following attributes,

Attribuite

GL Company Code

GL Branch Code

GL Account Code

GL Business Code

GL Department Code

GL Company Desc

GL Branch Desc

GL Account Desc

GL Business Desc

GL Department Desc

Financial Year

Financial Year Desc

Financial Period

Financial Period Desc

GL Balance Type (EOP, Ave_Per, etc)

GL Balance Type Desc

GL Account Type (Rev, Exp, Asset, etc)

GL Account Type Desc

GL Account Group  (BS/PnL)

GL Account Group Desc

GL Period Movement

GL Closing Balance