| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAP-LIM Logistics Inventory Management Engine |
1 | /LIME/COLL_APS | Collection for Planning System | 4 | DISPATCH_TIME | Dispatcher Record Processed (Time Stamp) | decimal | 21 | 7 | | |
2 | /LIME/COLL_BW | Collection for Business Warehouse | 4 | DISPATCH_TIME | Dispatcher Record Processed (Time Stamp) | decimal | 21 | 7 | | |
3 | /LIME/COLL_FIN | Collection for Financial System | 4 | DISPATCH_TIME | Dispatcher Record Processed (Time Stamp) | decimal | 21 | 7 | | |
4 | /LIME/COLL_INV | Collection for Inventory System | 4 | DISPATCH_TIME | Dispatcher Record Processed (Time Stamp) | decimal | 21 | 7 | | |
5 | /LIME/COLL_LEG | Collection for External System | 4 | DISPATCH_TIME | Dispatcher Record Processed (Time Stamp) | decimal | 21 | 7 | | |
6 | /LIME/COLL_MMIM | Collection for R/3 Inventory Management | 4 | DISPATCH_TIME | Dispatcher Record Processed (Time Stamp) | decimal | 21 | 7 | | |
7 | /LIME/COLL_PN | Assignment Table: Collection <-> LIME Document | 10 | DISPATCH_TIME | Dispatcher Record Processed (Time Stamp) | decimal | 21 | 7 | | |
8 | /LIME/COLL_W2IM | Collection for WME after ERP-MMIM | 4 | DISPATCH_TIME | Dispatcher Record Processed (Time Stamp) | decimal | 21 | 7 | | |
TOPExcise Duty |
9 | /BEV2/CS_HD | EMCS Process: Header Data | 17 | DISPATCH_TIME | Time of Dispatch | nvarchar | 6 | 0 | | |
10 | /BEV2/CS_HD_H | EMCS Process: Header Data - History | 18 | DISPATCH_TIME | Time of Dispatch | nvarchar | 6 | 0 | | |
TOPPrint Workbench |
11 | EFG_FLIGHT_DATA | Data by Data Dispatch | 9 | DISPATCH_TIME | System Time | nvarchar | 6 | 0 | | |