RHOP uses the concept of Objects which regroups affiliated relationships from the data stored into your database into accessible objects for querying and reporting purposes. To understand your data you must understand the underling relationships between the various fields and tables that store the data of your system. This section attempts to simplify the organization of your various tables and fields that make up your database and how the data is organized for retrieval purposes. This section does not purport to provide extensive or comprehensive details on the database or object structure used in RHOP but rather provide a guidance for determining which object/table to use for a given task or for reporting purposes.
Definitions:
Database Tables: A relational database is made up of several components, of which the table is most significant. The database table is where all the data in a database is stored, and without tables, there would not be much use for relational databases. A database consists of one or more tables. RHOP has over 100 tables that regroups common information in one location/table. A database table is a structure that organises data into rows and columns – forming a grid. Tables are similar to a worksheets in spreadsheet applications. The rows run horizontally and represent each record. The columns run vertically and represent a specific data field. The rows and columns intersect, forming a grid. The intersection of the rows and columns defines each cell in the table.
Each row in a relational table is uniquely identified by a Primary Key. This can be by one or more sets of column values. In most scenarios it is a single column, such as employeeID. The purpose of the Primary Key is to uniquely identify each row in the database. No two rows can have the same primary key value. The practical result of this, is that you can select every single row (Data Record) by just knowing its Primary Key.
Objects: In RHOP, objects are used to regroup various (several) tables into a relational object structure that understands the various relationships between the tables making it easier for users to access all data related to an object subject matter. For example an employee object can automatically provide access to an employee profile data as well as the employee security restrictions as well as an employee position/role and personal demographics tables as well as activity Audit logs related to an employee. By creating a single employee object containing all of the previous linked tables make it easy for users to find any information related to an employee without having to know how to link each table or understand the intricacies of the data structure of the database to be able to retrieve the required data.
RHOP Major Data Objects:
This is not a listing of all data objects available in RHOP but rather a description of the major objects a user will potentially want to use for reporting purposes. A user can view the reporting objects available to them when using the New Report wizard.
In the image above we have highlighted the Purchases object as the data type we wish to use in the New report. Once selected, the Purchases object regroups all activities related to a member purchase. For example the Purchase object includes the tables related to:
•Purchase object (all purchases done by a member.)
•Manufacturer object
•Member/Establishment object
•Membership Program object
•Product Guide Item object
•Product Line object
•Promotional Rebate Units object
•Purchase Import Files object
•Rebate object
•Rebater object
•Standard Rebate Unit object
•Supplier / Distributor object
•User object
•Warehouse object
As you can see from the above example, an object can provide easy access to a volume of data without the user having to create links to each piece of information they wish to access. An object is a very powerful data structure for RHOP. Each object name defines the content of what is included in the object. Below are the objects that users will more commonly use and what they contain as information. Note that that Change Log objects are in addition to the RHOP built-in Audit system which contains its own log data structure.
Administration Fees: Contain the table Administration fee and all related information regarding Administration fees.
Brand Name: Contain the table Brand name and all related information regarding Brand information
Broker: Contain the table Broker and all related information regarding Broker information
Broker Contacts: Contain the table Broker Contacts and all related information regarding Broker Contact information
Broker Documents: Contain the table Broker Documents and all related information regarding Broker documents
Broker Notes: Contain the table Broker Notes and all related information regarding Broker Notes
Business Owners: Contain the table Business Owners and all related information regarding Business Owners
Business Owners Contacts: Contain the table Business Owners Contacts and all related information regarding Business Owners Contacts
Business Owners Documents: Contain the table Business Owners Documents and all related information regarding Business Owners Documents
Business Owners Rel: Contain the table Business Owners Relationships and all related information regarding Business Owners Relationships
Business Owners Notes: Contain the table Business Owners Notes and all related information regarding Business Owners Notes
Company Information: Contain the table Company Information and all related information regarding Unipco (Company Profile).
Contact Position: Contain the table Contact Position and all related information regarding a Contact Position.
Document Type: Contain the table Document Types and all related information regarding Document Types created by users.
Drop Size: Contain the table Drop Size and all related information regarding Drop Size.
Employee: Contain the table Employee and all related information regarding Employees registered in RHOP.
Employee Position: Contain the table Employee Position and all related information regarding Employees Positions in RHOP.
Employee Region: Contain the table Employee Region and all related information regarding Regions that Employees are assigned in RHOP.
Manufacturer: Contain the table Manufacturer and all related information regarding Manufacturers.
Manufacturer Category: Contain the table Manufacturer Category and all related information regarding Manufacturers Categories defined in RHOP.
Member: Contain the table Member and all related information regarding Members.
Member Account: Contain the table Member Account and all related information regarding Member Accounts.
Member Category: Contain the table Member Category and all related information regarding Members categories defined in RHOP.
Member Contact: Contain the table Member Contact and all related information regarding Member Contacts.
Member: Contain the table Member and all related information regarding Members.
Member Document: Contain the table Member Document and all related information regarding Member Documents.
Member Notes: Contain the table Member Notes and all related information regarding Member Notes.
Member Program History: Contain the table Member Program history and all related information regarding Members participation in various programs
Member Prospect Information: Contain the table Member prospect Information and all related information regarding Members application to a program.
Member Rebate Cheque: Contain the table Member rebate cheque and all related information regarding Cheque issued to a Members.
Member Rebate Exceptions: Contain the table Member Rebate Exception and all related information regarding a Member rebate exception.
Member Rebate Program: Contain the table Member Rebate Program and all related information regarding the user defined Member Programs in RHOP.
Preferred Language: Contain the table Preferred language and all related information regarding the Preferred Language identified with a record.
Product: Contain the table Product and all related information regarding Product.
Product Alias: Contain the table Product Alias and all related information regarding the alias name of a product.
Product Brand: Contain the table Product Brand and all related information regarding the the brand of products.
Product Brandname: Contain the table Product Brandname and all related information regarding the the brand name of products.
Product Guide Rebate Exception: Contain the table Product Guide Rebate Exception and all related information regarding the the Product Guide Rebate exceptions.
Product Line: Contain the table Product Line and all related information regarding the the Product Line.
Product Note: Contain the table Product Note and all related information regarding the the Product Notes.
Product Supplier Name Alias: Contain the table Product Supplier Name Alias and all related information regarding the the Supplier Name Alias
Product Unit: Contain the table Product Unit and all related information regarding the the Product Unit define in RHOP.
Promotional Rebate: Contain the table Promotional Rebate and all related information regarding the the Promotional Rebates.
Promotional Rebate Change Log: Contain the table Promotional Rebate Change Log and all related information regarding the the Promotional Rebates Change log.
Promotional Rebate Product Guide Item: Contain the table Promotional Rebate Product Guide Item and all related information regarding the the Promotional Rebates Product Guide Items.
Purchase Periods: Contain the table Purchase Periods which is a special table containing all dates of created Purchase Periods in the system. This table is used primarily as a look up table for reports to select a Purchase date.
Purchases: Contain the table Purchases and all related information regarding ALL Purchases made by members.
Purchases Import Files: Contain the table Purchases Import Files and all related information regarding import files loaded into RHOP.
Rebatable Purchases: Contain the table Rebateable Purchases and all related information regarding ONLY Rebateable Purchases made by members.
Rebate: Contain the table Rebate and all related information regarding Rebates entered into the system.
Rebate Amount Change log: Contain the table Rebate Amount Change Log and all related information regarding changes made to Rebate Amounts.
Rebate Change log: Contain the table Rebate Change Log and all related information regarding changes made to Rebate.
Rebate Exception Change log: Contain the table Rebate Exception Amount Change Log and all related information regarding changes made to Rebate Exceptions.
Rebate Product Units: Contain the table Rebate Product Units and all related information regarding Rebate Product Units
Region: Contain the table Region and all related information regarding Regions defined in RHOP.
Role: Contain the table Role and all related information regarding User Roles defined in RHOP.
Region: Contain the table Region and all related information regarding Regions defined in RHOP.
Standard Rebate: Contain the table Standard Rebate and all related information regarding the Standard rebates defined in RHOP
Supplier /Distributors: Contain the table Supplier /Distributor and all related information regarding Supplier Distributors defined in RHOP
Supplier /Distributors Contact: Contain the table Supplier /Distributor Contacts and all related information regarding Supplier Distributors Contacts defined in RHOP.
Supplier /Distributors Documents: Contain the table Supplier /Distributor Documents and all related information regarding Supplier Distributors Documents stored in RHOP.
Supplier /Distributors Categories: Contain the table Supplier /Distributor Categories and all related information regarding Supplier Distributors Categories defined in RHOP.
Supplier /Distributors Notes: Contain the table Supplier /Distributor Notes and all related information regarding Supplier Distributors Notes stored in RHOP.
Supplier /Distributors Rebate Claim Note: Contain the table Supplier /Distributor Rebate Claim Note and all related information regarding Supplier Distributors Rebate notes defined in RHOP.
Territory Manager: Contain the table Territory Manager and all related information regarding Territory Manager defined in RHOP.
Territory Manager Notes : Contain the table Territory Manager Notes and all related information regarding Territory Manager notes stored in RHOP.
Territory Manager: Contain the table Territory Manager and all related information regarding Territory Manager defined in RHOP.
User: Contain the table User and all related information regarding Users defined in RHOP.
Warehouse Management Fees: Contain the table Warehouse Management Fees and all related information regarding Warehouse Management fees defined in RHOP.
Warehouse Sub-Groups: Contain the table Warehouse Subgroups and all related information regarding Warehouse Subgroups defined in RHOP.
.