# ItemTransactions: ionBIZ Item Transactions - Catalog: `ionBIZ` - Label: Item Transactions - Retrieve: true ## Table Columns The columns of the table `ItemTransactions` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `BookedAmount` | `decimal` | Booked Amount | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `CurrencyId` | `int32` | Currency ID | ☐ | | | `FromDeliveryNoteLineId` | `int32` | From Delivery Note Line ID | ☐ | | | `FromProjectCostId` | `int32` | From Project Cost ID | ☐ | | | `FromProjectItemProducedId` | `int32` | From Project Item Produced ID | ☐ | | | `FromPurchaseQuoteLineId` | `int32` | From Purchase Quote Line ID | ☐ | | | `FromStockId` | `int32` | From Stock ID | ☐ | | | `Id` | `int32` | ID | ☑ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `ItemId` | `int32` | Item ID | ☐ | | | `Manual` | `boolean` | Manual | ☐ | | | `ToDeliveryNoteLineId` | `int32` | To Delivery Note Line ID | ☐ | | | `ToProjectCostId` | `int32` | To Project Cost ID | ☐ | | | `ToProjectItemProducedId` | `int32` | To Project Item Produced ID | ☐ | | | `ToPurchaseQuoteLineId` | `int32` | To Purchase Quote Line ID | ☐ | | | `ToStockId` | `int32` | To Stock ID | ☐ | | | `UnitCost` | `decimal` | Unit Cost | ☐ | |