1. Home
  2. Resources
  3. SAP Tables
  4. REGUO - Extract from the payment records for online list

SAP Table REGUO

Extract from the payment records for online list

REGUO (Extract from the payment records for online list) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link REGUO to other SAP tables.

REGUO table fields

Field Data element Checktable Datatype Length Decimals
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
KUNNR Customer Number KUNNR CHAR 10 0
EMPFG Payee code EMPFG CHAR 16 0
VBLNR Document Number of the Payment Document VBLNR CHAR 10 0
AVISG Reason for Printing Payment Advice AVISG CHAR 1 0
A Zero balance notification
V Clearing (payment and notification already made)
WAERS Currency Key WAERS CUKY 5 0
SRTGB Business Area GSBER CHAR 4 0
SRTBP Business Place BUPLA CHAR 4 0
NAME1 Name 1 NAME1_GP CHAR 35 0
ORT01 City ORT01_GP CHAR 35 0
LAND1 Country Key LAND1 CHAR 3 0
REGIO Region (State, Province, County) REGIO CHAR 3 0
ZNME1 Name of the payee DZNME1 CHAR 35 0
ZORT1 City of the payee DZORT1 CHAR 35 0
ZLAND Country Key DZLAND CHAR 3 0
ZBNKS Country Key DZBNKS CHAR 3 0
ZBNKN Bank account number of the payee DZBNKN CHAR 18 0
ZBNKL Bank number of the payee's bank DZBNKL CHAR 15 0
ZBKON Bank Control Key of the Payee's Bank DZBKON CHAR 2 0
ZBVTY Bank Data Indicator for the Payee DZBVTY CHAR 4 0
ZSWIF SWIFT/BIC for International Payments SWIFT CHAR 11 0
RZAWE Payment Method for This Payment RZAWE CHAR 1 0
HKTID ID for account details HKTID CHAR 5 0
HBKID Short Key for a House Bank HBKID CHAR 5 0
HKTIW Short Key of the Account Data for the Bill of Exchange HKTIW CHAR 5 0
HBKIW Short Key of the House Bank for Bill/Exch.for Check/Bill/Ex. HBKIW CHAR 5 0
BVTYP Partner Bank Type BVTYP CHAR 4 0
VALUT Value date VALUT DATS 8 0
WDATE Bill of Exchange Issue Date WDATE DATS 8 0
ANFAE Bill of Exchange Payment Request Due Date ANFAE DATS 8 0
WEFAE Bill of Exchange Due Date WEFAE DATS 8 0
WEVWV Planned usage of the bill of exchange WEVWV CHAR 1 0
D Discounting
I Collection
F Forfeiting
RBETR Amount in Local Currency RBETR CURR 13 2
RSKON Total Cash Discount for the Payment Trans. (Local Currency) RSKON CURR 13 2
SKVHW Lost Cash Discount in Local Currency SKVHW CURR 13 2
RWBTR Amount Paid in the Payment Currency RWBTR CURR 13 2
RWSKT Total Cash Discount for the Pmnt Transactn in Pmnt Currency RWSKT CURR 13 2
SKVFW Lost Cash Discount in Payment Currency SKVFW CURR 13 2
DSKVH Impending Lost Cash Discount in Local Currency DSKVH CURR 13 2
RPOST Number of Items Paid RPOST DEC 5 0
RTEXT Number of Text Lines for the Items Paid RTEXT_D DEC 5 0
RUMSK Special G/L Indicator of the Payment Transaction RUMSK CHAR 1 0
RZUMS Target Special G/L Indicator of the Payment Transaction RZUMS CHAR 1 0
WEHMX Maximum Amount per Bill of Exchange in Local Currency WEHMX CURR 13 2
WEFMX Maximum Amount per Bill of Exchange in Payment Currency WEFMX CURR 13 2
WEHRS Remaining Amount in Local Crcy for Last Bill of Exchange WEHRS CURR 13 2
WEFRS Remaining Amount in Payment Crcy for Last Bill of Exchange WEFRS CURR 13 2
WEAMX Number of Bills of Exchange with Maximum Amount WEAMX DEC 3 0
RSPE1 Form Charges SPES1 CURR 11 2
RSPE2 Form Charges SPES2 CURR 11 2
RSPM1 Form Charges for Bill of Exchange with Maximum Amount SPEM1 CURR 11 2
RSPM2 Form Charges for Bill of Exchange with Maximum Amount SPEM2 CURR 11 2
BUSAB Accounting clerk BUSAB CHAR 2 0
INSEL Indicator: Partial Selection of Postings INSEL NUMC 1 0
ORISO Index Number for Original Sorting ORISO DEC 7 0
TYPAE Type of Change TYPAE CHAR 1 0
UBHKT G/L Account Number for Our Bank Account / Bank Sub-Account UBHKT CHAR 10 0
UBKNT Our account number at the bank UBKNT CHAR 18 0
UBKON Bank control key at our bank UBKON CHAR 2 0
UBNKS Bank country key BANKS CHAR 3 0
UBNKL Bank number of our bank UBNKL CHAR 15 0
PAYGR Grouping Field for Automatic Payments PAYGR CHAR 20 0
UBNKY Bank key of our bank UBNKY CHAR 15 0
ZBNKY Bank key of the payee's bank DZBNKY CHAR 15 0
KURSF Exchange rate KURSF DEC 9 5
RBET2 Amount Paid in Second Local Currency RBET2 CURR 13 2
RBET3 Amount Paid in Third Local Currency RBET3 CURR 13 2
RSKO2 Payment Transaction Total Discount in Second Local Currency RSKO2 CURR 13 2
RSKO3 Payment Transaction Total Discount in Third Local Currency RSKO3 CURR 13 2
KURS2 Exchange Rate for the Second Local Currency KURS2 DEC 9 5
KURS3 Exchange Rate for the Third Local Currency KURS3 DEC 9 5
BKREF Reference specifications for bank details BKREF CHAR 20 0
UZAWE Payment Method Supplement UZAWE CHAR 2 0
ZPFOR City of payee's PO box PFORT_Z CHAR 35 0
AUSFD Due date of the paid items AUSFD DATS 8 0
AUGDT Clearing Date AUGDT DATS 8 0
DTAWS Instruction key for data medium exchange DTAWS CHAR 2 0
EDIAV EDI Payment Advice Status EDIAV CHAR 1 0
NULL Customer/vendor has no EDI connection
X Cust./vend.has EDI connection, pyt adv./pyt ord.not yet sent
V Payment advice/payment order sent
E Transmission error, pyt advice/pyt carrier was created
EDIBN EDI Payment Order Status EDIBN CHAR 1 0
NULL Customer/vendor has no EDI connection
X Cust./vend.has EDI connection, pyt adv./pyt ord.not yet sent
V Payment advice/payment order sent
E Transmission error, pyt advice/pyt carrier was created
KOINH Account Holder Name KOINH_FI CHAR 60 0
DTWS1 Instruction key 1 DTAT16 NUMC 2 0
DTWS2 Instruction key 2 DTAT17 NUMC 2 0
DTWS3 Instruction key 3 DTAT18 NUMC 2 0
DTWS4 Instruction key 4 DTAT19 NUMC 2 0
KIDNO Payment Reference KIDNO CHAR 30 0
PYORD Payment Order PYORD CHAR 10 0
VERTN Contract Number RANL CHAR 13 0
VBEWA Flow Type SBEWART CHAR 4 0
BTYP1 Type of bank in a bank chain (correspondent, intermediary) BNTYP CHAR 1 0
1 Sender's correspondent bank
2 Intermediary bank
3 Recipient's correspondent bank
4 External house bank (use for in-house cash payments only)
BNKS1 Bank country key BANKS CHAR 3 0
BNKL1 Bank Keys BANKK CHAR 15 0
BNKN1 Bank account number BANKN CHAR 18 0
BKON1 Bank Control Key BKONT CHAR 2 0
BTYP2 Type of bank in a bank chain (correspondent, intermediary) BNTYP CHAR 1 0
1 Sender's correspondent bank
2 Intermediary bank
3 Recipient's correspondent bank
4 External house bank (use for in-house cash payments only)
BNKS2 Bank country key BANKS CHAR 3 0
BNKL2 Bank Keys BANKK CHAR 15 0
BNKN2 Bank account number BANKN CHAR 18 0
BKON2 Bank Control Key BKONT CHAR 2 0
BTYP3 Type of bank in a bank chain (correspondent, intermediary) BNTYP CHAR 1 0
1 Sender's correspondent bank
2 Intermediary bank
3 Recipient's correspondent bank
4 External house bank (use for in-house cash payments only)
BNKS3 Bank country key BANKS CHAR 3 0
BNKL3 Bank Keys BANKK CHAR 15 0
BNKN3 Bank account number BANKN CHAR 18 0
BKON3 Bank Control Key BKONT CHAR 2 0
SAKNR G/L Account Number SAKNR CHAR 10 0
XURGE Indicator: Extremely Urgent Payment PRQ_XURGE CHAR 1 0
X Yes
NULL No
ZIBAN IBAN of the Payee DZIBAN CHAR 34 0
MGUID SEPA Mandate: GUID of Mandate SEPA_MGUID RAW 16 0
MNDID Unique Referene to Mandate per Payment Recipient SEPA_MNDID CHAR 35 0
SEQ_TYPE SEPA: Sequence Type SEPA_SEQ_TYPE CHAR 4 0
OOFF One-Time Collection
FRST First Recurring Collection
RCUR Recurring Collection
FNAL Last Recurring Collection
INST_CODE Local Instrument Code (Direct Debit Type) FSEPA_INST_CODE CHAR 4 0
CORE SEPA Core Direct Debit
COR1 SEPA Core Direct Debit with D 1 Agreement
B2B SEPA Business-to-Business Direct Debit