| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| AP-LIM Logistics Inventory Management Engine | ||||||||||
| 1 | /LIME/LOG_QUAN | Log Table for the Stock Changes Made to a Document | 8 | GUID_PARENT | Parent GUID | varbinary | 16 | 0 | ||
| 2 | /LIME/LOG_SERIAL | Log Table of Serial Numbers | 10 | GUID_PARENT | Parent GUID | varbinary | 16 | 0 | ||
| 3 | /LIME/LOG_TREE | Log Changes in Table /LIME/TREE | 10 | GUID_PARENT | Parent GUID | varbinary | 16 | 0 | ||
| 4 | /LIME/LSQ | LIME - Stock Attributes | 3 | GUID_PARENT | Parent GUID | varbinary | 16 | 0 | ||
| 5 | /LIME/NLOG_QUAN | Logging of Changes in Table /LIME/NQUAN | 5 | GUID_PARENT | Parent GUID | varbinary | 16 | 0 | ||
| 6 | /LIME/NLOG_SER | LIME - Serial Numbers | 5 | GUID_PARENT | Parent GUID | varbinary | 16 | 0 | ||
| 7 | /LIME/NLOG_TREE | Logging of Changes in Table /LIME/NTREE | 9 | GUID_PARENT | Parent GUID | varbinary | 16 | 0 | ||
| 8 | /LIME/NQUAN | LIME - Stock Quantities | 3 | GUID_PARENT | Parent GUID | varbinary | 16 | 0 | ||
| 9 | /LIME/NSERIAL | LIME - Serial Numbers | 3 | GUID_PARENT | Parent GUID | varbinary | 16 | 0 | ||
| 10 | /LIME/NTREE | LIME - Tree Structure | 6 | GUID_PARENT | Parent GUID | varbinary | 16 | 0 | ||
| 11 | /LIME/QUAN | LIME - Stock Quantities | 3 | GUID_PARENT | Parent GUID | varbinary | 16 | 0 | ||
| 12 | /LIME/SERIAL | LIME - Serial Numbers | 3 | GUID_PARENT | Parent GUID | varbinary | 16 | 0 | ||
| 13 | /LIME/TREE | LIME - Tree Structure | 5 | GUID_PARENT | Parent GUID | varbinary | 16 | 0 | ||
| Sales | ||||||||||
| 14 | LOGIC_OBJREL | Link Table for LOGIC Objects | 2 | GUID_PARENT | GUID in 'RAW' format | varbinary | 16 | 0 | ||