| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Accounts Receivable and Payable |
1 | TFKBA_EXCLUDE | Balances to Be Excluded for Balances Variant | 3 | STVAR | Balances Category for Balances (Key) | nvarchar | 6 | 0 | | |
2 | TFKBA_TRANS | Assignment of Transactions to Balances Categories | 2 | STVAR | Balances Category for Balances (Key) | nvarchar | 6 | 0 | | |
3 | TFKBA_TYPE | Balances Categories for Balances | 2 | STVAR | Balances Category for Balances (Key) | nvarchar | 6 | 0 | | |
4 | TFKBA_TYPET | Name of Balance Categories | 3 | STVAR | Balances Category for Balances (Key) | nvarchar | 6 | 0 | | |
5 | TFKBA_TYPE_GROUP | Balances Categories of Balances Group | 4 | STVAR | Balances Category for Balances (Key) | nvarchar | 6 | 0 | | |
TOPFunds Management |
6 | FMBUD | FI-FM Data Transfer Structure FM4C | 13 | STVAR | Standard variant | nvarchar | 1 | 0 | | |
7 | FMCI | Commitment items master data | 20 | STVAR | Standard variant | nvarchar | 1 | 0 | | |
8 | FMHICI | Commitment items hierarchy | 15 | STVAR | Standard variant | nvarchar | 1 | 0 | | |
9 | FMHIPP | Hierarchy Table of Commitment Items in Chart of Cmmt Items | 5 | STVAR | Standard variant | nvarchar | 1 | 0 | | |
10 | FMVARNT | Chart of Commitment Items Variant: Entity Texts | 4 | STVAR | Standard variant | nvarchar | 1 | 0 | | |