| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAP-LIM Logistics Inventory Management Engine |
| 1 | /LIME/COLL_APS | Collection for Planning System | 47 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 2 | /LIME/COLL_BW | Collection for Business Warehouse | 47 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 3 | /LIME/COLL_FIN | Collection for Financial System | 47 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 4 | /LIME/COLL_INV | Collection for Inventory System | 47 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 5 | /LIME/COLL_LEG | Collection for External System | 47 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 6 | /LIME/COLL_MMIM | Collection for R/3 Inventory Management | 47 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 7 | /LIME/COLL_W2IM | Collection for WME after ERP-MMIM | 47 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 8 | /LIME/CUST_USAGE | Stock Usage | 2 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 9 | /LIME/CUST_USASP | Stock Usage - Texts | 2 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 10 | /LIME/MMIM_SOBKZ | Determination of Special Stock Indicator R/3 MM-IM | 2 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 11 | /LIME/PN_ITEM | Table to Save Prima Nota Item Data | 32 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 12 | /LIME/STOCK_I001 | LIME - Stock Key Material (R/3) | 6 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 13 | /LIME/STOCK_I002 | LIME - Stock Key Material, Batch (R/3) | 7 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 14 | /LIME/STOCK_I003 | LIME - Stock Key GTIN, Variant | 7 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 15 | /LIME/STOCK_I005 | LIME - Stock Key APO Material (F&R) | 5 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 16 | /LIME/STOCK_I006 | LIME - Stock Key Product GUID, Version (ICH) | 5 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 17 | /LIME/STOCK_I011 | LIME - Stock Key Sales Order Stock (R/3) | 6 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 18 | /LIME/STOCK_I012 | LIME - Stock Key Sales Order Stock, Batch (R/3) | 7 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 19 | /LIME/STOCK_I021 | LIME - Stock Key Project Stock (R/3) | 6 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 20 | /LIME/STOCK_I022 | LIME - Stock Key Project Stock, Batch (R/3) | 7 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 21 | /LIME/STOCK_S001 | Shadow Table for LIME - Material (R/3) | 6 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 22 | /LIME/STOCK_S002 | Shadow Table for LIME - Material, Batch (R/3) | 7 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 23 | /LIME/STOCK_S003 | Shadow Table for LIME - GTIN, Variant | 7 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 24 | /LIME/STOCK_S005 | Shadow Table for LIME - APO Material (F&R) | 5 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 25 | /LIME/STOCK_S006 | Shadow Table for LIME - Product GUID, Version (ICH) | 5 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 26 | /LIME/STOCK_S011 | Shadow Table for LIME - Sales Order Stock (R/3) | 6 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 27 | /LIME/STOCK_S012 | Shadow Table for LIME - Sales Order Stock, Batch (R/3) | 7 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 28 | /LIME/STOCK_S021 | Shadow Table for LIME - Project Stock (R/3) | 6 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 29 | /LIME/STOCK_S022 | Shadow Table for LIME - Project Stock, Batch (R/3) | 7 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| TOPGlobal Trade Services |
| 30 | /SAPSLL/S_IG01 | GTS - Make-to-Order Stock (Duty Unpaid) | 10 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 31 | /SAPSLL/S_IG02 | GTS - Stock | 8 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 32 | /SAPSLL/S_SG01 | GTS - Make-to-Order Stock (Duty Unpaid) | 10 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
| 33 | /SAPSLL/S_SG02 | GTS - Shadow Stock | 8 | STOCK_USAGE | Stock Usage | nvarchar | 1 | 0 | | |
