# Resources: ionBIZ Resources - Catalog: `ionBIZ` - Label: Resources - Retrieve: true ## Table Columns The columns of the table `Resources` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AccountManager` | `boolean` | Account Manager | ☐ | | | `Active` | `boolean` | Active | ☐ | | | `Address_CountryId` | `int32` | Address Country ID | ☐ | | | `AllowAccessToViewIssueSalesPrice` | `boolean` | Allow Access to View Issue Sales Price | ☐ | | | `AllowAccesToViewIssueBillable` | `boolean` | Allow Access to View Issue Billable | ☐ | | | `BadgingRequired` | `boolean` | Badging Required | ☐ | | | `BankAccount` | `string` | Bank Account | ☐ | | | `Bic` | `string` | BIC | ☐ | | | `Birthdate` | `datetimeoffset` | Birth Date | ☐ | | | `CanSyncExchange` | `boolean` | Can Synchronization Exchange | ☐ | | | `Color` | `string` | Colour | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `CurrencyId` | `int32` | Currency ID | ☐ | | | `CVPicture` | `byte[]` | CV Picture | ☐ | | | `CVSkillLevelColorOne` | `string` | CV Skill Level Colour One | ☐ | | | `CVSkillLevelColorTwo` | `string` | CV Skill Level Colour Two | ☐ | | | `CVText1` | `string` | CV Text 1 | ☐ | | | `CVText2` | `string` | CV Text 2 | ☐ | | | `DeletedById` | `int32` | Deleted by ID | ☐ | | | `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | | | `DepartmentId` | `int32` | Department ID | ☐ | | | `Email` | `string` | Email | ☐ | | | `EnableMfa` | `boolean` | Enable MFA | ☐ | | | `EndDate` | `datetimeoffset` | End Date | ☐ | | | `ExternalCode` | `string` | External Code | ☐ | | | `FlexOTCounterDayFrom` | `datetimeoffset` | Flex o t Counter day from | ☐ | | | `FullName` | `string` | Full Name | ☐ | | | `FunctionId` | `int32` | Function ID | ☐ | | | `Iban` | `string` | IBAN | ☐ | | | `Id` | `int32` | ID | ☑ | | | `IncludeBreakInTimeRegistration` | `boolean` | Include Break in Time Registration | ☐ | | | `Initials` | `string` | Initials | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `IsProjectManager` | `boolean` | Is Project Manager | ☐ | | | `Language` | `string` | Language | ☐ | | | `LocationId` | `int32` | Location ID | ☐ | | | `MobilePhone` | `string` | Mobile Phone | ☐ | | | `ModifiedById` | `int32` | Modified by ID | ☐ | | | `Name` | `string` | Name | ☐ | | | `Name2` | `string` | Name2 | ☐ | | | `PayrollCode` | `string` | Payroll Code | ☐ | | | `PeriodicTimesheetConfirmationDuration` | `int32` | Periodic Timesheet Confirmation Duration | ☐ | | | `Picture` | `byte[]` | Picture | ☐ | | | `PlaceOfBirth` | `string` | Place of Birth | ☐ | | | `PlanningSynchronizationDefaultToPrimaryCalendar` | `boolean` | Planning Synchronization Default to Primary Calendar | ☐ | | | `PlanningSynchronizationExchangeCalendarId` | `string` | Planning Synchronization Exchange Calendar ID | ☐ | | | `PlanningSynchronizationExchangeCalendarName` | `string` | Planning Synchronization Exchange Calendar Name | ☐ | | | `PlanningSynchronizationShowIonSyncTicketDropdown` | `boolean` | Planning Synchronization Show ion Synchronization Ticket Dropdown | ☐ | | | `PrivateEmailAddress` | `string` | Private Email Address | ☐ | | | `PrivateMobilePhone` | `string` | Private Mobile Phone | ☐ | | | `ProjectManager` | `boolean` | Project Manager | ☐ | | | `RequiredPercentageTimesheetConfirmation` | `int32` | Required Percentage Timesheet Confirmation | ☐ | | | `ResourceCategory` | `int32` | Resource Category | ☐ | | | `ResourceLanguageId` | `int32` | Resource Language ID | ☐ | | | `ResourceTypeId` | `int32` | Resource Type ID | ☐ | | | `RoleId` | `int32` | Role ID | ☐ | | | `SendDailyEmailNotificationForProjectPlanning` | `boolean` | Send Daily Email Notification for Project Planning | ☐ | | | `SendEmailNotificationForPlanning` | `boolean` | Send Email Notification for Planning | ☐ | | | `SendingEmailNotificationForUnregisteredTime` | `boolean` | Sending Email Notification for Unregistered Time | ☐ | | | `Sex` | `string` | Sex | ☐ | | | `ShortName` | `string` | Short Name | ☐ | | | `Sofi` | `string` | Social Security Number | ☐ | | | `StartDate` | `datetimeoffset` | Start Date | ☐ | | | `SysEndTime` | `datetimeoffset` | System End Time | ☐ | | | `SysStartTime` | `datetimeoffset` | System Start Time | ☐ | | | `SystemAdministrator` | `boolean` | System Administrator | ☐ | | | `Telephone` | `string` | Telephone | ☐ | | | `UseIpRecognition` | `boolean` | Use IP Recognition | ☐ | |