---
title: "PROJECTS (AccountView)"
description: "Projects"
language: fr
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/fr/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/fr/
---

# PROJECTS: AccountView Projects

`read only` `per partition`

- Catalogue : `AccountView`
- Label: Projects

Permet uniquement de récupérer des données.

## Colonnes de table

Les colonnes de la table `PROJECTS` sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ACCT_NAME` | `varchar2(40)` | Nom de l'entreprise | [ ] |  |  |
| `ACT_COST` | `int64` | Coûts réels | [ ] |  |  |
| `ACT_DIFF` | `int64` | Difference costs/revenues | [ ] |  |  |
| `ACT_PROC` | `int64` | Chiffre d'affaires réel | [ ] |  |  |
| `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` | Pourcentage du compte G | [ ] |  |  |
| `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` | Pourcentage de l'UWV | [ ] |  |  |
| `CALC_NOTE` | `varchar2(4)` | Project calculation note | [ ] |  |  |
| `CNG_DATE` | `datetime` | Date de modification | [ ] |  |  |
| `CNG_NR` | `int32` | Modifier le numéro | [ ] |  |  |
| `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` | Date d'inscription | [ ] |  |  |
| `INP_USR` | `varchar2(20)` | Entered by employee | [ ] |  |  |
| `INV_AMT` | `int64` | Invoiced amount | [ ] |  |  |
| `INV_METH` | `varchar2(10)` | Billing method | [ ] |  |  |
| `LB_PCT` | `decimal` | Taux de la charge sociale | [ ] |  |  |
| `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)` | Code du projet | [ ] |  |  |
| `PROJ_DESC` | `varchar2(40)` | Project description | [ ] |  |  |
| `PROJ_TYPE` | `varchar2(10)` | Type de projet | [ ] |  |  |
| `REL_COST` | `int64` | Realised budget costs | [ ] |  |  |
| `REL_PROC` | `int64` | Realised budget revenues | [ ] |  |  |
| `REQ_DATE` | `datetime` | Request date | [ ] |  |  |
| `SELL_AMT` | `int64` | Montant à facturer | [ ] |  |  |
| `SUB_NR` | `varchar2(10)` | Numéro de client/fournisseur | [ ] |  |  |
| `TYPE_DESC` | `varchar2(40)` | Project type description | [ ] |  |  |
| `USE_PCT` | `char` | Apply percentages below | [ ] |  |  |
