Password Policies

AD_PasswordRule

Overview

Table NameAD_PasswordRule
Access LevelSystem Only
Entity TypeD
Is DocumentNo
Is ViewNo
Has UUIDYes
Parent TableAD_Client
WikiView on iDempiere Wiki

Columns (27)

Column Type Required Default Description
AD_PasswordRule_UU String(36) No - -
Days_Reuse_Password Integer(10) No - Define number of day can reuse password
Name String(60) Yes - Alphanumeric identifier of the entity
AD_Client_ID Table Direct(10) Yes - Tenant for this installation.
AD_Org_ID Table Direct(10) Yes - Organizational entity within tenant
AD_PasswordRule_ID ID(10) Yes - -
AlphabeticalCharacter Integer(10) No - Require at least # alphabetical in passwords
AlphabeticalSequence Integer(10) No - Length of alphabetical sequence to validate
Created Date+Time(29) Yes SYSDATE Date this record was created
CreatedBy Search(10) Yes - User who created this records
DigitCharacter Integer(10) No - Require at least # digit in passwords
IsActive Yes-No(1) Yes Y The record is active in the system
IsDictMatchBackwards Yes-No(1) Yes N Match dictionary words backwards
IsUserNameRule Yes-No(1) Yes N Validate the password doesn't contain user name (ignore case and match backwards)
IsUsingDictionary Yes-No(1) Yes N -
IsWhitespace Yes-No(1) Yes N Whitespace validation
LowercaseCharacter Integer(10) No - Require at least # lower case char
MaxLength Integer(10) No - Maximum Length of Data
MinLength Integer(10) No - -
NonAlphaNumericCharacter Integer(10) No - Require at least # non-alphanumeric char
NumericalSequence Integer(10) No - Length of numerical sequence to validate
PathDictionary FileName(255) No - -
QWERTYSequence Integer(10) No - Length of QWERTY sequences to validate
RepeatCharacterRegex Integer(10) No - Length of repeated characters to validate
Updated Date+Time(29) Yes SYSDATE Date this record was updated
UpdatedBy Search(10) No - User who updated this records
UppercaseCharacter Integer(10) No - Require at least # upper case char

Foreign Keys

Column References Description
AD_Client_ID AD_Client.AD_Client_ID Tenant for this installation.
AD_Org_ID AD_Org.AD_Org_ID Organizational entity within tenant

Generated on 2026-05-03T17:56:58.272996067Z