| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | YIT_INFOBASE_XD | IDES Infobase: Application Data Assignments | 8 | KEY_INT1 | Infobase Key Field for Data Assignment | nvarchar | 8 | 0 | | |
2 | YIT_INITIAL | Infobase: Initialtabelle für Views | 5 | KEY_INT1 | Infobase: Platzhalter Key | nvarchar | 1 | 0 | | |
3 | YIT_O1NET | IDA: Original Table NET | 3 | KEY_INT1 | Order category | nvarchar | 2 | 0 | | |
4 | YIT_O1PRO | IDA: Original Table PRO | 3 | KEY_INT1 | Project definition (internal) | nvarchar | 8 | 0 | | |
5 | YIT_O1STN | IDA: Original Table STN | 3 | KEY_INT1 | Task List Type | nvarchar | 1 | 0 | | |
6 | YIT_O1STP | IDA: Original Table STP | 3 | KEY_INT1 | Current number for standard project | nvarchar | 8 | 0 | | |
7 | YIT_O1__1 | IDA: Original Table __1 Org. Units | 4 | KEY_INT1 | CATT: Application | nvarchar | 2 | 0 | | |
8 | YIT_O2NET | IDA: Original Table NET | 3 | KEY_INT1 | Order category | nvarchar | 2 | 0 | | |
9 | YIT_O2PRO | IDA: Original Table PRO | 3 | KEY_INT1 | Project definition (internal) | nvarchar | 8 | 0 | | |
10 | YIT_O2STN | IDA: Original Table STN | 3 | KEY_INT1 | Task List Type | nvarchar | 1 | 0 | | |
11 | YIT_O2STP | IDA: Original Table STP | 3 | KEY_INT1 | Current number for standard project | nvarchar | 8 | 0 | | |
12 | YIT_O2__1 | IDA: Original Table __1 Org. Units | 4 | KEY_INT1 | CATT: Application | nvarchar | 2 | 0 | | |
13 | YIT_O3NET | IDA: Original Table NET | 3 | KEY_INT1 | Order category | nvarchar | 2 | 0 | | |
14 | YIT_O3PRO | IDA: Original Table PRO | 3 | KEY_INT1 | Project definition (internal) | nvarchar | 8 | 0 | | |
15 | YIT_O3STN | IDA: Original Table STN | 3 | KEY_INT1 | Task List Type | nvarchar | 1 | 0 | | |
16 | YIT_O3STP | IDA: Original Table STP | 3 | KEY_INT1 | Current number for standard project | nvarchar | 8 | 0 | | |
17 | YIT_O3__1 | IDA: Original Table __1 Org. Units | 5 | KEY_INT1 | CATT: Application | nvarchar | 2 | 0 | | |
18 | YIT_R1NET | IDA: Reference table NET | 5 | KEY_INT1 | Order category | nvarchar | 2 | 0 | | |
19 | YIT_R1PRO | IDA: Reference table PRO | 5 | KEY_INT1 | Project definition (internal) | nvarchar | 8 | 0 | | |
20 | YIT_R1STN | IDA: Reference table STN | 5 | KEY_INT1 | Task List Type | nvarchar | 1 | 0 | | |
21 | YIT_R1STP | IDA: Reference table STP | 5 | KEY_INT1 | Current number for standard project | nvarchar | 8 | 0 | | |
22 | YIT_R1__1 | IDA: Reference Table __1 Org. Units | 6 | KEY_INT1 | CATT: Application | nvarchar | 2 | 0 | | |