Adempiere3.1.2/en/ManPageW ChangeAudit olh
Window: Change Audit
Description : Audit of data changes
Help : Log of data changes
Tab: Change Audit
Description : Log of data changes
Help : Log of data changes
Table Name : AD_ChangeLog
Fields
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
| Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
| Session | User Session Online or Web | Online or Web Session Information | AD_Session_ID
NUMBER(10) TableDir |
| Transaction | Name of the transaction | Internal name of the transcation | TrxName
NVARCHAR2(60) String |
| Change Log | Log of data changes | Log of data changes | AD_ChangeLog_ID
NUMBER(10) ID |
| Updated | Date this record was updated | The Updated field indicates the date that this record was updated. | Updated
DATE DateTime |
| Updated By | User who updated this records | The Updated By field indicates the user who updated this record. | UpdatedBy
NUMBER(10) Table |
| Table | Database Table information | The Database Table provides the information of the table definition | AD_Table_ID
NUMBER(10) TableDir |
| 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. | Record_ID
NUMBER(10) Button |
| Column | Column in the table | Link to the database column of the table | AD_Column_ID
NUMBER(10) TableDir |
| 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. |
IsActive
CHAR(1) YesNo |
| 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. | IsCustomization
CHAR(1) YesNo |
| Old Value | The old file data | Old data overwritten in the field | OldValue
NVARCHAR2(2000) String |
| New Value | New field value | New data entered in the field | NewValue
NVARCHAR2(2000) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
| Un-Do Changes | Undo changes | You can undo certain changes. | Undo
CHAR(1) Button |
| Re-Do Changes | Reapply changes | You can reapply certain changes. | Redo
CHAR(1) Button |
