| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPProduction Orders |
1 | COMPCMP | OCM: Comparison result, individual records for components | 2 | COMPNUM | Unambiguous identification number of a comparison result | nvarchar | 10 | 0 | | |
2 | COMPCONF | OCM: Comparison result, state of change numbers | 2 | COMPNUM | Unambiguous identification number of a comparison result | nvarchar | 10 | 0 | | |
3 | COMPF | OCM: Names of compared fields | 2 | COMPNUM | Unambiguous identification number of a comparison result | nvarchar | 10 | 0 | | |
4 | COMPH | OCM: Comparison result (header entry) | 2 | COMPNUM | Unambiguous identification number of a comparison result | nvarchar | 10 | 0 | | |
5 | COMPHDR | OCM: Comparison results, indiv. records for order headers | 2 | COMPNUM | Unambiguous identification number of a comparison result | nvarchar | 10 | 0 | | |
6 | COMPITM | OCM: Comparison result, individual records for items | 2 | COMPNUM | Unambiguous identification number of a comparison result | nvarchar | 10 | 0 | | |
7 | COMPMSG | Messages from checks for leveling steps | 2 | COMPNUM | Unambiguous identification number of a comparison result | nvarchar | 10 | 0 | | |
8 | COMPOPR | OCM: Comparison result, individual records for operations | 2 | COMPNUM | Unambiguous identification number of a comparison result | nvarchar | 10 | 0 | | |
9 | COMPPRT | OCM: Comparison result, individual record for PRTs | 2 | COMPNUM | Unambiguous identification number of a comparison result | nvarchar | 10 | 0 | | |
10 | COMPSQU | OCM: Comparison results; Single records for sequences | 2 | COMPNUM | Unambiguous identification number of a comparison result | nvarchar | 10 | 0 | | |
11 | FUNOCM | Function marked for Order Change Management | 19 | COMPNUM | Unambiguous identification number of a comparison result | nvarchar | 10 | 0 | | |