Abstract: A reusable ERP data retrieval object, in particular, a wide application query object provides a systematic and standardized approach to data retrieval. In one embodiment, the wide application query object is an encapsulated query object in that multiple queries are aggregated into one master query object (i.e., the wide application query object) that can, but does not necessarily have to, span multiple disparate data sources. In another embodiment, data retrieved in accordance with the wide application query logic is manipulated by code in any of a variety of different ways using a trigger model and specialized constructs. In still another embodiment, public parameters are utilized to trigger functions that impact the substance and layout of the query output.

Abstract: A method and system for integrating form data in an ERP system with a target application are provided. The method includes receiving a first input from a user of an ERP system while a form is running on an application layer of the ERP system to initiate a data integration process. Next, a metadata form XML file is generated at an ERP platform layer from the form running on the application layer. Then, the metadata form XML file is sent from the ERP platform layer to the application layer for use by target applications in integrating data from the form into the target applications.

Abstract: A method and system for integrating form data in an ERP system with a target application are provided. The method includes receiving a first input from a user of an ERP system while a form is running on an application layer of the ERP system to initiate a data integration process. Next, a metadata form XML file is generated at an ERP platform layer from the form running on the application layer. Then, the metadata form XML file is sent from the ERP platform layer to the application layer for use by target applications in integrating data from the form into the target applications.