OIUY3_TX_RPODT

Royalty 2.0 - TX GLO/TAMU - Oil Report | #transactional | Component: Royalty Reporting
Column Name Description
MANDT FK Client
RUN_ID Run ID of Tax Report
PROD_YEAR_MO Royalty 2.0 - Texas GLO/TAMU - Production Year/Month YYYYMM
GLO_LEASE FK Royalty 2.0 - TX GLO/TAMU Lease
RRC_DISTRICT_NO Royalty 2.0 - TX GLO/TAMU - District Number
RRC_OIL_LEASE_NO Royalty 2.0 - TX GLO/TAMU - RRC Oil Lease Number
RRC_GAS_WELL_ID Royalty 2.0 - TX GLO/TAMU - RRC Gas Well ID
RRC_DRILL_PERMIT Royalty 2.0 - TX GLO/TAMU - RRC Drilling Permit
GLO_UNIT_NO Royalty 2.0 - Texas GLO/TAMU - Unit Number
PURCHASER_ID Royalty 2.0 - Texas GLO/TAMU - Purchaser ID
REV_BOOK_ADJ_IND Royalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjs Show values
Column Name Description
💲 Currency Key (T001.WAERS):
GROSS_VALUE Gross Value
ROYALTY_DUE Royalty 2.0 - Texas GLO/TAMU - Royalty Due
Column Name Description
Column Name Description
Column Name Description
REV_BOOK_ADJ_IND Royalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjs Show values
REPORT_TYPE Royalty 2.0 - Texas GLO/TAMU - Report Type Show values
PROD_DISP_RPT Royalty 2.0 - TX GLO/TAMU - Production Disp Report Indicator Show values
AFFILIATED_SALE Royalty 2.0 - TX GLO - Affiliated Sale Indicator Show values
GLO_TIK Royalty 2.0 - Texas GLO/TAMU - GLO TIK Show values
IMMATERIAL Royalty 2.0 - TX GLO - Immaterial record Show values
ENTIRE_ROY_OB Royalty 2.0 - TX GLO/TAMU - Entire Royalty Obligation Show values
COMMENT_FL Royalty 2.0 - Texas GLO/TAMU - Comment Flag Show values
ORIGINAL_REPORT Royalty 2.0 - TX GLOTAMU - Original Report Show values
ZERO_VOL Royalty 2.0 - Texas GLO/TAMU - Zero Volume Flag Show values
PAY_REPORT_FLAG Royalty 2.0 - TX GLO/TAMU - Pay/Report Flag Show values
EXPECTED_RPT_EXC Royalty 2.0 - Texas GLO/TAMU No of Expected Reports Exceeded Show values
MULTI_PURCHASER Royalty 2.0 - Texas GLO/TAMU - Multiple Purchasers Flag Show values
Column Name Description Domain name
RRC_FIELD_NAME Royalty 2.0 - TX GLO/TAMU - RRC Field Name
RRC_LEASE_NAME Royalty 2.0 - TX GLO/TAMU - RRC Lease Name
PROP_ALIAS_NAME Royalty 2.0 - TX GLO/TAMU - Property Alias Name
TRACT_PART_FACT Royalty 2.0 - Texas GLO - Tract Participation Factor OIU_PERCENT98
OVERRIDE_CODE Royalty 2.0 - TX GLO/TAMU - Override Code
OPERATOR_ID Royalty 2.0 - TX GLO - Operator ID OIUY3_TX_ID
BEGINNING_STOCK Royalty 2.0 - TX GLO/TAMU - Beginning Stock OIUY3_SIGNED_DEC_15_6
GROSS_PRODUCTION Royalty 2.0 - TX GLO/TAMU - Gross Production OIUY3_SIGNED_DEC_15_6
PIPELINE Royalty 2.0 - TX GLO/TAMU - Pipeline OIUY3_SIGNED_DEC_15_6
TRUCK Royalty 2.0 - TX GLO/TAMU - Truck OIUY3_SIGNED_DEC_15_6
TANK_CAR_BARGE Royalty 2.0 - TX GLO/TAMU - Tank Car Barge OIUY3_SIGNED_DEC_15_6
TANK_CLEANING Royalty 2.0 - TX GLO/TAMU - Tank Cleaning OIUY3_SIGNED_DEC_15_6
CIRC_OIL_COND Royalty 2.0 - TX GLO/TAMU - Circulating Oil/Condensate OIUY3_SIGNED_DEC_15_6
LOST_STOLEN Royalty 2.0 - TX GLO/TAMU - Lost/Stolen OIUY3_SIGNED_DEC_15_6
BSW Royalty 2.0 - TX GLO/TAMU - Basic Sediment / Water OIUY3_SIGNED_DEC_15_6
OTHER_ROY_DUE Royalty 2.0 - TX GLO/TAMU - Other Royalty Due OIUY3_SIGNED_DEC_15_6
OTHER_NO_ROY_DUE Royalty 2.0 - TX GLO/TAMU - Other No Royalty Due OIUY3_SIGNED_DEC_15_6
SKIM_LIQ_HYDRO Royalty 2.0 - TX GLO/TAMU - Skim Liquid Hydrocarbon OIUY3_SIGNED_DEC_15_6
SCRUBBER_OIL Royalty 2.0 - TX GLO/TAMU - Scrubber Oil OIUY3_SIGNED_DEC_15_6
ENDING_STOCK Royalty 2.0 - TX GLO/TAMU - Ending Stock OIUY3_SIGNED_DEC_15_6
DRIP_OIL Royalty 2.0 - TX GLO/TAMU - Drip Oil OIUY3_SIGNED_DEC_15_6
ROY_DUE_NET_BBLS Royalty 2.0 - TX GLO/TAMU - Royalty Due Net Barrels OIUY3_SIGNED_DEC_15_6
API_GRAVITY Royalty 2.0 - Texas GLO/TAMU - API Gravity
UNIT_VALUE Royalty 2.0 - Texas GLO/TAMU - Unit Value
ROYALTY_DECIMAL Royalty 2.0 - Texas GLO - Royalty Decimal OIU_PERCENT98
REPORT_NUM Roy 2.0 TX - Report Number
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
Royalty 2.0 - TX GLO/TAMU Lease
Client OIUY3_TX_RPODT.MANDT == T000.MANDT