PROJECTS: AccountView Projects
read only per partition
- Katalog:
AccountView - Label: Projects
Es können nur Daten abgerufen werden.
Tabellenspalten
Die Spalten der Tabelle PROJECTS sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ACCT_ |
varchar2 |
Firmennamen | |||
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 |