invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

PJ_CARD: AccountView Project card

read only per partition

  • Catalogus: AccountView
  • Label: Project card

Kan alleen gegevens ophalen.

Tabelkolommen

De kolommen van de tabel PJ_CARD 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
ACT_COST int64 Werkelijke kosten
ACT_DIFF int64 Difference costs/revenues
ACT_P_QTY decimal Actual quantity revenues
ACT_PROC int64 Werkelijke inkomsten
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) Artikelcode
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 Boekingsbedrag
CST_QTY decimal Quantity posted
DECL_AMT int64 Factureerbaar bedrag
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) Kostensoort als dimensie
PCT_FIN decimal Percentage complete
PER_FIN decimal Financial period
PER_PROJ decimal Projectperiode
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) Projectcode
RAPP_YEAR varchar2(10) Reporting year
REC_ID varchar2(10) Unieke code
REL_COST int64 Realised budget costs
REL_PROC int64 Realised budget revenues
REL_QTY decimal Realised budget quantity
RES_ID varchar2(12) Identificatie van de bron
RES_TYPE int32 Bronsoort
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 Te factureren bedrag
SELL_QTY decimal Te factureren hoeveelheid
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 Transactiedatum
WIP_AMT int64 Open amount
WIP_QTY decimal Open quantity
WRK_CODE varchar2(10) Work type