FICOT_CONDI

Conditions (Unbuffered) | #masterdata | Component: Financial Conditions
Column Name Description
MANDT Client
I_LIST Condition List
I_COMP Condition Component
Column Name Description
💲 Currency (FICOT_COND.C_AMT_2):
A_FREEAMT Exemption
A_AMT_CUTB Reduction Amount
Column Name Description
Column Name Description
D_VALIDFROM Valid-From Date of Condition
D_VALIDTO Valid-Top Date of Condition
D_STARTDATE First Calculation Date for Date Update
D_CREATEDATE Created on
T_CREATETIME Creation Time
D_CHANGEDATE Changed on
T_CHANGETIME Changed at
D_RELEASEDATE Released on
T_RELEASETIME Released at
D_VALIDTO_ARCHIV Valid-to Date (Calculated) for Archiving
ARCHIVE_FLUD Resubmission Date
Column Name Description
F_INCREM Replacement Category Show values
F_INDCOND Individual Condition Show values
F_VALIDFROMINC Inclusive indicator for valid from date Show values
F_VALIDFROMULT Month-End Indicator for Valid-From Date Show values
F_VALIDTOINC Inclusive indicator for valid to date Show values
F_VALIDTOULT Month-End Indicator for Valid-To Date Show values
O_LEVEL Tiered or Interval Calculation Show values
O_LEVELTOFROM Condition Item (Upper/Lower Limit) Show values
F_ZEROCOND Condition Form Show values
O_LEVELEVAL Levels for Condition Determination Show values
O_STATUS Status of Validity Period of a Condition Show values
F_CORRESPONDENCE Create Correspondence Show values
O_LEVELTOFREVAL Indicator: Upper/Lower Limit for Condition Determination Show values
F_NOINHERITANCE Condition is not Passed On Show values
O_REFUND Category for Interest Reimbursement Show values
F_ADDDEBIT Obsolete: Ind. Overdraft Int. in Addition to Debit Interest Show values
O_INSTMETH Amout Determination Category for Payment Condition Show values
O_INTMETHOD Interest Calculation Method Show values
F_EXPINT Type of Interest Calculation Show values
O_AMMRHYZV Interest Settlement Frequency for Exponential Interest Calc. Show values
F_CAPITALINCREM Indicator: Capitalization Show values
F_DUEDATEREL Due Date-Related Calculation Indicator Show values
F_GRACEINT Grace Period Interest Method Show values
F_ROUND Rounding Category Show values
F_COUNT_AMOUNT Amount Counter Show values
O_SETTLEMENT Type of Clearing Show values
O_FIMATIMEPROP Indicator for Pro Rata Calculations in Cash Flow Show values
F_REDUCTION Obsolete: Do Not Use Show values
F_RELATION Condition has Relationships Show values
O_AVGINTWEIGHT Weighting Category of Interest Rate Show values
F_ROUNDAVGINT Rounding Category of Average Interest Rate Show values
O_AVGINTRESET Event for Resetting Calculation of Average Interest Rate Show values
O_REFDATE Reference Date Show values
U_REFDATUNIT Shift of Reference Date: Unit Show values
O_REFDATSETDATE Shift of reference date: Key date Show values
U_UNITDETSHIFT Shift of Determination Period: Unit Show values
O_TRNOVRCLBASE Balancing Method Show values
O_BALANCECATG Balance Category Show values
O_BALANCEBASE Basis of Balances Show values
O_PERIODCATG Period Category Show values
O_REPUNIT Repetition Unit Show values
O_KEYDATE Key Date Show values
F_STARTDATEINC Inclusive Indicator Show values
F_STARTDATEULT Month-End Indicator for Start Date Show values
O_DATERULE Update Rule Show values
O_PULLDATE Shift Due Date Show values
O_RHYTHMCATG Frequency Category Show values
U_REFSTARTUNIT Shift of Reference Date for Start Date: Unit Show values
F_FIXEDPERIOD Update With Fixed Periods Show values
O_RELDATESHIFT Reference Date After Working Day Shift Show values
O_REL_MISC Reference Category for Date Category Adjustment Show values
ARCHIVE_STATUS Archivability Status Show values
Column Name Description Domain name
I_EXTLINK External Connection SYSUUID
O_CONDTYPE Condition Type FICO_OCONDTYP
I_MERGE_ORDER Ordinal Number for Markup Conditions in Condition Merger FICO_IMERGENO
O_CONDSOURCE Origin of the Validity Period FICO_OCONDSOURCE
I_LIST_SOURCE Original List GUID for the Validity Period SYSUUID
I_BASIS_ORDER Ordinal Number for Basis Conditions in Condition Merger FICO_IMERGENO
I_COMP_REL Dependent Condition Component from Release SYSUUID
N_FREECOUNT Number of Free Items FICO_NCOUNT
U_ROUNDUNIT Rounding Unit TFMSRUNIT
O_ITEMCOUNTER Counter FICO_OITEMCOUNTER
O_RES_METH_TYPE Result Calculation Type
R_PERC_CUTB Perecentage Reduction FICO_RPERCENTAGE
O_INTREF_CUTB Reference Interest Rate Reduction
R_INTMIN_CUTB Minimum Interest Reduction FICO_RPERCENTAGE
R_INTMAX_CUTB Maximum Interest Reduction FICO_RPERCENTAGE
N_CHRGCOUNT Maximum Number of Items FICO_NCOUNT
U_ROUNDUNITAVGINT Number of Rounding Decimal Places for Average Interest Rate TFM_ROUNDDECIMALS
R_AVGINTSPREAD Markup or Markdown Applied to Average Interest Rate FICO_RAVGINTSPREAD
R_AVGINTMIN Minimum of Average Interest Rate FICO_RAVGINTMIN
R_AVGINTMAX Maximum of Average Interest Rate FICO_RAVGINTMAX
N_REFDATNUM Shift of reference date: Number of units FICO_NNUMUNIT
N_NUMDETSHIFT Shift of Calculation Period: Number of Units FICO_NNUMUNIT
O_TIMEPROPCALC Charge Calculation Method FICO_OTIMEPROPCALC
O_TRNOVRCLASS Turnover Class FICO_OTRNOVRCLASS
O_BASEREFEVAL Calculation Basis
N_REPPERIOD Repetition period FICO_NREPPERIOD
O_REFSTARTDATE Reference Date for Start Date
N_REFSTARTNUM Shift of Reference Date for Start Date: Number of Units FICO_NNUMUNIT
O_KEYDATES40 Multiple Key Dates, CHAR Field With One Character Per Day CHAR40
N_LOCKOUTDAYS Duration of Lockout Period in Working Days FICO_NLOCKOUTDAYS
O_DIFFCATG Differentiation Category FICO_ODIFFCATG
I_DIFFVALUE Differentiation value FICO_IDIFFVALUE
O_DIFFCATG_1 Differentiation Category FICO_ODIFFCATG
I_DIFFVALUE_1 Differentiation value FICO_IDIFFVALUE
O_DIFFCATG_2 Differentiation Category FICO_ODIFFCATG
I_DIFFVALUE_2 Differentiation value FICO_IDIFFVALUE
O_DIFFCATG_3 Differentiation Category FICO_ODIFFCATG
I_DIFFVALUE_3 Differentiation value FICO_IDIFFVALUE
O_DIFFCATG_4 Differentiation Category FICO_ODIFFCATG
I_DIFFVALUE_4 Differentiation value FICO_IDIFFVALUE
X_CREATEUSER Created by FICO_XUSER
X_CHANGEUSER Last changed by FICO_XUSER
X_RELEASEUSER Released by FICO_XUSER
I_FLDLSTID Field List SYSUUID
Master Data Relations Join Conditions
Currency
  • FICOT_CONDI.MANDT == TCURC.MANDT
  • FICOT_CONDI.C_AMT == TCURC.WAERS
Amount Category FICOT_CONDI.O_AMTCATG == FICOB_AMT.O_AMTCATG
Application FICOT_CONDI.O_APPL == FICOB_APPL.O_APPL
Calendar 1 FICOT_CONDI.O_CAL1 == TFACD.IDENT
Calendar 2 FICOT_CONDI.O_CAL2 == TFACD.IDENT
Calendar 3 FICOT_CONDI.O_CAL3 == TFACD.IDENT
Interest Calendar FICOT_CONDI.O_CAL4 == TFACD.IDENT
Calendar 4 FICOT_CONDI.O_CAL5 == TFACD.IDENT
Calendar 5 FICOT_CONDI.O_CAL6 == TFACD.IDENT
Date Category FICOT_CONDI.O_DATECATG == FICOB_DATE.O_DATECATG
Determination Period
Condition Group Type
  • Application
  • Condition Group Type
Calculation Method for Early Withdrawal Penalty
  • ?
  • Calculation Method for Early Withdrawal Penalty
  • Client
Reference Condition Type
  • ?
  • Client
  • Reference Condition Type
  • FICOT_CONDI.[column in domain "FICO_OAPPL"] == FICOC_COND.O_APPL
  • FICOT_CONDI.MANDT == FICOC_COND.MANDT
  • FICOT_CONDI.O_RELCONDTYPE == FICOC_COND.O_CONDTYPE
Reference Date Category FICOT_CONDI.O_RELDATECATG == FICOB_DATE.O_DATECATG
Reason for Assignment of Condition
  • Reason for Assignment of Condition
  • Client
Use Period
  • Use Period
  • Client