Abstract: A software application or module enables real-time tracking and auditing of general ledger assertions in real-time during the processing of a given event with respect to a particular contract, ensuring that all entries are reconciled and recorded as they occur. The system allows an internal audit to be performed in real-time, and can be configured to automatically block workflow in the case of a discrepancy between a contract and the general ledger as revealed by the audit.

Abstract: Access to an individual tenant's data within a multi-tenant relational database architecture is provided, without unduly exposing data of other tenants. A list of accessible tables is presented to an authenticated individual, such as a developer. Specific information can be designated as sensitive and can be excluded from the information the developer can access. A specialized user interface provides secure point-and-click access to data by allowing selection of a set of higher-level data types to retrieve. Access to data from a related table can be enabled by providing a hyperlink that, when activated, retrieves a relevant record from the related table. Primary key values can also be rendered as hyperlinks that can activate a pop-up menu showing all tables that refer to that primary key value. In at least one embodiment, SQL queries are automatically constructed based on the user's selection of items from the pop-up menu.

Abstract: Access to an individual tenant's data within a multi-tenant relational database architecture is provided, without unduly exposing data of other tenants. A list of accessible tables is presented to an authenticated individual, such as a developer. Specific information can be designated as sensitive and can be excluded from the information the developer can access. A specialized user interface provides secure point-and-click access to data by allowing selection of a set of higher-level data types to retrieve. Access to data from a related table can be enabled by providing a hyperlink that, when activated, retrieves a relevant record from the related table. Primary key values can also be rendered as hyperlinks that can activate a pop-up menu showing all tables that refer to that primary key value. In at least one embodiment, SQL queries are automatically constructed based on the user's selection of items from the pop-up menu.