OIUX3_JEINTF

Tax Reporting - JE Interface Table | #transactional | Component: Tax Reporting
Column Name Description
MANDT FK Client
RUN_ID Run ID of Tax Report
OR_LVL_1_NO Company Name Code
ACCT_PERD_DT Accounting Period(YYYYMM01)
BTCH_NO Batch ID
LE_NO Journal Entry Line Number
Column Name Description
💲 Currency Key (T001.WAERS):
GR_AM Gross Amount (Value)
NET_TRANSP_AM Net Transportation Amount
NET_OTH_MK_AM Net Other Marketing Amount
TXN_VAL_AM Transaction Owner Amount
DED_RMB_AM Deduction/Reimbursement Amount
TAX_RMB_AM Tax Reimbursement Amount
Column Name Description
Column Name Description
Column Name Description
ACCT_CAT_NO Account category code Show values
BTCH_TYP_CD Batch Type Show values
Column Name Description Domain name
SYS_SRCE_CD PRA application component source CHAR2
TRANS_AM JE Transaction Amount OIUX3_SIGNED_DEC_11_2
TRANS_QY JE Transaction Quantity OIUH_DEC11_2
GR_QY Gross Quantity OIUH_DEC11_2
VL_TYPE_CD Volume Type CHAR2
PU_NO Purchaser Number CHAR6
PU_SEQ_NO Purchaser Sequence Number CHAR2
PRDR_NO Producer ID CHAR6
PRDR_SEQ_NO Producer Sequence Number CHAR2
RVRS_RSN_CD Reversal Reason Code CHAR2
UNIT_OF_MEAS_CD Unit of Measure Code CHAR3
CT_NO Contract ID CHAR6
CT_TYPE_CD Contract Type code CHAR2
DOI_PR_NO Property CHAR8
DOI_SEQ_NO Division of Interest (DOI) Number CHAR5
WL_NO Well ID Number CHAR6
WC_NO Well Completion ID CHAR2
ORIG_MP Originating Measurement Point Number CHAR6
SA_MP_NO Sales Measurement Point Number CHAR6
SA_DT Sales Date CHAR10
STATE_CD State Code CHAR2
UNIT_PR_NO Unit Property Number CHAR8
PROC_CO Processing Company code CHAR3
TAX_CD Tax Code CHAR2
REF_NO Reference Number CHAR10
NWK_NO Delivery Network number H_DELIVERY_NWK
SUBNWK_NO Subnetwork Number H_SUBDN_NO
CHV_RPT_CD Template Cost Center KOSTL
BTU_QY BTU Quantity OIUH_DEC7_3
PS_BASE_QY Pressure Base Quantity OIUH_DEC6_3
GRV_QY Gravity OIUH_DEC3_1
OWN_NO Owner Number CHAR6
OWN_SEQ_NO Owner Sequence Number CHAR2
OWN_INT_DECM_QY Owner Interest Decimal Quantity OIUH_DEC9_8
OWN_INT_TYPE_CD Owner Interest Type Code CHAR2
OWN_INT_SEQ_NO Owner Interest Sequence Number CHAR2
PAY_CD Pay Code CHAR2
OWN_BAL_DECM_QY Owner Disbursement (Balance) Decimal OIUH_DEC9_8
MMBTU_OVL_AM Owner MMBTU OIUH_DEC11_2
Master Data Relations Join Conditions
Account ID
  • Company Name Code
  • Account ID
Client OIUX3_JEINTF.MANDT == T000.MANDT
Full three char. product code (Major and Detail Products) OIUX3_JEINTF.PD_CD == OIUX3_PDCD.PDCD