| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 140 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
2 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 167 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
3 | BSEG | Accounting Document Segment | 57 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
4 | BSID_BAK | Accounting: Secondary Index for Customers | 140 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
5 | BSIK_BAK | Accounting: Secondary index for vendors | 167 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
6 | BSSEG | Accounting Document Segment | 46 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
7 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 46 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
8 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 46 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
9 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 46 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
10 | GLPOS_C_CT | FI Document: Entry View | 317 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
11 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 317 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
12 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 317 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
13 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 317 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
14 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 326 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
15 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 326 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
16 | MHND | Dunning Data | 64 | ZINKZ | Public Sector Industry Solution: Exempt from Interest Calc. | nvarchar | 2 | 0 | | |
17 | REGUP | Processed items from payment program | 143 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
TOPAccounting Interface |
18 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 202 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
19 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 202 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
TOPCross-Application Components |
20 | BBSID | Accounting: Secondary index for customers | 140 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
TOPFinancial Accounting |
21 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 140 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
22 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 167 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
23 | BSID | Accounting: Secondary Index for Customers | 140 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
24 | BSIK | Accounting: Secondary Index for Vendors | 167 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
25 | VBSEGD | Document Segment for Customer Document Parking | 32 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
26 | VBSEGK | Document Segment for Vendor Document Parking | 37 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
27 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 28 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
TOPFunds Management-Specific Postings |
28 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 29 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
29 | PSOSEGD | Document Segment: Recurring Request, Customer | 33 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
30 | PSOSEGK | Recurring Request Document Segment, Vendors | 38 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
31 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 28 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
TOPInformation System |
32 | DKKOP | Balance Audit Trail | 53 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
33 | DKOKP | Open Item Account Balance Audit Trail | 43 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
34 | DSKOP | Balance Audit Trail | 55 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
TOPLoans Management |
35 | MZDAT | Dunning and interest data for batch input | 15 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
36 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 189 | ZINKZ | Ausnahme von der Verzinsung | nvarchar | 2 | 0 | | |
37 | VDBEPI | Posted line items for document header | 77 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
38 | VDBEPI_SHADOW | Shadow Table for VDBEPI (Restrictions) | 77 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
39 | VDBEPP | Flow Data - Planned Item | 111 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
40 | VDBOBEPP | Business Operation: Entered and Activated Flow Data | 111 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
41 | VDZNB_USAGE | Payment Postprocessing: Usage of a Payment Postpr. Activity | 84 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
42 | VZFZE_VDBEPP | Central Entry Table for Release Procedure | 114 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
TOPReal Estate Management |
43 | VIAKBSEG | Document Line Item from SCS for Interface | 130 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
44 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 48 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | | |