| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAccounts Receivable Accounting Process Integration |
1 | FDM_DOC_MIRROR | Document Information (Raw Data in Substitute System) | 46 | ALLOC_NMBR | Assignment Number | nvarchar | 18 | 0 | | |
TOPBack Office |
2 | TRFT_MAN_POST | Manual Posting | 11 | ALLOC_NMBR | Assignment Number | nvarchar | 18 | 0 | | |
3 | TRST_POSCHG_FLOW | CFM: Flow for Securities Account Position Change | 23 | ALLOC_NMBR | Assignment Number | nvarchar | 18 | 0 | | |
4 | TRST_SECACCTRANS | Treasury: Securities Account Transfer | 24 | ALLOC_NMBR | Assignment Number | nvarchar | 18 | 0 | | |
TOPBasis Components |
5 | /XFT/INV_Q | Invoice receipt queue: Header | 79 | ALLOC_NMBR | Assignment Number | nvarchar | 18 | 0 | | |
6 | /XFT/INV_Q_S | Invoice receipt queue: Header | 79 | ALLOC_NMBR | Assignment Number | nvarchar | 18 | 0 | | |
TOPGL Account Posting |
7 | TCJ_POSITIONS | Cash Journal Document Items | 93 | ALLOC_NMBR | Assignment Number | nvarchar | 18 | 0 | | |
TOPLease Accounting |
8 | FIOTPOI | One-Time Postings: Items | 13 | ALLOC_NMBR | Assignment Number | nvarchar | 18 | 0 | | |
TOPTransaction Manager |
9 | SLDT_FLOW | Subledger Distributor Transactions | 7 | ALLOC_NMBR | Assignment Number | nvarchar | 18 | 0 | | |
10 | TCAT_FLOW | Flow Table of the Corporate Actions | 7 | ALLOC_NMBR | Assignment Number | nvarchar | 18 | 0 | | |
11 | TERT_FLOW | Flow Table for Rights that can be Exercised | 7 | ALLOC_NMBR | Assignment Number | nvarchar | 18 | 0 | | |
12 | TRDT_FLOW | Persistent distributor flows | 5 | ALLOC_NMBR | Assignment Number | nvarchar | 18 | 0 | | |
TOPTreasury and Risk Management |
13 | TREAT_FLOW | Treasury: TREA Flows | 18 | ALLOC_NMBR | Assignment Number | nvarchar | 18 | 0 | | |