PJ_LINE: AccountView Project journal
read only per partition
- Catalogus:
AccountView - Label: Project journal
Kan alleen gegevens ophalen.
Tabelkolommen
De kolommen van de tabel PJ_LINE 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_ |
int64 |
Werkelijke kosten | |||
ACT_ |
decimal |
Actual quantity revenues | |||
ACT_ |
int64 |
Werkelijke inkomsten | |||
ACT_ |
decimal |
Actual quantity costs | |||
ADV_ |
int64 |
Advance amount | |||
ADV_ |
decimal |
Advance quantity | |||
AG_ |
varchar2 |
Item group | |||
ART_ |
varchar2 |
Artikelcode | |||
BUD_ |
int64 |
Budget costs | |||
BUD_ |
int64 |
Budget revenues | |||
CANC_ |
int64 |
Cancelled amount | |||
CANC_ |
decimal |
Cancelled quantity | |||
COBLI_ |
int64 |
Commitments amount costs | |||
COBLI_ |
decimal |
Commitments quantity costs | |||
COGS_ |
int64 |
Kostprijs | |||
COGS_ |
decimal |
Aantal tegen kostprijs | |||
COST_ |
varchar2 |
Cost centre code | |||
CST_ |
int64 |
Boekingsbedrag | |||
CST_ |
decimal |
Quantity posted | |||
DECL_ |
int64 |
Factureerbaar bedrag | |||
DECL_ |
decimal |
Billable quantity | |||
DIM_ |
varchar2 |
Dimensions description | |||
DPT_ |
varchar2 |
Department | |||
EMP_ |
varchar2 |
Employee group | |||
EMP_NR |
varchar2 |
Employee code | |||
EXTC_ |
int64 |
Cost price at external rate | |||
INV_ |
int64 |
Invoiced amount | |||
INV_ |
varchar2 |
Transaction invoice description | |||
INV_ |
decimal |
Invoiced quantity | |||
ITEM_ |
varchar2 |
Transaction description | |||
JOUR_ |
varchar2 |
Account number (journal) | |||
JOUR_ |
int64 |
Amount (journal) | |||
JOUR_ |
varchar2 |
Cost type (journal) | |||
JOUR_ |
int32 |
Period (journal) | |||
JOUR_ |
decimal |
Quantity (journal) | |||
LINK_ |
varchar2 |
Link to details | |||
OBLI_ |
varchar2 |
Commitment number | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
PC_DIM |
varchar2 |
Kostensoort als dimensie | |||
PER_ |
decimal |
Financial period | |||
PER_ |
varchar2 |
Period (journal) | |||
PER_ |
decimal |
Projectperiode | |||
POBLI_ |
int64 |
Commitments amount revenues | |||
POBLI_ |
decimal |
Commitments quantity revenues | |||
PRF_ |
int64 |
Actual costs incl. profit surcharge | |||
PROC_ |
int32 |
Originating process | |||
PROF_ |
int64 |
Amount released (project result) | |||
PROF_ |
decimal |
Quantity released (project result) | |||
PROJ_ |
varchar2 |
Project attributes | |||
PROJ_ |
varchar2 |
Projectcode | |||
RAPP_ |
varchar2 |
Reporting year | |||
REC_ID |
varchar2 |
Unieke code | |||
RES_ID |
varchar2 |
Identificatie van de bron | |||
RES_ |
int32 |
Bronsoort | |||
SELL_ |
int64 |
Te factureren bedrag | |||
SELL_ |
decimal |
Te factureren hoeveelheid | |||
SRC_ |
varchar2 |
Account number (source) | |||
SRC_PC |
varchar2 |
Cost type (source) | |||
SRC_ |
int32 |
Period (source) | |||
STR_ |
varchar2 |
Hour type/item code/cost type | |||
STR_ |
varchar2 |
Hour type group/item code/cost type | |||
STR_ |
varchar2 |
Hour type/item group/cost type | |||
STR_ |
varchar2 |
Hour type group/item group/cost type | |||
TG_ |
varchar2 |
Hour type group | |||
TIM_ |
varchar2 |
Hour type | |||
TRANS_ |
int64 |
Transferred amount | |||
TRANS_ |
int32 |
Number of item transactions | |||
TRANS_ |
int32 |
Number of item transactions history | |||
TRANS_ |
int32 |
Number of billing transactions | |||
TRANS_ |
int32 |
Number of billing transactions history | |||
TRANS_ |
int32 |
Number of project transfer transactions | |||
TRANS_ |
int32 |
Number of project transfer transactions history | |||
TRANS_ |
decimal |
Transferred quantity | |||
TRANS_ |
int32 |
Number of hours transactions | |||
TRANS_ |
int32 |
Number of hours transactions history | |||
TRANS_ |
int32 |
Number of financial transactions | |||
TRANS_ |
int32 |
Number of financial transactions history | |||
TRN_ |
datetime |
Transactiedatum | |||
TRN_ |
int32 |
Transaction type | |||
WIP_ |
int64 |
Open amount | |||
WIP_ |
decimal |
Open quantity | |||
WIPJR_ |
int64 |
Work in progress amount | |||
WIPJR_ |
decimal |
Work in progress quantity | |||
WRK_ |
varchar2 |
Work type |