| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_MM001 | Data staging - Material master plant view complex table | 126 | GTIN_VARIANT | Global Trade Item Number Variant | nvarchar | 2 | 0 | | |
2 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 126 | GTIN_VARIANT | Global Trade Item Number Variant | nvarchar | 2 | 0 | | |
3 | /SMERP/STG_MM003 | Data staging - Material UoM view complex table | 127 | GTIN_VARIANT | Global Trade Item Number Variant | nvarchar | 2 | 0 | | |
4 | /SMERP/STG_MM004 | Data staging - Material warehouse view complex table | 126 | GTIN_VARIANT | Global Trade Item Number Variant | nvarchar | 2 | 0 | | |
5 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 126 | GTIN_VARIANT | Global Trade Item Number Variant | nvarchar | 2 | 0 | | |
6 | ZEIMMARA | USING FOR STORING EIM MARA DATAS | 130 | GTIN_VARIANT | Global Trade Item Number Variant | nvarchar | 2 | 0 | | |
TOPAP-LIM Logistics Inventory Management Engine |
7 | /LIME/COLL_APS | Collection for Planning System | 45 | GTIN_VARIANT | Global Trade Item Number (GTIN) Variant | nvarchar | 2 | 0 | | |
8 | /LIME/COLL_BW | Collection for Business Warehouse | 45 | GTIN_VARIANT | Global Trade Item Number (GTIN) Variant | nvarchar | 2 | 0 | | |
9 | /LIME/COLL_FIN | Collection for Financial System | 45 | GTIN_VARIANT | Global Trade Item Number (GTIN) Variant | nvarchar | 2 | 0 | | |
10 | /LIME/COLL_INV | Collection for Inventory System | 45 | GTIN_VARIANT | Global Trade Item Number (GTIN) Variant | nvarchar | 2 | 0 | | |
11 | /LIME/COLL_LEG | Collection for External System | 45 | GTIN_VARIANT | Global Trade Item Number (GTIN) Variant | nvarchar | 2 | 0 | | |
12 | /LIME/COLL_MMIM | Collection for R/3 Inventory Management | 45 | GTIN_VARIANT | Global Trade Item Number (GTIN) Variant | nvarchar | 2 | 0 | | |
13 | /LIME/COLL_W2IM | Collection for WME after ERP-MMIM | 45 | GTIN_VARIANT | Global Trade Item Number (GTIN) Variant | nvarchar | 2 | 0 | | |
14 | /LIME/PN_ITEM | Table to Save Prima Nota Item Data | 30 | GTIN_VARIANT | Global Trade Item Number (GTIN) Variant | nvarchar | 2 | 0 | | |
15 | /LIME/STOCK_I003 | LIME - Stock Key GTIN, Variant | 5 | GTIN_VARIANT | Global Trade Item Number (GTIN) Variant | nvarchar | 2 | 0 | | |
16 | /LIME/STOCK_S003 | Shadow Table for LIME - GTIN, Variant | 5 | GTIN_VARIANT | Global Trade Item Number (GTIN) Variant | nvarchar | 2 | 0 | | |
TOPAuto-ID Backend Integration |
17 | AIDARCI | Obsolete: Auto-ID Infrastructure Archiving Items | 8 | GTIN_VARIANT | GTIN Variant | nvarchar | 2 | 0 | | |
18 | AIDEPCREF | Obsolite: EPC Reference | 9 | GTIN_VARIANT | GTIN Variant | nvarchar | 2 | 0 | | |
19 | AIDLOG | Auto-ID Infrastructure Log Table | 15 | GTIN_VARIANT | GTIN Variant | nvarchar | 2 | 0 | | |
TOPCross-Application Components |
20 | MMARA | General material data | 130 | GTIN_VARIANT | Global Trade Item Number Variant | nvarchar | 2 | 0 | | |
TOPMaterial Master |
21 | MARA | General Material Data | 130 | GTIN_VARIANT | Global Trade Item Number Variant | nvarchar | 2 | 0 | | |
22 | MARA_TMP | File for Incorrect Data in Direct Input | 137 | GTIN_VARIANT | Global Trade Item Number Variant | nvarchar | 2 | 0 | | |
23 | MARM | Units of Measure for Material | 25 | GTIN_VARIANT | Global Trade Item Number Variant | nvarchar | 2 | 0 | | |
24 | MARM_TMP | File for Incorrect Data in Direct Input | 28 | GTIN_VARIANT | Global Trade Item Number Variant | nvarchar | 2 | 0 | | |
25 | MLEA | Vendor-Specific EANs | 9 | GTIN_VARIANT | Global Trade Item Number Variant | nvarchar | 2 | 0 | | |
26 | MVRA | Cross-version fields for MARA | 130 | GTIN_VARIANT | Global Trade Item Number Variant | nvarchar | 2 | 0 | | |
27 | MVRM | Units of Measure for Material | 25 | GTIN_VARIANT | Global Trade Item Number Variant | nvarchar | 2 | 0 | | |