| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAP-LIM Logistics Inventory Management Engine |
1 | /LIME/LOG_QUAN | Log Table for the Stock Changes Made to a Document | 14 | IDX_PARENT | Current Nummer of Key Table | nvarchar | 3 | 0 | | |
2 | /LIME/LOG_SERIAL | Log Table of Serial Numbers | 14 | IDX_PARENT | Current Nummer of Key Table | nvarchar | 3 | 0 | | |
3 | /LIME/LOG_TREE | Log Changes in Table /LIME/TREE | 14 | IDX_PARENT | Current Nummer of Key Table | nvarchar | 3 | 0 | | |
4 | /LIME/NLOG_QUAN | Logging of Changes in Table /LIME/NQUAN | 13 | IDX_PARENT | Current Nummer of Key Table | nvarchar | 3 | 0 | | |
5 | /LIME/NLOG_SER | LIME - Serial Numbers | 11 | IDX_PARENT | Current Nummer of Key Table | nvarchar | 3 | 0 | | |
6 | /LIME/NLOG_TREE | Logging of Changes in Table /LIME/NTREE | 11 | IDX_PARENT | Current Nummer of Key Table | nvarchar | 3 | 0 | | |
7 | /LIME/NQUAN | LIME - Stock Quantities | 11 | IDX_PARENT | Current Nummer of Key Table | nvarchar | 3 | 0 | | |
8 | /LIME/NSERIAL | LIME - Serial Numbers | 9 | IDX_PARENT | Current Nummer of Key Table | nvarchar | 3 | 0 | | |
9 | /LIME/NTREE | LIME - Tree Structure | 8 | IDX_PARENT | Current Nummer of Key Table | nvarchar | 3 | 0 | | |
10 | /LIME/QUAN | LIME - Stock Quantities | 10 | IDX_PARENT | Current Nummer of Key Table | nvarchar | 3 | 0 | | |
11 | /LIME/SERIAL | LIME - Serial Numbers | 10 | IDX_PARENT | Current Nummer of Key Table | nvarchar | 3 | 0 | | |
12 | /LIME/TREE | LIME - Tree Structure | 9 | IDX_PARENT | Current Nummer of Key Table | nvarchar | 3 | 0 | | |