Abstract: A system and method are provided for automatically managing item record interchange in a business enterprise, where an item may be a product, component part, partially assembled or manufactured part, a process, or other item that requires indicia used to identify it within a business enterprise, whether it is a single company enterprise, or a widespread business that receives items from other sources such as manufacturers, suppliers, purchasers, shippers, or other entities. The system provides a universal solution that allows the intake of item records, such as records for manufacturer component parts shipped to a product manufacturer, and integrating the part records from disparate sources into a standard and useable format.

Abstract: A system and method are provided for automatically managing item record interchange in a business enterprise, where an item may be a product, component part, partially assembled or manufactured part, a process, or other item that requires indicia used to identify it within a business enterprise, whether it is a single company enterprise, or a widespread business that receives items from other sources such as manufacturers, suppliers, purchasers, shippers, or other entities. The system provides a universal solution that allows the intake of item records, such as records for manufacturer component parts shipped to a product manufacturer, and integrating the part records from disparate sources into a standard and useable format.

Abstract: A method of recognizing and normalizing repeatable data pattern from a file uses a computer executing a computer program. The file is first received by the computer program. The data pattern of the file is recognized based upon a profile selected from a plurality of profiles from a library. The file is parsed into a plurality of data fields based upon the profile selected. The data from the file is stored in a database.

Abstract: A computer-implemented method of customizing a database application at runtime includes steps of storing a value associated with a new attribute in an attribute table. The attribute table is configured as a logical extension of a base table that is configured to store values associated with a number of base attributes. The definitions of the new attributes may be stored in an attribute metadata table that is adapted to store the definition of each of the new attributes of the attribute table. A base-attribute pair may be stored in a base-attribute mapping table, the base-attribute pair mapping the name of the base table to the name of the attribute table. An extended attribute may also be stored in an extended attribute table, the extended attribute table including a name column configured to store the extended attribute and a value column configured to store an extended attribute value corresponding to the extended attribute.