Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
AccountStatus
Table Definition  Parent Tables  Child Tables
Table DefinitionField | 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 Table | Join Phrase | When deleting parent record... |
---|
Child Table | Join Phrase | When deleting AccountStatus record... |
---|---|---|
Account | Account.AccountStatus = AccountStatus.AccountStatus | RESTRICT if Account exists |