| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAP-LIM Logistics Inventory Management Engine |
1 | /LIME/ARCH_IDX | Index Table to Select LIME Archiving Objects | 2 | GUID_PN | LIME GUID for Prima Nota | varbinary | 16 | 0 | | |
2 | /LIME/COLL_APS | Collection for Planning System | 5 | GUID_PN | LIME GUID for Prima Nota | varbinary | 16 | 0 | | |
3 | /LIME/COLL_BW | Collection for Business Warehouse | 5 | GUID_PN | LIME GUID for Prima Nota | varbinary | 16 | 0 | | |
4 | /LIME/COLL_FIN | Collection for Financial System | 5 | GUID_PN | LIME GUID for Prima Nota | varbinary | 16 | 0 | | |
5 | /LIME/COLL_INV | Collection for Inventory System | 5 | GUID_PN | LIME GUID for Prima Nota | varbinary | 16 | 0 | | |
6 | /LIME/COLL_LEG | Collection for External System | 5 | GUID_PN | LIME GUID for Prima Nota | varbinary | 16 | 0 | | |
7 | /LIME/COLL_MMIM | Collection for R/3 Inventory Management | 5 | GUID_PN | LIME GUID for Prima Nota | varbinary | 16 | 0 | | |
8 | /LIME/COLL_PN | Assignment Table: Collection <-> LIME Document | 3 | GUID_PN | LIME GUID for Prima Nota | varbinary | 16 | 0 | | |
9 | /LIME/COLL_W2IM | Collection for WME after ERP-MMIM | 5 | GUID_PN | LIME GUID for Prima Nota | varbinary | 16 | 0 | | |
10 | /LIME/LOG_HEAD | Log Table for Header Data of a Prima Nota Document | 2 | GUID_PN | LIME GUID for Prima Nota | varbinary | 16 | 0 | | |
11 | /LIME/LOG_QUAN | Log Table for the Stock Changes Made to a Document | 2 | GUID_PN | LIME GUID for Prima Nota | varbinary | 16 | 0 | | |
12 | /LIME/LOG_SERIAL | Log Table of Serial Numbers | 2 | GUID_PN | LIME GUID for Prima Nota | varbinary | 16 | 0 | | |
13 | /LIME/LOG_TREE | Log Changes in Table /LIME/TREE | 2 | GUID_PN | LIME GUID for Prima Nota | varbinary | 16 | 0 | | |
14 | /LIME/NLOG_QUAN | Logging of Changes in Table /LIME/NQUAN | 2 | GUID_PN | LIME GUID for Prima Nota | varbinary | 16 | 0 | | |
15 | /LIME/PN_ITEM | Table to Save Prima Nota Item Data | 2 | GUID_PN | LIME GUID for Prima Nota | varbinary | 16 | 0 | | |
16 | /LIME/PN_ITEM_TB | /LIME/DOC Collective Table of Param, Quant, Serial No, ACC | 2 | GUID_PN | LIME GUID for Prima Nota | varbinary | 16 | 0 | | |
17 | /LIME/PN_SERIAL | /LIME/DOC - PN Document for Serial Numbers | 2 | GUID_PN | Globally Unique Identifier | varbinary | 16 | 0 | | |