PROJECTS: AccountView Projects
read only per partition
- Catalogo:
AccountView - Label: Projects
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella PROJECTS. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ACCT_ |
varchar2 |
Nome della ditta | |||
ACT_ |
int64 |
Actual costs | |||
ACT_ |
int64 |
Difference costs/revenues | |||
ACT_ |
int64 |
Actual revenues | |||
ADV_ |
int64 |
Advance amount | |||
BB_ |
decimal |
Year-end processing | |||
BEG_ |
datetime |
Project start date | |||
BEG_ |
int32 |
Start period | |||
BLK_ |
decimal |
G-account percentage | |||
BMA_ |
int64 |
Budget variance costs | |||
BMA_ |
int64 |
Budget variance revenues | |||
BUD_ |
int64 |
Budget costs | |||
BUD_ |
int64 |
Budget revenues | |||
BV_PCT |
decimal |
UWV percentage | |||
CALC_ |
varchar2 |
Project calculation note | |||
CNG_ |
datetime |
Date modified | |||
CNG_NR |
int32 |
Change number | |||
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 |
Entry date | |||
INP_ |
varchar2 |
Entered by employee | |||
INV_ |
int64 |
Invoiced amount | |||
INV_ |
varchar2 |
Billing method | |||
LB_PCT |
decimal |
Payroll tax percentage | |||
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 |
Project code | |||
PROJ_ |
varchar2 |
Project description | |||
PROJ_ |
varchar2 |
Project type | |||
REL_ |
int64 |
Realised budget costs | |||
REL_ |
int64 |
Realised budget revenues | |||
REQ_ |
datetime |
Request date | |||
SELL_ |
int64 |
Amount to be invoiced | |||
SUB_NR |
varchar2 |
Customer/supplier number | |||
TYPE_ |
varchar2 |
Project type description | |||
USE_ |
char |
Apply percentages below |