Window: Change Audit
[Created: 29/05/2003 - Updated: 02/01/2000 ]
Description: Audit of data changes
Help: Log of data changes
Tab: Change Audit
[Created: 29/05/2003 - Updated: 24/09/2005 ]
Description: Log of data changes
Help: Log of data changes
Tab Level: 0
Table 10: Change Audit - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | ad_changelog.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | ad_changelog.AD_Org_ID numeric(10) Table Direct |
| Session | User Session Online or Web | Online or Web Session Information | ad_changelog.AD_Session_ID numeric(10) Search |
| Transaction | Name of the transaction | Internal name of the transaction | ad_changelog.TrxName character varying(1000) String |
| Change Log | Log of data changes | Log of data changes | ad_changelog.AD_ChangeLog_ID numeric(10) ID |
| Updated | Date this record was updated | The Updated field indicates the date that this record was updated. | ad_changelog.Updated timestamp without time zone Date+Time |
| Updated By | User who updated this records | The Updated By field indicates the user who updated this record. | ad_changelog.UpdatedBy numeric(10) Search |
| Table | Database Table information | The Database Table provides the information of the table definition | ad_changelog.AD_Table_ID numeric(10) Table Direct |
| Record ID | Direct internal record ID | The Record ID is the internal unique identifier of a record. Please note that zooming to the record may not be successful for Orders, Invoices and Shipment/Receipts as sometimes the Sales Order type is not known. | ad_changelog.Record_ID numeric(10) Record ID |
| Column | Column in the table | Link to the database column of the table | ad_changelog.AD_Column_ID numeric(10) Search |
| Record UUID | ad_changelog.Record_UU character varying(36) Record UUID | ||
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. | ad_changelog.IsActive character(1) Yes-No |
| Customization | The change is a customization of the data dictionary and can be applied after Migration | The migration "resets" the system to the current/original setting. If selected you can save the customization and re-apply it. Please note that you need to check, if your customization has no negative side effect in the new release. | ad_changelog.IsCustomization character(1) Yes-No |
| Event Change Log | Type of Event in Change Log | ad_changelog.EventChangeLog character(1) List | |
| Old Value | The old file data | Old data overwritten in the field | ad_changelog.OldValue character varying(4000) String |
| New Value | New field value | New data entered in the field | ad_changelog.NewValue character varying(4000) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | ad_changelog.Description character varying(255) String |
| Un-Do Changes | Undo changes | You can undo certain changes. | ad_changelog.Undo character(1) Button |
| Re-Do Changes | Reapply changes | You can reapply certain changes. | ad_changelog.Redo character(1) Button |