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

# PROJECTS: AccountView Projects

`read only` `per partition`

- Catalogus: `AccountView`
- Label: Projects

Kan alleen gegevens ophalen.

## Tabelkolommen

De kolommen van de tabel `PROJECTS` worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ACCT_NAME` | `varchar2(40)` | Bedrijfsnaam | [ ] |  |  |
| `ACT_COST` | `int64` | Werkelijke kosten | [ ] |  |  |
| `ACT_DIFF` | `int64` | Difference costs/revenues | [ ] |  |  |
| `ACT_PROC` | `int64` | Werkelijke inkomsten | [ ] |  |  |
| `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-accountpercentage | [ ] |  |  |
| `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` | Datum van wijziging | [ ] |  |  |
| `CNG_NR` | `int32` | Nummer wijzigen | [ ] |  |  |
| `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` | Datum van inschrijving | [ ] |  |  |
| `INP_USR` | `varchar2(20)` | Entered by employee | [ ] |  |  |
| `INV_AMT` | `int64` | Invoiced amount | [ ] |  |  |
| `INV_METH` | `varchar2(10)` | Billing method | [ ] |  |  |
| `LB_PCT` | `decimal` | Procentueel tarief van de loonbelasting | [ ] |  |  |
| `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)` | Projectcode | [ ] |  |  |
| `PROJ_DESC` | `varchar2(40)` | Project description | [ ] |  |  |
| `PROJ_TYPE` | `varchar2(10)` | Projecttype | [ ] |  |  |
| `REL_COST` | `int64` | Realised budget costs | [ ] |  |  |
| `REL_PROC` | `int64` | Realised budget revenues | [ ] |  |  |
| `REQ_DATE` | `datetime` | Request date | [ ] |  |  |
| `SELL_AMT` | `int64` | Te factureren bedrag | [ ] |  |  |
| `SUB_NR` | `varchar2(10)` | Klant-/leveranciersnummer | [ ] |  |  |
| `TYPE_DESC` | `varchar2(40)` | Project type description | [ ] |  |  |
| `USE_PCT` | `char` | Apply percentages below | [ ] |  |  |
