CA2381782A1 - Livestock inventory and materials system with interactive graphical user interface - Google Patents

Livestock inventory and materials system with interactive graphical user interface Download PDF

Info

Publication number
CA2381782A1
CA2381782A1 CA002381782A CA2381782A CA2381782A1 CA 2381782 A1 CA2381782 A1 CA 2381782A1 CA 002381782 A CA002381782 A CA 002381782A CA 2381782 A CA2381782 A CA 2381782A CA 2381782 A1 CA2381782 A1 CA 2381782A1
Authority
CA
Canada
Prior art keywords
data
window
tree structure
set forth
hierarchical tree
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Abandoned
Application number
CA002381782A
Other languages
French (fr)
Inventor
Lori A. Janes
William C. Miller, Iii
Alan R. Davidson
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
CATTLEMAN'S RESOURCE Inc
Original Assignee
Individual
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Individual filed Critical Individual
Publication of CA2381782A1 publication Critical patent/CA2381782A1/en
Abandoned legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S715/00—Data processing: presentation processing of document, operator interface processing, and screen saver display processing
    • Y10S715/961—Operator interface with visual structure or function dictated by intended use
    • Y10S715/962—Operator interface for marketing or sales

Abstract

The invention includes a livestock and material inventory system which comprises a database storing inventory data, at least one data explorer operable to access predetermined portions of data in the database, and a graphical user interface operable to display data accessed by the at least one data explorer to a user. The graphical user interface includes a first window operable to display a hierarchical tree structure representation of the inventory data, and a second window operable to display a data summary associated with a selected node in the hierarchical tree structure.

Description

LIVESTOCK INVENTORY AND MATERIALS SYSTEM WITH
INTERACTIVE GRAPHICAL USER INTERFACE
TECHNICAL FIELD OF THE INVENTION
This invention is related in general to the field of computer software, and more particularly, to a livestock inventory and materials system with an interactive graphical user interface.
RELATED PATENT APPLICATION
This patent application claims the benefit of provisional application Serial No. 60/096,536, titled Livestock Inventory and Materials System Driven From a Hierarchical Tree Graphical User Interface, filed on August 13, 1998.
BACKGROUND OF THE INVENTION
When managing livestock and materials used by livestock, it is imperative but extremely difficult to keep an inventory system current and accurate. The conventional inventory system uses a text-based user interface that typically involves a menu of inventory activities, for example, animals movements, incoming animals, outgoing animals, incoming materials, and material usage. Both livestock and materials inventories can be quite complex. For example, livestock inventories must accurately represent the type of animal, and its breed, sex, origination, age, size, and many other characteristics in addition to current and past locations.
To know what animals and materials are at what locations, for example, the user must either run a paper report or look up the current inventory on a screen, and then switch to an activity entry menu or screen to enter the movement or other required activity. When the user is entering the activities he/she is no longer able to see the inventory. After entering the activity, the user must return to the inventory report or screen again to verify that the activity just entered was processed correctly by pulling the correct item from a first location and moved (in example ofthe movement activity) the item to the correct second location. Multiple reports including summaries and detail of both source location and destination location must be run and laid next to each other to understand the overall hierarchical relationships of the inventories as well as the detailed information.
With some activities, characteristics of livestock also changed during the activity and therefore the user must run even more reports to view the inventory from various views and characteristics (again, summary and detail of multiple characteristics) to verify that the activity was input and processed correctly.
All of these user interactions must be done to verify just a single entered activity. With this conventional approach, inventory maintenance is extremely time consuming and the inventory is often inaccurate or not up to date.
These conventional systems typically require a user with strong computer skills to use and maintain the inventory. Therefore, often the person that manages the inventories must fill out paper forms which are then given to the computer-skilled person to input. The computer-skilled user then reconciles the data and may have to call back to the manager for more information if the reported activities have errors. The inventory manager then must verify the resulting current inventory for accuracy. This process results in more inaccuracy and double or triple the man-hours. Further, the inventory manager does not know the current inventory until the computer-skilled office personnel enters the data and obtains. an updated report to the inventory manager. Therefore, the inventory manager often does not have the most up to date view of the inventory available.
In summary, livestock managers were limited by inaccurate inventories for which the staff was spending a large effort attempting to maintain.
SUMMARY OF THE INVENTION
Therefore, a need has arisen for a system and method of livestock and material inventory tracking and management that provides an interactive graphical user interface that not only provides the user different views or data summaries of the data, but also allows the user to easily change the data to reflect completed business transactions and also to enter new data. It is desirable for the user to see the current data at all times while he/she is changing data or entering new data. It is also desirable to allow the user to easily change the criteria and scope for the data to be displayed.
In one aspect of the invention, an interactive graphical user interface window of a livestock and materials inventory system includes a first window operable to display a hierarchical tree structure representation of inventory data, and a second window operable to display a data summary associated with a selected node in the hierarchical tree structure.
In another aspect of the invention, a livestock and material inventory system comprises a database storing inventory data, at least one data explorer operable to access predetermined portions of data in the database, and a graphical user interface operable to display data accessed by the at least one data explorer to a user. The graphical user interface includes a first window operable to display a hierarchical tree structure representation of the inventory data, and a second window operable to display a data summary associated with a selected node in the hierarchical tree structure.

In yet another aspect of the invention, a method of tracking livestock and materials inventory includes the steps of selecting a business application environment, selecting a data explorer having access of specific predetermined sets of data in a database, organizing and displaying the accessed data in a hierarchical tree structure in a first window following a selected organizational criteria and in response to the selected business application environment, selecting a node of the hierarchical tree structure, and displaying data summaries associated with the selected node in a second window.
A technical advantage of the present invention is the interactive graphical user interface that not only displays the data in a user-specifiable organizational manner, but also allows the user to easily enter a business transaction by drag and drop methods. The graphical user interface allows the user to set and change any number of criteria for displaying and summarizing the data. A
further technical advantage of the present invention is the multi-tiered and modular architecture of the system that allows future business applications and data explorers to be developed with substantially shortened development time. A generic data explorer object is used to instantiate function-specific data explorers so that the data explorers share common properties and provide a common and seamless presentation to the user.
BRIEF DESCRIPTION OF THE DRAWINGS
For a more complete understanding of the present invention and advantages thereof, reference is made to the accompanying drawings, in which:
FIGURE 1 is a functional block diagram ofthe livestock and materials inventory system and method according to the teachings of the present invention;
FIGURES 2A-2J are embodiments of graphical user interfaces according to the teachings of the present invention;
FIGURE 3 is a block diagram of an embodiment of the inventory database of the present invention;
FIGURE 4 is a functional block diagram showing the multi-tiered architecture of the present invention;
FIGURE 5 is a flow diagram of an embodiment of a control and processing portion of the present invention;
FIGURE 6 is a graphical user interface showing an embodiment of a Windows registry according to the teachings of the present invention;
FIGURES 7 and 8 are diagrams showing the population of the hierarchical tree structure according to an embodiment of the present invention;
FIGURE 9 is a flow diagram showing an embodiment of the control and processing portion of the presentinvention;
FIGURE 10 is a diagram showing an embodiment of the drag and drop method according to the teachings of the present invention; and FIGURE 11 is a diagram showing an embodiment of selecting a business application environment according to the teachings of the present invention.
DETAILED DESCRIPTION OF TIIE INVENTION
FIGURE 1 is a block diagram of the livestock inventory and materials system 10 of the present invention. System 10 includes a database 12 that stores all the data related to the user's agricultural business.
Database 12 may be implemented as a relational database, object-oriented database, relational object-oriented database, or in any suitable technology and architecture. Agriculture explorer 14 is an umbrella process or environment that includes a number of data explorers 20-24 that may be used for many different agricultural and ranch business applications 26-30. Data explorers 20-24 access and provide different slices of data stored in database 12 so that the data is presented in a manner that makes sense for the particular business application. The user is able to look at and navigate around various aspects ofthe data with the simple clicks of a mouse button.
Data explorers 20-24 include order explorer 20, which, is a process that provides data summaries associated with customer orders. Buyer explorer 21 is a process that provides data summaries associated with invoices and purchases. Buyer explorer 22 thus allows a user to access and view livestock and material purchase transactions. Livestock explorer 22 is a process that provides data on livestock by location, type, owner, or history, etc. Supply inventory explorer 23 is a process that provides data summaries of movement activities (e.g. incoming, outgoing, harvest, movements in, movements out, purchase, apply, sell) associated with supplies. Supply usage/harvest explorer 24, on the other hand, is a process that provides data summaries associated with the usage and harvest of supplies.
Business applications in which the data explorers may be used include order-buyer business application 26, which provides data summaries associated with customer orders as well as invoice purchases of buyers from vendors. The user may use order-buyer application 21 to find, buy, and resell cattle to other livestock businesses. It may be noted that order-buyer application 21 is a combination of order explorer 20 and buyer explorer 22 and accesses and presents data used in both business applications. Buyer-stocker business application 27 may use a combination of livestock, buyer, supply inventory and supply usage/harvest explorers to keep livestock inventory and track purchases, feeding, treatment and sale of livestock. Supply tracker business application 28 may use a combination of the supply inventory and supply usage/harvest explorers to track supply inventory and supply usage. Feed-lot business application 29 may use a combination of the livestock, supply inventory, supply usage/harvest, and buyer explorers to track livestock inventory to final fed-weight, custom feeds, and treatments within a feed lot. Cow-calf business application 30 may use a combination of the livestock, buyer, breeding, and supply explorers to track breeding and production inventory and feeding at a breeding ranch.
When a data explorer is used in the context of a business application, the data presented in the data explorer is adapted so that it is meaningful in that context. The data explorers each provides access to or view of specific well-defined portions of database 12 that are meaningful for the specific business applications. For example in an order-buyer business application, livestock is purchased and immediately applied directly to a sale. Therefore, because in the order-buyer business application, livestock stay in physical inventory for only a short period of time, just using a physical inventory viewer alone that looks at more permanent inventory such as the livestock explorer is not useful or meaningful.
Livestock inventory and materials system 10 has a second component that includes a graphical user interface (GUI) 16 that provides a window-based interface with a menu bar with drop-down lists, a tool bar, clickable icons and buttons, a hierarchical tree structure, and tabbed pages displaying data summaries.
Details of graphical user interface are described below in conjunction with references to FIGURE 2.
A third component of livestock inventory and materials system 10 is the control and processing modules 18 that store and process data based on user initiated events or user-entered data. Depending on the specific data explorer environment that is currently active, the user's input is processed according to the business rules of the active business application. Therefore, the same user input may generate two different results in two different business application environments. Details of control and processing modules 18 are described below.
Referring to FIGURE 2A for an exemplary screen print 40 of an exemplary data explorer showing some of the common graphical user interface elements shared by all the data explorers. Screen print 40 shows what a cow-calf explorer graphical user interface may look like. The graphical user interface may include a number of pull-down lists 42-44. Pull-down list 42 provides the user the capability to select the inventory view, which may be by location, owner, animal type, age, sex, breeding status, weight group, or other user-defined criteria. Pull-down list 43 provides the user the capability to select the as of date for the data shown. Pull-down list 44 provides the selection of which inventory to display, which may include livestock, materials or both. Such pull-down lists may be used to limit or focus the data displayed in a hierarchical tree data structure 46 displayed in a left-hand panel or window 47. For example, hierarchical tree data structure 46 shows a breakdown of geographical locations since that is what is selected in pull-down list 42.
It may be noted that USA is the top node, which has seven branches denoting states (Texas, Oklahoma, Florida, Wyoming, Colorado, Nebraska, and Kansas). Some of the states or branches are further broken down into regions such as Texas, and other states are terminal nodes such as Florida. Some regions are even further broken down into multiple sub-regions or ranches/pastures, such as the Panhandle of Texas is broken down into Bob's Place and High Country Pasture. Therefore, hierarchical tree data structure 46 includes a top node, with one or multiple branches, each of which may include zero, one or more sub-branches and/or leaves (terminal nodes). The number of branching and the number of levels of branching are not limited. Each node with sub-nodes may be displayed as expanded (those noted with a "-" symbol) or contracted (those noted with a "+" symbol).
In the right-hand panel or window 48, tabbed data summary pages 50 are displayed. Tabbed data summary pages 50 may present details and summaries of data represented in various ways, including tables, charts, graphs, maps, images, videos, and other data representations. Pull-down list 44 may also be used to I S limit or focus the data displayed in right-hand panel 48. The user-selected livestock inventory as of 5/16/98 for the location selected or highlighted (or noted by the pointing hand cursor) in left-hand panel 47 is displayed in tabbed data summary pages 50. Because the G4F Ranch node of Wyoming is selected in hierarchical tree data structure 46, the livestock inventory for that location is displayed in right-hand panel 48. The inventory displayed is attributable to both the front and back pastures of the G4F Ranch, because the G4F Ranch can be further broken down into the front pasture and the back pasture, and that the G4F
Ranch, not an particular sub-region, is selected. If the user so desires, he/she may view livestock inventory of the specific pasture by selecting it in the hierarchical tree data structure. Similarly, if the top node (LISA) is selected, all livestock at all locations are displayed in the right-hand panel. Therefore, the selection of the node in the hierarchical tree data structure determines the scope of the data displayed in the tabbed data summary pages.
Tabbed data summary pages 50 includes multiple pages of data that can be "flipped" to by selecting or clicking on the respective tabs. The same data focused and narrowed by the pull-down lists and hierarchical tree node selection is shown on the various tabbed pages in a number of ways. Therefore, the inventory data can be summed, subtotaled, and selectively displayed in the various tabbed pages. For example, if the Item/Status Tab is activated, the inventory item details and the status of the inventory item are summed. The displayed head count and average weight columns then represent the total head and average weight across all livestock with equal description and status and are located in any sub-level of the active level.
Clickable buttons 52 are also provided to allow the user to select specific inventory activities, such as moving livestock or other inventory from one location to another. Control and processing modules 18 also simplifies this process by allowing the user to pick up inventory from one location and drop it in another location (or from one data explorer to another data explorer) using a drag and drop technique. The drag and drop technique and other details of control and processing modules 18 are described below.
FIGURES 2B-2E are exemplary screen prints of the graphical user interface of agriculture explorer 14 with different selected business application environments including feed fed 29, stocker 27, and order buyer 26. It may be seen that the tool bar icons have been changed to reflect the nature and needs of the selected business application. The user may then select the data explorer with which he/she desires to view the data. FIGURES 2F-2J are exemplary screen prints of the graphical user interface of various data explorers - order explorer 20, buyer explorer 21, supply inventory explorer 23, supply usage/harvest explorer 24, and livestock explorer 22. The data explorer windows are laid inside the agriculture explorer window, and may be configured in a number of ways, such as tile, cascade, etc.
Appendix A includes a list of the types of data that may be summarized and displayed for each data explorer.
FIGURE 3 is a block diagram of exemplary tables of database 12 according to the teachings of the present invention. Database 12 is made up of a number of tables which are related to one another, each table storing several fields of related data. Exemplary tables in database 12 may include:
~ Associates (60) - contains information about all individuals used by the various applications, such as customers, buyers, and vendors ~ ExpenseTypes (62) - types of expenses, such as livestock purchase, freight, medicine etc.
~ InventoryTypes (64) - types or groupings of inventory ~ LivestockActivityDetail (66) - Details of livestock transactions ~ LivestockActivityMaster (68) - Livestock trasactions ~ LivestockActivityTypes (70) - Types of Livestock transactions ~ LivestockInventory (72) - Livestock inventory on hand ~ LivestockType (74) - types of livestock ~ Locations (76) - locations to put livestock or inventory ~ OrderItem (78) - details on livestock and expenses applied to fill an order ~ Orders (80) - what is ordered ~ Owner (82) - Who owns the livestock ~ PurchaseDetail (84) - details on what was purchased ~ PurchaseMaster (86) - purchases (detail of purchase in PurchaseDetail) ~ PurchaseTypes (88) - type of purchase ~ Quality (90) - subjective description of the quality of the livestock ~ SupplyActivityDetail (92) - detailed records of activity (history) of inventory ~ SupplyActivityMaster (94) - transactions ~ SupplyActivityTypes (96) - types of supply activity ~ SupplyInventory (98) - inventory on hand ~ SupplyItems (100) - items that can be in inventory ~ UnitTypes ( 102) - by pound, or by the bale, etc.
The relational links between the various tables are shown in FIGURE 3. The following provides examples of some of the main tables (in addition to shared supporting tables like Associates, Locations, etc.) may be accessed by each data explorers:
~ Order Explorer - Orders and OrderItem tables ~ Buyer Explorer - PurchaseMaster table and the PurchaseDetail table ~ Supply Inventory - SupplyActivityMaster, SupplyInventory, and SupplyActivityDetail tables ~ Supplies Usage/Harvest - SupplyActivityMaster and SupplyActivityDetail tables ~ Livestock Explorer - LivestockActivityMaster, LivestockInventory, and LivestockActivityDetail tables FIGURE 4 is a diagram showing the mufti-tiered architecture of system 10 according to the teachings of the present invention. The data explorers such as buyer 22, livestock 24, order 20, supply inventory 25, and supply usage/harvest 26, etc. are constructed from instances 110-112 of a common generic explorer object. The generic explorer is defined to have a set of graphical user interface properties, such as a title bar, a tool bar, clickable icons and/or buttons, a left panel that provides an hierarchical tree-structured view of the data, and a right panel that provides detailed information on a specific node of the tree such as shown in FIGURE 2. Each data explorer has an underlying control module 114-116 with the appropriate functions to create the associated function-specific explorer from the generic explorer object. For example, an OrderExplorer control module 114 has the specific methods or steps to build an order explorer instance 110 ofthe generic explorer object. Thus, the user can dynamically open multiple data explorers to gain different insight into the data. Referring also to FIGURES 5 and 9, generic data explorer 110 may be configured according to the specific events or methods specified in explorer control module 114. When the user opens an explorer of a particular function or for a particular business application, a specific series of events or methods of explorer control module 114 is called. For example, a Form Load event is called to retrieve window configuration and settings (block 140). Setup Menu is also called to determine and display the available button and pull-down list selections. Form Load then calls a Fill Tree method that loads the hierarchical tree structure in the left panel (block 142). Fill Tree then calls the selected (or default) Load-Tab routines which load the right panel with tabbed pages of information, as shown in block 144. To speed up execution, only the data associated with the selected or the default (usually the leftmost tab) tab pages is loaded.
In particular, when Order Explorer is opened, for example, the Form Load event calls a function named Read Registry that reads Windows (95, or 98) registry values, an example of which is shown in FIGURE 6. The Windows registry contains information on the visual attributes that the user is able to set and change, such as the position and size of the left and right panels or the sizes of various columns in the tabbed pages in the right panel, etc. This information is stored for each data explorer. The Read Registry function is passed the data: Key to Read, Value to Read, Create If Doesn't Exist, Default value.
Read Registry returns the data found in the Windows registry, or if no data was found it returns the default value. The Order Explorer may repeatedly call the Read Registry function to determine the last state of the View All, Show Customer, Show Orders, Display By, and the right panel tab controls, such as SSTab, a software program provided by Sheridan Software Systems, Inc. of Melville, New York.
The Form Load event then calls the Fill Tree subroutine. The Fill Tree subroutine accesses Locations table 76 (FIGURE 3) to obtain parent and child information to build and populate the tree control in the left panel of the active data explorer. An example of a tree structure and its associated location table is shown in FIGURES 7 and 8. Note in FIGURE 7, only the details of the selected branch is shown in the right panel, and in FIGURE 8, all the data associated with the top node is displayed in the right panel. The left panel tree hierarchy can be configured according to user specifications.
The bottom-most nodes (terminal nodes) of any branch are the only nodes, in that branch, that may contain data. This means that while one branch of the tree may go through four levels to reach the terminal nodes, another branch may only have two levels. In the various database tables the relationship between nodes is saved. For example, the field ParentID in the Locations table contains the LocID (LocationID) of the Parent of a node. In the case of the Supply Inventory Explorer, for example, the Fill Tree subroutine queries the Locations table joined to the SuppIyInventory table. The resulting recordset contains the ParentID
for each record. The top node will have a 0 (for this invention we set the field to default to 0, but start numbering all indexes at 1, so that 0 is in effect No ID) for its ParentID, but all other nodes will have a parent location's LocID as its ParentID.
The Fill Tree method loops through the recordset and populates one branch at a time by finding the next lower node using the ParentID field, until all the branches are built.
The Fill Tree subroutine loads and sets the state of the control. The sequence is as follows. First turn redraw off, clear all nodes, and choose either a set of large icons, or a set of small icons for the tree (according to registry entry). Next build the SQL (standard query language) query for the tree. The SQL
query is built according to the selections made on the explorer tool bar. For example, for the Order Explorer, the user may indicate if all customers are to be shown in the left panel, or just customers with orders. .
In the Order Explorer example, the join function is made between the Associates table and either the Orders table, the OpenOrders view of the Orders table (all records where the Status is Open), or the Closed Orders view of the Orders table (all records where the Status is Closed). The Associates table contains information on all individuals (customers, buyers, vendors etc.) so the query is limited to customers only in ' its WHERE clause. An example of the resulting exemplary query for all orders and showing all customers ~s SELECT Associates.AssocID, Associates.Name, Associates.Addressl, Associates.Address2, Associates.City, Associates.State, Associates.Zip, Associates.Phone, Associates.Customer, Associates.Vendor, Orders.OrderID, Orders.RefNbr, Orders.DateOpened, Orders.Description FROM
Associates LEFT JOIN Orders ON
Associates.AssocID = Orders.AssocID WIRE
Associates.Customer = Yes ORDER BY
Associates.Name ASC, Orders.DateOpened Asc The recordset that is returned by this query is used to populate the hierarchical tree structure. The Top node is added. Each node has a key (a unique identifier for the node), text (to display), relative, and relationship.
Each node's position in the tree hierarchy is established by entering another node's Key as its relative, and listing the other node as a parent, child, or sibling. The nodes are created using the tree control's Add method. The subroutine loops through the recordset from beginning to end, and adds a second level node for each customer if the Show Customers option has been selected. The level is set by using Top (the key 3 S for the top node) as the relative property (to refer to the top node), and child as the relationship (to indicate that the customer node is a child of the top node). Similarly the orders made by each customer are added as child nodes of the customer node. All nodes other than the top node are assigned a number as their key in order as the key is created (1, 2, 3, and so on). Additionally all nodes have an optional DataKey, which is a non-unique value used to further describe the node. This application assigns actual IDs to the DataKey property for each node other than the top node. Each customer node has the DataKey set to its AssociateID, and each order node's DataKey is the OrderID. Each level of node is also assigned icons for its non-selected, selected, and expanded states. The text used for the Customer level is the customer name. The text used for the order level is either the RefNbr (Reference number) or the Description from the recordset depending on whether the user has selected Display by Reference or Display by Description.
If the customer had previously selected a node the value is read from the registry and that node is set as the selected node, otherwise the top node is set as the selected node and this is recorded in the registry. Now that the selected item has been set, the tool tips for the five tree tools can be set. The tools may include:
~ Expand All Nodes ~ Collapse All Nodes ~ Add (i.e. Add a Customer, Add an Order) ~ Delete (i.e. Delete this Customer, Delete this Order) ~ Edit (i.e. Edit this Customer, Edit this Order) The last step taken in the Fill Tree subroutine is a cal l to one of the Load subroutines to load detailed data for display into the right panel. The specific Load routine is determined by the tab property of the tree tab control which indicates the current or active tab on the user's screen.
The right panel view is loaded using information from the left panel selection to limit its results. The tree is used to build a recordset of the OrderIDs of all terminal nodes of the selected branch, and this recordset is joined to the Load query that-is used to retrieve the data for the selected tab in the right panel. Thus, the detailed data displayed in the right panel are limited according to the node selection in the left panel. Each node that is added programmatically to the left panel has several methods and events that are used within the program, as well as built-in behavior.
By clicking on the "+" symbol next to the node the immediate children of that node are displayed (expanded), and by clicking on the "-" symbol next to an expanded node the node's children are hidden (collapsed). All other visual behavior of the nodes is handled programmatically, for example, the user can click on a selected 3 0 node's text, and edit it which results in an AfterLabelEdit event firing where the change can be validated and saved. If the user clicks on the Expand All icon, the program loops through all the nodes in the tree and sets the expanded property to true. The program controls the various properties of each node, such as the icon that represents the node, and how the lines between the nodes are drawn.
Referring to FIGURE 5, in the case of the Order Explorer, four different Load subroutines are used to load the four tabbed views available in the right panel. The Fill Tree subroutine calls the Load subroutine for the active tab or the default tab. If a user clicks on a different tab to change the view the active tab (the tab property) for the tab control is automatically set to the tab the user choose, and the Tab Click event fires.
In the Tab Click event a case structure calls the Load subroutine for the tab chosen.
In the Order Explorer example, the right panel contains various views of Orders table 80 and OrderItem table 78 (FIGURE 3), which contains detailed information about the cattle, and other expenses that have been applied to each order. An OrderID links the Orders table with the OrderItem table. The right panel of the Order Explorer may contain four tabs, where each tab contains a different view of the data contained in the two tables. The information may be read from multiple tables and is retrieved using SQL
query to join the Orders table to the OrderItem table by the field OrderID.
Thus the details about the expenses applied to an order is combined with the information about what was ordered, and then displayed to the user.
The first tab in the right panel ofthe Orders Explorer, Order Summary, contains a one line summary of the order and its status. The information is created by both an aggregate (summary) query which totals all costs from the OrderItem table, and a join with the order information in the Orders table to create a single summary record showing what has been placed on the order and what was ordered.
The second tab, Cattle Detail, contains a one line summary for every group of cattle used to fill the order. Cattle from several sources may be used to fill the order, and each group has a separate record in the OrderItem table. The OrderID arnibute joins the tables, but an additional restriction is used in the SQL query - only records from the OrderItem table that refer to cattle are joined to the Orders table. The third tab, Cost Summary is similar to Order Summary except that the costs are totaled by expense type rather than making one grand total.
Expense types include livestock purchase, freight, medicine, commission etc., and can be customized by the user. One line per expense type is displayed in the Cost Summary view. The fourth tab, Cost Detail, contains one line for each applied cost, including livestock. The behavior of the tabs according to the selected node is shown below:
Tab Top Node Customer Node Order Node Order all orders selected customer selected order orders Summary Cattle all orders selected customerselected order orders Detail Cost summed across summed across summed for the all selected Summary orders customer orders selected order Cost all lines for all details for all detail for Detail all orders selected the customer selected order A more complete list of the tables used to create the right panel views (for the Order Explorer) may include PurchaseMaster, PurchaseDetail, ExpenseTypes, OrderItem, Orders, Associates, Quality, and LivestockType.
In the order explorer example, the Load Summary subroutine loads data into the Order Summary tab, Load Detail routine loads data into the Cattle Detail tab, Load CostDetail routine loads data into the Cost Detail tab, and Load CostSummary routine loads data into the Cost Summary tab.
In the Load Summary subroutine, the query is built first. The query varies with the selected level of the tree in the left panel. The top level contains information on all orders, the customer level contains information on that customer's orders, and the order level only contains information about the selected order.
The exemplary query built for the view of all orders to show the one line summary may be:
SELECT Associates.Name AS Customer, Orders.RefNbr AS Reference, Orders.OrderID, Orders.Status AS Open, Orders.DateOpened AS
(Order Date], Orders.DateInvoiced AS [Inv Date], OrderItemTotals.LatestDate AS [Date Modified], LivestockType.Description AS
Livestock, Orders.Qty AS [Hd Ordered], Orders.Loads AS [Loads Ordered], Orders.MinWeight AS [Min Wt], Orders.MaxWeight AS [Max Wt], Orders.MaxPrice AS [Max Price], IIf(OrderItemTotals.TotalApplied Is Null,O,OrderItemTotals.TotalApplied) AS [Hd Applied], IIf(OrderItemTotals.TotalWeight Is Null,O,OrderItemTotals.TotalWeight) AS Weight, Iif(OrderItemTotals.TotalApplied>O,OrderItemTot als.TotalWeight/OrderItemTotals.TotalApplied,0) AS [Avg Wt], IIf(OrderItemTotals.TotalAmount Is Null,O,OrderItemTotals.TotalAmount) AS Cost, Quality.Description AS Quality, Orders.Description AS Description FROM Quality RIGHT JOIN (LivestockType INNER
JOIN ((Orders INNER JOIN Associates ON
Orders.AssocID = Associates.AssocID) LEFT JOIN
OrderItemTotals S
ON Orders.OrderID = OrderItemTotals.ID) ON
LivestockType.LivestockType =
Orders.LivestockType) ON Quality.QualityID =
Orders.QualityID
ORDER BY Associates.Name ASC, Orders.RefNbr ASC, Orders.DateOpened ASC;
Please refer to Appendix B for exemplary queries used to populate and repopulate the right panel each time the user alters a selection to obtain the correct and current data from the database.
Referring back to FIGURE 4, application control modules 120 and 121 are part of control and processing modules 18 (FIGURE 1) and are called by explorer control modules 114-116 to process user input. For example, referring also to FIGURE 9, the user may drag a group of cattle from a stocker explorer to a specific owner node in the hierarchical tree structure displayed in a livestock explorer. A portion of agriculture explorer (agriculture explorer) 14 is a TreeControl DragOver event 140 that fires in response to this user input. Depending on the explorer type, in this case, livestock, the specific explorer control module is called or called. In the example shown in FIGURE 9, the DragOver subroutine 142 of a LivestockControl explorer control module is called. Because the current business application is stocker, a StockerControl.DragOver subroutine 144 of the application control module associated with the stocker business application is called by DragOver subroutine 142 of the livestock explorer control module. The DragOver subroutine 144 then determines the explorer environment, determines the mouse location, and determines whether the current mouse location is on an acceptable target location based on predefined business rules associated with the stocker business application. The DragIcon indicating the mouse location is then made reflective of whether the current location is an acceptable or suitable target. Each data explorer may be assigned a unique tag that allows it to be easily identified. A non-acceptable target is marked by the universal NO symbol indicated by a circle with a slash through it, for example. The informative icons provide the user a visual feedback on whether he can "drop" the dragged inventory. Therefore, as the mouse is passed over the various elements of the graphical user interface, the DragOver event rapidly fires repeatedly or periodically to determine the acceptability of the mouse location.
3 5 When he/she drops the inventory on the intended target, the DragDrop event of the tree control fires.
The data in database 12 is modified appropriately to reflect the completion of the transaction. In many instances, a dialog box ( 124, 125; FIGURE 4) is displayed to receive any additional required or optional information associated with the transaction and to allow the user to edit the data. T'he data associated with the transaction are then saved in database 12 in the appropriate tables. The source and target explorer display is refreshed to reflect the updated inventory status.
FIGURE 10 is an example of the drag and drop technique used in the order-buyer business application between a buyer explorer 21 and an order explorer 20. In the order-buyer business application, livestock is typically bought by a professional buying company and immediately sold to customers to fill an existing order. The user may click on a group of cattle displayed in the right-hand panel of buyer explorer 21 and drag it to the hierarchical tree structure displayed in the left-hand panel of order explorer 20. The DragOver event of the tree control of order explorer 20 (routed to the order-buyer business application control module as shown in FIGURE 9) continues to check whether the mouse is over an order in order explorer 20 by using a HitTest method. The HitTest method returns all the attributes or properties associated with the hierarchical tree structure node under the mouse pointer. If the mouse position as given in Cartesian coordinates (X,Y) is over an order (of a particular customer), then the HitTest Level property so indicates.
The HitTest function also returns a DataKey property, which is the OrderID, an unique identifier for the order. The DataKey is used to generate a query of orders table 80 (FIGURE 3):
SELECT*FROM Orders WIRE
OrderID="&SSTree.HitTest(X, Y).DataKey to identify the particular order being filled by the drag and drop action. A
recordset is opened using this query, and the OpenRecordset method of a database object is set to the agriculture explorer database. Only one record is identified by this query, since each order has a unique OrderID.
If the livestock type of the order found matches the livestock type dragged from the buyer explorer, then the source DragIcon property is set to a livestock bitmap giving the user visual confirmation that the livestock can be dropped on this order.
It may be noted that the drag and drop method of the present invention may be used to select any displayed element as the data source, whether it be a node of the hierarchical tree structure or a displayed data summary item, to any other displayed element as the data target. Once dropped, the data of the data source is processed or associated with the data of the data target to complete the business transaction. A
dialog box may open and be displayed to the user to fill in additional data not already available as part of the data source or data target. The user may also modify the data using the dialog box.
Control and processing modules 18 (FIGURE 1) also plays an important role in allowing the user to select the specific business application environment he/she desires to view and work with the data.

Referring to FIGURE 11, a pull-down selection in the menu bar of umbrella agriculture explorer (agriculture explorer) 14 is the business application. An abbreviated exemplary pull-down list for applications shows order-buyer, feed-fed, and stocker applications. When the user selects the stocker application, the Menu Click subroutine 150 in agriculture explorer 14 calls the Stocker.SetMainMenu function 152 of the stocker application control module. The Stocker.SetMainMenu function sets the menu bar drop-down list selections, the icons, and refreshes the screen to reflect the new business application of stocker. The result, as shown by sample window 154, is a window with a menu bar, tool bar, drop-down lists matching the user-selected business application.
The data in the agriculture explorer database can be exported at user discretion to external business systems. An example would be the export of a purchase invoice to a user's accounting system to allow automated payment and tracking of accounts. The data can be exported to the external database in several ways depending on its type. If external business system makes use of a database that can be directly acessed by via ODBC (Open DataBase Connectivity - most modern databases fall in this category), the application control module can then attach to the database and directly input the new data or changes. The agriculture explorer stores the name and path of the database in the Windows registry, and the database is updated via an update SQL query. This technique requires both an understanding of and access to the external database.
The present invention includes a user-friendly and highly interactive system that provides livestock and materials inventory tracking for various agricultural business applications and transactions. The data is displayed in an easy-to-comprehend manner and the user may narrow the scope of the data displayed in a variety of ways. The hierarchical tree structure organizes the data in a way that is selected by the user, such as by location, ownership, inventory type, etc. The user may also specify the date for which the data is current. The hierarchical tree may have multiple branches having one or more sub-levels. The number of sub-levels in the branches also need not be the same. The tabbed pages provide data summaries and details of the tree node selected by the user. The data may be displayed in a number of ways also selectable by the user. In this manner, the user is able to easily navigate through the data and obtain snap shots of the data presented in meaningful ways according to the selected business application environment.
Although several embodiments of the present invention and its advantages have been described in detail, it should be understood that mutations, changes, substitutions, transformations, modifications, variations, and alterations can be made therein without departing from the teachings of the present invention, the spirit and scope of the invention being set forth by the appended claims.

APPENDIX A
Explorer Appearance and behavior of right panel as affected by left panel 1. Buyer Explorer T'he tree has three levels:
All Vendors (or Buyers, or Payees) Specific Vendors (or Buyers, or Payees) Purchases 1.1. Invoice Summary Tab A one line summary of an invoice Top Level - 1 line per invoice, all purchase invoices ' Specific Vendor - I line per invoice, all of that vendor's purchase invoices Purchase - 1 line for that purchase invoice 1.1.1. Vendor - Who we bought from 1.1.2. Ref - A reference number 1. T.3. Inv Date - Date of invoice 1.1.4. Hd Purch - Number of head purchased 1.1.5. Hd Placed - Number of head assigned to customer orders 1.1.6. Hd Avail - Number of head still available to be placed 1.1.7. Total Cost - Total cost of the group of livestock 1.1.8. Cost Unapplied - Cost not yet applied to customer orders 1.1.9. Total Weight - Total weight of the group of livestock 1.1.10. Avg Wt - Weight per head 1.1.11. Cost/Cwt - Cost per 100 lbs.
1.1.12. CostlHd - Cost per head 1.1.13. Description 1.1.14. Buyer - Who authorized the purchase 1.1.15. Payee - Who was paid 1.2. Expense Summary Tab One line per type of Expense or type of livestock Top Level - 1 line per Expense or type of livestock summed across all purchases Specific Vendor - I line per Expense or type of livestock summed across all of that vendor's purchase invoices Purchase - 1 line Expense or type of livestock summed across that purchase invoice 1.2.1. Expense Type - What type of expense or livestock 1.2.2. Hd Purch - Number of head purchased 1.2.3. Hd Placed - Number of head assigned to customer orders 1.2.4. Hd Avail - Number of head still available to be placed 1.2.5. Total Cost - Total cost of the group of livestock 1.2.6. Cost Unapplied - Cost not yet applied to customer orders 1.2.7. Total Weight - Total weight of the group of livestock 1.2.8. Avg Wt - Weight per head 1.2.9. Cost/Hd - Cost per head 1.2.10. Cost/Cwt - Cost per I 00 lbs.
1.3. Invoice Detail Tab A one line per expense or group of livestock on an invoice Top level - 1 line per expense for all purchase invoices ' Specific Vendor - 1 line per expense for all of that vendor's purchase invoices Purchase - 1 line per expense for that purchase invoice 1.3.1. Vendor - Who we bought from I .3.2. Ref - A reference number 1.3.3. Inv Date - Date of invoice 1.3.4. Hd Purch - Number of head purchased 1.3.5. Hd Placed - Number of head assigned to customer orders 1.3.6. Hd Avail - Number of head still available to be placed 1.3.7. Cost - Cost of the expense or group of livestock 1.3.8. Cost Unapplied - Cost not yet applied to customer orders 1.3.9. Total Weight - Total weight of the group of livestock 1.3.10. Avg Wt - Weight per head 1.3.11. CostlHd - Cost per head 1.3.12. Cost/Cwt - Cost per 100 lbs.
1.3.13. Description 1.3.14. Buyer - Who authorized the purchase 1.3.15. Payee - Who was paid 1.3.16. Quality - User subjective description of the quality of the group of livestock 1.3.17. Details - Notes about the expense or group of livestock 2. Livestock Explorer The tree is free form, terminal locations can contain inventory each higher level of the tree contains the locations under it.
2.1. Livestock Detail Tab Detail on current status of livestock. All Livestock in selected group, location, or by owner etc 2.1.1. Owner 2.1.2. Location 2.1.3. Date - Date of record 2.1.4. Livestock - Sex/Type of Livestock . 2.1.5. In Weight - Initial weight of cattle 2.1.6. Head 2.1.7. Weight - Actual weight 2.1.8. Avg Wt - Actual weight per head 2.1.9. Est Wt/Hd - estimated weight 2.1.10. Lbs Fed 2.1.11. Ration - (Feed Recipe) 2.1.12. Pasture 2.1.13. ADG - Average daily gain 2.1.14. DOF - Days on feed 3 5 2.1.15. DORT - Days on Ration (Feed Recipe) 2.1.16. Treatment - medical treatment or breeding 2.1.1. Notes 2.2 Livestock Summary Tab One line summary by type of livestock. Summed by group, location, owner etc.
2.2.1. Livestock - Sex/Type of Livestock 2.2.2. Head 2.2.3. Weight - Actual total weight 2.2.4. Avg Wt - Average of Actual weight per head 2.2.5. Avg Est Wt - Average of Estimated weight per head 2.2.6. Avg ADG - Average of Average daily gains 2.2.7. Avg DOF - Average of Days on feed 2.2.8. Avg DORT - Average Days on Ration (Feed Recipe) 2.2.1. Notes 2.3. Livestock History Tab All Details by date to display historical trends or events. Selected group, or all groups in selected branch displayed 2.3.1. Owner 2.3.2. Location 2.3.3. Date - Date of record 2.3.4. Date In - Date cattle received 2.3.5. Livestock - Sex/Type of Livestock 2.3.6. In Weight - Initial weight of cattle 2.3.7: Head 2.3.8. Weight - Actual weight 2.3.9. Avg Wt - Actual weight per head 2.3.10. Est Wt/Hd - estimated weight 2.3.11. Lbs Fed 2.3.12. Ration - (Feed Recipe) 2.3.13. Pasture 2.3.14. ADG - Average daily gain 2.3.15. DOF - Days on Feed 2.3.16. DORT - Days on Ration (Feed Recipe) 2.3.17. Treatment 2.3.1. Notes 3. Order Explorer The tree has three levels ~ All Customers ~ Specific Customers ~ Orders 3.1. Order Summary Tab A one line summary of an order ~ Top level - 1 line per order, all orders ~ Specific Customer - 1 line per order, all of that customer's orders ~ Order - 1 line for that order 3.1.1. Customer - Who ordered the livestock 3.1.2. Reference - Customer purchase order 3.1.3. Open - if the order is open or filled 3.1.4. Order Date - When the order was made 3.1.5. Inv Date - When the order was billed 3.1.6. Date Modified - Most recent date the order was modified 3 5 3.1.7. Livestock - Sex/Type of Livestock 3.1.8. Hd Ordered - Number of head ordered 3.1.9. Min Wt - Minimum desired weight 3.1.10. Max Wt - Maximum desired weight 3.1.11. Max Price - maximum acceptable purchase price 3.1.12. Hd Applied - Number of head applied to fill the order 3.1.13. Weight - Total Weight of head applied 3.1.14. Avg Weight - Weight per head applied to order 3.1.15. Cost - Total cost applied to order 3.1.16. Quality - Quality of livestock desired 3.1.17. Loads Ordered - how many truck loads the customer wants 3.1.18. Description 3.2. Cattle Detail Tab A one line for each group of cattle applied to each order ~ Top level - 1 line per group of cattle for every orders ~ Specific Customer - 1 line per group of cattle for all of that customer's orders ~ Order - 1 line per group of cattle for that order 3.2.1. Customer - Who ordered the livestock 3.2.2. Reference - Customer purchase order 3.2.3. Open - if the order is open or filled 3.2.4. Order Date - When the order was made 3.2.5. Inv Date - When the order was billed ~

3.2.6. Invoice - The invoice number for the purchase of the cattle applied here 3.2.7. Livestock - Sex/Type of livestock 3.2.8. Hd Ordered - Number of head ordered 3.2.9. Date Applied - When this group of cattle was applied to the order 103.2.10. Head Applied - number of head applied 3.2.11. Weight - Total Weight of head applied 3.2.12. Avg Weight - Weight per head applied to order 3.2.13. Cost - Total cost applied to order 3.2.14. Quality - Quality of livestock desired 153.2.15. Description 3.3. Cost mmary Tab Su A one line for each type of expense or livestock Top level - 1 line per type of Expense or livestock summed across all orders Specific Customer - 1 line per type of Expense or livestock, summed across all of that 20 customer's orders Order - 1 line per type of Expense or livestock Summed across that order 3.3.1. Expense - Type of Expense or livestock 3.3.2. Head - Number of head 3.3.3. Weight - Total Weight of head applied 253.3.4. Avg Weight - Weight per head applied to order 3.3.5. Cost - Total cost applied to order 3.3.6. Cost/Hd - cost per head 3.3.7. CosdCwt - cost per 100 lbs.

3.4. Cost Detail Tab 30A one line per Expense or group of livestock on an order Top level - 1 line per Expense or group of livestock on an order, for all orders Specific Customer - 1 line per Expense or group of livestock on an order, for all of that customer's orders Orders - 1 line per Expense or group of livestock on an order 353.4.1. Customer - Who ordered the livestock 3.4.2. Reference - Customer purchase order 3.4.3. Open - if the order is open or filled 3.4.4. Expense - Type of Expense or livestock 3.4.5. Head - Number of head 403.4.6. Weight - Total Weight of head applied 3.4.7. Avg Weight - Weight per head applied to order 3.4.8. Cost - Total cost applied to order 3.4.9. Cost/Hd - cost per head 3.4.10. Cost/Cwt - cost per 100 lbs.

453.4.11. Quality - Quality of livestock desired 3.4.12. Description 3.4.13. Invoice - The invoice number for the purchase of the cattle applied here 4. Supply Inventory Explorer The tree is free form, terminal locations can contain inventory each higher level of the tree contains the locations 50under it.

4.1. Activity Detail Tab Complete history. All details for each transaction. Shows all transaction for selected location, or all transaction for all locations in the selected branch 4.1.1. Doc Ref - Reference 4.1.2. Date 4.1.3. Status - processed or unprocessed . 4.1.4. Activity - What type of transaction took place 4.1.5. Source - Where the Supply came from 4.1.6. Destination - Where the Supply went 4.1.7. Arrival Date 4.1.8. Supply Item 4.1.9. Unit Type 4.1.10. Unit Price 4.1.11. Quantity 4.1.12. Total Price 4.2. Current Detail Tab Detail on all Supply Items currently still in inventory by location. Shows all at selected location, or all at each location in selected branch 4.2.1. Location 4.2.2. Supply Item 4.2.3. In Date 4.2.4. Arrival Date 4.2.5. Unit Type 4.2.6. Quantity 4.2.7. Lbs/LJnit 4.2.8. Total Lbs 4.3. Location Summary Tab Summary of all Supply Items at each Location. Shows selected location, or all locations in selected branch 4.3.1. Location 4.3.2. Supply Item 4.3.3. Quantity 4.3.4. Unit Type 4.3.5. Lbs/Unit 4.3.6. Total Lbs 4.4. Supply Item Summary Tab Summary of Supply Items. Summed for selected location, or summed across all locations in selected branch 4.4.1. Supply Item 4.4.2. Unit Type 4.4.3. Quantity 4.4.4. Lbs/Unit 4.4.5. Total Lbs 4.5. Inventory Type Summary Tab Sum Supply Items by Inventory Type (i.e. hay is a type of Roughage). Summed for selected location, or summed across all locations in selected branch 4.5.1. Inventory type 4.5.1. Totallbs 5. Supply Usage/Harvest Explorer The tree is free form, terminal locations can contain inventory each higher level of the tree contains the locations under it.
5.1. Activity Detail Tab Complete history. All details for each transaction. Shows all transaction for selected location, or all transaction for all locations in the selected branch 5.1. I . Doc Ref - Reference 5.1.2. Date 5.1.3. Status - processed or unprocessed 5.1.4. Source - Where the Supply came from 5.1.5. Destination - Where the Supply went 5.1.6. Arrival Date 5.1.7. Supply Item 5.1.8. Unit Type 5.1.9. Unit Price 5.1.10. Quantity 5.1.11. Total Price 5.2. Location Summary Tab Summary of all Supply Items at each Location. Shows selected location, or all locations in selected branch 5.2.1. Location 5.2.2. Supply Item 5.2.3. Quantity 5.2.4. Unit Type 5.2.5. Lbs/LJnit 5.2.6. Total Lbs 5.3. Supply Item Summary Tab Summary of Supply Items. Summed for selected location, or summed across all locations in selected branch 5.3.1. Supply Item 5.3.2. Quantity 5.3.3. Lbs/Unit 5.3.4. Total Lbs 5.4. Inventory Type Summary Tab Sum Supply Items by Inventory (i.e. hay is a type of Roughage). Summed for selected location, or summed across all locations in selected branch 5.4.1. Inventory type 1. Totallbs APPENDIX B
The exemplary Cattle Detail query for all orders may be:
SELECT Associates.Name AS Customer, Orders.RefNbr AS Reference, Orders.OrderID, Orders.Status AS Open, Orders.DateOpened AS

[Order Date], Orders.DateInvoiced AS
[Inv Date], PurchaseInvoices.RefNbr AS Invoice, LivestockType.Description AS Livestock, Orders.Qty AS [Hd Ordered], OrderItem.OrderLiID, OrderItem.InvLiID, OrderItem.ActDate AS [Date Applied], IIf(OrderItem.Qty Is Null, 0, OrderItem.Qty) AS

[Hd Applied], IIf (OrderItem.Weight Is Null, 0, OrderItem.Weight) AS Weight, IIf(OrderItem.Qty > 0, OrderItem.WeighdOrderItem.Qty, 0) AS [Avg Wt], IIf(OrderItem.Amount Is Null, 0, OrderItem.Amount) AS Cost, Quality.Description AS Quality, Orders.Description AS Description, True AS LPurchase FROM PurchaseInvoices RIGHT

JOIN (PurchaseDetail RIGHT JOIN (Quality RIGHT

JOIN (LivestockType INNER JOIN ((Orders INNER

JOIN Associates ON Orders.AssocID =

Associates.AssocID) LEFT JOIN (OrderItem LEFT

JOIN ExpenseTypes ON OrderItem.ExpenseID
=

ExpenseTypes.ExpenseID) ON Orders.OrderID
=

OrderItem.OrderID) ON LivestockType.LivestockType =

Orders.LivestockType) ON Quality.QualityID
=

OrderItem.QualityID) ON PurchaseDetail.InvLiID

= OrderItem.InvLiID) ON PurchaseInvoices.InvID

= PurchaseDetail.InvID WHERE

(ExpenseTypes.Purchase = True AND

ExpenseTypes.Livestock = True) ORDER
BY

Associates.Name ASC, Orders.DateOpened ASC, OrderItem.ActDate ASC;

The Cost Summary query makes use of a predefined query called OrderSummary:
SELECT DISTINCT OrderItem.OrderLiID, OrderItem.ExpenseID, OrderItem.Amount, Orders.LivestockType, IIf(ExpenseTypes.Livestock = True And ExpenseTypes.Purchase = True, True, False) AS
LPurchase, IIf(ExpenseTypes.Purchase = True And ExpenseTypes.Livestock = True, OrderItem.Qty, OrderItemTotals.TotalApplied) AS Head, IIf(ExpenseTypes.Purchase = True And ExpenseTypes.Livestock = True, OrderItem.Weight, OrderItemTotaIs.TotalWeight) AS Weight, Orders.OrderID, Orders.AssocID, Orders.Status FROM ExpenseTypes INNER JOIN (Orders INNER JOIN
(OrderItemTotals INNER JOIN OrderItem ON
OrderItemTotals.ID = OrderItem.OrderID) ON
Orders.OrderID = OrderItem.OrderID) ON
ExpenseTypes.ExpenseID = OrderItem.ExpenseID
GROUP BY OrderItem.OrderLiID, OrderItem.ExpenseID, OrderItem.Amount, Orders.LivestockType, IIf(ExpenseTypes.Livestock = True And ExpenseTypes.Purchase = True, True, False), IIf(ExpenseTypes.Purchase = True And ExpenseTypes.Livestock = True, OrderItem.Qty, OrderItemTotals.TotalApplied), IIf(ExpenseTypes.Purchase = True And ExpenseTypes.Livestock = True, OrderItem.Weight, OrderItemTotals.TotalWeight), Orders.OrderID, Orders.AssocID, Orders.Status;
The exemplary Cost Summary query may be:
SELECT IIf(ExpenseTypes.Livestock = True And ExpenseTypes.Purchase =
True,LivestockType.Description,ExpenseTypes.Descript ion) AS Expense, Sum(OrderSummary.Head) AS Head, IIf(Sum(OrderSummary.Head) = 0, 0, Sum(OrderSummary.Amount)/ Sum(OrderSummary.Head)) AS
[Cost/Hd], Sum(OrderSummary.Weight) AS Weight, IIf(Sum(OrderSummary.LPurchase) = 0, 0, Sum(OrderSummary.Weight)/Sum(OrderSummary.Head)) AS
[Avg Wt], IIf(Sum(OrderSummary.Weight) = 0, 0, Sum(OrderSummary.Amount)/
Sum(OrderSummary.Weight)*100) AS [CosbCwt], (OrderSummary.Amount) AS Cost, OrderSummary.ExpenseID, OrderSummary.LPurchase FROM
(OrderSummary INNER JOIN ExpenseTypes ON
OrderSummary.ExpenseID = ExpenseTypes.ExpenseID) INNER JOIN LivestockType ON
OrderSummary.LivestockType =
LivestockType.LivestockType GROUP BY
IIf(ExpenseTypes.Livestock=True And ExpenseTypes.Purchase = True, LivestockType.Description, ExpenseTypes.Description), ExpenseTypes.ExpenseID, OrderSummary.LPurchase ORDER BY
OrderSummary.ExpenseID;

The exemplary Cost Detail query used a predefined query called OrderItemTotals:
SELECT OrderItem.OrderID AS ID, Sum(IIf(ExpenseTypes.Purchase = True AND
ExpenseTypes.Livestock = True, OrderItem.Qty, 0)) AS TotalApplied, Sum(IIf(ExpenseTypes.Purchase = True AND
ExpenseTypes.Livestock = True, OrderItem.Weight, 0)) AS TotaIWeight, Sum(OrderItem.Amount) AS TotalAmount, Max(OrderItem.ActDate) AS LatestDate FROM ExpenseTypes INNER JOIN OrderItem ON
ExpenseTypes.ExpenseID = OrderItem.ExpenseID
GROUP BY OrderItem.OrderID;
The exemplary Cost Detail query may be:
SELECT Associates.Name AS Customer, Orders.RefNbr AS Reference, Orders.Status AS

Open, IIf((ExpenseTypes.Purchase = True AND

ExpenseTypes.Livestock=True), LivestockType.Description,ExpenseTypes.Descript ion) AS Expense, OrderItem.OrderLiID, OrderItem.InvLiID, (IIf(OrderItem.Qty > 0, OrderItem.Qty, OrderItemTotals.TotalApplied)) AS Head, IIf(OrderItemTotals.TotalApplied > 0, (OrderItem.Amound(IIf(OrderItem.Qty > 0, OrderItem.Qty, OrderItemTotals.TotalApplied))), 0) AS [Cost/Hd], (IIf(OrderItem.Weight > 0, OrderItem.Weight, OrderItemTotals.TotalWeight)) AS Weight, IIf((ExpenseTypes.Purchase = True AND ExpenseTypes.Livestock = True), IIf(OrderItem.Qty > 0, OrderItem.WeighdOrderItem.Qty, 0), 0) AS Avg Wt, IIf(OrderItemTotals.TotaIWeight > 0, (100*OrderItem.Amound(IIf(OrderItem.Weight >

0, OrderItem.Weight, OrderItemTotals.TotalWeight))), 0) AS

[Cost/Cwt], OrderItem.Amount AS Cost, Orders.Qty AS HdOrd, Orders.OrderID
AS OrderID, OrderItem.ExpenseID, Quality.Description AS

Quality, Orders.Description AS Description, IIf(ExpenseTypes.Purchase = True AND

ExpenseTypes.Livestock = True,True,False) AS

LPurchase, PurchaseInvoices.RefNbr AS Invoice FROM PurchaseInvoices RIGHT JOIN

(PurchaseDetail RIGHT JOIN (Quality RIGHT JOIN

(Associates INNER JOIN ((Orders INNER
JOIN

LivestockType Orders.LivestockType =

LivestockType.LivestockType) INNER
JOIN

((OrderItem LEFT JOIN ExpenseTypes ON

OrderItem.ExpenseID = ExpenseTypes.ExpenseID) LEFT JOIN OrderItemTotals OrderItem.OrderID =
OrderItemTotals.ID) ON Orders.OrderID =
OrderItem.OrderID) ON Associates.AssocID =
Orders.AssocID) ON Quality.QualityID =
OrderItem.QualityID) ON PurchaseDetail.InvLiID
= OrderItem.InvLiID) ON PurchaseInvoices.InvID
= PurchaseDetail.InvID ORDER BY Associates.Name ASC, Orders.DateOpened ASC, Orders.OrderID ASC, ExpenseTypes.Description ASC;

Claims (86)

WHAT IS CLAIMED IS:
1. An interactive graphical user interface window of a livestock and materials inventory system, comprising:
a first window operable to display a hierarchical tree structure representation of inventory data; and a second window operable to display a data summary associated with a selected node in the hierarchical tree structure.
2. The window, as set forth in claim 1, wherein each node in the hierarchical tree structure is associated with the displayed inventory data in the second window, so that a user may manipulate the inventory data by manipulating the tree nodes or displayed data summary.
3. The window, as set forth in claim 1, wherein each node in the hierarchical tree structure is associated with the displayed inventory data in the second window, so that a user may drag a source node and its associated data and drop on a target node and its associated data, the data of the source node being associated with the data of the target node to complete a business transaction.
4. The window, as set forth in claim 1, wherein each node in the hierarchical tree structure is associated with the displayed inventory data in the second window and the displayed data summary items are each associated with the inventory data, so that a user may drag a source node and its associated data and drop on a target data summary item and its associated data, the data of the source node being associated with the data of the target data summary item to complete a business transaction.
5. The window, as set forth in claim 1, wherein each node in the hierarchical tree structure is associated with the displayed inventory data in the second window and the displayed data summary items are each associated with the inventory data, so that a user may drag a source data summary item and its associated data and drop on a target node and its associated data, the data of the source data summary item being associated with the data of the target node to complete a business transaction.
6. The window, as set forth in claim 1, further comprising a pull-down selection of display criteria for the hierarchical tree structure and the data summary.
7. The window, as set forth in claim 1, further comprising a clickable icon display criteria for the hierarchical tree structure.
8. The window, as set forth in claim 1, wherein the hierarchical tree structure comprises:
a top node;
one or more branch nodes;
zero or more levels of sub-branch nodes linked to each branch node; and zero or more leaf nodes linked to each sub-branch node.
9. The window, as set forth in claim 8, wherein each node is operable to be expanded to show levels below the node or collapsed to hide the levels below the node.
10. The window, as set forth in claim 1, wherein the second window is operable to display more than one data summary pages associated with a selected node in the hierarchical tree structure representation.
11. The window, as set forth in claim 1, wherein the second window is operable to display more than one data summary pages associated with a selected node in the hierarchical tree structure representation, each data summary page comprising a labeled tab indicative of the type of data summary displayed therein.
12. The window, as set forth in claim 1, wherein the data summary displayed in the second window comprises a graphical representation of data.
13. The window, as set forth in claim 1, wherein the data summary displayed in the second window comprises a chart or graph.
14. The window, as set forth in claim 1, wherein the data summary displayed in the second window comprises a pictorial image.
15. The window, as set forth in claim 1, wherein the data summary displayed in the second window comprises a map.
16. The window, as set forth in claim 1, wherein the data summary displayed in the second window comprises a video and/or audio stream.
17. The window, as set forth in claim 1, wherein the data summary displayed in the second window comprises data presented in a tabular or grid format.
18. The window, as set forth in claim 1, wherein the first window is operable to display livestock inventory data by geographical location in the hierarchical tree structure representation.
19. The window, as set forth in claim 1, wherein the first window is operable to display livestock inventory data by geographical location in the hierarchical tree structure representation, the hierarchical tree structure having a top node indicative of country, a first sub-level indicative of states, a second sub-level indicative of regions in a state, and a third sub-level indicative of ranches and pastures holding the livestock.
20. The window, as set forth in claim 1, wherein the first window is operable to display livestock inventory data by ownership in the hierarchical tree structure.
21. The window, as set forth in claim 1, wherein the first window is operable to display inventory data by type of inventory in the hierarchical tree structure, and the second window is operable to display data summary pages associated with one or more selected inventory in the hierarchical tree structure.
22. The window, as set forth in claim 1, wherein the first window is operable to display customer data in the hierarchical tree structure, and the second window is operable to display data summary pages associated with one or more selected customer in the hierarchical tree structure.
23. The window, as set forth in claim 18, wherein the displayed customer data comprises customer orders.
24. The window, as set forth in claim 1, wherein the first window is operable to display vendor data in the hierarchical tree structure, and the second window is operable to display data summary pages associated with one or more selected vendor in the hierarchical tree structure.
25. The window, as set forth in claim 1, wherein the first window is operable to display buyer data in the hierarchical tree structure, and the second window is operable to display data summary pages associated with one or more selected buyer in the hierarchical tree structure.
26. The window, as set forth in claim 1, wherein the first window is operable to display buyer, vendor or livestock type in the hierarchical tree structure, and the second window is operable to display data summary pages associated with one or more selected buyer, vendor or livestock type in the hierarchical tree structure.
27. The window, as set forth in claim 1, further comprising a menu bar having a pull-down list of business application environments.
28. The window, as set forth in claim 1, further comprising a tool bar having a plurality of icons each representing a data explorer having access to particular predetermined portions of an inventory database.
29. The window, as set forth in claim 1, further comprising a plurality of dialog windows each operable to be displayed to receive data specific to a business application transaction.
30. The window, as set forth in claim 27, wherein the first and second windows are associated with a first data explorer, the window further comprising:
a third window operable to display a hierarchical tree structure representation of inventory data associated with a second data explorer; and a fourth window operable to display a data summary associated with a selected node in the hierarchical tree structure.
31. The window, as set forth in claim 27, wherein the first and second windows are associated with a first data explorer, the window further comprising multiple additional data explorers, each data explorer also having a first window operable to display a hierarchical tree structure displaying data associated with the respective data explorer, and a second window operable to display a data summary associated with a selected node in the hierarchical tree structure.
32. The window, as set forth in claim 1, further comprising a registry recording various visual attributes associated with the first and second windows.
33. A livestock and material inventory system, comprising:
a database storing inventory data;
at least one data explorer operable to access predetermined portions of data in the database; and a graphical user interface operable to display data accessed by the at least one data explorer to a user, the graphical user interface comprises:
a first window operable to display and allow a user to manipulate a hierarchical tree structure representation of the inventory data; and a second window operable to display a data summary associated with a selected node in the hierarchical tree structure.
34. The system, as set forth in claim 33, wherein each node in the hierarchical tree structure is associated with the displayed inventory data in the second window, so that a user may manipulate the inventory data by manipulating the tree nodes or displayed data summary.
35. The system, as set forth in claim 33, wherein each node in the hierarchical tree structure is associated with the displayed inventory data in the second window, so that a user may drag a source node and its associated data and drop on a target node and its associated data, the data of the source node being associated with the data of the target node to complete a business transaction.
36. The system, as set forth in claim 33, wherein each node in the hierarchical tree structure is associated with the displayed inventory data in the second window and the displayed data summary items are each associated with the inventory data, so that a user may drag a source node and its associated data and drop on a target data summary item and its associated data, the data of the source node being associated with the data of the target data summary item to complete a business transaction.
37. The system, as set forth in claim 33, wherein each node in the hierarchical tree structure is associated with the displayed inventory data in the second window and the displayed data summary items are each associated with the inventory data, so that a user may drag a source data summary item and its associated data and drop on a target node and its associated data, the data of the source data summary item being associated with the data of the target node to complete a business transaction.
38. The system, as set forth in claim 33, wherein the graphical user interface further comprises a pull-down selection of display criteria for the hierarchical tree structure.
39. The system, as set forth in claim 33, wherein the graphical user interface further comprises a clickable icon display criteria for the hierarchical tree structure.
40. The system, as set forth in claim 33, wherein the hierarchical tree structure comprises:
a top node;
one or more branch nodes;
zero or more levels of sub-branch nodes linked to each branch node; and zero or more leaf nodes linked to each sub-branch node.
41. The system, as set forth in claim 33, wherein the second window is operable to display more than one data summary pages associated with a selected node in the hierarchical tree structure representation.
42. The system, as set forth in claim 33, wherein the second window is operable to display more than one data summary pages associated with a selected node in the hierarchical tree structure representation, each data summary page comprising a labeled tab indicative of the type of data summary displayed therein.
43. The system, as set forth in claim 33, wherein the first window is operable to display livestock inventory data by geographical location in the hierarchical tree structure representation.
44. The system, as set forth in claim 33, wherein the first window is operable to display livestock inventory data by geographical location in the hierarchical tree structure representation, the hierarchical tree structure having a top node indicative of country, a first sub-level indicative of states, a second sub-level indicative of regions in a state, and a third sub-level indicative of ranches and pastures holding the livestock.
45. The system, as set forth in claim 33, wherein the first window is operable to display livestock inventory data by ownership in the hierarchical tree structure.
46. The system, as set forth in claim 33, wherein the first window is operable to display inventory data by type of inventory in the hierarchical tree structure, and the second window is operable to display data summary pages associated with one or more selected inventory in the hierarchical tree structure.
47. The system, as set forth in claim 33, wherein the first window is operable to display customer data in the hierarchical tree structure, and the second window is operable to display data summary pages associated with one or more selected customer in the hierarchical tree structure.
48. The system, as set forth in claim 47, wherein the displayed customer data comprises customer orders.
49. The system, as set forth in claim 33, wherein the first window is operable to display vendor data in the hierarchical tree structure, and the second window is operable to display data summary pages associated with one or more selected vendor in the hierarchical tree structure.
50. The system, as set forth in claim 33, wherein the first window is operable to display buyer data in the hierarchical tree structure, and the second window is operable to display data summary pages associated with one or more selected buyer in the hierarchical tree structure.
51. The system, as set forth in claim 33, wherein the first window is operable to display buyer, vendor or livestock type in the hierarchical tree structure, and the second window is operable to display data summary pages associated with one or more selected buyer, vendor or livestock type in the hierarchical tree structure.
52. The system, as set forth in claim 33, wherein the graphical user interface further comprises a menu bar having a pull-down list of business application environments.
53. The system, as set forth in claim 33, wherein the graphical user interface further comprises a tool bar having a plurality of icons each representing a data explorer having access to particular predetermined portions of an inventory database.
54. The system, as set forth in claim 33, wherein the graphical user interface further comprises a plurality of dialog windows each operable to be displayed to receive data specific to a business application transaction.
55. The system, as set forth in claim 33, wherein the first and second windows are associated with a first data explorer, the window further comprising multiple additional data explorers, each data explorer also having a first window operable to display a hierarchical tree structure displaying data associated with the respective data explorer, and a second window operable to display a data summary associated with a selected node in the hierarchical tree structure.
56. The system, as set forth in claim 33, further comprising a generic data explorer object, the generic data explorer object comprising a generic set of graphical user interface properties and a set of explorer control modules operable to generate instances of data explorers having specific functionality.
57. The system, as set forth in claim 33, further comprising a livestock data explorer operable to access livestock inventory data stored in the database, display the livestock inventory data by at least one selection criteria in the hierarchical tree structure in the first window, and display livestock inventory data summaries associated with a selected node in the hierarchical tree structure.
58. The system, as set forth in claim 33, comprising an order data explorer operable to access order data associated with customers stored in the database, display the customers by at least one selection criteria in the hierarchical tree structure in the first window, and display customer order data summaries associated with a selected node in the hierarchical tree structure.
59. The system, as set forth in claim 33, comprising a buyer data explorer operable to access data associated with invoices stored in the database, display the data by at least one selection criteria in the hierarchical tree structure in the first window, and display invoice data summaries associated with a selected node in the hierarchical tree structure.
60. The system, as set forth in claim 33, comprising a supply inventory data explorer operable to access supply inventory data stored in the database, display the supply inventory data by at least one selection criteria in the hierarchical tree structure in the first window, and display supply inventory data summaries associated with a selected node in the hierarchical tree structure.
61. The system, as set forth in claim 33, comprising a supply usage/harvest data explorer operable to access supply usage and harvest data stored in the database, display the data by at least one selection criteria in the hierarchical tree structure in the first window, and display supply inventory data summaries associated with a selected node in the hierarchical tree structure.
62. The system, as set forth in claim 33, further comprising a set of application control modules each having a set of business rules applicable to the inventory data, so that the data may be associated with and interpreted with respect to a particular business application environment.
63. The system, as set forth in claim 33, further comprising a data exporter operable to access the database and export selected data in a predetermined format.
64. A method of tracking livestock and materials inventory, comprising:
selecting a business application environment;
selecting a data explorer having access of specific predetermined sets of data in a database;
organizing and displaying the accessed data in a hierarchical tree structure in a first window following a selected organizational criteria and in response to the selected business application environment;
selecting a node of the hierarchical tree structure; and displaying data summaries associated with the selected node in a second window.
65. The method, as set forth in claim 64, wherein selecting a data explorer comprises instantiating a data explorer having a particular functionality from a generic data explorer object.
66. The method, as set forth in claim 65, wherein instantiating data explorer comprises executing graphical user interface methods of the generic data explorer object.
67. The method, as set forth in claim 64, further comprising associating each node in the hierarchical tree structure with the displayed inventory data in the second window, so that a user may manipulate the inventory data by manipulating the tree nodes or displayed data summary.
68. The method, as set forth in claim 64, further comprising associating each node in the hierarchical tree structure with the displayed inventory data in the second window, so that a user may drag a source node and its associated data and drop on a target node and its associated data, the data of the source node being associated with the data of the target node to complete a business transaction.
69. The method, as set forth in claim 64, further comprising associating each node in the hierarchical tree structure with the displayed inventory data in the second window and the displayed data summary items are each associated with the inventory data, so that a user may drag a source node and its associated data and drop on a target data summary item and its associated data, the data of the source node being associated with the data of the target data summary item to complete a business transaction.
70. The method, as set forth in claim 64, further comprising associating each node in the hierarchical tree structure with the displayed inventory data in the second window and the displayed data summary items are each associated with the inventory data, so that a user may drag a source data summary item and its associated data and drop on a target node and its associated data, the data of the source data summary item being associated with the data of the target node to complete a business transaction.
71. The method, as set forth in claim 64, comprising:
selecting a livestock data explorer operable to access livestock inventory data stored in the database;
displaying the livestock inventory data by at least one selection criteria in the hierarchical tree structure in the first window; and displaying livestock inventory data summaries associated with a selected node in the hierarchical tree structure.
72. The method, as set forth in claim 64, comprising:
selecting an order data explorer operable to access order data associated with customers stored in the database;
displaying the customers by at least one selection criteria in the hierarchical tree structure in the first window; and displaying customer order data summaries associated with a selected node in the hierarchical tree structure.
73. The method, as set forth in claim 64, comprising:
selecting a buyer data explorer operable to access data associated with invoices stored in the database;
displaying the data by at least one selection criteria in the hierarchical tree structure in the first window; and displaying invoice data summaries associated with a selected node in the hierarchical tree structure.
74. The method, as set forth in claim 64, comprising:
selecting a supply inventory data explorer operable to access supply inventory data stored in the database;
displaying the supply inventory data by at least one selection criteria in the hierarchical tree structure in the first window; and displaying supply inventory data summaries associated with a selected node in the hierarchical tree structure.
75. The method, as set forth in claim 64, comprising:
selecting a supply usage/harvest data explorer operable to access supply usage and harvest data stored in the database;
displaying the data by at least one selection criteria in the hierarchical tree structure in the first window; and displaying supply inventory data summaries associated with a selected node in the hierarchical tree structure.
76. The method, as set forth in claim 64, further comprising:
selecting a second data explorer having access of specific predetermined data of a database;
organizing and displaying the accessed data in a second hierarchical tree structure in a third window following a selected organizational criteria;
selecting a node of the second hierarchical tree structure in the third window; and displaying data summaries associated with the selected node of the second hierarchical tree structure in a fourth window.
77. The method, as set forth in claim 64, further comprising:
selecting a first displayed item in the first or second window as a data source;
dragging the selected data source;
dropping the selected data source onto a second displayed item in the first or second window as a data target; and associating data related to the selected data source with the data target to complete a business transaction.
78. The method, as set forth in claim 55, further comprising:
selecting a second data explorer having a first and second windows also displaying a hierarchical tree structure and data summaries, respectively;
selecting a first displayed item in the first or second window of the first data explorer as a data source;
dragging the selected data source;
dropping the selected data source onto a second displayed item in the first or second window of the second data explorer as a data target; and associating data related to the selected data source with the data target to complete a business transaction.
79. The method, as set forth in claim 74, further comprising:
checking the suitability of displayed elements passed over by the dragged data source as a possible data target; and displaying a drag icon indicative of the suitability of the displayed elements.
80. The method, as set forth in claim 64, further comprising:
displaying a dialog box having a plurality of data fields;
filling in selected data fields with appropriate data from the data source and the data target;
receiving additional data associated with the completed transaction; and receiving modified data in filled data fields associated with the completed transaction.
81. The method, as set forth in claim 64, further comprising exporting data associated with the selected node in a predetermined format.
82. The method, as set forth in claim 64, wherein displaying data summaries comprises displaying a graphical representaion of the data.
83. The method, as set forth in claim 64, wherein displaying data summaries comprises displaying a chart or graph.
84. The method, as set forth in claim 64, wherein displaying data summaries comprises displaying a map.
85. The method, as set forth in claim 64, wherein displaying data summaries comprises displaying a pictorial image.
86. The method, as set forth in claim 64, wherein displaying data summaries comprises displaying a video and/or audio stream.
CA002381782A 1999-08-12 2000-08-14 Livestock inventory and materials system with interactive graphical user interface Abandoned CA2381782A1 (en)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US09/373,927 US6642946B1 (en) 1998-08-13 1999-08-12 Livestock inventory and materials system with interactive graphical user interface
US09/373,927 1999-08-12
PCT/US2000/022311 WO2001013302A2 (en) 1999-08-12 2000-08-14 Livestock inventory and materials system with interactive graphical user interface

Publications (1)

Publication Number Publication Date
CA2381782A1 true CA2381782A1 (en) 2001-02-22

Family

ID=23474479

Family Applications (1)

Application Number Title Priority Date Filing Date
CA002381782A Abandoned CA2381782A1 (en) 1999-08-12 2000-08-14 Livestock inventory and materials system with interactive graphical user interface

Country Status (4)

Country Link
US (1) US6642946B1 (en)
AU (1) AU777146B2 (en)
CA (1) CA2381782A1 (en)
WO (1) WO2001013302A2 (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20140052600A1 (en) * 2003-09-11 2014-02-20 Bgc Partners, Inc Graphical user interface related to non-standard trading of financial instruments

Families Citing this family (63)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6751604B2 (en) * 1999-01-06 2004-06-15 Hewlett-Packard Development Company, L.P. Method of displaying temporal and storage media relationships of file names protected on removable storage media
US7366708B2 (en) * 1999-02-18 2008-04-29 Oracle Corporation Mechanism to efficiently index structured data that provides hierarchical access in a relational database system
US6931625B1 (en) * 1999-10-05 2005-08-16 Borland Software Corporation Method and system for collapsing a graphical representation of related elements
WO2001054492A1 (en) * 2000-01-28 2001-08-02 Courtney Oldham Automated method and system for conducting a cattle auction
US7743074B1 (en) * 2000-04-05 2010-06-22 Microsoft Corporation Context aware systems and methods utilizing hierarchical tree structures
US7028268B1 (en) * 2000-06-15 2006-04-11 Conley Jr Ralph F Multiple destination banners
US8396859B2 (en) * 2000-06-26 2013-03-12 Oracle International Corporation Subject matter context search engine
US20020054155A1 (en) * 2000-07-14 2002-05-09 Borland Software Corporation Data module design system
US7493565B2 (en) * 2000-12-22 2009-02-17 Microsoft Corporation Environment-interactive context-aware devices and methods
US6963874B2 (en) 2002-01-09 2005-11-08 Digital River, Inc. Web-site performance analysis system and method utilizing web-site traversal counters and histograms
US7783506B2 (en) * 2001-08-17 2010-08-24 Expedia, Inc. System and method for managing reservation requests for one or more inventory items
US7707075B2 (en) * 2001-08-17 2010-04-27 Expedia, Inc. System and method for managing inventory
US7308651B2 (en) * 2001-09-05 2007-12-11 Sca Hygiene Products Ab Data entry graphical user interface
US7363593B1 (en) * 2001-11-30 2008-04-22 Versata Development Group, Inc. System and method for presenting information organized by hierarchical levels
US20030105771A1 (en) * 2001-12-01 2003-06-05 Tiefenbrun Natan E. Attribute driven dynamic tree structure
US20030117446A1 (en) * 2001-12-21 2003-06-26 Expeditors International Of Washington Inc. System and method for processing transaction information
US20030128231A1 (en) * 2002-01-09 2003-07-10 Stephane Kasriel Dynamic path analysis
US7631035B2 (en) 2002-01-09 2009-12-08 Digital River, Inc. Path-analysis toolbar
AUPR991602A0 (en) * 2002-01-11 2002-01-31 Newbrain Technologies Pty Limited A livestock trading method and system
US6866194B2 (en) * 2002-01-23 2005-03-15 Nestec, Ltd. Systems and methods for inventory management
US7370281B2 (en) * 2002-02-22 2008-05-06 Bea Systems, Inc. System and method for smart drag-and-drop functionality
US20030202009A1 (en) * 2002-04-24 2003-10-30 Stephane Kasriel Integration toolbar
US7197517B2 (en) * 2002-09-25 2007-03-27 International Business Machines Corporation Systems, methods, and computer program products to display and select hierarchical database segments and fields
WO2004055646A2 (en) * 2002-12-13 2004-07-01 Gene Codes Forensics, Inc. Method for profiling and identifying persons by using data samples
US7188308B2 (en) * 2003-04-08 2007-03-06 Thomas Weise Interface and method for exploring a collection of data
US7421495B2 (en) * 2003-06-27 2008-09-02 Computer Associates Think, Inc. System and method for monitoring network devices
CN1849602A (en) * 2003-09-09 2006-10-18 皇家飞利浦电子股份有限公司 Method of providing tree-structured views of data
US7904833B2 (en) * 2003-12-08 2011-03-08 International Business Machines Corporation Electronic commerce GUI for displaying trading partners
US7272609B1 (en) * 2004-01-12 2007-09-18 Hyperion Solutions Corporation In a distributed hierarchical cache, using a dependency to determine if a version of the first member stored in a database matches the version of the first member returned
US7949639B2 (en) * 2004-02-20 2011-05-24 Symphonyiri Group, Inc. Attribute segments and data table bias reduction
US10325272B2 (en) * 2004-02-20 2019-06-18 Information Resources, Inc. Bias reduction using data fusion of household panel data and transaction data
US8108430B2 (en) * 2004-04-30 2012-01-31 Microsoft Corporation Carousel control for metadata navigation and assignment
US20050284381A1 (en) * 2004-06-04 2005-12-29 Bell Timothy L Livestock facility equipment network
US20050278650A1 (en) * 2004-06-14 2005-12-15 Sims Lisa K Floating user interface
US8532282B2 (en) * 2004-06-14 2013-09-10 At&T Intellectual Property I, L.P. Tracking user operations
EP1612652A1 (en) * 2004-06-30 2006-01-04 Siemens Aktiengesellschaft Graphical user interface with searchable register cards
US7536634B2 (en) 2005-06-13 2009-05-19 Silver Creek Systems, Inc. Frame-slot architecture for data conversion
US7670213B2 (en) * 2004-09-09 2010-03-02 Elysian Fields Farms, Inc. Method of monitoring the production history of consumable animal primal cuts
US7523131B2 (en) * 2005-02-10 2009-04-21 Oracle International Corporation Techniques for efficiently storing and querying in a relational database, XML documents conforming to schemas that contain cyclic constructs
US20060212371A1 (en) * 2005-03-18 2006-09-21 Inventec Corporation System and method for generating material inventory list
US20070011290A1 (en) * 2005-07-05 2007-01-11 Schaedle R S Method and system for facilitating the advertising of an animal
US20080059500A1 (en) * 2006-09-05 2008-03-06 Chad Symens System and method for collaborative data sharing and analysis
US8671005B2 (en) * 2006-11-01 2014-03-11 Microsoft Corporation Interactive 3D shortage tracking user interface
US20080147519A1 (en) * 2006-12-15 2008-06-19 Scott Reigel Method and System for Conducting Inventories and Appraisals
US8160984B2 (en) 2007-01-26 2012-04-17 Symphonyiri Group, Inc. Similarity matching of a competitor's products
US8504598B2 (en) * 2007-01-26 2013-08-06 Information Resources, Inc. Data perturbation of non-unique values
US10621203B2 (en) * 2007-01-26 2020-04-14 Information Resources, Inc. Cross-category view of a dataset using an analytic platform
US9400814B2 (en) * 2007-11-13 2016-07-26 Oracle International Corporation Hierarchy nodes derived based on parent/child foreign key and/or range values on parent node
US7788305B2 (en) * 2007-11-13 2010-08-31 Oracle International Corporation Hierarchy nodes derived based on parent/child foreign key and/or range values on parent node
US8060828B2 (en) * 2008-08-08 2011-11-15 Yahoo! Inc. Window overlay for online collaboration platform
US10963848B1 (en) * 2009-03-16 2021-03-30 Home Depot Product Authority, Llc Identifying, soliciting, selecting and scheduling service providers
US8266069B2 (en) * 2009-04-10 2012-09-11 Shipwire, Inc. Method and apparatus for hierarchical inbound shipment order configuration
US9256899B2 (en) 2010-01-15 2016-02-09 Dell Products, L.P. System and method for separation of software purchase from fulfillment
US10387927B2 (en) 2010-01-15 2019-08-20 Dell Products L.P. System and method for entitling digital assets
US9235399B2 (en) 2010-01-15 2016-01-12 Dell Products L.P. System and method for manufacturing and personalizing computing devices
US8170783B2 (en) 2010-03-16 2012-05-01 Dell Products L.P. System and method for handling software activation in entitlement
US9501849B2 (en) * 2012-05-11 2016-11-22 Vmware, Inc. Multi-dimensional visualization tool for browsing and troubleshooting at scale
US9779219B2 (en) 2012-08-09 2017-10-03 Dell Products L.P. Method and system for late binding of option features associated with a device using at least in part license and unique ID information
US20140068481A1 (en) * 2012-08-28 2014-03-06 Clint H. O'Connor Rich User Experience in Purchasing and Assignment
US8660888B2 (en) 2013-04-13 2014-02-25 Leachman Cattle of Colorado, LLC System, computer-implemented method, and non-transitory, computer-readable medium to determine relative market value of a sale group of livestock based on genetic merit and other non-genetic factors
US10387834B2 (en) * 2015-01-21 2019-08-20 Palantir Technologies Inc. Systems and methods for accessing and storing snapshots of a remote application in a document
US10198404B2 (en) 2016-06-10 2019-02-05 ProntoForms Inc. Flexible online form display
US11714826B2 (en) * 2020-02-27 2023-08-01 Intuitive Data Analytics, LLC Generation and adaptation of visualizations from one or more data sets stored using a single-branch approach

Family Cites Families (22)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4015366A (en) * 1975-04-11 1977-04-05 Advanced Decision Handling, Inc. Highly automated agricultural production system
US4288856A (en) 1979-12-14 1981-09-08 Linseth Gerald S Livestock feedlot management method and apparatus
FR2550915B1 (en) 1983-08-25 1986-06-06 Chevillot Sarl LIVESTOCK IDENTIFICATION LOOP
US4617876A (en) 1984-11-28 1986-10-21 Hayes Norman J Animal identification and control system
US5008821A (en) 1987-08-12 1991-04-16 Micro Chemical, Inc. Computerized process and system for assigning and delivering feed to animals in a feedlot
US5315505A (en) 1987-08-12 1994-05-24 Micro Chemical, Inc. Method and system for providing animal health histories and tracking inventory of drugs
CA2102150A1 (en) 1992-11-09 1994-05-10 J. Sam Cureton Computer network and method for feeding animals in a feedlot using the same
US5351644B1 (en) 1993-02-25 2000-04-18 Cornell Res Foundation Inc Method of bovine herd management
AU6707394A (en) 1993-04-20 1994-11-08 Apple Computer, Inc. Interactive user interface
US5592606A (en) * 1993-07-30 1997-01-07 Myers; Allen Method and apparatus for storage and display of hierarchally organized data
US5424957A (en) 1993-10-07 1995-06-13 Info Tech Accurate metering and control system and method for livestock feeding operation
US5450317A (en) * 1993-11-24 1995-09-12 U S West Advanced Technologies, Inc. Method and system for optimized logistics planning
US5673647A (en) 1994-10-31 1997-10-07 Micro Chemical, Inc. Cattle management method and system
US5838319A (en) 1994-12-13 1998-11-17 Microsoft Corporation System provided child window control for displaying items in a hierarchical fashion
USH1743H (en) * 1995-03-17 1998-08-04 Hercules Incorporated Inventory management method and apparatus
US5623589A (en) 1995-03-31 1997-04-22 Intel Corporation Method and apparatus for incrementally browsing levels of stories
US5701137A (en) * 1995-05-24 1997-12-23 Microsoft Corporation Method for separating a hierarchical tree control into one or more hierarchical child tree controls in a graphical user interface
US5740549A (en) 1995-06-12 1998-04-14 Pointcast, Inc. Information and advertising distribution system and method
US5619555A (en) 1995-07-28 1997-04-08 Latitude Communications Graphical computer interface for an audio conferencing system
US5923328A (en) * 1996-08-07 1999-07-13 Microsoft Corporation Method and system for displaying a hierarchical sub-tree by selection of a user interface element in a sub-tree bar control
US5910803A (en) * 1996-08-14 1999-06-08 Novell, Inc. Network atlas mapping tool
US6259448B1 (en) * 1998-06-03 2001-07-10 International Business Machines Corporation Resource model configuration and deployment in a distributed computer network

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20140052600A1 (en) * 2003-09-11 2014-02-20 Bgc Partners, Inc Graphical user interface related to non-standard trading of financial instruments
US9858618B2 (en) * 2003-09-11 2018-01-02 Bgc Partners, Inc. Graphical user interface related to non-standard trading of financial instruments
US10726483B2 (en) 2003-09-11 2020-07-28 Bgc Partners, Inc. Graphical user interface related to non-standard trading of financial instruments
US11605129B2 (en) 2003-09-11 2023-03-14 Bgc Partners, Inc. Graphical user interface related to non-standard trading of financial instruments

Also Published As

Publication number Publication date
AU777146B2 (en) 2004-10-07
US6642946B1 (en) 2003-11-04
AU6906700A (en) 2001-03-13
WO2001013302A3 (en) 2002-08-15
WO2001013302A2 (en) 2001-02-22

Similar Documents

Publication Publication Date Title
AU777146B2 (en) Livestock inventory and materials system with interactive graphical user interface
US7131069B1 (en) Navigational interface for ERP system
US5721903A (en) System and method for generating reports from a computer database
US5710900A (en) System and method for generating reports from a computer database
US5692181A (en) System and method for generating reports from a computer database
US20190347263A1 (en) Data entry commentary and sheet reconstruction for multidimensional enterprise system
US7778899B2 (en) Method and system for object-oriented workflow management of multi-dimensional data
US5619688A (en) Method and system for constructing database queries using a field selection grid
US7584210B2 (en) Method and apparatus for creation and maintenance of database structure
US7568200B2 (en) Computer-implemented method and apparatus for inventory management
US8112461B2 (en) System and method for storing item attributes in an electronic catalog
US8285580B2 (en) System and method for filtering exceptions generated by forecasting and replenishment engine
US7949953B2 (en) Designing and generating charts to graphically represent data in a data source
US20030115207A1 (en) Hierarchical hybrid OLAP analytics generators
US20030061225A1 (en) Hierarchical hybrid OLAP scenario management system
US20030171979A1 (en) System and method for selecting and arranging products on a shelf
US8738464B2 (en) Method, medium, and system for online selection and ordering of custom furniture
US20010003455A1 (en) Method, system and graphic user interface for entering and editing filter conditions for filtering a database
US20060112070A1 (en) Interactive graphical interface for data manipulation and presentation
US20030061246A1 (en) Hierarchical hybrid online analytical processing services system
JP2007536627A (en) System and method for an electronic catalog supplier portal
US20090125830A1 (en) Compound Fields
US20050283466A1 (en) Techniques for creating queries
US6892357B2 (en) Logistics management method and system
JPH0877184A (en) Device and method for retrieving data base, direct mail issuance supporting system with data base retrieving device, device and method for evaluating customer, and direct mail issuance supporting system with customer evaluating device

Legal Events

Date Code Title Description
EEER Examination request
FZDE Discontinued