	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

174 COLUMNS | 4 INDEXES | ERP 6.0 | FPRL_ITEM TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Financial Accounting :: Accounts Payable :: Basic Functions :: Payment Transactions
1	ERP EHP7	6.0	FPRL_ITEM	174	4	Item Data	Payment Transactions

SQL: selectupdate insert create

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

SELECT MANDT, GUID, LIST_ID, STATUS, ALEVEL, CREA_USER, CREA_TIME, CHANGE_USER, CHANGE_TIME, APPLIC, BUKRS, BELNR, GJAHR, BUZEI, LIFNR, KUNNR, FILKD, EMPFB, VBUND, SHKZG, WAERS, WRBTR, SKFBT, WSKTO, QBSHB, PSWSL, PSWBT, PSSKT, BLART, BUDAT, BLDAT, KOART, BSCHL, HKONT, SAKNR, UMSKZ, GSBER, MWSKZ, QSSKZ, SGTXT, ZFBDT, ZBD1T, ZBD2T, ZBD3T, ZBD1P, ZBD2P, XREBZ, ESRNR, ESRRE, ESRPZ, EBELN, EBELP, STCEG, XBLNR, LZBKZ, LANDL, NPLNR, AUFPL, ZUONR, VERTN, REBZT, REBZG, REBZJ, REBZZ, KOSTL, VBEL2, POSN2, PRCTR, XREF1, XREF2, XREF3, DTWS1, DTWS2, DTWS3, DTWS4, XCPDD, BUPLA, PPRCT, GRANT_NBR, FKBER, GEBER, XINVE, KEYNO, PAMTF, ORIGIN, EPIC_PROCESSOR, EPIC_STATUS, AVC_STATUS, AVC_PRIORITY, FIPOS_ES, FISTL_ES, GRANT_NBR_ES, FKBER_ES, GEBER_ES, PROJK_ES, CISUB1_ES, CISUB2_ES, CISUB3_ES, CISUB4_ES, CISUB5_ES, LOTKZ_ES, EBELN_CO, SAPLONGNUM, KBLNR, ACCOUNTANT, CO_STATUS, STCD2, POKEN, ZLSPR, LAUFD_PAY, LAUFI_PAY, VBLNR_PAY, PYORD_PAY, XF110_EXEC, LAUFD, LAUFI, JOBCOUNT, ZBUKR, ABSBU, ZNME1, ZPSTL, ZORT1, ZLAND, ZREGI, ZSPRA, NAME1, ZBVTY, ZBNKS, ZBNKY, ZBNKL, ZBNKN, ZBKON, BKREF, ZSWIF, ZIBAN, KOINH, HKTID, HBKID, UBNKS, UBNKY, UBNKL, UBKNT, UBKON, UBHKT, RZAWE, UZAWE, DTAWS, ZALDT, VALUT, AUSFD, ANFAE, WEFAE, WDATE, BUSAB, EIKTO, KIDNO, RFTTRN, BTYP1, BNKS1, BNKL1, BNKN1, BTYP2, BNKS2, BNKL2, BNKN2, BTYP3, BNKS3, BNKL3, BNKN3, MGUID, MNDID, INV_NO, INV_YEAR, INV_ITEM FROM FPRL_ITEM

TOP ERP 6.0 | FPRL_ITEM 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	*	MANDT	Allow NULL?
2	GUID	UUID in X form (binary)	varbinary	16	0	RAW		No		SYSUUID_X
3	LIST_ID	Payment Release List ID	nvarchar	10	0	NUMC	(N'0000000000')	Yes	FPRL_HEADER	FPRL_LIST_ID	Allow NULL?
4	STATUS	Item Status ID	nvarchar	3	0	CHAR	(N' ')	Yes	FPRL_ITEM_STAT	FPRL_ITEM_STATUS	Allow NULL?
5	ALEVEL	Approval Level	nvarchar	2	0	NUMC	(N'00')	Yes	FPRL_LEVELS	FPRL_LEVEL	Allow NULL?
6	CREA_USER	Created By	nvarchar	12	0	CHAR	(N' ')	Yes		FPRL_USER	Allow NULL?
7	CREA_TIME	Created On	decimal	15	0	DEC	((0))	Yes		FPRL_CREA_TIME
8	CHANGE_USER	Last Changed By	nvarchar	12	0	CHAR	(N' ')	Yes		FPRL_USER_CH	Allow NULL?
9	CHANGE_TIME	Last Changed On	decimal	15	0	DEC	((0))	Yes		FPRL_CHANGE_TIME
10	APPLIC	Payment Release List Application ID	nvarchar	10	0	CHAR	(N' ')	Yes	FPRL_APPLIC	FPRL_APPLICATION	Allow NULL?
11	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	T001	BUKRS	Allow NULL?
12	BELNR	Accounting Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		BELNR_D	Allow NULL?
13	GJAHR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	Yes		GJAHR	Allow NULL?
14	BUZEI	Number of Line Item Within Accounting Document	nvarchar	3	0	NUMC	(N'000')	Yes		BUZEI	Allow NULL?
15	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	LIFNR	Allow NULL?
16	KUNNR	Customer Number	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	KUNNR	Allow NULL?
17	FILKD	Account Number of the Branch	nvarchar	10	0	CHAR	(N' ')	Yes		FILKD	Allow NULL?
18	EMPFB	Payee/Payer	nvarchar	10	0	CHAR	(N' ')	Yes		EMPFB	Allow NULL?
19	VBUND	Company ID of trading partner	nvarchar	6	0	CHAR	(N' ')	Yes	T880	RASSC	Allow NULL?
20	SHKZG	Debit/Credit Indicator	char	1	0	CHAR	(N' ')	Yes		SHKZG	Allow NULL?
21	WAERS	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
22	WRBTR	Amount in document currency	decimal	13	2	CURR	((0))	Yes		WRBTR
23	SKFBT	Amount Eligible for Cash Discount in Document Currency	decimal	13	2	CURR	((0))	Yes		SKFBT
24	WSKTO	Cash discount amount in document currency	decimal	13	2	CURR	((0))	Yes		WSKTO
25	QBSHB	Withholding Tax Amount (in Document Currency)	decimal	13	2	CURR	((0))	Yes		QBSHB
26	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0	CUKY	(N' ')	Yes	*	PSWSL	Allow NULL?
27	PSWBT	Amount for Updating in General Ledger	decimal	13	2	CURR	((0))	Yes		PSWBT
28	PSSKT	Cash Discount Deduction for the Item	decimal	13	2	CURR	((0))	Yes		PSSKT
29	BLART	Document Type	nvarchar	2	0	CHAR	(N' ')	Yes	T003	BLART	Allow NULL?
30	BUDAT	Posting Date in the Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BUDAT	Allow NULL?
31	BLDAT	Document Date in Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BLDAT	Allow NULL?
32	KOART	Account Type	char	1	0	CHAR	(N' ')	Yes		KOART	Allow NULL?
33	BSCHL	Posting Key	nvarchar	2	0	CHAR	(N' ')	Yes	TBSL	BSCHL	Allow NULL?
34	HKONT	General Ledger Account	nvarchar	10	0	CHAR	(N' ')	Yes	SKB1	HKONT	Allow NULL?
35	SAKNR	G/L Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	SKB1	SAKNR	Allow NULL?
36	UMSKZ	Special G/L Indicator	char	1	0	CHAR	(N' ')	Yes	T074U	UMSKZ	Allow NULL?
37	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
38	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKZ	Allow NULL?
39	QSSKZ	Withholding Tax Code	nvarchar	2	0	CHAR	(N' ')	Yes	*	QSSKZ	Allow NULL?
40	SGTXT	Item Text	nvarchar	50	0	CHAR	(N' ')	Yes		SGTXT	Allow NULL?
41	ZFBDT	Baseline Date for Due Date Calculation	nvarchar	8	0	DATS	(N'00000000')	Yes		DZFBDT	Allow NULL?
42	ZBD1T	Cash discount days 1	decimal	3	0	DEC	((0))	Yes		DZBD1T
43	ZBD2T	Cash discount days 2	decimal	3	0	DEC	((0))	Yes		DZBD2T
44	ZBD3T	Net Payment Terms Period	decimal	3	0	DEC	((0))	Yes		DZBD3T
45	ZBD1P	Cash Discount Percentage 1	decimal	5	3	DEC	((0))	Yes		DZBD1P
46	ZBD2P	Cash Discount Percentage 2	decimal	5	3	DEC	((0))	Yes		DZBD2P
47	XREBZ	Indicator: Item is an Invoice-Related Credit Memo	char	1	0	CHAR	(N' ')	Yes		XREBZ	Allow NULL?
48	ESRNR	ISR Subscriber Number	nvarchar	11	0	CHAR	(N' ')	Yes		ESRNR	Allow NULL?
49	ESRRE	ISR Reference Number	nvarchar	27	0	CHAR	(N' ')	Yes		ESRRE	Allow NULL?
50	ESRPZ	ISR Check Digit	nvarchar	2	0	CHAR	(N' ')	Yes		ESRPZ	Allow NULL?
51	EBELN	Purchasing Document Number	nvarchar	10	0	CHAR	(N' ')	Yes	EKKO	EBELN	Allow NULL?
52	EBELP	Item Number of Purchasing Document	nvarchar	5	0	NUMC	(N'00000')	Yes	EKPO	EBELP	Allow NULL?
53	STCEG	VAT Registration Number	nvarchar	20	0	CHAR	(N' ')	Yes		STCEG	Allow NULL?
54	XBLNR	Reference Document Number	nvarchar	16	0	CHAR	(N' ')	Yes		XBLNR1	Allow NULL?
55	LZBKZ	State Central Bank Indicator	nvarchar	3	0	CHAR	(N' ')	Yes	T015L	LZBKZ	Allow NULL?
56	LANDL	Supplying Country	nvarchar	3	0	CHAR	(N' ')	Yes	T005	LANDL	Allow NULL?
57	NPLNR	Network Number for Account Assignment	nvarchar	12	0	CHAR	(N' ')	Yes	*	NPLNR	Allow NULL?
58	AUFPL	Routing number of operations in the order	nvarchar	10	0	NUMC	(N'0000000000')	Yes		CO_AUFPL	Allow NULL?
59	ZUONR	Assignment Number	nvarchar	18	0	CHAR	(N' ')	Yes		DZUONR	Allow NULL?
60	VERTN	Contract Number	nvarchar	13	0	CHAR	(N' ')	Yes		RANL	Allow NULL?
61	REBZT	Follow-On Document Type	char	1	0	CHAR	(N' ')	Yes		REBZT	Allow NULL?
62	REBZG	Number of the Invoice the Transaction Belongs to	nvarchar	10	0	CHAR	(N' ')	Yes		REBZG	Allow NULL?
63	REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	nvarchar	4	0	NUMC	(N'0000')	Yes		REBZJ	Allow NULL?
64	REBZZ	Line Item in the Relevant Invoice	nvarchar	3	0	NUMC	(N'000')	Yes		REBZZ	Allow NULL?
65	KOSTL	Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	KOSTL	Allow NULL?
66	VBEL2	Sales Document	nvarchar	10	0	CHAR	(N' ')	Yes	*	VBELN_VA	Allow NULL?
67	POSN2	Sales Document Item	nvarchar	6	0	NUMC	(N'000000')	Yes	*	POSNR_VA	Allow NULL?
68	PRCTR	Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	PRCTR	Allow NULL?
69	XREF1	Business partner reference key	nvarchar	12	0	CHAR	(N' ')	Yes		XREF1	Allow NULL?
70	XREF2	Business partner reference key	nvarchar	12	0	CHAR	(N' ')	Yes		XREF2	Allow NULL?
71	XREF3	Reference key for line item	nvarchar	20	0	CHAR	(N' ')	Yes		XREF3	Allow NULL?
72	DTWS1	Instruction key 1	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT16	Allow NULL?
73	DTWS2	Instruction key 2	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT17	Allow NULL?
74	DTWS3	Instruction key 3	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT18	Allow NULL?
75	DTWS4	Instruction key 4	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT19	Allow NULL?
76	XCPDD	Indicator: Address and bank data set individually	char	1	0	CHAR	(N' ')	Yes		XCPDD	Allow NULL?
77	BUPLA	Business Place	nvarchar	4	0	CHAR	(N' ')	Yes	*	BUPLA	Allow NULL?
78	PPRCT	Partner Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	PPRCTR	Allow NULL?
79	GRANT_NBR	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
80	FKBER	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
81	GEBER	Fund	nvarchar	10	0	CHAR	(N' ')	Yes	*	BP_GEBER	Allow NULL?
82	XINVE	Indicator: Capital Goods Affected?	char	1	0	CHAR	(N' ')	Yes		XINVE	Allow NULL?
83	KEYNO	Key Number for Payment Request	nvarchar	10	0	CHAR	(N' ')	Yes	*	PRQ_KEYNO	Allow NULL?
84	PAMTF	Payment Request Amount in Payment Currency	decimal	13	2	CURR	((0))	Yes		PRQ_AMTFC
85	ORIGIN	Origin Indicator	nvarchar	8	0	CHAR	(N' ')	Yes	*	FIBL_ORIGIN	Allow NULL?
86	EPIC_PROCESSOR	Processor	nvarchar	12	0	CHAR	(N' ')	Yes	*	EPIC_PROCESSOR	Allow NULL?
87	EPIC_STATUS	Item Status	nvarchar	3	0	CHAR	(N' ')	Yes		EPIC_ITEM_STATUS	Allow NULL?
88	AVC_STATUS	Cash Control Status	char	1	0	CHAR	(N' ')	Yes		FMCCAVC_STATUS	Allow NULL?
89	AVC_PRIORITY	Cash Control Priority	nvarchar	6	0	NUMC	(N'000000')	Yes		FMCCAVC_PRIORITY	Allow NULL?
90	FIPOS_ES	Commitment Item	nvarchar	14	0	CHAR	(N' ')	Yes	*	FIPOS	Allow NULL?
91	FISTL_ES	Funds Center	nvarchar	16	0	CHAR	(N' ')	Yes	*	FISTL	Allow NULL?
92	GRANT_NBR_ES	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
93	FKBER_ES	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
94	GEBER_ES	Fund	nvarchar	10	0	CHAR	(N' ')	Yes	*	BP_GEBER	Allow NULL?
95	PROJK_ES	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	PS_PSP_PNR	Allow NULL?
96	CISUB1_ES	Substring 1 of Commitment Item	nvarchar	10	0	CHAR	(N' ')	Yes		FM_CISUB1	Allow NULL?
97	CISUB2_ES	Substring 2 of Commitment Item	nvarchar	10	0	CHAR	(N' ')	Yes		FM_CISUB2	Allow NULL?
98	CISUB3_ES	Substring 3 of Commitment Item	nvarchar	10	0	CHAR	(N' ')	Yes		FM_CISUB3	Allow NULL?
99	CISUB4_ES	Substring 4 of Commitment Item	nvarchar	10	0	CHAR	(N' ')	Yes		FM_CISUB4	Allow NULL?
100	CISUB5_ES	Substring 5 of Commitment Item	nvarchar	10	0	CHAR	(N' ')	Yes		FM_CISUB5	Allow NULL?
101	LOTKZ_ES	Lot Number for Requests	nvarchar	10	0	CHAR	(N' ')	Yes		PSO_LOTKZ	Allow NULL?
102	EBELN_CO	Purchasing Document Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	EBELN	Allow NULL?
103	SAPLONGNUM	Smart Number	nvarchar	40	0	CHAR	(N' ')	Yes		/SAPPSPRO/LONGNUM	Allow NULL?
104	KBLNR	Document Number for Earmarked Funds	nvarchar	10	0	CHAR	(N' ')	Yes	*	KBLNR	Allow NULL?
105	ACCOUNTANT	Accountant	nvarchar	6	0	CHAR	(N' ')	Yes		FPCR_ACCOUNTANT	Allow NULL?
106	CO_STATUS	Status of Garnishment	nvarchar	2	0	NUMC	(N'00')	Yes		FPCL_CO_STAT	Allow NULL?
107	STCD2	Tax Number 2	nvarchar	11	0	CHAR	(N' ')	Yes		STCD2	Allow NULL?
108	POKEN	Item Indicator	nvarchar	3	0	CHAR	(N' ')	Yes		POKEN	Allow NULL?
109	ZLSPR	Payment Block Key	char	1	0	CHAR	(N' ')	Yes	T008	DZLSPR	Allow NULL?
110	LAUFD_PAY	Date on Which the Program Is to Be Run	nvarchar	8	0	DATS	(N'00000000')	Yes		LAUFD	Allow NULL?
111	LAUFI_PAY	Additional Identification	nvarchar	6	0	CHAR	(N' ')	Yes		LAUFI	Allow NULL?
112	VBLNR_PAY	Document Number of the Payment Document	nvarchar	10	0	CHAR	(N' ')	Yes		VBLNR	Allow NULL?
113	PYORD_PAY	Payment Order	nvarchar	10	0	CHAR	(N' ')	Yes		PYORD	Allow NULL?
114	XF110_EXEC	General Flag	char	1	0	CHAR	(N' ')	Yes		FLAG	Allow NULL?
115	LAUFD	Date of Proposal Run	nvarchar	8	0	DATS	(N'00000000')	Yes		FPRL_LAUFD	Allow NULL?
116	LAUFI	Payment Proposal	nvarchar	6	0	CHAR	(N' ')	Yes		FPRL_LAUFI	Allow NULL?
117	JOBCOUNT	Job ID	nvarchar	8	0	CHAR	(N' ')	Yes		BTCJOBCNT	Allow NULL?
118	ZBUKR	Paying company code	nvarchar	4	0	CHAR	(N' ')	Yes	T001	DZBUKR	Allow NULL?
119	ABSBU	Sending company code	nvarchar	4	0	CHAR	(N' ')	Yes	*	ABSBU	Allow NULL?
120	ZNME1	Name of the payee	nvarchar	35	0	CHAR	(N' ')	Yes		DZNME1	Allow NULL?
121	ZPSTL	Postal code of the payee	nvarchar	10	0	CHAR	(N' ')	Yes		DZPSTL	Allow NULL?
122	ZORT1	City of the payee	nvarchar	35	0	CHAR	(N' ')	Yes		DZORT1	Allow NULL?
123	ZLAND	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	*	DZLAND	Allow NULL?
124	ZREGI	Regional code of the payee	nvarchar	3	0	CHAR	(N' ')	Yes	*	DZREGI	Allow NULL?
125	ZSPRA	Language key of the payee	char	1	0	LANG	(N' ')	Yes	*	DZSPRA	Allow NULL?
126	NAME1	Name 1	nvarchar	35	0	CHAR	(N' ')	Yes		NAME1_GP	Allow NULL?
127	ZBVTY	Bank Data Indicator for the Payee	nvarchar	4	0	CHAR	(N' ')	Yes		DZBVTY	Allow NULL?
128	ZBNKS	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	*	DZBNKS	Allow NULL?
129	ZBNKY	Bank key of the payee's bank	nvarchar	15	0	CHAR	(N' ')	Yes		DZBNKY	Allow NULL?
130	ZBNKL	Bank number of the payee's bank	nvarchar	15	0	CHAR	(N' ')	Yes		DZBNKL	Allow NULL?
131	ZBNKN	Bank account number of the payee	nvarchar	18	0	CHAR	(N' ')	Yes		DZBNKN	Allow NULL?
132	ZBKON	Bank Control Key of the Payee's Bank	nvarchar	2	0	CHAR	(N' ')	Yes		DZBKON	Allow NULL?
133	BKREF	Reference specifications for bank details	nvarchar	20	0	CHAR	(N' ')	Yes		BKREF	Allow NULL?
134	ZSWIF	SWIFT/BIC for International Payments	nvarchar	11	0	CHAR	(N' ')	Yes		SWIFT	Allow NULL?
135	ZIBAN	IBAN (International Bank Account Number)	nvarchar	34	0	CHAR	(N' ')	Yes		IBAN	Allow NULL?
136	KOINH	Account Holder Name	nvarchar	60	0	CHAR	(N' ')	Yes		KOINH_FI	Allow NULL?
137	HKTID	ID for account details	nvarchar	5	0	CHAR	(N' ')	Yes	*	HKTID	Allow NULL?
138	HBKID	Short Key for a House Bank	nvarchar	5	0	CHAR	(N' ')	Yes	T012	HBKID	Allow NULL?
139	UBNKS	Bank country key	nvarchar	3	0	CHAR	(N' ')	Yes	*	BANKS	Allow NULL?
140	UBNKY	Bank key of our bank	nvarchar	15	0	CHAR	(N' ')	Yes		UBNKY	Allow NULL?
141	UBNKL	Bank number of our bank	nvarchar	15	0	CHAR	(N' ')	Yes		UBNKL	Allow NULL?
142	UBKNT	Our account number at the bank	nvarchar	18	0	CHAR	(N' ')	Yes		UBKNT	Allow NULL?
143	UBKON	Bank control key at our bank	nvarchar	2	0	CHAR	(N' ')	Yes		UBKON	Allow NULL?
144	UBHKT	G/L Account Number for Our Bank Account / Bank Sub-Account	nvarchar	10	0	CHAR	(N' ')	Yes	*	UBHKT	Allow NULL?
145	RZAWE	Payment Method	char	1	0	CHAR	(N' ')	Yes	T042Z	DZLSCH	Allow NULL?
146	UZAWE	Payment Method Supplement	nvarchar	2	0	CHAR	(N' ')	Yes	T042F	UZAWE	Allow NULL?
147	DTAWS	Instruction key for data medium exchange	nvarchar	2	0	CHAR	(N' ')	Yes	*	DTAWS	Allow NULL?
148	ZALDT	Posting date of the payment document	nvarchar	8	0	DATS	(N'00000000')	Yes		DZALDT_ZHL	Allow NULL?
149	VALUT	Value date	nvarchar	8	0	DATS	(N'00000000')	Yes		VALUT	Allow NULL?
150	AUSFD	Due date of the paid items	nvarchar	8	0	DATS	(N'00000000')	Yes		AUSFD	Allow NULL?
151	ANFAE	Bill of Exchange Payment Request Due Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ANFAE	Allow NULL?
152	WEFAE	Bill of Exchange Due Date	nvarchar	8	0	DATS	(N'00000000')	Yes		WEFAE	Allow NULL?
153	WDATE	Bill of Exchange Issue Date	nvarchar	8	0	DATS	(N'00000000')	Yes		WDATE	Allow NULL?
154	BUSAB	Accounting clerk	nvarchar	2	0	CHAR	(N' ')	Yes	*	BUSAB	Allow NULL?
155	EIKTO	Shipper's (Our) Account Number at the Customer or Vendor	nvarchar	12	0	CHAR	(N' ')	Yes		EIKTO	Allow NULL?
156	KIDNO	Payment Reference	nvarchar	30	0	CHAR	(N' ')	Yes		KIDNO	Allow NULL?
157	RFTTRN	Payment code	nvarchar	20	0	CHAR	(N' ')	Yes		RFTTRN_BF	Allow NULL?
158	BTYP1	Type of bank in a bank chain (correspondent, intermediary)	char	1	0	CHAR	(N' ')	Yes		BNTYP	Allow NULL?
159	BNKS1	Bank country key	nvarchar	3	0	CHAR	(N' ')	Yes	*	BANKS	Allow NULL?
160	BNKL1	Bank Keys	nvarchar	15	0	CHAR	(N' ')	Yes		BANKK	Allow NULL?
161	BNKN1	Bank account number	nvarchar	18	0	CHAR	(N' ')	Yes		BANKN	Allow NULL?
162	BTYP2	Type of bank in a bank chain (correspondent, intermediary)	char	1	0	CHAR	(N' ')	Yes		BNTYP	Allow NULL?
163	BNKS2	Bank country key	nvarchar	3	0	CHAR	(N' ')	Yes	*	BANKS	Allow NULL?
164	BNKL2	Bank Keys	nvarchar	15	0	CHAR	(N' ')	Yes		BANKK	Allow NULL?
165	BNKN2	Bank account number	nvarchar	18	0	CHAR	(N' ')	Yes		BANKN	Allow NULL?
166	BTYP3	Type of bank in a bank chain (correspondent, intermediary)	char	1	0	CHAR	(N' ')	Yes		BNTYP	Allow NULL?
167	BNKS3	Bank country key	nvarchar	3	0	CHAR	(N' ')	Yes	*	BANKS	Allow NULL?
168	BNKL3	Bank Keys	nvarchar	15	0	CHAR	(N' ')	Yes		BANKK	Allow NULL?
169	BNKN3	Bank account number	nvarchar	18	0	CHAR	(N' ')	Yes		BANKN	Allow NULL?
170	MGUID	SEPA Mandate: GUID of Mandate	varbinary	16	0	RAW		Yes		SEPA_MGUID
171	MNDID	Unique Referene to Mandate per Payment Recipient	nvarchar	35	0	CHAR	(N' ')	Yes		SEPA_MNDID	Allow NULL?
172	INV_NO	Document Number or Invoice Reference Number	nvarchar	10	0	CHAR	(N' ')	Yes		FPRL_REBZG	Allow NULL?
173	INV_YEAR	Fiscal Year of DocNo/Inf.ref.	nvarchar	4	0	NUMC	(N'0000')	Yes		FPRL_REBZJ	Allow NULL?
174	INV_ITEM	Line Item within Accounting Document or Relevant Invoice	nvarchar	3	0	NUMC	(N'000')	Yes		FPRL_REBZZ	Allow NULL?

TOP ERP 6.0 | FPRL_ITEM INDEXES

Name	Primary	Unique	Type	Columns
FPRL_ITEM~0	Yes	Yes	CLUSTERED	GUID, MANDT
FPRL_ITEM~1	No	No	NONCLUSTERED	BUZEI, GJAHR, BELNR, BUKRS
FPRL_ITEM~2	No	No	NONCLUSTERED	LIST_ID
FPRL_ITEM~3	No	No	NONCLUSTERED	KEYNO

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

174 COLUMNS | 4 INDEXES | ERP 6.0 | FPRL_ITEM TABLE

TOP ERP 6.0 | FPRL_ITEM COLUMNS

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

174 COLUMNS | 4 INDEXES | ERP 6.0 | FPRL_ITEM TABLE

TOPERP 6.0 | FPRL_ITEM COLUMNS

TOPERP 6.0 | FPRL_ITEM INDEXES

TOP ERP 6.0 | FPRL_ITEM COLUMNS

TOP ERP 6.0 | FPRL_ITEM INDEXES