| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 174 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | |
2 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 176 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | |
3 | BSEG | Accounting Document Segment | 289 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | |
4 | BSID_BAK | Accounting: Secondary Index for Customers | 174 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | |
5 | BSIK_BAK | Accounting: Secondary index for vendors | 176 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | |
6 | BSSEG | Accounting Document Segment | 278 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | |
7 | CNV_10520FICAMAP | Mappingtable for conversion of foreign currencies | 10 | KONTL | Acct assnmnt string for industry-specific account assngments | nvarchar | 50 | 0 | | |
8 | CNV_10520_DOCMAP | CNV_10520: Mapping Table for FICA Documents | 6 | KONTL | Acct assnmnt string for industry-specific account assngments | nvarchar | 50 | 0 | | |
9 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 278 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | |
10 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 278 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | |
11 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 278 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | |
TOPCollectionsDisbursements |
12 | VVKKFOP | Single Doc in Posting Data Interface | 69 | KONTL | Acct assnmnt string for industry-specific account assngments | nvarchar | 50 | 0 | | |
13 | VVSCPOS | Payment Plan Item | 63 | KONTL | Acct assnmnt string for industry-specific account assngments | nvarchar | 50 | 0 | | |
TOPContract Accounts Receivable and Payable |
14 | DFKKDEFREV_POS | Line Item Table (Event-Based Deferred Revenues) | 38 | KONTL | Acct assnmnt string for industry-specific account assngments | nvarchar | 50 | 0 | | |
15 | DFKKMOP | Items in contract account document | 92 | KONTL | Acct assnmnt string for industry-specific account assngments | nvarchar | 50 | 0 | | |
16 | DFKKMOPK | Items in contract account document | 44 | KONTL | Acct assnmnt string for industry-specific account assngments | nvarchar | 50 | 0 | | |
17 | DFKKOP | Items in contract account document | 92 | KONTL | Acct assnmnt string for industry-specific account assngments | nvarchar | 50 | 0 | | |
18 | DFKKOPK | Items in contract account document | 44 | KONTL | Acct assnmnt string for industry-specific account assngments | nvarchar | 50 | 0 | | |
19 | DFKKOP_REP | Open Items from FPO4 | 96 | KONTL | Acct assnmnt string for industry-specific account assngments | nvarchar | 50 | 0 | | |
20 | DFKKSUM | Posting totals from FI-CA | 40 | KONTL | Acct assnmnt string for industry-specific account assngments | nvarchar | 50 | 0 | | |
21 | FKKDEFREV | Trigger Table for Deferred Revenue Postings | 40 | KONTL | Acct assnmnt string for industry-specific account assngments | nvarchar | 50 | 0 | | |
TOPElectronic Bank Statement |
22 | FEB_ACCNT_SAVE | Saving of Posting Lines for Postprocessing (Account Assign.) | 67 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | |
23 | FEB_ACT | Acct Assignment Templates | 67 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | |
TOPFinancial Accounting |
24 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 174 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | |
25 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 176 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | |
26 | BSID | Accounting: Secondary Index for Customers | 174 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | |
27 | BSIK | Accounting: Secondary Index for Vendors | 176 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | |
28 | VBSEGA | Document Segment for Document Parking - Asset Database | 64 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | |
29 | VBSEGD | Document Segment for Customer Document Parking | 128 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | |
30 | VBSEGK | Document Segment for Vendor Document Parking | 140 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | |
31 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 123 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | |
TOPFinancial Services Localization |
32 | /GSINS/UPR_DEFRE | UPR - Calculation of unearned insurance premium reserve | 14 | KONTL | Acct assnmnt string for industry-specific account assngments | nvarchar | 50 | 0 | | |
TOPFunds Management-Specific Postings |
33 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 121 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | |
34 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 133 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | |
TOPGeneral Ledger Accounting |
35 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 65 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | |
TOPGL Account Posting |
36 | TCJ_POSITIONS | Cash Journal Document Items | 74 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | |
TOPInvoicing |
37 | DEABPS | Customer change table: Logical view of BB amounts | 84 | KONTL | Acct assnmnt string for industry-specific account assngments | nvarchar | 50 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
38 | /BEV3/CH1030BSG2 | Document Segment CH Event Ledger Part2 | 45 | KONTL | Acct assignment string for industry-specific acct assignmnts | nvarchar | 50 | 0 | | |