invantive documentation
Invantive SupportforenAnmelden / Eintragen

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_NAME varchar2(40) Firmennamen
ACT_COST int64 Actual costs
ACT_DIFF int64 Difference costs/revenues
ACT_PROC int64 Actual revenues
ADV_AMT int64 Advance amount
BB_TYPE decimal Year-end processing
BEG_DATE datetime Project start date
BEG_PER int32 Start period
BLK_PCT decimal G-account percentage
BMA_COST int64 Budget variance costs
BMA_PROC int64 Budget variance revenues
BUD_COST int64 Budget costs
BUD_PROC int64 Budget revenues
BV_PCT decimal UWV percentage
CALC_NOTE varchar2(4) Project calculation note
CNG_DATE datetime Date modified
CNG_NR int32 Change number
CNG_USR varchar2(20) Employee last modified
COBLI_AMT int64 Commitments amount costs
COMMENT varchar2(4) Note
COST_OBLI int64 Actual costs excluding commitments
DTS_CALC varchar2(14) Date/time
EMP_NAME varchar2(40) Project manager full name
EMP_NR varchar2(10) Project manager
END_DATE datetime Project end date
END_PER int32 End period
EXT_DESC varchar2(40) External description
FIN_DATE datetime Date financially closed
INP_DATE datetime Entry date
INP_USR varchar2(20) Entered by employee
INV_AMT int64 Invoiced amount
INV_METH varchar2(10) Billing method
LB_PCT decimal Payroll tax percentage
MIN_INV int64 Minimum invoice amount
OMA_COST int64 Budget variance costs incl. commitments
OMA_PROC int64 Budget variance revenues incl. commitments
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PCT_FIN float Project percentage complete
PCT_WIP float % complete financial
PER_PJC decimal Last recalculated period
PG_CODE varchar2(10) Project group
PG_DESC varchar2(40) Project group description
POBLI_AMT int64 Commitments amount revenues
PP_NAME varchar2(40) Client contact
PRO_STAT decimal Project status
PROC_OBLI int64 Actual revenues excluding commitments
PROJ_CODE varchar2(10) Project code
PROJ_DESC varchar2(40) Project description
PROJ_TYPE varchar2(10) Project type
REL_COST int64 Realised budget costs
REL_PROC int64 Realised budget revenues
REQ_DATE datetime Request date
SELL_AMT int64 Amount to be invoiced
SUB_NR varchar2(10) Customer/supplier number
TYPE_DESC varchar2(40) Project type description
USE_PCT char Apply percentages below