This is an HTML version of an attachment to the Freedom of Information request 'Schema for the Fujitsu Oracle database for County Council accounts'.
Oracle Cash Management - Release 11i
Logical Data Model
CASH FORECAST
INTERNAL ORGANIZATION
CASH FORECAST CELL
belongs to
owns
has
BUSINESS 
LEGAL ENTITY
OPERATING UNIT
has
of
GROUP
is of
having
uses
contained in
referenced by
 owns
referencing
EXTERNAL ORGANIZATION
BANK BRANCH
BANK STATEMENT
CUSTOMER
listing txn activity for
has
belongs to
CUSTOMER SITE
manages
having
SUPPLIER
managed by
contained in
BANK ACCOUNT
BANK STATEMENT 
BANK STATEMENT LINE
RECONCILIATION ERROR
EXTERNAL BANK 
having
ACCOUNT
has
CUSTOMER BANK 
generating
generated by
ACCOUNT
matched to
owns
owned by
belongs to
SUPPLIER SITE
SUPPLIER BANK 
ACCOUNT

INTERNAL BANK 
owned by
ACCOUNT
having
referencing
part of
EXTERNAL CASH 
AP PAYMENT
BANK STATEMENT RECONCILIATION
TRANSACTION
AP CHECK
identifying
EXTERNAL 
BANK ERROR 
PAYABLES 
RECONCILIATION
RECONCILIATION
PAYMENT 
matched to
identifying
identifying
matched to
RECONCILIATION
AP 
ELECTRONIC 

AP WIRE 
PAYMENT

RECEIPT 
PAYROLL 
JOURNAL 
RECONCILIATION
PAYMENT 
RECONCILIATION
RECONCILIATION
identifying
identifying
matched to
matched to
RECEIPT HISTORY
JOURNAL ENTRY
JOURNAL LINE
in
composed of
Click here for instructions on ordering
a printing of the diagram from Kinkos

Copyright © 2000, Oracle Corporation.  All Rights Reserved
This logical data m odel is subject to change without notice.
                   Release/Version Num ber:  11i