| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPRoyalty Reporting |
1 | OIUREP_MMS_REJS | MMS-2014 - Extraction Rejects | 48 | TRNSP_ALW_DE_CUR | MMS-2014 - Transportation Allowance Currency | nvarchar | 5 | 0 | | |
2 | OIUREP_MRT_HIST | MMS-2014 MMS Royalty Transaction Processed History | 27 | TRNSP_ALW_DE_CUR | MMS-2014 - Transportation Allowance Currency | nvarchar | 5 | 0 | | |
3 | OIUREP_MRT_PEND | MMS-2014 MMS Royalty Transaction Processed - Pending | 27 | TRNSP_ALW_DE_CUR | MMS-2014 - Transportation Allowance Currency | nvarchar | 5 | 0 | | |
4 | OIUREP_RTPEND | MMS-2014 - Royalty Transaction Pending | 47 | TRNSP_ALW_DE_CUR | MMS-2014 - Transportation Allowance Currency | nvarchar | 5 | 0 | | |
5 | OIUREP_RT_HIST | MMS-2014 - Royalty Transaction (Pending) History | 47 | TRNSP_ALW_DE_CUR | MMS-2014 - Transportation Allowance Currency | nvarchar | 5 | 0 | | |