/PRA/R3_OOSTXNA - Royalty 2.0 - TX GLO - Out of Statute Royalty Txns (Alloc)

Royalty 2.0 - TX GLO - Out of Statute Royalty Txns (Alloc) information is stored in SAP table /PRA/R3_OOSTXNA.
It is part of development package /PRA/ROYALTY_2.0 in software component IS-OIL-PRA. This development package consists of objects that can be grouped under "Royalty 2.0 remediation".

Fields for table /PRA/R3_OOSTXNA

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6T000
.INCLUDE/PRA/S_R3_ROYTXN_KEYX/PRA/S_R3_ROYTXN_KEY0
.INCLUDEROIUY3_TX_REVTXN_KEYXROIUY3_TX_REVTXN_KEY0
BUKRSCompany CodeXBUKRSCHAR8OIU_CM_COMPC
SALES_DTSales Date / MonthXOIU_SALE_DTDATS16
PDCDFull three char. product code (Major and Detail Products)XOIU_FULL_PD_CDCHAR6OIUX3_PDCD
WL_NOWell ID numberXOIU_WL_NOCHAR30OIU_PR_WELL
WC_NOWell Completion NumberXOIU_WC_NOCHAR10OIU_PR_WC
MP_NOMeasurement point numberXOIU_MP_NOCHAR40OIU_PR_MP
VNAMEJoint ventureXJV_NAMECHAR12OIU_DO_JV
DOI_NODivision of interest (DOI)XOIU_DOI_NOCHAR10OIU_DO_DI
DN_NODelivery network numberXOIU_DN_NOCHAR40OIU_PR_DN
CT_NOContract NumberXOIU_CT_NOCHAR20OIU_RV_CT
VL_TYPE_CDVolume type codeXOIU_VT_CDCHAR4OIU_PR_VLTYP
OWNER_IDENTIFIERRoyalty 2.0 - Owner IdentifierX/PRA/CM_OWNER_IDENTIFIERCHAR48
LEASE_IDENTIFIERRoyalty 2.0 - TX GLO/TAMU - Lease IdentifierXOIUY3_TX_LEASE_IDENTIFIERNUMC12
REV_BOOK_ADJ_INDRoyalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/AdjsXOIUY3_REV_BOOK_REVADJ_ADJ_INDCHAR2
.INCLUDE/PRA/S_R3_ROYTXN_NONKEY/PRA/S_R3_ROYTXN_NONKEY0
UNIT_VNAMEJoint ventureJV_NAMECHAR12OIU_DO_JV
ACCT_NOAccount IDOIUH_ACCTIDCHAR20
CHV_RPT_CDTemplate Cost CenterRKOSTLCHAR20*
UOMMeasurement unitOIU_MEAS_UUNIT6T006
PS_BASE_QYPressure Base QuantityOIUH_PRESSURE_BASEDEC4
GRV_QYGravityOIUH_GRAVITYDEC2
PAY_CDPay CodeOIUH_PAY_CODECHAR4
OWN_INT_DECM_QYRoyalty 2.0 - TX GLO - Owner NRIOIUY3_TX_OWNER_NRIDEC5
OWN_BAL_DECM_QYOwner Disbursement (Balance) DecimalOIUH_OWNER_DISBUR_DECIMALDEC5
PU_NOPurchaser Number/PRA/PURCHASERCHAR20*
AFFILIATED_SALERoyalty 2.0 - TX GLO - Affiliated Sale IndicatorOIUY3_TX_AFFILIATED_SALE_INDCHAR2
.INCLUDEROIUY3_TX_ROYTXN_NONKEY_NUMROIUY3_TX_ROYTXN_NONKEY_NUM0
GR_QYGross VolumeOIUX3_GROSS_VOLUMEDEC6
GR_AMGross ValueOIUX3_GROSS_VALUECURR6
TXN_VAL_AMRoyalty 2.0 - TX GLO - Owner Gross ValueOIUY3_TX_OWNER_GROSS_VALUECURR6
TRANS_AMJE Transaction AmountOIUX3_TRANS_AMTDEC6
TRANS_QYJE Transaction QuantityOIUH_TRANS_QUANTITYDEC6
MMBTU_OVL_AMOwner MMBTUOIUH_OWNER_MMBTUDEC6
PLT_VL_GRED_AMGross Plant Volume Reduction amountOIUH_GROSS_PLANT_VOLUME_RED_AMDEC6
PLT_VL_ORED_AMOwner Plant Volume Reduction amountOIUH_OWNER_PLANT_VOLUME_RED_AMDEC6
DED_RMB_AMDeduction/Reimbursement AmountOIUH_DED_REIMB_AMOUNTCURR6
NET_TRANSP_AMMarketing CostOIUX3_MARKETING_COSTCURR6
NET_OTH_MK_AMMarketing CostOIUX3_MARKETING_COSTCURR6
TAX_RMB_AMTax Reimbursement AmountOIUH_TAX_REIMBURSEMENT_AMTCURR6
TAX_AMTax amountOIUH_TAX_AMOUNTCURR6
BTU_QYBTU QuantityOIUH_BTU_QUANTITYDEC4
.INCLUDE/PRA/S_R3_ROYTXN_NONKEY_VAL/PRA/S_R3_ROYTXN_NONKEY_VAL0
ORIGINAL_REPORTRoyalty 2.0 - TX GLOTAMU - Original ReportOIUY3_TX_ORIGINAL_REPORTCHAR2
GAS_DISP_CODERoyalty 2.0 - TX GLO/TAMU - Royalty Gas Disposition CodeOIUY3_TX_GLO_ROY_GAS_DISP_CODENUMC4
MASTER_LEVELRoyalty 2.0 - TX GLO - Master LevelOIUY3_TX_MASTER_LEVELCHAR2
RRC_LEVELRoyalty 2.0 - TX GLO - RRC Master LevelOIUY3_TX_RRC_LEVELCHAR2
PURCHASER_IDRoyalty 2.0 - Texas GLO/TAMU - Purchaser IDOIUY3_TX_PURCHASER_IDNUMC22
OPERATOR_IDRoyalty 2.0 - TX GLO - Operator IDOIUY3_TX_OPERATOR_IDCHAR20
.INCLUDEROIUY3_TX_MASTER_SUBKEYROIUY3_TX_MASTER_SUBKEY0
GLO_LEASERoyalty 2.0 - TX GLO/TAMU LeaseOIUY3_TX_GLO_LEASENUMC12OIUY3_TX_LEASE
GLO_UNIT_NORoyalty 2.0 - Texas GLO/TAMU - Unit NumberOIUY3_TX_GLO_UNIT_NOCHAR10OIUY3_TX_UNIT
ROYALTY_DECIMALRoyalty 2.0 - Texas GLO - Royalty DecimalOIUY3_TX_ROYALTY_DECIMALDEC5
UNIT_VNAME_FLAGRoy 2.0 - Texas GLO/TAMU - Unit VentureOIUY3_TX_UNIT_VNAMECHAR2
.INCLUDEROIUY3_TX_MASTER_NONKEYROIUY3_TX_MASTER_NONKEY0
ALLOC_PERCENTRoyalty 2.0 - TX GLO/TAMU - Allocation PercentOIUY3_TX_ALLOCATION_PERCENTDEC5
TRACT_PART_FACTRoyalty 2.0 - Texas GLO - Tract Participation FactorOIUY3_TX_TRACT_PART_FACTORDEC5
.INCLUDE/PRA/S_R3_RRC_NONKEY/PRA/S_R3_RRC_NONKEY0
RRC_DISTRICT_NORoyalty 2.0 - TX GLO/TAMU - District NumberOIUY3_TX_GLO_DISTRICT_NOCHAR4
RRC_OIL_LEASE_NORoyalty 2.0 - TX GLO/TAMU - RRC Oil Lease NumberOIUY3_TX_GLO_RRC_OIL_LEASE_NOCHAR10
RRC_GAS_WELL_IDRoyalty 2.0 - TX GLO/TAMU - RRC Gas Well IDOIUY3_TX_GLO_RRC_GAS_WELL_IDCHAR12
RRC_DRILL_PERMITRoyalty 2.0 - TX GLO/TAMU - RRC Drilling PermitOIUY3_TX_GLO_RRC_DRILLING_PERMCHAR12
RRC_FIELD_NAMERoyalty 2.0 - TX GLO/TAMU - RRC Field NameOIUY3_TX_GLO_RRC_FIELD_NAMECHAR64
RRC_LEASE_NAMERoyalty 2.0 - TX GLO/TAMU - RRC Lease NameOIUY3_TX_GLO_RRC_LEASE_NAMECHAR64
PROP_ALIAS_NAMERoyalty 2.0 - TX GLO/TAMU - Property Alias NameOIUY3_TX_GLO_PROP_ALIAS_NAMECHAR64
OPERATOR_NOOperator Number/PRA/R3_OPERATOR_NOCHAR20
PAY_REPORT_FLAGRoyalty 2.0 - TX GLO/TAMU - Pay/Report FlagOIUY3_TX_PAY_REPORT_FLAGCHAR2
DOC_NOVal. document numberOIURV_DOCNRCHAR40*
DOC_YEARDocument yearOIU_DOC_YEARNUMC8
INTERFACE_FLRoyalty 2.0 - TX GLO - Interface FlagOIUY3_TX_INTERFACE_FLCHAR2
OPTION1CHAR2
OPTION2PPN FlagCHAR2
OPTION3CHAR2
REFERENCE_RUN_IDRun ID of Tax ReportOIUX3_RUN_IDNUMC20
.INCLUDEOIU_CREATIONOIU_CREATION0
OIU_CRUSERName of Person Responsible for Creating the ObjectERNAMCHAR24
OIU_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TZNTSTMPSDEC8
Privacy Policy