| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMS_05_EIKP | Collected Header Document Numbers for TDMS_Time-EIKP | 3 | EXNUM | EXNUM for EIKP | nvarchar | 10 | 0 | | |
TOPAdvertising Management |
2 | JHTFK | IS-M/AM: Settlement Documents (Billing, Commission) - Header | 67 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
TOPBasic Functions |
3 | EIEI | Foreign Trade: Export/Import Communication Data | 2 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
4 | EIKP | Foreign Trade: Export/Import Header Data | 2 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
5 | EIPO | Foreign Trade: Export/Import: Item Data | 2 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
6 | EIUV | Foreign Trade: Incompletion Log for Foreign Trade Data | 3 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
7 | EIZO | FT: Exp/Imp ident. of goods, pres. of goods for cust.declar. | 2 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
TOPBilling |
8 | VBRK | Billing Document: Header Data | 56 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
TOPContract Accounts Receivable and Payable |
9 | DFKKTAXEX | Table of FI-CA Tax Exemptions | 7 | EXNUM | Number of Exemption Licence | nvarchar | 15 | 0 | | |
10 | DFKKTAX_EXEMPT | Table of FI-CA Tax Exemptions | 7 | EXNUM | Number of exemption certificate | nvarchar | 15 | 0 | | |
TOPData Retention Tool |
11 | TXW_S_EKKO | Retrieve EKKO from archive | 20 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
12 | TXW_S_LIKP | Retrieve LIKP from archive | 16 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
13 | TXW_S_MKPF | Retrieve MKPF from archive | 23 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
14 | TXW_S_VBRK | Retrieve VBRK from archive | 33 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
TOPInventory Management |
15 | MKPF | Header: Material Document | 24 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
TOPLocalization |
16 | J_1IEXCDTL | Excise invoice line item details | 7 | EXNUM | Official Excise Document Number | nvarchar | 10 | 0 | | |
17 | J_1IEXCHDR | Excise invoice header detail | 10 | EXNUM | Official Excise Document Number | nvarchar | 10 | 0 | | |
18 | J_1IGRXREF | Goods Receipt to Excise Invoice Coss Reference | 5 | EXNUM | Official Excise Document Number | nvarchar | 10 | 0 | | |
19 | J_1IGRXSUB | GR reference to subcontracting challans | 5 | EXNUM | Official Excise Document Number | nvarchar | 10 | 0 | | |
20 | J_1IKONV | Excise recalculated conditions | 6 | EXNUM | Official Excise Document Number | nvarchar | 10 | 0 | | |
21 | J_1IQRDEP | Quarterly Returns Depot structure | 7 | EXNUM | Official Excise Document Number | nvarchar | 10 | 0 | | |
22 | J_1IRG23D | RG23D register for the depot | 15 | EXNUM | Official Excise Document Number | nvarchar | 10 | 0 | | |
23 | J_1I_INBDELV | INBOUND DELIVERY DETAILS FROM sus | 4 | EXNUM | Official Excise Document Number | nvarchar | 10 | 0 | | |
TOPLogistics - General |
24 | WBHK | Trading Contract: Header Data | 32 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
TOPPurchasing |
25 | EKKO | Purchasing Document Header | 55 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
TOPShipping |
26 | LIKP | SD Document: Delivery Header Data | 61 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |