| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPRoyalty Reporting |
1 | OIUREP_ADJ_DTLA | MMS OGOR A Adjustment Detail Record | 20 | RPT_FLAG | Report Flag - Determines if included in Current/Amended Adj | nvarchar | 1 | 0 | | |
2 | OIUREP_ADJ_DTLB | MMS OGOR B Adjustment Detail Record | 19 | RPT_FLAG | Report Flag - Determines if included in Current/Amended Adj | nvarchar | 1 | 0 | | |
3 | OIUREP_ADJ_DTLC | MMS OGOR C Adjustment Detail Record | 21 | RPT_FLAG | Report Flag - Determines if included in Current/Amended Adj | nvarchar | 1 | 0 | | |
4 | OIUREP_ADJ_HDR | Adjustment Header for MMS OGOR | 18 | RPT_FLAG | Report Flag - Determines if included in Current/Amended Adj | nvarchar | 1 | 0 | | |
5 | OIUREP_ADJ_PASR | MMS PASR Adjustment Detail Record | 17 | RPT_FLAG | Report Flag - Determines if included in Current/Amended Adj | nvarchar | 1 | 0 | | |
6 | OIUREP_ADJ_PASRH | MMS PASR Adjustment Header Record | 20 | RPT_FLAG | Report Flag - Determines if included in Current/Amended Adj | nvarchar | 1 | 0 | | |