OIUREP_ARCROYHIS

Archived Reported Royalty and Volume Data | #transactional | Component: Production and Revenue Accounting
Column Name Description
MANDT FK Client
YEAR_MONTH Reporting Year and Month
ORG_LEVEL1_NO FK Company Code
AGENCY FK Agency for Reporting
OIL_GAS_IND Oil and Gas Indicator Show values
YEAR_MONTH_AMND Year and Month for Amended Reports
AGENCY_LEASE Agency assigned Lease No.
AGENCY_PROD_CODE FK Agency defined product code
AGENCY_VOL_TYPE FK Agency defined Volume type
GRAVITY_QTY Gravity Quantity
Column Name Description
💲 Currency (CURRENCY):
GROSS_VALUE Gross Value From a Contract/Well
NET_VALUE Net Value From a Contract/Well
TRANSPORT_COST Transportation Cost
TAX_AMT Deduction Amount
MARKETING_TOT Deduction Amount
DEDUCTION_AMT1 Deduction Amount
DEDUCTION_AMT2 Deduction Amount
DEDUCTION_AMT3 Deduction Amount
DEDUCTION_AMT4 Deduction Amount
ROYALTY_DUE Royalty Amount due to the State Agency
Column Name Description
📏 Standard volume unit (STD_VOL_U):
GROSS_VOLUME Gross Volume
NET_VOLUME Net Volume
NGL_VOLUME NGL Volume
📏 Energy quantity unit (ENERGY_U):
ENERGY energy
Column Name Description
Column Name Description
OIL_GAS_IND Oil and Gas Indicator Show values
Column Name Description Domain name
UNIT_PROPERTY_NO Joint venture JV_NAME
TRACT_PF Tract Participation Factor Decimal OIU_PERCENT98
API_GRV Oil/gas density at standard/base conditions OIU_QCI_OIB_DICHT
UPLOAD_FLAG Single-Character Flag CHAR1
OIU_CRUSER Name of Person Responsible for Creating the Object USNAM
OIU_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Agency for Reporting OIUREP_ARCROYHIS.AGENCY == OIUREP_ROY_AGY.AGENCY
Agency defined product code
  • Agency for Reporting
  • Agency defined product code
Agency defined Volume type
  • Agency for Reporting
  • Agency defined Volume type
Client OIUREP_ARCROYHIS.MANDT == T000.MANDT
Company Code
  • OIUREP_ARCROYHIS.MANDT == T001.MANDT
  • OIUREP_ARCROYHIS.ORG_LEVEL1_NO == T001.BUKRS