| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /CEERE/FUKDC | Tax office: master data - time dependent | 6 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
2 | /OPT/VIM_1CLEAR | /OPT/VIM_1HEAD Extension with Clearing Documents (BSAK) | 18 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
3 | /OPT/VIM_STG_LIF | Table: Staging data - Vendor master for ICC | 31 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
4 | /OPT/WT_3S_PYMNT | Supplier Self Service Payment Information | 17 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
5 | BBP_RBKP | Document Header: Invoice Receipt | 63 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
6 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 53 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
7 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 55 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
8 | BSEG | Accounting Document Segment | 120 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
9 | BSID_BAK | Accounting: Secondary Index for Customers | 53 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
10 | BSIK_BAK | Accounting: Secondary index for vendors | 55 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
11 | BSSEG | Accounting Document Segment | 109 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
12 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 109 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
13 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 109 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
14 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 109 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
15 | GLPOS_C_CT | FI Document: Entry View | 73 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
16 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 73 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
17 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 73 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
18 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 73 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
19 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 73 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
20 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 73 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
21 | LFBK_EMC_JP_D | Electronic Monetary Claims Japan | 3 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
22 | REGUP | Processed items from payment program | 18 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
TOPAccounting |
23 | VDIOA_CALC_HEAD | Calculation Details for Interest on Arrears Calculation | 21 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
TOPAccounting Interface |
24 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 334 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
25 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 334 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
TOPAdvertising Management |
26 | JHAISZ | IS-M/AM: Assignment Table of Advertisers for OPM Order | 51 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
27 | JHTFK | IS-M/AM: Settlement Documents (Billing, Commission) - Header | 15 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
28 | JHTFX | IS-M/AM: Billing Index - Order Billing | 25 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
TOPAutomatic Payments |
29 | PAYRQ | Payment Requests | 101 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
TOPBasic Functions |
30 | T028RTRANS | Repetitive Transfer Transactions | 22 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
TOPBelgium |
31 | T5BT1 | Exceptional Tax Scales | 3 | BVTYP | Tax Scale Group | nvarchar | 3 | 0 | | |
32 | T5BT2 | Exemption for dependent children | 2 | BVTYP | Tax Scale Group | nvarchar | 3 | 0 | | |
33 | T5BT3 | Reduction for dependent children | 2 | BVTYP | Tax Scale Group | nvarchar | 3 | 0 | | |
TOPBilling |
34 | VBRK | Billing Document: Header Data | 92 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
TOPBusiness Partner |
35 | VTBSTC1 | Components of Payment Details for Standing Instruction | 6 | BVTYP | Partner bank details | nvarchar | 4 | 0 | | |
TOPCross-Application Components |
36 | BBSID | Accounting: Secondary index for customers | 53 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
TOPFinancial Accounting |
37 | /OPT/VIM_1HEAD | Document Header | 150 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
38 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 53 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
39 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 55 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
40 | BSID | Accounting: Secondary Index for Customers | 53 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
41 | BSIK | Accounting: Secondary Index for Vendors | 55 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
42 | EBSEG | Doc.Segment of Fin.Accntng External Documents | 49 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
43 | KMZEI | FI: Account Assignment Model Item Information | 33 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
44 | KNBK | Customer Master (Bank Details) | 7 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
45 | KOMU | Account Assignment Templates for G/L Account Items | 33 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
46 | LFBK | Vendor Master (Bank Details) | 7 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
47 | VBSEGD | Document Segment for Customer Document Parking | 64 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
48 | VBSEGK | Document Segment for Vendor Document Parking | 70 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
TOPFunds Management-Specific Postings |
49 | PSOSEGD | Document Segment: Recurring Request, Customer | 65 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
50 | PSOSEGK | Recurring Request Document Segment, Vendors | 71 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
TOPInvoice Verification |
51 | RBKP | Document Header: Invoice Receipt | 63 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
52 | T8J4B | JV Cash Call Batch table | 17 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
TOPLoans Management |
53 | TTONFTVVZZKOPO | Test neue Fima: VVZZKOPO | 29 | BVTYP | Partnerbanktyp | nvarchar | 4 | 0 | | |
54 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 129 | BVTYP | Partnerbanktyp | nvarchar | 4 | 0 | | |
55 | VDAUSZ | Drawings on Disbursement | 50 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
56 | VDBEPI | Posted line items for document header | 48 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
57 | VDBEPI_SHADOW | Shadow Table for VDBEPI (Restrictions) | 48 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
58 | VDBEPP | Flow Data - Planned Item | 82 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
59 | VDBOBEPP | Business Operation: Entered and Activated Flow Data | 82 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
60 | VDCFWAREHOUSE | Cash Flow Management | 70 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
61 | VDGPO | Loan: Relationship Partner/Role Object | 17 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
62 | VDORDER | Borrower's note loan order data | 60 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
63 | VDREPAYMENT | Payoff Master Data | 68 | BVTYP | Bank Details ID | nvarchar | 4 | 0 | | |
64 | VZFZE_VDAUSZ | Central Entry Table for Release Procedure | 52 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
65 | VZFZE_VDBEPP | Central Entry Table for Release Procedure | 85 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
TOPMaster Data |
66 | JGTKNBKFSY | IS-M: Index for Synchronization of Cust.Bank with Th.-Pty FI | 4 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
67 | JGTLFBKFSY | IS-M: Index for Synchronization of Vendor Bank w/Th.-Pty FI | 4 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
68 | VDESCROWKOPO0 | TEMPORARY USE: Escrow Condition Items | 28 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
TOPPayment Transactions |
69 | FPCR_CESS | Garnishment Register Attributes | 22 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
70 | REGUH | Settlement data from payment program | 52 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
71 | REGUHO | REGUH version before the 'n'th change | 25 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
TOPPayroll |
72 | T5T1L | Bank accounts of authorities (tax,insurance) | 25 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
73 | T5TPS1L | Bank accounts of authorities (tax,insurance) | 27 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
74 | T7SK1L | Bank accounts of authorities (tax,insurance) | 28 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
TOPPeriodical Sales and Distribution |
75 | JFDFS | IS-M/SD: Billing/Settlement Index | 26 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
76 | JFXBPOSDL | IS-M: Backup Transfer Internal Table XBPOS | 34 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
77 | JKPA | Sales Order: Partner | 22 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
78 | JNTRECH | IS-M/SD: Research | 40 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
TOPPortfolio |
79 | VDCNCL | Rescission of Business Operation | 18 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
TOPReal Estate Localization Czech Republic |
80 | /CEERE/FUKD | Tax office: master data | 4 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
TOPReal Estate Management |
81 | BPOBIMMO | Business Partner - Object Relationship: Real Estate | 15 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
82 | VIAKBSEG | Document Line Item from SCS for Interface | 37 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
83 | VIBEPP | Flow data - Planned items for real estate management | 32 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
84 | VIMIIH | Invoice Header | 10 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
TOPReal Estate Slovakia |
85 | TIVXCSKVZN | Local regulations: rates, prices, increments | 15 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
TOPReceivablesPayment Management |
86 | VDAD_CONTROL | Table with Dates for Auto Debit Run | 11 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
87 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 111 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
TOPService Station Retailing |
88 | OIRC_FUELS_PR | SSR - Processing profile | 72 | BVTYP | Partner bank type for invoicing items | nvarchar | 4 | 0 | | |
TOPSocial Insurance |
89 | P01BV_STAT | Status Table for PPO Contribution Collect. Notif. Procedure | 4 | BVTYP | Notification Category for PPO Collection of Contributions | nvarchar | 1 | 0 | | |
TOPTreasury |
90 | SPBB1 | Partner-Bank relationship | 7 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
91 | VZGPO | Partner/role object relationship | 17 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
92 | VZZKOPO | Table condition items | 31 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
93 | VZZPARO | Partner / Role / Object relationship | 12 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |
94 | VZZUSP | Payment splitting | 15 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | | |