Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
FinanceCenter
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| FinanceCenterID | INTEGER | ? | MANDATORY | FK |
| FinanceCenterCode | CHARACTER(4) | MANDATORY | User entered code that uniquely identifies the finance center. | |
| SortName | CHARACTER(60) | OPTIONAL | Programmatically set sort name. | |
| PracticeID | INTEGER | ? | OPTIONAL | FK |
| Class | CHARACTER(6) | OPTIONAL | User Entered. User selects finance center class code. Field is supported by the lookup types:[FinanceCtrClass]. Values are defined in the LookupCode table for the above lookup types. | |
| DepartmentCode | CHARACTER(3) | OPTIONAL | Department code is selected by the user. Department code is limited to numeric input although stored as a character. | |
| RecordStatus | CHARACTER(1) | MANDATORY | User selected record status for the finance center. 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. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Entity | FinanceCenter.FinanceCenterID = Entity.EntitySID | CASCADE if FinanceCenter exists |
| Department | FinanceCenter.DepartmentCode = Department.DepartmentCode | RESTRICT if FinanceCenter exists |
| Practice | FinanceCenter.PracticeID = Practice.PracticeID | RESTRICT if FinanceCenter exists |
| Child Table | Join Phrase | When deleting FinanceCenter record... |
|---|---|---|
| Charge | Charge.FinanceCenterID = FinanceCenter.FinanceCenterID | RESTRICT if Charge exists |
| Staff | Staff.FinanceCenterID = FinanceCenter.FinanceCenterID | RESTRICT if Staff exists |