| 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 | 29 | GLN | Global Location Number | nvarchar | 13 | 0 | | |
| 2 | /LIME/COLL_BW | Collection for Business Warehouse | 29 | GLN | Global Location Number | nvarchar | 13 | 0 | | |
| 3 | /LIME/COLL_FIN | Collection for Financial System | 29 | GLN | Global Location Number | nvarchar | 13 | 0 | | |
| 4 | /LIME/COLL_INV | Collection for Inventory System | 29 | GLN | Global Location Number | nvarchar | 13 | 0 | | |
| 5 | /LIME/COLL_LEG | Collection for External System | 29 | GLN | Global Location Number | nvarchar | 13 | 0 | | |
| 6 | /LIME/COLL_MMIM | Collection for R/3 Inventory Management | 29 | GLN | Global Location Number | nvarchar | 13 | 0 | | |
| 7 | /LIME/COLL_W2IM | Collection for WME after ERP-MMIM | 29 | GLN | Global Location Number | nvarchar | 13 | 0 | | |
| 8 | /LIME/LOC_I003 | LIME - Location Key GLN | 2 | GLN | Global Location Number | nvarchar | 13 | 0 | | |
| 9 | /LIME/LOC_S003 | Shadow Table for LIME - GLN | 2 | GLN | Global Location Number | nvarchar | 13 | 0 | | |
| 10 | /LIME/PN_ITEM | Table to Save Prima Nota Item Data | 11 | GLN | Global Location Number | nvarchar | 13 | 0 | | |
| TOPAuto-ID Infrastructure |
| 11 | /AIN/DM_LOC | Location table | 10 | GLN | GLN | nvarchar | 13 | 0 | | |
| TOPMaterial Master |
| 12 | EANC_GLN_MAPP | GLN - R/3 Mapping Table | 4 | GLN | International Location Number(GLN) | nvarchar | 18 | 0 | | |
