# Paymentshistories - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Paymentshistories` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `BankAccountId` | `int32` | Bank Account ID | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `CurrencyConvertorFactor` | `decimal` | Currency Convertor Factor | ☐ | | | `CurrencyId` | `int32` | Currency ID | ☐ | | | `Date` | `datetimeoffset` | Date | ☐ | | | `DeletedById` | `int32` | Deleted by ID | ☐ | | | `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | | | `ExternalCode` | `string` | External Code | ☐ | | | `Id` | `int32` | ID | ☑ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `LocalAmount` | `decimal` | Local Amount | ☐ | | | `ModifiedById` | `int32` | Modified by ID | ☐ | | | `Notification` | `string` | Notification | ☐ | | | `RelationId` | `int32` | Relation ID | ☐ | | | `SysEndTime` | `datetimeoffset` | System End Time | ☐ | | | `SysStartTime` | `datetimeoffset` | System Start Time | ☐ | |