| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /CCEE/CSFI_CLEAR | Documents for clearing | 9 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
2 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 26 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
3 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 26 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
4 | BSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 23 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
5 | BSEG | Accounting Document Segment | 38 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
6 | BSID_BAK | Accounting: Secondary Index for Customers | 26 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
7 | BSIK_BAK | Accounting: Secondary index for vendors | 26 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
8 | BSIS_BAK | Accounting: Secondary Index for G/L Accounts | 23 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
9 | BSSEG | Accounting Document Segment | 27 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
10 | FAGLBSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 23 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
11 | FAGLBSIS_BAK | Accounting: Secondary Index for G/L Accounts | 23 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
12 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 27 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
13 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 27 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
14 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 27 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
15 | FUDT_VDOCBSEZ | Item Additional Information of Verification Doc | 21 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
16 | FUDT_VDOCBSEZH | Item Additional Information of Verification Doc(History) | 21 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
17 | J_1UF_INV_REF | Document references to FI Invoice processed items | 24 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
18 | J_1UF_ORD_IN_TAX | Order data used in tax vouchers and corrections | 19 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
19 | REGUP | Processed items from payment program | 37 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
TOPAccounting Interface |
20 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 461 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
21 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 461 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
TOPCross-Application Components |
22 | BBSID | Accounting: Secondary index for customers | 26 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
TOPData Retention Tool |
23 | TXW_S_BSEG | Retrieve BSEG from archive | 81 | MWSTS | Tax amount in local currency | nvarchar | 16 | 0 | | |
TOPFinancial Accounting |
24 | AVIP | Payment Advice Line Item | 20 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
25 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 26 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
26 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 26 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
27 | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 23 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
28 | BSID | Accounting: Secondary Index for Customers | 26 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
29 | BSIK | Accounting: Secondary Index for Vendors | 26 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
30 | BSIS | Accounting: Secondary Index for G/L Accounts | 23 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
31 | EBSEG | Doc.Segment of Fin.Accntng External Documents | 19 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
32 | PARCT | Receipt Log Table | 13 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
33 | VBSEGD | Document Segment for Customer Document Parking | 20 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
34 | VBSEGK | Document Segment for Vendor Document Parking | 20 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
TOPFlexible Real Estate Management |
35 | VIAKHO20 | WEG-Verwaltung: Guthaben/Forderungen Eigentümerabrechnung | 27 | MWSTS | Steuerbetrag in Hauswährung | decimal | 13 | 2 | | |
36 | VIXCOTDOC | COA, Distribution of VAT, Documents | 16 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
TOPFunds Management |
37 | KBLP | Document Item: Manual Document Entry | 112 | MWSTS | Card Document: Tax on Sales/Purchases Paid in Local Currency | decimal | 15 | 2 | | |
TOPFunds Management-Specific Postings |
38 | PSOSEGD | Document Segment: Recurring Request, Customer | 21 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
39 | PSOSEGK | Recurring Request Document Segment, Vendors | 21 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
TOPGeneral Ledger Accounting |
40 | FAGLBSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 23 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
41 | FAGLBSIS | Accounting: Secondary Index for G/L Accounts | 23 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
TOPInformation System |
42 | DKKOP | Balance Audit Trail | 49 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
43 | DKOKP | Open Item Account Balance Audit Trail | 39 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
44 | DSKOP | Balance Audit Trail | 52 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
TOPReal Estate Management |
45 | VIAK14 | RA credit memo/receivable:now only used as structure! | 26 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
46 | VIAK20 | RA credit memo/receivable (incid.exp.sttlmnt created) | 26 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
47 | VIAKBSEG | Document Line Item from SCS for Interface | 112 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
48 | VITAXD | Tax Shares per Real Estate Account Assignment | 11 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
49 | VIVSTB | Document reference for input tax treatment | 29 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |
TOPRemaining Beverage - Obsolete Objects |
50 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 29 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | | |