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

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	RUNID	HR B2A: Global Object ID	nvarchar	32	0	Allow NULL?
3	PERNR	Personnel number	nvarchar	8	0	Allow NULL?
4	SRNO	Super Stream Unique running sequence number	nvarchar	10	0	Allow NULL?
5	STATUS	Status of Record	nvarchar	2	0	Allow NULL?
6	SEQNR	Sequence Number	nvarchar	5	0	Allow NULL?
7	IABKRS	Payroll Area	nvarchar	2	0	Allow NULL?
8	INPER	In-period for payroll	nvarchar	6	0	Allow NULL?
9	FPPER	For-period for garnishment	nvarchar	6	0	Allow NULL?
10	PAYTY	Payroll type	char	1	0	Allow NULL?
11	PAYID	Payroll Identifier	char	1	0	Allow NULL?
12	BONDT	Off-cycle payroll payment date	nvarchar	8	0	Allow NULL?
13	PAYDT	Pay date for payroll result	nvarchar	8	0	Allow NULL?
14	SDATE	Date of updation of Record	nvarchar	8	0	Allow NULL?
15	STIME	Time of update of record	nvarchar	6	0	Allow NULL?
16	SUSER	User Name	nvarchar	12	0	Allow NULL?
17	PRN2	Payment Reference Number	nvarchar	18	0	Allow NULL?
18	FCODE	Superannuation Fund Code	nvarchar	4	0	Allow NULL?
19	NEGSP	Negatives Supported	nvarchar	5	0	Allow NULL?
20	FILID	FILE ID	nvarchar	50	0	Allow NULL?
21	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
22	LINID	LINE ID	nvarchar	8	0	Allow NULL?
23	SOUID	Source Entity ID	nvarchar	11	0	Allow NULL?
24	SOENT	Source Entity ID Type	nvarchar	40	0	Allow NULL?
25	SOADD	Source Electronic Service Address	nvarchar	120	0	Allow NULL?
26	ERMSG	Electronic Error Messaging	nvarchar	10	0	Allow NULL?
27	SEABN	HR AU: Super Stream Source ABN	nvarchar	11	0	Allow NULL?
28	SORGN	Sender Organization Name	nvarchar	120	0	Allow NULL?
29	SFNAM	Sender Family Name	nvarchar	40	0	Allow NULL?
30	SGNAM	Sender Given Name	nvarchar	40	0	Allow NULL?
31	SONAM	Sender Other Given Name	nvarchar	40	0	Allow NULL?
32	SEMAL	Sender E-mail Address Text	nvarchar	120	0	Allow NULL?
33	STELN	Telephone Contact Number	nvarchar	10	0	Allow NULL?
34	PAABN	Payer ABN	nvarchar	11	0	Allow NULL?
35	PORGN	Payer Organization Name	nvarchar	60	0	Allow NULL?
36	PABSB	Bank State Branch Number	nvarchar	15	0	Allow NULL?
37	PAACN	Financial Institution Account Number	nvarchar	20	0	Allow NULL?
38	PACNT	Financial Institution Account Name	nvarchar	40	0	Allow NULL?
39	PYABN	HR AU: Super Stream Target ABN	nvarchar	11	0	Allow NULL?
40	PYUSI	Unique Superannuation Identification Number	nvarchar	14	0	Allow NULL?
41	PYORG	Fund Organization Name	nvarchar	60	0	Allow NULL?
42	PYTAD	End Point URL	nvarchar	120	0	Allow NULL?
43	PYMTH	Payment Method	nvarchar	15	0	Allow NULL?
44	TRNDT	Payment Date	nvarchar	8	0	Allow NULL?
45	PRNUM	Payment Reference Number	nvarchar	18	0	Allow NULL?
46	BPAYC	BPay Biller Code	nvarchar	10	0	Allow NULL?
47	PYAMT	Super Stream Payment Amount	decimal	13	2
48	PYBSB	Bank State Branch Number	nvarchar	15	0	Allow NULL?
49	PYACN	Financial Institution Account Number	nvarchar	20	0	Allow NULL?
50	PYACT	Financial Institution Account Name	nvarchar	40	0	Allow NULL?
51	ERABN	Employer ABN	nvarchar	11	0	Allow NULL?
52	LOCID	Location ID	nvarchar	3	0	Allow NULL?
53	EORGN	Employer Organizational Name Text	nvarchar	40	0	Allow NULL?
54	FNDGE	Superannuation Fund Generated Employer Identifier	nvarchar	20	0	Allow NULL?
55	TAXFN	Tax File Number (TFN)	nvarchar	9	0	Allow NULL?
56	NTITL	Person Name Title Text	nvarchar	15	0	Allow NULL?
57	NSUFX	Person Name Suffix text	nvarchar	15	0	Allow NULL?
58	PFNAM	Member Family Name	nvarchar	40	0	Allow NULL?
59	PGNAM	Member Given Name	nvarchar	40	0	Allow NULL?
60	PONAM	Member Other Given Name	nvarchar	40	0	Allow NULL?
61	SEXCD	Sex Code	nvarchar	7	0	Allow NULL?
62	BDATE	Date of Birth	nvarchar	8	0	Allow NULL?
63	ADRCO	Address Usage Code	nvarchar	4	0	Allow NULL?
64	ADDL1	Address Details Line 1 Text	nvarchar	70	0	Allow NULL?
65	ADDL2	Address Details Line 2 Text	nvarchar	70	0	Allow NULL?
66	ADDL3	Address Details Line 3 Text	nvarchar	70	0	Allow NULL?
67	ADDL4	Address Details Line 4 Text	nvarchar	70	0	Allow NULL?
68	LOCNM	Locality Name Text	nvarchar	70	0	Allow NULL?
69	PSTCD	Postal Code	nvarchar	10	0	Allow NULL?
70	STACO	State or Territory Code	nvarchar	70	0	Allow NULL?
71	CNTRY	Country Key	nvarchar	3	0	Allow NULL?
72	MEMAL	E-mail Address	nvarchar	120	0	Allow NULL?
73	MEMTL	Member Telephone Minimal Number Landline	nvarchar	10	0	Allow NULL?
74	MEMMB	Member Telephone Minimal Number Mobile	nvarchar	10	0	Allow NULL?
75	MEMID	Member Client Identifier	nvarchar	20	0	Allow NULL?
76	PAYNO	Payroll Number Identifier	nvarchar	8	0	Allow NULL?
77	EMPEN	Employee Employment End date	nvarchar	8	0	Allow NULL?
78	EMPET	Employment End Reason Text	nvarchar	30	0	Allow NULL?
79	PSTDT	Pay Period Start Date	nvarchar	8	0	Allow NULL?
80	PENDT	Pay Period End Date	nvarchar	8	0	Allow NULL?
81	SAGAM	Employer Super Annuation Guarantee Amount	decimal	13	2
82	AWDAM	Employer Contributions Award Or Productivity Amount	decimal	13	2
83	PCONT	Employee Personal Contributions Amount	decimal	13	2
84	SALSC	Employer Contributions Salary Sacrificed Amount	decimal	13	2
85	VOLAM	Employer Voluntary contribution amount	decimal	13	2
86	SPCON	Spouse Contribution Amount	decimal	13	2
87	CHCON	Child Contribution Amount	decimal	13	2
88	OTCON	Third Party Contribution Amount	decimal	13	2
89	EMSTD	Employment Start Date	nvarchar	8	0	Allow NULL?
90	ATWRK	At Work Indicator	nvarchar	7	0	Allow NULL?
91	ANBEN	Annual Salary for Benefits Amount	decimal	13	2
92	ANCON	Annual Salary for Contributions Amount	decimal	13	2
93	ACONS	Super Contribution Start Date	nvarchar	8	0	Allow NULL?
94	ACONE	Super Contribution End Date	nvarchar	8	0	Allow NULL?
95	AINAM	Annual Salary for Insurance Amount	decimal	13	2
96	WHRSW	Weekly Hours Worked Number	decimal	5	2
97	OCCUD	Occupation Description	nvarchar	40	0	Allow NULL?
98	INSIN	Insurance Opt Out Indicator	nvarchar	10	0	Allow NULL?
99	FNDRG	Super Fund Registration Date	nvarchar	8	0	Allow NULL?
100	BENCT	Benefit Category	nvarchar	120	0	Allow NULL?
101	EMPST	HR AU: Employment Status Of Employee	nvarchar	20	0	Allow NULL?
102	COSDT	Super Contribution Commence Date	nvarchar	8	0	Allow NULL?
103	COEDT	Super Contribution Cease Date	nvarchar	8	0	Allow NULL?
104	MEMRT	Member Registration Text	nvarchar	40	0	Allow NULL?
105	MPRTX	Defined Benefit Member Pre Tax Contribution	decimal	13	2
106	MPOTC	Defined Benefit Member Post Tax Contribution	decimal	13	2
107	DBERC	Defined Benefit Employer Contribution	decimal	13	2
108	NMPRT	Defined Benefit Notional Member Pre Tax Contribution	decimal	13	2
109	NMPOT	Defined Benefit Notional Member Post Tax Contribution	decimal	13	2
110	NOERC	Defined Benefit Notional Employer Contribution	decimal	13	2
111	ORTER	Ordinary Time Earnings	decimal	13	2
112	APSWE	Actual Periodic Salary or Wages Earned	decimal	13	2
113	SUAPD	Superannuable Allowances Paid	decimal	13	2
114	NSUAP	Notional Superannuable Allowances	decimal	13	2
115	SERFR	Service Fraction	decimal	6	5
116	SERED	Service Fraction Effective Date	nvarchar	8	0	Allow NULL?
117	FUTHR	Full Time Hours	decimal	7	3
118	CONHR	Contracted Hours	decimal	7	3
119	ACHRP	Actual Hours Paid	decimal	7	3
120	EMLOC	Employee Location Identifier	nvarchar	20	0	Allow NULL?
121	DSERF	Defined Benefits Registration Service Fraction	decimal	6	5
122	DSERS	Service Fraction Start Date	nvarchar	8	0	Allow NULL?
123	DSERE	Service Fraction End Date	nvarchar	8	0	Allow NULL?
124	EMPRT	Defined Benefit Employer Rate	decimal	5	2
125	EMPRS	Defined Benefit Employer Rate Start Date	nvarchar	8	0	Allow NULL?
126	EMPRE	Defined Benefit Employer Rate End Date	nvarchar	8	0	Allow NULL?
127	MERAT	Defined Benefit Member Rate	decimal	5	2
128	MERAS	Defined Benefit Member Rate Start Date	nvarchar	8	0	Allow NULL?
129	MERAE	Defined Benefit Member Rate End Date	nvarchar	8	0	Allow NULL?
130	ANSA1	Defined Benefit Annual Salary 1	decimal	13	2
131	ANSD1	Defined Benefit Annual Salary 1 Start Date	nvarchar	8	0	Allow NULL?
132	ANSE1	Defined Benefit Annual Salary 1 End Date	nvarchar	8	0	Allow NULL?
133	ANSA2	Defined Benefit Annual Salary 2	decimal	13	2
134	ANSD2	Defined Benefit Annual Salary 2 Start Date	nvarchar	8	0	Allow NULL?
135	ANSE2	Defined Benefit Annual Salary 2 End Date	nvarchar	8	0	Allow NULL?
136	ANSA3	Defined Benefit Annual Salary 3	decimal	13	2
137	ANSD3	Defined Benefit Annual Salary 3 Start Date	nvarchar	8	0	Allow NULL?
138	ANSE3	Defined Benefit Annual Salary 3 End Date	nvarchar	8	0	Allow NULL?
139	ANSA4	Defined Benefit Annual Salary 4	decimal	13	2
140	ANSD4	Defined Benefit Annual Salary 4 Start Date	nvarchar	8	0	Allow NULL?
141	ANSE4	Defined Benefit Annual Salary 4 End Date	nvarchar	8	0	Allow NULL?
142	ANSA5	Defined Benefit Annual Salary 5	decimal	13	2
143	ANSD5	Defined Benefit Annual Salary 5 Start Date	nvarchar	8	0	Allow NULL?
144	ANSE5	Defined Benefit Annual Salary 5 End Date	nvarchar	8	0	Allow NULL?
145	LWPCD	Leave Without Pay Code	char	1	0	Allow NULL?
146	LWPCS	Leave Without Pay Code Start Date	nvarchar	8	0	Allow NULL?
147	LWPCE	Leave Without Pay Code End Date	nvarchar	8	0	Allow NULL?
148	ASIED	Annual Salary for Insurance Effective Date	nvarchar	8	0	Allow NULL?
149	ASBED	Annual Salary for Benefits Effective Date	nvarchar	8	0	Allow NULL?
150	EMSED	Employee Status Effective Date	nvarchar	8	0	Allow NULL?
151	EBEND	Employee Benefit Category Effective Date	nvarchar	8	0	Allow NULL?
152	DEMLC	Employee Location Identifier	nvarchar	20	0	Allow NULL?
153	DEMLS	Employee Location Identifier Start Date	nvarchar	8	0	Allow NULL?
154	DEMLE	Employee Location Identifier End Date	nvarchar	8	0	Allow NULL?

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

154 COLUMNS | 1 INDEXES | ERP 6.0 | T5Q_SUPERSTREAM TABLE

TOP ERP 6.0 | T5Q_SUPERSTREAM COLUMNS

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

154 COLUMNS | 1 INDEXES | ERP 6.0 | T5Q_SUPERSTREAM TABLE

TOPERP 6.0 | T5Q_SUPERSTREAM COLUMNS

TOPERP 6.0 | T5Q_SUPERSTREAM INDEXES

TOP ERP 6.0 | T5Q_SUPERSTREAM COLUMNS

TOP ERP 6.0 | T5Q_SUPERSTREAM INDEXES