| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | YIT_R1ACC | IDA: Reference Table ACC | 8 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
2 | YIT_R1ASS | IDA: Reference Table ASS | 8 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
3 | YIT_R1BNK | IDA: Reference Table BNK | 8 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
4 | YIT_R1BOM | IDA: Reference Table BOM | 8 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
5 | YIT_R1CAT | IDA: Reference Table CAT | 6 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
6 | YIT_R1COE | IDA: Reference Table COE | 9 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
7 | YIT_R1COS | IDA: Reference Table COS | 9 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
8 | YIT_R1CRE | IDA: Reference Table CRE | 7 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
9 | YIT_R1DEB | IDA: Reference Table DEB | 7 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
10 | YIT_R1DOC | IDA: Reference Table DOC | 8 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
11 | YIT_R1EQU | IDA: Reference Table EQU | 7 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
12 | YIT_R1IPR | IDA: Reference Table IPR | 7 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
13 | YIT_R1MAT | IDA: Reference Table MAT | 7 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
14 | YIT_R1MPL | IDA: Reference table MPL | 7 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
15 | YIT_R1NET | IDA: Reference table NET | 8 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
16 | YIT_R1OBJ | IDA: Reference table OBJ | 9 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
17 | YIT_R1ORD | IDA: Reference table ORD | 8 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
18 | YIT_R1PER | IDA: Reference table PER | 7 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
19 | YIT_R1PRC | IDA: Reference Table COS | 9 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
20 | YIT_R1PRO | IDA: Reference table PRO | 8 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
21 | YIT_R1ROU | IDA: Reference table ROU | 9 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
22 | YIT_R1STN | IDA: Reference table STN | 8 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
23 | YIT_R1STP | IDA: Reference table STP | 8 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
24 | YIT_R1TPL | IDA: Reference Table TPL | 7 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
25 | YIT_R1WOR | IDA: Reference Table WOR | 8 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
26 | YIT_R1__1 | IDA: Reference Table __1 Org. Units | 9 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |
27 | YIT_R1__2 | IDA: Reference Table __2 Application Customizing | 9 | DAT_COMM1 | IDA: text line 1 for comments | nvarchar | 132 | 0 | | |