# OPENITEM: Open items - Name: `OPENITEM` - Catalog: `AccountView` - Label: Open items - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `OPENITEM` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AG_DATE` | `datetime` | Scheduling date | ☐ | | | `AG_PAYREF` | `string(19)` | Acceptgiro payment reference | ☐ | | | `AMT_INT` | `int64` | Interest/costs | ☐ | | | `AMT_MARK` | `int64` | Open amount when marking | ☐ | | | `AMT_PAY` | `int64` | Amount payable | ☐ | | | `AMT_PAYN` | `int64` | Amount payable (negative) | ☐ | | | `ASTERIK` | `string(1)` | Asterisk for overdue invoice | ☐ | | | `AUTH_DATE` | `datetime` | Approval date | ☐ | | | `AUTH_EMP` | `string(10)` | Approving employee | ☐ | | | `BANK_ACCT` | `string(10)` | Bank account field name | ☐ | | | `BANK_ACCTV` | `string(42)` | Bank account | ☐ | | | `CNG_DATE` | `datetime` | Date last modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `COLL_DATE` | `datetime` | Date handed over | ☐ | | | `COMMENT1` | `string(4)` | Note | ☐ | | | `COST_CODE` | `string(10)` | Cost centre code | ☐ | | | `CR_AMT` | `int64` | Credit amount | ☐ | | | `CRED_DAYS` | `decimal` | Payment term in days | ☐ | | | `CRED_SHOW` | `boolean` | Supplier | ☐ | | | `CUR_CAMT` | `int64` | Currency amount (credit) | ☐ | | | `CUR_CODE` | `string(3)` | Currency code | ☐ | | | `CUR_DAMT` | `int64` | Currency amount (debit) | ☐ | | | `CUR_INT` | `int64` | Currency amount interest/costs | ☐ | | | `CUR_SIGN` | `string(1)` | Currency symbol | ☐ | | | `DATE_PAID` | `datetime` | Date paid | ☐ | | | `DD_ACT` | `boolean` | Direct debit | ☐ | | | `DEB_SHOW` | `boolean` | Customer | ☐ | | | `DISC_DAYS` | `decimal` | Discount term in days | ☐ | | | `DISP_INV` | `boolean` | Manually blocked for automatic payment/direct debit | ☐ | | | `DJ_CODE` | `string(3)` | Journal code | ☐ | | | `DOC_ID` | `string(32)` | Document code | ☐ | | | `DOC_TYPE` | `int32` | Document type | ☐ | | | `DR_AMT` | `int64` | Debit amount | ☐ | | | `DR_TYPE` | `boolean` | Debit type | ☐ | | | `EXT_ID` | `string(32)` | External identification | ☐ | | | `EXT_TYPE` | `decimal` | External source | ☐ | | | `FIAT_PRIO` | `decimal` | Approval priority | ☐ | | | `GREK_TYPE` | `string(1)` | Transaction type G-account | ☐ | | | `HAS_COMM` | `boolean` | Note present | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INV_NR` | `string(12)` | Document/invoice number | ☐ | | | `IS_EURO` | `boolean` | Payment in euros | ☐ | | | `IT_ORIGD_E` | `int64` | Original amount in euros | ☐ | | | `IT_PAID_EU` | `int64` | Paid in euros | ☐ | | | `ITEM_AGE` | `decimal` | Number of days open | ☐ | | | `ITEM_BAL` | `int64` | Open amount | ☐ | | | `ITEM_BAL_E` | `int64` | Open amount in euros | ☐ | | | `ITEM_BALC` | `int64` | Open amount (credit) | ☐ | | | `ITEM_CAMT` | `int64` | Currency amount | ☐ | | | `ITEM_CAMTC` | `int64` | Currency amount (payment) | ☐ | | | `ITEM_CAMTD` | `int64` | Currency amount (receipt) | ☐ | | | `ITEM_CPAYI` | `int64` | Currency amount including interest/costs | ☐ | | | `ITEM_DSCDT` | `datetime` | Discount due date | ☐ | | | `ITEM_EXPDS` | `decimal` | Number of days overdue | ☐ | | | `ITEM_EXPDT` | `datetime` | Due date | ☐ | | | `ITEM_EXPPG` | `decimal` | Number of days overdue (negative number of days) | ☐ | | | `ITEM_ORIGC` | `int64` | Original amount (credit) | ☐ | | | `ITEM_ORIGD` | `int64` | Original amount | ☐ | | | `ITEM_PAID` | `int64` | Paid | ☐ | | | `ITEM_PAYC` | `int64` | Amount after discount (credit) | ☐ | | | `ITEM_PAYD` | `int64` | Amount after discount | ☐ | | | `ITEM_PAYI` | `int64` | Amount including interest/costs | ☐ | | | `ITEM_PDPG` | `int64` | Payment discount amount (direct debit) | ☐ | | | `ITEM_PROC` | `boolean` | Processed | ☐ | | | `ITEM_REC` | `int64` | Amount receivable | ☐ | | | `ITEM_REST` | `int64` | Remaining amount | ☐ | | | `MAND_B2B` | `boolean` | Direct debit type: business | ☐ | | | `MAND_DATE` | `datetime` | Signature date | ☐ | | | `MAND_ID` | `string(35)` | Direct debit mandate reference | ☐ | | | `MAND_SEQ` | `int32` | Direct debit mandate | ☐ | | | `MARK_DD` | `boolean` | Marked for direct debit | ☐ | | | `MARK_PG` | `boolean` | Marked for payment | ☐ | | | `OI_STAT` | `decimal` | Approval status | ☐ | | | `PAGE_NR` | `string(10)` | Page number | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PAY_COLL` | `boolean` | Item handed over | ☐ | | | `PAY_DESC` | `string(130)` | Payment reference | ☐ | | | `PAY_ID` | `string(10)` | Payment file code | ☐ | | | `PAY_PROM` | `datetime` | Promised payment date | ☐ | | | `PD_AMT` | `int64` | Payment discount amount | ☐ | | | `PD_PCT` | `decimal` | Payment discount percentage | ☐ | | | `PG_BLK` | `boolean` | Blocked for automatic payment | ☐ | | | `PMT_AMT` | `decimal` | Amount payable FC | ☐ | | | `PMT_AMTN` | `decimal` | Amount payable FC (-) | ☐ | | | `PMT_ARTS` | `string(2)` | Item number for transit | ☐ | | | `PMT_CHQ` | `boolean` | Payment by cheque | ☐ | | | `PMT_CRECV` | `boolean` | All bank charges for account of beneficiary | ☐ | | | `PMT_CSEND` | `boolean` | Charges of other banks for account of principal | ☐ | | | `PMT_CURR` | `string(3)` | Payment currency code | ☐ | | | `PMT_DESC` | `string(80)` | Description for DNB | ☐ | | | `PMT_FAST` | `boolean` | Urgent foreign payment | ☐ | | | `PMT_GOODS` | `string(2)` | Goods code | ☐ | | | `PMT_ORD1` | `string(2)` | Payment instruction code 1 | ☐ | | | `PMT_ORD2` | `string(2)` | Payment instruction code 2 | ☐ | | | `PMT_ORD3` | `string(2)` | Payment instruction code 3 | ☐ | | | `PMT_ORD4` | `string(2)` | Payment instruction code 4 | ☐ | | | `PMT_TYPE` | `string(2)` | Foreign exchange reporting | ☐ | | | `POST_TYPE` | `decimal` | Write-off code | ☐ | | | `PROJ_CODE` | `string(10)` | Project code | ☐ | | | `REM_BLK` | `boolean` | Blocked for reminders | ☐ | | | `REM_CNT` | `decimal` | Number of times reminded | ☐ | | | `REM_DATE` | `datetime` | Date of last reminder | ☐ | | | `REM_DAYS` | `decimal` | Number of days since last reminder | ☐ | | | `SUB_NR` | `string(10)` | Customer/supplier number | ☐ | | | `SUM_BAL_EU` | `int64` | Overdue outstanding amount in euros | ☐ | | | `SUM_IT_BAL` | `int64` | Overdue outstanding amount | ☐ | | | `TO_PAY` | `int64` | To be paid | ☐ | | | `TRANSPORT` | `string(16)` | Carried-forward amount | ☐ | | | `TRN_DATE` | `datetime` | Invoice date | ☐ | | | `TRN_DESC` | `string(40)` | Invoice description | ☐ | |