ERP 6.0 | OIUY3_TX_ROYHST TABLE
1 | ERP EHP7 | 6.0 | OIUY3_TX_ROYHST | 70 | 6 | Royalty 2.0 - TX GLO - Royalty Transaction History |
ERP 6.0 | OIUY3_TX_ROYHST COLUMNS
ERP 6.0 | OIUY3_TX_ROYHST INDEXES
Name | Primary | Unique | Type | Columns |
---|---|---|---|---|
OIUY3_TX_ROYHST~0 | Yes | Yes | CLUSTERED | REV_BOOK_ADJ_IND, OWNER_IDENTIFIER, VL_TYPE_CD, CT_NO, DN_NO, DOI_NO, VNAME, MP_NO, WC_NO, WL_NO, PDCD, SALES_DT, BUKRS, MANDT |
OIUY3_TX_ROYHST~00 | No | No | NONCLUSTERED | PDCD, SALES_DT, WC_NO, WL_NO, MANDT |
OIUY3_TX_ROYHST~10 | No | No | NONCLUSTERED | PDCD, SALES_DT, MP_NO, MANDT |
OIUY3_TX_ROYHST~20 | No | No | NONCLUSTERED | PDCD, SALES_DT, DOI_NO, VNAME, BUKRS, MANDT |
OIUY3_TX_ROYHST~30 | No | No | NONCLUSTERED | PDCD, SALES_DT, GLO_LEASE, MANDT |
OIUY3_TX_ROYHST~50 | No | No | NONCLUSTERED | PURCHASER_ID, PDCD, SALES_DT, GLO_LEASE, RRC_DRILL_PERMIT, RRC_GAS_WELL_ID, RRC_OIL_LEASE_NO, RRC_DISTRICT_NO, MANDT |