OIUX3_JEINTF - Tax Reporting - JE Interface Table

Tax Reporting - JE Interface Table information is stored in SAP table OIUX3_JEINTF.
It is part of development package OIU_X3 in software component IS-OIL-PRA-REP-TAX. This development package consists of objects that can be grouped under "Tax 2.0".

Fields for table OIUX3_JEINTF

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
.INCLUDE		X		ROIUX3_JEINTF_KEY	0
RUN_ID	Run ID of Tax Report	X	OIUX3_RUN_ID	NUMC	20
OR_LVL_1_NO	Company Name Code	X	OIUH_COMPANY	CHAR	6
ACCT_PERD_DT	Accounting Period(YYYYMM01)	X	OIUH_ACCOUNTING_PERIOD8	CHAR	16
BTCH_NO	Batch ID	X	OIUH_BATCH_ID	CHAR	8
LE_NO	Journal Entry Line Number	X	OIUH_JELINENO	CHAR	16
.INCLUDE				ROIUX3_JEINTF_NON_KEY	0
ACCT_NO	Account ID		OIUH_ACCTID	CHAR	20	OIUH_RV_COA
ACCT_CAT_NO	Account category code		OIU_ACCT_CAT_CD	CHAR	8
BTCH_TYP_CD	Batch Type		OIUH_BATCH_TYPE	CHAR	4
SYS_SRCE_CD	PRA application component source		OIUH_SUB_SYSTEM_SOURCE	CHAR	4
TRANS_AM	JE Transaction Amount		OIUX3_TRANS_AMT	DEC	6
TRANS_QY	JE Transaction Quantity		OIUH_TRANS_QUANTITY	DEC	6
GR_AM	Gross Amount (Value)		OIUH_GROSS_AMOUNT	CURR	6
GR_QY	Gross Quantity		OIUH_GROSS_QTY	DEC	6
PD_CD	Full three char. product code (Major and Detail Products)		OIU_FULL_PD_CD	CHAR	6	OIUX3_PDCD
VL_TYPE_CD	Volume Type		OIUH_VOLTYPE	CHAR	4
PU_NO	Purchaser Number		OIUH_PU_NO	CHAR	12
PU_SEQ_NO	Purchaser Sequence Number		OIUH_PURCHASER_SEQUENCE_NUMBER	CHAR	4
PRDR_NO	Producer ID		OIUH_PRODUCER	CHAR	12
PRDR_SEQ_NO	Producer Sequence Number		OIUH_PRODUCER_SEQUENCE_NUMBER	CHAR	4
RVRS_RSN_CD	Reversal Reason Code		OIUH_RVRS_REASON_CODE	CHAR	4
UNIT_OF_MEAS_CD	Unit of Measure Code		OIUH_UNIT_OF_MEASURE	CHAR	6
CT_NO	Contract ID		OIUH_CONTRACT_ID	CHAR	12
CT_TYPE_CD	Contract Type code		OIUH_CONTRACT_TYPE_CODE	CHAR	4
DOI_PR_NO	Property		OIUH_PR_NO	CHAR	16
DOI_SEQ_NO	Division of Interest (DOI) Number		OIUH_DOI_NO	CHAR	10
WL_NO	Well ID Number		OIUH_WELL_NO	CHAR	12
WC_NO	Well Completion ID		OIUH_WELL_COMPLETION_ID	CHAR	4
ORIG_MP	Originating Measurement Point Number		OIUH_ORIGINATING_MP_NO	CHAR	12
SA_MP_NO	Sales Measurement Point Number		OIUH_SALES_MP_NUMBER	CHAR	12
SA_DT	Sales Date		OIUH_SALES_DATE	CHAR	20
STATE_CD	State Code		OIUH_STATE_CODE	CHAR	4
UNIT_PR_NO	Unit Property Number		OIUH_UNIT_PROPERTY_NUMBER	CHAR	16
PROC_CO	Processing Company code		OIUH_PROCESSING_COMPANY_CODE	CHAR	6
TAX_CD	Tax Code		OIUH_TAX_CODE	CHAR	4
REF_NO	Reference Number		OIUH_REFERENCE_NUMBER	CHAR	20
NWK_NO	Delivery Network number		OIUH_DN_NO	CHAR	8
SUBNWK_NO	Subnetwork Number		OIUH_SUBNWK_NO	CHAR	8
CHV_RPT_CD	Template Cost Center		RKOSTL	CHAR	20	*
.INCLUDE				ROIUX3_JEINTF_NON_KEY2	0
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
OWN_NO	Owner Number		OIUH_OWNER	CHAR	12
OWN_SEQ_NO	Owner Sequence Number		OIUH_OWNER_SEQUENCE_NUMBER	CHAR	4
OWN_INT_DECM_QY	Owner Interest Decimal Quantity		OIUH_OWN_INTEREST_DECIMAL_QTY	DEC	5
OWN_INT_TYPE_CD	Owner Interest Type Code		OIUH_OWN_INTEREST_TYPE_CODE	CHAR	4
OWN_INT_SEQ_NO	Owner Interest Sequence Number		OIUH_OWN_INTEREST_SEQ_NUMBER	CHAR	4
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
NET_TRANSP_AM	Net Transportation Amount		OIUH_TRANSPORTATION_AMT	CURR	6
NET_OTH_MK_AM	Net Other Marketing Amount		OIUH_NET_OTH_MARKETING_AMOUNT	CURR	6
TXN_VAL_AM	Transaction Owner Amount		OIUH_TRAN_OWNER_AMOUNT	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