/PRA/R6_ROYSTG - Royalty 2.0 - WY - Royalty Transactions (Staging)

Royalty 2.0 - WY - Royalty Transactions (Staging) information is stored in SAP table /PRA/R6_ROYSTG.
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_ROYSTG

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
.INCLUDE	ROIUY6_WY_ROYTXN_KEY	X		/PRA/S_R6_ROYTXN_KEY	0
.INCLUDE	ROIUY6_WY_REVTXN_KEY	X		ROIUY6_WY_REVTXN_KEY	0
BUKRS	Company Code	X	BUKRS	CHAR	8	OIU_CM_COMPC
SALES_DT	Sales Date / Month	X	OIU_SALE_DT	DATS	16
PDCD	Full three char. product code (Major and Detail Products)	X	OIU_FULL_PD_CD	CHAR	6	OIUX3_PDCD
WL_NO	Well ID number	X	OIU_WL_NO	CHAR	30	OIU_PR_WELL
WC_NO	Well Completion Number	X	OIU_WC_NO	CHAR	10	OIU_PR_WC
MP_NO	Measurement point number	X	OIU_MP_NO	CHAR	40	OIU_PR_MP
VNAME	Joint venture	X	JV_NAME	CHAR	12	OIU_DO_JV
DOI_NO	Division of interest (DOI)	X	OIU_DOI_NO	CHAR	10	OIU_DO_DI
DN_NO	Delivery network number	X	OIU_DN_NO	CHAR	40	OIU_PR_DN
CT_NO	Contract Number	X	OIU_CT_NO	CHAR	20	OIU_RV_CT
VL_TYPE_CD	Volume type code	X	OIU_VT_CD	CHAR	4	OIU_PR_VLTYP
OWNER_IDENTIFIER	Royalty 2.0 - Owner Identifier	X	/PRA/CM_OWNER_IDENTIFIER	CHAR	48
REV_BOOK_ADJ_IND	Royalty 2.0 - WY - Reversal/Booking/Reversal Adjustment/Adjs	X	OIUY6_REV_BOOK_REVADJ_ADJ_IND	CHAR	2
.INCLUDE	ROIUY6_WY_ROYTXN_NONKEY			ROIUY6_WY_ROYTXN_NONKEY	0
UNIT_VNAME	Joint venture		JV_NAME	CHAR	12	OIU_DO_JV
ACCT_NO	Account ID		OIUH_ACCTID	CHAR	20
UOM	Measurement unit		OIU_MEAS_U	UNIT	6	T006
GR_QY	Gross Volume		OIUX3_GROSS_VOLUME	DEC	6
GR_AM	Gross Value		OIUX3_GROSS_VALUE	CURR	6
DED_RMB_AM	Deduction/Reimbursement Amount		OIUH_DED_REIMB_AMOUNT	CURR	6
TAX_RMB_AM	Tax Reimbursement Amount		OIUH_TAX_REIMBURSEMENT_AMT	CURR	6
NET_TRANSP_AM	Marketing Cost		OIUX3_MARKETING_COST	CURR	6
NET_OTH_MK_AM	Marketing Cost		OIUX3_MARKETING_COST	CURR	6
MKT_COST_01	Marketing Cost		OIUX3_MARKETING_COST	CURR	6
MKT_COST_02	Marketing Cost		OIUX3_MARKETING_COST	CURR	6
MKT_COST_03	Marketing Cost		OIUX3_MARKETING_COST	CURR	6
MKT_COST_04	Marketing Cost		OIUX3_MARKETING_COST	CURR	6
MKT_COST_05	Marketing Cost		OIUX3_MARKETING_COST	CURR	6
MKT_COST_06	Marketing Cost		OIUX3_MARKETING_COST	CURR	6
MKT_COST_07	Marketing Cost		OIUX3_MARKETING_COST	CURR	6
MKT_COST_08	Marketing Cost		OIUX3_MARKETING_COST	CURR	6
MKT_COST_09	Marketing Cost		OIUX3_MARKETING_COST	CURR	6
MKT_COST_10	Marketing Cost		OIUX3_MARKETING_COST	CURR	6
TXN_VAL_AM	Royalty 2.0 - WY - Owner Gross Value		OIUY6_WY_OWNER_GROSS_VALUE	CURR	6
OWN_INT_DECM_QY	Royalty 2.0 - Wyoming - Owner NRI		OIUY6_WY_OWNER_NRI	DEC	5
TRANS_AM	JE Transaction Amount		OIUX3_TRANS_AMT	DEC	6
TRANS_QY	JE Transaction Quantity		OIUH_TRANS_QUANTITY	DEC	6
BTU_QY	BTU Quantity		OIUH_BTU_QUANTITY	DEC	4
PS_BASE_QY	Pressure Base Quantity		OIUH_PRESSURE_BASE	DEC	4
GRV_QY	Gravity		OIUH_GRAVITY	DEC	2
PAY_CD	Pay Code		OIUH_PAY_CODE	CHAR	4
OWN_BAL_DECM_QY	Owner Disbursement (Balance) Decimal		OIUH_OWNER_DISBUR_DECIMAL	DEC	5
MMBTU_OVL_AM	Owner MMBTU		OIUH_OWNER_MMBTU	DEC	6
OPERATED_FL	Royalty 2.0 - WY - Operated Flag		OIUY6_OPERATED_FLAG	CHAR	2
OPERATOR_NAME	Royalty 2.0 - WY - Operator Name		OIUY6_WY_OPERATOR_NAME	CHAR	76
.INCLUDE	ROIUY6_WY_MASTER_SUBKEY			ROIUY6_WY_MASTER_SUBKEY	0
STATE_LEASE_NO	Royalty 2.0 - Wyoming - State Lease Number		OIUY6_WY_STATE_LEASE_NO	CHAR	30
UNIQUE_ID	Royalty 2.0 - Wyoming - PSA		OIUY6_WY_UNIQUE_IDENTIFIER	CHAR	40
.INCLUDE	ROIUY6_WY_MASTER_NONKEY			ROIUY6_WY_MASTER_NONKEY	0
REPORT_ONLY	Royalty 2.0 - WY - Report Only Flag		OIUY6_WY_REPORT_ONLY_FL	CHAR	2
OVERRIDE_FL	Royalty 2.0 - WY - Override Operated Flag		OIUY6_WY_OVERRIDE_OPERATED_FL	CHAR	2
TRACT_ALLOC_LSE	Royalty 2.0 - Wyoming - Tract Allocation to Lease		OIUY6_WY_TRACT_ALLOC_TO_LEASE	DEC	5
ROYALTY_RATE	Royalty 2.0 - Wyoming - Royalty Rate		OIUY6_WY_ROYALTY_RATE	DEC	5
ALLOC_PERCENT	Royalty 2.0 - Wyoming - Allocation Percent		OIUY6_WY_ALLOCATION_PERCENT	DEC	5
REFERENCE_FIELD	Royalty 2.0 - WY - Reference Field		OIUY6_WY_REFERENCE_FIELD	CHAR	70
ALTERNATE_PSA	Royalty 2.0 - Wyoming - Alternate PSA		OIUY6_WY_ALTERNATE_PSA	CHAR	40
CTRACT_ALLOC_LSE	Royalty 2.0 - Wyoming - Calculated Tract Allocation to Lease		OIUY6_WY_CALC_TRACT_ALLOC_LSE	DEC	5
MASTER_LEVEL	Royalty 2.0 - WY - Master Level		OIUY6_WY_MASTER_LEVEL	CHAR	2
WY_PDCD	Royalty 2.0 - Wyoming - Product Code		OIUY6_WY_PRODUCT_CODE	NUMC	6
PAYER_CODE	Royalty 2.0 - Wyoming - Payer Code		OIUY6_WY_PAYER_CODE	NUMC	8
ORIGINAL_REPORT	Royalty 2.0 - WY - Original Report		OIUY6_WY_ORIGINAL_REPORT	CHAR	2
DOC_NO	Val. document number		OIURV_DOCNR	CHAR	40	*
DOC_YEAR	Document year		OIU_DOC_YEAR	NUMC	8
INTERFACE_FL	Royalty 2.0 - WY - Interface Flag		OIUY6_WY_INTERFACE_FL	CHAR	2
OPTION1				CHAR	2
OPTION2	PPN Flag			CHAR	2
OPTION3				CHAR	2
REJ_SUSP_IND	Rejection-Suspension Status		OIUX3_REJECT_SUSPEND_IND	CHAR	2
REJ_CD	Royalty 2.0 - WY - Reject Code		OIUY6_WY_REJECT_CODE	CHAR	4	OIUY6_WY_REJ
.INCLUDE	OIU_CREATION			OIU_CREATION	0
OIU_CRUSER	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
OIU_TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TZNTSTMPS	DEC	8