# RelationContacts: ionBIZ Customer Contacts - Catalog: `ionBIZ` - Label: Customer Contacts - Retrieve: true ## Table Columns The columns of the table `RelationContacts` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Active` | `boolean` | Active | ☐ | | | `AllowLogin` | `boolean` | Allow Login | ☐ | | | `Comment` | `string` | Comment | ☐ | | | `ContactId` | `int32` | Contact ID | ☐ | | | `ContactTitleId` | `int32` | Contact Title ID | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `DeletedById` | `int32` | Deleted by ID | ☐ | | | `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | | | `Department` | `string` | Department | ☐ | | | `Email` | `string` | Email | ☐ | | | `EnableMfa` | `boolean` | Enable MFA | ☐ | | | `EndDate` | `datetimeoffset` | End Date | ☐ | | | `Function` | `string` | Function | ☐ | | | `Id` | `int32` | ID | ☑ | | | `InvoiceReceiver` | `boolean` | Invoice Receiver | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `Language` | `string` | Language | ☐ | | | `MobilePhone` | `string` | Mobile Phone | ☐ | | | `ModifiedById` | `int32` | Modified by ID | ☐ | | | `OptOutMailing` | `boolean` | Opt-out Mailing | ☐ | | | `ParentId` | `int32` | Parentid | ☐ | | | `Password` | `string` | Password | ☐ | | | `PersonalRelationId` | `int32` | Personal Relation ID | ☐ | | | `PurchaseOrderReciever` | `boolean` | Purchase Order Receiver | ☐ | | | `RelationAddressId` | `int32` | Relation Address ID | ☐ | | | `RelationId` | `int32` | Relation ID | ☐ | | | `ResourceId` | `int32` | Resource ID | ☐ | | | `RoleId` | `int32` | Role ID | ☐ | | | `Salutation` | `string` | Salutation | ☐ | | | `StartDate` | `datetimeoffset` | Start Date | ☐ | | | `SysEndTime` | `datetimeoffset` | System End Time | ☐ | | | `SysStartTime` | `datetimeoffset` | System Start Time | ☐ | | | `Telephone` | `string` | Telephone | ☐ | | | `TransferDate` | `datetimeoffset` | Transfer Date | ☐ | | | `TransferedFromRelationContactId` | `int32` | Transferred from Relation Contact ID | ☐ | | | `TransferredById` | `int32` | Transferred by ID | ☐ | | | `UseInIssues` | `boolean` | Use in Issues | ☐ | | | `Username` | `string` | User Name | ☐ | |