Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
1 | YIT_O2ACC | IDA: Original Table ACC | 28 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
2 | YIT_O2ASS | IDA: Original Table ASS | 28 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
3 | YIT_O2BNK | IDA: Original Table BNK | 28 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
4 | YIT_O2BOM | IDA: Original Table BOM | 28 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
5 | YIT_O2CAT | IDA: Original Table CAT | 26 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
6 | YIT_O2COE | IDA: Original Table COE | 29 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
7 | YIT_O2COS | IDA: Original Table COS | 29 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
8 | YIT_O2CRE | IDA: Original Table CRE | 27 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
9 | YIT_O2DEB | IDA: Original Table DEB | 27 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
10 | YIT_O2DOC | IDA: Original Table DOC | 28 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
11 | YIT_O2EQU | IDA: Original Table EQU | 27 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
12 | YIT_O2IPR | IDA: Original Table IPR | 27 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
13 | YIT_O2MAT | IDA: Original Table MAT | 27 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
14 | YIT_O2MPL | IDA: Original Table MPL | 27 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
15 | YIT_O2NET | IDA: Original Table NET | 28 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
16 | YIT_O2OBJ | IDA: Original Table OBJ | 29 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
17 | YIT_O2ORD | IDA: Original Table ORD | 28 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
18 | YIT_O2PER | IDA: Original Table PER | 27 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
19 | YIT_O2PRC | IDA: Original Table PRC | 29 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
20 | YIT_O2PRO | IDA: Original Table PRO | 28 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
21 | YIT_O2ROU | IDA: Original Table ROU | 29 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
22 | YIT_O2STN | IDA: Original Table STN | 28 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
23 | YIT_O2STP | IDA: Original Table STP | 28 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
24 | YIT_O2TPL | IDA: Original Table TPL | 27 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
25 | YIT_O2WOR | IDA: Original Table WOR | 28 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
26 | YIT_O2__1 | IDA: Original Table __1 Org. Units | 29 | N10_1 | 10 digit number | nvarchar | 10 | 0 | ||
27 | YIT_O2__2 | IDA: Original Table __2 Application Customizing | 29 | N10_1 | 10 digit number | nvarchar | 10 | 0 |