| 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 | 26 | GUID_LOC | Location GUID | varbinary | 16 | 0 | | |
| 2 | /LIME/COLL_BW | Collection for Business Warehouse | 26 | GUID_LOC | Location GUID | varbinary | 16 | 0 | | |
| 3 | /LIME/COLL_FIN | Collection for Financial System | 26 | GUID_LOC | Location GUID | varbinary | 16 | 0 | | |
| 4 | /LIME/COLL_INV | Collection for Inventory System | 26 | GUID_LOC | Location GUID | varbinary | 16 | 0 | | |
| 5 | /LIME/COLL_LEG | Collection for External System | 26 | GUID_LOC | Location GUID | varbinary | 16 | 0 | | |
| 6 | /LIME/COLL_MMIM | Collection for R/3 Inventory Management | 26 | GUID_LOC | Location GUID | varbinary | 16 | 0 | | |
| 7 | /LIME/COLL_W2IM | Collection for WME after ERP-MMIM | 26 | GUID_LOC | Location GUID | varbinary | 16 | 0 | | |
| 8 | /LIME/LOC_I001 | LIME - Location Key Plant, Storage Location (R/3) | 4 | GUID_LOC | Globally Unique Identifier | varbinary | 16 | 0 | | |
| 9 | /LIME/LOC_I002 | LIME - Location Key Plant (R/3) | 3 | GUID_LOC | Globally Unique Identifier | varbinary | 16 | 0 | | |
| 10 | /LIME/LOC_I003 | LIME - Location Key GLN | 3 | GUID_LOC | Globally Unique Identifier | varbinary | 16 | 0 | | |
| 11 | /LIME/LOC_I004 | LIME - Location Key DUNS+4 | 3 | GUID_LOC | Globally Unique Identifier | varbinary | 16 | 0 | | |
| 12 | /LIME/LOC_I005 | LIME - Location Key APO Location (F&R) | 3 | GUID_LOC | Globally Unique Identifier | varbinary | 16 | 0 | | |
| 13 | /LIME/LOC_I006 | LIME - Location Key Location GUID (ICH) | 3 | GUID_LOC | Globally Unique Identifier | varbinary | 16 | 0 | | |
| 14 | /LIME/LOC_I007 | LIME - Location Key Partner (incl. R/3) | 4 | GUID_LOC | Globally Unique Identifier | varbinary | 16 | 0 | | |
| 15 | /LIME/LOC_I008 | LIME - Location Key Means of Transport, Code (incl. R/3) | 4 | GUID_LOC | Globally Unique Identifier | varbinary | 16 | 0 | | |
| 16 | /LIME/LOC_S001 | Shadow Table for LIME - Plant, Storage Location (R/3) | 4 | GUID_LOC | Globally Unique Identifier | varbinary | 16 | 0 | | |
| 17 | /LIME/LOC_S002 | Shadow Table for LIME - Plant (R/3) | 3 | GUID_LOC | Globally Unique Identifier | varbinary | 16 | 0 | | |
| 18 | /LIME/LOC_S003 | Shadow Table for LIME - GLN | 3 | GUID_LOC | Globally Unique Identifier | varbinary | 16 | 0 | | |
| 19 | /LIME/LOC_S004 | Shadow Table for LIME - DUNS+4 | 3 | GUID_LOC | Globally Unique Identifier | varbinary | 16 | 0 | | |
| 20 | /LIME/LOC_S005 | Shadow Table for LIME - APO Location (F&R) | 3 | GUID_LOC | Globally Unique Identifier | varbinary | 16 | 0 | | |
| 21 | /LIME/LOC_S006 | Shadow Table for LIME - Location GUID (ICH) | 3 | GUID_LOC | Globally Unique Identifier | varbinary | 16 | 0 | | |
| 22 | /LIME/LOC_S007 | Shadow Table for LIME - Partner (incl. R/3) | 4 | GUID_LOC | Globally Unique Identifier | varbinary | 16 | 0 | | |
| 23 | /LIME/LOC_S008 | Shadow Table for LIME - Means of Transport, Code (incl. R/3) | 4 | GUID_LOC | Globally Unique Identifier | varbinary | 16 | 0 | | |
| 24 | /LIME/PN_ITEM | Table to Save Prima Nota Item Data | 8 | GUID_LOC | Location GUID | varbinary | 16 | 0 | | |
| TOPGlobal Trade Services |
| 25 | /SAPSLL/L_IG01 | GTS - Location Table for Customs Warehouse IDs | 3 | GUID_LOC | Globally Unique Identifier | varbinary | 16 | 0 | | |
| 26 | /SAPSLL/L_SG01 | GTS: Shadow Location Table for Customs Warehouse IDs | 3 | GUID_LOC | Globally Unique Identifier | varbinary | 16 | 0 | | |
