| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | BBP_PDIGP | Business Transaction Item-Purchasing Information | 116 | GTIN | Product ID GTIN | nvarchar | 40 | 0 | | |
| TOPAP-LIM Logistics Inventory Management Engine |
| 2 | /LIME/COLL_APS | Collection for Planning System | 44 | GTIN | Global Trade Item Number (GTIN) | nvarchar | 14 | 0 | | |
| 3 | /LIME/COLL_BW | Collection for Business Warehouse | 44 | GTIN | Global Trade Item Number (GTIN) | nvarchar | 14 | 0 | | |
| 4 | /LIME/COLL_FIN | Collection for Financial System | 44 | GTIN | Global Trade Item Number (GTIN) | nvarchar | 14 | 0 | | |
| 5 | /LIME/COLL_INV | Collection for Inventory System | 44 | GTIN | Global Trade Item Number (GTIN) | nvarchar | 14 | 0 | | |
| 6 | /LIME/COLL_LEG | Collection for External System | 44 | GTIN | Global Trade Item Number (GTIN) | nvarchar | 14 | 0 | | |
| 7 | /LIME/COLL_MMIM | Collection for R/3 Inventory Management | 44 | GTIN | Global Trade Item Number (GTIN) | nvarchar | 14 | 0 | | |
| 8 | /LIME/COLL_W2IM | Collection for WME after ERP-MMIM | 44 | GTIN | Global Trade Item Number (GTIN) | nvarchar | 14 | 0 | | |
| 9 | /LIME/PN_ITEM | Table to Save Prima Nota Item Data | 29 | GTIN | Global Trade Item Number (GTIN) | nvarchar | 14 | 0 | | |
| 10 | /LIME/STOCK_I003 | LIME - Stock Key GTIN, Variant | 4 | GTIN | Global Trade Item Number (GTIN) | nvarchar | 14 | 0 | | |
| 11 | /LIME/STOCK_S003 | Shadow Table for LIME - GTIN, Variant | 4 | GTIN | Global Trade Item Number (GTIN) | nvarchar | 14 | 0 | | |
| TOPAuto-ID Backend Integration |
| 12 | AIDARCI | Obsolete: Auto-ID Infrastructure Archiving Items | 7 | GTIN | Global Trade Item Number (GTIN) | nvarchar | 18 | 0 | | |
| 13 | AIDEPCREF | Obsolite: EPC Reference | 8 | GTIN | Global Trade Item Number (GTIN) | nvarchar | 18 | 0 | | |
| 14 | AIDLOG | Auto-ID Infrastructure Log Table | 14 | GTIN | Global Trade Item Number (GTIN) | nvarchar | 18 | 0 | | |
| TOPAuto-ID Infrastructure |
| 15 | /AIN/DM_ACT_OBJ | Action object | 8 | GTIN | Global Trade Item Number (GTIN) | nvarchar | 40 | 0 | | |
| 16 | /AIN/DM_DOC_OBJ | Document object information | 11 | GTIN | Global Trade Item Number (GTIN) | nvarchar | 40 | 0 | | |
| 17 | /AIN/DM_OBJECT | Object | 5 | GTIN | Global Trade Item Number (GTIN) | nvarchar | 40 | 0 | | |
| 18 | /AIN/TPRNGTINFLT | Condition Table for Tag Comm: GTIN, Filter Value -> Profile | 4 | GTIN | Global Trade Item Number (GTIN) | nvarchar | 40 | 0 | | |
| 19 | /AIN/TPRNGTNFLPR | Profile determination using GTIN and Filter value | 2 | GTIN | Global Trade Item Number (GTIN) | nvarchar | 40 | 0 | | |
| TOPCentral Part of Product Master |
| 20 | COMM_PR_GTIN | GTIN - Global Trade Item Number | 5 | GTIN | Global Trade Item Number (GTIN) | nvarchar | 40 | 0 | | |
| 21 | COMM_PR_GTINH | GTIN - Global Trade Item Number History | 6 | GTIN | Global Trade Item Number (GTIN) | nvarchar | 40 | 0 | | |
| TOPConditions |
| 22 | KOTD020 | EAN/GV Type/Sales org./Distr. Chl/Division/County/Customer | 4 | GTIN | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | |
| TOPMaterial Master |
| 23 | WGDS_CONFIRM | WGDS Confirmation | 7 | GTIN | Confirmation GTIN | nvarchar | 14 | 0 | | |
| 24 | WGDS_CONF_STATE | Datapool item confirmation state | 5 | GTIN | Global trade item number (GTIN) | nvarchar | 14 | 0 | | |
| 25 | WGDS_ITEM_SUBSCR | Table that link confirmation, subscription and pricat item | 3 | GTIN | Subscription GTIN | nvarchar | 14 | 0 | | |
| 26 | WGDS_SUBSCRIPS | WGDS Subscriptions | 11 | GTIN | Subscription GTIN | nvarchar | 14 | 0 | | |
