| 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 | 53 | VALUT | | nvarchar | 8 | 0 | | |
2 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 53 | VALUT | | nvarchar | 8 | 0 | | |
3 | /BIC/B0000170000 | PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta | 20 | VALUT | | nvarchar | 8 | 0 | | |
4 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 61 | VALUT | | nvarchar | 8 | 0 | | |
5 | /OPT/VIM_1ITEM_S | Document Item | 93 | VALUT | Value date | nvarchar | 8 | 0 | | |
6 | /OPT/VIM_TITEM | Document Item | 93 | VALUT | Value date | nvarchar | 8 | 0 | | |
7 | BOE_COL_ITEM | Collection item data table | 23 | VALUT | Value date | nvarchar | 8 | 0 | | |
8 | BOE_DIS_ITEM | Discount item data table | 12 | VALUT | Value date | nvarchar | 8 | 0 | | |
9 | BOE_PAY_ITEM | Payment item data table | 12 | VALUT | Value date | nvarchar | 8 | 0 | | |
10 | BSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 32 | VALUT | Value date | nvarchar | 8 | 0 | | |
11 | BSEG | Accounting Document Segment | 54 | VALUT | Value date | nvarchar | 8 | 0 | | |
12 | BSIS_BAK | Accounting: Secondary Index for G/L Accounts | 32 | VALUT | Value date | nvarchar | 8 | 0 | | |
13 | BSSEG | Accounting Document Segment | 43 | VALUT | Value date | nvarchar | 8 | 0 | | |
14 | DFKK_TRIGX_PAY | Outbound Interface: New Trigger Table for Payment Info | 17 | VALUT | Due date for net payment | nvarchar | 8 | 0 | | |
15 | EPIC_EBR_HDR | OBSOLETE!!! | 58 | VALUT | Value date of the item to be cleared | nvarchar | 8 | 0 | | |
16 | FAGLBSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 32 | VALUT | Value date | nvarchar | 8 | 0 | | |
17 | FAGLBSIS_BAK | Accounting: Secondary Index for G/L Accounts | 32 | VALUT | Value date | nvarchar | 8 | 0 | | |
18 | FIAPSAD_ORDR_LT | Line Item for Order Number KSA | 16 | VALUT | Value date | nvarchar | 8 | 0 | | |
19 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 43 | VALUT | Value date | nvarchar | 8 | 0 | | |
20 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 43 | VALUT | Value date | nvarchar | 8 | 0 | | |
21 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 43 | VALUT | Value date | nvarchar | 8 | 0 | | |
22 | GLPCA_CT | Profit Center Documents | 124 | VALUT | Value date | nvarchar | 8 | 0 | | |
23 | GLPCA_T_CT | Profit Center Documents | 140 | VALUT | Value date | nvarchar | 8 | 0 | | |
24 | GLPOS_C_CT | FI Document: Entry View | 251 | VALUT | Value date | nvarchar | 8 | 0 | | |
25 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 251 | VALUT | Value date | nvarchar | 8 | 0 | | |
26 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 251 | VALUT | Value date | nvarchar | 8 | 0 | | |
27 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 251 | VALUT | Value date | nvarchar | 8 | 0 | | |
28 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 260 | VALUT | Value date | nvarchar | 8 | 0 | | |
29 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 260 | VALUT | Value date | nvarchar | 8 | 0 | | |
30 | YVIM_1ITEM | Document Item | 93 | VALUT | Value date | nvarchar | 8 | 0 | | |
TOPAccounting Interface |
31 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 50 | VALUT | Value date | nvarchar | 8 | 0 | | |
32 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 50 | VALUT | Value date | nvarchar | 8 | 0 | | |
TOPAutomatic Payments |
33 | PAYRQ | Payment Requests | 121 | VALUT | Value Date for the Sending Bank | nvarchar | 8 | 0 | | |
TOPBasic Functions |
34 | FEBEP | Electronic Bank Statement Line Items | 15 | VALUT | Value date of the item to be cleared | nvarchar | 8 | 0 | | |
TOPCollectionsDisbursements |
35 | VVKKTRIMA | Trigger for Checking Dunning Status | 7 | VALUT | Value date | nvarchar | 8 | 0 | | |
36 | VVSCPOS | Payment Plan Item | 78 | VALUT | Value date | nvarchar | 8 | 0 | | |
37 | VVSCRESPAYMENT | Bill Scheduling: Universal Life | 14 | VALUT | Value date | nvarchar | 8 | 0 | | |
TOPContract Accounts Receivable and Payable |
38 | DFKKBRLEVYREC | Levy Way: Data from Payment Lot for Levy Way report (Brazil) | 8 | VALUT | Value date | nvarchar | 8 | 0 | | |
39 | DFKKCFRLS | Clarification Cases: Returns Lots | 14 | VALUT | Value date | nvarchar | 8 | 0 | | |
40 | DFKKCMK | Manually Issued Checks Lot: Header Data | 11 | VALUT | Value date | nvarchar | 8 | 0 | | |
41 | DFKKCMP | Manually Issued Checks Lot: Item Data | 10 | VALUT | Value date | nvarchar | 8 | 0 | | |
42 | DFKKCOLLITEM | Collection Units | 16 | VALUT | Value Date | nvarchar | 8 | 0 | | |
43 | DFKKCOLLPAYM | Collection Payments | 10 | VALUT | Value Date | nvarchar | 8 | 0 | | |
44 | DFKKCOL_LOG | Collections Agency File: Settlement Log (Payments) | 9 | VALUT | Value date (batch input) | nvarchar | 8 | 0 | | |
45 | DFKKCR | Repository For Checks | 27 | VALUT | Value date | nvarchar | 8 | 0 | | |
46 | DFKKCRDEL | CR: Deleted Payment Medium / Basic Data | 30 | VALUT | Value date | nvarchar | 8 | 0 | | |
47 | DFKKEXC | External Payment Information | 14 | VALUT | Value date | nvarchar | 8 | 0 | | |
48 | DFKKEXCJ | Cash Journal: Data Store for Inbound Services | 8 | VALUT | Value date | nvarchar | 8 | 0 | | |
49 | DFKKEXC_PAYINFO | Information for Payment Medium | 27 | VALUT | Value date | nvarchar | 8 | 0 | | |
50 | DFKKEXC_SUM | External Payment Information: Totals Records | 8 | VALUT | Value date | nvarchar | 8 | 0 | | |
51 | DFKKEXC_SUM_HIST | Cash Desk Closing History (DFKKEXC_SUM) | 9 | VALUT | Value date | nvarchar | 8 | 0 | | |
52 | DFKKEXC_TMP | External Payment Information: Account Assignment Parameters | 10 | VALUT | Value date | nvarchar | 8 | 0 | | |
53 | DFKKMOPK | Items in contract account document | 18 | VALUT | Value date | nvarchar | 8 | 0 | | |
54 | DFKKOPK | Items in contract account document | 18 | VALUT | Value date | nvarchar | 8 | 0 | | |
55 | DFKKOPKC | Card Data Appendix for FICA Document | 22 | VALUT | Value date | nvarchar | 8 | 0 | | |
56 | DFKKOPK_SHORT | Offsetting Items for FI-CA Document - Extracts | 12 | VALUT | Value date | nvarchar | 8 | 0 | | |
57 | DFKKPOH | Payment Order: Header Data | 21 | VALUT | Value date | nvarchar | 8 | 0 | | |
58 | DFKKPPP | Payment Assignments to Promises to Pay | 11 | VALUT | Value date | nvarchar | 8 | 0 | | |
59 | DFKKRH | Returns History | 22 | VALUT | Value date | nvarchar | 8 | 0 | | |
60 | DFKKRK | Returns lot: Header data | 18 | VALUT | Value date | nvarchar | 8 | 0 | | |
61 | DFKKRP | Returns lot: Data for payment | 32 | VALUT | Value date | nvarchar | 8 | 0 | | |
62 | DFKKSUM | Posting totals from FI-CA | 37 | VALUT | Value date | nvarchar | 8 | 0 | | |
63 | DFKKSUMOLD | Totals Records Without Account Assignment Changes | 11 | VALUT | Value date | nvarchar | 8 | 0 | | |
64 | DFKKZK | Payment lot: Header data | 16 | VALUT | Value date | nvarchar | 8 | 0 | | |
65 | DFKKZP | Payment lot: Data for payment | 26 | VALUT | Value date | nvarchar | 8 | 0 | | |
66 | DFKK_TRIGGER_PAY | Outbound Interface: Trigger Table for Payment Information | 16 | VALUT | Due date for net payment | nvarchar | 8 | 0 | | |
67 | DPAYH | Payment program - data for payment | 63 | VALUT | Value date | nvarchar | 8 | 0 | | |
68 | FKKBEP | Electronic Bank Statement Line Items | 15 | VALUT | Value date of the item to be cleared | nvarchar | 8 | 0 | | |
TOPData Retention Tool |
69 | TXW_S_BSEG | Retrieve BSEG from archive | 78 | VALUT | Value date | nvarchar | 8 | 0 | | |
TOPFinancial Accounting |
70 | /OPT/VIM_1ITEM | Document Item | 93 | VALUT | Value date | nvarchar | 8 | 0 | | |
71 | ACCTIT | Compressed Data from FI/CO Document | 15 | VALUT | Value date | nvarchar | 8 | 0 | | |
72 | AVIK | Payment Advice Header | 49 | VALUT | Value date | nvarchar | 8 | 0 | | |
73 | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 32 | VALUT | Value date | nvarchar | 8 | 0 | | |
74 | BSIS | Accounting: Secondary Index for G/L Accounts | 32 | VALUT | Value date | nvarchar | 8 | 0 | | |
75 | EBSEG | Doc.Segment of Fin.Accntng External Documents | 27 | VALUT | Value date | nvarchar | 8 | 0 | | |
76 | KMZEI | FI: Account Assignment Model Item Information | 15 | VALUT | Value date | nvarchar | 8 | 0 | | |
77 | KOMU | Account Assignment Templates for G/L Account Items | 15 | VALUT | Value date | nvarchar | 8 | 0 | | |
78 | VBSEGD | Document Segment for Customer Document Parking | 29 | VALUT | Value date | nvarchar | 8 | 0 | | |
79 | VBSEGK | Document Segment for Vendor Document Parking | 34 | VALUT | Value date | nvarchar | 8 | 0 | | |
80 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 24 | VALUT | Value date | nvarchar | 8 | 0 | | |
TOPFunds Management |
81 | FMEP | FI-FM Line Items | 20 | VALUT | Value date | nvarchar | 8 | 0 | | |
TOPFunds Management-Specific Postings |
82 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 26 | VALUT | Value date | nvarchar | 8 | 0 | | |
83 | PSOSEGD | Document Segment: Recurring Request, Customer | 30 | VALUT | Value date | nvarchar | 8 | 0 | | |
84 | PSOSEGK | Recurring Request Document Segment, Vendors | 35 | VALUT | Value date | nvarchar | 8 | 0 | | |
85 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 25 | VALUT | Value date | nvarchar | 8 | 0 | | |
TOPGeneral Ledger Accounting |
86 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 15 | VALUT | Value date | nvarchar | 8 | 0 | | |
87 | FAGLBSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 32 | VALUT | Value date | nvarchar | 8 | 0 | | |
88 | FAGLBSIS | Accounting: Secondary Index for G/L Accounts | 32 | VALUT | Value date | nvarchar | 8 | 0 | | |
89 | GLFLEXA | Flexible general ledger: Actual line items | 39 | VALUT | Value date | nvarchar | 8 | 0 | | |
TOPGL transfer |
90 | BKKC02 | General Ledger: Posting Totals for FI | 13 | VALUT | Value date | nvarchar | 8 | 0 | | |
TOPInformation System |
91 | DKKOP | Balance Audit Trail | 54 | VALUT | Value date | nvarchar | 8 | 0 | | |
92 | DKOKP | Open Item Account Balance Audit Trail | 55 | VALUT | Value date | nvarchar | 8 | 0 | | |
93 | DSKOP | Balance Audit Trail | 56 | VALUT | Value date | nvarchar | 8 | 0 | | |
TOPIntercompany Data Exchange |
94 | IUEEDPPLOTATADM | Distribute Aggregated Payments: Parameter/Status Management | 6 | VALUT | Value date | nvarchar | 8 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
95 | JVPO1 | JVA: Plan Line Items | 110 | VALUT | Value date | nvarchar | 8 | 0 | | |
96 | JVSO1 | JV LI Table with Objects for JVTO1 | 46 | VALUT | Value date | nvarchar | 8 | 0 | | |
TOPLoans Management |
97 | VDZNB_PAYINFO | Payment Postprocessing: Payment Inform. for a PPP Activity | 9 | VALUT | Value date of the item to be cleared | nvarchar | 8 | 0 | | |
98 | VDZNB_PAYMENT | Payment Postprocessing: Payments for a PPP Activity | 16 | VALUT | Value date | nvarchar | 8 | 0 | | |
99 | VZFZE_VDNBZE | Central Entry Table for Release Procedure | 21 | VALUT | Value date | nvarchar | 8 | 0 | | |
TOPLocalization |
100 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 63 | VALUT | Value date | nvarchar | 8 | 0 | | |
101 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 62 | VALUT | Value date | nvarchar | 8 | 0 | | |
102 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 62 | VALUT | Value date | nvarchar | 8 | 0 | | |
103 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 62 | VALUT | Value date | nvarchar | 8 | 0 | | |
TOPPayment Transactions |
104 | FPRL_ITEM | Item Data | 149 | VALUT | Value date | nvarchar | 8 | 0 | | |
105 | PYORDH | Payment order header data | 13 | VALUT | Value date | nvarchar | 8 | 0 | | |
106 | REGUH | Settlement data from payment program | 59 | VALUT | Value date | nvarchar | 8 | 0 | | |
107 | REGUHH | REGUH version before the 'n'th change | 21 | VALUT | Value date | nvarchar | 8 | 0 | | |
108 | REGUHM | Payment Data for Cross-Payment Run Payment Medium | 17 | VALUT | Value date | nvarchar | 8 | 0 | | |
109 | REGUHO | REGUH version before the 'n'th change | 31 | VALUT | Value date | nvarchar | 8 | 0 | | |
TOPPayments |
110 | DFKKBOH | Boleto: Header data | 24 | VALUT | Value date | nvarchar | 8 | 0 | | |
TOPProfit Center Accounting |
111 | GLPCA | EC-PCA: Actual Line Items | 97 | VALUT | Value date | nvarchar | 8 | 0 | | |
TOPProject System |
112 | FILTER_PS_LOG | Filter for PS EHP4 | 8 | VALUT | Text (80 Characters) | nvarchar | 80 | 0 | | |
TOPReal Estate Management |
113 | RFVIUMSATZ | Test Data for RE Multicash Sales Data | 9 | VALUT | Value date | nvarchar | 8 | 0 | | |
114 | VIAKBSEG | Document Line Item from SCS for Interface | 28 | VALUT | Date | nvarchar | 8 | 0 | | |
TOPReceivablesPayment Management |
115 | VDARL_RLS | Direct Debits Per Contract | 8 | VALUT | Value date | nvarchar | 8 | 0 | | |
TOPRegulatory reporting for insurance companies |
116 | ISSRPREFLOW | ISSR: Basistabelle/Bewegungstabelle | 17 | VALUT | Data valuta | nvarchar | 8 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
117 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 45 | VALUT | Value date | nvarchar | 8 | 0 | | |
TOPSAP Credit Management |
118 | DFKKCRLP | Credit Management: Last Payment | 5 | VALUT | Value date | nvarchar | 8 | 0 | | |