FICOT_CONDI - Conditions (Unbuffered)

Conditions (Unbuffered) information is stored in SAP table FICOT_CONDI.
It is part of development package FICO in software component CA-FIM-FCO. This development package consists of objects that can be grouped under "Financial Conditions".

Fields for table FICOT_CONDI

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
.INCLUDEXFICOS_CONDI_KEY0
MANDTClientXMANDTCLNT6*
I_LISTCondition ListXFICO_ILISTRAW16
I_COMPCondition ComponentXFICO_ICOMPRAW16
I_EXTLINKExternal ConnectionFICO_IEXTLINKRAW16
.INCLUDEFICOS_LIST0
O_LISTTYPECondition Group TypeFICO_OLISTTYPNUMC12FICOC_LIST
O_APPLApplicationFICO_OAPPLCHAR12FICOB_APPL
.INCLUDEFICOS_COND0
O_CONDTYPECondition TypeFICO_OCONDTYPENUMC12*
F_INCREMReplacement CategoryFICO_FINCREMCHAR2
I_MERGE_ORDEROrdinal Number for Markup Conditions in Condition MergerFICO_IMERGENONUMC8
C_AMTCurrencyFICO_CAMTCUKY10TCURC
F_INDCONDIndividual ConditionFICO_FINDCONDCHAR2
.INCLUDEFICOS_COMPONENT0
I_CONDCondition GUIDFICO_ICONDRAW16*
D_VALIDFROMValid-From Date of ConditionFICO_DVALIDFROMDATS16
F_VALIDFROMINCInclusive indicator for valid from dateFICO_FVALIDFROMINCCHAR2
F_VALIDFROMULTMonth-End Indicator for Valid-From DateFICO_FVALIDFROMULTCHAR2
D_VALIDTOValid-Top Date of ConditionFICO_DVALIDTODATS16
F_VALIDTOINCInclusive indicator for valid to dateFICO_FVALIDTOINCCHAR2
F_VALIDTOULTMonth-End Indicator for Valid-To DateFICO_FVALIDTOULTCHAR2
O_LEVELTiered or Interval CalculationFICO_OLEVELNUMC2
O_LEVELTOFROMCondition Item (Upper/Lower Limit)FICO_OLEVELTOFROMNUMC2
F_ZEROCONDCondition FormFICO_FZEROCONDCHAR2
O_TIMELIMReason for Assignment of ConditionFICO_OTIMELIMNUMC4FICOC_TIMELIM
O_LEVELEVALLevels for Condition DeterminationFICO_OLEVELEVALNUMC2
O_STATUSStatus of Validity Period of a ConditionFICO_OSTATUSNUMC4
F_CORRESPONDENCECreate CorrespondenceFICO_FCORRESPONDENCECHAR2
O_LEVELTOFREVALIndicator: Upper/Lower Limit for Condition DeterminationFICO_OLEVELTOFREVALNUMC2
O_RELCONDTYPEReference Condition TypeFICO_ORELCONDTYPENUMC12FICOC_COND
F_NOINHERITANCECondition is not Passed OnFICO_FNO_INHERITANCECHAR2
O_CONDSOURCEOrigin of the Validity PeriodFICO_OCONDSOURCECHAR20
I_LIST_SOURCEOriginal List GUID for the Validity PeriodFICO_ILISTSOURCERAW16
O_REFUNDCategory for Interest ReimbursementFICO_OREFUNDNUMC2
I_BASIS_ORDEROrdinal Number for Basis Conditions in Condition MergerFICO_IBASIS_MERGENONUMC8
I_COMP_RELDependent Condition Component from ReleaseFICO_ICOMP_RELRAW16
.INCLUDEFICOS_AMT0
O_AMTCATGAmount CategoryFICO_OAMTCATGCHAR12FICOB_AMT
F_ADDDEBITObsolete: Ind. Overdraft Int. in Addition to Debit InterestFICO_FADDDEBITCHAR2
O_INSTMETHAmout Determination Category for Payment ConditionFICO_OINSTMETHCHAR8
O_INTMETHODInterest Calculation MethodFICO_OINTMETHODCHAR2
F_EXPINTType of Interest CalculationFICO_FEXPINTCHAR2
O_AMMRHYZVInterest Settlement Frequency for Exponential Interest Calc.TFM_AMMRHYZVNUMC4
A_FREEAMTExemptionFICO_AFREEAMTCURR12
N_FREECOUNTNumber of Free ItemsFICO_NFREECOUNTNUMC14
F_CAPITALINCREMIndicator: CapitalizationFICO_FCAPITALINCREMCHAR2
F_DUEDATERELDue Date-Related Calculation IndicatorFICO_FDUEDATERELCHAR2
F_GRACEINTGrace Period Interest MethodFICO_FGRACEINTCHAR2
O_CAL4Interest CalendarTFMSKALIDWTCHAR4TFACD
F_ROUNDRounding CategoryFICO_FROUNDCHAR2
U_ROUNDUNITRounding UnitFICO_UROUNDUNITDEC7
F_COUNT_AMOUNTAmount CounterFICO_FCOUNT_AMOUNTCHAR2
O_SETTLEMENTType of ClearingFICO_OSETTLEMENTCHAR2
O_FIMATIMEPROPIndicator for Pro Rata Calculations in Cash FlowFICO_OFIMATIMEPROPNUMC2
O_ITEMCOUNTERCounterFICO_OITEMCOUNTERCHAR12
.INCLUDEFICOS_AMT_PENALTY0
O_PCALCREFCalculation Method for Early Withdrawal PenaltyFICO_OPCALCCHAR4FICOC_PCALCREF
F_REDUCTIONObsolete: Do Not UseFICO_FREDUCTIONCHAR2
O_RES_METH_TYPEResult Calculation TypeFICO_ORES_METH_TYPENUMC8
.INCLUDEFICOS_REDUCTION0
A_AMT_CUTBReduction AmountFICO_AAMT_CUTBCURR12
R_PERC_CUTBPerecentage ReductionFICO_RPERCENTAGE_CUTBDEC8
O_INTREF_CUTBReference Interest Rate ReductionFICO_OINTREF_CUTBCHAR20
R_INTMIN_CUTBMinimum Interest ReductionFICO_RINTMIN_CUTBDEC8
R_INTMAX_CUTBMaximum Interest ReductionFICO_RINTMAX_CUTBDEC8
N_CHRGCOUNTMaximum Number of ItemsFICO_NCHRGCOUNTNUMC14
F_RELATIONCondition has RelationshipsFICO_FRELATIONCHAR2
.INCLUDEFICOS_AVGINT0
O_AVGINTWEIGHTWeighting Category of Interest RateFICO_OAVGINTWEIGHTCHAR2
F_ROUNDAVGINTRounding Category of Average Interest RateFICO_FROUNDAVGINTCHAR2
U_ROUNDUNITAVGINTNumber of Rounding Decimal Places for Average Interest RateFICO_UROUNDUNITAVGINTINT11
R_AVGINTSPREADMarkup or Markdown Applied to Average Interest RateFICO_RAVGINTSPREADDEC8
R_AVGINTMINMinimum of Average Interest RateFICO_RAVGINTMINDEC8
R_AVGINTMAXMaximum of Average Interest RateFICO_RAVGINTMAXDEC8
O_AVGINTRESETEvent for Resetting Calculation of Average Interest RateFICO_OAVGINTRESETCHAR2
.INCLUDEFICOS_EVAL0
O_REFDATEReference DateFICO_OREFDATENUMC2
U_REFDATUNITShift of Reference Date: UnitFICO_UREFDATUNITNUMC2
N_REFDATNUMShift of reference date: Number of unitsFICO_NREFDATNUMNUMC6
O_REFDATSETDATEShift of reference date: Key dateFICO_OREFDATSETDATENUMC4
U_UNITDETSHIFTShift of Determination Period: UnitFICO_UUNITDETSHIFTNUMC2
N_NUMDETSHIFTShift of Calculation Period: Number of UnitsFICO_NNUMDETSHIFTNUMC6
O_USEPRDUse PeriodFICO_OUSEPRDNUMC4FICOC_USEPRD
O_DETPRDDetermination PeriodFICO_ODETPRDNUMC4FICOC_DETPRD
O_TIMEPROPCALCCharge Calculation MethodFICO_OTIMEPROPCALCNUMC4
O_TRNOVRCLASSTurnover ClassFICO_OTRNOVRCLASSCHAR8
O_TRNOVRCLBASEBalancing MethodFICO_OTRNOVRCLBASENUMC4
O_BALANCECATGBalance CategoryFICO_OBALANCECATGNUMC4
O_BALANCEBASEBasis of BalancesFICO_OBALANCEBASENUMC4
O_PERIODCATGPeriod CategoryFICO_OPERIODCATGNUMC4
O_BASEREFEVALCalculation BasisFICO_OBASEREFEVALCHAR20
.INCLUDEFICOS_DATE0
O_DATECATGDate CategoryFICO_ODATECATGCHAR12FICOB_DATE
N_REPPERIODRepetition periodFICO_NREPPERIODINT44
O_REPUNITRepetition UnitFICO_OREPUNITCHAR2
O_KEYDATEKey DateFICO_OKEYDATENUMC4
D_STARTDATEFirst Calculation Date for Date UpdateFICO_DSTARTDATEDATS16
F_STARTDATEINCInclusive IndicatorFICO_FSTARTDATEINCCHAR2
F_STARTDATEULTMonth-End Indicator for Start DateFICO_FSTARTDATEULTCHAR2
O_DATERULEUpdate RuleFICO_ODATERULENUMC4
O_PULLDATEShift Due DateFICO_OPULLDATECHAR4
O_RHYTHMCATGFrequency CategoryFICO_ORHYTHMCATGCHAR2
O_REFSTARTDATEReference Date for Start DateFICO_OREFSTARTDATENUMC8
N_REFSTARTNUMShift of Reference Date for Start Date: Number of UnitsFICO_NREFSTARTNUMNUMC6
U_REFSTARTUNITShift of Reference Date for Start Date: UnitFICO_UREFSTARTUNITNUMC2
F_FIXEDPERIODUpdate With Fixed PeriodsFICO_FFIXEDPERIODCHAR2
O_RELDATECATGReference Date CategoryFICO_ORELDATECATGCHAR12FICOB_DATE
O_RELDATESHIFTReference Date After Working Day ShiftFICO_ORELDATESHIFTCHAR2
O_REL_MISCReference Category for Date Category AdjustmentFICO_ORELMISCCHAR2
O_CAL1Calendar 1FICO_OCAL1CHAR4TFACD
O_CAL2Calendar 2FICO_OCAL2CHAR4TFACD
O_CAL3Calendar 3FICO_OCAL3CHAR4TFACD
O_CAL5Calendar 4FICO_OCAL5CHAR4TFACD
O_CAL6Calendar 5FICO_OCAL6CHAR4TFACD
O_KEYDATES40Multiple Key Dates, CHAR Field With One Character Per DayFICO_OKEYDATES40CHAR80
N_LOCKOUTDAYSDuration of Lockout Period in Working DaysFICO_NLOCKOUTDAYSNUMC4
.INCLUDEFICOS_DIFF_CHANGE0
O_DIFFCATGDifferentiation CategoryFICO_ODIFFCATG_0CHAR6*
I_DIFFVALUEDifferentiation valueFICO_IDIFFVALUECHAR20
O_DIFFCATG_1Differentiation CategoryFICO_ODIFFCATG_1CHAR6*
I_DIFFVALUE_1Differentiation valueFICO_IDIFFVALUECHAR20
O_DIFFCATG_2Differentiation CategoryFICO_ODIFFCATG_2CHAR6*
I_DIFFVALUE_2Differentiation valueFICO_IDIFFVALUECHAR20
O_DIFFCATG_3Differentiation CategoryFICO_ODIFFCATG_3CHAR6*
I_DIFFVALUE_3Differentiation valueFICO_IDIFFVALUECHAR20
O_DIFFCATG_4Differentiation CategoryFICO_ODIFFCATG_4CHAR6*
I_DIFFVALUE_4Differentiation valueFICO_IDIFFVALUECHAR20
.INCLUDEFICOS_USERDATA0
X_CREATEUSERCreated byFICO_XCREATEUSERCHAR24
D_CREATEDATECreated onFICO_DCREATEDATEDATS16
T_CREATETIMECreation TimeFICO_TCREATETIMETIMS12
X_CHANGEUSERLast changed byFICO_XCHANGEUSERCHAR24
D_CHANGEDATEChanged onFICO_DCHANGEDATEDATS16
T_CHANGETIMEChanged atFICO_TCHANGETIMETIMS12
X_RELEASEUSERReleased byFICO_XRELEASEUSERCHAR24
D_RELEASEDATEReleased onFICO_DRELEASEDATEDATS16
T_RELEASETIMEReleased atFICO_TRELEASETIMETIMS12
D_VALIDTO_ARCHIVValid-to Date (Calculated) for ArchivingFICO_DVALIDTO_ARCHIVEDATS16
.INCLUDEAFX_STR_ARCHIVE_DATA0
ARCHIVE_STATUSArchivability StatusAFX_DTE_ARCHIVE_STATUSCHAR2
ARCHIVE_FLUDResubmission DateAFX_DTE_ARCHIVE_FLUDDATS16
I_FLDLSTIDField ListFICO_IFLDLSTIDRAW16
Privacy Policy