| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FUDT_VDOCBKPF | Verification Document Header | 94 | PSOBT | Posting Day | nvarchar | 8 | 0 | | |
2 | FUDT_VDOCBKPFH | Verification Document Header(History) | 94 | PSOBT | Posting Day | nvarchar | 8 | 0 | | |
3 | GLPOS_C_CT | FI Document: Entry View | 359 | PSOBT | Posting Day | nvarchar | 8 | 0 | | |
4 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 353 | PSOBT | Posting Day | nvarchar | 8 | 0 | | |
5 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 353 | PSOBT | Posting Day | nvarchar | 8 | 0 | | |
6 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 353 | PSOBT | Posting Day | nvarchar | 8 | 0 | | |
7 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 368 | PSOBT | Posting Day | nvarchar | 8 | 0 | | |
8 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 362 | PSOBT | Posting Day | nvarchar | 8 | 0 | | |
TOPFinancial Accounting |
9 | ACCTIT | Compressed Data from FI/CO Document | 166 | PSOBT | Posting Day | nvarchar | 8 | 0 | | |
10 | BKPF | Accounting Document Header | 96 | PSOBT | Posting Day | nvarchar | 8 | 0 | | |
TOPFunds Management |
11 | FMIFIIT | FI Line Item Table in Funds Management | 61 | PSOBT | Posting Day | nvarchar | 8 | 0 | | |
12 | FMRC_BKPF | Reconciliation of Headers from FI | 7 | PSOBT | Posting Day | nvarchar | 8 | 0 | | |
13 | FMRC_BSEG | Reconciliation of Lines from FI | 11 | PSOBT | Posting Day | nvarchar | 8 | 0 | | |
14 | FMRC_FMIFIIT | Reconciliation of Lines from FM | 8 | PSOBT | Posting Day | nvarchar | 8 | 0 | | |
15 | FMRC_RC_PAY | Results List: Documents: Bank/Clearing Acct Matching FM-FI | 11 | PSOBT | Posting Day | nvarchar | 8 | 0 | | |
TOPFunds Management-Specific Postings |
16 | FMPSO_TAGRP | Day-End Closing - Closing Group | 6 | PSOBT | Posting Day | nvarchar | 8 | 0 | | |
17 | FMTABBST | Cash Balance with Day-End Closing for Each Closing Group | 4 | PSOBT | Posting Day | nvarchar | 8 | 0 | | |
18 | PSKW2 | Exceptions for Posting Day | 4 | PSOBT | Posting day user | nvarchar | 8 | 0 | | |
19 | PSOKPF | Recurring Request Document Header | 77 | PSOBT | Posting Day | nvarchar | 8 | 0 | | |
TOPInformation system |
20 | PSKW2_LOCK | Tabelle 'Buchungstag sperren' | 4 | PSOBT | Buchungstag Benutzer | nvarchar | 8 | 0 | | |
21 | PSOBFI | FI Position (Day-end Closing) | 9 | PSOBT | Posting Day | nvarchar | 8 | 0 | | |
22 | PSOBFI_INI | FI-Anfangsbestände ( Tagesabschluss) | 9 | PSOBT | Buchungstag | nvarchar | 8 | 0 | | |
23 | PSOBFM | FM Positions Table of Day-end Closing | 5 | PSOBT | Posting Day | nvarchar | 8 | 0 | | |
24 | PSOBFM_INI | FM-Anfangsbestände ( Tagesabschluss) | 5 | PSOBT | Buchungstag | nvarchar | 8 | 0 | | |