| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /ATL/LHTMBNK | Reconciled bank lines | 7 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |
2 | EPIC_BRS_EBS_BUF | epic: brs ebs line item value date period snap shot | 2 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |
3 | EPIC_EBR_FEB | Additional Data on Bank Statement Line Item for Bank Receipt | 3 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |
4 | FIAPPTD_KUKEY | ID administration | 6 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |
TOPBasic Functions |
5 | FEBCL | Clearing data for an electronic bank statement line item | 2 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |
6 | FEBEP | Electronic Bank Statement Line Items | 2 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |
7 | FEBKEY | ID administration | 3 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |
8 | FEBKO | Electronic Bank Statement Header Records | 6 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |
9 | FEBMS | Message table for Finnish bank statement | 2 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |
10 | FEBPI | Polling Statement Line Item Information | 2 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |
11 | FEBRE | Reference record for electronic bank statement line item | 2 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |
TOPCash Desk |
12 | FMSHERLOCK | Clarification List (Payments to be Clarified) | 2 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |
TOPContract Accounts Receivable and Payable |
13 | FKKBEP | Electronic Bank Statement Line Items | 2 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |
14 | FKKBRINSEQ | Brazil : Storing Sequence Number of Incoming Files | 8 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |
TOPElectronic Bank Statement |
15 | FEBIP | Posting Parameters for Postprocessing | 2 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |
16 | FEBRE_ORIG | Original Ref. Record for an Elec. Bank Statement Line Item | 2 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |
17 | FEB_ACCNT_SAVE | Saving of Posting Lines for Postprocessing (Account Assign.) | 2 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |
18 | FEB_AVIR_EXTD | Advice Note Subitem Enhancement (Bank Statement Postproc.) | 13 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |
19 | FEB_ITEM_SAVE | Saving of Posting Items for Postprocessing (On Account) | 2 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |
20 | FEB_PARMT_POST | Posting Parameters for Postprocessing | 2 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |
TOPLoans Management |
21 | VDZNB_PAYINFO | Payment Postprocessing: Payment Inform. for a PPP Activity | 11 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |
TOPRental Accounting |
22 | VIRALSRHD | Statistics - Returned Debit Memos in RE: Header Data | 5 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |
23 | VIRALSRIT | Statistics - Returned Debit Memos in RE: Source Items | 5 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |
TOPTreasury |
24 | FLQITEMBS | Liquidity Calculation - Line Items for Bank Statement Docs | 11 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |
25 | FLQITEMFI_TP | Liquidity Calculation: Actual Line Items at Top Level | 11 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | | |