	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	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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

170 COLUMNS | 3 INDEXES | ERP 6.0 | PAYRQ TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Financial Accounting :: Bank Accounting :: Payment Transactions :: Automatic Payments
1	ERP EHP7	6.0	PAYRQ	170	3	Payment Requests	Automatic Payments

SQL: selectupdate insert create

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

SELECT MANDT, KEYNO, ZBUKR, ABSBU, BUKRS, BELNR, BUZEI, GJAHR, GSBER, USNAM, MONAT, CPUDT, HWAER, WAERS, HWAE2, HWAE3, PACUR, DMBTR, DMBE2, DMBE3, WRBTR, PAMTL, PAMTF, SHKZG, KOART, PARNO, HKONT, PAYEE, FILKD, ANRED, NAME1, NAME2, NAME3, NAME4, PSTLZ, ORT01, PSTL2, STRAS, PFACH, LAND1, REGIO, BUSAB, STCD1, DTAMS, DTAWS, DTWS1, DTWS2, DTWS3, DTWS4, LZBKZ, LANDL, ZANRE, ZNME1, ZNME2, ZNME3, ZNME4, ZPSTL, ZORT1, ZPST2, ZSTRA, ZPFAC, ZLAND, ZREGI, ZSPRA, EIKTO, ZTLFX, ZTELF, ZTELX, HKTID, HBKID, UBNKY, UBNKS, UBNKL, UIBAN, UBKNT, UBKON, UBNKR, UBHKT, BKHBK, BTYP1, BNKS1, BNKL1, BNKN1, BKON1, BKRF1, IBAN1, BTYP2, BNKS2, BNKL2, BNKN2, BKON2, BKRF2, IBAN2, BTYP3, BNKS3, BNKL3, BNKN3, BKON3, BKRF3, IBAN3, BVTYP, ZBNKS, ZBNKN, ZBNKL, ZBNKY, ZBKON, BKREF, ZBNKR, SWIFT, KOINH, ZGSBR, GGRUP, XRELD, XRELI, XRELP, XREVE, STGRD, XURGE, TAGE1, DUEDT, VALUT, CRVAL, IMPER, ZUONR, XPORE, UZAWE, ZWELS, XEZER, SWTXT, XBLNR, BLDAT, SGTXT, PAYGR, XKDFB, ZLSPR, VBUND, AUGDT, AUGCP, AUGBL, AWSYS, AWTYP, AWKEY, ORIGIN, HBKGR, RFTTRN, POST_NAME, POST_DATE, REL_NAME, REL_DATE, DEDUAMNTP, DEDUAMNTL, WTAMNTP, WTAMNTL, KIDNO, ZIBAN, SNAME1, SORT01, SLAND1, VERTN, EXTACCOUNT, ZPFOR, MGUID, SNAME2, SNAME3, SNAME4, SSTRAS, SSTRS2, SPSTLZ, SID, PURP_CODE FROM PAYRQ

TOP ERP 6.0 | PAYRQ 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	KEYNO	Key Number for Payment Request	nvarchar	10	0	CHAR	(N' ')	No		PRQ_KEYNO	Allow NULL?
3	ZBUKR	Paying Company Code for this Payment Request	nvarchar	4	0	CHAR	(N' ')	Yes	T001	PRQ_ZBUKR	Allow NULL?
4	ABSBU	Sending Company Code for Payment Requests	nvarchar	4	0	CHAR	(N' ')	Yes	T001	PRQ_ABSBU	Allow NULL?
5	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	T001	BUKRS	Allow NULL?
6	BELNR	Accounting Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		BELNR_D	Allow NULL?
7	BUZEI	Number of Line Item Within Accounting Document	nvarchar	3	0	NUMC	(N'000')	Yes		BUZEI	Allow NULL?
8	GJAHR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	Yes		GJAHR	Allow NULL?
9	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
10	USNAM	User name	nvarchar	12	0	CHAR	(N' ')	Yes	USR02	USNAM	Allow NULL?
11	MONAT	Fiscal Period	nvarchar	2	0	NUMC	(N'00')	Yes		MONAT	Allow NULL?
12	CPUDT	Day On Which Accounting Document Was Entered	nvarchar	8	0	DATS	(N'00000000')	Yes		CPUDT	Allow NULL?
13	HWAER	Local Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	HWAER	Allow NULL?
14	WAERS	Currency Key of the Invoice	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PRQ_DOCUR	Allow NULL?
15	HWAE2	Currency Key of Second Local Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	HWAE2	Allow NULL?
16	HWAE3	Currency Key of Third Local Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	HWAE3	Allow NULL?
17	PACUR	Payment Request Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PRQ_PACUR	Allow NULL?
18	DMBTR	Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		DMBTR
19	DMBE2	Amount in Second Local Currency	decimal	13	2	CURR	((0))	Yes		DMBE2
20	DMBE3	Amount in Third Local Currency	decimal	13	2	CURR	((0))	Yes		DMBE3
21	WRBTR	Amount in document currency	decimal	13	2	CURR	((0))	Yes		WRBTR
22	PAMTL	Payment Request Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		PRQ_AMTLC
23	PAMTF	Payment Request Amount in Payment Currency	decimal	13	2	CURR	((0))	Yes		PRQ_AMTFC
24	SHKZG	Debit/Credit Indicator	char	1	0	CHAR	(N' ')	Yes		SHKZG	Allow NULL?
25	KOART	Account Type	char	1	0	CHAR	(N' ')	Yes		KOART	Allow NULL?
26	PARNO	Business Partner	nvarchar	10	0	CHAR	(N' ')	Yes		PRQ_PARNO	Allow NULL?
27	HKONT	General Ledger Account	nvarchar	10	0	CHAR	(N' ')	Yes	SKA1	HKONT	Allow NULL?
28	PAYEE	Account Number of the Alternative Payee	nvarchar	10	0	CHAR	(N' ')	Yes		PRQ_PAYEE	Allow NULL?
29	FILKD	Account Number of the Branch	nvarchar	10	0	CHAR	(N' ')	Yes		FILKD	Allow NULL?
30	ANRED	Title	nvarchar	15	0	CHAR	(N' ')	Yes		ANRED	Allow NULL?
31	NAME1	Name 1	nvarchar	35	0	CHAR	(N' ')	Yes		NAME1_GP	Allow NULL?
32	NAME2	Name 2	nvarchar	35	0	CHAR	(N' ')	Yes		NAME2_GP	Allow NULL?
33	NAME3	Name 3	nvarchar	35	0	CHAR	(N' ')	Yes		NAME3_GP	Allow NULL?
34	NAME4	Name 4	nvarchar	35	0	CHAR	(N' ')	Yes		NAME4_GP	Allow NULL?
35	PSTLZ	Postal Code	nvarchar	10	0	CHAR	(N' ')	Yes		PSTLZ	Allow NULL?
36	ORT01	City	nvarchar	35	0	CHAR	(N' ')	Yes		ORT01_GP	Allow NULL?
37	PSTL2	P.O. Box Postal Code	nvarchar	10	0	CHAR	(N' ')	Yes		PSTL2	Allow NULL?
38	STRAS	House number and street	nvarchar	35	0	CHAR	(N' ')	Yes		STRAS_GP	Allow NULL?
39	PFACH	PO Box	nvarchar	10	0	CHAR	(N' ')	Yes		PFACH	Allow NULL?
40	LAND1	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	T005	LAND1	Allow NULL?
41	REGIO	Region (State, Province, County)	nvarchar	3	0	CHAR	(N' ')	Yes	T005S	REGIO	Allow NULL?
42	BUSAB	Accounting clerk	nvarchar	2	0	CHAR	(N' ')	Yes	T001S	BUSAB	Allow NULL?
43	STCD1	Tax Number 1	nvarchar	16	0	CHAR	(N' ')	Yes		STCD1	Allow NULL?
44	DTAMS	Indicator for Data Medium Exchange	char	1	0	CHAR	(N' ')	Yes		DTAMS	Allow NULL?
45	DTAWS	Instruction key for data medium exchange	nvarchar	2	0	CHAR	(N' ')	Yes	T015W	DTAWS	Allow NULL?
46	DTWS1	Instruction key 1	nvarchar	2	0	NUMC	(N'00')	Yes	T015W1	DTAT16	Allow NULL?
47	DTWS2	Instruction key 2	nvarchar	2	0	NUMC	(N'00')	Yes	T015W1	DTAT17	Allow NULL?
48	DTWS3	Instruction key 3	nvarchar	2	0	NUMC	(N'00')	Yes	T015W1	DTAT18	Allow NULL?
49	DTWS4	Instruction key 4	nvarchar	2	0	NUMC	(N'00')	Yes	T015W1	DTAT19	Allow NULL?
50	LZBKZ	State Central Bank Indicator	nvarchar	3	0	CHAR	(N' ')	Yes	T015L	LZBKZ	Allow NULL?
51	LANDL	Supplying Country	nvarchar	3	0	CHAR	(N' ')	Yes	T005	LANDL	Allow NULL?
52	ZANRE	Title of the payee	nvarchar	15	0	CHAR	(N' ')	Yes		DZANRE	Allow NULL?
53	ZNME1	Name of the payee	nvarchar	35	0	CHAR	(N' ')	Yes		DZNME1	Allow NULL?
54	ZNME2	Name of the payee	nvarchar	35	0	CHAR	(N' ')	Yes		DZNME1	Allow NULL?
55	ZNME3	Name of the payee	nvarchar	35	0	CHAR	(N' ')	Yes		DZNME1	Allow NULL?
56	ZNME4	Name of the payee	nvarchar	35	0	CHAR	(N' ')	Yes		DZNME1	Allow NULL?
57	ZPSTL	Postal code of the payee	nvarchar	10	0	CHAR	(N' ')	Yes		DZPSTL	Allow NULL?
58	ZORT1	City of the payee	nvarchar	35	0	CHAR	(N' ')	Yes		DZORT1	Allow NULL?
59	ZPST2	P.O. box postal code of the payee	nvarchar	10	0	CHAR	(N' ')	Yes		DZPST2	Allow NULL?
60	ZSTRA	Street and house number of the payee	nvarchar	35	0	CHAR	(N' ')	Yes		DZSTRA	Allow NULL?
61	ZPFAC	P.O. box of the payee	nvarchar	10	0	CHAR	(N' ')	Yes		DZPFAC	Allow NULL?
62	ZLAND	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	T005	DZLAND	Allow NULL?
63	ZREGI	Regional code of the payee	nvarchar	3	0	CHAR	(N' ')	Yes	T005S	DZREGI	Allow NULL?
64	ZSPRA	Language Key	char	1	0	LANG	(N' ')	Yes	T002	SPRAS	Allow NULL?
65	EIKTO	Shipper's (Our) Account Number at the Customer or Vendor	nvarchar	12	0	CHAR	(N' ')	Yes		EIKTO	Allow NULL?
66	ZTLFX	Fax Number	nvarchar	31	0	CHAR	(N' ')	Yes		TELFX	Allow NULL?
67	ZTELF	First telephone number	nvarchar	16	0	CHAR	(N' ')	Yes		TELF1	Allow NULL?
68	ZTELX	Telex number	nvarchar	30	0	CHAR	(N' ')	Yes		TELX1	Allow NULL?
69	HKTID	ID for account details	nvarchar	5	0	CHAR	(N' ')	Yes	T012K	HKTID	Allow NULL?
70	HBKID	Short Key for a House Bank	nvarchar	5	0	CHAR	(N' ')	Yes	T012	HBKID	Allow NULL?
71	UBNKY	Bank key of our bank	nvarchar	15	0	CHAR	(N' ')	Yes	BNKA	UBNKY	Allow NULL?
72	UBNKS	Bank country key	nvarchar	3	0	CHAR	(N' ')	Yes	T005	BANKS	Allow NULL?
73	UBNKL	Bank number of our bank	nvarchar	15	0	CHAR	(N' ')	Yes		UBNKL	Allow NULL?
74	UIBAN	IBAN at our House Bank	nvarchar	34	0	CHAR	(N' ')	Yes		UIBAN	Allow NULL?
75	UBKNT	Our account number at the bank	nvarchar	18	0	CHAR	(N' ')	Yes		UBKNT	Allow NULL?
76	UBKON	Bank control key at our bank	nvarchar	2	0	CHAR	(N' ')	Yes		UBKON	Allow NULL?
77	UBNKR	Regional Code of the House Bank	nvarchar	3	0	CHAR	(N' ')	Yes	T005S	PRQ_UBNKR	Allow NULL?
78	UBHKT	G/L Account Number for Our Bank Account / Bank Sub-Account	nvarchar	10	0	CHAR	(N' ')	Yes	SKA1	UBHKT	Allow NULL?
79	BKHBK	G/L Account for Bank Clearing Account	nvarchar	10	0	CHAR	(N' ')	Yes	SKA1	PRQ_BKHBK	Allow NULL?
80	BTYP1	Type of bank in a bank chain (correspondent, intermediary)	char	1	0	CHAR	(N' ')	Yes		BNTYP	Allow NULL?
81	BNKS1	Bank country key	nvarchar	3	0	CHAR	(N' ')	Yes	*	BANKS	Allow NULL?
82	BNKL1	Bank Keys	nvarchar	15	0	CHAR	(N' ')	Yes		BANKK	Allow NULL?
83	BNKN1	Bank account number	nvarchar	18	0	CHAR	(N' ')	Yes		BANKN	Allow NULL?
84	BKON1	Bank Control Key	nvarchar	2	0	CHAR	(N' ')	Yes		BKONT	Allow NULL?
85	BKRF1	Reference specifications for bank details	nvarchar	20	0	CHAR	(N' ')	Yes		BKREF	Allow NULL?
86	IBAN1	IBAN (International Bank Account Number)	nvarchar	34	0	CHAR	(N' ')	Yes		IBAN	Allow NULL?
87	BTYP2	Type of bank in a bank chain (correspondent, intermediary)	char	1	0	CHAR	(N' ')	Yes		BNTYP	Allow NULL?
88	BNKS2	Bank country key	nvarchar	3	0	CHAR	(N' ')	Yes	*	BANKS	Allow NULL?
89	BNKL2	Bank Keys	nvarchar	15	0	CHAR	(N' ')	Yes		BANKK	Allow NULL?
90	BNKN2	Bank account number	nvarchar	18	0	CHAR	(N' ')	Yes		BANKN	Allow NULL?
91	BKON2	Bank Control Key	nvarchar	2	0	CHAR	(N' ')	Yes		BKONT	Allow NULL?
92	BKRF2	Reference specifications for bank details	nvarchar	20	0	CHAR	(N' ')	Yes		BKREF	Allow NULL?
93	IBAN2	IBAN (International Bank Account Number)	nvarchar	34	0	CHAR	(N' ')	Yes		IBAN	Allow NULL?
94	BTYP3	Type of bank in a bank chain (correspondent, intermediary)	char	1	0	CHAR	(N' ')	Yes		BNTYP	Allow NULL?
95	BNKS3	Bank country key	nvarchar	3	0	CHAR	(N' ')	Yes	*	BANKS	Allow NULL?
96	BNKL3	Bank Keys	nvarchar	15	0	CHAR	(N' ')	Yes		BANKK	Allow NULL?
97	BNKN3	Bank account number	nvarchar	18	0	CHAR	(N' ')	Yes		BANKN	Allow NULL?
98	BKON3	Bank Control Key	nvarchar	2	0	CHAR	(N' ')	Yes		BKONT	Allow NULL?
99	BKRF3	Reference specifications for bank details	nvarchar	20	0	CHAR	(N' ')	Yes		BKREF	Allow NULL?
100	IBAN3	IBAN (International Bank Account Number)	nvarchar	34	0	CHAR	(N' ')	Yes		IBAN	Allow NULL?
101	BVTYP	Partner Bank Type	nvarchar	4	0	CHAR	(N' ')	Yes		BVTYP	Allow NULL?
102	ZBNKS	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	T005	DZBNKS	Allow NULL?
103	ZBNKN	Bank account number of the payee	nvarchar	18	0	CHAR	(N' ')	Yes		DZBNKN	Allow NULL?
104	ZBNKL	Bank number of the payee's bank	nvarchar	15	0	CHAR	(N' ')	Yes		DZBNKL	Allow NULL?
105	ZBNKY	Bank key of the payee's bank	nvarchar	15	0	CHAR	(N' ')	Yes	BNKA	DZBNKY	Allow NULL?
106	ZBKON	Bank Control Key of the Payee's Bank	nvarchar	2	0	CHAR	(N' ')	Yes		DZBKON	Allow NULL?
107	BKREF	Reference specifications for bank details	nvarchar	20	0	CHAR	(N' ')	Yes		BKREF	Allow NULL?
108	ZBNKR	Regional Code of the Payee's Bank	nvarchar	3	0	CHAR	(N' ')	Yes	T005S	PRQ_ZBNKR	Allow NULL?
109	SWIFT	SWIFT/BIC for International Payments	nvarchar	11	0	CHAR	(N' ')	Yes		SWIFT	Allow NULL?
110	KOINH	Account Holder Name	nvarchar	60	0	CHAR	(N' ')	Yes		KOINH_FI	Allow NULL?
111	ZGSBR	Business Area: Offsetting Posting	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	PRQ_ZGSBR	Allow NULL?
112	GGRUP	Partner Bank's Account No. for Bank Account Transfers	nvarchar	10	0	CHAR	(N' ')	Yes	SKA1	PRQ_ZHKONT	Allow NULL?
113	XRELD	Indicator: Released for Posting	char	1	0	CHAR	(N' ')	Yes		PRQ_XRELD	Allow NULL?
114	XRELI	Indicator: Complete	char	1	0	CHAR	(N' ')	Yes		PRQ_XRELI	Allow NULL?
115	XRELP	Indicator: Released for Payment	char	1	0	CHAR	(N' ')	Yes		PRQ_XRELP	Allow NULL?
116	XREVE	Indicator: Payment Request is Reversed	char	1	0	CHAR	(N' ')	Yes		PRQ_XREVE	Allow NULL?
117	STGRD	Reason for Reversal	nvarchar	2	0	CHAR	(N' ')	Yes	T041C	STGRD	Allow NULL?
118	XURGE	Indicator: Extremely Urgent Payment	char	1	0	CHAR	(N' ')	Yes		PRQ_XURGE	Allow NULL?
119	TAGE1	Residence time 1	nvarchar	4	0	NUMC	(N'0000')	Yes		TAGE1	Allow NULL?
120	DUEDT	Payment Request Due Date	nvarchar	8	0	DATS	(N'00000000')	Yes		PRQ_DUEDT	Allow NULL?
121	VALUT	Value Date for the Sending Bank	nvarchar	8	0	DATS	(N'00000000')	Yes		PRQ_VALDT	Allow NULL?
122	CRVAL	Value Date at Payee's Bank	nvarchar	8	0	DATS	(N'00000000')	Yes		PRQ_CRVAL	Allow NULL?
123	IMPER	Value Date may no Longer be Changed	char	1	0	CHAR	(N' ')	Yes		PRQ_IMPER	Allow NULL?
124	ZUONR	Assignment Number	nvarchar	18	0	CHAR	(N' ')	Yes		DZUONR	Allow NULL?
125	XPORE	Indicator: Individual Payment?	char	1	0	CHAR	(N' ')	Yes		PRQ_XPORE	Allow NULL?
126	UZAWE	Payment Method Supplement	nvarchar	2	0	CHAR	(N' ')	Yes	T042F	UZAWE	Allow NULL?
127	ZWELS	List of the Payment Methods to be Considered	nvarchar	10	0	CHAR	(N' ')	Yes		DZWELS	Allow NULL?
128	XEZER	Indicator: Is there collection authorization ?	char	1	0	CHAR	(N' ')	Yes		XEZER	Allow NULL?
129	SWTXT	Swift Text	nvarchar	140	0	CHAR	(N' ')	Yes		PRQ_SWTXT	Allow NULL?
130	XBLNR	Reference Document Number	nvarchar	16	0	CHAR	(N' ')	Yes		XBLNR1	Allow NULL?
131	BLDAT	Document Date in Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BLDAT	Allow NULL?
132	SGTXT	Item Text	nvarchar	50	0	CHAR	(N' ')	Yes		SGTXT	Allow NULL?
133	PAYGR	Grouping Field for Automatic Payments	nvarchar	20	0	CHAR	(N' ')	Yes		PAYGR	Allow NULL?
134	XKDFB	Do not Post any Exchange Rate Differences	char	1	0	CHAR	(N' ')	Yes		XKDFB_042E	Allow NULL?
135	ZLSPR	Payment Block Key	char	1	0	CHAR	(N' ')	Yes	T008	DZLSPR	Allow NULL?
136	VBUND	Company ID of trading partner	nvarchar	6	0	CHAR	(N' ')	Yes	T880	RASSC	Allow NULL?
137	AUGDT	Clearing Date	nvarchar	8	0	DATS	(N'00000000')	Yes		AUGDT	Allow NULL?
138	AUGCP	Clearing Entry Date	nvarchar	8	0	DATS	(N'00000000')	Yes		AUGCP	Allow NULL?
139	AUGBL	Document Number of the Clearing Document	nvarchar	10	0	CHAR	(N' ')	Yes		AUGBL	Allow NULL?
140	AWSYS	Logical System	nvarchar	10	0	CHAR	(N' ')	Yes	TBDLS	LOGSYSTEM	Allow NULL?
141	AWTYP	Reference Transaction	nvarchar	5	0	CHAR	(N' ')	Yes	TTYP	AWTYP	Allow NULL?
142	AWKEY	Reference Key	nvarchar	20	0	CHAR	(N' ')	Yes		AWKEY	Allow NULL?
143	ORIGIN	Origin Indicator	nvarchar	8	0	CHAR	(N' ')	Yes	TFIBLORIGIN	FIBL_ORIGIN	Allow NULL?
144	HBKGR	Group of House Bank Accounts	nvarchar	2	0	CHAR	(N' ')	Yes	TFIBLHBG	FIBL_HBG	Allow NULL?
145	RFTTRN	Payment code	nvarchar	20	0	CHAR	(N' ')	Yes		RFTTRN_BF	Allow NULL?
146	POST_NAME	User who Carried Out the Posting	nvarchar	12	0	CHAR	(N' ')	Yes	USR02	PRQ_POSTNAME	Allow NULL?
147	POST_DATE	Day on Which Payment Request was Posted	nvarchar	8	0	DATS	(N'00000000')	Yes		PRQ_POSTDATE	Allow NULL?
148	REL_NAME	User who Carried Out the Release	nvarchar	12	0	CHAR	(N' ')	Yes	USR02	PRQ_RELNAME	Allow NULL?
149	REL_DATE	Release Date for Payment	nvarchar	8	0	DATS	(N'00000000')	Yes		PRQ_RELDATE	Allow NULL?
150	DEDUAMNTP	Deductions in Payment Currency	decimal	13	2	CURR	((0))	Yes		PRQ_DEDUAMNTP
151	DEDUAMNTL	Deductions in Local Currency	decimal	13	2	CURR	((0))	Yes		PRQ_DEDUAMNTL
152	WTAMNTP	Withholding Tax Amount in Payment Currency	decimal	13	2	CURR	((0))	Yes		PRQ_WTAMNTP
153	WTAMNTL	Withholding Tax Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		PRQ_WTAMNTL
154	KIDNO	Payment Reference	nvarchar	30	0	CHAR	(N' ')	Yes		KIDNO	Allow NULL?
155	ZIBAN	IBAN of the Payee	nvarchar	34	0	CHAR	(N' ')	Yes		DZIBAN	Allow NULL?
156	SNAME1	Name 1	nvarchar	35	0	CHAR	(N' ')	Yes		NAME1_GP	Allow NULL?
157	SORT01	City	nvarchar	35	0	CHAR	(N' ')	Yes		ORT01_GP	Allow NULL?
158	SLAND1	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	*	LAND1_GP	Allow NULL?
159	VERTN	Contract Number	nvarchar	13	0	CHAR	(N' ')	Yes		RANL	Allow NULL?
160	EXTACCOUNT	External Account	nvarchar	10	0	CHAR	(N' ')	Yes		TPM_EXT_ACCOUNT	Allow NULL?
161	ZPFOR	City of payee's PO box	nvarchar	35	0	CHAR	(N' ')	Yes		PFORT_Z	Allow NULL?
162	MGUID	SEPA Mandate: GUID of Mandate	varbinary	16	0	RAW		Yes		SEPA_MGUID
163	SNAME2	Name 2	nvarchar	35	0	CHAR	(N' ')	Yes		NAME2_GP	Allow NULL?
164	SNAME3	Name 3	nvarchar	35	0	CHAR	(N' ')	Yes		NAME3_GP	Allow NULL?
165	SNAME4	Name 4	nvarchar	35	0	CHAR	(N' ')	Yes		NAME4_GP	Allow NULL?
166	SSTRAS	House number and street	nvarchar	35	0	CHAR	(N' ')	Yes		STRAS_GP	Allow NULL?
167	SSTRS2	House number and street	nvarchar	35	0	CHAR	(N' ')	Yes		STRAS_GP	Allow NULL?
168	SPSTLZ	Postal code	nvarchar	10	0	CHAR	(N' ')	Yes		PSTLZ_BAS	Allow NULL?
169	SID	Original Payer of a Payment (ID)	nvarchar	35	0	CHAR	(N' ')	Yes		SENDER_ID	Allow NULL?
170	PURP_CODE	SEPA Purpose Code: Classification of a Payment/Debit Memo	nvarchar	4	0	CHAR	(N' ')	Yes		FPM_PURP_CODE	Allow NULL?

TOP ERP 6.0 | PAYRQ INDEXES

Name	Primary	Unique	Type	Columns
PAYRQ~0	Yes	Yes	CLUSTERED	KEYNO, MANDT
PAYRQ~001	No	No	NONCLUSTERED	AWKEY, AWTYP, AWSYS
PAYRQ~002	No	No	NONCLUSTERED	ORIGIN, AUGBL, BUKRS

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

170 COLUMNS | 3 INDEXES | ERP 6.0 | PAYRQ TABLE

TOP ERP 6.0 | PAYRQ COLUMNS

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

170 COLUMNS | 3 INDEXES | ERP 6.0 | PAYRQ TABLE

TOPERP 6.0 | PAYRQ COLUMNS

TOPERP 6.0 | PAYRQ INDEXES

TOP ERP 6.0 | PAYRQ COLUMNS

TOP ERP 6.0 | PAYRQ INDEXES