invantive documentation
Forum di supporto InvantiveAccedi / Registrati

PJ_CARD: AccountView Project card

read only per partition

  • Catalogo: AccountView
  • Label: Project card

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella PJ_CARD. 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
ACT_COST int64 Actual costs
ACT_DIFF int64 Difference costs/revenues
ACT_P_QTY decimal Actual quantity revenues
ACT_PROC int64 Actual revenues
ACT_QTY decimal Actual quantity costs
ADV_AMT int64 Advance amount
ADV_QTY decimal Advance quantity
AG_CODE varchar2(5) Item group
ART_CODE varchar2(15) Codice articolo
BMA_COST int64 Budget variance costs
BMA_PROC int64 Budget variance revenues
BMA_QTY decimal Budget variance quantity
BPA_COST decimal Budget percentage variance costs
BPA_PROC decimal Budget percentage variance revenues
BPA_QTY decimal Budget percentage variance quantities
BUD_COST int64 Budget costs
BUD_PROC int64 Budget revenues
BUD_QTY decimal Budget quantity
CANC_AMT int64 Cancelled amount
CANC_QTY decimal Cancelled quantity
COBLI_AMT int64 Commitments amount costs
COBLI_QTY decimal Commitments quantity costs
COST_CODE varchar2(10) Cost centre code
COST_OBLI int64 Actual costs excluding commitments
CST_AMT int64 Amount posted
CST_QTY decimal Quantity posted
DECL_AMT int64 Chargeable amount
DECL_QTY decimal Billable quantity
DIM_DESC varchar2(200) Dimensions description
DPT_CODE varchar2(10) Department
EMP_GRP varchar2(10) Employee group
EMP_NR varchar2(10) Employee code
INV_AMT int64 Invoiced amount
INV_QTY decimal Invoiced quantity
OMA_COST int64 Budget variance costs incl. commitments
OMA_PROC int64 Budget variance revenues incl. commitments
OPA_COST decimal Budget % costs incl. commitments
OPA_PROC decimal Budget % revenues incl. commitments
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PC_DIM varchar2(5) Cost type as dimension
PCT_FIN decimal Percentage complete
PER_FIN decimal Financial period
PER_PROJ decimal Project period
PG_CODE varchar2(10) Project group
POBLI_AMT int64 Commitments amount revenues
POBLI_QTY decimal Commitments quantity revenues
PRF_PROC int64 Actual costs incl. profit surcharge
PROC_OBLI int64 Actual revenues excluding commitments
PROJ_CODE varchar2(10) Project code
RAPP_YEAR varchar2(10) Reporting year
REC_ID varchar2(10) Unique code
REL_COST int64 Realised budget costs
REL_PROC int64 Realised budget revenues
REL_QTY decimal Realised budget quantity
RES_ID varchar2(12) Source identification
RES_TYPE int32 Source type
RMA_COST int64 Budget variance realised costs
RMA_PROC int64 Budget variance realised revenues
RMA_QTY decimal Budget variance realised quantity
RPA_COST decimal Budget percentage realised costs
RPA_PROC decimal Budget percentage realised revenues
RPA_QTY decimal Budget percentage realised quantity
SELL_AMT int64 Amount to be invoiced
SELL_QTY decimal Quantity to be invoiced
STR_DETAIL varchar2(15) Hour type/item code/cost type
STR_DETGR1 varchar2(15) Hour type group/item code/cost type
STR_DETGR2 varchar2(10) Hour type/item group/cost type
STR_GROUP varchar2(10) Hour type group/item group/cost type
TG_CODE varchar2(10) Hour type group code
TIM_CODE varchar2(10) Hour type code
TRANS_AMT int64 Transferred amount
TRANS_ART int32 Number of item transactions
TRANS_ARTH int32 Number of item transactions history
TRANS_EXP int32 Number of billing transactions
TRANS_EXPH int32 Number of billing transactions history
TRANS_PJB int32 Number of project transfer transactions
TRANS_PJBH int32 Number of project transfer transactions history
TRANS_QTY decimal Transferred quantity
TRANS_TIM int32 Number of hours transactions
TRANS_TIMH int32 Number of hours transactions history
TRANS_TRN int32 Number of financial transactions
TRANS_TRNH int32 Number of financial transactions history
TRN_DATE datetime Data della transazione
WIP_AMT int64 Open amount
WIP_QTY decimal Open quantity
WRK_CODE varchar2(10) Work type