invantive documentation
Forum di supporto InvantiveAccedi / Registrati

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_NAME varchar2(40) Nome della ditta
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