Oracle EBS PO模块表结构
需积分: 2 59 浏览量
2022-12-30
10:07:23
上传
评论
收藏 98KB PDF 举报
Click here for instructions on ordering
a printing of the diagram from Kinkos
Oracle Purchasing - Release 11i.5
Logical Data Model
Copyright © 2000, 2001 O racle Corporation. A ll Rights Reserved
T h is lo g ical d a ta m o d el is su bje c t to ch a n ge w itho u t no tic e .
COST GROUP
LICENSE PLATE
LPN
PREPACK
LPN
PREGENERATED
LPN ON HAND
LPN CARTON
LPN WIP
LPN RECEIVING
LICENSE PLATE CONTENT
MANUFACTURERFREIGHT CARRIER
ITEM
SALES ORDER
SALES ORDER LINE
RETURN
ORDER LINE
PROJECT
CONTRACT LINE
PROJECT
CONTRACT
ORGANIZATION ITEM
REVISION
MATERIAL TRANSACTION HISTORY
INTERNAL
SHIPMENT
INTERNAL
RECEIPT
RMA TXN
PO RECEIPT
MATERIAL TXN
PROJECT
CONTRACT
DELIVERABLE
GRANT AWARD
INVENTORY SUPPLY
INTRANSIT SHIPMENT SUPPLY
PO SUPPLYREQUISITION SUPPLY
RECEIVING SUPPLY
WIP SUPPLY
AP INVOICE
MFG ORDER
WIP JOB
AP TAX CODE
GRANT AWARD
DISTRIBUTION
GL PERIOD
PURCHASING
DOCUMENT TYPE
PURCHASING LINE
TYPE
PROJECT
CONTRACT
PROJECT
AWARD
PROJECT
CURRENCY
MANUFACTURING LINE
AP PAYMENT TERMS
SOURCING RULE
EFFECTIVE PERIOD
PURCHASE ORDER
APPROVAL LIST
LINE
PURCHASE ORDER
APPROVAL LIST
HAZARD CLASS
UNITED NATION HAZARD
NUMBER
UNIT OF MEASURE
RECEIVING SUB-LEDGER
QUOTATION LINE DETAIL
QUOTATION SHIPMENT
QUOTATION PRICE
BREAK
REQUEST FOR QUOTATION LINE
DETAIL
REQUEST FOR QUOTATION
SHIPMENT
REQUEST FOR QUOTATION
PRICE BREAK
HR LOCATION
PURCHASE ORDER
PURCHASE AGREEMENT
BLANKET PURCHASE
ORDER
PURCHASE
CONTRACT
PLANNED
PURCHASE ORDER
STANDARD
PURCHASE ORDER
REPLENISHMENT SOURCE
SOURCING
RULE-BOD
ASSIGNMENT
SOURCING RULE
PURCHASE ORDER SHIPMENT DISTRIBUTION
STANDARD PO
SHIPMENT
DISTRIBUTION
BLANKET RELEASE
SHIPMENT
DISTRIBUTION
PLANNED PO
SCHEDULED
SHIPMENT DIST
PLANNED PO
SHIPMENT
DISTRIBUTION
PURCHASE ORDER LINE SHIPMENT
PLANNED PO LINE
SHIPMENT
STANDARD PO
LINE SHIPMENT
BLANKET RELEASE
SHIPMENT
PLANNED PO
SCHEDULED
SHIPMENT
PURCHASE ORDER LINE
PLANNED PO LINE
STANDARD PO LINE BLANKET PO LINE
RECEIVING TRANSACTION
DELIVER TO INVENTORY
INVOICE PO
MATCH
CORRECTION
RETURN TO
RECEIVING
RETURN TO VENDORINSPECTION
RECEIPT
PROJECT MFG PROJECT
PROJECT MFG PA
PROJECT
SEIBAN NUMBER
PROJECT TASK
QUOTATION
CATALOG QUOTATION
BID QUOTATION
SUBINVENTORY
INTERNAL ORGANIZATION
INVENTORY ORGANIZATION
OPERATING UNIT
INBOUND SHIPMENT LINE
INBOUND SHIPMENT
INTRANSIT INVENTORY
SHIPMENT
INTERNAL ORDER
SHIPMENT
FROM SUPPLIER
SHIPMENT
ITEM CATEGORY
PO COMMODITY
CODE
GL ACCOUNT
BLANKET PO LINE
PRICE BREAK
BLANKET RELEASE
ORGANIZATION ITEM
PLANNED PO
RELEASE
QUOTATION LINE
APPROVED SUPPLIER LIST
REQUEST FOR QUOTATION
LINE
REQUEST FOR QUOTATION
REQUEST FOR BID
QUOTATION
REQUEST FOR CATALOG
QUOTATION
SUPPLIER CONTACT
REQUEST FOR
QUOTATION
SUPPLIER
REQUISITION DISTRIBUTION
REQUISITION
REQUISITION LINE
PURCHASE REQUISITION
LINE
INTERNAL REQUISITION
LINE
REQUEST FOR QUOTATION
SUPPLIER LIST
PERSON
EMPLOYEE
BUYER
EXTERNAL ORGANIZATION
SUPPLIER SITE
SUPPLIER
references
is referenced by
uses as
material
account
material account for
owned by
owns
for
has
identifies
identified by
is
is
identified by
identifies
references
referenced by
references
referenced by
composed of
in
has
referenced by
owned
owning
uses
used by
references
referenced by
has bill to location
bill to location for
has deliver to
location
deliver to location for
has
used by
has
assigned to
part of
contains
is ordered by
orders
is based on
has
approval for
approved on
approval
for
referenced
by
for
has
is contained
in
contains
return order for
has
generates
generated by
source for
has source
uses
document
type
for
uses document
type
for
part of
contains
is a quote for
is quoted by
revision of
has revision
for
has
in period
for
has
source
source for
generated by
generates
for
has
has
for
in currency
for
references
referenced
by
for
has
transfer from
transfer
source
has source
source
for
has source
source for
has source
source for
supplied from
supplies
distributed by
distributes
for
has
uses
for
uses document type
for
in currency
for
for
has
distributed
by
distributes
for
has
using
for
using
for
is for
has
is a
is a
destined for
is
destination
for
is for
will
receive
is for
will receive
is for
will
receive
has parent
is parent of
references
referenced by
has
for
references
referenced by
has
for
effectivity period for
in effect for
in effect for
effectivity period for
for
has
for
has
for
has
for
has
has as first approver
is first approver for
next approval
of
needs
response
from
responds to
forward to
to be
forwarded to
references
referenced by
references
referenced by
references
referenced by
references
referenced by
references
referenced
by
references
referenced
by
references
referenced
by
references
referenced by
references
referenced
by
has unit of
measure
referenced
by
references
referenced
by
references
referenced
by
references
referenced by
references
referenced by
referencing
referenced by
assigned to
has carrier
is for
is on
generated by
the source
of
backup copy of
posted to
assigned
assigned
to
assigned to
references
deliver to location
has deliver to
ship to location for
has ship to
location
shipped by
shipping
purchased by
purchasing
belongs to
owns
belong to
own
has buyer
for
contained in
contains
releases
is released by
contained in
contains
releases
released by
contained in
contains
designates as
source
designated
source for
designates as
source
designated
source for
assigns
is assigned by
refers to
referred by
refers to
referred
to by
owned by
owns
has
for
has
for
for project
task
has
approved for
approved by
prepared by
prepares
has
for
has
for
using
for
recorded as
refers to
for
to
a child of
a parent of
for
referenced by
is a stocking
area within
has
stocking
area
owned by
owns
is distributed
distributes
is for
received as
references
referenced by
distributes
distributed by
shipment schedule for
shipment
scheduled
by
is for
received on
is stocked in
stores
received on
received as
used by
uses
owned by
owning
has
for
uses
charge
account
used by
references
referenced by
referenced by
references
derives
derived
from
has source
source for
has destination
destination for
results from
results in
belongs to
has
send to
destination for
in
composed of
uses as charge
account
charge
account for
from supplier site
sent
charged to
charge account for
distributes
distributed by
released by
releases
for
has
shipment schedule for
shipment
scheduled by
distributes
distributed by
shipment schedule for
shipment scheduled by
referenced by
references
received for
received as
distributes
distributed by
for catalog
quotation
has
for bid
quotation
shipment
scheduled
by
approval for
approved by
can submit
quotation for
can be
submitted by
shipment
schedule
for
shipment
scheduled by
for
has
generated by
generates
authorizes to
submit quote
authorized to
send quote
represents
represented
by
has contact
is contact
for
the charge for
charged to
within
composed of
has purchasing agent
purchasing agent for
includes
is included
is a
is a
belongs to
has
资源评论
