# TransactionVariables: ionBIZ Transaction Variables
- Catalog: `ionBIZ`
- Label: Transaction Variables
- Retrieve: true
## Table Columns
The columns of the table `TransactionVariables` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `Id` | `int32` | ID | ☑ | |
| `SPID` | `int16` | SPID | ☐ | |
| `TransactionId` | `int64` | Transaction ID | ☐ | |
| `VariableName` | `string` | Variable Name | ☐ | |
| `VariableValue` | `string` | Variable Value | ☐ | |