OIUY3_TX_ROYHST

Royalty 2.0 - TX GLO - Royalty Transaction History | #transactional | Component: Royalty Reporting

🔑 Keys (14)
💰 Amounts (7)
∑ Quantities
📅 Dates (1)
☰ Categorical (7)
Other (39)
🔗 Relations (14)

Column Name	Description
MANDT FK	Client
BUKRS FK	Company Code
SALES_DT	Sales Date / Month
PDCD FK	Full three char. product code (Major and Detail Products)
WL_NO FK	Well ID number
WC_NO FK	Well Completion Number
MP_NO FK	Measurement point number
VNAME FK	Joint venture
DOI_NO FK	Division of interest (DOI)
DN_NO FK	Delivery network number
CT_NO FK	Contract Number
VL_TYPE_CD FK	Volume type code
OWNER_IDENTIFIER	Royalty 2.0 - Owner Identifier
REV_BOOK_ADJ_IND	Royalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjs	Show values

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
REV_BOOK_ADJ_IND	Royalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjs	Show values
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
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	`OIUY3_TX_ROYHST.MANDT == OIU_CM_COMPC.MANDT` `OIUY3_TX_ROYHST.BUKRS == OIU_CM_COMPC.BUKRS`
Delivery network number	`OIUY3_TX_ROYHST.MANDT == OIU_PR_DN.MANDT` `OIUY3_TX_ROYHST.DN_NO == OIU_PR_DN.DN_NO`
Division of interest (DOI) Joint venture Division of interest (DOI) Company Code	`OIUY3_TX_ROYHST.MANDT == OIU_DO_DI.MANDT` `OIUY3_TX_ROYHST.VNAME == OIU_DO_DI.VNAME` `OIUY3_TX_ROYHST.DOI_NO == OIU_DO_DI.DOI_NO` `OIUY3_TX_ROYHST.BUKRS == OIU_DO_DI.BUKRS`
Royalty 2.0 - TX GLO/TAMU Lease	`OIUY3_TX_ROYHST.MANDT == OIUY3_TX_LEASE.MANDT` `OIUY3_TX_ROYHST.GLO_LEASE == OIUY3_TX_LEASE.GLO_LEASE`
Royalty 2.0 - Texas GLO/TAMU - Unit Number Royalty 2.0 - TX GLO/TAMU Lease Royalty 2.0 - Texas GLO/TAMU - Unit Number ?	`OIUY3_TX_ROYHST.MANDT == OIUY3_TX_UNIT.MANDT` `OIUY3_TX_ROYHST.GLO_LEASE == OIUY3_TX_UNIT.GLO_LEASE` `OIUY3_TX_ROYHST.GLO_UNIT_NO == OIUY3_TX_UNIT.GLO_UNIT_NO` `OIUY3_TX_ROYHST.[column in domain "OIU_EFF_FROM_DT"] == OIUY3_TX_UNIT.EFF_FROM_DT`
Client	`OIUY3_TX_ROYHST.MANDT == T000.MANDT`
Measurement point number	`OIUY3_TX_ROYHST.MANDT == OIU_PR_MP.MANDT` `OIUY3_TX_ROYHST.MP_NO == OIU_PR_MP.MP_NO`
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	`OIUY3_TX_ROYHST.OPERATOR_NO == OIUH_CM_BA.BA_BA_NO` `OIUY3_TX_ROYHST.OPERATOR_SEQ_NO == OIUH_CM_BA.BA_SEQ_NO` `OIUY3_TX_ROYHST.MANDT == OIUH_CM_BA.MANDT`
Full three char. product code (Major and Detail Products)	`OIUY3_TX_ROYHST.PDCD == OIUX3_PDCD.PDCD`
Measurement unit	`OIUY3_TX_ROYHST.MANDT == T006.MANDT` `OIUY3_TX_ROYHST.UOM == T006.MSEHI`
Volume type code	`OIUY3_TX_ROYHST.VL_TYPE_CD == OIU_PR_VLTYP.VL_TYPE_CD`
Joint venture Joint venture Company Code	`OIUY3_TX_ROYHST.MANDT == OIU_DO_JV.MANDT` `OIUY3_TX_ROYHST.VNAME == OIU_DO_JV.VNAME` `OIUY3_TX_ROYHST.BUKRS == OIU_DO_JV.BUKRS`
Well Completion Number Well ID number Well Completion Number	`OIUY3_TX_ROYHST.MANDT == OIU_PR_WC.MANDT` `OIUY3_TX_ROYHST.WL_NO == OIU_PR_WC.WL_NO` `OIUY3_TX_ROYHST.WC_NO == OIU_PR_WC.WC_NO`
Well ID number	`OIUY3_TX_ROYHST.MANDT == OIU_PR_WELL.MANDT` `OIUY3_TX_ROYHST.WL_NO == OIU_PR_WELL.WL_NO`