CRS_TRLB: AccountView Reporting
read only per partition
- Catálogo:
AccountView - Label: Reporting
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla CRS_TRLB. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ACCT_ |
varchar2 |
General ledger account | |||
BAL_ |
int64 |
Balance sheet CY credit | |||
BAL_ |
int64 |
Balance sheet PY credit | |||
BAL_ |
int64 |
Balance sheet CY debit | |||
BAL_ |
int64 |
Balance sheet PY debit | |||
BAL_ |
int64 |
Balance sheet CY | |||
BAL_ |
int64 |
Balance sheet PY | |||
BAL_ |
int64 |
Net balance sheet CY credit | |||
BAL_ |
int64 |
Net balance sheet CY debit | |||
BAL_ |
decimal |
Balance sheet CY qty | |||
BAL_ |
decimal |
Balance sheet PY qty | |||
BAL_ |
int64 |
Balance sheet CY - PY | |||
BAL_ |
decimal |
Balance sheet CY - PY qty | |||
BAL_ |
decimal |
Balance sheet CY - PY % | |||
BAL_ |
decimal |
Balance sheet CY - PY qty % | |||
BUD_ |
varchar2 |
Budget holder | |||
COR_ |
int64 |
Adjustment CY credit | |||
COR_ |
int64 |
Adjustments PY credit | |||
COR_ |
int64 |
Adjustments CY debit | |||
COR_ |
int64 |
Adjustments PY debit | |||
COR_ |
int64 |
Adjustment CY | |||
COR_ |
int64 |
Adjustments PY | |||
COR_ |
decimal |
Adjustments CY qty | |||
COR_ |
decimal |
Adjustments PY qty | |||
COR_ |
int64 |
Adjustments CY - PY | |||
COR_ |
decimal |
Adjustments CY - PY qty | |||
COR_ |
decimal |
Adjustments CY - PY % | |||
COR_ |
decimal |
Adjustments CY - PY qty % | |||
COST_ |
varchar2 |
Cost centre code | |||
DIM_ |
varchar2 |
Dimension key | |||
DSP_ |
varchar2 |
Line format | |||
FCT_ |
int64 |
Forecast CY | |||
FCT_ |
decimal |
Forecast CY qty | |||
FCT_ |
int64 |
Forecast CY - Budget Year-end CY | |||
FCT_ |
decimal |
Forecast CY - Budget Year-end CY qty | |||
FCT_ |
decimal |
Forecast CY - Budget Year-end CY % | |||
FCT_ |
decimal |
Forecast CY - Budget Year-end CY qty % | |||
INC_ |
int64 |
P&L CY credit | |||
INC_ |
int64 |
P&L PY credit | |||
INC_ |
int64 |
P&L CY debit | |||
INC_ |
int64 |
P&L PY debit | |||
INC_ |
int64 |
P&L CY | |||
INC_ |
int64 |
P&L PY | |||
INC_ |
int64 |
Net P&L CY credit | |||
INC_ |
int64 |
Net P&L CY debit | |||
INC_ |
decimal |
P&L CY qty | |||
INC_ |
decimal |
P&L PY qty | |||
INC_ |
int64 |
P&L CY - PY | |||
INC_ |
decimal |
P&L CY - PY qty | |||
INC_ |
decimal |
P&L CY - PY % | |||
INC_ |
decimal |
P&L CY - PY qty % | |||
IND_ |
int32 |
Indentation level | |||
LINE_ |
char |
Bold line | |||
LINE_ |
varchar2 |
Line description | |||
LINE_ |
int32 |
Level | |||
LINE_ |
int32 |
Line type | |||
MND_ |
int32 |
Months | |||
MUT_ |
int64 |
Movements CY credit | |||
MUT_ |
int64 |
Movements PY credit | |||
MUT_ |
int64 |
Movements CY debit | |||
MUT_ |
int64 |
Movements PY debit | |||
MUT_ |
int64 |
Movements CY | |||
MUT_ |
int64 |
Movements PY | |||
MUT_ |
decimal |
Movements CY qty | |||
MUT_ |
decimal |
Movements PY qty | |||
MUT_ |
int64 |
Movements CY - PY | |||
MUT_ |
decimal |
Movements CY - PY qty | |||
MUT_ |
decimal |
Movements CY - PY % | |||
MUT_ |
decimal |
Movements CY - PY qty % | |||
OPN_ |
int64 |
Opening balance CY credit | |||
OPN_ |
int64 |
Opening balance PY credit | |||
OPN_ |
int64 |
Opening balance CY debit | |||
OPN_ |
int64 |
Opening balance PY debit | |||
OPN_ |
int64 |
Opening balance CY | |||
OPN_ |
int64 |
Opening balance PY | |||
OPN_ |
decimal |
Opening balance CY qty | |||
OPN_ |
decimal |
Opening balance PY qty | |||
OPN_ |
int64 |
Opening balance CY credit net | |||
OPN_ |
int64 |
Opening balance CY debit net | |||
OPN_ |
int64 |
Opening balance CY - PY | |||
OPN_ |
decimal |
Opening balance CY - PY qty | |||
OPN_ |
decimal |
Opening balance CY - PY % | |||
OPN_ |
decimal |
Opening balance CY - PY qty % | |||
PA_ |
varchar2 |
Partner | |||
PAGE_ |
char |
Page break | |||
PARENT_ |
varchar2 |
Parent element | |||
PART_ |
varchar2 |
Partner as dimension | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
PC_ |
varchar2 |
Cost type | |||
PER_ |
int64 |
Period CY credit | |||
PER_ |
int64 |
Period PY credit | |||
PER_ |
int64 |
Period CY debit | |||
PER_ |
int64 |
Period PY debit | |||
PER_ |
int64 |
Period CY | |||
PER_ |
int64 |
Period PY | |||
PER_ |
decimal |
Period 100% CY | |||
PER_ |
decimal |
Period 100% PY | |||
PER_ |
int64 |
Net period CY credit | |||
PER_ |
int64 |
Net period CY debit | |||
PER_ |
decimal |
Period CY qty | |||
PER_ |
decimal |
Period PY qty | |||
PER_ |
decimal |
Period 100% CY qty | |||
PER_ |
decimal |
Period 100% PY qty | |||
PER_ |
int64 |
Budget period CY | |||
PER_ |
int64 |
Budget period PY | |||
PER_ |
int64 |
Budget period CY - PY | |||
PER_ |
decimal |
Budget period CY - PY % | |||
PER_ |
decimal |
Budget period CY qty | |||
PER_ |
decimal |
Budget period PY qty | |||
PER_ |
decimal |
Budget period CY - PY qty | |||
PER_ |
decimal |
Budget period CY - PY qty % | |||
PER_ |
int64 |
Period CY - Budget period CY | |||
PER_ |
int64 |
Period PY - Budget period PY | |||
PER_ |
int64 |
Period CY - PY | |||
PER_ |
decimal |
Period CY - Budget period CY qty | |||
PER_ |
decimal |
Period PY - Budget period PY qty | |||
PER_ |
decimal |
Period CY - PY qty | |||
PER_ |
decimal |
Period CY - Budget period CY % | |||
PER_ |
decimal |
Period PY - Budget period PY % | |||
PER_ |
decimal |
Period CY - PY % | |||
PER_ |
decimal |
Period CY - Budget period CY qty % | |||
PER_ |
decimal |
Period PY - Budget period PY qty % | |||
PER_ |
decimal |
Period CY - PY qty % | |||
PROJ_ |
varchar2 |
Project code | |||
QTR_ |
int32 |
Quarters | |||
REC_ID |
varchar2 |
Unique code | |||
REC_ |
varchar2 |
Source key | |||
RNG_ |
varchar2 |
Partner administration | |||
RST_ |
int64 |
Remaining budget CY | |||
RST_ |
decimal |
Remaining budget CY qty | |||
SHOW_ |
int32 |
Icon | |||
SHOW_ |
char |
Show total line | |||
SHOW_ |
char |
Show line | |||
TAX_ID |
varchar2 |
Element code | |||
TIL_ |
int64 |
Up to period CY credit | |||
TIL_ |
int64 |
Up to period PY credit | |||
TIL_ |
int64 |
Up to period CY debit | |||
TIL_ |
int64 |
Up to period PY debit | |||
TIL_ |
int64 |
Up to period CY | |||
TIL_ |
int64 |
Up to period PY | |||
TIL_ |
decimal |
Up to period 100% CY | |||
TIL_ |
decimal |
Up to period 100% PY | |||
TIL_ |
int64 |
Net up to period CY credit | |||
TIL_ |
int64 |
Net up to period PY credit | |||
TIL_ |
int64 |
Net up to period CY debit | |||
TIL_ |
int64 |
Net up to period PY debit | |||
TIL_ |
decimal |
Up to period CY qty | |||
TIL_ |
decimal |
Up to period PY qty | |||
TIL_ |
decimal |
Up to period 100% CY qty | |||
TIL_ |
decimal |
Up to period 100% PY qty | |||
TIL_ |
int64 |
Budget up to period CY | |||
TIL_ |
int64 |
Budget up to period PY | |||
TIL_ |
int64 |
Budget up to period CY - PY | |||
TIL_ |
decimal |
Budget up to period CY - PY % | |||
TIL_ |
decimal |
Budget up to period CY qty | |||
TIL_ |
decimal |
Budget up to period PY qty | |||
TIL_ |
decimal |
Budget up to period CY - PY qty | |||
TIL_ |
decimal |
Budget up to period CY - PY qty % | |||
TIL_ |
int64 |
Up to period CY - Budget up to period CY | |||
TIL_ |
int64 |
Up to period PY - Budget up to period PY | |||
TIL_ |
int64 |
Up to period CY - PY | |||
TIL_ |
decimal |
Up to period CY - Budget up to period CY qty | |||
TIL_ |
decimal |
Up to period PY - Budget up to period PY qty | |||
TIL_ |
decimal |
Up to period CY - PY qty | |||
TIL_ |
decimal |
Up to period CY - Budget up to period CY % | |||
TIL_ |
decimal |
Up to period PY - Budget up to period PY % | |||
TIL_ |
decimal |
Up to period CY - PY % | |||
TIL_ |
decimal |
Up to period CY - Budget up to period CY qty % | |||
TIL_ |
decimal |
Up to period PY - Budget up to period PY qty % | |||
TIL_ |
decimal |
Up to period CY - PY qty % | |||
TOT_ |
int64 |
Actual CY credit | |||
TOT_ |
int64 |
Actual PY credit | |||
TOT_ |
int64 |
Actual CY debit | |||
TOT_ |
int64 |
Actual PY debit | |||
TOT_ |
int64 |
Actual CY | |||
TOT_ |
int64 |
Actual PY | |||
TOT_ |
decimal |
Actual 100% CY | |||
TOT_ |
decimal |
Actual 100% PY | |||
TOT_ |
int64 |
Net actual CY credit | |||
TOT_ |
int64 |
Net actual CY debit | |||
TOT_ |
decimal |
Actual CY qty | |||
TOT_ |
decimal |
Actual PY qty | |||
TOT_ |
decimal |
Actual 100% CY qty | |||
TOT_ |
decimal |
Actual 100% PY qty | |||
TOT_ |
int64 |
Budget CY | |||
TOT_ |
int64 |
Budget PY | |||
TOT_ |
int64 |
Budget CY - PY | |||
TOT_ |
decimal |
Budget 100% CY | |||
TOT_ |
decimal |
Budget 100% PY | |||
TOT_ |
decimal |
Budget CY - PY % | |||
TOT_ |
decimal |
Budget CY qty | |||
TOT_ |
decimal |
Budget PY qty | |||
TOT_ |
decimal |
Budget CY - PY qty | |||
TOT_ |
decimal |
Budget 100% CY qty | |||
TOT_ |
decimal |
Budget 100% PY qty | |||
TOT_ |
decimal |
Budget CY - PY qty % | |||
TOT_ |
int64 |
Actual CY - Budget CY | |||
TOT_ |
int64 |
Actual PY - Budget PY | |||
TOT_ |
int64 |
Actual CY - PY | |||
TOT_ |
decimal |
Actual CY - Budget CY qty | |||
TOT_ |
decimal |
Actual PY - Budget PY qty | |||
TOT_ |
decimal |
Actual CY - PY qty | |||
TOT_ |
decimal |
Actual CY - Budget CY % | |||
TOT_ |
decimal |
Actual PY - Budget PY % | |||
TOT_ |
decimal |
Actual CY - PY % | |||
TOT_ |
decimal |
Actual CY - Budget CY qty % | |||
TOT_ |
decimal |
Actual PY - Budget PY qty % | |||
TOT_ |
decimal |
Actual CY - PY qty % | |||
TRN_ |
int32 |
Period | |||
ULT_ |
int64 |
Year-end PY credit | |||
ULT_ |
int64 |
Year-end PY debit | |||
ULT_ |
int64 |
Year-end PY | |||
ULT_ |
decimal |
Year-end 100% PY | |||
ULT_ |
decimal |
Year-end PY qty | |||
ULT_ |
decimal |
Year-end 100% PY qty | |||
ULT_ |
int64 |
Budget year-end CY | |||
ULT_ |
int64 |
Budget year-end PY | |||
ULT_ |
decimal |
Year-end budget CY qty | |||
ULT_ |
decimal |
Budget year-end PY qty | |||
ULT_ |
int64 |
Year-end PY - Budget year-end PY | |||
ULT_ |
decimal |
Year-end PY - Budget year-end PY qty | |||
ULT_ |
decimal |
Year-end PY - Budget year-end PY % | |||
ULT_ |
decimal |
Year-end PY - Budget year-end PY qty % |