invantive documentation
Invantive SupportforenAnmelden / Eintragen

CRS_TRLB: AccountView Reporting

read only per partition

  • Katalog: AccountView
  • Label: Reporting

Es können nur Daten abgerufen werden.

Tabellenspalten

Die Spalten der Tabelle CRS_TRLB sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
ACCT_NR varchar2(10) General ledger account
BAL_AAC_CY int64 Balance sheet CY credit
BAL_AAC_PY int64 Balance sheet PY credit
BAL_AAD_CY int64 Balance sheet CY debit
BAL_AAD_PY int64 Balance sheet PY debit
BAL_AAN_CY int64 Balance sheet CY
BAL_AAN_PY int64 Balance sheet PY
BAL_ABC_CY int64 Net balance sheet CY credit
BAL_ABD_CY int64 Net balance sheet CY debit
BAL_AQN_CY decimal Balance sheet CY qty
BAL_AQN_PY decimal Balance sheet PY qty
BAL_DAN_YY int64 Balance sheet CY - PY
BAL_DQN_YY decimal Balance sheet CY - PY qty
BAL_PAN_YY decimal Balance sheet CY - PY %
BAL_PQN_YY decimal Balance sheet CY - PY qty %
BUD_EMP_NR varchar2(10) Budget holder
COR_AAC_CY int64 Adjustment CY credit
COR_AAC_PY int64 Adjustments PY credit
COR_AAD_CY int64 Adjustments CY debit
COR_AAD_PY int64 Adjustments PY debit
COR_AAN_CY int64 Adjustment CY
COR_AAN_PY int64 Adjustments PY
COR_AQN_CY decimal Adjustments CY qty
COR_AQN_PY decimal Adjustments PY qty
COR_DAN_YY int64 Adjustments CY - PY
COR_DQN_YY decimal Adjustments CY - PY qty
COR_PAN_YY decimal Adjustments CY - PY %
COR_PQN_YY decimal Adjustments CY - PY qty %
COST_CODE varchar2(10) Cost centre code
DIM_KEY varchar2(100) Dimension key
DSP_FMT varchar2(1) Line format
FCT_AAN_CY int64 Forecast CY
FCT_AQN_CY decimal Forecast CY qty
FCT_DAN_CY int64 Forecast CY - Budget Year-end CY
FCT_DQN_CY decimal Forecast CY - Budget Year-end CY qty
FCT_PAN_CY decimal Forecast CY - Budget Year-end CY %
FCT_PQN_CY decimal Forecast CY - Budget Year-end CY qty %
INC_AAC_CY int64 P&L CY credit
INC_AAC_PY int64 P&L PY credit
INC_AAD_CY int64 P&L CY debit
INC_AAD_PY int64 P&L PY debit
INC_AAN_CY int64 P&L CY
INC_AAN_PY int64 P&L PY
INC_ABC_CY int64 Net P&L CY credit
INC_ABD_CY int64 Net P&L CY debit
INC_AQN_CY decimal P&L CY qty
INC_AQN_PY decimal P&L PY qty
INC_DAN_YY int64 P&L CY - PY
INC_DQN_YY decimal P&L CY - PY qty
INC_PAN_YY decimal P&L CY - PY %
INC_PQN_YY decimal P&L CY - PY qty %
IND_LVL int32 Indentation level
LINE_BOLD char Bold line
LINE_DESC varchar2(60) Line description
LINE_LVL int32 Level
LINE_TYPE int32 Line type
MND_PER int32 Months
MUT_AAC_CY int64 Movements CY credit
MUT_AAC_PY int64 Movements PY credit
MUT_AAD_CY int64 Movements CY debit
MUT_AAD_PY int64 Movements PY debit
MUT_AAN_CY int64 Movements CY
MUT_AAN_PY int64 Movements PY
MUT_AQN_CY decimal Movements CY qty
MUT_AQN_PY decimal Movements PY qty
MUT_DAN_YY int64 Movements CY - PY
MUT_DQN_YY decimal Movements CY - PY qty
MUT_PAN_YY decimal Movements CY - PY %
MUT_PQN_YY decimal Movements CY - PY qty %
OPN_AAC_CY int64 Opening balance CY credit
OPN_AAC_PY int64 Opening balance PY credit
OPN_AAD_CY int64 Opening balance CY debit
OPN_AAD_PY int64 Opening balance PY debit
OPN_AAN_CY int64 Opening balance CY
OPN_AAN_PY int64 Opening balance PY
OPN_AQN_CY decimal Opening balance CY qty
OPN_AQN_PY decimal Opening balance PY qty
OPN_CAC_CY int64 Opening balance CY credit net
OPN_CAD_CY int64 Opening balance CY debit net
OPN_DAN_YY int64 Opening balance CY - PY
OPN_DQN_YY decimal Opening balance CY - PY qty
OPN_PAN_YY decimal Opening balance CY - PY %
OPN_PQN_YY decimal Opening balance CY - PY qty %
PA_CODE varchar2(10) Partner
PAGE_BREAK char Page break
PARENT_ID varchar2(10) Parent element
PART_RNG varchar2(20) Partner as dimension
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PC_CODE varchar2(5) Cost type
PER_AAC_CY int64 Period CY credit
PER_AAC_PY int64 Period PY credit
PER_AAD_CY int64 Period CY debit
PER_AAD_PY int64 Period PY debit
PER_AAN_CY int64 Period CY
PER_AAN_PY int64 Period PY
PER_AAP_CY decimal Period 100% CY
PER_AAP_PY decimal Period 100% PY
PER_ABC_CY int64 Net period CY credit
PER_ABD_CY int64 Net period CY debit
PER_AQN_CY decimal Period CY qty
PER_AQN_PY decimal Period PY qty
PER_AQP_CY decimal Period 100% CY qty
PER_AQP_PY decimal Period 100% PY qty
PER_BAN_CY int64 Budget period CY
PER_BAN_PY int64 Budget period PY
PER_BAN_YY int64 Budget period CY - PY
PER_BAP_YY decimal Budget period CY - PY %
PER_BQN_CY decimal Budget period CY qty
PER_BQN_PY decimal Budget period PY qty
PER_BQN_YY decimal Budget period CY - PY qty
PER_BQP_YY decimal Budget period CY - PY qty %
PER_DAN_CY int64 Period CY - Budget period CY
PER_DAN_PY int64 Period PY - Budget period PY
PER_DAN_YY int64 Period CY - PY
PER_DQN_CY decimal Period CY - Budget period CY qty
PER_DQN_PY decimal Period PY - Budget period PY qty
PER_DQN_YY decimal Period CY - PY qty
PER_PAN_CY decimal Period CY - Budget period CY %
PER_PAN_PY decimal Period PY - Budget period PY %
PER_PAN_YY decimal Period CY - PY %
PER_PQN_CY decimal Period CY - Budget period CY qty %
PER_PQN_PY decimal Period PY - Budget period PY qty %
PER_PQN_YY decimal Period CY - PY qty %
PROJ_CODE varchar2(10) Project code
QTR_PER int32 Quarters
REC_ID varchar2(10) Unique code
REC_KEY varchar2(20) Source key
RNG_CODE varchar2(10) Partner administration
RST_BAN_CY int64 Remaining budget CY
RST_BQN_CY decimal Remaining budget CY qty
SHOW_ICON int32 Icon
SHOW_LINE char Show total line
SHOW_REC char Show line
TAX_ID varchar2(10) Element code
TIL_AAC_CY int64 Up to period CY credit
TIL_AAC_PY int64 Up to period PY credit
TIL_AAD_CY int64 Up to period CY debit
TIL_AAD_PY int64 Up to period PY debit
TIL_AAN_CY int64 Up to period CY
TIL_AAN_PY int64 Up to period PY
TIL_AAP_CY decimal Up to period 100% CY
TIL_AAP_PY decimal Up to period 100% PY
TIL_ABC_CY int64 Net up to period CY credit
TIL_ABC_PY int64 Net up to period PY credit
TIL_ABD_CY int64 Net up to period CY debit
TIL_ABD_PY int64 Net up to period PY debit
TIL_AQN_CY decimal Up to period CY qty
TIL_AQN_PY decimal Up to period PY qty
TIL_AQP_CY decimal Up to period 100% CY qty
TIL_AQP_PY decimal Up to period 100% PY qty
TIL_BAN_CY int64 Budget up to period CY
TIL_BAN_PY int64 Budget up to period PY
TIL_BAN_YY int64 Budget up to period CY - PY
TIL_BAP_YY decimal Budget up to period CY - PY %
TIL_BQN_CY decimal Budget up to period CY qty
TIL_BQN_PY decimal Budget up to period PY qty
TIL_BQN_YY decimal Budget up to period CY - PY qty
TIL_BQP_YY decimal Budget up to period CY - PY qty %
TIL_DAN_CY int64 Up to period CY - Budget up to period CY
TIL_DAN_PY int64 Up to period PY - Budget up to period PY
TIL_DAN_YY int64 Up to period CY - PY
TIL_DQN_CY decimal Up to period CY - Budget up to period CY qty
TIL_DQN_PY decimal Up to period PY - Budget up to period PY qty
TIL_DQN_YY decimal Up to period CY - PY qty
TIL_PAN_CY decimal Up to period CY - Budget up to period CY %
TIL_PAN_PY decimal Up to period PY - Budget up to period PY %
TIL_PAN_YY decimal Up to period CY - PY %
TIL_PQN_CY decimal Up to period CY - Budget up to period CY qty %
TIL_PQN_PY decimal Up to period PY - Budget up to period PY qty %
TIL_PQN_YY decimal Up to period CY - PY qty %
TOT_AAC_CY int64 Actual CY credit
TOT_AAC_PY int64 Actual PY credit
TOT_AAD_CY int64 Actual CY debit
TOT_AAD_PY int64 Actual PY debit
TOT_AAN_CY int64 Actual CY
TOT_AAN_PY int64 Actual PY
TOT_AAP_CY decimal Actual 100% CY
TOT_AAP_PY decimal Actual 100% PY
TOT_ABC_CY int64 Net actual CY credit
TOT_ABD_CY int64 Net actual CY debit
TOT_AQN_CY decimal Actual CY qty
TOT_AQN_PY decimal Actual PY qty
TOT_AQP_CY decimal Actual 100% CY qty
TOT_AQP_PY decimal Actual 100% PY qty
TOT_BAN_CY int64 Budget CY
TOT_BAN_PY int64 Budget PY
TOT_BAN_YY int64 Budget CY - PY
TOT_BAP_CY decimal Budget 100% CY
TOT_BAP_PY decimal Budget 100% PY
TOT_BAP_YY decimal Budget CY - PY %
TOT_BQN_CY decimal Budget CY qty
TOT_BQN_PY decimal Budget PY qty
TOT_BQN_YY decimal Budget CY - PY qty
TOT_BQP_CY decimal Budget 100% CY qty
TOT_BQP_PY decimal Budget 100% PY qty
TOT_BQP_YY decimal Budget CY - PY qty %
TOT_DAN_CY int64 Actual CY - Budget CY
TOT_DAN_PY int64 Actual PY - Budget PY
TOT_DAN_YY int64 Actual CY - PY
TOT_DQN_CY decimal Actual CY - Budget CY qty
TOT_DQN_PY decimal Actual PY - Budget PY qty
TOT_DQN_YY decimal Actual CY - PY qty
TOT_PAN_CY decimal Actual CY - Budget CY %
TOT_PAN_PY decimal Actual PY - Budget PY %
TOT_PAN_YY decimal Actual CY - PY %
TOT_PQN_CY decimal Actual CY - Budget CY qty %
TOT_PQN_PY decimal Actual PY - Budget PY qty %
TOT_PQN_YY decimal Actual CY - PY qty %
TRN_PER int32 Period
ULT_AAC_PY int64 Year-end PY credit
ULT_AAD_PY int64 Year-end PY debit
ULT_AAN_PY int64 Year-end PY
ULT_AAP_PY decimal Year-end 100% PY
ULT_AQN_PY decimal Year-end PY qty
ULT_AQP_PY decimal Year-end 100% PY qty
ULT_BAN_CY int64 Budget year-end CY
ULT_BAN_PY int64 Budget year-end PY
ULT_BQN_CY decimal Year-end budget CY qty
ULT_BQN_PY decimal Budget year-end PY qty
ULT_DAN_PY int64 Year-end PY - Budget year-end PY
ULT_DQN_PY decimal Year-end PY - Budget year-end PY qty
ULT_PAN_PY decimal Year-end PY - Budget year-end PY %
ULT_PQN_PY decimal Year-end PY - Budget year-end PY qty %