Table Oracle Relations in All Module, Slides of Information Technology

Download Table Oracle Relations in All Module and more Slides Information Technology in PDF only on Docsity!

TABLE

RELATIONS

CINDY R AMALIA

CINDY R AMALIACINDY R AMALIA

bybyby

TABLE OF

CONTENTS

02

03

01

RELATIONS BETWEEN AP

(ACCOUNT PAYABLE) TABLES

RELATIONS BETWEEN AR

(ACCOUNT RECEIVABLE)

TABLES

RELATIONS BETWEEN

PURCHASING (PO) TABLES

04

RELATIONS BETWEEN ORDER

MANAGEMENT TABLES

05

RELATIONS BETWEEN

INVENTORY MANAGEMENT

TABLES

06

RELATIONS BETWEEN GENERAL

LEDGER TABLES

RELATIONS BETWEEN AP (ACCOUNT PAYABLE) TABLESRELATIONS BETWEEN AP (ACCOUNT PAYABLE) TABLES RELATIONS BETWEEN AP (ACCOUNT PAYABLE) TABLES

WITHOUT RELATING TABLE WITHOUT RELATING TABLEWITHOUT RELATING TABLE

WITH RELATING TABLEWITH RELATING TABLEWITH RELATING TABLE

DOUBLING

INACCURATE

ACCURATE

AVOID DOUBLING

E

X

A

M

P

L

E

E

X

A

M

P

L

E

E

X

A

M

P

L

E

AP_INVOICES_ALL &AP_INVOICES_ALL &AP_INVOICES_ALL &

AP_HOLDS_ALLAP_HOLDS_ALLAP_HOLDS_ALL

RELATIONS BETWEEN ARRELATIONS BETWEEN ARRELATIONS BETWEEN AR

(ACCOUNT RECEIVABLE)(ACCOUNT RECEIVABLE)(ACCOUNT RECEIVABLE)

TABLESTABLESTABLES

LINK: https://dbdiagram.io/d/AR-NEATER-VER-658bd4e389dea6279999e

RELATIONS BETWEENRELATIONS BETWEENRELATIONS BETWEEN

PURCHASING (PO) TABLESPURCHASING (PO) TABLESPURCHASING (PO) TABLES

LINK: https://dbdiagram.io/d/PURCHASING-TABLES-6593bd2fac844320ae

RELATIONS BETWEEN PURCHASING (PO) TABLESRELATIONS BETWEEN PURCHASING (PO) TABLES RELATIONS BETWEEN PURCHASING (PO) TABLES

WITHOUT RELATING TABLEWITHOUT RELATING TABLEWITHOUT RELATING TABLE

WITH RELATING TABLEWITH RELATING TABLEWITH RELATING TABLE

DOUBLING

INACCURATE

ACCURATE

AVOID DOUBLING

E

X

A

M

P

L

E

E

X

A

M

P

L

E

E

X

A

M

P

L

E

RCV_TRANSACTIONS &RCV_TRANSACTIONS &RCV_TRANSACTIONS &

PO_INTERFACE_ERRORSPO_INTERFACE_ERRORSPO_INTERFACE_ERRORS

RELATIONS BETWEEN ORDER MANAGEMENT TABLESRELATIONS BETWEEN ORDER MANAGEMENT TABLES RELATIONS BETWEEN ORDER MANAGEMENT TABLES

WITH RELATING TABLEWITH RELATING TABLEWITH RELATING TABLE

DOUBLING

INACCURATE

ACCURATE

AVOID DOUBLING

E

X

A

M

P

L

E

E

X

A

M

P

L

E

E

X

A

M

P

L

E

OE_ORDER_LINES_HISTORYOE_ORDER_LINES_HISTORYOE_ORDER_LINES_HISTORY

& OE_ORDER_LINES_ALL& OE_ORDER_LINES_ALL& OE_ORDER_LINES_ALL

WITHOUT RELATING TABLEWITHOUT RELATING TABLEWITHOUT RELATING TABLE

RELATIONS BETWEEN INVENTORYRELATIONS BETWEEN INVENTORYRELATIONS BETWEEN INVENTORY

MANAGEMENT TABLESMANAGEMENT TABLESMANAGEMENT TABLES

LINK: https://dbdiagram.io/d/INVENTORY-MGT-TABLES-659cd88aac844320ae81ddb

RELATIONS BETWEEN GENERAL LEDGER TABLES RELATIONS BETWEEN GENERAL LEDGER TABLESRELATIONS BETWEEN GENERAL LEDGER TABLES

LINK: https://dbdiagram.io/d/GL-TABLES-65a63a03ac844320ae016a

RELATIONS BETWEEN GENERAL LEDGER TABLESRELATIONS BETWEEN GENERAL LEDGER TABLES RELATIONS BETWEEN GENERAL LEDGER TABLES

WITH RELATING TABLEWITH RELATING TABLEWITH RELATING TABLE

DOUBLING

INACCURATE

ACCURATE

AVOID DOUBLING

E

X

A

M

P

L

E

E

X

A

M

P

L

E

E

X

A

M

P

L

E

GL_JE_HEADERS &GL_JE_HEADERS &GL_JE_HEADERS &

GL_BUDGET_VERSIONS GL_BUDGET_VERSIONSGL_BUDGET_VERSIONS

WITHOUT RELATING TABLEWITHOUT RELATING TABLEWITHOUT RELATING TABLE