| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | COPC_PAYRQ_T | COPC: Payment request text | 3 | ESNUM | | nvarchar | 5 | 0 | | |
2 | EPIC_EBR_FEB | Additional Data on Bank Statement Line Item for Bank Receipt | 4 | ESNUM | Memo record number (line item number in bank statement) | nvarchar | 5 | 0 | | |
TOPBasic Functions |
3 | FEBCL | Clearing data for an electronic bank statement line item | 3 | ESNUM | Memo record number (line item number in bank statement) | nvarchar | 5 | 0 | | |
4 | FEBEP | Electronic Bank Statement Line Items | 3 | ESNUM | Memo record number (line item number in bank statement) | nvarchar | 5 | 0 | | |
5 | FEBPI | Polling Statement Line Item Information | 3 | ESNUM | Memo record number (line item number in bank statement) | nvarchar | 5 | 0 | | |
6 | FEBRE | Reference record for electronic bank statement line item | 3 | ESNUM | Memo record number (line item number in bank statement) | nvarchar | 5 | 0 | | |
TOPCash Desk |
7 | FMSHERLOCK | Clarification List (Payments to be Clarified) | 3 | ESNUM | Memo record number (line item number in bank statement) | nvarchar | 5 | 0 | | |
TOPContract Accounts Receivable and Payable |
8 | FKKBEP | Electronic Bank Statement Line Items | 3 | ESNUM | Single Record Number (Line Item Number in Account Statement) | nvarchar | 8 | 0 | | |
TOPElectronic Bank Statement |
9 | FEBRE_ORIG | Original Ref. Record for an Elec. Bank Statement Line Item | 3 | ESNUM | Memo record number (line item number in bank statement) | nvarchar | 5 | 0 | | |
10 | FEB_ACCNT_SAVE | Saving of Posting Lines for Postprocessing (Account Assign.) | 3 | ESNUM | Memo record number (line item number in bank statement) | nvarchar | 5 | 0 | | |
11 | FEB_AVIR_EXTD | Advice Note Subitem Enhancement (Bank Statement Postproc.) | 14 | ESNUM | Memo record number (line item number in bank statement) | nvarchar | 5 | 0 | | |
12 | FEB_ITEM_SAVE | Saving of Posting Items for Postprocessing (On Account) | 3 | ESNUM | Memo record number (line item number in bank statement) | nvarchar | 5 | 0 | | |
TOPLoans Management |
13 | VDZNB_PAYINFO | Payment Postprocessing: Payment Inform. for a PPP Activity | 12 | ESNUM | Memo record number (line item number in bank statement) | nvarchar | 5 | 0 | | |
TOPRental Accounting |
14 | VIRALSRIT | Statistics - Returned Debit Memos in RE: Source Items | 10 | ESNUM | 5 Character Numeric NUMC | nvarchar | 5 | 0 | | |
TOPTreasury |
15 | FLQITEMBS | Liquidity Calculation - Line Items for Bank Statement Docs | 12 | ESNUM | Memo record number (line item number in bank statement) | nvarchar | 5 | 0 | | |
16 | FLQITEMFI_TP | Liquidity Calculation: Actual Line Items at Top Level | 12 | ESNUM | Memo record number (line item number in bank statement) | nvarchar | 5 | 0 | | |