| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMSSCM_HU | TDMS Header for Handling Unit | 3 | GUID_HU | Unique Internal Identification of a Handling Unit | varbinary | 16 | 0 | | |
TOPAP-LIM Logistics Inventory Management Engine |
2 | /LIME/COLL_APS | Collection for Planning System | 62 | GUID_HU | GUID Handling Unit | varbinary | 16 | 0 | | |
3 | /LIME/COLL_BW | Collection for Business Warehouse | 62 | GUID_HU | GUID Handling Unit | varbinary | 16 | 0 | | |
4 | /LIME/COLL_FIN | Collection for Financial System | 62 | GUID_HU | GUID Handling Unit | varbinary | 16 | 0 | | |
5 | /LIME/COLL_INV | Collection for Inventory System | 62 | GUID_HU | GUID Handling Unit | varbinary | 16 | 0 | | |
6 | /LIME/COLL_LEG | Collection for External System | 62 | GUID_HU | GUID Handling Unit | varbinary | 16 | 0 | | |
7 | /LIME/COLL_MMIM | Collection for R/3 Inventory Management | 62 | GUID_HU | GUID Handling Unit | varbinary | 16 | 0 | | |
8 | /LIME/COLL_W2IM | Collection for WME after ERP-MMIM | 62 | GUID_HU | GUID Handling Unit | varbinary | 16 | 0 | | |
9 | /LIME/HU_I003 | LIME - HU Key SSCC | 3 | GUID_HU | Globally Unique Identifier | varbinary | 16 | 0 | | |
10 | /LIME/HU_S003 | Shadow Table for LIME - SSCC | 3 | GUID_HU | Globally Unique Identifier | varbinary | 16 | 0 | | |
11 | /LIME/PN_ITEM | Table to Save Prima Nota Item Data | 21 | GUID_HU | GUID Handling Unit | varbinary | 16 | 0 | | |