Last Updated: 7/22/2025 8:42:49 PM

Intergy Version: 22.00.00.00

AccountStatus

Table Definition  Parent Tables  Child Tables

Table Definition

Description: This table is used to define possible account status values. An event may be associated with the status as well.

Field Datatype Default Null Option Comment
AccountStatus CHARACTER(10)   MANDATORY Account status code. User entered.
Event CHARACTER(8)   OPTIONAL User selected account status event for the account status. Event is defined in the LookupCode table for the lookup type 'AcctStatusEvent'. Codes for lookup type 'AcctStatusEvent' are not user definable.
Description CHARACTER(60)   OPTIONAL Description of the status. User entered.
RecordStatus CHARACTER(1)   MANDATORY User selected record status for the account status. RecordStatus is defined in the LookupCode table for the lookup type 'RecordStatus'. Codes for lookup type 'RecordStatus' are not user definable. Valid codes are (A)ctive and (I)nactive.
TimeStamp CHARACTER(14)   OPTIONAL System generated date/time stamp record was last written.
LastUser INTEGER ?   OPTIONAL User ID of user that last wrote the record.
CreateStamp CHARACTER(14)   OPTIONAL System generated date/time stamp record was created.
CreateUser INTEGER ?   OPTIONAL User ID of user that created the record.
ActiveAccount CHARACTER(1)   MANDATORY This field determines if the status indicates the account is active or inactive. If the flag is (Y)es then the Account.RecordStatus field is set active, if (N)o then the Account.RecordStatus is set inactive.
DeactivatesAccount CHARACTER(1)   MANDATORY This flag indicates whether or not the account status causes the account to be deactivated. Possible values are (Y)es or (N)o and are validated by the Confirmation lookup type.

Parent Tables
Parent TableJoin PhraseWhen deleting parent record...

Child Tables
Child TableJoin PhraseWhen deleting AccountStatus record...
Account Account.AccountStatus = AccountStatus.AccountStatus RESTRICT if Account exists