Download original attachment
(PDF file)
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