Oracle® Retail Data Model Reference
10g Release 2 (10.2)
Part Number E10084-04

PDF · Mobi · ePub

List of Figures

2-1 Customer Entity Relationships
2-2 Employee Entity Relationships
2-3 Item Entity Relationships
2-4 Location Geography Entity Relationships
2-5 Organization Entity Relationships
2-6 Promotion Entity Relationships
2-7 SKU Item Entity Relationship
2-8 Tender Repository Relationships
2-9 Time Entity Relationships
2-10 Time of Day Entity Relationships
2-11 Time Transformation Entity Relationships
2-12 Customer Order Entity Relationships
2-13 Customer Order Line Item Entity Relationships
2-14 Customer Order Line Item State Assignment Entity Relationships
2-15 Customer Order State Entity Relationships
2-16 Customer Service Request Entity Relationships
2-17 Employee Labor Entity Relationships
2-18 Exchange Rate Currency Day
2-19 Inventory Control Document Entity Relationships
2-20 Inventory Control Document Line Item Entity Relationships
2-21 Inventory Item State Entity Relationships
2-22 Market Sales Item Week Entity Relationships
2-23 Purchase Order Entity Relationships
2-24 Purchase Order Line Item Entity Relationships
2-25 Purchase Order Line Item State Entity Relationships
2-26 Purchase Order State Entity Relationships
2-27 Retail Sale Return Line Item Entity Relationships
2-28 Retail Sale Return Promotion Line Item Entity Relationships
2-29 Retail Tender History Entity Relationships
2-30 Retail Tender Line Item Entity Relationships
2-31 Retail Transaction Entity Relationships
2-32 Retail Transaction Associate Assignment Entity Relationships
2-33 Retail Transaction Line Item Entity Relationships
2-34 Sales Forecast Item Organization Hierarchy Week Entity Relationships
2-35 Sales Plan Item Organization Hierarchy Week Entity Relationships
2-36 Till History Entity Relationships
2-37 Till Tax History Entity Relationships
2-38 Till Tender History Entity Relationships
2-39 Vendor SKU Cost Profit Day Entity Relationships
2-40 Certificate Activity Transaction Derived Entity Relationships
2-41 Customer Employee Relationship Day Entity Relationships
2-42 Customer Order Item Day Derived Entity Relationships
2-43 Customer Order Line Item State Derived Entity Relationships
2-44 Customer RFMP Score Entity Relationships
2-45 Customer SKU Sale Return Day Derived Entity Relationships
2-46 Catalog Request by Day Derived Entity Relationships
2-47 Inventory Adjustment by Item Day Derived Entity Relationships
2-48 Inventory Unavailable Item Day Entity Relationships
2-49 Inventory Position by Item Day Derived Entity Relationships
2-50 POS Tender Flow Entity Relationships
2-51 POS Transaction Flow Entity Relationships
2-52 Retail Sale Return Item Day Derived Entity Relationships
2-53 Space Utilization Item Day Derived Entity Relationships
2-54 Till Derived Entity Relationships
2-55 Carrier Compliance Week Aggr Entity Relationships
2-56 Certificate Activity Day Aggr Entity Relationships
2-57 Certificate Activity Week Aggr Entity Relationships
2-58 Customer Employee Relationship Month Aggr Entity Relationships
2-59 Customer Employee Sale Return Week Aggr Entity Relationships
2-60 Customer Order Department Day Aggr Entity Relationships
2-61 Customer Order Department Month Aggr Entity Relationships
2-62 Customer Order Item Month Aggr Entity Relationships
2-63 Customer Order Item Week Aggr Entity Relationship
2-64 Customer Order Subclass Day Aggr Entity Relationship
2-65 Customer Order Subclass Month Aggr Entity Relationship
2-66 Customer Order Subclass Week Aggr Entity Relationships
2-67 Inventory Budget By Week Aggr Entity Relationships
2-68 Inventory Item State History Week Entity Relationships
2-69 Inventory Position By Department Day Aggr Entity Relationships
2-70 Inventory Position By Department Week Aggr Entity Relationships
2-71 Inventory Position By Item Week Aggr Entity Relationships
2-72 Inventory Position Subclass Day Aggr Entity Relationships
2-73 Inventory Position Subclass Week Aggr Entity Relationships
2-74 Inventory Receipt By Item Day Aggr Entity Relationships
2-75 Inventory Receipt By Item Week Aggr Entity Relationships
2-76 Inventory Receipt By Subclass Day Aggr Entity Relationships
2-77 Inventory Receipt By Subclass Week Aggr Entity Relationships
2-78 Inventory Transfer By Item Day Aggr Entity Relationships
2-79 Inventory Transfer By Item Week Aggr
2-80 Inventory Transfer By Subclass Day Aggr
2-81 Inventory Transfer By Subclass Week Aggr Entity Relationships
2-82 Inventory Vendor Compliance Aggr Entity Relationships
2-83 Market Sales Department Week Aggr Entity Relationships
2-84 Promotion Cost Contribution Week Aggr Entity Relationships
2-85 Promotion Sales Margin Week Aggr Entity Relationships
2-86 Retail Markdown Department Day Aggr Entity Relationships
2-87 Retail Markdown Department Week Aggr Entity Relationships
2-88 Retail Markdown Item Day Aggr Entity Relationships
2-89 Retail Markdown Item Week Aggr Entity Relationships
2-90 Retail Sale Return Organization Hierarchy Day Aggr Entity Relationships
2-91 Retail Sale Return Department Day Aggr Entity Relationships
2-92 Retail Sale Return Department Week Aggr Entity Relationships
2-93 Retail Sale Return Department Month Aggr Entity Relationships
2-94 Retail Sale Return Item Week Aggr Entity Relationships
2-95 Retail Sale Return Subclass Day Aggr Entity Relationships
2-96 Retail Sale Return Subclass Month Aggr Entity Relationships
2-97 Retail Sale Return Subclass Week Aggr Entity Relationships
2-98 Retail Transaction Emp Workstation Aggr
2-99 Space Utilization Department Day Aggr Entity Relationships
2-100 Stock Ledger By Subclass Month Aggr Entity Relationships
2-101 Stock Ledger By Subclass Week Aggr Entity Relationships
2-102 Till History Workstation Aggr Entity Relationships
2-103 Till Tender History Employee Aggr Entity Relationships
2-104 Vendor Availability Item Day Aggr Entity Relationships
2-105 Vendor Compliance Item Week Entity Relationships
2-106 Vendor Compliance Week Aggr Entity Relationships
2-107 Vendor Contract Item Day Aggr Entity Relationships
3-1 Organization Dimension
3-2 Product Dimension
3-3 Time Dimension

Copyright © 2009, Oracle and/or its affiliates. All rights reserved.
Legal Notices