OIUY5_OK_RPGDT - Roy 2.0 OK � Gas Report Details
Roy 2.0 OK � Gas Report Details information is stored in SAP table OIUY5_OK_RPGDT.
It is part of development package OIU_Y5 in software component IS-OIL-PRA-REP-ROY. This development package consists of objects that can be grouped under "OK Royalty 2.0".
It is part of development package OIU_Y5 in software component IS-OIL-PRA-REP-ROY. This development package consists of objects that can be grouped under "OK Royalty 2.0".
Fields for table OIUY5_OK_RPGDT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
RUN_ID | Proc 2.0 - Run ID | X | OIUE2_RUN_ID | NUMC | 20 | OIUE2_RUN_HDR |
.INCLUDE | ROIUY5_OK_RPDT_KEY | X | ROIUY5_OK_RPDT_KEY | 0 | ||
SALES_DT | Sales Date / Month | X | OIU_SALE_DT | DATS | 16 | |
ENTITY_ID | Gen Rep - Agency Entity ID | X | OIUGR_ENTITY_ID | CHAR | 40 | |
REV_BOOK_ADJ_IND | Gen Roy 2.0 - Reversal/Booking/Reversal Adjustment/Adjs | X | OIUGR_REV_BK_REVADJ_ADJ_IND | CHAR | 2 | |
.INCLUDE | ROIUY5_OK_PROF_NONKEY | ROIUY5_OK_PROF_NONKEY | 0 | |||
PAYOR_NAME | Roy 2.0 OK � Payor Name | OIUY5_OK_PAYOR_NAME | CHAR | 60 | ||
.INCLUDE | ROIUY5_OK_ENTITY_NONKEY | ROIUY5_OK_ENTITY_NONKEY | 0 | |||
LESSEE | Roy 2.0 OK � Lessee | OIUY5_OK_LESSEE | CHAR | 60 | ||
DESCRIPTION | Roy 2.0 OK � Description | OIUY5_OK_DESCRIPTION | CHAR | 60 | ||
SEC_GEO_LOC | Secondary geographic location | OIU_SEC_GEO_LOC | CHAR | 6 | OIU_CM_LXSGL | |
TWP | Township number | OIU_TWP_NO | CHAR | 6 | ||
RGE | Roy 2.0 OK � Region | OIUY5_OK_RGE | CHAR | 6 | ||
SEC_GEO_DESC | Secondary Geographical Location Description | OIU_SEC_GEO_DESC | CHAR | 60 | ||
LEASE_NAME | Roy 2.0 OK � Lease Name | OIUY5_OK_LEASE_NAME | CHAR | 60 | ||
NO_OF_OG_WELLS | Roy 2.0 OK � No. of Wells | OIUY5_OK_NO_OF_WELLS | CHAR | 6 | ||
NO_OF_OIL_WELLS | Roy 2.0 OK � No. of Wells | OIUY5_OK_NO_OF_WELLS | CHAR | 6 | ||
ROYALTY_INT | Roy 2.0 OK � Royalty Interest | OIUY5_OK_ROYALTY_INT | DEC | 5 | ||
.INCLUDE | ROIUY5_OK_RPGDT_NONKEY_NUMERIC | ROIUY5_OK_RPGDT_NONKEY_NUMERIC | 0 | |||
GROSS_PRODUCTION_GAS | Roy 2.0 OK � Gross Production | OIUY5_OK_GROSS_PROD | DEC | 6 | ||
GROSS_VALUE_GAS | Roy 2.0 OK � Gross Value | OIUY5_OK_GROSS_VAL | CURR | 6 | ||
GROSS_VALUE_NGL | Roy 2.0 OK � Gross Value | OIUY5_OK_GROSS_VAL | CURR | 6 | ||
GROSS_VOLUME_RESIDUE | Roy 2.0 OK � Gross Volume | OIUY5_OK_GROSS_VOL | DEC | 6 | ||
CT_PERCENT_TO_LEASE | Roy 2.0 OK � Contract Percent to Lease | OIUY5_OK_CT_PCNT_TO_LEASE | DEC | 4 | ||
PRICE_RESIDUE | Roy 2.0 OK � Price | OIUY5_OK_PRICE | DEC | 3 | ||
GROSS_VALUE_RESIDUE | Roy 2.0 OK � Gross Value | OIUY5_OK_GROSS_VAL | CURR | 6 | ||
TOTAL_VALUE | Roy 2.0 OK � Total Value | OIUY5_OK_TOTAL_VAL | CURR | 6 | ||
ADJUSTMENT_VALUE_GAS | Roy 2.0 OK � Adjustment Value | OIUY5_OK_ADJUSTMENT_VAL | CURR | 6 | ||
ADJUSTED_VALUE_GAS | Roy 2.0 OK � Adjusted Value | OIUY5_OK_ADJUSTED_VAL | CURR | 6 | ||
ROYALTY_DUE_GAS | Roy 2.0 OK � Royalty Due | OIUY5_OK_ROY_DUE | CURR | 6 | ||
GROSS_VOLUME_DRY_GAS | Roy 2.0 OK � Gross Volume | OIUY5_OK_GROSS_VOL | DEC | 6 | ||
PRICE_DRY_GAS | Roy 2.0 OK � Price | OIUY5_OK_PRICE | DEC | 3 | ||
TOTAL_VALUE_DRY_GAS | Roy 2.0 OK � Total Value | OIUY5_OK_TOTAL_VAL | CURR | 6 | ||
ADJUSTMENT_VALUE_DRY_GAS | Roy 2.0 OK � Adjustment Value | OIUY5_OK_ADJUSTMENT_VAL | CURR | 6 | ||
ADJUSTED_VALUE_DRY_GAS | Roy 2.0 OK � Adjusted Value | OIUY5_OK_ADJUSTED_VAL | CURR | 6 | ||
ROYALTY_INT_DRY_GAS | Roy 2.0 OK � Royalty Interest | OIUY5_OK_ROYALTY_INT | DEC | 5 | ||
ROYALTY_DUE_DRY_GAS | Roy 2.0 OK � Royalty Due | OIUY5_OK_ROY_DUE | CURR | 6 | ||
.INCLUDE | /PRA/LAST_CHANGED | /PRA/LAST_CHANGED | 0 | |||
CHANGE_USER | Last Changed By | OIUX3_LAST_CHANGED_USER | CHAR | 24 | ||
CHANGE_TIMESTAMP | Last Changed Timestamp | /PRA/LAST_CHANGED_TZNTSTMPS | DEC | 8 |