| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | NRZAA | Repayment request | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | PYBUK | Company Code for Automatic Payment Transactions | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 6 | BETRW | Amount in Transaction Currency with +/- Sign | decimal | 13 | 2 | | | | |
| 7 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | | | |
| 8 | BETR2 | Amount in second parallel currency with +/- sign | decimal | 13 | 2 | | | | |
| 9 | BETR3 | Amount in third parallel currency with +/- sign | decimal | 13 | 2 | | | | |
| 10 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | BANKS | Bank country key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | BANKL | Bank Number of Other Bank Key | nvarchar | 15 | 0 | | | | Allow NULL? |
| 13 | BANKN | Bank account number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 14 | BKONT | Bank Control Key | nvarchar | 2 | 0 | | | | Allow NULL? |
| 15 | BKREF | Reference specifications for bank details | nvarchar | 20 | 0 | | | | Allow NULL? |
| 16 | XPGRO | Post Office Bank Current Account | char | 1 | 0 | | | | Allow NULL? |
| 17 | KOINH | Name of Account Holder | nvarchar | 60 | 0 | | | | Allow NULL? |
| 18 | HBKID | Short Key for a House Bank | nvarchar | 5 | 0 | | | | Allow NULL? |
| 19 | HKTID | ID for account details | nvarchar | 5 | 0 | | | | Allow NULL? |
| 20 | PYMET | Payment Method | char | 1 | 0 | | | | Allow NULL? |
| 21 | GSBER | Business Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 22 | SEGMENT | Segment for Segmental Reporting | nvarchar | 10 | 0 | | | | Allow NULL? |
| 23 | PRCTR | Profit Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 24 | HKONT | Account for refunding incoming payments | nvarchar | 10 | 0 | | | | Allow NULL? |
| 25 | PYBEL | Number of Payment Document | nvarchar | 12 | 0 | | | | Allow NULL? |
| 26 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 28 | CPUDT | Day On Which Accounting Document Was Entered | nvarchar | 8 | 0 | | | | Allow NULL? |
| 29 | CPUTM | Time of Entry | nvarchar | 6 | 0 | | | | Allow NULL? |
| 30 | STARA | Status of Repayment Request | char | 1 | 0 | | | | Allow NULL? |
| 31 | TXTVW | Note to Payee in Payment | nvarchar | 80 | 0 | | | | Allow NULL? |
| 32 | APPLK | Application area | char | 1 | 0 | | | | Allow NULL? |
| 33 | ANFBL | Document number of posting made to refund clearing account | nvarchar | 12 | 0 | | | | Allow NULL? |
| 34 | SPZAH | Lock Reason for Automatic Payment | char | 1 | 0 | | | | Allow NULL? |
| 35 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 36 | AEDAT | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 37 | AETIM | Time changed | nvarchar | 6 | 0 | | | | Allow NULL? |
| 38 | C4EYE | Check Reason for Workflows Acc. to Dual Control Principle | nvarchar | 2 | 0 | | | | Allow NULL? |
| 39 | XADRX | Address Data Exists | char | 1 | 0 | | | | Allow NULL? |
| 40 | XABWB | Bank Data of Recipient Explicitly Specified | char | 1 | 0 | | | | Allow NULL? |
| 41 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | | | Allow NULL? |
| 42 | SWIFT | SWIFT/BIC for International Payments | nvarchar | 11 | 0 | | | | Allow NULL? |
