JL Mexican Accounts Auxiliary Report - XML File

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Latin America Localizations
Source: Mexican Accounts Auxiliary Report - XML File
Short Name: JLMXAAUX_XMLP
DB package: JL_MX_JOURNAL_ENTRIES_PKG
Select to_char(jml.journal_date,'YYYY-MM-DD') journal_date,
                                        substr(gl_je_name,1,(50 - (length(to_char(je_header_id))+1))) || ' ' || to_char(je_header_id) journal_name,
					substr(jml.line_description,1,200) line_description,
					trim(TO_CHAR(ROUND(NVL(jml.ACCOUNTED_DR,0), :G_PRECISION),'9999999999999999999990.00')) accounted_dr,
					trim(TO_CHAR(ROUND(NVL(jml.ACCOUNTED_CR,0), :G_PRECISION),'9999999999999999999990.00')) accounted_cr,
					jma.natural_account || ' ' || jma.subaccount account,
					substr(jma.natural_account_desc || ' ' || jma.subaccount_desc, 1 ,100) description,
					trim(TO_CHAR(ROUND(NVL(jma.BEGIN_BALANCE,0), :G_PRECISION),'9999999999999999999990.00')) begin_balance,
					trim(TO_CHAR(ROUND(NVL(jma.END_BALANCE,0), :G_PRECISION),'9999999999999999999990.00')) end_balance
					From jl_mx_je_lines_t jml,
						 jl_mx_gl_accounts_t jma
					Where jml.request_id = :g_con_request_id
					  and jma.config_id = :P_CONFIG_ID
					  and decode(jma.company_bsv,'T','1', jma.company_bsv) = decode(jma.company_bsv,'T','1', jml.addit_info_1)
					  and jma.natural_account = jml.addit_info_2
					  And nvl(Decode(Jma.Subaccount,'T','1', Jma.Subaccount),'1') = nvl(Decode(Jma.Subaccount,'T','1', Jml.Subaccount),'1')
					  -- and Jma.Sat_account is not null
					order by  jma.natural_account,jml.journal_date, jml.gl_je_name, jml.je_header_id
Parameter NameSQL textValidation
Configuration Name
 
LOV Oracle
Auxiliary Report Version
 
Char
Journal Entry Source
 
LOV Oracle
Accounting Flexfield From
 
Char
Accounting Flexfield To
 
Char
Show Adjustment Periods
 
LOV Oracle
Period
 
LOV Oracle
Include Zero Amount
 
LOV Oracle
Request Type
 
LOV Oracle
Audit Request Number
 
Char
Audit Process Number
 
Char
Seal
 
Char
Certificate Number
 
Char
Certificate
 
Char
Download
Related Blitz Reports
JL Mexican Journal Entries - XML File JL Mexican Trial Balance - XML File JL Mexican Chart of Accounts - XML File JL Mexican Fixed Assets IMPAC - draft JL Chilean General Ledger Cash Ledger- Not Supported: Reserved For Future Use JL Colombian Inflation Adjusted Fixed Assets Report- Not Supported: Reserved For Future Use JL Colombian Fixed Assets Inflation Adjusted Account Drill Down Report- Not Supported: Reserved For Future Use JL Colombian Fixed Assets Inflation Adjusted Drill Down - draft JL Colombian Third Party / Account Report- Not Supported: Reserved For Future Use
Blitz Report™