---
title: "PROJECTS (AccountView)"
description: "Projects"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/vismaaccountview/AccountView..PROJECTS
original: https://documentation.invantive.eu/en/datamodels/vismaaccountview/AccountView..PROJECTS
updated: 2026-11-16T21:14:40Z
license: https://documentation.invantive.eu/en/
---

# PROJECTS: AccountView Projects

`read only` `per partition`

- Catalog: `AccountView`
- Label: Projects

Can only retrieve data.

## Table Columns

The columns of the table `PROJECTS` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ACCT_NAME` | `varchar2(40)` | Company name | [ ] |  |  |
| `ACT_COST` | `int64` | Actual costs | [ ] |  |  |
| `ACT_DIFF` | `int64` | Difference costs/revenues | [ ] |  |  |
| `ACT_PROC` | `int64` | Actual revenues | [ ] |  |  |
| `ADV_AMT` | `int64` | Advance amount | [ ] |  |  |
| `BB_TYPE` | `decimal` | Year-end processing | [ ] |  |  |
| `BEG_DATE` | `datetime` | Project start date | [ ] |  |  |
| `BEG_PER` | `int32` | Start period | [ ] |  |  |
| `BLK_PCT` | `decimal` | G-account percentage | [ ] |  |  |
| `BMA_COST` | `int64` | Budget variance costs | [ ] |  |  |
| `BMA_PROC` | `int64` | Budget variance revenues | [ ] |  |  |
| `BUD_COST` | `int64` | Budget costs | [ ] |  |  |
| `BUD_PROC` | `int64` | Budget revenues | [ ] |  |  |
| `BV_PCT` | `decimal` | UWV percentage | [ ] |  |  |
| `CALC_NOTE` | `varchar2(4)` | Project calculation note | [ ] |  |  |
| `CNG_DATE` | `datetime` | Date modified | [ ] |  |  |
| `CNG_NR` | `int32` | Change number | [ ] |  |  |
| `CNG_USR` | `varchar2(20)` | Employee last modified | [ ] |  |  |
| `COBLI_AMT` | `int64` | Commitments amount costs | [ ] |  |  |
| `COMMENT` | `varchar2(4)` | Note | [ ] |  |  |
| `COST_OBLI` | `int64` | Actual costs excluding commitments | [ ] |  |  |
| `DTS_CALC` | `varchar2(14)` | Date/time | [ ] |  |  |
| `EMP_NAME` | `varchar2(40)` | Project manager full name | [ ] |  |  |
| `EMP_NR` | `varchar2(10)` | Project manager | [ ] |  |  |
| `END_DATE` | `datetime` | Project end date | [ ] |  |  |
| `END_PER` | `int32` | End period | [ ] |  |  |
| `EXT_DESC` | `varchar2(40)` | External description | [ ] |  |  |
| `FIN_DATE` | `datetime` | Date financially closed | [ ] |  |  |
| `INP_DATE` | `datetime` | Entry date | [ ] |  |  |
| `INP_USR` | `varchar2(20)` | Entered by employee | [ ] |  |  |
| `INV_AMT` | `int64` | Invoiced amount | [ ] |  |  |
| `INV_METH` | `varchar2(10)` | Billing method | [ ] |  |  |
| `LB_PCT` | `decimal` | Payroll tax percentage | [ ] |  |  |
| `MIN_INV` | `int64` | Minimum invoice amount | [ ] |  |  |
| `OMA_COST` | `int64` | Budget variance costs incl. commitments | [ ] |  |  |
| `OMA_PROC` | `int64` | Budget variance revenues incl. commitments | [ ] |  |  |
| `partition_code` | `varchar2` | Partition code | [x] |  |  |
| `partition_name` | `varchar2` | Partition name | [x] |  |  |
| `PCT_FIN` | `float` | Project percentage complete | [ ] |  |  |
| `PCT_WIP` | `float` | % complete financial | [ ] |  |  |
| `PER_PJC` | `decimal` | Last recalculated period | [ ] |  |  |
| `PG_CODE` | `varchar2(10)` | Project group | [ ] |  |  |
| `PG_DESC` | `varchar2(40)` | Project group description | [ ] |  |  |
| `POBLI_AMT` | `int64` | Commitments amount revenues | [ ] |  |  |
| `PP_NAME` | `varchar2(40)` | Client contact | [ ] |  |  |
| `PRO_STAT` | `decimal` | Project status | [ ] |  |  |
| `PROC_OBLI` | `int64` | Actual revenues excluding commitments | [ ] |  |  |
| `PROJ_CODE` | `varchar2(10)` | Project code | [ ] |  |  |
| `PROJ_DESC` | `varchar2(40)` | Project description | [ ] |  |  |
| `PROJ_TYPE` | `varchar2(10)` | Project type | [ ] |  |  |
| `REL_COST` | `int64` | Realised budget costs | [ ] |  |  |
| `REL_PROC` | `int64` | Realised budget revenues | [ ] |  |  |
| `REQ_DATE` | `datetime` | Request date | [ ] |  |  |
| `SELL_AMT` | `int64` | Amount to be invoiced | [ ] |  |  |
| `SUB_NR` | `varchar2(10)` | Customer/supplier number | [ ] |  |  |
| `TYPE_DESC` | `varchar2(40)` | Project type description | [ ] |  |  |
| `USE_PCT` | `char` | Apply percentages below | [ ] |  |  |

