| 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) | 37 | PMNT_BLOCK | Line Item Blocked for Payment? | nvarchar | 1 | 0 | | |
2 | TEBPPEXTSTATUS | External description of the invoice | 3 | PMNT_BLOCK | Block Key for Payment | nvarchar | 1 | 0 | | |
3 | TEBPPEXTSTATUST | Text table for TEBPPEXTSTATUS | 4 | PMNT_BLOCK | Block Key for Payment | nvarchar | 1 | 0 | | |
TOPBasis Components |
4 | /XFT/INV_Q | Invoice receipt queue: Header | 56 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
5 | /XFT/INV_Q_S | Invoice receipt queue: Header | 56 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
TOPFunds Management-Specific Postings |
6 | IFMPDCUST | Payment Directive Settings | 9 | PMNT_BLOCK | Payment Block Key for Payment Directives | nvarchar | 1 | 0 | | |
TOPGrantor Management |
7 | GTRFIAPAR | Grantor: FI AP/AR related data | 3 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
TOPIncentive and Commission Management ICM |
8 | CACS00_DOCFI_P | Data Transfer: FI Documents (Items) | 13 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
9 | CACS00_DOCSE | Commission Document, Settlement | 27 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
10 | CACSCD_DOCCD_PD | Settlement to FS-CD: Reference Document Line Items | 6 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
11 | CACSFI_DOCFI_PD | Settlement to FI: Reference Line Item | 8 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
12 | CACSHR_DOCHR_PD | Settlement to PY: Reference Line Item | 22 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
13 | TCACS_STMTY | Settlement Type | 12 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
14 | YCRM01_ACCST | Account Assignment Type/Cost Info for Settlement Types | 11 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
15 | YCRM01_DOCFI_P | Data Transfer: FI Documents Item | 15 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
16 | YCRM01_DOCSE | Commission Document: Due Dates | 27 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
17 | YHITEC_DOCFI_P | Data Transfer: FI Documents Item | 13 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
18 | YHITEC_DOCSE | Commission Document: Due Dates | 27 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
19 | YSVMA_ACCAS | Account Assignment Type/Cost Information for Remuneration | 5 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
20 | YSVMA_ACCST | Account Assignment Type/Cost Info for Settlement Types | 12 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
21 | YSVMA_DOCFI_P | Data Transfer: FI Documents (Items) | 13 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
22 | YSVMA_DOCSE | Commission Document: Due Dates | 27 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
23 | YTEL01_ACCAS | Account Assignment Type/Cost Information for Remuneration | 19 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
24 | YTEL01_ACCST | Account Assignment Type/Cost Info for Settlement Types | 11 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
25 | YTEL01_DOCFI_P | Data Transfer: FI Documents Item | 13 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
26 | YTEL01_DOCSE | Commission Document: Due Dates | 44 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
27 | YTEL05_ACCAS | Account Assignment Type/Cost Information for Remuneration | 6 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
28 | YTEL05_ACCST | Account Assignment Type/Cost Info for Settlement Types | 6 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
29 | YTEL05_DOCFI_P | Data Transfer: FI Documents (Items) | 13 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
30 | YTEL05_DOCSE | Commission Document: Due Dates | 33 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
31 | ZICMAG_DOCFI_P | Data Transfer: FI Documents (Items) | 13 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |
32 | ZICMAG_DOCSE | Commission Document: Due Dates | 27 | PMNT_BLOCK | Payment Block Key | nvarchar | 1 | 0 | | |