/PRA/R6_PRDT - Royalty 2.0 - WY - Royalty PRA Details

Royalty 2.0 - WY - Royalty PRA Details information is stored in SAP table /PRA/R6_PRDT.
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/R6_PRDT

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6T000
RUN_IDRun ID of Tax ReportXOIUX3_RUN_IDNUMC20
.INCLUDEROIUY6_WY_ROYTXN_KEYX/PRA/S_R6_ROYTXN_KEY0
.INCLUDEROIUY6_WY_REVTXN_KEYXROIUY6_WY_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
REV_BOOK_ADJ_INDRoyalty 2.0 - WY - Reversal/Booking/Reversal Adjustment/AdjsXOIUY6_REV_BOOK_REVADJ_ADJ_INDCHAR2
OUT_OF_STATUTEOut of StatuteOIUX3_OUT_OF_STATUTECHAR2
.INCLUDEROIUY6_WY_ROYTXN_NONKEYROIUY6_WY_ROYTXN_NONKEY0
UNIT_VNAMEJoint ventureJV_NAMECHAR12*
ACCT_NOAccount IDOIUH_ACCTIDCHAR20
UOMMeasurement unitOIU_MEAS_UUNIT6T006
GR_QYGross VolumeOIUX3_GROSS_VOLUMEDEC6
GR_AMGross ValueOIUX3_GROSS_VALUECURR6
DED_RMB_AMDeduction/Reimbursement AmountOIUH_DED_REIMB_AMOUNTCURR6
TAX_RMB_AMTax Reimbursement AmountOIUH_TAX_REIMBURSEMENT_AMTCURR6
NET_TRANSP_AMMarketing CostOIUX3_MARKETING_COSTCURR6
NET_OTH_MK_AMMarketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_01Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_02Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_03Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_04Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_05Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_06Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_07Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_08Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_09Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_10Marketing CostOIUX3_MARKETING_COSTCURR6
TXN_VAL_AMRoyalty 2.0 - WY - Owner Gross ValueOIUY6_WY_OWNER_GROSS_VALUECURR6
OWN_INT_DECM_QYRoyalty 2.0 - Wyoming - Owner NRIOIUY6_WY_OWNER_NRIDEC5
TRANS_AMJE Transaction AmountOIUX3_TRANS_AMTDEC6
TRANS_QYJE Transaction QuantityOIUH_TRANS_QUANTITYDEC6
BTU_QYBTU QuantityOIUH_BTU_QUANTITYDEC4
PS_BASE_QYPressure Base QuantityOIUH_PRESSURE_BASEDEC4
GRV_QYGravityOIUH_GRAVITYDEC2
PAY_CDPay CodeOIUH_PAY_CODECHAR4
OWN_BAL_DECM_QYOwner Disbursement (Balance) DecimalOIUH_OWNER_DISBUR_DECIMALDEC5
MMBTU_OVL_AMOwner MMBTUOIUH_OWNER_MMBTUDEC6
OPERATED_FLRoyalty 2.0 - WY - Operated FlagOIUY6_OPERATED_FLAGCHAR2
OPERATOR_NAMERoyalty 2.0 - WY - Operator NameOIUY6_WY_OPERATOR_NAMECHAR76
.INCLUDEROIUY6_WY_MASTER_SUBKEYROIUY6_WY_MASTER_SUBKEY0
STATE_LEASE_NORoyalty 2.0 - Wyoming - State Lease NumberOIUY6_WY_STATE_LEASE_NOCHAR30
UNIQUE_IDRoyalty 2.0 - Wyoming - PSAOIUY6_WY_UNIQUE_IDENTIFIERCHAR40
.INCLUDEROIUY6_WY_MASTER_NONKEYROIUY6_WY_MASTER_NONKEY0
REPORT_ONLYRoyalty 2.0 - WY - Report Only FlagOIUY6_WY_REPORT_ONLY_FLCHAR2
OVERRIDE_FLRoyalty 2.0 - WY - Override Operated FlagOIUY6_WY_OVERRIDE_OPERATED_FLCHAR2
TRACT_ALLOC_LSERoyalty 2.0 - Wyoming - Tract Allocation to LeaseOIUY6_WY_TRACT_ALLOC_TO_LEASEDEC5
ROYALTY_RATERoyalty 2.0 - Wyoming - Royalty RateOIUY6_WY_ROYALTY_RATEDEC5
ALLOC_PERCENTRoyalty 2.0 - Wyoming - Allocation PercentOIUY6_WY_ALLOCATION_PERCENTDEC5
REFERENCE_FIELDRoyalty 2.0 - WY - Reference FieldOIUY6_WY_REFERENCE_FIELDCHAR70
ALTERNATE_PSARoyalty 2.0 - Wyoming - Alternate PSAOIUY6_WY_ALTERNATE_PSACHAR40
CTRACT_ALLOC_LSERoyalty 2.0 - Wyoming - Calculated Tract Allocation to LeaseOIUY6_WY_CALC_TRACT_ALLOC_LSEDEC5
MASTER_LEVELRoyalty 2.0 - WY - Master LevelOIUY6_WY_MASTER_LEVELCHAR2
WY_PDCDRoyalty 2.0 - Wyoming - Product CodeOIUY6_WY_PRODUCT_CODENUMC6
PAYER_CODERoyalty 2.0 - Wyoming - Payer CodeOIUY6_WY_PAYER_CODENUMC8
ORIGINAL_REPORTRoyalty 2.0 - WY - Original ReportOIUY6_WY_ORIGINAL_REPORTCHAR2
DOC_NOVal. document numberOIURV_DOCNRCHAR40*
DOC_YEARDocument yearOIU_DOC_YEARNUMC8
INTERFACE_FLRoyalty 2.0 - WY - Interface FlagOIUY6_WY_INTERFACE_FLCHAR2
OPTION1CHAR2
OPTION2PPN FlagCHAR2
OPTION3CHAR2
.INCLUDEOIU_CREATIONOIU_CREATION0
OIU_CRUSERName of Person Responsible for Creating the ObjectERNAMCHAR24
OIU_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TZNTSTMPSDEC8
Privacy Policy