# CRS_OI3: Open items (journals) - Name: `CRS_OI3` - Catalog: `AccountView` - Label: Open items (journals) - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `CRS_OI3` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `DIF_AMT` | `int64` | Difference amount | ☐ | | | `DIF_CUR` | `int64` | Difference amount (foreign currency) | ☐ | | | `DIF_TYPE` | `decimal` | Difference type | ☐ | | | `DJ_CODE` | `string(3)` | Journal code | ☐ | | | `OPN_CUR` | `int64` | Outstanding amount (foreign currency) | ☐ | | | `PAID_AMT` | `int64` | Amount paid | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PDIF_VAT` | `int64` | Payment discount difference amount | ☐ | |