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	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	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	ICLPROCURE	74	4	Claim Item Groupings	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 of Payment	nvarchar	3	0	Allow NULL?
5	PROCUREMENT	ID of Claim Item Grouping	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	CREATEDBY	Created By	nvarchar	12	0	Allow NULL?
10	CREATETIME	Created: Date + Time	decimal	15	0
11	PDOCTYPE	Benefit Type for Grouping of Lower Level Benefit Types	nvarchar	10	0	Allow NULL?
12	PDOCCAT	Claim Item Grouping Category	nvarchar	2	0	Allow NULL?
13	ISSUEDATE	Date Created	nvarchar	8	0	Allow NULL?
14	RECEIVEDATE	Date Received	nvarchar	8	0	Allow NULL?
15	DATEFROM	Start Date of Period	nvarchar	8	0	Allow NULL?
16	TIMEFROM	Start Time of Claim Item Group	nvarchar	6	0	Allow NULL?
17	DATETO	End Date of Period	nvarchar	8	0	Allow NULL?
18	TIMETO	End Time of Claim Item Group	nvarchar	6	0	Allow NULL?
19	ISSUEDATE_PRESCR	Date Prescription Created Acc. to Invoice	nvarchar	8	0	Allow NULL?
20	ACQUISITIONDATE	Date Entered	nvarchar	8	0	Allow NULL?
21	AMOUNT1	General Amount Field	decimal	15	2
22	CURRENCY	Currency	nvarchar	5	0	Allow NULL?
23	EXTERNALREF	External Reference of Claim Item Grouping	nvarchar	20	0	Allow NULL?
24	EXTDOCUMENT	External Document Number	nvarchar	16	0	Allow NULL?
25	EXTCASENO	Hospital-Internal ID	nvarchar	23	0	Allow NULL?
26	EXTFILENO	HI: External Data Set Identification	nvarchar	20	0	Allow NULL?
27	PROC_REF	Reference to Claim Item Grouping	nvarchar	4	0	Allow NULL?
28	DISCOUNTAMOUNT	Discount on Invoice Amount	decimal	15	2
29	DISCOUNTPERCENT	Discount on Total Invoice Amount in Percent	decimal	5	2
30	ACCIDENT	Accident or Other Reason for Possible Recovery	nvarchar	2	0	Allow NULL?
31	SUBROGATION	Indication Whether Recovery Claim Might Be Involved	nvarchar	2	0	Allow NULL?
32	DUEDATE	Due Date	nvarchar	8	0	Allow NULL?
33	DUEDATE_ORIG	Origin of Due Date	nvarchar	8	0	Allow NULL?
34	STATUS	Status of a Claim Item Grouping	nvarchar	2	0	Allow NULL?
35	STATREASON	Reason for Changing the Status	nvarchar	2	0	Allow NULL?
36	OWNCONTRIB	Copayment	nvarchar	3	0	Allow NULL?
37	REASON	Reason for Creating a Claim Item Grouping	nvarchar	3	0	Allow NULL?
38	CAUSE	Specification of Reason for Creating Claim Item Grouping	nvarchar	2	0	Allow NULL?
39	PDOCCATTYPE	Type of Claim Item Grouping Category	nvarchar	3	0	Allow NULL?
40	SUBCL_ORIG	Original Subclaim Multiple Prescription/Curr.Subclm Appraisl	nvarchar	3	0	Allow NULL?
41	PROC_ORIG	Original Claim Item Grouping of Multiple Prescription	nvarchar	4	0	Allow NULL?
42	DATASOURCE	Data Origin	nvarchar	2	0	Allow NULL?
43	SETORDERDATE	Set Order Date	nvarchar	8	0	Allow NULL?
44	COMPLETIONDATE	Completion Date	nvarchar	8	0	Allow NULL?
45	FEE	Fee	decimal	15	2
46	MATLABCOST	Material and Laboratory Costs	decimal	15	2
47	MATLABCOSTINT	will be deleted.	decimal	15	2
48	ADDCOST	Other Costs	decimal	15	2
49	VALPERUNIT	Value per Unit of Benefits Catalog Item	decimal	20	12
50	SUBSIDYPERCENT	Subsidy in Percent (%)	decimal	5	2
51	SUBSIDYAMOUNT	Subsidy Amount	decimal	15	2
52	SENTUTC	Sent: Date and Time	decimal	15	0
53	SENT_BY_DME	Sent via External Interface (Not Yet Used)	char	1	0	Allow NULL?
54	RECEIPT_BY_DME	Receipt via External Interface	char	1	0	Allow NULL?
55	CANCEL	Status "Cancelled"	char	1	0	Allow NULL?
56	REJECTED	Status "Rejected"	char	1	0	Allow NULL?
57	INSUSPENSE	Status "Pending"	char	1	0	Allow NULL?
58	INPROCESS	Status "In Process"	char	1	0	Allow NULL?
59	RELEASED	Status "Released"	char	1	0	Allow NULL?
60	XFINISHED	Complete/Approved/Finished	char	1	0	Allow NULL?
61	ORDERED	Status "Commissioned"	char	1	0	Allow NULL?
62	TRANSFERRED	Status "Reassigned"	char	1	0	Allow NULL?
63	TOBEAPPROVED	Status "To Be Approved"	char	1	0	Allow NULL?
64	XCLINICCARD	Flag: Clinic Card	char	1	0	Allow NULL?
65	PAYFREQPLAN	Payment Frequency of a Repetitive Payment	nvarchar	2	0	Allow NULL?
66	ASSIGN_GUID	UUID of Entry to be Linked	nvarchar	32	0	Allow NULL?
67	XREQUEST	Indicator: Receivable	char	1	0	Allow NULL?
68	COMPPER_DATEFROM	Comparision Period From	nvarchar	8	0	Allow NULL?
69	COMPPER_DATETO	Comparison Period To	nvarchar	8	0	Allow NULL?
70	PAYOUT_SCENARIO	Repetitive Payment Scenario	char	1	0	Allow NULL?
71	REASONREJ	Rejection Reasons for Payments and Reserves	nvarchar	2	0	Allow NULL?
72	METHOD	Payment Method	char	1	0	Allow NULL?
73	ADDRNUMBER	Address Number for Checks	nvarchar	10	0	Allow NULL?
74	BKID	Bank Details ID	nvarchar	4	0	Allow NULL?

Name	Primary	Unique	Type	Columns
ICLPROCURE~0	Yes	Yes	CLUSTERED	PROCUREMENT, SUBCLAIM, CLAIM, ACTIVE, CLIENT
ICLPROCURE~001	No	No	NONCLUSTERED	EXTERNALREF, CLIENT
ICLPROCURE~002	No	No	NONCLUSTERED	STATUS, PDOCCAT
ICLPROCURE~003	No	No	NONCLUSTERED	DATETO, DATEFROM, PDOCCAT

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

74 COLUMNS | 4 INDEXES | ERP 6.0 | ICLPROCURE TABLE

TOP ERP 6.0 | ICLPROCURE COLUMNS

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

74 COLUMNS | 4 INDEXES | ERP 6.0 | ICLPROCURE TABLE

TOPERP 6.0 | ICLPROCURE COLUMNS

TOPERP 6.0 | ICLPROCURE INDEXES

TOP ERP 6.0 | ICLPROCURE COLUMNS

TOP ERP 6.0 | ICLPROCURE INDEXES