| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000168000 | PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items | 52 | UZAWE | | nvarchar | 2 | 0 | | |
2 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 52 | UZAWE | | nvarchar | 2 | 0 | | |
3 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 60 | UZAWE | | nvarchar | 2 | 0 | | |
4 | /SMD/MD_____00J4 | SID-Tabelle fuer Pmt meth. supplement | 3 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
5 | /SMD/MD_____010E | SID-Tabelle fuer Pmt meth. supplement | 3 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
6 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 111 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
7 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 120 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
8 | BSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 71 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
9 | BSEG | Accounting Document Segment | 255 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
10 | BSID_BAK | Accounting: Secondary Index for Customers | 111 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
11 | BSIK_BAK | Accounting: Secondary index for vendors | 120 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
12 | BSIS_BAK | Accounting: Secondary Index for G/L Accounts | 71 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
13 | BSSEG | Accounting Document Segment | 244 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
14 | FAGLBSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 71 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
15 | FAGLBSIS_BAK | Accounting: Secondary Index for G/L Accounts | 71 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
16 | FSEPA_INST_CD | Local Instrument and Lead Times for SEPA Direct Debits | 13 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
17 | FUDT_VDOCBSECLRH | Additional Data for Document Segment: Clearing Information | 35 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
18 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 244 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
19 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 244 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
20 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 244 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
21 | FUDT_VDOCBSE_CLR | Additional Data for Document Segment: Clearing Information | 35 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
22 | GLPOS_C_CT | FI Document: Entry View | 250 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
23 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 250 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
24 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 250 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
25 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 250 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
26 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 259 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
27 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 259 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
28 | REGUP | Processed items from payment program | 117 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
29 | T042F | Payment method supplements | 2 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
30 | T042H | Text table for additional payment methods | 3 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
31 | TREAT_FLOW_PM | Treasury: TREA Flow Payment Details | 9 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
32 | VDSEPA_DD | Sepa DD - Lead Time Determination | 12 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
TOPAccounting Interface |
33 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 109 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
34 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 109 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
TOPAutomatic Payments |
35 | PAYRQ | Payment Requests | 126 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
TOPBack Office |
36 | TRFT_PACC_BANK | Payment Information | 13 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
37 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 44 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
38 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 44 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
39 | TRST_SECACC_BANK | Payment Details for Securities Account | 13 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
40 | TRST_SECACC_PAY | Downport Payment Information for Securities Management | 12 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
TOPBank Customer Accounts |
41 | TBKKIHB4 | FI Data for Manual Outgoing Payments In-House Bank | 8 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
42 | TBKKIHB5 | Payt Method Determination HQ FI for Payment In-House Bank | 11 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
TOPBank Master Data |
43 | TBCHAIN1 | Bank chains | 7 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
44 | TBCHAIN2 | Bank Chains per Business Partner Account | 8 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
45 | TBCHAIN21 | Bank chains per business partner account (allocation) | 8 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
TOPBusiness Partner |
46 | TIVBPVENDORCMP | Vendor Preassignment (CoCd Data) | 41 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
47 | VTBSTC1 | Components of Payment Details for Standing Instruction | 11 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
TOPCentral Cash Desk Procedure |
48 | FMFGT_IPACD_PMS | IPACed Auto Doc Creation - Payment Method Suppl for Invoice | 5 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
49 | FMFGT_IPCD_BLRT | Document Type for Auto Creation of IPACed Invoices | 7 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
TOPContract Accounts Receivable and Payable |
50 | DPAYH | Payment program - data for payment | 65 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
TOPCross-Application Components |
51 | BBSID | Accounting: Secondary index for customers | 111 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
TOPData Retention Tool |
52 | TXW_S_BSEG | Retrieve BSEG from archive | 85 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
TOPData Transfer |
53 | PPDIT | Transfer to Accounting: Lines in HR IDOCs | 30 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
TOPFinancial Accounting |
54 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 111 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
55 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 120 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
56 | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 71 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
57 | BSE_CLR | Additional Data for Document Segment: Clearing Information | 35 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
58 | BSID | Accounting: Secondary Index for Customers | 111 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
59 | BSIK | Accounting: Secondary Index for Vendors | 120 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
60 | BSIS | Accounting: Secondary Index for G/L Accounts | 71 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
61 | KNB1 | Customer Master (Company Code) | 55 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
62 | LFB1 | Vendor Master (Company Code) | 42 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
63 | T076E | FI-EDI: Assignment Pymt Method - External Pymt Method (Bank) | 8 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
64 | VACSPLT | FI Document Parking (Enjoy): Amount Split | 9 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
65 | VBSEGD | Document Segment for Customer Document Parking | 62 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
66 | VBSEGK | Document Segment for Vendor Document Parking | 68 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
67 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 141 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
TOPFSCM In-House Cash |
68 | IHC_DB_PAY_MAPP | IHC: Clearing Agreement | 8 | UZAWE | Delivered Payment Method Supplement | nvarchar | 2 | 0 | | |
TOPFunds Management |
69 | T042F_FMFG_TC | Pmt Method Supp map to ALC and Pmt Office - US Treas Conf | 2 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
TOPFunds Management-Specific Postings |
70 | PSOSEGD | Document Segment: Recurring Request, Customer | 63 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
71 | PSOSEGK | Recurring Request Document Segment, Vendors | 69 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
TOPGeneral Ledger Accounting |
72 | FAGLBSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 71 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
73 | FAGLBSIS | Accounting: Secondary Index for G/L Accounts | 71 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
TOPInvoice Verification |
74 | RBKP | Document Header: Invoice Receipt | 119 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
75 | RBVS | Invoice Verification: Split Invoice Amount | 8 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
TOPLoans Management |
76 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 247 | UZAWE | Zusatz zum Zahlweg | nvarchar | 2 | 0 | | |
77 | VDBEPI | Posted line items for document header | 134 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
78 | VDBEPI_SHADOW | Shadow Table for VDBEPI (Restrictions) | 134 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
79 | VDBEPP | Flow Data - Planned Item | 158 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
80 | VDBOBEPP | Business Operation: Entered and Activated Flow Data | 158 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
81 | VDORDER | Borrower's note loan order data | 73 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
82 | VDREPAYMENT | Payoff Master Data | 89 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
83 | VDZV | Payment Details for the Loan | 20 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
84 | VZFZE_VDBEPP | Central Entry Table for Release Procedure | 161 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
TOPLocalization |
85 | J_3R0 | Payment with correspondent account | 9 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
86 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 62 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
87 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 61 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
88 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 61 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
89 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 61 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
TOPPayment Transactions |
90 | FPRL_ITEM | Item Data | 146 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
91 | PAYR | Payment Medium File | 60 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
92 | REGUH | Settlement data from payment program | 104 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
93 | REGUHH | REGUH version before the 'n'th change | 33 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
94 | REGUHM | Payment Data for Cross-Payment Run Payment Medium | 14 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
95 | /BEV3/CH1030BSG2 | Document Segment CH Event Ledger Part2 | 11 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
TOPTransaction Manager |
96 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 33 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
97 | OTC_CONV_IFHAPO | Backup Table for Underlying Transaction Flows | 31 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
98 | REFCC | References between CO object numbers, currency differences | 20 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
99 | SLDT_FLOW | Subledger Distributor Transactions | 58 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
100 | TERT_FLOW | Flow Table for Rights that can be Exercised | 27 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
101 | TRDT_FLOW | Persistent distributor flows | 56 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
102 | VTBFHAPO | Transaction Flow | 33 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
103 | VTBFHAPO_MIGR | Migrated Financial Flows | 33 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
104 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 33 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
105 | VTBPFHAPO | Treasury: Flow Shells | 32 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
106 | VTBZV | Payment Details for Transaction | 20 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
107 | VTIFHAPO | Underlying transaction flows | 31 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
TOPTransfer to Financial Accounting |
108 | TRACT_ACCITEM | Accounting Items | 26 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
109 | TRPRT_PAYMENTS | Persistent Data for Payment Requests | 47 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |
TOPTreasury and Risk Management |
110 | TREAT_EXT_ACC_PM | Treasury: External Account Payment Details | 13 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | |