JL Mexican Trial Balance - XML File

➜ Back to Library
Description
Categories: BI Publisher
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 NameSQL textValidation
Configuration Name
 
LOV Oracle
Trial Balance Version
 
Char
Period
 
LOV Oracle
Adjustment Period
 
LOV Oracle
Remittance Type
 
LOV Oracle
Trial Balance Modified Date
 
Date
Seal
 
Char
Certificate Number
 
Char
Certificate
 
Char
Include Statistical Balances
 
LOV Oracle
Download
Related Blitz Reports
JL Mexican Accounts Auxiliary Report - XML File JL Mexican Journal Entries - XML File JL Mexican Chart of Accounts - XML File JL Mexican Fixed Assets IMPAC - draft JL Colombian Third Party / Account Report- Not Supported: Reserved For Future Use JL Colombian Fixed Assets Inflation Adjusted Drill Down - draft JL Brazilian Payables Cancelled Consolidated Invoice Register - draft JL Colombian Payables Withholding Report- Not Supported: Reserved For Future Use JL Chilean General Ledger Cash Ledger- Not Supported: Reserved For Future Use
Blitz Report™