	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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

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

176 COLUMNS | 2 INDEXES | ERP 6.0 | REGUH TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Financial Accounting :: Accounts Payable :: Basic Functions :: Payment Transactions
1	ERP EHP7	6.0	REGUH	176	2	Settlement data from payment program	Payment Transactions

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, LAUFD, LAUFI, XVORL, ZBUKR, LIFNR, KUNNR, EMPFG, VBLNR, AVISG, WAERS, SRTGB, ANRED, NAME1, NAME2, NAME3, NAME4, PSTLZ, ORT01, STRAS, PFACH, LAND1, STCD1, WEVWV, ZANRE, ZNME1, ZNME2, ZNME3, ZNME4, ZPSTL, ZORT1, ZSTRA, ZPFAC, ZLAND, ZREGI, ZBNKS, ZBNKN, ZBNKL, ZBKON, ZBVTY, ZSWIF, XEZER, ZSPRA, ZALDT, RZAWE, RUMSK, RZUMS, HKTID, HBKID, HKTIW, HBKIW, BVTYP, UBKON, UBKNT, UBNKS, UBNKL, UIBAN, UBHKT, VALUT, CRVAL, ANFAE, WEFAE, RBETR, RSKON, RWBTR, RWSKT, RSPE1, RSPE2, RPOST, RTEXT, RSPM1, RSPM2, WEHMX, WEFMX, WEHRS, WEFRS, WEAMX, BUSAB, EIKTO, XINVE, WDATE, XAEND, ZLSPR, DTAWS, DTAMS, KURSF, ABWAE, SKVHW, SKVFW, DSKVH, ZPST2, PAYGR, ZBNKY, UBNKY, PSTL2, ABSBU, RBET2, RBET3, RSKO2, RSKO3, KURS2, KURS3, BKREF, UZAWE, ZORT2, ZTLFX, XSIWE, ZPFOR, PERNR, SEQNR, BTZNR, AUSFD, AUGDT, EDIAV, IDOC_NUM_AVIS, EDIBN, IDOC_NUM, ZTELF, ZTELX, KOINH, DTWS1, DTWS2, DTWS3, DTWS4, ZSTC1, KIDNO, PYORD, REGIO, TEXT, BTYP1, BNKS1, BNKL1, BNKN1, BKON1, BKRF1, IBAN1, BTYP2, BNKS2, BNKL2, BNKN2, BKON2, BKRF2, IBAN2, BTYP3, BNKS3, BNKL3, BNKN3, BKON3, BKRF3, IBAN3, SAKNR, HKONT, ALEBN, XKDFB, SRTBP, FPM_KEY, GRPNO, SRTF1, SRTF2, SRTF3, XCORR, XAVIS, XCOPM, DORIGIN, RFTTRN, ZADNR, ADRNR, ZIBAN, MGUID, SEQ_TYPE, INST_CODE, PURP_CODE, XMLST, TIMESTAMP_AVIS, FM_STATUS, FILE_NBR FROM REGUH

TOP ERP 6.0 | REGUH COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	LAUFD	Date on Which the Program Is to Be Run	nvarchar	8	0	DATS	(N'00000000')	No		LAUFD	Allow NULL?
3	LAUFI	Additional Identification	nvarchar	6	0	CHAR	(N' ')	No		LAUFI	Allow NULL?
4	XVORL	Indicator: Only Proposal Run?	char	1	0	CHAR	(N' ')	No		XVORL	Allow NULL?
5	ZBUKR	Paying company code	nvarchar	4	0	CHAR	(N' ')	No	T001	DZBUKR	Allow NULL?
6	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	CHAR	(N' ')	No	LFA1	LIFNR	Allow NULL?
7	KUNNR	Customer Number	nvarchar	10	0	CHAR	(N' ')	No	KNA1	KUNNR	Allow NULL?
8	EMPFG	Payee code	nvarchar	16	0	CHAR	(N' ')	No		EMPFG	Allow NULL?
9	VBLNR	Document Number of the Payment Document	nvarchar	10	0	CHAR	(N' ')	No		VBLNR	Allow NULL?
10	AVISG	Reason for Printing Payment Advice	char	1	0	CHAR	(N' ')	Yes		AVISG	Allow NULL?
11	WAERS	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
12	SRTGB	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
13	ANRED	Title	nvarchar	15	0	CHAR	(N' ')	Yes		ANRED	Allow NULL?
14	NAME1	Name 1	nvarchar	35	0	CHAR	(N' ')	Yes		NAME1_GP	Allow NULL?
15	NAME2	Name 2	nvarchar	35	0	CHAR	(N' ')	Yes		NAME2_GP	Allow NULL?
16	NAME3	Name 3	nvarchar	35	0	CHAR	(N' ')	Yes		NAME3_GP	Allow NULL?
17	NAME4	Name 4	nvarchar	35	0	CHAR	(N' ')	Yes		NAME4_GP	Allow NULL?
18	PSTLZ	Postal Code	nvarchar	10	0	CHAR	(N' ')	Yes		PSTLZ	Allow NULL?
19	ORT01	City	nvarchar	35	0	CHAR	(N' ')	Yes		ORT01_GP	Allow NULL?
20	STRAS	House number and street	nvarchar	35	0	CHAR	(N' ')	Yes		STRAS_GP	Allow NULL?
21	PFACH	PO Box	nvarchar	10	0	CHAR	(N' ')	Yes		PFACH	Allow NULL?
22	LAND1	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	T005	LAND1	Allow NULL?
23	STCD1	Tax Number 1	nvarchar	16	0	CHAR	(N' ')	Yes		STCD1	Allow NULL?
24	WEVWV	Planned usage of the bill of exchange	char	1	0	CHAR	(N' ')	Yes		WEVWV	Allow NULL?
25	ZANRE	Title of the payee	nvarchar	15	0	CHAR	(N' ')	Yes		DZANRE	Allow NULL?
26	ZNME1	Name of the payee	nvarchar	35	0	CHAR	(N' ')	Yes		DZNME1	Allow NULL?
27	ZNME2	Name of the payee	nvarchar	35	0	CHAR	(N' ')	Yes		DZNME1	Allow NULL?
28	ZNME3	Name of the payee	nvarchar	35	0	CHAR	(N' ')	Yes		DZNME1	Allow NULL?
29	ZNME4	Name of the payee	nvarchar	35	0	CHAR	(N' ')	Yes		DZNME1	Allow NULL?
30	ZPSTL	Postal code of the payee	nvarchar	10	0	CHAR	(N' ')	Yes		DZPSTL	Allow NULL?
31	ZORT1	City of the payee	nvarchar	35	0	CHAR	(N' ')	Yes		DZORT1	Allow NULL?
32	ZSTRA	Street and house number of the payee	nvarchar	35	0	CHAR	(N' ')	Yes		DZSTRA	Allow NULL?
33	ZPFAC	P.O. box of the payee	nvarchar	10	0	CHAR	(N' ')	Yes		DZPFAC	Allow NULL?
34	ZLAND	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	T005	DZLAND	Allow NULL?
35	ZREGI	Regional code of the payee	nvarchar	3	0	CHAR	(N' ')	Yes	T005S	DZREGI	Allow NULL?
36	ZBNKS	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	T005	DZBNKS	Allow NULL?
37	ZBNKN	Bank account number of the payee	nvarchar	18	0	CHAR	(N' ')	Yes		DZBNKN	Allow NULL?
38	ZBNKL	Bank number of the payee's bank	nvarchar	15	0	CHAR	(N' ')	Yes		DZBNKL	Allow NULL?
39	ZBKON	Bank Control Key of the Payee's Bank	nvarchar	2	0	CHAR	(N' ')	Yes		DZBKON	Allow NULL?
40	ZBVTY	Bank Data Indicator for the Payee	nvarchar	4	0	CHAR	(N' ')	Yes		DZBVTY	Allow NULL?
41	ZSWIF	SWIFT/BIC for International Payments	nvarchar	11	0	CHAR	(N' ')	Yes		SWIFT	Allow NULL?
42	XEZER	Indicator: Is there collection authorization ?	char	1	0	CHAR	(N' ')	Yes		XEZER	Allow NULL?
43	ZSPRA	Language key of the payee	char	1	0	LANG	(N' ')	Yes	T002	DZSPRA	Allow NULL?
44	ZALDT	Posting date of the payment document	nvarchar	8	0	DATS	(N'00000000')	Yes		DZALDT_ZHL	Allow NULL?
45	RZAWE	Payment Method for This Payment	char	1	0	CHAR	(N' ')	Yes	T042Z	RZAWE	Allow NULL?
46	RUMSK	Special G/L Indicator of the Payment Transaction	char	1	0	CHAR	(N' ')	Yes	*	RUMSK	Allow NULL?
47	RZUMS	Target Special G/L Indicator of the Payment Transaction	char	1	0	CHAR	(N' ')	Yes	*	RZUMS	Allow NULL?
48	HKTID	ID for account details	nvarchar	5	0	CHAR	(N' ')	Yes	T012K	HKTID	Allow NULL?
49	HBKID	Short Key for a House Bank	nvarchar	5	0	CHAR	(N' ')	Yes	T012	HBKID	Allow NULL?
50	HKTIW	Short Key of the Account Data for the Bill of Exchange	nvarchar	5	0	CHAR	(N' ')	Yes	T012K	HKTIW	Allow NULL?
51	HBKIW	Short Key of the House Bank for Bill/Exch.for Check/Bill/Ex.	nvarchar	5	0	CHAR	(N' ')	Yes	T012	HBKIW	Allow NULL?
52	BVTYP	Partner Bank Type	nvarchar	4	0	CHAR	(N' ')	Yes		BVTYP	Allow NULL?
53	UBKON	Bank control key at our bank	nvarchar	2	0	CHAR	(N' ')	Yes		UBKON	Allow NULL?
54	UBKNT	Our account number at the bank	nvarchar	18	0	CHAR	(N' ')	Yes		UBKNT	Allow NULL?
55	UBNKS	Bank country key	nvarchar	3	0	CHAR	(N' ')	Yes	T005	BANKS	Allow NULL?
56	UBNKL	Bank number of our bank	nvarchar	15	0	CHAR	(N' ')	Yes		UBNKL	Allow NULL?
57	UIBAN	IBAN at our House Bank	nvarchar	34	0	CHAR	(N' ')	Yes		UIBAN	Allow NULL?
58	UBHKT	G/L Account Number for Our Bank Account / Bank Sub-Account	nvarchar	10	0	CHAR	(N' ')	Yes	SKB1	UBHKT	Allow NULL?
59	VALUT	Value date	nvarchar	8	0	DATS	(N'00000000')	Yes		VALUT	Allow NULL?
60	CRVAL	Value Date at Payee's Bank	nvarchar	8	0	DATS	(N'00000000')	Yes		PRQ_CRVAL	Allow NULL?
61	ANFAE	Bill of Exchange Payment Request Due Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ANFAE	Allow NULL?
62	WEFAE	Bill of Exchange Due Date	nvarchar	8	0	DATS	(N'00000000')	Yes		WEFAE	Allow NULL?
63	RBETR	Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		RBETR
64	RSKON	Total Cash Discount for the Payment Trans. (Local Currency)	decimal	13	2	CURR	((0))	Yes		RSKON
65	RWBTR	Amount Paid in the Payment Currency	decimal	13	2	CURR	((0))	Yes		RWBTR
66	RWSKT	Total Cash Discount for the Pmnt Transactn in Pmnt Currency	decimal	13	2	CURR	((0))	Yes		RWSKT
67	RSPE1	Form Charges	decimal	11	2	CURR	((0))	Yes		SPES1
68	RSPE2	Form Charges	decimal	11	2	CURR	((0))	Yes		SPES2
69	RPOST	Number of Items Paid	decimal	5	0	DEC	((0))	Yes		RPOST
70	RTEXT	Number of Text Lines for the Items Paid	decimal	5	0	DEC	((0))	Yes		RTEXT_D
71	RSPM1	Form Charges for Bill of Exchange with Maximum Amount	decimal	11	2	CURR	((0))	Yes		SPEM1
72	RSPM2	Form Charges for Bill of Exchange with Maximum Amount	decimal	11	2	CURR	((0))	Yes		SPEM2
73	WEHMX	Maximum Amount per Bill of Exchange in Local Currency	decimal	13	2	CURR	((0))	Yes		WEHMX
74	WEFMX	Maximum Amount per Bill of Exchange in Payment Currency	decimal	13	2	CURR	((0))	Yes		WEFMX
75	WEHRS	Remaining Amount in Local Crcy for Last Bill of Exchange	decimal	13	2	CURR	((0))	Yes		WEHRS
76	WEFRS	Remaining Amount in Payment Crcy for Last Bill of Exchange	decimal	13	2	CURR	((0))	Yes		WEFRS
77	WEAMX	Number of Bills of Exchange with Maximum Amount	decimal	3	0	DEC	((0))	Yes		WEAMX
78	BUSAB	Accounting clerk	nvarchar	2	0	CHAR	(N' ')	Yes	T001S	BUSAB	Allow NULL?
79	EIKTO	Shipper's (Our) Account Number at the Customer or Vendor	nvarchar	12	0	CHAR	(N' ')	Yes		EIKTO	Allow NULL?
80	XINVE	Indicator: Capital Goods Affected?	char	1	0	CHAR	(N' ')	Yes		XINVE	Allow NULL?
81	WDATE	Bill of Exchange Issue Date	nvarchar	8	0	DATS	(N'00000000')	Yes		WDATE	Allow NULL?
82	XAEND	Indicator: Payment Proposal was Changed Afterwards	char	1	0	CHAR	(N' ')	Yes		XAEND_REGU	Allow NULL?
83	ZLSPR	Payment Block Key	char	1	0	CHAR	(N' ')	Yes	T008	DZLSPR	Allow NULL?
84	DTAWS	Instruction key for data medium exchange	nvarchar	2	0	CHAR	(N' ')	Yes	*	DTAWS	Allow NULL?
85	DTAMS	Indicator for Data Medium Exchange	char	1	0	CHAR	(N' ')	Yes		DTAMS	Allow NULL?
86	KURSF	Exchange rate	decimal	9	5	DEC	((0))	Yes		KURSF
87	ABWAE	Settlement currency for bank transfers	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	ABWAE	Allow NULL?
88	SKVHW	Lost Cash Discount in Local Currency	decimal	13	2	CURR	((0))	Yes		SKVHW
89	SKVFW	Lost Cash Discount in Payment Currency	decimal	13	2	CURR	((0))	Yes		SKVFW
90	DSKVH	Impending Lost Cash Discount in Local Currency	decimal	13	2	CURR	((0))	Yes		DSKVH
91	ZPST2	P.O. box postal code of the payee	nvarchar	10	0	CHAR	(N' ')	Yes		DZPST2	Allow NULL?
92	PAYGR	Grouping Field for Automatic Payments	nvarchar	20	0	CHAR	(N' ')	Yes		PAYGR	Allow NULL?
93	ZBNKY	Bank key of the payee's bank	nvarchar	15	0	CHAR	(N' ')	Yes		DZBNKY	Allow NULL?
94	UBNKY	Bank key of our bank	nvarchar	15	0	CHAR	(N' ')	Yes		UBNKY	Allow NULL?
95	PSTL2	P.O. Box Postal Code	nvarchar	10	0	CHAR	(N' ')	Yes		PSTL2	Allow NULL?
96	ABSBU	Sending company code	nvarchar	4	0	CHAR	(N' ')	Yes	T001	ABSBU	Allow NULL?
97	RBET2	Amount Paid in Second Local Currency	decimal	13	2	CURR	((0))	Yes		RBET2
98	RBET3	Amount Paid in Third Local Currency	decimal	13	2	CURR	((0))	Yes		RBET3
99	RSKO2	Payment Transaction Total Discount in Second Local Currency	decimal	13	2	CURR	((0))	Yes		RSKO2
100	RSKO3	Payment Transaction Total Discount in Third Local Currency	decimal	13	2	CURR	((0))	Yes		RSKO3
101	KURS2	Exchange Rate for the Second Local Currency	decimal	9	5	DEC	((0))	Yes		KURS2
102	KURS3	Exchange Rate for the Third Local Currency	decimal	9	5	DEC	((0))	Yes		KURS3
103	BKREF	Reference specifications for bank details	nvarchar	20	0	CHAR	(N' ')	Yes		BKREF	Allow NULL?
104	UZAWE	Payment Method Supplement	nvarchar	2	0	CHAR	(N' ')	Yes	T042F	UZAWE	Allow NULL?
105	ZORT2	Location from payee's address	nvarchar	35	0	CHAR	(N' ')	Yes		ORT02_Z	Allow NULL?
106	ZTLFX	Payee's telefax number	nvarchar	31	0	CHAR	(N' ')	Yes		TELFX_Z	Allow NULL?
107	XSIWE	Indicator: Bill on demand	char	1	0	CHAR	(N' ')	Yes		XSIWE	Allow NULL?
108	ZPFOR	City of payee's PO box	nvarchar	35	0	CHAR	(N' ')	Yes		PFORT_Z	Allow NULL?
109	PERNR	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		PERNR_D	Allow NULL?
110	SEQNR	Sequence Number	nvarchar	5	0	CHAR	(N' ')	Yes		SEQC5	Allow NULL?
111	BTZNR	Assignment of Transfers	varbinary	1	0	RAW		Yes		BTZNR
112	AUSFD	Due date of the paid items	nvarchar	8	0	DATS	(N'00000000')	Yes		AUSFD	Allow NULL?
113	AUGDT	Clearing Date	nvarchar	8	0	DATS	(N'00000000')	Yes		AUGDT	Allow NULL?
114	EDIAV	EDI Payment Advice Status	char	1	0	CHAR	(N' ')	Yes		EDIAV	Allow NULL?
115	IDOC_NUM_AVIS	IDoc number	nvarchar	16	0	NUMC	(N'0000000000000000')	Yes		EDI_DOCNUM	Allow NULL?
116	EDIBN	EDI Payment Order Status	char	1	0	CHAR	(N' ')	Yes		EDIBN	Allow NULL?
117	IDOC_NUM	IDoc number	nvarchar	16	0	NUMC	(N'0000000000000000')	Yes		EDI_DOCNUM	Allow NULL?
118	ZTELF	Payee telephone number	nvarchar	20	0	CHAR	(N' ')	Yes		TELFN_Z	Allow NULL?
119	ZTELX	Payee telex number	nvarchar	30	0	CHAR	(N' ')	Yes		TELEX_Z	Allow NULL?
120	KOINH	Account Holder Name	nvarchar	60	0	CHAR	(N' ')	Yes		KOINH_FI	Allow NULL?
121	DTWS1	Instruction key 1	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT16	Allow NULL?
122	DTWS2	Instruction key 2	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT17	Allow NULL?
123	DTWS3	Instruction key 3	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT18	Allow NULL?
124	DTWS4	Instruction key 4	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT19	Allow NULL?
125	ZSTC1	Payee's tax number 1	nvarchar	16	0	CHAR	(N' ')	Yes		STCD1_Z	Allow NULL?
126	KIDNO	Payment Reference	nvarchar	30	0	CHAR	(N' ')	Yes		KIDNO	Allow NULL?
127	PYORD	Payment Order	nvarchar	10	0	CHAR	(N' ')	Yes		PYORD	Allow NULL?
128	REGIO	Region (State, Province, County)	nvarchar	3	0	CHAR	(N' ')	Yes	*	REGIO	Allow NULL?
129	TEXT	Text field	nvarchar	29	0	CHAR	(N' ')	Yes		TEXT	Allow NULL?
130	BTYP1	Type of bank in a bank chain (correspondent, intermediary)	char	1	0	CHAR	(N' ')	Yes		BNTYP	Allow NULL?
131	BNKS1	Bank country key	nvarchar	3	0	CHAR	(N' ')	Yes	*	BANKS	Allow NULL?
132	BNKL1	Bank Keys	nvarchar	15	0	CHAR	(N' ')	Yes		BANKK	Allow NULL?
133	BNKN1	Bank account number	nvarchar	18	0	CHAR	(N' ')	Yes		BANKN	Allow NULL?
134	BKON1	Bank Control Key	nvarchar	2	0	CHAR	(N' ')	Yes		BKONT	Allow NULL?
135	BKRF1	Reference specifications for bank details	nvarchar	20	0	CHAR	(N' ')	Yes		BKREF	Allow NULL?
136	IBAN1	IBAN (International Bank Account Number)	nvarchar	34	0	CHAR	(N' ')	Yes		IBAN	Allow NULL?
137	BTYP2	Type of bank in a bank chain (correspondent, intermediary)	char	1	0	CHAR	(N' ')	Yes		BNTYP	Allow NULL?
138	BNKS2	Bank country key	nvarchar	3	0	CHAR	(N' ')	Yes	*	BANKS	Allow NULL?
139	BNKL2	Bank Keys	nvarchar	15	0	CHAR	(N' ')	Yes		BANKK	Allow NULL?
140	BNKN2	Bank account number	nvarchar	18	0	CHAR	(N' ')	Yes		BANKN	Allow NULL?
141	BKON2	Bank Control Key	nvarchar	2	0	CHAR	(N' ')	Yes		BKONT	Allow NULL?
142	BKRF2	Reference specifications for bank details	nvarchar	20	0	CHAR	(N' ')	Yes		BKREF	Allow NULL?
143	IBAN2	IBAN (International Bank Account Number)	nvarchar	34	0	CHAR	(N' ')	Yes		IBAN	Allow NULL?
144	BTYP3	Type of bank in a bank chain (correspondent, intermediary)	char	1	0	CHAR	(N' ')	Yes		BNTYP	Allow NULL?
145	BNKS3	Bank country key	nvarchar	3	0	CHAR	(N' ')	Yes	*	BANKS	Allow NULL?
146	BNKL3	Bank Keys	nvarchar	15	0	CHAR	(N' ')	Yes		BANKK	Allow NULL?
147	BNKN3	Bank account number	nvarchar	18	0	CHAR	(N' ')	Yes		BANKN	Allow NULL?
148	BKON3	Bank Control Key	nvarchar	2	0	CHAR	(N' ')	Yes		BKONT	Allow NULL?
149	BKRF3	Reference specifications for bank details	nvarchar	20	0	CHAR	(N' ')	Yes		BKREF	Allow NULL?
150	IBAN3	IBAN (International Bank Account Number)	nvarchar	34	0	CHAR	(N' ')	Yes		IBAN	Allow NULL?
151	SAKNR	G/L Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	SAKNR	Allow NULL?
152	HKONT	General Ledger Account	nvarchar	10	0	CHAR	(N' ')	Yes	*	HKONT	Allow NULL?
153	ALEBN	ALE IDoc Distribution Status of Payment Data	char	1	0	CHAR	(N' ')	Yes		ALEBN	Allow NULL?
154	XKDFB	Do not Post any Exchange Rate Differences	char	1	0	CHAR	(N' ')	Yes		XKDFB_042E	Allow NULL?
155	SRTBP	Business Place	nvarchar	4	0	CHAR	(N' ')	Yes	*	BUPLA	Allow NULL?
156	FPM_KEY	Rundate, ID, and Default Indicator Concatenated	nvarchar	15	0	CHAR	(N' ')	Yes		FPM_KEY	Allow NULL?
157	GRPNO	Grouping Criterium for Payments	int	10	0	INT4	((0))	Yes		GRPNO_FPM	Allow NULL?
158	SRTF1	Format-specific sorting of payments incl. sequence nuber	nvarchar	38	0	CHAR	(N' ')	Yes		SRTF1N_FPM	Allow NULL?
159	SRTF2	User-defined sorting of payments incl. sequence number	nvarchar	56	0	CHAR	(N' ')	Yes		SRTF2N_FPM	Allow NULL?
160	SRTF3	Format-specific sorting of payments incl. sequence nuber	nvarchar	38	0	CHAR	(N' ')	Yes		SRTF1N_FPM	Allow NULL?
161	XCORR	Indicator: Payment Correspondence	char	1	0	CHAR	(N' ')	Yes		XCORR_FPM	Allow NULL?
162	XAVIS	Indicator: Separate Payment Advice	char	1	0	CHAR	(N' ')	Yes		XAVIS_FPM	Allow NULL?
163	XCOPM	Payment Medium for Business Partner (Correspondence)	char	1	0	CHAR	(N' ')	Yes		XCOPM_FPM	Allow NULL?
164	DORIGIN	Grouping Origin	nvarchar	8	0	CHAR	(N' ')	Yes	*	FIBL_DORIGIN	Allow NULL?
165	RFTTRN	Payment code	nvarchar	20	0	CHAR	(N' ')	Yes		RFTTRN_BF	Allow NULL?
166	ZADNR	Payee's Address Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	ADRNR_Z	Allow NULL?
167	ADRNR	Address number	nvarchar	10	0	CHAR	(N' ')	Yes	*	AD_ADDRNUM	Allow NULL?
168	ZIBAN	IBAN of the Payee	nvarchar	34	0	CHAR	(N' ')	Yes		DZIBAN	Allow NULL?
169	MGUID	SEPA Mandate: GUID of Mandate	varbinary	16	0	RAW		Yes		SEPA_MGUID
170	SEQ_TYPE	SEPA: Sequence Type	nvarchar	4	0	CHAR	(N' ')	Yes		SEPA_SEQ_TYPE	Allow NULL?
171	INST_CODE	Local Instrument Code (Direct Debit Type)	nvarchar	4	0	CHAR	(N' ')	Yes		FSEPA_INST_CODE	Allow NULL?
172	PURP_CODE	SEPA Purpose Code: Classification of a Payment/Debit Memo	nvarchar	4	0	CHAR	(N' ')	Yes		FPM_PURP_CODE	Allow NULL?
173	XMLST	Status of XML Payment Advice	char	1	0	CHAR	(N' ')	Yes		XMLST_AVIS	Allow NULL?
174	TIMESTAMP_AVIS	Time Stamp for Sending XML Payment Advice	decimal	15	0	DEC	((0))	Yes		TIMESTAMP_AVIS
175	FM_STATUS	Availability Status for a Payment	char	1	0	CHAR	(N' ')	Yes		FM_PAY_STA	Allow NULL?
176	FILE_NBR	Key for multiple files from single Payment Program Print	nvarchar	6	0	NUMC	(N'000000')	Yes		FMFG_FILE_NO	Allow NULL?

TOP ERP 6.0 | REGUH INDEXES

Name	Primary	Unique	Type	Columns
REGUH~0	Yes	Yes	CLUSTERED	VBLNR, EMPFG, KUNNR, LIFNR, ZBUKR, XVORL, LAUFI, LAUFD, MANDT
REGUH~PMW	No	No	NONCLUSTERED	SRTF1, GRPNO, FPM_KEY, 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

176 COLUMNS | 2 INDEXES | ERP 6.0 | REGUH TABLE

TOP ERP 6.0 | REGUH COLUMNS

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

176 COLUMNS | 2 INDEXES | ERP 6.0 | REGUH TABLE

TOPERP 6.0 | REGUH COLUMNS

TOPERP 6.0 | REGUH INDEXES

TOP ERP 6.0 | REGUH COLUMNS

TOP ERP 6.0 | REGUH INDEXES