ManPageW SessionAudit

From ADempiere ERP Wiki

Jump to: navigation, search

Return to Index

Enjoy it, and help to fill it! But please, always respecting copyright.

Please write your contributions under the Contributions Section



Contents

Window: Session Audit

Description : Audit of User Sessions

Help : History of Online or Web Sessions



Tab: Session Audit

Description : List of User Sessions

Help : History of Online or Web Sessions

Table Name  : AD_Session

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

Created Date this record was created The Created field indicates the date that this record was created. Created

DATE

DateTime

Created By User who created this records The Created By field indicates the user who created this record. CreatedBy

NUMBER(10)

Table

Updated Date this record was updated The Updated field indicates the date that this record was updated. Updated

DATE

DateTime

Remote Addr Remote Address The Remote Address indicates an alternative or external address. Remote_Addr

NVARCHAR2(60)

String

Remote Host Remote host Info Remote_Host

NVARCHAR2(120)

String

Web Session Web Session ID WebSession

VARCHAR2

String

Login date LoginDate

DATE

Date

Role Responsibility Role The Role determines security and access a user who has this Role will have in the System. AD_Role_ID

NUMBER(10)

TableDir

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Processed The document has been processed The Processed checkbox indicates that a document has been processed. Processed

CHAR(1)

YesNo


Tab: Change Audit

Description : 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

Event Change Log Type of Event in Change Log EventChangeLog

CHAR(1)

List

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

Contributions

Personal tools