Skip to main content

Window: Session Audit

[Created: 28/05/2003 - Updated: 02/01/2000 ]
Description: Audit of User Sessions
Help: History of Online or Web Sessions

Tab: Session Audit

[Created: 28/05/2003 - Updated: 02/01/2000 ]
Description: List of User Sessions
Help: History of Online or Web Sessions
Tab Level: 0

Table 10: Session Audit - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.ad_session.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.ad_session.AD_Org_ID numeric(10)
Table Direct
CreatedDate this record was createdThe Created field indicates the date that this record was created.ad_session.Created timestamp without time zone
Date+Time
Created ByUser who created this recordsThe Created By field indicates the user who created this record.ad_session.CreatedBy numeric(10)
Search
UpdatedDate this record was updatedThe Updated field indicates the date that this record was updated.ad_session.Updated timestamp without time zone
Date+Time
Remote AddrRemote AddressThe Remote Address indicates an alternative or external address.ad_session.Remote_Addr character varying(60)
String
Remote HostRemote host Infoad_session.Remote_Host character varying(120)
String
Server NameNode instance namead_session.ServerName character varying(80)
Text
Web SessionWeb Session IDad_session.WebSession character varying(40)
String
RoleResponsibility RoleThe Role determines security and access a user who has this Role will have in the System.ad_session.AD_Role_ID numeric(10)
Table Direct
Login datead_session.LoginDate timestamp without time zone
Date
DescriptionOptional short description of the recordA description is limited to 255 characters.ad_session.Description character varying(2000)
Text
ProcessedThe document has been processedThe Processed checkbox indicates that a document has been processed.ad_session.Processed character(1)
Yes-No

Tab: Change Audit

[Created: 29/05/2003 - Updated: 24/09/2005 ]
Description: Data Changes
Help: Log of data changes
Tab Level: 1

Table 20: Change Audit - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant 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
OrganizationOrganizational entity within tenantAn 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
SessionUser Session Online or WebOnline or Web Session Informationad_changelog.AD_Session_ID numeric(10)
Search
TransactionName of the transactionInternal name of the transactionad_changelog.TrxName character varying(1000)
String
Change LogLog of data changesLog of data changesad_changelog.AD_ChangeLog_ID numeric(10)
ID
UpdatedDate this record was updatedThe Updated field indicates the date that this record was updated.ad_changelog.Updated timestamp without time zone
Date+Time
Updated ByUser who updated this recordsThe Updated By field indicates the user who updated this record.ad_changelog.UpdatedBy numeric(10)
Search
TableDatabase Table informationThe Database Table provides the information of the table definitionad_changelog.AD_Table_ID numeric(10)
Table Direct
Record IDDirect internal record IDThe 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
ColumnColumn in the tableLink to the database column of the tablead_changelog.AD_Column_ID numeric(10)
Search
Record UUIDad_changelog.Record_UU character varying(36)
Record UUID
ActiveThe record is active in the systemThere 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
CustomizationThe change is a customization of the data dictionary and can be applied after MigrationThe 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 LogType of Event in Change Logad_changelog.EventChangeLog character(1)
List
Old ValueThe old file dataOld data overwritten in the fieldad_changelog.OldValue character varying(4000)
String
New ValueNew field valueNew data entered in the fieldad_changelog.NewValue character varying(4000)
String
DescriptionOptional short description of the recordA description is limited to 255 characters.ad_changelog.Description character varying(255)
String
Un-Do ChangesUndo changesYou can undo certain changes.ad_changelog.Undo character(1)
Button
Re-Do ChangesReapply changesYou can reapply certain changes.ad_changelog.Redo character(1)
Button