JL Mexican Trial Balance - XML File

Description
Categories: BI Publisher
Columns: Account, Begin Balance, Period Net Dr, Period Net Cr, End Balance ...
Application: Latin America Localizations
Source: Mexican Trial Balance - XML File
Short Name: JLMXTBAL_XMLP
DB package: JL_MX_TBAL_PKG
 SELECT natural_account
					  || ' '
					  || subaccount account, 
					  TRIM(TO_CHAR(ROUND(NVL(BEGIN_BALANCE,0), :G_PRECISION),'9999999999999999999990.00')) begin_balance,
  					  TRIM(TO_CHAR(ROUND(NVL(PERIOD_NET_DR,0), :G_PRECISION),'9999999999999999999990.00')) period_net_dr,
					  TRIM(TO_CHAR(ROUND(NVL(PERIOD_NET_CR,0), :G_PRECISION),'9999999999999999999990.00')) period_net_cr,
					  TRIM(TO_CHAR(ROUND(NVL(END_BALANCE,0), :G_PRECISION),'9999999999999999999990.00')) end_balance					   
					FROM (Select * 
                                              From jl_mx_gl_accounts_t
					      Order By natural_account, subaccount) jl_mx_gl_accounts_t
					WHERE Sat_account IS NOT NULL
					  AND ( NVL(BEGIN_BALANCE,0)   <> 0
  					       Or NVL(PERIOD_NET_DR,0) <> 0
					       Or NVL(PERIOD_NET_CR,0) <> 0
					       Or NVL(END_BALANCE,0)   <> 0)					   
					  CONNECT BY parent_account  = Prior natural_account
					  START WITH parent_account IS NULL
Parameter Name SQL text Validation
Configuration Name
 
LOV Oracle
Trial Balance Version
 
Period
 
LOV Oracle
Adjustment Period
 
LOV Oracle
Remittance Type
 
LOV Oracle
Trial Balance Modified Date
 
Date
Seal
 
Certificate Number
 
Certificate
 
Include Statistical Balances
 
LOV Oracle