| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1RA/0SD010CO | Items for Class SD01 - Raw Data | 6 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
2 | /1RA/0SD010MI | Items for Class SD01 - Raw Data | 5 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
3 | /1RA/0SD012CO | Items for Class SD01 - Processable | 6 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
4 | /1RA/0SD012MI | Items for Class SD01 - Processable | 5 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
5 | /1RA/0SD014CO | Items for Class SD01 - Processed | 6 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
6 | /1RA/0SD014MI | Items for Class SD01 - Processed | 5 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
7 | /1RA/0SD020CO | Items for Class SD02 - Raw Data | 6 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
8 | /1RA/0SD020MI | Items for Class SD02 - Raw Data | 5 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
9 | /1RA/0SD022CO | Items for Class SD02 - Processable | 6 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
10 | /1RA/0SD022MI | Items for Class SD02 - Processable | 5 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
11 | /1RA/0SD024CO | Items for Class SD02 - Processed | 6 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
12 | /1RA/0SD024MI | Items for Class SD02 - Processed | 5 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
13 | /1RA/0SD030CO | Items for Class SD03 - Raw Data | 6 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
14 | /1RA/0SD030MI | Items for Class SD03 - Raw Data | 5 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
15 | /1RA/0SD032CO | Items for Class SD03 - Processable | 6 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
16 | /1RA/0SD032MI | Items for Class SD03 - Processable | 5 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
17 | /1RA/0SD034CO | Items for Class SD03 - Processed | 6 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
18 | /1RA/0SD034MI | Items for Class SD03 - Processed | 5 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
19 | FARR_D_COMP | Compound groups of Contract items | 6 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
20 | FARR_D_LEGACY | Legacy data for initial load of revenue accounting items | 5 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
21 | FARR_D_LEGACYC | Legacy data for initial load of conditions for rev.acc.it. | 5 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
22 | FARR_D_LEGACYSF | legacy data for scheduled fulfillments (time based) | 5 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
23 | FARR_D_MAPPING | Mapping Table to map source document to POBs of RA-Contracts | 6 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
24 | FARR_D_MAPPING_F | Mapping table for Fulfillment | 5 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
25 | FARR_D_MAPPING_I | Mapping table for Invoices | 5 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
26 | FARR_D_PP_LOCKED | Mass Processing: Locked RAIs per Mass Rund ID | 8 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
27 | FARR_D_PP_UNITS | Unit Related Parameters for Parallel Processing | 7 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
28 | FARR_D_RAI2_PROC | Acct. principles RAI2 was successfully processed for | 5 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |
29 | FARR_D_RAI_CH | Change Sequence of Changed Items | 8 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | | |