| 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 | 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 | VBLNR | Document Number of the Payment Document | nvarchar | 10 | 0 | CHAR | (N' ') | No | | VBLNR | Allow NULL? |
| 5 | ZBUKR | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 6 | HBKID | Short Key for a House Bank | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T012 | HBKID | Allow NULL? |
| 7 | HKTID | ID for account details | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T012K | HKTID | Allow NULL? |
| 8 | UBNKL | Bank number of our bank | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | UBNKL | Allow NULL? |
| 9 | UBKNT | Our account number at the bank | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | UBKNT | Allow NULL? |
| 10 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | EMFSL | Allow NULL? |
| 11 | BANKS | Bank country key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | BANKS | Allow NULL? |
| 12 | BANKL | Bank number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | BANKL | Allow NULL? |
| 13 | BANKN | Bank account number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | BANKN | Allow NULL? |
| 14 | BKONT | Bank Control Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BKONT | Allow NULL? |
| 15 | BKREF | Reference specifications for bank details | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BKREF | Allow NULL? |
| 16 | PSKTO | Account Number of Bank Account At Post Office | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | PSKTO | Allow NULL? |
| 17 | ZLSCH | Payment Method | char | 1 | 0 | CHAR | (N' ') | Yes | T042Z | PCODE | Allow NULL? |
| 18 | LGART | Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | LGART | Allow NULL? |
| 19 | PERNR | Personnel number | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PERSNO | Allow NULL? |
| 20 | BETRG | Amount in Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | RBETR | |
| 21 | LWAER | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 22 | FBETR | Amount Paid in the Payment Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | RWBTR | |
| 23 | WAERS | Payment Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | PAD_WAERS | Allow NULL? |
| 24 | PTEXT | Text for bank transfer | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | PRO_PTEXT | Allow NULL? |
| 25 | EMFTX | Payee Text | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | EMFTX | Allow NULL? |
| 26 | STRAS | House number and street | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | STRAS | Allow NULL? |
| 27 | BKPLZ | Postal Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BKPLZ | Allow NULL? |
| 28 | BKORT | City | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | ORT01 | Allow NULL? |
| 29 | ZIBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | CHAR | (N' ') | Yes | | IBAN | Allow NULL? |
| 30 | ZSWIF | SWIFT/BIC for International Payments | nvarchar | 11 | 0 | CHAR | (N' ') | Yes | | SWIFT | Allow NULL? |
| 31 | FCODE | HRRO: Fiscal code | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | PRO_FCODE | Allow NULL? |
| 32 | SEQNR | Sequence Number | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | SEQC5 | Allow NULL? |
