| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | J_1UF_REEI_XML_A | XML table for J_1UF_REEI with User | 31 | ADJUSTMENTS | VAT Adjustments/Distribution Indicator | nvarchar | 1 | 0 | | |
2 | J_1UF_REP_XML | XML table for J_1UF_REP | 35 | ADJUSTMENTS | VAT Adjustments/Distribution Indicator | nvarchar | 1 | 0 | | |
3 | J_1UF_REP_XML_A | XML table for J_1UF_REEI with User | 36 | ADJUSTMENTS | VAT Adjustments/Distribution Indicator | nvarchar | 1 | 0 | | |
4 | J_1UF_RES_XML | XML table for J_1UF_RES | 34 | ADJUSTMENTS | VAT Adjustments/Distribution Indicator | nvarchar | 1 | 0 | | |
TOPFinancial Accounting |
5 | J_1UF_REEII_XML | XML table for J_1UF_REEII | 31 | ADJUSTMENTS | VAT Adjustments/Distribution Indicator | nvarchar | 1 | 0 | | |
6 | J_1UF_REEI_XML | XML table for J_1UF_REEI | 30 | ADJUSTMENTS | VAT Adjustments/Distribution Indicator | nvarchar | 1 | 0 | | |
TOPRoyalty Reporting |
7 | OIUREP_ADJ_DTLA | MMS OGOR A Adjustment Detail Record | 19 | ADJUSTMENTS | Adjustment Indicator | nvarchar | 1 | 0 | | |
8 | OIUREP_ADJ_DTLB | MMS OGOR B Adjustment Detail Record | 18 | ADJUSTMENTS | Adjustment Indicator | nvarchar | 1 | 0 | | |
9 | OIUREP_ADJ_DTLC | MMS OGOR C Adjustment Detail Record | 20 | ADJUSTMENTS | Adjustment Indicator | nvarchar | 1 | 0 | | |
10 | OIUREP_ADJ_HDR | Adjustment Header for MMS OGOR | 16 | ADJUSTMENTS | Adjustment Indicator | nvarchar | 1 | 0 | | |
11 | OIUREP_ADJ_PASR | MMS PASR Adjustment Detail Record | 16 | ADJUSTMENTS | Adjustment Indicator | nvarchar | 1 | 0 | | |
12 | OIUREP_ADJ_PASRH | MMS PASR Adjustment Header Record | 19 | ADJUSTMENTS | Adjustment Indicator | nvarchar | 1 | 0 | | |