| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BOBF/TOOL_TR_DB | ESF: Trace | 16 | TIMESTAMP_END | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | | |
2 | /SDF/ZQLM_ACT | /SDF/ZQLM_ACT | 2 | TIMESTAMP_END | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | | |
3 | CNV_MBT_ACT_LOG | Application log for DMIS Actions | 7 | TIMESTAMP_END | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
4 | CNV_MBT_ACT_REC | Activity record - info about DMIS DEL Activities | 11 | TIMESTAMP_END | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
5 | DMC_ACT_REC | Activity record - info about the execution of DMC activities | 9 | TIMESTAMP_END | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
6 | DMC_ACT_REC_LOG | Application logs assigned to a DMC activity | 6 | TIMESTAMP_END | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
7 | DMC_RUNINFO_TIME | DMC: Time and status for data portions | 7 | TIMESTAMP_END | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | | |
8 | DMC_RUN_INFO | DMC: Record Counter and Status for a Run | 11 | TIMESTAMP_END | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | | |
9 | IDXLOG_ADM | Configuration: IDoc Adapter RFC Logging | 6 | TIMESTAMP_END | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | | |
10 | IUUC_RUNINFO_TIM | IUUC: Time and status for data portions | 7 | TIMESTAMP_END | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | | |
11 | LTR_G_JOB | Step job | 12 | TIMESTAMP_END | Timestamp End | nvarchar | 14 | 0 | | |
12 | RSMONREQDELREDU | Monitoring of Reduce/Delete Runs for critical DTAs | 7 | TIMESTAMP_END | UTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun) | decimal | 21 | 7 | | |
13 | SQLM_ACTIVITIES | SQLM_ACTIVITIES | 2 | TIMESTAMP_END | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | | |
14 | SRTCM_ACTIVITIES | Runtime Check Monitor Activities (History) | 3 | TIMESTAMP_END | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | | |
TOPAP-LIM Logistics Inventory Management Engine |
15 | /LIME/COLL_APS | Collection for Planning System | 15 | TIMESTAMP_END | UTC Time Stamp (YYYYMMDDhhmmss,mmmuuun) End of Operation | decimal | 21 | 7 | | |
16 | /LIME/COLL_BW | Collection for Business Warehouse | 15 | TIMESTAMP_END | UTC Time Stamp (YYYYMMDDhhmmss,mmmuuun) End of Operation | decimal | 21 | 7 | | |
17 | /LIME/COLL_FIN | Collection for Financial System | 15 | TIMESTAMP_END | UTC Time Stamp (YYYYMMDDhhmmss,mmmuuun) End of Operation | decimal | 21 | 7 | | |
18 | /LIME/COLL_INV | Collection for Inventory System | 15 | TIMESTAMP_END | UTC Time Stamp (YYYYMMDDhhmmss,mmmuuun) End of Operation | decimal | 21 | 7 | | |
19 | /LIME/COLL_LEG | Collection for External System | 15 | TIMESTAMP_END | UTC Time Stamp (YYYYMMDDhhmmss,mmmuuun) End of Operation | decimal | 21 | 7 | | |
20 | /LIME/COLL_MMIM | Collection for R/3 Inventory Management | 15 | TIMESTAMP_END | UTC Time Stamp (YYYYMMDDhhmmss,mmmuuun) End of Operation | decimal | 21 | 7 | | |
21 | /LIME/COLL_W2IM | Collection for WME after ERP-MMIM | 15 | TIMESTAMP_END | UTC Time Stamp (YYYYMMDDhhmmss,mmmuuun) End of Operation | decimal | 21 | 7 | | |
22 | /LIME/PN_ITEM | Table to Save Prima Nota Item Data | 68 | TIMESTAMP_END | UTC Time Stamp (YYYYMMDDhhmmss,mmmuuun) End of Operation | decimal | 21 | 7 | | |
TOPData Staging |
23 | RSODSACT | Activation of ODS M Records | 6 | TIMESTAMP_END | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
24 | RSREQARCHREORG | Request Archiving | 10 | TIMESTAMP_END | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |