This is an HTML version of an attachment to the Freedom of Information request 'Schema for the Fujitsu Oracle database for County Council accounts'.
GL_ACCOUNT_HIERARCHIES (apps
GL_CODE_COMBINATIONS (ap
SUMMARY_CODE_COMBINATION
CODE_COMBINATION_ID
DETAIL_CODE_COMBINATION_ID
GL_REVALUATION (app
SET_OF_BOOKS_ID
GL_SUSPENSE_ACCOUNTS (app
GL_JE_CATEGORIES_TL 
SET_OF_BOOKS_ID
JE_SOURCE_NAME
JE_CATEGORY_NAME
JE_CATEGORY_NAME
LANGUAGE
CODE_COMBINATION_ID
GL_JE_SOURCES_TL (
JE_SOURCE_NAME
LANGUAGE
GL_INTERCOMPANY_ACCOUNTS (apps/gl/D
SET_OF_BOOKS_ID
JE_SOURCE_NAME
JE_CATEGORY_NAME
BAL_SEG_VALUE
GL_NET_INCOME_ACCOUNTS (apps
SET_OF_BOOKS_ID
BAL_SEG_VALUE
CODE_COMBINATION_ID
GL_SUMMARY_TEMPLATES (a
TEMPLATE_ID
GL_DAILY_RATES (apps/gl/Database Objects/GL Design)
FROM_CURRENCY
TO_CURRENCY
CONVERSION_DATE
CONVERSION_TYPE
GL_HISTORICAL_RATES (apps/gl/Database Objects/GL D
SET_OF_BOOKS_ID
FND_CURRENCIES (apps
PERIOD_NAME
CODE_COMBINATION_ID
CURRENCY_CODE
TARGET_CURRENCY
USAGE_CODE
GL_SETS_OF_BOOKS (apps/gl/Databas
GL_TRANSLATION_RATES (apps/
SET_OF_BOOKS_ID
SET_OF_BOOKS_ID
PERIOD_NAME
TO_CURRENCY_CODE
ACTUAL_FLAG
GL_TRANSACTION_DATES (apps/
TRANSACTION_CALENDAR_ID
TRANSACTION_DATE
GL_TRANSACTION_CALENDAR (a
FND_ID_FLEX_STRUCTURES (apps/
TRANSACTION_CALENDAR_ID
APPLICATION_ID
ID_FLEX_CODE
ID_FLEX_NUM
GL_PERIOD_STATUSES (apps/gl/D
GL_PERIODS (apps/gl/Database
APPLICATION_ID
PERIOD_SET_NAME
SET_OF_BOOKS_ID
PERIOD_NAME
PERIOD_NAME
GL_PERIOD_SETS (apps/gl/Dat
Diagram : R115 GL SETUP
Modified : 03 November  1999 12:20:15
PERIOD_SET_NAME
Application System : apps/gl/Database Objects/GL Design