| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | ITTS_PERSONNEL | Personnel Master Data in TTS | 7 | SHIFT | Crew ID | nvarchar | 20 | 0 | | |
| 2 | ITTS_SFT | Crew Attributes | 3 | SHIFT | Crew ID | nvarchar | 20 | 0 | | |
| 3 | ITTS_SFT_MEMB | Maintenance Crew Members | 3 | SHIFT | Crew ID | nvarchar | 20 | 0 | | |
| 4 | SFTT_ATTND_SAVE | Save crew member attendance status | 6 | SHIFT | Crew ID | nvarchar | 20 | 0 | | |
| 5 | T5A4A | General Absence Data | 4 | SHIFT | Illness Indicator (Austria) | nvarchar | 1 | 0 | | |
| 6 | T5A4C | Entitlement Quotas (Obsolete) | 3 | SHIFT | Illness Indicator (Austria) | nvarchar | 1 | 0 | | |
| 7 | T5A4U | Entitlement Quotas | 3 | SHIFT | Illness Indicator (Austria) | nvarchar | 1 | 0 | | |
| 8 | T5A4W | Entitlements in Analysis Period | 3 | SHIFT | Illness Indicator (Austria) | nvarchar | 1 | 0 | | |
| 9 | T5GPBS29 | Absence Evaluation: Scheme Switches | 7 | SHIFT | Absence Evaluation: Shift Worke'rs Entitlements | nvarchar | 1 | 0 | | |
| 10 | T7BREFD_EEVWSC | Relief shift workday information | 5 | SHIFT | Shift identification sequential | nvarchar | 1 | 0 | | |
| 11 | TTS_PERSONNEL | TTS Approvers | 8 | SHIFT | Crew ID | nvarchar | 20 | 0 | | |
| 12 | TTS_SFTSAVE | Crew Member Information | 6 | SHIFT | Crew ID | nvarchar | 20 | 0 | | |
| TOPApplication Frame |
| 13 | CRMC_UI_NKS | Table of CRM keyboard shortcuts | 7 | SHIFT | CRM personalization flag for Shift in keyboard shortcut | nvarchar | 1 | 0 | | |
| TOPAustria |
| 14 | T5A4D | Time-Dependent Entitlement Quotas | 3 | SHIFT | Illness Indicator (Austria) | nvarchar | 1 | 0 | | |
| TOPBasic Functions |
| 15 | T880B | Valuation methods | 14 | SHIFT | No. of dec.places to be shifted | nvarchar | 1 | 0 | | |
| TOPInterface to Terminal Automation System |
| 16 | OIK01 | IS-OIL/TAS: LID Document Data | 82 | SHIFT | TD driver shift | nvarchar | 1 | 0 | | |
| 17 | OIK01D | IS-OIL/TAS: deactivated LID Document Data | 83 | SHIFT | TD driver shift | nvarchar | 1 | 0 | | |
| 18 | OIKCF | TAS - Control Field Data | 18 | SHIFT | TD driver shift | nvarchar | 1 | 0 | | |
| 19 | OIKCFW | TAS - Control Field Data | 18 | SHIFT | TD driver shift | nvarchar | 1 | 0 | | |
| 20 | OIKLID | TAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes) | 49 | SHIFT | TD driver shift | nvarchar | 1 | 0 | | |
| 21 | OIKLIDR | TD - TAS Reference Table | 49 | SHIFT | TD driver shift | nvarchar | 1 | 0 | | |
| 22 | OIKLIDW | TAS LID Working version (NOTE: keep DB eq to DB OIKLID) | 49 | SHIFT | TD driver shift | nvarchar | 1 | 0 | | |
| 23 | OIKTT | TPI:Trip planning times-for customer use (Enhancem.OIKSHPSV) | 5 | SHIFT | TD driver shift | nvarchar | 1 | 0 | | |
| 24 | OIKVD | TPI: Vehicle/Driver assignment | 3 | SHIFT | TD driver shift | nvarchar | 1 | 0 | | |
| 25 | TOIKTRVS | LID TAS relevance determination Shipment | 7 | SHIFT | TD driver shift | nvarchar | 1 | 0 | | |
| TOPMarket Risk Analyzer |
| 26 | ATRFART | Risk factor type | 6 | SHIFT | Risk factor shift for approximation procedure | decimal | 15 | 7 | | |
| 27 | JBRREGW | Rules for multi-dimensional risk factor shift | 35 | SHIFT | Risk Factor Shift in Percent | decimal | 10 | 8 | | |
| TOPPurchasing |
| 28 | WGRC_TSETTINGS | Customizing Settings for Goods Receipt Capacity Check | 7 | SHIFT | Delivery Date Shift to a Different Day | nvarchar | 1 | 0 | | |
| TOPShift Planning |
| 29 | T77SP_CE | Shift Planning: Rules for Abbreviation Sequences | 6 | SHIFT | Shift abbreviation for Shift Planning | nvarchar | 4 | 0 | | |
| TOPShift Planning for Public Sector |
| 30 | HRSPPS_AVAIL | Shift Abbreviations for Availability Duties | 7 | SHIFT | Shift abbreviation for Shift Planning | nvarchar | 4 | 0 | | |
| TOPTraders and Schedulers Workbench |
| 31 | OIGSV | TD Vehicles in Transport/Shipment | 46 | SHIFT | TD driver shift | nvarchar | 1 | 0 | | |
| 32 | OIJ_EL_LAYT_EV | Laytime start and end events | 16 | SHIFT | Number of days to shift | nvarchar | 2 | 0 | | |
| 33 | TOIJ_EL_LAYT_EV | Default laytime terms for documents | 12 | SHIFT | Number of days to shift | nvarchar | 2 | 0 | | |
| TOPTransportation and Distribution |
| 34 | OIGDH | TD Driver Shift | 5 | SHIFT | TD driver shift | nvarchar | 1 | 0 | | |
| 35 | TOIGH | TD Shift Table | 2 | SHIFT | TD driver shift | nvarchar | 1 | 0 | | |
| 36 | TOIGHT | TD Shift Text Table | 3 | SHIFT | TD driver shift | nvarchar | 1 | 0 | | |
| TOPTreasury |
| 37 | JBD15 | Yield Curve Types (Values) | 5 | SHIFT | Interest rate shift | decimal | 10 | 7 | | |
| TOPWork Clearance Management |
| 38 | WCAAP | WCM: Application | 102 | SHIFT | Crew ID | nvarchar | 20 | 0 | | |
