| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ZEIM_VBAK | Sales Document: Header Data | 8 | AUDAT | Document Date (Date Received/Sent) | nvarchar | 8 | 0 | | |
TOPAccounting Interface |
2 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 305 | AUDAT | Payment cards: Authorization date | nvarchar | 8 | 0 | | |
3 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 305 | AUDAT | Payment cards: Authorization date | nvarchar | 8 | 0 | | |
TOPAdvertising Management |
4 | JHAK | IS-M/AM: Order-Publishing-Media (Header Data) | 6 | AUDAT | Document Date (Date Received/Sent) | nvarchar | 8 | 0 | | |
5 | JHWWWTEMP_ORDER | IS-M/AM: Temporary Table for Order Data from the Internet | 73 | AUDAT | Payment cards: Authorization date | nvarchar | 8 | 0 | | |
TOPBank Accounting |
6 | BSEGC | Document: Data on Payment Card Payments | 18 | AUDAT | Payment cards: Authorization date | nvarchar | 8 | 0 | | |
TOPBasis Components |
7 | ZDS400_VBAK | Tabelle für Beispielprogramm des ZDS400 | 8 | AUDAT | Belegdatum (Ein- bzw. Ausgangsdatum) | nvarchar | 8 | 0 | | |
8 | ZSALES_ORD_HEAD | Sales Order Header (IDES DEMO) | 6 | AUDAT | Document Date (Date Received/Sent) | nvarchar | 8 | 0 | | |
TOPContract Accounts Receivable and Payable |
9 | DFKKCMP | Manually Issued Checks Lot: Item Data | 31 | AUDAT | Issue Date of Check | nvarchar | 8 | 0 | | |
10 | DFKKEXC_PAYINFO | Information for Payment Medium | 17 | AUDAT | Payment cards: Authorization date | nvarchar | 8 | 0 | | |
11 | DFKKIP_GRP | Payment Specification: Header Data | 50 | AUDAT | Payment cards: Authorization date | nvarchar | 8 | 0 | | |
12 | DFKKIP_GRPH | Payment Specification: Payment Data (History) | 52 | AUDAT | Payment cards: Authorization date | nvarchar | 8 | 0 | | |
13 | DFKKOPC | Card Data Supplement for Business Partner Item | 12 | AUDAT | Payment cards: Authorization date | nvarchar | 8 | 0 | | |
14 | DFKKOPKC | Card Data Appendix for FICA Document | 12 | AUDAT | Payment cards: Authorization date | nvarchar | 8 | 0 | | |
15 | DFKKZP | Payment lot: Data for payment | 67 | AUDAT | Payment cards: Authorization date | nvarchar | 8 | 0 | | |
16 | DFKK_PCARD | Card Data Supplement | 11 | AUDAT | Payment cards: Authorization date | nvarchar | 8 | 0 | | |
TOPCross-Application Components |
17 | VVBAK | Sales Document: Header Data | 8 | AUDAT | Document Date (Date Received/Sent) | nvarchar | 8 | 0 | | |
TOPData Retention Tool |
18 | TXW_S_VBAK | Retrieve VBAK from archive | 5 | AUDAT | Document Date (Date Received/Sent) | nvarchar | 8 | 0 | | |
TOPEngineering Change Management |
19 | AENR | Change Master | 29 | AUDAT | End Date for Transitional Period (Prescribed by Law) | nvarchar | 8 | 0 | | |
TOPLogistics - General |
20 | WBHK | Trading Contract: Header Data | 31 | AUDAT | Document Date (Date Received/Sent) | nvarchar | 8 | 0 | | |
TOPMarketing Retail Network |
21 | OIFPBL | Index to point at Business Location | 7 | AUDAT | Document Date (Date Received/Sent) | nvarchar | 8 | 0 | | |
TOPMedia Sales and Distribution |
22 | /NAM/PAY_CC | Workload for Credit Card Payment | 23 | AUDAT | Payment cards: Previous date of authorization | nvarchar | 8 | 0 | | |
TOPPayment Cards |
23 | FPLTC | Payment cards: Transaction data - SD | 16 | AUDAT | Payment cards: Authorization date | nvarchar | 8 | 0 | | |
TOPPeriodical Sales and Distribution |
24 | JFRKCC | IS-M/SD: Billing - Payment Card Data | 16 | AUDAT | Payment cards: Authorization date | nvarchar | 8 | 0 | | |
25 | JKAPCC | Sales Order: Payment Card Data | 17 | AUDAT | Payment cards: Authorization date | nvarchar | 8 | 0 | | |
26 | JKWWWTEMP_ORDER | IS-M/SD: WWW Temporary Table for Order Data from Internet | 99 | AUDAT | Payment cards: Authorization date | nvarchar | 8 | 0 | | |
27 | JKWWWTEMP_PAY | IS-M: Temporary Internet Table: Payment Data Change | 25 | AUDAT | Payment cards: Authorization date | nvarchar | 8 | 0 | | |
TOPProduction and Revenue Accounting |
28 | OIUCM_CONTRACT | PRA Contracts | 8 | AUDAT | Document Date (Date Received/Sent) | nvarchar | 8 | 0 | | |
TOPProfitability Analysis |
29 | CEERROR | CO-PA: Incorrect records from SD | 32 | AUDAT | Document Date (Date Received/Sent) | nvarchar | 8 | 0 | | |
TOPRecycling Administration Core Functions |
30 | J_7LV1K | REA Document: Header Data | 3 | AUDAT | Document Date (Date Received/Sent) | nvarchar | 8 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
31 | /BEV1/RBVBAK | Sales Document: Header Data | 8 | AUDAT | Document Date (Date Received/Sent) | nvarchar | 8 | 0 | | |
TOPSales |
32 | VAKPA | Sales Index: Orders by Partner Function | 6 | AUDAT | Document Date (Date Received/Sent) | nvarchar | 8 | 0 | | |
33 | VAPMA | Sales Index: Order Items by Material | 5 | AUDAT | Document Date (Date Received/Sent) | nvarchar | 8 | 0 | | |
34 | VBAK | Sales Document: Header Data | 8 | AUDAT | Document Date (Date Received/Sent) | nvarchar | 8 | 0 | | |
TOPShipping |
35 | LIPSRF | LIPS Reference Data | 6 | AUDAT | Document Date (Date Received/Sent) | nvarchar | 8 | 0 | | |
TOPSimulation |
36 | VSVBAK_CN | Version: Sales document: Header data | 9 | AUDAT | Document Date (Date Received/Sent) | nvarchar | 8 | 0 | | |