| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBasis-Related Help Functions, Appl. Log, Formula Intepreter |
1 | COAT_E_DATA | COAT: Extract Data | 2 | EXTRACT_ID | Extract ID | nvarchar | 6 | 0 | | |
2 | COAT_E_INFO | COAT: Information About Extracts | 2 | EXTRACT_ID | Extract ID | nvarchar | 6 | 0 | | |
TOPContract Accounts Receivable and Payable |
3 | DFKKCUST_SHORT | Data Extract: Customizing | 7 | EXTRACT_ID | Extract Identification | nvarchar | 20 | 0 | | |
4 | DFKKGP_SHORT | Data Extract: BP Data | 20 | EXTRACT_ID | Extract Identification | nvarchar | 20 | 0 | | |
5 | DFKKKO_SHORT | Header Data for Contract Accounting Document - Extracts | 14 | EXTRACT_ID | Extract Identification | nvarchar | 20 | 0 | | |
6 | DFKK_CUST_EXTR | FI-CA Partner - Extracts | 2 | EXTRACT_ID | Extract Identification | nvarchar | 20 | 0 | | |
7 | DFKK_DOC_EXTR | FI-CA Documents - Extracts | 2 | EXTRACT_ID | Extract Identification | nvarchar | 20 | 0 | | |
8 | DFKK_GP_EXTR | FI-CA Partner - Extracts | 2 | EXTRACT_ID | Extract Identification | nvarchar | 20 | 0 | | |
TOPContract Billing |
9 | ERCH_DOC_EXTR | Billing Document Extract -Selection Requirements - | 2 | EXTRACT_ID | Extract Identification | nvarchar | 20 | 0 | | |
10 | ETAXERCH | Index Table for Tax Storage/Billing Documents | 3 | EXTRACT_ID | Extract Identification | nvarchar | 20 | 0 | | |
11 | ETAXERCHKO | Extract Table for Tax Storage/Billing Documents | 2 | EXTRACT_ID | Extract Identification | nvarchar | 20 | 0 | | |
TOPData Retention Tool |
12 | TXW_DIR | Data file log (replaced by txw_dir2, use of guids) | 2 | EXTRACT_ID | Data extract ID (to be replaced in release 99 by txw_uuid) | nvarchar | 4 | 0 | | |
13 | TXW_DIR2 | Data file log | 6 | EXTRACT_ID | Data extract ID (to be replaced in release 99 by txw_uuid) | nvarchar | 4 | 0 | | |
14 | TXW_DIRAL | Data file log - ArchiveLink (obsolete after rel 99) | 2 | EXTRACT_ID | Data extract ID (to be replaced in release 99 by txw_uuid) | nvarchar | 4 | 0 | | |
15 | TXW_DIRAL2 | Data file log - ArchiveLink | 4 | EXTRACT_ID | Data extract ID (to be replaced in release 99 by txw_uuid) | nvarchar | 4 | 0 | | |
16 | TXW_DIRSEG | Data file segment directory (replaced by txw_dirsg2: uuids) | 2 | EXTRACT_ID | Data extract ID (to be replaced in release 99 by txw_uuid) | nvarchar | 4 | 0 | | |
17 | TXW_VWLOG | View query log (replaced by txw_vwlog2: uuids) | 6 | EXTRACT_ID | Data extract ID (to be replaced in release 99 by txw_uuid) | nvarchar | 4 | 0 | | |
TOPIntercompany Data Exchange |
18 | ETAXTINVDOC | Index Table for Tax Storage for Incoming Bill, Documents | 2 | EXTRACT_ID | Extract Identification | nvarchar | 20 | 0 | | |
19 | ETAXTINVKO | Extract Table for Tax Storage for Incoming Bill, Extr. Info | 2 | EXTRACT_ID | Extract Identification | nvarchar | 20 | 0 | | |
20 | TINV_EXTR_HDR | Extract of Bill Receipt Document: Admin. Data (Eval. System) | 2 | EXTRACT_ID | Extract Identification | nvarchar | 20 | 0 | | |
TOPInvoicing |
21 | ERD_DOC_EXTR | Print Document Extract - Selection Conditions - | 2 | EXTRACT_ID | Extract Identification | nvarchar | 20 | 0 | | |
22 | ETAXERDK | Index Table for Tax Storage/Print Documents | 3 | EXTRACT_ID | Extract Identification | nvarchar | 20 | 0 | | |
23 | ETAXERDKKO | Extract Table for Tax Storage/Print Documents | 2 | EXTRACT_ID | Extract Identification | nvarchar | 20 | 0 | | |
TOPProfit Center Accounting |
24 | PCA_SCMO | Index from Schedule Manager Run to Corresponding Extracts | 3 | EXTRACT_ID | Extract ID of a Company Code | nvarchar | 12 | 0 | | |