| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | CNV_20100_AVSPO | Mapping for AVIP: AVSPO(old) - AVSPO(new) | 6 | AVSID | | nvarchar | 16 | 0 | | |
| 2 | EPIC_EBR_AV | Additional Data on Payment Advice Line Item for Bank Receipt | 6 | AVSID | Payment Advice Number | nvarchar | 16 | 0 | | |
| 3 | FUDT_VDOCAVIKKEH | Payment advice key for Document Verification | 5 | AVSID | Payment Advice Number | nvarchar | 16 | 0 | | |
| 4 | FUDT_VDOCAVIKKEY | Payment Advice Note Key for Document Verification | 5 | AVSID | Payment Advice Number | nvarchar | 16 | 0 | | |
| TOPAccounts Receivable |
| 5 | CRMD_CCM_LINK | Link from payment item to claim chargeback recovery in CRM | 8 | AVSID | Payment Advice Number | nvarchar | 16 | 0 | | |
| TOPBasic Functions |
| 6 | FEBEP | Electronic Bank Statement Line Items | 54 | AVSID | Payment Advice Number | nvarchar | 16 | 0 | | |
| TOPContract Accounts Receivable and Payable |
| 7 | FKKBEP | Electronic Bank Statement Line Items | 54 | AVSID | Payment Advice Number | nvarchar | 16 | 0 | | |
| TOPDunning |
| 8 | MHNK | Dunning data (account entries) | 44 | AVSID | Payment Advice Number | nvarchar | 16 | 0 | | |
| TOPElectronic Bank Statement |
| 9 | FEB_AVIR_EXTD | Advice Note Subitem Enhancement (Bank Statement Postproc.) | 5 | AVSID | Payment Advice Number | nvarchar | 16 | 0 | | |
| TOPFinancial Accounting |
| 10 | AVIK | Payment Advice Header | 5 | AVSID | Payment Advice Number | nvarchar | 16 | 0 | | |
| 11 | AVIP | Payment Advice Line Item | 5 | AVSID | Payment Advice Number | nvarchar | 16 | 0 | | |
| 12 | AVIR | Payment Advice Subitem | 5 | AVSID | Payment Advice Number | nvarchar | 16 | 0 | | |
| 13 | AVIT | Advice Header: User-Definable Text | 5 | AVSID | Payment Advice Number | nvarchar | 16 | 0 | | |
| 14 | BKORM | Accounting Correspondence Requests | 13 | AVSID | Payment Advice Number | nvarchar | 16 | 0 | | |
