| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RD_VBL | Payroll Result: Supplementary Pension Public Sector | 25 | KTONR | Supplementary Pension: Account Number (Obsolete with ZVMP) | nvarchar | 6 | 0 | | |
2 | T028B | Transaction Type of Sender Bank | 3 | KTONR | Bank account number | nvarchar | 18 | 0 | | |
3 | T5D1L | SI Withholding Deductions (D) | 8 | KTONR | Account Number of Health Insurance Fund | nvarchar | 10 | 0 | | |
TOPBank Customer Accounts |
4 | TBKKIHB6 | Dispatcher per Account Number | 3 | KTONR | Bank account number | nvarchar | 18 | 0 | | |
TOPBasic Functions |
5 | FEBKO | Electronic Bank Statement Header Records | 21 | KTONR | Bank account number | nvarchar | 18 | 0 | | |
6 | T028L | EB: Sender Bank - CM Data | 3 | KTONR | Bank account number | nvarchar | 18 | 0 | | |
7 | T028Q | Mapping Table | 5 | KTONR | Bank account number | nvarchar | 18 | 0 | | |
8 | T028X | Returns Reasons | 4 | KTONR | Bank account number | nvarchar | 18 | 0 | | |
TOPData Collection |
9 | S120 | Sales as per receipts | 36 | KTONR | Bank account number | nvarchar | 18 | 0 | | |
10 | S120BIW1 | S120BIW1 * Sales as Per Receipts | 36 | KTONR | Bank account number | nvarchar | 18 | 0 | | |
11 | S120BIW2 | S120BIW2 * Sales as Per Receipts | 36 | KTONR | Bank account number | nvarchar | 18 | 0 | | |
TOPFinancial Accounting |
12 | TIBAN_APAR | Unconfirmed IBANs and Their Correct Validity Start | 3 | KTONR | Customer/Vendor Account Number | nvarchar | 10 | 0 | | |
TOPLoans Management |
13 | VDZNB_PAYINFO | Payment Postprocessing: Payment Inform. for a PPP Activity | 23 | KTONR | Bank account number | nvarchar | 18 | 0 | | |
TOPOverhead Cost Controlling |
14 | COANZ | Index of Objects With Down Payments/Requests | 4 | KTONR | SD business partner identifier (number or code) | nvarchar | 10 | 0 | | |
TOPPayment Transactions |
15 | T042U | Block Entries for Debit Customers/Credit Vendors | 6 | KTONR | Open item account number | nvarchar | 10 | 0 | | |
TOPPublic Sector |
16 | T5D5N | Supplementary Pension Public Sector: Account Number Table | 8 | KTONR | Supplementary Pension: Account Number (Obsolete with ZVMP) | nvarchar | 6 | 0 | | |
TOPReal Estate Management |
17 | RFVIAUSZUG | Test Data for RE Multicash Statement Data | 7 | KTONR | Account | nvarchar | 24 | 0 | | |
18 | RFVIBK01A | Bank Procedure Test Data - A-Record | 7 | KTONR | Account | nvarchar | 24 | 0 | | |
19 | RFVIBK01C | Bank Procedure Test Data - C-Record | 8 | KTONR | Account | nvarchar | 24 | 0 | | |
20 | RFVIBK01E | Bank Procedure Test Data: E-Record | 7 | KTONR | Account | nvarchar | 24 | 0 | | |
21 | RFVIBK01V | Bank Procedure Test Data - C-Record - File Extension | 8 | KTONR | Account | nvarchar | 24 | 0 | | |
22 | RFVIUMSATZ | Test Data for RE Multicash Sales Data | 8 | KTONR | Account | nvarchar | 24 | 0 | | |