JE Norwegian GEI S-ReportFor future use

Description
Categories: BI Publisher
Application: European Localizations
Source: Norwegian GEI S-Report (XML) For future use
Short Name: JENOGEIS_XML
DB package: JE_JENOGEIS_XMLP_PKG
select 	decode(substr(text, 5, 1),'S','S - Rapport') Report_type,
	substr(text, 6, 9) Accountant_unit,
	substr(text, 15, 6) Period,
	substr(text, 21, 12) Version,
	substr(text, 33, 35) Refrence_number,
	substr(text, 68, 9) Central_unit
from 	je_no_gei_asciis_t
where	substr(text, 1, 2) = 'H1'
Parameter Name SQL text Validation
Ledger ID
 
Number
Filename and Path
 
Expenses
 
Income
 
Period
 
Final Report?
 
LOV Oracle
Ask a question