PROJECTS: AccountView Projects
read only per partition
- Catálogo:
AccountView - Label: Projects
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla PROJECTS. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ACCT_ |
varchar2 |
Nombre de empresa | |||
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 |