| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T7IEB | Mapping table for Enterprise and ERn numbers | 2 | ENTNR | Enterprise number | nvarchar | 10 | 0 | | |
2 | T7NOEDG_BF_GRANT | EDAG - Granted Bunnfradrag amount per year | 2 | ENTNR | EDAG - Enterprise Nr. | nvarchar | 11 | 0 | | |
3 | T7NOEDG_PRD02 | EDAG - IRED storage (actual version) | 4 | ENTNR | EDAG - Enterprise Nr. | nvarchar | 11 | 0 | | |
4 | T7NOEDG_PRD03 | EDAG - IRED storage (versions) | 4 | ENTNR | EDAG - Enterprise Nr. | nvarchar | 11 | 0 | | |
5 | T7NOEDG_PRD04 | EDAG - SMBS links to IRED storage | 5 | ENTNR | EDAG - Enterprise Nr. | nvarchar | 11 | 0 | | |
6 | T7NOEDG_PRD05 | EDAG - ACF links | 3 | ENTNR | EDAG - Enterprise Nr. | nvarchar | 11 | 0 | | |
7 | T7NOEDG_PRD06 | EDAG - Receptions | 3 | ENTNR | EDAG - Enterprise Nr. | nvarchar | 11 | 0 | | |
8 | T7NOEDG_PRD07 | EDAG - Last submission info | 3 | ENTNR | EDAG - Enterprise Nr. | nvarchar | 11 | 0 | | |
9 | T7NOEDG_TEST01 | EDAG[TEST] - ACF test table 1 | 4 | ENTNR | EDAG - Enterprise Nr. | nvarchar | 11 | 0 | | |
10 | T7NOEDG_TEST02 | EDAG[TEST] - IRED storage (actual version) | 4 | ENTNR | EDAG - Enterprise Nr. | nvarchar | 11 | 0 | | |
11 | T7NOEDG_TEST03 | EDAG[TEST] - IRED storage (versions) | 4 | ENTNR | EDAG - Enterprise Nr. | nvarchar | 11 | 0 | | |
12 | T7NOEDG_TEST04 | EDAG[TEST] - SMBS links to IRED storage | 5 | ENTNR | EDAG - Enterprise Nr. | nvarchar | 11 | 0 | | |
13 | T7NOEDG_TEST05 | EDAG[TEST] - ACF links | 3 | ENTNR | EDAG - Enterprise Nr. | nvarchar | 11 | 0 | | |
14 | T7NOEDG_TEST06 | EDAG[TEST] - Receptions | 3 | ENTNR | EDAG - Enterprise Nr. | nvarchar | 11 | 0 | | |
15 | T7NOEDG_TEST07 | EDAG[TEST] - Last submission info | 3 | ENTNR | EDAG - Enterprise Nr. | nvarchar | 11 | 0 | | |
TOPRecycling Administration Core Functions |
16 | J_7LBDCMSG | REA Conditions: Error Messages BDC Condition Adjustment | 12 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
17 | J_7LE01 | REA Partner Master Record: General Data (Country-Dependent) | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
18 | J_7LE02 | REA Partner Master Record: Company Code | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
19 | J_7LE04 | REA Partner Master Record: Volume/Area Classes | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
20 | J_7LE04T | REA Partner Master Record: Volume/Area Classes Short Texts | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
21 | J_7LE05 | REA Partner Master Record: Packaging Types | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
22 | J_7LE06 | REA Partner Master Record: Additional Information Key | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
23 | J_7LE06T | REA Partner Master Record: Additional Info., Short Text | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
24 | J_7LE07 | REA Partner Master Record: Content Identification Key | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
25 | J_7LE07T | REA Partner Master Record: Content Ident.Key, Short Text | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
26 | J_7LE08 | REA Partner Master Record: Month-Quarter Assignment | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
27 | J_7LE09 | REA Partner Master: Document Types | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
28 | J_7LE09T | REA Partner Master: Document Types Short Text | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
29 | J_7LE10 | REA Partner Master: Document Types Periodicity | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
30 | J_7LE11 | REA Partner Master: Selection Groups for Consecutive Docs | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
31 | J_7LE11T | REA Partner Master: Selection Grps for Consec.Docs Short Txt | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
32 | J_7LE12 | REA Partner Master: Consecutive Doc.-to-Selection Grp Asgmt | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
33 | J_7LE13 | REA Partner Master: Trade Levels | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
34 | J_7LE13T | REA Partner Master: Trade Levels - Short Text | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
35 | J_7LE14 | REA Partner Master: Trade Level Proportion (price list vers) | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
36 | J_7LE15 | REA Partner Master: Formulas for Fee Calculation | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
37 | J_7LE15T | REA Partner Master Record: Formulas - Short Texts | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
38 | J_7LE16 | REA Partner Master Record: Packaging Category - Fraction | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
39 | J_7LE16T | REA Partner Master Rec.: Packag. Ctgry Fraction, Short Text | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
40 | J_7LE17 | REA Partner Master: Price Formulas | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
41 | J_7LE17T | REA Partner Master: Formulas Short Text | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
42 | J_7LM05 | REA Article Master: Recycling Partner Assignment | 7 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
43 | J_7LM09 | REA Article Master: R.Partner-Depend.Data Assign.Packaging | 8 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
44 | J_7LM10 | REA Article Master: Filters for Regional Processing | 7 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
45 | J_7LM11 | REA Article Master: Declaration Key | 6 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
46 | J_7LMS01 | REA Declaration System Lock Table | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
47 | J_7LP01 | REA Price List: Versions | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
48 | J_7LP02 | REA Price List: Items | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
49 | J_7LP03 | REA Price List: Conditions | 2 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
50 | J_7LS02 | REA Fractions: Partner Fractions | 3 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
51 | J_7LS02T | REA Partner Fractions: Short Text | 3 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
52 | J_7LV03 | REA Packaging Master Data: Recycling Partner Assignment | 4 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
53 | J_7LV07 | REA Packaging Groups: Recycling Partner-Dep. Packaging Data | 5 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
54 | J_7LV08 | REA Packag. Mast. Data: Re.Partner-Dep. Data Asgmt Fraction | 5 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
55 | J_7LV1K | REA Document: Header Data | 42 | ENTNR | Recycling Partner | nvarchar | 10 | 0 | | |
TOPTime Data Recording and Administration |
56 | TMW_TDTYPE | Time Data ID | 4 | ENTNR | Entry Number | nvarchar | 5 | 0 | | |
57 | TMW_TD_SUBLA | Subset | 5 | ENTNR | Entry Number | nvarchar | 5 | 0 | | |
TOPUse Subcomponents |
58 | SADRX5 | X.500 Directory Entries | 10 | ENTNR | Addresses: Sequence number | nvarchar | 3 | 0 | | |