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	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
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	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

B1 8.8: Top 10 requests

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

	Product	Version	Table	Columns	Indexes	Description	Module
Financial Services :: Claims Management
1	ERP EHP7	6.0	ICLSUBCL	52	2	Subclaim	Claims Management

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	CLIENT	Client	nvarchar	3	Allow NULL?
2	ACTIVE	Table entry is active (A) or in suspense (S)	char	1	Allow NULL?
3	CLAIM	Number of Claim	nvarchar	17	Allow NULL?
4	SUBCLAIM	Subclaim	nvarchar	3	Allow NULL?
5	CHANGETIME	Changed: Date + Time	decimal	15
6	CHANGEDBY	Changed By	nvarchar	12	Allow NULL?
7	DELETED	Database Line Status (Original, Changed, Deleted)	char	1	Allow NULL?
8	CREATEDBY	Created By	nvarchar	12	Allow NULL?
9	CREATETIME	Created: Date + Time	decimal	15
10	STATUS	Status of Subclaim	nvarchar	2	Allow NULL?
11	STATUSCHG	Time of Last Status Change	decimal	15
12	STHANDLER	"Claim Handling" Process Active	char	1	Allow NULL?
13	STNOCLAIM	No Claim Made	char	1	Allow NULL?
14	STCLOSED	"Close (Sub)Claim" Process Executed	char	1	Allow NULL?
15	STINVALID	Subclaim Invalid	char	1	Allow NULL?
16	STREJECT	Claim/Subclaim Rejected	char	1	Allow NULL?
17	STATREASON	Reason for Changing the Status	nvarchar	2	Allow NULL?
18	XCOMPLETE	Flag: Claim Item List (Presumably) Complete	char	1	Allow NULL?
19	SUBCLTYPE	Subclaim Type	nvarchar	4	Allow NULL?
20	XSALVAGE	Flag: Salvage?	char	1	Allow NULL?
21	XOTHERINSURE	Flag: Other Insurance?	char	1	Allow NULL?
22	XSUBRO	Subrogation/Recovery Status	char	1	Allow NULL?
23	SUBRO_POTENTIAL	Subrogation/Recovery Potential of a Subclaim (Check Status)	char	1	Allow NULL?
24	XLITIGATION	Flag: Litigation?	char	1	Allow NULL?
25	XNEGOTIATION	Flag: Negotiation?	char	1	Allow NULL?
26	XFRAUD	Flag: Potential Fraud?	char	1	Allow NULL?
27	COVERAGE	Coverage	nvarchar	4	Allow NULL?
28	COVPOLVNR	Version Number of Coverage Contract	nvarchar	2	Allow NULL?
29	XCOVCONFIRMED	Indication of Compensability	char	1	Allow NULL?
30	ASSIGN_STATE	Assignment Status of a Claim Subobject	nvarchar	2	Allow NULL?
31	HANDLERTYPE	Object Category of Subclaim Handler	nvarchar	2	Allow NULL?
32	CLAIMHANDLER	Claim Handler for Subclaim	nvarchar	12	Allow NULL?
33	HANDLERTYPE_GRP	Object Category of Subclaim Handler Group	nvarchar	2	Allow NULL?
34	CLAIMHANDLER_GRP	Claim Handler Group for Subclaims	nvarchar	12	Allow NULL?
35	COMPLEX	Complexity of Claim/Subclaim	char	1	Allow NULL?
36	SUBCLAIMDESC	Name of Claim/Subclaim	nvarchar	20	Allow NULL?
37	BENTREE	Benefit Type Tree	nvarchar	8	Allow NULL?
38	BENTREEG	Generation of Benefit Type Tree	nvarchar	5	Allow NULL?
39	BENTREEV	Version of Benefit Type Tree	nvarchar	5	Allow NULL?
40	WF_EXEC_TIME	Execution Time Workflow	decimal	15
41	WF_STATUS	Workflow Status	char	1	Allow NULL?
42	ASSIGN_GUID	UUID of Entry to be Linked	nvarchar	32	Allow NULL?
43	MAX_ITEMNR	Current Highest Claim Item Number	nvarchar	4	Allow NULL?
44	OVERRULEREASON	Overruling Reason	nvarchar	3	Allow NULL?
45	BENSTART_DT	Start of Benefit	nvarchar	8	Allow NULL?
46	BENEND_DT	End of Benefit	nvarchar	8	Allow NULL?
47	COMPENSABILITY	Compensability	char	1	Allow NULL?
48	BENCALC_NUM	Sequence Number of Benefit Calculation	nvarchar	20	Allow NULL?
49	INSUREDOBJ	Insured Object Number	nvarchar	4	Allow NULL?
50	ARCHIVE_STATUS	Archiving Status	char	1	Allow NULL?
51	ARCHIVE_FLUD	Resubmission Date	nvarchar	8	Allow NULL?
52	REJECTION	Rejection Reason	nvarchar	2	Allow NULL?

Name	Primary	Unique	Type	Columns
ICLSUBCL~0	Yes	Yes	CLUSTERED	SUBCLAIM, CLAIM, ACTIVE, CLIENT
ICLSUBCL~001	No	No	NONCLUSTERED	STATUS, CLAIMHANDLER, HANDLERTYPE, 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

52 COLUMNS | 2 INDEXES | ERP 6.0 | ICLSUBCL TABLE

TOP ERP 6.0 | ICLSUBCL COLUMNS

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

52 COLUMNS | 2 INDEXES | ERP 6.0 | ICLSUBCL TABLE

TOPERP 6.0 | ICLSUBCL COLUMNS

TOPERP 6.0 | ICLSUBCL INDEXES

TOP ERP 6.0 | ICLSUBCL COLUMNS

TOP ERP 6.0 | ICLSUBCL INDEXES