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	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

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	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Financial Services :: Claims Management
1	ERP EHP7	6.0	ICLITEM	76	2	Claim Item	Claims Management

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	CLIENT	Client	nvarchar	3	0	Allow NULL?
2	ACTIVE	Table entry is active (A) or in suspense (S)	char	1	0	Allow NULL?
3	CLAIM	Number of Claim	nvarchar	17	0	Allow NULL?
4	SUBCLAIM	Subclaim	nvarchar	3	0	Allow NULL?
5	ITEM	Claim Item	nvarchar	4	0	Allow NULL?
6	CHANGETIME	Changed: Date + Time	decimal	15	0
7	CHANGEDBY	Changed By	nvarchar	12	0	Allow NULL?
8	DELETED	Database Line Status (Original, Changed, Deleted)	char	1	0	Allow NULL?
9	ITEMCAT	Claim Item Category	nvarchar	2	0	Allow NULL?
10	ITEMTYPE	Claim Item Object Type	nvarchar	3	0	Allow NULL?
11	ITEMUSE	Usage Type of Claim Item	nvarchar	2	0	Allow NULL?
12	COVTYPE	Coverage Type	nvarchar	10	0	Allow NULL?
13	BENTYPE	Benefit Type	nvarchar	10	0	Allow NULL?
14	RCOVTYPE	Benefit Coverage Type	nvarchar	10	0	Allow NULL?
15	XWAITPERIOD	Probationary Periods Ignored	char	1	0	Allow NULL?
16	COVERAGE	Coverage	nvarchar	4	0	Allow NULL?
17	SCPOSID_INT	Internal ID of Benefits Catalog Item	nvarchar	32	0	Allow NULL?
18	SERVCAT	ID of a Benefits, Services and Fees Catalog	nvarchar	10	0	Allow NULL?
19	SCPOSID_EXT	ID of a Benefits Catalog Item	nvarchar	20	0	Allow NULL?
20	STATUS	Status of Claim Item	nvarchar	2	0	Allow NULL?
21	REJREASON	Claim Item Rejection Reason	nvarchar	2	0	Allow NULL?
22	MODIFIED	Modified	char	1	0	Allow NULL?
23	PROCURED	Ordered	char	1	0	Allow NULL?
24	CALCULATED	Calculated	char	1	0	Allow NULL?
25	DESCRIPTION	Claim Item Description	nvarchar	40	0	Allow NULL?
26	DAILY	Daily	char	1	0	Allow NULL?
27	WEEKLY	Weekly	char	1	0	Allow NULL?
28	MONTHLY	Monthly	nvarchar	2	0	Allow NULL?
29	TOTAL	Total Number of Benefits	nvarchar	3	0	Allow NULL?
30	VALIDFROM	Claim Item: Valid From	nvarchar	8	0	Allow NULL?
31	VALIDTO	Claim Item: Valid To	nvarchar	8	0	Allow NULL?
32	STARTDATE	Start Date	nvarchar	8	0	Allow NULL?
33	ENDDATE	End Date	nvarchar	8	0	Allow NULL?
34	DNUMBER	Number	decimal	5	0
35	EVALUATION	Valid claim item evaluation	nvarchar	2	0	Allow NULL?
36	EVALCAT	Evaluation Category	nvarchar	2	0	Allow NULL?
37	EVALBASE	Type of Evaluator	nvarchar	3	0	Allow NULL?
38	EVQUANTITY	Claim Item: Number (Days, Visits, Area) for Evaluation	decimal	10	3
39	EVQUANUNIT	Claim Item: Unit of Measurement	nvarchar	3	0	Allow NULL?
40	EVAMTPERUNIT	Amount per Unit	decimal	15	2
41	EVAMOUNT	Evaluated Amount	decimal	15	2
42	EVCURR	Currency of Evaluated Amount	nvarchar	5	0	Allow NULL?
43	FACTOR	Factor	decimal	7	4
44	ACV	Actual Cash Value	decimal	15	2
45	ACVPERCENT	Proportion of Actual Cash Value to Original Cash Value in %	decimal	5	2
46	CALCEXPRESSION	BRFplus Expression for Calculating Payout Amount	nvarchar	20	0	Allow NULL?
47	PERDAY	Amount per Day	decimal	15	2
48	DISCOUNTPERCENT	Discount on Total Invoice Amount in Percent	decimal	5	2
49	XDISCOUNTUSED	Discount Amount from Table Applied with Invoice	char	1	0	Allow NULL?
50	XDISCOUNTPERCENT	Discount Amount Without Reference to Percent Discount	char	1	0	Allow NULL?
51	XDISC_2B_APPLIED	Indicator: Discount to Be Applied	char	1	0	Allow NULL?
52	GROSNET	Flag: Amount Is Net Amount	char	1	0	Allow NULL?
53	TXCOD	Tax Code	nvarchar	2	0	Allow NULL?
54	SUBCLREF	Subclaim to Which a Claim Item Is Assigned	nvarchar	3	0	Allow NULL?
55	PROCUREMENT	ID of Claim Item Grouping	nvarchar	4	0	Allow NULL?
56	ITEM_REF	Claim Item	nvarchar	4	0	Allow NULL?
57	DAMAGEDOBJ	Damaged Object	nvarchar	4	0	Allow NULL?
58	ASSIGN_GUID	UUID of Entry to be Linked	nvarchar	32	0	Allow NULL?
59	REFNO	External Reference Number	nvarchar	15	0	Allow NULL?
60	PDREF	Reference to Purchasing Document	nvarchar	10	0	Allow NULL?
61	PDPOS	Reference to Item Number in Purchasing Document	nvarchar	10	0	Allow NULL?
62	REF_LOCCAT	Reference Location for External Services	nvarchar	2	0	Allow NULL?
63	PTYPE	Transaction Type in Procurement Process	nvarchar	4	0	Allow NULL?
64	XGENEROS	Flag: Ex Gratia Payment?	char	1	0	Allow NULL?
65	ADDITIONAL_ITEM	Additional Claim Item	char	1	0	Allow NULL?
66	ADDIT_ITEM_SUM	Total of Additional Claim Items	char	1	0	Allow NULL?
67	REMUN_TYPE	Remuneration Category	nvarchar	4	0	Allow NULL?
68	BENVALUE	Benefit Value	decimal	15	2
69	XCREATEDMAN	Manually Created Item	char	1	0	Allow NULL?
70	CREATIONREASON	Reason for Manual Creation (ID)	nvarchar	3	0	Allow NULL?
71	XGENLEDGERTP	Internal Clearing	char	1	0	Allow NULL?
72	PERIODICITY	Time Periods	nvarchar	2	0	Allow NULL?
73	ADDDUEDATE	Additional Payment Due Date	nvarchar	12	0	Allow NULL?
74	TOTALVALUEANNUAL	Total Annual Value	decimal	15	2
75	PAYROLLVAR	Settlement Variant for Annuity Disbursement	nvarchar	3	0	Allow NULL?
76	DISBURSETYPE	Disbursement Category for Annuity Disbursement	nvarchar	3	0	Allow NULL?

Name	Primary	Unique	Type	Columns
ICLITEM~0	Yes	Yes	CLUSTERED	ITEM, SUBCLAIM, CLAIM, ACTIVE, CLIENT
ICLITEM~000	No	No	NONCLUSTERED	ITEMCAT, PROCUREMENT, SUBCLAIM, CLAIM, ACTIVE, CLIENT

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

76 COLUMNS | 2 INDEXES | ERP 6.0 | ICLITEM TABLE

TOP ERP 6.0 | ICLITEM COLUMNS

TOP ERP 6.0 | ICLITEM 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

76 COLUMNS | 2 INDEXES | ERP 6.0 | ICLITEM TABLE

TOPERP 6.0 | ICLITEM COLUMNS

TOPERP 6.0 | ICLITEM INDEXES

TOP ERP 6.0 | ICLITEM COLUMNS

TOP ERP 6.0 | ICLITEM INDEXES