Industry Specific :: Industry Solution Oil :: Production and Revenue Accounting :: Revenue |
| Product | Version | Table | Columns | Indexes | Description | Module |
---|
1 | ERP EHP7 | 6.0 | OIUH_RV_DOH | 36 | 6 | DOI Owner History | Revenue |
Name | Primary | Unique | Type | Columns |
---|
OIUH_RV_DOH~0 | Yes | Yes | CLUSTERED | DUMMY_SEQ_FIELD, MANDT |
OIUH_RV_DOH~I01 | No | No | NONCLUSTERED | DOH_EFF_FROM_DT, H_NEW_OI_SEQ_NO, NEW_OI_TYPE_CD, NEW_OWN_SEQ_NO, DOH_NEW_OWN_NO, DOH_DOI_NO, DOH_PR_NO, MANDT |
OIUH_RV_DOH~I02 | No | No | NONCLUSTERED | DOH_EFF_FROM_DT, H_OLD_OWN_DI_PC, DOH_OOI_SEQ_NO, DOH_OOI_TYPE_CD, OLD_OWN_SEQ_NO, DOH_OLD_OWN_NO, DOH_DOI_NO, DOH_PR_NO, MANDT |
OIUH_RV_DOH~I03 | No | No | NONCLUSTERED | H_OLD_OWN_DI_PC, DOH_EFF_TO_DT, DOH_EFF_FROM_DT, DOH_OOI_SEQ_NO, DOH_OOI_TYPE_CD, OLD_OWN_SEQ_NO, DOH_OLD_OWN_NO, DOH_DOI_NO, DOH_PR_NO, MANDT |
OIUH_RV_DOH~I04 | No | No | NONCLUSTERED | OLD_OWN_SEQ_NO, DOH_OLD_OWN_NO, DOH_USER_ID, MANDT |
OIUH_RV_DOH~I05 | No | Yes | NONCLUSTERED | DOH_FILE_NO, DOH_EFF_FROM_DT, H_NEW_OI_SEQ_NO, NEW_OI_TYPE_CD, NEW_OWN_SEQ_NO, DOH_NEW_OWN_NO, DOH_OOI_SEQ_NO, DOH_OOI_TYPE_CD, OLD_OWN_SEQ_NO, DOH_OLD_OWN_NO, DOH_DOI_NO, DOH_PR_NO, MANDT |