ERP 6.0: Top 10 requests

	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

B1 8.8: Top 10 requests

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OINM	101	Whse Journal

	Product	Version	Table	Columns	Indexes	Description	Module
Cross-Application Components :: Financial MathematicsConditions :: Financial Conditions
1	ERP EHP7	6.0	FICOT_CONDI	122	2	Conditions (Unbuffered)	Financial Conditions

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	I_LIST	Condition List	varbinary	16	0	RAW		No		FICO_ILIST
3	I_COMP	Condition Component	varbinary	16	0	RAW		No		FICO_ICOMP
4	I_EXTLINK	External Connection	varbinary	16	0	RAW		Yes		FICO_IEXTLINK
5	O_LISTTYPE	Condition Group Type	nvarchar	6	0	NUMC	(N'000000')	Yes	FICOC_LIST	FICO_OLISTTYP	Allow NULL?
6	O_APPL	Application	nvarchar	6	0	CHAR	(N' ')	Yes	FICOB_APPL	FICO_OAPPL	Allow NULL?
7	O_CONDTYPE	Condition Type	nvarchar	6	0	NUMC	(N'000000')	Yes	*	FICO_OCONDTYPE	Allow NULL?
8	F_INCREM	Replacement Category	char	1	0	CHAR	(N' ')	Yes		FICO_FINCREM	Allow NULL?
9	I_MERGE_ORDER	Ordinal Number for Markup Conditions in Condition Merger	nvarchar	4	0	NUMC	(N'0000')	Yes		FICO_IMERGENO	Allow NULL?
10	C_AMT	Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	FICO_CAMT	Allow NULL?
11	F_INDCOND	Individual Condition	char	1	0	CHAR	(N' ')	Yes		FICO_FINDCOND	Allow NULL?
12	I_COND	Condition GUID	varbinary	16	0	RAW		Yes	*	FICO_ICOND
13	D_VALIDFROM	Valid-From Date of Condition	nvarchar	8	0	DATS	(N'00000000')	Yes		FICO_DVALIDFROM	Allow NULL?
14	F_VALIDFROMINC	Inclusive indicator for valid from date	char	1	0	CHAR	(N' ')	Yes		FICO_FVALIDFROMINC	Allow NULL?
15	F_VALIDFROMULT	Month-End Indicator for Valid-From Date	char	1	0	CHAR	(N' ')	Yes		FICO_FVALIDFROMULT	Allow NULL?
16	D_VALIDTO	Valid-Top Date of Condition	nvarchar	8	0	DATS	(N'00000000')	Yes		FICO_DVALIDTO	Allow NULL?
17	F_VALIDTOINC	Inclusive indicator for valid to date	char	1	0	CHAR	(N' ')	Yes		FICO_FVALIDTOINC	Allow NULL?
18	F_VALIDTOULT	Month-End Indicator for Valid-To Date	char	1	0	CHAR	(N' ')	Yes		FICO_FVALIDTOULT	Allow NULL?
19	O_LEVEL	Tiered or Interval Calculation	char	1	0	NUMC	(N'0')	Yes		FICO_OLEVEL	Allow NULL?
20	O_LEVELTOFROM	Condition Item (Upper/Lower Limit)	char	1	0	NUMC	(N'0')	Yes		FICO_OLEVELTOFROM	Allow NULL?
21	F_ZEROCOND	Condition Form	char	1	0	CHAR	(N' ')	Yes		FICO_FZEROCOND	Allow NULL?
22	O_TIMELIM	Reason for Assignment of Condition	nvarchar	2	0	NUMC	(N'00')	Yes	FICOC_TIMELIM	FICO_OTIMELIM	Allow NULL?
23	O_LEVELEVAL	Levels for Condition Determination	char	1	0	NUMC	(N'0')	Yes		FICO_OLEVELEVAL	Allow NULL?
24	O_STATUS	Status of Validity Period of a Condition	nvarchar	2	0	NUMC	(N'00')	Yes		FICO_OSTATUS	Allow NULL?
25	F_CORRESPONDENCE	Generate Correspondence	char	1	0	CHAR	(N' ')	Yes		FICO_FCORRESPONDENCE	Allow NULL?
26	O_LEVELTOFREVAL	Indicator: Upper/Lower Limit for Condition Determination	char	1	0	NUMC	(N'0')	Yes		FICO_OLEVELTOFREVAL	Allow NULL?
27	O_RELCONDTYPE	Reference Condition Type	nvarchar	6	0	NUMC	(N'000000')	Yes	FICOC_COND	FICO_ORELCONDTYPE	Allow NULL?
28	F_NOINHERITANCE	Condition is not Passed On	char	1	0	CHAR	(N' ')	Yes		FICO_FNO_INHERITANCE	Allow NULL?
29	O_CONDSOURCE	Origin of the Validity Period	nvarchar	10	0	CHAR	(N' ')	Yes		FICO_OCONDSOURCE	Allow NULL?
30	I_LIST_SOURCE	Original List GUID for the Validity Period	varbinary	16	0	RAW		Yes		FICO_ILISTSOURCE
31	O_REFUND	Category for Interest Reimbursement	char	1	0	NUMC	(N'0')	Yes		FICO_OREFUND	Allow NULL?
32	I_BASIS_ORDER	Ordinal Number for Basis Conditions in Condition Merger	nvarchar	4	0	NUMC	(N'0000')	Yes		FICO_IBASIS_MERGENO	Allow NULL?
33	I_COMP_REL	Dependent Condition Component from Release	varbinary	16	0	RAW		Yes		FICO_ICOMP_REL
34	O_AMTCATG	Amount Category	nvarchar	6	0	CHAR	(N' ')	Yes	FICOB_AMT	FICO_OAMTCATG	Allow NULL?
35	F_ADDDEBIT	Obsolete: Ind. Overdraft Int. in Addition to Debit Interest	char	1	0	CHAR	(N' ')	Yes		FICO_FADDDEBIT	Allow NULL?
36	O_INSTMETH	Amout Determination Category for Payment Condition	nvarchar	4	0	CHAR	(N' ')	Yes		FICO_OINSTMETH	Allow NULL?
37	O_INTMETHOD	Interest Calculation Method	char	1	0	CHAR	(N' ')	Yes		FICO_OINTMETHOD	Allow NULL?
38	F_EXPINT	Exponential/Linear Interest Calculation	char	1	0	CHAR	(N' ')	Yes		FICO_FEXPINT	Allow NULL?
39	O_AMMRHYZV	Interest Settlement Frequency for Exponential Interest Calc.	nvarchar	2	0	NUMC	(N'00')	Yes		TFM_AMMRHYZV	Allow NULL?
40	A_FREEAMT	Exemption	decimal	23	2	CURR	((0))	Yes		FICO_AFREEAMT
41	N_FREECOUNT	Number of Free Items	nvarchar	7	0	NUMC	(N'0000000')	Yes		FICO_NFREECOUNT	Allow NULL?
42	F_CAPITALINCREM	Indicator: Capitalization	char	1	0	CHAR	(N' ')	Yes		FICO_FCAPITALINCREM	Allow NULL?
43	F_DUEDATEREL	Due Date-Related Calculation Indicator	char	1	0	CHAR	(N' ')	Yes		FICO_FDUEDATEREL	Allow NULL?
44	F_GRACEINT	Grace Period Interest Method	char	1	0	CHAR	(N' ')	Yes		FICO_FGRACEINT	Allow NULL?
45	O_CAL4	Interest Calendar	nvarchar	2	0	CHAR	(N' ')	Yes	TFACD	TFMSKALIDWT	Allow NULL?
46	F_ROUND	Rounding Category	char	1	0	CHAR	(N' ')	Yes		FICO_FROUND	Allow NULL?
47	U_ROUNDUNIT	Rounding Unit	decimal	13	7	DEC	((0))	Yes		FICO_UROUNDUNIT
48	F_COUNT_AMOUNT	Amount Counter	char	1	0	CHAR	(N' ')	Yes		FICO_FCOUNT_AMOUNT	Allow NULL?
49	O_SETTLEMENT	Type of Clearing	char	1	0	CHAR	(N' ')	Yes		FICO_OSETTLEMENT	Allow NULL?
50	O_FIMATIMEPROP	Indicator for Pro Rata Calculations in Cash Flow	char	1	0	NUMC	(N'0')	Yes		FICO_OFIMATIMEPROP	Allow NULL?
51	O_ITEMCOUNTER	Counter	nvarchar	6	0	CHAR	(N' ')	Yes		FICO_OITEMCOUNTER	Allow NULL?
52	O_PCALCREF	Calculation Method for Early Withdrawal Penalty	nvarchar	2	0	CHAR	(N' ')	Yes	FICOC_PCALCREF	FICO_OPCALC	Allow NULL?
53	F_REDUCTION	Obsolete: Do Not Use	char	1	0	CHAR	(N' ')	Yes		FICO_FREDUCTION	Allow NULL?
54	O_RES_METH_TYPE	Result Calculation Type	nvarchar	4	0	NUMC	(N'0000')	Yes		FICO_ORES_METH_TYPE	Allow NULL?
55	A_AMT_CUTB	Reduction Amount	decimal	23	2	CURR	((0))	Yes		FICO_AAMT_CUTB
56	R_PERC_CUTB	Perecentage Reduction	decimal	15	10	DEC	((0))	Yes		FICO_RPERCENTAGE_CUTB
57	O_INTREF_CUTB	Reference Interest Rate Reduction	nvarchar	10	0	CHAR	(N' ')	Yes		FICO_OINTREF_CUTB	Allow NULL?
58	R_INTMIN_CUTB	Minimum Interest Reduction	decimal	15	10	DEC	((0))	Yes		FICO_RINTMIN_CUTB
59	R_INTMAX_CUTB	Maximum Interest Reduction	decimal	15	10	DEC	((0))	Yes		FICO_RINTMAX_CUTB
60	N_CHRGCOUNT	Maximum Number of Items	nvarchar	7	0	NUMC	(N'0000000')	Yes		FICO_NCHRGCOUNT	Allow NULL?
61	F_RELATION	Condition has Relationships	char	1	0	CHAR	(N' ')	Yes		FICO_FRELATION	Allow NULL?
62	O_REFDATE	Reference Date	char	1	0	NUMC	(N'0')	Yes		FICO_OREFDATE	Allow NULL?
63	U_REFDATUNIT	Shift of Reference Date: Unit	char	1	0	NUMC	(N'0')	Yes		FICO_UREFDATUNIT	Allow NULL?
64	N_REFDATNUM	Shift of reference date: Number of units	nvarchar	3	0	NUMC	(N'000')	Yes		FICO_NREFDATNUM	Allow NULL?
65	O_REFDATSETDATE	Shift of reference date: Key date	nvarchar	2	0	NUMC	(N'00')	Yes		FICO_OREFDATSETDATE	Allow NULL?
66	U_UNITDETSHIFT	Shift of Determination Period: Unit	char	1	0	NUMC	(N'0')	Yes		FICO_UUNITDETSHIFT	Allow NULL?
67	N_NUMDETSHIFT	Shift of Calculation Period: Number of Units	nvarchar	3	0	NUMC	(N'000')	Yes		FICO_NNUMDETSHIFT	Allow NULL?
68	O_USEPRD	Use Period	nvarchar	2	0	NUMC	(N'00')	Yes	FICOC_USEPRD	FICO_OUSEPRD	Allow NULL?
69	O_DETPRD	Determination Period	nvarchar	2	0	NUMC	(N'00')	Yes	FICOC_DETPRD	FICO_ODETPRD	Allow NULL?
70	O_TIMEPROPCALC	Charge Calculation Method	nvarchar	2	0	NUMC	(N'00')	Yes		FICO_OTIMEPROPCALC	Allow NULL?
71	O_TRNOVRCLASS	Turnover Class	nvarchar	4	0	CHAR	(N' ')	Yes		FICO_OTRNOVRCLASS	Allow NULL?
72	O_TRNOVRCLBASE	Balancing Method	nvarchar	2	0	NUMC	(N'00')	Yes		FICO_OTRNOVRCLBASE	Allow NULL?
73	O_BALANCECATG	Balance Category	nvarchar	2	0	NUMC	(N'00')	Yes		FICO_OBALANCECATG	Allow NULL?
74	O_BALANCEBASE	Basis of Balances	nvarchar	2	0	NUMC	(N'00')	Yes		FICO_OBALANCEBASE	Allow NULL?
75	O_PERIODCATG	Period Category	nvarchar	2	0	NUMC	(N'00')	Yes		FICO_OPERIODCATG	Allow NULL?
76	O_BASEREFEVAL	Calculation Basis	nvarchar	10	0	CHAR	(N' ')	Yes		FICO_OBASEREFEVAL	Allow NULL?
77	O_DATECATG	Date Category	nvarchar	6	0	CHAR	(N' ')	Yes	FICOB_DATE	FICO_ODATECATG	Allow NULL?
78	N_REPPERIOD	Repetition period	int	10	0	INT4	((0))	Yes		FICO_NREPPERIOD	Allow NULL?
79	O_REPUNIT	Repetition Unit	char	1	0	CHAR	(N' ')	Yes		FICO_OREPUNIT	Allow NULL?
80	O_KEYDATE	Key Date	nvarchar	2	0	NUMC	(N'00')	Yes		FICO_OKEYDATE	Allow NULL?
81	D_STARTDATE	First Calculation Date for Date Update	nvarchar	8	0	DATS	(N'00000000')	Yes		FICO_DSTARTDATE	Allow NULL?
82	F_STARTDATEINC	Inclusive Indicator	char	1	0	CHAR	(N' ')	Yes		FICO_FSTARTDATEINC	Allow NULL?
83	F_STARTDATEULT	Month-End Indicator for Start Date	char	1	0	CHAR	(N' ')	Yes		FICO_FSTARTDATEULT	Allow NULL?
84	O_DATERULE	Update Rule	nvarchar	2	0	NUMC	(N'00')	Yes		FICO_ODATERULE	Allow NULL?
85	O_PULLDATE	Shift Due Date	nvarchar	2	0	CHAR	(N' ')	Yes		FICO_OPULLDATE	Allow NULL?
86	O_RHYTHMCATG	Frequency Category	char	1	0	CHAR	(N' ')	Yes		FICO_ORHYTHMCATG	Allow NULL?
87	O_REFSTARTDATE	Reference Date for Start Date	nvarchar	4	0	NUMC	(N'0000')	Yes		FICO_OREFSTARTDATE	Allow NULL?
88	N_REFSTARTNUM	Shift of Reference Date for Start Date: Number of Units	nvarchar	3	0	NUMC	(N'000')	Yes		FICO_NREFSTARTNUM	Allow NULL?
89	U_REFSTARTUNIT	Shift of Reference Date for Start Date: Unit	char	1	0	NUMC	(N'0')	Yes		FICO_UREFSTARTUNIT	Allow NULL?
90	F_FIXEDPERIOD	Update With Fixed Periods	char	1	0	CHAR	(N' ')	Yes		FICO_FFIXEDPERIOD	Allow NULL?
91	O_RELDATECATG	Reference Date Category	nvarchar	6	0	CHAR	(N' ')	Yes	FICOB_DATE	FICO_ORELDATECATG	Allow NULL?
92	O_RELDATESHIFT	Reference Date After Working Day Shift	char	1	0	CHAR	(N' ')	Yes		FICO_ORELDATESHIFT	Allow NULL?
93	O_REL_MISC	Reference Category for Date Category Adjustment	char	1	0	CHAR	(N' ')	Yes		FICO_ORELMISC	Allow NULL?
94	O_CAL1	Calendar 1	nvarchar	2	0	CHAR	(N' ')	Yes	TFACD	FICO_OCAL1	Allow NULL?
95	O_CAL2	Calendar 2	nvarchar	2	0	CHAR	(N' ')	Yes	TFACD	FICO_OCAL2	Allow NULL?
96	O_CAL3	Calendar 3	nvarchar	2	0	CHAR	(N' ')	Yes	TFACD	FICO_OCAL3	Allow NULL?
97	O_CAL5	Calendar 4	nvarchar	2	0	CHAR	(N' ')	Yes	TFACD	FICO_OCAL5	Allow NULL?
98	O_CAL6	Calendar 5	nvarchar	2	0	CHAR	(N' ')	Yes	TFACD	FICO_OCAL6	Allow NULL?
99	O_KEYDATES40	Multiple Key Dates, CHAR Field With One Character Per Day	nvarchar	40	0	CHAR	(N' ')	Yes		FICO_OKEYDATES40	Allow NULL?
100	O_DIFFCATG	Differentiation Category	nvarchar	3	0	CHAR	(N' ')	Yes	*	FICO_ODIFFCATG_0	Allow NULL?
101	I_DIFFVALUE	Differentiation value	nvarchar	10	0	CHAR	(N' ')	Yes		FICO_IDIFFVALUE	Allow NULL?
102	O_DIFFCATG_1	Differentiation Category	nvarchar	3	0	CHAR	(N' ')	Yes	*	FICO_ODIFFCATG_1	Allow NULL?
103	I_DIFFVALUE_1	Differentiation value	nvarchar	10	0	CHAR	(N' ')	Yes		FICO_IDIFFVALUE	Allow NULL?
104	O_DIFFCATG_2	Differentiation Category	nvarchar	3	0	CHAR	(N' ')	Yes	*	FICO_ODIFFCATG_2	Allow NULL?
105	I_DIFFVALUE_2	Differentiation value	nvarchar	10	0	CHAR	(N' ')	Yes		FICO_IDIFFVALUE	Allow NULL?
106	O_DIFFCATG_3	Differentiation Category	nvarchar	3	0	CHAR	(N' ')	Yes	*	FICO_ODIFFCATG_3	Allow NULL?
107	I_DIFFVALUE_3	Differentiation value	nvarchar	10	0	CHAR	(N' ')	Yes		FICO_IDIFFVALUE	Allow NULL?
108	O_DIFFCATG_4	Differentiation Category	nvarchar	3	0	CHAR	(N' ')	Yes	*	FICO_ODIFFCATG_4	Allow NULL?
109	I_DIFFVALUE_4	Differentiation value	nvarchar	10	0	CHAR	(N' ')	Yes		FICO_IDIFFVALUE	Allow NULL?
110	X_CREATEUSER	Created by	nvarchar	12	0	CHAR	(N' ')	Yes		FICO_XCREATEUSER	Allow NULL?
111	D_CREATEDATE	Created on	nvarchar	8	0	DATS	(N'00000000')	Yes		FICO_DCREATEDATE	Allow NULL?
112	T_CREATETIME	Creation Time	nvarchar	6	0	TIMS	(N'000000')	Yes		FICO_TCREATETIME	Allow NULL?
113	X_CHANGEUSER	Last changed by	nvarchar	12	0	CHAR	(N' ')	Yes		FICO_XCHANGEUSER	Allow NULL?
114	D_CHANGEDATE	Changed on	nvarchar	8	0	DATS	(N'00000000')	Yes		FICO_DCHANGEDATE	Allow NULL?
115	T_CHANGETIME	Changed at	nvarchar	6	0	TIMS	(N'000000')	Yes		FICO_TCHANGETIME	Allow NULL?
116	X_RELEASEUSER	Released by	nvarchar	12	0	CHAR	(N' ')	Yes		FICO_XRELEASEUSER	Allow NULL?
117	D_RELEASEDATE	Released on	nvarchar	8	0	DATS	(N'00000000')	Yes		FICO_DRELEASEDATE	Allow NULL?
118	T_RELEASETIME	Released at	nvarchar	6	0	TIMS	(N'000000')	Yes		FICO_TRELEASETIME	Allow NULL?
119	D_VALIDTO_ARCHIV	Valid-to Date (Calculated) for Archiving	nvarchar	8	0	DATS	(N'00000000')	Yes		FICO_DVALIDTO_ARCHIVE	Allow NULL?
120	ARCHIVE_STATUS	Archivability Status	char	1	0	CHAR	(N' ')	Yes		AFX_DTE_ARCHIVE_STATUS	Allow NULL?
121	ARCHIVE_FLUD	Resubmission Date	nvarchar	8	0	DATS	(N'00000000')	Yes		AFX_DTE_ARCHIVE_FLUD	Allow NULL?
122	I_FLDLSTID	Field List	varbinary	16	0	RAW		Yes		FICO_IFLDLSTID

Name	Primary	Unique	Type	Columns
FICOT_CONDI~0	Yes	Yes	CLUSTERED	I_COMP, I_LIST, MANDT
FICOT_CONDI~I01	No	No	NONCLUSTERED	D_VALIDFROM, O_STATUS, I_COND, I_LIST, I_EXTLINK, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

122 COLUMNS | 2 INDEXES | ERP 6.0 | FICOT_CONDI TABLE

TOP ERP 6.0 | FICOT_CONDI COLUMNS

TOP ERP 6.0 | FICOT_CONDI INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

122 COLUMNS | 2 INDEXES | ERP 6.0 | FICOT_CONDI TABLE

TOPERP 6.0 | FICOT_CONDI COLUMNS

TOPERP 6.0 | FICOT_CONDI INDEXES

TOP ERP 6.0 | FICOT_CONDI COLUMNS

TOP ERP 6.0 | FICOT_CONDI INDEXES