PROJECTS: AccountView Projects
read only per partition
- Catalogus:
AccountView - Label: Projects
Kan alleen gegevens ophalen.
Tabelkolommen
De kolommen van de tabel PROJECTS worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ACCT_ |
varchar2 |
Bedrijfsnaam | |||
ACT_ |
int64 |
Werkelijke kosten | |||
ACT_ |
int64 |
Difference costs/revenues | |||
ACT_ |
int64 |
Werkelijke inkomsten | |||
ADV_ |
int64 |
Advance amount | |||
BB_ |
decimal |
Year-end processing | |||
BEG_ |
datetime |
Project start date | |||
BEG_ |
int32 |
Start period | |||
BLK_ |
decimal |
G-accountpercentage | |||
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 |
Datum van wijziging | |||
CNG_NR |
int32 |
Nummer wijzigen | |||
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 |
Datum van inschrijving | |||
INP_ |
varchar2 |
Entered by employee | |||
INV_ |
int64 |
Invoiced amount | |||
INV_ |
varchar2 |
Billing method | |||
LB_PCT |
decimal |
Procentueel tarief van de loonbelasting | |||
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 |
Projectcode | |||
PROJ_ |
varchar2 |
Project description | |||
PROJ_ |
varchar2 |
Projecttype | |||
REL_ |
int64 |
Realised budget costs | |||
REL_ |
int64 |
Realised budget revenues | |||
REQ_ |
datetime |
Request date | |||
SELL_ |
int64 |
Te factureren bedrag | |||
SUB_NR |
varchar2 |
Klant-/leveranciersnummer | |||
TYPE_ |
varchar2 |
Project type description | |||
USE_ |
char |
Apply percentages below |