PJ_CARD: AccountView Project card
read only per partition
- Catalog:
AccountView - Label: Project card
Can only retrieve data.
Table Columns
The columns of the table PJ_CARD are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ACT_ |
int64 |
Actual costs | |||
ACT_ |
int64 |
Difference costs/revenues | |||
ACT_ |
decimal |
Actual quantity revenues | |||
ACT_ |
int64 |
Actual revenues | |||
ACT_ |
decimal |
Actual quantity costs | |||
ADV_ |
int64 |
Advance amount | |||
ADV_ |
decimal |
Advance quantity | |||
AG_ |
varchar2 |
Item group | |||
ART_ |
varchar2 |
Article Code | |||
BMA_ |
int64 |
Budget variance costs | |||
BMA_ |
int64 |
Budget variance revenues | |||
BMA_ |
decimal |
Budget variance quantity | |||
BPA_ |
decimal |
Budget percentage variance costs | |||
BPA_ |
decimal |
Budget percentage variance revenues | |||
BPA_ |
decimal |
Budget percentage variance quantities | |||
BUD_ |
int64 |
Budget costs | |||
BUD_ |
int64 |
Budget revenues | |||
BUD_ |
decimal |
Budget quantity | |||
CANC_ |
int64 |
Cancelled amount | |||
CANC_ |
decimal |
Cancelled quantity | |||
COBLI_ |
int64 |
Commitments amount costs | |||
COBLI_ |
decimal |
Commitments quantity costs | |||
COST_ |
varchar2 |
Cost centre code | |||
COST_ |
int64 |
Actual costs excluding commitments | |||
CST_ |
int64 |
Amount posted | |||
CST_ |
decimal |
Quantity posted | |||
DECL_ |
int64 |
Chargeable amount | |||
DECL_ |
decimal |
Billable quantity | |||
DIM_ |
varchar2 |
Dimensions description | |||
DPT_ |
varchar2 |
Department | |||
EMP_ |
varchar2 |
Employee group | |||
EMP_NR |
varchar2 |
Employee code | |||
INV_ |
int64 |
Invoiced amount | |||
INV_ |
decimal |
Invoiced quantity | |||
OMA_ |
int64 |
Budget variance costs incl. commitments | |||
OMA_ |
int64 |
Budget variance revenues incl. commitments | |||
OPA_ |
decimal |
Budget % costs incl. commitments | |||
OPA_ |
decimal |
Budget % revenues incl. commitments | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
PC_DIM |
varchar2 |
Cost type as dimension | |||
PCT_ |
decimal |
Percentage complete | |||
PER_ |
decimal |
Financial period | |||
PER_ |
decimal |
Project period | |||
PG_ |
varchar2 |
Project group | |||
POBLI_ |
int64 |
Commitments amount revenues | |||
POBLI_ |
decimal |
Commitments quantity revenues | |||
PRF_ |
int64 |
Actual costs incl. profit surcharge | |||
PROC_ |
int64 |
Actual revenues excluding commitments | |||
PROJ_ |
varchar2 |
Project code | |||
RAPP_ |
varchar2 |
Reporting year | |||
REC_ID |
varchar2 |
Unique code | |||
REL_ |
int64 |
Realised budget costs | |||
REL_ |
int64 |
Realised budget revenues | |||
REL_ |
decimal |
Realised budget quantity | |||
RES_ID |
varchar2 |
Source identification | |||
RES_ |
int32 |
Source type | |||
RMA_ |
int64 |
Budget variance realised costs | |||
RMA_ |
int64 |
Budget variance realised revenues | |||
RMA_ |
decimal |
Budget variance realised quantity | |||
RPA_ |
decimal |
Budget percentage realised costs | |||
RPA_ |
decimal |
Budget percentage realised revenues | |||
RPA_ |
decimal |
Budget percentage realised quantity | |||
SELL_ |
int64 |
Amount to be invoiced | |||
SELL_ |
decimal |
Quantity to be invoiced | |||
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 code | |||
TIM_ |
varchar2 |
Hour type code | |||
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 |
Transaction Date | |||
WIP_ |
int64 |
Open amount | |||
WIP_ |
decimal |
Open quantity | |||
WRK_ |
varchar2 |
Work type |