OIUE2_JEINTF - Proc 2.0 - JE Interface Table

Proc 2.0 - JE Interface Table information is stored in SAP table OIUE2_JEINTF.
It is part of development package OIU_E2 in software component IS-OIL-PRA-REV. This development package consists of objects that can be grouped under "Proc 2.0 - Escheat / Wyoming Escrow".

Fields for table OIUE2_JEINTF

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6T000
.INCLUDEROIUE2_JEINTF_KEYXROIUE2_JEINTF_KEY0
RUN_IDProc 2.0 - Run IDXOIUE2_RUN_IDNUMC20
OR_LVL_1_NOCompany Name CodeXOIUH_COMPANYCHAR6
ACCT_PERD_DTAccounting Period(YYYYMM01)XOIUH_ACCOUNTING_PERIOD8CHAR16
BTCH_NOBatch IDXOIUH_BATCH_IDCHAR8
LE_NOJournal Entry Line NumberXOIUH_JELINENOCHAR16
.INCLUDEROIUE2_JEINTF_NON_KEYROIUE2_JEINTF_NON_KEY0
REC_TYPEPRA Journal Entry Record Type (0=Control, 1= Line item)OIUH_RECORD_TYPECHAR2
VOU_NOVoucher NumberOIUH_VOUCHER_NUMBERCHAR12
REJ_FLLine item Reject Flag (Y=Yes, N=No)OIUH_REJECT_FLAGCHAR2
ACCT_NOAccount IDOIUH_ACCTIDCHAR20OIUH_RV_COA
ACCT_TYPE_CDAccount TypeOIUH_ACCTYPECHAR4
ACCT_CAT_NOAccount category codeOIU_ACCT_CAT_CDCHAR8
BTCH_TYP_CDBatch TypeOIUH_BATCH_TYPECHAR4
LE_PRCS_ST_CDJournal Entry Line StatusOIUH_JELINESTCHAR2
SYS_SRCE_CDPRA application component sourceOIUH_SUB_SYSTEM_SOURCECHAR4
TRANS_AMJE Transaction AmountOIUH_TRANS_AMTCURR6
TRANS_QYJE Transaction QuantityOIUH_TRANS_QUANTITYDEC6
GR_AMGross Amount (Value)OIUH_GROSS_AMOUNTCURR6
GR_QYGross QuantityOIUH_GROSS_QTYDEC6
PD_CDProduct CodeOIUH_PRODUCT_CODECHAR6*
CK_NOCheck NumberOIUH_CHECK_NUMBERCHAR20
CK_DTCheck DateOIUH_CHECKDATECHAR20
VL_TYPE_CDVolume TypeOIUH_VOLTYPECHAR4
VL_CLASS_CDVolume Class CodeOIUH_VOL_CLASS_CODECHAR2
VL_SRCE_CDVolume source codeOIUH_VOL_SOURCE_CODECHAR2
VL_FRQ_CDVolume Frequency codeOIUH_VOL_FREQUENCY_CODECHAR2
BTU_QYBTU QuantityOIUH_BTU_QUANTITYDEC4
MMBTU_DET_CDMMBTU Determination CodeOIUH_MMBTU_DET_CODECHAR2
PS_BASE_QYPressure Base QuantityOIUH_PRESSURE_BASEDEC4
GRV_QYGravityOIUH_GRAVITYDEC2
OWN_NOOwner NumberOIUH_OWNERCHAR12
OWN_SEQ_NOOwner Sequence NumberOIUH_OWNER_SEQUENCE_NUMBERCHAR4
PU_NOPurchaser NumberOIUH_PU_NOCHAR12
PU_SEQ_NOPurchaser Sequence NumberOIUH_PURCHASER_SEQUENCE_NUMBERCHAR4
PRDR_NOProducer IDOIUH_PRODUCERCHAR12
PRDR_SEQ_NOProducer Sequence NumberOIUH_PRODUCER_SEQUENCE_NUMBERCHAR4
OWN_INT_DECM_QYOwner Interest Decimal QuantityOIUH_OWN_INTEREST_DECIMAL_QTYDEC5
OWN_INT_TYPE_CDOwner Interest Type CodeOIUH_OWN_INTEREST_TYPE_CODECHAR4
OWN_INT_SEQ_NOOwner Interest Sequence NumberOIUH_OWN_INTEREST_SEQ_NUMBERCHAR4
RVRS_RSN_CDReversal Reason CodeOIUH_RVRS_REASON_CODECHAR4
UNIT_OF_MEAS_CDUnit of Measure CodeOIUH_UNIT_OF_MEASURECHAR6
CASH_RCPT_DTCash Receipt DateOIUH_CASH_RECEIPT_DATECHAR20
SUS_RSN_CDSuspense Reason CodeOIUH_SUSPENSE_REASON_CODECHAR4
CT_NOContract IDOIUH_CONTRACT_IDCHAR12
CT_TYPE_CDContract Type codeOIUH_CONTRACT_TYPE_CODECHAR4
DOI_PR_NOPropertyOIUH_PR_NOCHAR16
DOI_SEQ_NODivision of Interest (DOI) NumberOIUH_DOI_NOCHAR10
SECT_PR_NOSection Property NumberOIUH_SECTION_PROP_NUMBERCHAR16
SECT_SEQ_NOSection Sequence NumberOIUH_SECTION_SEQ_NUMBERCHAR10
TRACE_CO_NOCompany Name CodeOIUH_COMPANYCHAR6
TRACE_APRD_DTAccounting Period(YYYYMM01)OIUH_ACCOUNTING_PERIOD8CHAR16
TRACE_ACCT_NOAccount IDOIUH_ACCTIDCHAR20
TRACE_BTCH_NOBatch IDOIUH_BATCH_IDCHAR8
TRACE_VOUC_NOVoucher NumberOIUH_VOUCHER_NUMBERCHAR12
TRACE_LE_NOJournal Entry Line NumberOIUH_JELINENOCHAR16
TRACE_BTCH_TYBatch TypeOIUH_BATCH_TYPECHAR4
WL_NOWell ID NumberOIUH_WELL_NOCHAR12
WC_NOWell Completion IDOIUH_WELL_COMPLETION_IDCHAR4
ORIG_MPOriginating Measurement Point NumberOIUH_ORIGINATING_MP_NOCHAR12
ORIG_MP_TYPEOriginating Measurement Point TypeOIUH_ORIGINATING_MP_TYPECHAR4
DED_RMB_AMDeduction/Reimbursement AmountOIUH_DED_REIMB_AMOUNTCURR6
DED_GR_RMB_AMGross Deduction/Reimbursement amountOIUH_DED_GR_REIMB_AMOUNTCURR6
TAX_1_AMTax amountOIUH_TAX_AMOUNTCURR6
TAX_2_AMTax amountOIUH_TAX_AMOUNTCURR6
TAX_3_AMTax amountOIUH_TAX_AMOUNTCURR6
TAX_4_AMTax amountOIUH_TAX_AMOUNTCURR6
TAX_5_AMTax amountOIUH_TAX_AMOUNTCURR6
TAX_6_AMTax amountOIUH_TAX_AMOUNTCURR6
TAX_7_AMTax amountOIUH_TAX_AMOUNTCURR6
TAX_8_AMTax amountOIUH_TAX_AMOUNTCURR6
TAX_9_AMTax amountOIUH_TAX_AMOUNTCURR6
TAX_10_AMTax amountOIUH_TAX_AMOUNTCURR6
TAX_RMB_AMTax Reimbursement AmountOIUH_TAX_REIMBURSEMENT_AMTCURR6
TAX_GR_RMB_AMGross Tax Reimbursement AmountOIUH_GROSS_TAX_REIMB_AMTCURR6
INV_NOInvoice NumberOIUH_INVOICE_NUMBERCHAR12
INV_DTInvoice DateOIUH_INVOICE_DATECHAR20
INV_TYPE_CDInvoice Type codeOIUH_INVOICE_TYPE_CODECHAR4
PAY_CDPay CodeOIUH_PAY_CODECHAR4
SA_MP_NOSales Measurement Point NumberOIUH_SALES_MP_NUMBERCHAR12
SA_DTSales DateOIUH_SALES_DATECHAR20
STATE_CDState CodeOIUH_STATE_CODECHAR4
TAX_AUTH_NOTax Authority NumberOIUH_TAX_AUTHORITY_NUMBERCHAR12
TAX_AUTH_SEQ_NOTax Authority Sequence NumberOIUH_TAX_AUTHORITY_SEQ_NUMBERCHAR4
OWN_BAL_DECM_QYOwner Disbursement (Balance) DecimalOIUH_OWNER_DISBUR_DECIMALDEC5
PR_TYPE_CDProperty Type CodeOIUH_PROPERTY_TYPE_CODECHAR4
OP_NON_OP_FLOperated FlagOIUH_OPERATED_FLAGCHAR2
PU_PR_NOPurchaser Property NumberOIUH_PURCHASER_PROPERTY_NUMBERCHAR36
PU_PD_CDPurchaser Product CodeOIUH_PURCHASER_PRODUCT_CODECHAR6
UNIT_PR_NOUnit Property NumberOIUH_UNIT_PROPERTY_NUMBERCHAR16
ARMT_LVL_1_CDA/R Remittance Level 1 codeOIUH_AR_REMIT_LVL_1_CODECHAR16
ARMT_LVL_2_CDA/R Remittance Level 2 codeOIUH_AR_REMIT_LVL_2_CODECHAR10
TRANS_DEDescriptive Text for financial transactionOIUH_DESCRIPTIONCHAR120
NET_TRANSP_AMNet Transportation AmountOIUH_TRANSPORTATION_AMTCURR6
NET_OTH_MK_AMNet Other Marketing AmountOIUH_NET_OTH_MARKETING_AMOUNTCURR6
GR_TRANSP_AMGross Transportation AmountOIUH_GROSS_TRANP_AMOUNTCURR6
GR_OTH_MK_AMGross Other Marketing AmountOIUH_GROSS_OTH_MARKETING_AMTCURR6
OTH_DED_01_AMOther Deductions AmountOIUH_OTHER_DEDUCTION_AMOUNTCURR6
OTH_DED_02_AMOther Deductions AmountOIUH_OTHER_DEDUCTION_AMOUNTCURR6
OTH_DED_03_AMOther Deductions AmountOIUH_OTHER_DEDUCTION_AMOUNTCURR6
OTH_DED_04_AMOther Deductions AmountOIUH_OTHER_DEDUCTION_AMOUNTCURR6
OTH_DED_05_AMOther Deductions AmountOIUH_OTHER_DEDUCTION_AMOUNTCURR6
OTH_DED_06_AMOther Deductions AmountOIUH_OTHER_DEDUCTION_AMOUNTCURR6
OTH_DED_07_AMOther Deductions AmountOIUH_OTHER_DEDUCTION_AMOUNTCURR6
OTH_DED_08_AMOther Deductions AmountOIUH_OTHER_DEDUCTION_AMOUNTCURR6
OTH_DED_09_AMOther Deductions AmountOIUH_OTHER_DEDUCTION_AMOUNTCURR6
OTH_DED_10_AMOther Deductions AmountOIUH_OTHER_DEDUCTION_AMOUNTCURR6
OTH_DED_11_AMOther Deductions AmountOIUH_OTHER_DEDUCTION_AMOUNTCURR6
OTH_DED_12_AMOther Deductions AmountOIUH_OTHER_DEDUCTION_AMOUNTCURR6
OTH_DED_13_AMOther Deductions AmountOIUH_OTHER_DEDUCTION_AMOUNTCURR6
OTH_DED_14_AMOther Deductions AmountOIUH_OTHER_DEDUCTION_AMOUNTCURR6
OTH_DED_15_AMOther Deductions AmountOIUH_OTHER_DEDUCTION_AMOUNTCURR6
OTH_DED_16_AMOther Deductions AmountOIUH_OTHER_DEDUCTION_AMOUNTCURR6
OTH_DED_17_AMOther Deductions AmountOIUH_OTHER_DEDUCTION_AMOUNTCURR6
OTH_DED_18_AMOther Deductions AmountOIUH_OTHER_DEDUCTION_AMOUNTCURR6
PROC_COProcessing Company codeOIUH_PROCESSING_COMPANY_CODECHAR6
AES_FLActual / Entitled / Settlement CodeOIU_AES_CDCHAR2
TAX_CDTax CodeOIUH_TAX_CODECHAR4
GRP_GROUP_NOGroup NumberOIUH_GROUP_NUMBERCHAR16
INT_SYMBOLInterest SymbolOIUH_INTEREST_SYMBOLCHAR4
TXN_VAL_AMTransaction Owner AmountOIUH_TRAN_OWNER_AMOUNTCURR6
TXN_DTTransaction DateOIUH_TRANS_DATECHAR20
GAS_PLANT_NOGas Plant Property NumberOIUH_GAS_PLANT_PROPERTY_NUMBERCHAR16
GAS_PLANT_DOIGas Plant DOI NumberOIUH_GAS_PLANT_DOI_NUMBERCHAR10
REF_NOReference NumberOIUH_REFERENCE_NUMBERCHAR20
SELLER_NOSeller NumberOIUH_SELLER_NUMBERCHAR12
SELLER_SEQ_NOSeller Sequence NumberOIUH_SELLER_SEQUENCE_NUMBERCHAR4
NWK_NODelivery Network numberOIUH_DN_NOCHAR8
SUBNWK_NOSubnetwork NumberOIUH_SUBNWK_NOCHAR8
AUDIT_BTCH_NOAudit Batch NumberOIUH_AUDIT_BATCH_NUMBERCHAR8
JDI_PR_NOJDI Expense Property NumberOIUH_JDI_PROPERTY_NUMBERCHAR16
JDI_NOJDI Expense Property Sequence NumberOIUH_JDI_PROPERTY_SEQ_NUMBERCHAR10
DI_PR_NOExpense Property NumberOIUH_DI_PROPERTY_NUMBERCHAR16
DI_NOExpense Property Sequence NumberOIUH_DI_PROPERTY_SEQ_NUMBERCHAR10
REMT_NORemitter IDOIUH_REMITTER_IDCHAR12
REMT_SEQ_NORemitter Sequence NumberOIUH_REMITTER_SEQUENCE_NUMBERCHAR4
RCV_GL_WL_NOOff Lease Well NumberOIUH_OFF_LEASE_WELL_NUMBERCHAR12
RCV_GL_WC_NOOff Lease Well Completion NumberOIUH_OFF_LEASE_WELL_COMPLETIONCHAR4
REL_CT_NOREL Contract NumberOIUH_REL_CONTRACT_NUMBERCHAR12
PLT_VL_GRED_AMGross Plant Volume Reduction amountOIUH_GROSS_PLANT_VOLUME_RED_AMDEC6
PLT_VL_ORED_AMOwner Plant Volume Reduction amountOIUH_OWNER_PLANT_VOLUME_RED_AMDEC6
INT_PAID_FLInterest Paid FlagOIUH_INTEREST_PAID_FLAGCHAR2
MMBTU_OVL_AMOwner MMBTUOIUH_OWNER_MMBTUDEC6
MMBTU_GRVL_AMMMBTU Gross VolumeOIUH_MMBTUDEC6
PHASE_NOPhase numberOIUVL_PHASE_NOCHAR2
PD_CD_SUM_INDProduct Code Summarize IndicatorOIUH_PRODUCT_CODE_SUMMARIZE_INCHAR2
VL_LEVEL_CDValuation Level CodeOIUH_VALUATION_LEVEL_CODECHAR4
CHV_RPT_CDTemplate Cost CenterRKOSTLCHAR20*
GR_TAX_1_AMGross Tax AmountOIUH_GROSS_TAX_AMOUNTCURR7
GR_TAX_2_AMGross Tax AmountOIUH_GROSS_TAX_AMOUNTCURR7
GR_TAX_3_AMGross Tax AmountOIUH_GROSS_TAX_AMOUNTCURR7
GR_TAX_4_AMGross Tax AmountOIUH_GROSS_TAX_AMOUNTCURR7
GR_TAX_5_AMGross Tax AmountOIUH_GROSS_TAX_AMOUNTCURR7
GR_TAX_6_AMGross Tax AmountOIUH_GROSS_TAX_AMOUNTCURR7
GR_TAX_7_AMGross Tax AmountOIUH_GROSS_TAX_AMOUNTCURR7
GR_TAX_8_AMGross Tax AmountOIUH_GROSS_TAX_AMOUNTCURR7
GR_TAX_9_AMGross Tax AmountOIUH_GROSS_TAX_AMOUNTCURR7
GR_TAX_10_AMGross Tax AmountOIUH_GROSS_TAX_AMOUNTCURR7
SPEC_PYMNT_CDSpecial Payment CodeOIUH_SPECIAL_PAYMENT_CODECHAR2
LGND_CDLegend CodeOIUH_LEGEND_CODECHAR4
RBUR_DECRoyalty Burden DecimalOIUH_ROYALTY_BURDEN_DECIMALDEC5
ESCH_FLEscheat FlagOIUH_ESCHEAT_FLAGCHAR2
CMT_SYS_NOComment System NumberOIUH_COMMENT_SYSTEM_NUMBERDEC10
OVRD_OWN_CDOverride Owner codeOIU_OVRD_OWN_CDCHAR4
BRD_CDBrand CodeOIUH_BRAND_CODECHAR8
RCPTN_PT_NOReception Point NumberOIUH_RECEPTION_POINT_NUMBERCHAR12
TRNSP_NOTransporter NumberOIUH_TRANSPORTER_NUMBERCHAR12
TRNSP_SEQ_NOTransporter Sequence NumberOIUH_TRANSPORTER_SEQ_NUMBERCHAR4
OR_LVL_2_NORegion Code (Org. Lvl 2)OIUH_REGION_CODECHAR2
MK_TYPE_NOMarketing Type NumberOIUH_MARKETING_TYPE_NUMBERCHAR4
ORIG_PR_NOOriginating Property NumberOIUH_ORGINATING_PROPERTY_NOCHAR16
INJ_DTInjection DateOIUH_INJECTION_DATECHAR20
GR_APC_RMBGross APC ReimbursementOIUH_GROSS_APC_REIMBURSEMENTCURR7
NET_APC_RMBNet APC Reimbursement AmountOIUH_NET_APC_REIMBURSEMENTCURR7
JI_OWN_NOJI Owner NumberOIUH_JI_OWNER_NUMBERCHAR12
JI_OWN_SEQ_NOJI Owner Sequence NumberOIUH_JI_OWNER_SEQUENCE_NUMBERCHAR4
DEAL_I_NODeal I NumberOIUH_DEAL_I_NUMBERCHAR24
CUSA_TRSPK_NOCUSA Transportation NumberOIUH_CUSA_TRANSPORTATION_NOCHAR16
VER_NOVersion NumberOIUH_TT_VER_NODEC3
USER_IDUser IDOIUH_USER_IDCHAR16
TIMESTAMPTime StampOIUH_TT_TIMESTAMPCHAR28
ERROR_1_CDJE posting Validation Error CodeOIUH_ERROR_CODECHAR10
ERROR_2_CDJE posting Validation Error CodeOIUH_ERROR_CODECHAR10
ERROR_3_CDJE posting Validation Error CodeOIUH_ERROR_CODECHAR10
ERROR_4_CDJE posting Validation Error CodeOIUH_ERROR_CODECHAR10
ERROR_5_CDJE posting Validation Error CodeOIUH_ERROR_CODECHAR10
.INCLUDEOIU_MKTG_DTLOIU_MKTG_DTL0
O_INT_1_AMOwner internal mkt amt 1OIU_O_INT_1_AMCURR6
O_INT_2_AMOwner internal mkt amt 2OIU_O_INT_2_AMCURR6
O_INT_3_AMOwner internal mkt amt 3OIU_O_INT_3_AMCURR6
O_INT_4_AMOwner internal mkt amt 4OIU_O_INT_4_AMCURR6
O_INT_5_AMOwner internal mkt amt 5OIU_O_INT_5_AMCURR6
O_INT_6_AMOwner internal mkt amt 6OIU_O_INT_6_AMCURR6
O_INT_7_AMOwner internal mkt amt 7OIU_O_INT_7_AMCURR6
O_INT_8_AMOwner internal mkt amt 8OIU_O_INT_8_AMCURR6
O_INT_9_AMOwner internal mkt amt 9OIU_O_INT_9_AMCURR6
O_INT_10_AMOwner internal mkt amt10OIU_O_INT_10_AMCURR6
O_EXT_1_AMOwner external mkt amt 1OIU_O_EXT_1_AMCURR6
O_EXT_2_AMOwner external mkt amt 2OIU_O_EXT_2_AMCURR6
O_EXT_3_AMOwner external mkt amt 3OIU_O_EXT_3_AMCURR6
O_EXT_4_AMOwner external mkt amt 4OIU_O_EXT_4_AMCURR6
O_EXT_5_AMOwner external mkt amt 5OIU_O_EXT_5_AMCURR6
O_EXT_6_AMOwner external mkt amt 6OIU_O_EXT_6_AMCURR6
O_EXT_7_AMOwner external mkt amt 7OIU_O_EXT_7_AMCURR6
O_EXT_8_AMOwner external mkt amt 8OIU_O_EXT_8_AMCURR6
O_EXT_9_AMOwner external mkt amt 9OIU_O_EXT_9_AMCURR6
O_EXT_10_AMOwner external mkt amt10OIU_O_EXT_10_AMCURR6
G_INT_1_AMGross internal mkt amt 1OIU_G_INT_1_AMCURR6
G_INT_2_AMGross internal mkt amt 2OIU_G_INT_2_AMCURR6
G_INT_3_AMGross internal mkt amt 3OIU_G_INT_3_AMCURR6
G_INT_4_AMGross internal mkt amt 4OIU_G_INT_4_AMCURR6
G_INT_5_AMGross internal mkt amt 5OIU_G_INT_5_AMCURR6
G_INT_6_AMGross internal mkt amt 6OIU_G_INT_6_AMCURR6
G_INT_7_AMGross internal mkt amt 7OIU_G_INT_7_AMCURR6
G_INT_8_AMGross internal mkt amt 8OIU_G_INT_8_AMCURR6
G_INT_9_AMGross internal mkt amt 9OIU_G_INT_9_AMCURR6
G_INT_10_AMGross internal mkt amt10OIU_G_INT_10_AMCURR6
G_EXT_1_AMGross external mkt amt 1OIU_G_EXT_1_AMCURR6
G_EXT_2_AMGross external mkt amt 2OIU_G_EXT_2_AMCURR6
G_EXT_3_AMGross external mkt amt 3OIU_G_EXT_3_AMCURR6
G_EXT_4_AMGross external mkt amt 4OIU_G_EXT_4_AMCURR6
G_EXT_5_AMGross external mkt amt 5OIU_G_EXT_5_AMCURR6
G_EXT_6_AMGross external mkt amt 6OIU_G_EXT_6_AMCURR6
G_EXT_7_AMGross external mkt amt 7OIU_G_EXT_7_AMCURR6
G_EXT_8_AMGross external mkt amt 8OIU_G_EXT_8_AMCURR6
G_EXT_9_AMGross external mkt amt 9OIU_G_EXT_9_AMCURR6
G_EXT_10_AMGross external mkt amt 10OIU_G_EXT_10_AMCURR6
Privacy Policy