JE Norwegian GEI A-Report- Not Supported: Reserved For Future Use

Description

Categories
BI Publisher
Application
European Localizations
Source
Norwegian GEI A-Report (XML) - Not Supported: Reserved For Future Use
Short Name
JENOGEIA_XML
DB package
JE_JENOGEIA_XMLP_PKG
Imported from BI Publisher
Norwegian GEI A-Report

SQL 7 lines

select 	substr(account,1,2) Authority,
	substr(account,3,10) Account,
	to_number(amount) Amount
From JE_NO_GEI_AREPORTS
WHERE record_id like 'S1'
order by account