/PRA/R6_INTSTG - Royalty 2.0 - WY - Royalty Transaction Interface (Staging)

Royalty 2.0 - WY - Royalty Transaction Interface (Staging) information is stored in SAP table /PRA/R6_INTSTG.
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_INTSTG

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
GUID	16-byte UID in 32 chars (hexadecimal)	X	SYSUUID_C32	CHAR	64
ACCT_PERIOD	Accounting Period		/PRA/ACCOUNTING_PERIOD	ACCP	12
ACCT_DOC_NO	Revenue Accounting Document Number		/PRA/ACCOUNTING_DOC_NO	CHAR	20
LINE_NO	Accounting Document Line Number		/PRA/ACCT_DOC_LINE_NUMBER	NUMC	16
.INCLUDE	ROIUY6_WY_ROYTXN_KEY			/PRA/S_R6_ROYTXN_KEY	0
.INCLUDE	ROIUY6_WY_REVTXN_KEY			ROIUY6_WY_REVTXN_KEY	0
BUKRS	Company Code		BUKRS	CHAR	8	OIU_CM_COMPC
SALES_DT	Sales Date / Month		OIU_SALE_DT	DATS	16
PDCD	Full three char. product code (Major and Detail Products)		OIU_FULL_PD_CD	CHAR	6	OIUX3_PDCD
WL_NO	Well ID number		OIU_WL_NO	CHAR	30	OIU_PR_WELL
WC_NO	Well Completion Number		OIU_WC_NO	CHAR	10	OIU_PR_WC
MP_NO	Measurement point number		OIU_MP_NO	CHAR	40	OIU_PR_MP
VNAME	Joint venture		JV_NAME	CHAR	12	OIU_DO_JV
DOI_NO	Division of interest (DOI)		OIU_DOI_NO	CHAR	10	OIU_DO_DI
DN_NO	Delivery network number		OIU_DN_NO	CHAR	40	OIU_PR_DN
CT_NO	Contract Number		OIU_CT_NO	CHAR	20	OIU_RV_CT
VL_TYPE_CD	Volume type code		OIU_VT_CD	CHAR	4	OIU_PR_VLTYP
OWNER_IDENTIFIER	Royalty 2.0 - Owner Identifier		/PRA/CM_OWNER_IDENTIFIER	CHAR	48
.INCLUDE	ROIUY6_WY_ROYTXN_NONKEY			ROIUY6_WY_ROYTXN_NONKEY	0
UNIT_VNAME	Joint venture		JV_NAME	CHAR	12	*
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
.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