OIUY3_TX_INTTXN

Royalty 2.0 - TX GLO/TAMU - Royalty Transaction Interface | #transactional | Component: Royalty Reporting
Column Name Description
MANDT FK Client
OR_LVL_1_NO Company Name Code
ACCT_PERD_DT Accounting Period(YYYYMM01)
BTCH_NO Batch ID
LE_NO Journal Entry Line Number
Column Name Description
💲 Currency Key (T001.WAERS):
GR_AM Gross Value
TXN_VAL_AM Royalty 2.0 - TX GLO - Owner Gross Value
DED_RMB_AM Deduction/Reimbursement Amount
NET_TRANSP_AM Marketing Cost
NET_OTH_MK_AM Marketing Cost
TAX_RMB_AM Tax Reimbursement Amount
TAX_AM Tax amount
Column Name Description
Column Name Description
SALES_DT Sales Date / Month
Column Name Description
AFFILIATED_SALE Royalty 2.0 - TX GLO - Affiliated Sale Indicator Show values
ORIGINAL_REPORT Royalty 2.0 - TX GLOTAMU - Original Report Show values
GAS_DISP_CODE Royalty 2.0 - TX GLO/TAMU - Royalty Gas Disposition Code Show values
UNIT_VNAME_FLAG Roy 2.0 - Texas GLO/TAMU - Unit Venture Show values
PAY_REPORT_FLAG Royalty 2.0 - TX GLO/TAMU - Pay/Report Flag Show values
INTERFACE_FL Royalty 2.0 - TX GLO - Interface Flag Show values
Column Name Description Domain name
OWNER_IDENTIFIER Royalty 2.0 - Owner Identifier
ACCT_NO Account ID CHAR10
CHV_RPT_CD Template Cost Center KOSTL
PS_BASE_QY Pressure Base Quantity OIUH_DEC6_3
GRV_QY Gravity OIUH_DEC3_1
PAY_CD Pay Code CHAR2
OWN_INT_DECM_QY Royalty 2.0 - TX GLO - Owner NRI OIU_PERCENT98
OWN_BAL_DECM_QY Owner Disbursement (Balance) Decimal OIUH_DEC9_8
PU_NO Purchaser ID CHAR6
PU_SEQ_NO Purchaser Sequence Number CHAR2
GR_QY Gross Volume OIUX3_SIGNED_DEC_11_2
TRANS_AM JE Transaction Amount OIUX3_SIGNED_DEC_11_2
TRANS_QY JE Transaction Quantity OIUH_DEC11_2
MMBTU_OVL_AM Owner MMBTU OIUH_DEC11_2
PLT_VL_GRED_AM Gross Plant Volume Reduction amount OIUH_DEC11_2
PLT_VL_ORED_AM Owner Plant Volume Reduction amount OIUH_DEC11_2
BTU_QY BTU Quantity OIUH_DEC7_3
MASTER_LEVEL Royalty 2.0 - TX GLO - Master Level
RRC_LEVEL Royalty 2.0 - TX GLO - RRC Master Level
PURCHASER_ID Royalty 2.0 - Texas GLO/TAMU - Purchaser ID
OPERATOR_ID Royalty 2.0 - TX GLO - Operator ID OIUY3_TX_ID
ROYALTY_DECIMAL Royalty 2.0 - Texas GLO - Royalty Decimal OIU_PERCENT98
ALLOC_PERCENT Royalty 2.0 - TX GLO/TAMU - Allocation Percent OIU_PERCENT98
TRACT_PART_FACT Royalty 2.0 - Texas GLO - Tract Participation Factor OIU_PERCENT98
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
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
OPERATOR_SEQ_NO Royalty 2.0 - TX GLO - Operator Sequence Number OIUCM_SEQ_NO
DOC_NO Val. document number OIU_MP_NO
DOC_YEAR Document year GJAHR
OPTION1 null
OPTION2 null
OPTION3 null
REFERENCE_RUN_ID Run ID of Tax Report NUMC10
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
Company Code
Delivery network number
Division of interest (DOI)
  • Joint venture
  • Division of interest (DOI)
  • Company Code
Royalty 2.0 - TX GLO/TAMU Lease
Royalty 2.0 - Texas GLO/TAMU - Unit Number
  • Royalty 2.0 - TX GLO/TAMU Lease
  • Royalty 2.0 - Texas GLO/TAMU - Unit Number
  • ?
Client OIUY3_TX_INTTXN.MANDT == T000.MANDT
Measurement point number
Royalty 2.0 - TX GLO/TAMU - Operator Number
  • Royalty 2.0 - TX GLO/TAMU - Operator Number
  • Royalty 2.0 - TX GLO - Operator Sequence Number
  • Client
Full three char. product code (Major and Detail Products) OIUY3_TX_INTTXN.PDCD == OIUX3_PDCD.PDCD
Measurement unit
  • OIUY3_TX_INTTXN.MANDT == T006.MANDT
  • OIUY3_TX_INTTXN.UOM == T006.MSEHI
Volume type code OIUY3_TX_INTTXN.VL_TYPE_CD == OIU_PR_VLTYP.VL_TYPE_CD
Joint venture
  • Joint venture
  • Company Code
Well Completion Number
  • Well ID number
  • Well Completion Number
Well ID number