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	OINM	101	Whse Journal
6	OVPM	154	Outgoing Payments
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
Industry Specific :: Clinical System
1	ERP EHP7	6.0	N1MEORDER	106	8	IS-H*MED: Medication, Medication Order	Clinical System

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	MEORDID	Medication: Order - Order Number	nvarchar	10	0	Allow NULL?
3	EINRI	Institution	nvarchar	4	0	Allow NULL?
4	PATNR	IS-H: Patient Number	nvarchar	10	0	Allow NULL?
5	FALNR	IS-H: Case Number	nvarchar	10	0	Allow NULL?
6	MOTX	Medication: Description of Order	nvarchar	60	0	Allow NULL?
7	MOSTX	Medication: Order - Comment	nvarchar	80	0	Allow NULL?
8	MOLTX	Indicator that Long Text Exists	char	1	0	Allow NULL?
9	ORGFA	Medication: Ordering Departmental Org. Unit	nvarchar	8	0	Allow NULL?
10	ORGPF	Medication: Order - Ordering Organizational Unit	nvarchar	8	0	Allow NULL?
11	MOTYPID	Medication: Type of Order	nvarchar	2	0	Allow NULL?
12	MOSID	Medication: Status ID for Status of Medication Order	nvarchar	3	0	Allow NULL?
13	APDEV	Medication: Administration Device ID	nvarchar	3	0	Allow NULL?
14	PHFORM	Medication: ID Dosage Form	nvarchar	3	0	Allow NULL?
15	APROU	Medication: ID Administration Route	nvarchar	3	0	Allow NULL?
16	MOVDF	Medication: Order - Valid From Date	nvarchar	8	0	Allow NULL?
17	MOVTF	Medication: Valid From Time	nvarchar	6	0	Allow NULL?
18	MOVDT	Medication: Order - Valid To Date	nvarchar	8	0	Allow NULL?
19	MOVTT	Medication: Order - Valid To Time	nvarchar	6	0	Allow NULL?
20	ORDUR	Medication: Order - Order Duration	decimal	12	3
21	ORDURU	Medication: Order Duration Unit	nvarchar	3	0	Allow NULL?
22	EXTD	Medication: Change in MO Validity	char	1	0	Allow NULL?
23	MEDGRPID	Medication: Drug Category Key	nvarchar	3	0	Allow NULL?
24	MOSUBTY	Medication: Order - Subscreen Type	nvarchar	2	0	Allow NULL?
25	MORESP1	Medication: Order - Employee Responsible	nvarchar	10	0	Allow NULL?
26	MORESP2	Medication: Order - Consulting EmR - OBSOLETE	nvarchar	10	0	Allow NULL?
27	MOCONSOU	Medication: Order - Consulting OU - OBSOLETE	nvarchar	8	0	Allow NULL?
28	INSTX	Medication: Order - Preparation Directions	nvarchar	80	0	Allow NULL?
29	INLTX	Indicator that Long Text Exists	char	1	0	Allow NULL?
30	ABSG	Termination Reason	nvarchar	10	0	Allow NULL?
31	MOPRINT	Medication: Order - Internal Priority	nvarchar	3	0	Allow NULL?
32	MEOEXT	Medication: Order - External Medication	char	1	0	Allow NULL?
33	MEOEXTCC	Medication: Relevant for Clinical Checking	char	1	0	Allow NULL?
34	EXT_DRUGID	Medication: External Drug ID	nvarchar	32	0	Allow NULL?
35	MPRESNR	Medication - Order Profile ID	nvarchar	10	0	Allow NULL?
36	MEPSNR	Medication: Sequence Number Order Profile	nvarchar	3	0	Allow NULL?
37	MEPSSTX	Medication: Sequence Text Order Profile	nvarchar	80	0	Allow NULL?
38	MEPSLTX	Indicator that Long Text Exists	char	1	0	Allow NULL?
39	ORIGIN	Medication: Order - Original Order ID - OBSOLETE	nvarchar	10	0	Allow NULL?
40	MOPRN	Medication: Order - PRN Indicator	char	1	0	Allow NULL?
41	PRNCSTX	Medication: Order - Check Condition	nvarchar	80	0	Allow NULL?
42	PRNCLTX	Indicator that Long Text Exists	char	1	0	Allow NULL?
43	OLDIS	Medication: Order - Take Home Medication - OBSOLETE	char	1	0	Allow NULL?
44	SLDOSE	Medication: Orders - Sliding Dose	char	1	0	Allow NULL?
45	IVTYPE	Medication: Order - Infusion Type	char	1	0	Allow NULL?
46	RECUP	Medication: Order - Flag: Recipe Updated - OBSOLETE	char	1	0	Allow NULL?
47	STRGTHDOS	Medication: Order - Dosage Type	char	1	0	Allow NULL?
48	SELTYP	Medication: Order - Selection Type - OBSOLETE	char	1	0	Allow NULL?
49	PATWGT	Medication: Order - Patient Weight	decimal	12	3
50	PATWGTU	Medication: Order - Patient Weight Unit	nvarchar	3	0	Allow NULL?
51	PATHGT	Medication: Order - Patient Height	decimal	12	3
52	PATHGTU	Medication: Order - Patient Height Unit	nvarchar	3	0	Allow NULL?
53	CALCUD	Medication: Order - Calculation Factor	char	1	0	Allow NULL?
54	PCALOCK	Medication: PCA Lock Duration	decimal	12	3
55	PCALOCKU	Medication: Order - PCA Lock Duration Unit	nvarchar	3	0	Allow NULL?
56	PCAMAX	Medication: PCA Number of Boli	tinyint	3	0
57	PCAPER	Medication: Time Number of Boli	decimal	12	3
58	PCAPERU	Medication: Time Unit Number of Boli	nvarchar	3	0	Allow NULL?
59	COMPDOS	Medication: Dose Type for Compound	char	1	0	Allow NULL?
60	AL	Medication: Localization ID	nvarchar	4	0	Allow NULL?
61	CHDVER	Medication: Order - Change Attribute Check	char	1	0	Allow NULL?
62	RCUSE	Medication: Order - Reason for Usage	nvarchar	5	0	Allow NULL?
63	DC_USED	Medication: Order - Dose Calculator Used	char	1	0	Allow NULL?
64	VFCOIND	Medication: Check Condition to Be Checked	char	1	0	Allow NULL?
65	ADOUTPAT	Medication: Administration in IP/OC - OBSOLETE	char	1	0	Allow NULL?
66	OUPREP	Medication: Preparation Fill Source Indicator	char	1	0	Allow NULL?
67	FIXQUAN	Medication: Order Ind. for Fixed Recipe Qty for Compounds	char	1	0	Allow NULL?
68	MEFALAR	IS-H: Case Type	char	1	0	Allow NULL?
69	ERUSR	IS-H: Name of Employee who Created Record	nvarchar	12	0	Allow NULL?
70	ERDAT	IS-H: Date when Record Created	nvarchar	8	0	Allow NULL?
71	ERTIM	IS-H: Time Record Created	nvarchar	6	0	Allow NULL?
72	UPUSR	IS-H: Name of Person who Last Changed Data	nvarchar	12	0	Allow NULL?
73	UPDAT	IS-H: Date of Last Change	nvarchar	8	0	Allow NULL?
74	UPTIM	IS-H: Time of Last Change	nvarchar	6	0	Allow NULL?
75	STORN	IS-H: Cancellation Indicator	char	1	0	Allow NULL?
76	STUSR	IS-H: Name of User who Canceled Data Record	nvarchar	12	0	Allow NULL?
77	STDAT	Date of Cancellation	nvarchar	8	0	Allow NULL?
78	STOID	Reason for Canceling Medical Object	nvarchar	3	0	Allow NULL?
79	NMRF	Medication: Number of Repeats	nvarchar	4	0	Allow NULL?
80	INPAT_ALLOWED	Medication: Inpatient Case Type Allowed - OBSOLETE	char	1	0	Allow NULL?
81	DAYPAT_ALLOWED	Medication: Day Patient Case Type Allowed - OBSOLETE	char	1	0	Allow NULL?
82	OUTPAT_ALLOWED	Medication: Outpatient Case Type Allowed - OBSOLETE	char	1	0	Allow NULL?
83	IMDOSE	Medication: Order - Immediate Dose	char	1	0	Allow NULL?
84	PURPOSE	Medication: Purpose of Order	char	1	0	Allow NULL?
85	DISPQUAN	Medication: Drug Dispensing Quantity	decimal	24	12
86	DISPQUANU	Medication: Dispensing Quantity Unit	nvarchar	3	0	Allow NULL?
87	TPID	Medication: ID Order Template	nvarchar	10	0	Allow NULL?
88	DURMETH	Medication: Determination Type of Order Validity	char	1	0	Allow NULL?
89	VALTIME	Medication: Validation Time	decimal	15	0
90	VALVMA	Employee Responsible	nvarchar	10	0	Allow NULL?
91	ENDORIGIN	Medication: Reason ID	nvarchar	5	0	Allow NULL?
92	ORMOVDT	Medication: End Date Before Order Sequence	nvarchar	8	0	Allow NULL?
93	ORMOVTT	Medication: End Time Before Order Sequence	nvarchar	6	0	Allow NULL?
94	PDUR	Medication: Planned Duration	decimal	12	3
95	PDURU	Medication: Administration Duration Unit	nvarchar	3	0	Allow NULL?
96	DOSDEF	Medication: Simplified Dose Definition	nvarchar	400	0	Allow NULL?
97	DCM	Medication: Dose Calculation Method	char	1	0	Allow NULL?
98	DELAY	Medication: Delayed Order Start	nvarchar	8	0	Allow NULL?
99	DELAYU	Medication: Unit of Delayed Order Start	nvarchar	3	0	Allow NULL?
100	FIXEDDELAY	Medication: Fix Delayed Order Start	char	1	0	Allow NULL?
101	SPECREQ	Medication: Special Request Indicator	char	1	0	Allow NULL?
102	AUTIDEM	Indicator for Allowed Drug Substitution	char	1	0	Allow NULL?
103	EMORD	Medication - Emergency Order	char	1	0	Allow NULL?
104	COUNTDAY	Medication - Treatment Start Day	nvarchar	3	0	Allow NULL?
105	PDUR_MODE	Medication: Calculation Method Duration/Flow Rate	char	1	0	Allow NULL?
106	THERAPY_REC	Medication: Indicator for Therapy Recommendations	char	1	0	Allow NULL?

Name	Primary	Unique	Type	Columns
N1MEORDER~0	Yes	Yes	CLUSTERED	MEORDID, MANDT
N1MEORDER~001	No	No	NONCLUSTERED	FALNR, EINRI, MANDT
N1MEORDER~002	No	No	NONCLUSTERED	PATNR, MANDT
N1MEORDER~003	No	No	NONCLUSTERED	MOVDF, EINRI, MANDT
N1MEORDER~004	No	No	NONCLUSTERED	MOVDT, EINRI, MANDT
N1MEORDER~005	No	No	NONCLUSTERED	MPRESNR, EINRI, MANDT
N1MEORDER~008	No	No	NONCLUSTERED	ERUSR, EINRI, MANDT
N1MEORDER~009	No	No	NONCLUSTERED	ERDAT, EINRI, 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

106 COLUMNS | 8 INDEXES | ERP 6.0 | N1MEORDER TABLE

TOP ERP 6.0 | N1MEORDER COLUMNS

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

106 COLUMNS | 8 INDEXES | ERP 6.0 | N1MEORDER TABLE

TOPERP 6.0 | N1MEORDER COLUMNS

TOPERP 6.0 | N1MEORDER INDEXES

TOP ERP 6.0 | N1MEORDER COLUMNS

TOP ERP 6.0 | N1MEORDER INDEXES