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_ |
varchar2 |
Nom de l'entreprise | |||
ACT_ |
int64 |
Coûts réels | |||
ACT_ |
int64 |
Difference costs/revenues | |||
ACT_ |
int64 |
Chiffre d'affaires réel | |||
ADV_ |
int64 |
Advance amount | |||
BB_ |
decimal |
Year-end processing | |||
BEG_ |
datetime |
Project start date | |||
BEG_ |
int32 |
Start period | |||
BLK_ |
decimal |
Pourcentage du compte G | |||
BMA_ |
int64 |
Budget variance costs | |||
BMA_ |
int64 |
Budget variance revenues | |||
BUD_ |
int64 |
Budget costs | |||
BUD_ |
int64 |
Budget revenues | |||
BV_PCT |
decimal |
Pourcentage de l'UWV | |||
CALC_ |
varchar2 |
Project calculation note | |||
CNG_ |
datetime |
Date de modification | |||
CNG_NR |
int32 |
Modifier le numéro | |||
CNG_ |
varchar2 |
Employee last modified | |||
COBLI_ |
int64 |
Commitments amount costs | |||
COMMENT |
varchar2 |
Note | |||
COST_ |
int64 |
Actual costs excluding commitments | |||
DTS_ |
varchar2 |
Date/time | |||
EMP_ |
varchar2 |
Project manager full name | |||
EMP_NR |
varchar2 |
Project manager | |||
END_ |
datetime |
Project end date | |||
END_ |
int32 |
End period | |||
EXT_ |
varchar2 |
External description | |||
FIN_ |
datetime |
Date financially closed | |||
INP_ |
datetime |
Date d'inscription | |||
INP_ |
varchar2 |
Entered by employee | |||
INV_ |
int64 |
Invoiced amount | |||
INV_ |
varchar2 |
Billing method | |||
LB_PCT |
decimal |
Taux de la charge sociale | |||
MIN_ |
int64 |
Minimum invoice amount | |||
OMA_ |
int64 |
Budget variance costs incl. commitments | |||
OMA_ |
int64 |
Budget variance revenues incl. commitments | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
PCT_ |
float |
Project percentage complete | |||
PCT_ |
float |
% complete financial | |||
PER_ |
decimal |
Last recalculated period | |||
PG_ |
varchar2 |
Project group | |||
PG_ |
varchar2 |
Project group description | |||
POBLI_ |
int64 |
Commitments amount revenues | |||
PP_ |
varchar2 |
Client contact | |||
PRO_ |
decimal |
Project status | |||
PROC_ |
int64 |
Actual revenues excluding commitments | |||
PROJ_ |
varchar2 |
Code du projet | |||
PROJ_ |
varchar2 |
Project description | |||
PROJ_ |
varchar2 |
Type de projet | |||
REL_ |
int64 |
Realised budget costs | |||
REL_ |
int64 |
Realised budget revenues | |||
REQ_ |
datetime |
Request date | |||
SELL_ |
int64 |
Montant à facturer | |||
SUB_NR |
varchar2 |
Numéro de client/fournisseur | |||
TYPE_ |
varchar2 |
Project type description | |||
USE_ |
char |
Apply percentages below |