| 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 | | |