| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPConfirmations |
1 | AFRU | Order Confirmations | 133 | SCHGRUP | Grouping for Shift Definitions and Shift Sequences | nvarchar | 2 | 0 | | |
TOPIndustry-Specific Component Automotive |
2 | TSUMBP | Scheduling Profile for Summarized JIT Calls | 5 | SCHGRUP | Grouping for Shift Definitions and Shift Sequences | nvarchar | 2 | 0 | | |
3 | TSUMSCP | Calculation Profile for Summarized JIT Calls | 5 | SCHGRUP | Grouping for Shift Definitions and Shift Sequences | nvarchar | 2 | 0 | | |
TOPJust-In-Time Processing |
4 | JITCUD | Parameter Determination of Planned Delivery Time | 9 | SCHGRUP | Grouping for Shift Definitions and Shift Sequences | nvarchar | 2 | 0 | | |
TOPKANBAN |
5 | CTIMEDEF | Time definition | 4 | SCHGRUP | Grouping for Shift Definitions and Shift Sequences | nvarchar | 2 | 0 | | |
6 | TPKBP | Kanban calculation profile | 10 | SCHGRUP | Grouping for Shift Definitions and Shift Sequences | nvarchar | 2 | 0 | | |
TOPProduction Orders |
7 | COCF_SR | Shift Reports in PDF Format | 25 | SCHGRUP | Grouping for Shift Definitions and Shift Sequences | nvarchar | 2 | 0 | | |
TOPWork Center |
8 | TC37A | Shift definition | 2 | SCHGRUP | Grouping for Shift Definitions and Shift Sequences | nvarchar | 2 | 0 | | |
9 | TC37P | Break schedule | 2 | SCHGRUP | Grouping for Shift Definitions and Shift Sequences | nvarchar | 2 | 0 | | |
10 | TC37S | Texts for break plans | 3 | SCHGRUP | Grouping for Shift Definitions and Shift Sequences | nvarchar | 2 | 0 | | |
11 | TC37T | Texts for shift definitions | 3 | SCHGRUP | Grouping for Shift Definitions and Shift Sequences | nvarchar | 2 | 0 | | |
12 | TC38A | Shift sequence | 2 | SCHGRUP | Grouping for Shift Definitions and Shift Sequences | nvarchar | 2 | 0 | | |
13 | TC38T | Texts for shift groupings | 3 | SCHGRUP | Grouping for Shift Definitions and Shift Sequences | nvarchar | 2 | 0 | | |
14 | TC39A | Grouping shift definitions and shift sequences | 2 | SCHGRUP | Grouping for Shift Definitions and Shift Sequences | nvarchar | 2 | 0 | | |
15 | TC39T | Texts for grouping shift definition and shift sequence | 3 | SCHGRUP | Grouping for Shift Definitions and Shift Sequences | nvarchar | 2 | 0 | | |