SAP ROIUREP_ROY_WY_M1M2 table - Royalty Data Download for M1 & M2 details in SAP

Description: Joint venture
Field Name: UNIT_PROPERTY_NO
Data Element: JV_NAME
Data Type: CHAR
length (Dec): 6(0)
Check table:
Conversion Routine: ALPHA
Domain Name: JV_NAME
MemoryID: JVV
AppClass: FGJ
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field UNIT_PROPERTY_NO

Description: Agency assigned Lease No.
Field Name: AGENCY_LEASE
Data Element: OIUREP_AGENCY_LEASE
Data Type: CHAR
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: OIUREP_AGENCY_LEASE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AGENCY_LEASE

Description: Joint venture
Field Name: PROPERTY_NO
Data Element: JV_NAME
Data Type: CHAR
length (Dec): 6(0)
Check table:
Conversion Routine: ALPHA
Domain Name: JV_NAME
MemoryID: JVV
AppClass: FGJ
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field PROPERTY_NO

Description: Division of interest (DOI)
Field Name: DOI_NO
Data Element: OIU_DOI_NO
Data Type: CHAR
length (Dec): 5(0)
Check table:
Conversion Routine: ALPHA
Domain Name: OIU_DOI_NO
MemoryID: OIU_DOI
AppClass:
SHLP: H_OIU_DO_DI
SHLP Field: DOI_NO
ConvExit: ALPHA

See all SAP tables containing field DOI_NO

Description: Agency defined product code
Field Name: AGENCY_PROD_CODE
Data Element: OIUREP_AGENCY_PDCD
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: OIUREP_AGENCY_PDCD
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AGENCY_PROD_CODE

Description: Year and Month for Amended Reports
Field Name: YEAR_MONTH_AMND
Data Element: OIUREP_AMND_YYYYMM
Data Type: NUMC
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: OIUREP_RPT_YYYYMM
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field YEAR_MONTH_AMND

Description: Last/Current indicator
Field Name: LAST_CURR_IND
Data Element: OIUREP_LAST_CURR_IND
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: OIUREP_LAST_CURR_IND
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_CURR_IND

Description: Gross Volume
Field Name: GROSS_VOLUME
Data Element: OIUREP_GROSS_VOLUME
Data Type: QUAN
length (Dec): 13(3)
Check table:
Conversion Routine:
Domain Name: MENGE
MemoryID:
AppClass: MB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GROSS_VOLUME

Description: Gross Value From a Contract/Well
Field Name: GROSS_VALUE
Data Element: OIUREP_GROSS_VALUE
Data Type: CURR
length (Dec): 13(2)
Check table:
Conversion Routine:
Domain Name: OIUREP_VALUE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GROSS_VALUE

Description: Generic Price Per Unit for Oil/Gas
Field Name: PRICE
Data Element: OIUREP_PRICE_PER_UNIT
Data Type: DEC
length (Dec): 5(2)
Check table:
Conversion Routine:
Domain Name: OIUH_DEC5_2
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PRICE

Description: Tract Participation Factor Decimal
Field Name: TRACT_PF
Data Element: OIU_TR_PART_FACT_PC
Data Type: DEC
length (Dec): 9(8)
Check table:
Conversion Routine:
Domain Name: OIU_PERCENT98
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRACT_PF

Description: Payor's fraction of Royalty payment
Field Name: PAYOR_FRACTION
Data Element: OIUREP_PAYOR_FRACTION
Data Type: DEC
length (Dec): 9(8)
Check table:
Conversion Routine:
Domain Name: OIUREP_PAYOR_FRACTION
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAYOR_FRACTION

Description: Royalty Amount due to the State Agency
Field Name: ROYALTY_DUE
Data Element: OIUREP_ROYALTY_DUE
Data Type: CURR
length (Dec): 13(2)
Check table:
Conversion Routine:
Domain Name: OIUREP_VALUE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROYALTY_DUE