1. SAP Tutorial
  2. Oil & Gas

OIUCI_JE SAP table for – Incoming Check Journalized. Temporary hold

Here we would like to draw your attention to OIUCI_JE table in SAP. As we know it is being mainly used with the SAP IS-OIL-PRA (Production and Revenue Accounting in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIUCI_JE is a SAP standard transp table used for storing Incoming Check Journalized. Temporary hold related data in SAP. It comes under the package OIU_CI.

SAP OIUCI_JE table

Table OIUCI_JE technical data

TableOIUCI_JE
Data storingIncoming Check Journalized. Temporary hold
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REV-CI
SAP PackageOIU_CI
Delivery ClassL – Table for storing temporary data
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUCI_JE Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in OIUCI_JE table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • OR_LVL_1_NO : Company Name Code
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • ACCT_PERD_DT : Accounting Period(YYYYMM01)
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • BTCH_NO : Batch ID
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • LE_NO : Journal Entry Line Number
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • REC_TYPE : PRA Journal Entry Record Type (0=Control, 1= Line item)
    Its data type is CHAR (Character String) with field length 1
  • VOU_NO : Voucher Number
    Its data type is CHAR (Character String) with field length 6
  • REJ_FL : Line item Reject Flag (Y=Yes, N=No)
    Its data type is CHAR (Character String) with field length 1
  • ACCT_NO : Account ID
    Its data type is CHAR (Character String) with field length 10
  • ACCT_TYPE_CD : Account Type
    Its data type is CHAR (Character String) with field length 2
  • ACCT_CAT_NO : Account category code
    Its data type is CHAR (Character String) with field length 4
  • BTCH_TYP_CD : Batch Type
    Its data type is CHAR (Character String) with field length 2
  • LE_PRCS_ST_CD : Journal Entry Line Status
    Its data type is CHAR (Character String) with field length 1
  • SYS_SRCE_CD : PRA application component source
    Its data type is CHAR (Character String) with field length 2
  • TRANS_AM : JE Transaction Amount
    Its data type is CURR (Currency Field) with field length 11
  • TRANS_QY : JE Transaction Quantity
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • GR_AM : Gross Amount (Value)
    Its data type is CURR (Currency Field) with field length 11
  • GR_QY : Gross Quantity
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • PD_CD : Product Code
    Its data type is CHAR (Character String) with field length 3
  • CK_NO : Check Number
    Its data type is CHAR (Character String) with field length 10
  • CK_DT : Check Date
    Its data type is CHAR (Character String) with field length 10
  • VL_TYPE_CD : Volume Type
    Its data type is CHAR (Character String) with field length 2
  • VL_CLASS_CD : Volume Class Code
    Its data type is CHAR (Character String) with field length 1
  • VL_SRCE_CD : Volume source code
    Its data type is CHAR (Character String) with field length 1
  • VL_FRQ_CD : Volume Frequency code
    Its data type is CHAR (Character String) with field length 1
  • BTU_QY : BTU Quantity
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • MMBTU_DET_CD : MMBTU Determination Code
    Its data type is CHAR (Character String) with field length 1
  • PS_BASE_QY : Pressure Base Quantity
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • GRV_QY : Gravity
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • OWN_NO : Owner Number
    Its data type is CHAR (Character String) with field length 6
  • OWN_SEQ_NO : Owner Sequence Number
    Its data type is CHAR (Character String) with field length 2
  • PU_NO : Purchaser Number
    Its data type is CHAR (Character String) with field length 6
  • PU_SEQ_NO : Purchaser Sequence Number
    Its data type is CHAR (Character String) with field length 2
  • PRDR_NO : Producer ID
    Its data type is CHAR (Character String) with field length 6
  • PRDR_SEQ_NO : Producer Sequence Number
    Its data type is CHAR (Character String) with field length 2
  • OWN_INT_DECM_QY : Owner Interest Decimal Quantity
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • OWN_INT_TYPE_CD : Owner Interest Type Code
    Its data type is CHAR (Character String) with field length 2
  • OWN_INT_SEQ_NO : Owner Interest Sequence Number
    Its data type is CHAR (Character String) with field length 2
  • RVRS_RSN_CD : Reversal Reason Code
    Its data type is CHAR (Character String) with field length 2
  • UNIT_OF_MEAS_CD : Unit of Measure Code
    Its data type is CHAR (Character String) with field length 3
  • CASH_RCPT_DT : Cash Receipt Date
    Its data type is CHAR (Character String) with field length 10
  • SUS_RSN_CD : Suspense Reason Code
    Its data type is CHAR (Character String) with field length 2
  • CT_NO : Contract ID
    Its data type is CHAR (Character String) with field length 6
  • CT_TYPE_CD : Contract Type code
    Its data type is CHAR (Character String) with field length 2
  • DOI_PR_NO : Property
    Its data type is CHAR (Character String) with field length 8
  • DOI_SEQ_NO : Division of Interest (DOI) Number
    Its data type is CHAR (Character String) with field length 5
  • SECT_PR_NO : Section Property Number
    Its data type is CHAR (Character String) with field length 8
  • SECT_SEQ_NO : Section Sequence Number
    Its data type is CHAR (Character String) with field length 5
  • TRACE_CO_NO : Company Name Code
    Its data type is CHAR (Character String) with field length 3
  • TRACE_APRD_DT : Accounting Period(YYYYMM01)
    Its data type is CHAR (Character String) with field length 8
  • TRACE_ACCT_NO : Account ID
    Its data type is CHAR (Character String) with field length 10
  • TRACE_BTCH_NO : Batch ID
    Its data type is CHAR (Character String) with field length 4
  • TRACE_VOUC_NO : Voucher Number
    Its data type is CHAR (Character String) with field length 6
  • TRACE_LE_NO : Journal Entry Line Number
    Its data type is CHAR (Character String) with field length 8
  • TRACE_BTCH_TY : Batch Type
    Its data type is CHAR (Character String) with field length 2
  • WL_NO : Well ID Number
    Its data type is CHAR (Character String) with field length 6
  • WC_NO : Well Completion ID
    Its data type is CHAR (Character String) with field length 2
  • ORIG_MP : Originating Measurement Point Number
    Its data type is CHAR (Character String) with field length 6
  • ORIG_MP_TYPE : Originating Measurement Point Type
    Its data type is CHAR (Character String) with field length 2
  • DED_RMB_AM : Deduction/Reimbursement Amount
    Its data type is CURR (Currency Field) with field length 11
  • DED_GR_RMB_AM : Gross Deduction/Reimbursement amount
    Its data type is CURR (Currency Field) with field length 11
  • TAX_1_AM : Tax amount
    Its data type is CURR (Currency Field) with field length 11
  • TAX_2_AM : Tax amount
    Its data type is CURR (Currency Field) with field length 11
  • TAX_3_AM : Tax amount
    Its data type is CURR (Currency Field) with field length 11
  • TAX_4_AM : Tax amount
    Its data type is CURR (Currency Field) with field length 11
  • TAX_5_AM : Tax amount
    Its data type is CURR (Currency Field) with field length 11
  • TAX_6_AM : Tax amount
    Its data type is CURR (Currency Field) with field length 11
  • TAX_7_AM : Tax amount
    Its data type is CURR (Currency Field) with field length 11
  • TAX_8_AM : Tax amount
    Its data type is CURR (Currency Field) with field length 11
  • TAX_9_AM : Tax amount
    Its data type is CURR (Currency Field) with field length 11
  • TAX_10_AM : Tax amount
    Its data type is CURR (Currency Field) with field length 11
  • TAX_RMB_AM : Tax Reimbursement Amount
    Its data type is CURR (Currency Field) with field length 11
  • TAX_GR_RMB_AM : Gross Tax Reimbursement Amount
    Its data type is CURR (Currency Field) with field length 11
  • INV_NO : Invoice Number
    Its data type is CHAR (Character String) with field length 6
  • INV_DT : Invoice Date
    Its data type is CHAR (Character String) with field length 10
  • INV_TYPE_CD : Invoice Type code
    Its data type is CHAR (Character String) with field length 2
  • PAY_CD : Pay Code
    Its data type is CHAR (Character String) with field length 2
  • SA_MP_NO : Sales Measurement Point Number
    Its data type is CHAR (Character String) with field length 6
  • SA_DT : Sales Date
    Its data type is CHAR (Character String) with field length 10
  • STATE_CD : State Code
    Its data type is CHAR (Character String) with field length 2
  • TAX_AUTH_NO : Tax Authority Number
    Its data type is CHAR (Character String) with field length 6
  • TAX_AUTH_SEQ_NO : Tax Authority Sequence Number
    Its data type is CHAR (Character String) with field length 2
  • OWN_BAL_DECM_QY : Owner Disbursement (Balance) Decimal
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • PR_TYPE_CD : Property Type Code
    Its data type is CHAR (Character String) with field length 2
  • OP_NON_OP_FL : Operated Flag
    Its data type is CHAR (Character String) with field length 1
  • PU_PR_NO : Purchaser Property Number
    Its data type is CHAR (Character String) with field length 18
  • PU_PD_CD : Purchaser Product Code
    Its data type is CHAR (Character String) with field length 3
  • UNIT_PR_NO : Unit Property Number
    Its data type is CHAR (Character String) with field length 8
  • ARMT_LVL_1_CD : A/R Remittance Level 1 code
    Its data type is CHAR (Character String) with field length 8
  • ARMT_LVL_2_CD : A/R Remittance Level 2 code
    Its data type is CHAR (Character String) with field length 5
  • TRANS_DE : Descriptive Text for financial transaction
    Its data type is CHAR (Character String) with field length 60
  • NET_TRANSP_AM : Net Transportation Amount
    Its data type is CURR (Currency Field) with field length 11
  • NET_OTH_MK_AM : Net Other Marketing Amount
    Its data type is CURR (Currency Field) with field length 11
  • GR_TRANSP_AM : Gross Transportation Amount
    Its data type is CURR (Currency Field) with field length 11
  • GR_OTH_MK_AM : Gross Other Marketing Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_01_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_02_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_03_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_04_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_05_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_06_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_07_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_08_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_09_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_10_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_11_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_12_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_13_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_14_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_15_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_16_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_17_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_18_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • PROC_CO : Processing Company code
    Its data type is CHAR (Character String) with field length 3
  • AES_FL : Actual / Entitled / Settlement Code
    Its data type is CHAR (Character String) with field length 1
  • TAX_CD : Tax Code
    Its data type is CHAR (Character String) with field length 2
  • GRP_GROUP_NO : Group Number
    Its data type is CHAR (Character String) with field length 8
  • INT_SYMBOL : Interest Symbol
    Its data type is CHAR (Character String) with field length 2
  • TXN_VAL_AM : Transaction Owner Amount
    Its data type is CURR (Currency Field) with field length 11
  • TXN_DT : Transaction Date
    Its data type is CHAR (Character String) with field length 10
  • GAS_PLANT_NO : Gas Plant Property Number
    Its data type is CHAR (Character String) with field length 8
  • GAS_PLANT_DOI : Gas Plant DOI Number
    Its data type is CHAR (Character String) with field length 5
  • REF_NO : Reference Number
    Its data type is CHAR (Character String) with field length 10
  • SELLER_NO : Seller Number
    Its data type is CHAR (Character String) with field length 6
  • SELLER_SEQ_NO : Seller Sequence Number
    Its data type is CHAR (Character String) with field length 2
  • NWK_NO : Delivery Network number
    Its data type is CHAR (Character String) with field length 4
  • SUBNWK_NO : Subnetwork Number
    Its data type is CHAR (Character String) with field length 4
  • AUDIT_BTCH_NO : Audit Batch Number
    Its data type is CHAR (Character String) with field length 4
  • JDI_PR_NO : JDI Expense Property Number
    Its data type is CHAR (Character String) with field length 8
  • JDI_NO : JDI Expense Property Sequence Number
    Its data type is CHAR (Character String) with field length 5
  • DI_PR_NO : Expense Property Number
    Its data type is CHAR (Character String) with field length 8
  • DI_NO : Expense Property Sequence Number
    Its data type is CHAR (Character String) with field length 5
  • REMT_NO : Remitter ID
    Its data type is CHAR (Character String) with field length 6
  • REMT_SEQ_NO : Remitter Sequence Number
    Its data type is CHAR (Character String) with field length 2
  • RCV_GL_WL_NO : Off Lease Well Number
    Its data type is CHAR (Character String) with field length 6
  • RCV_GL_WC_NO : Off Lease Well Completion Number
    Its data type is CHAR (Character String) with field length 2
  • REL_CT_NO : REL Contract Number
    Its data type is CHAR (Character String) with field length 6
  • PLT_VL_GRED_AM : Gross Plant Volume Reduction amount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • PLT_VL_ORED_AM : Owner Plant Volume Reduction amount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • INT_PAID_FL : Interest Paid Flag
    Its data type is CHAR (Character String) with field length 1
  • MMBTU_OVL_AM : Owner MMBTU
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • MMBTU_GRVL_AM : MMBTU Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • PHASE_NO : Phase number
    Its data type is CHAR (Character String) with field length 1
  • PD_CD_SUM_IND : Product Code Summarize Indicator
    Its data type is CHAR (Character String) with field length 1
  • VL_LEVEL_CD : Valuation Level Code
    Its data type is CHAR (Character String) with field length 2
  • CHV_RPT_CD : Template cost center
    Its data type is CHAR (Character String) with field length 10
  • GR_TAX_1_AM : Gross Tax Amount
    Its data type is CURR (Currency Field) with field length 13
  • GR_TAX_2_AM : Gross Tax Amount
    Its data type is CURR (Currency Field) with field length 13
  • GR_TAX_3_AM : Gross Tax Amount
    Its data type is CURR (Currency Field) with field length 13
  • GR_TAX_4_AM : Gross Tax Amount
    Its data type is CURR (Currency Field) with field length 13
  • GR_TAX_5_AM : Gross Tax Amount
    Its data type is CURR (Currency Field) with field length 13
  • GR_TAX_6_AM : Gross Tax Amount
    Its data type is CURR (Currency Field) with field length 13
  • GR_TAX_7_AM : Gross Tax Amount
    Its data type is CURR (Currency Field) with field length 13
  • GR_TAX_8_AM : Gross Tax Amount
    Its data type is CURR (Currency Field) with field length 13
  • GR_TAX_9_AM : Gross Tax Amount
    Its data type is CURR (Currency Field) with field length 13
  • GR_TAX_10_AM : Gross Tax Amount
    Its data type is CURR (Currency Field) with field length 13
  • SPEC_PYMNT_CD : Special Payment Code
    Its data type is CHAR (Character String) with field length 1
  • LGND_CD : Legend Code
    Its data type is CHAR (Character String) with field length 2
  • RBUR_DEC : Royalty Burden Decimal
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • ESCH_FL : Escheat Flag
    Its data type is CHAR (Character String) with field length 1
  • CMT_SYS_NO : Comment System Number
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 18
  • OVRD_OWN_CD : Override Owner code
    Its data type is CHAR (Character String) with field length 2
  • BRD_CD : Brand Code
    Its data type is CHAR (Character String) with field length 4
  • RCPTN_PT_NO : Reception Point Number
    Its data type is CHAR (Character String) with field length 6
  • TRNSP_NO : Transporter Number
    Its data type is CHAR (Character String) with field length 6
  • TRNSP_SEQ_NO : Transporter Sequence Number
    Its data type is CHAR (Character String) with field length 2
  • OR_LVL_2_NO : Region Code (Org. Lvl 2)
    Its data type is CHAR (Character String) with field length 1
  • MK_TYPE_NO : Marketing Type Number
    Its data type is CHAR (Character String) with field length 2
  • ORIG_PR_NO : Originating Property Number
    Its data type is CHAR (Character String) with field length 8
  • INJ_DT : Injection Date
    Its data type is CHAR (Character String) with field length 10
  • GR_APC_RMB : Gross APC Reimbursement
    Its data type is CURR (Currency Field) with field length 13
  • NET_APC_RMB : Net APC Reimbursement Amount
    Its data type is CURR (Currency Field) with field length 13
  • JI_OWN_NO : JI Owner Number
    Its data type is CHAR (Character String) with field length 6
  • JI_OWN_SEQ_NO : JI Owner Sequence Number
    Its data type is CHAR (Character String) with field length 2
  • DEAL_I_NO : Deal I Number
    Its data type is CHAR (Character String) with field length 12
  • CUSA_TRSPK_NO : CUSA Transportation Number
    Its data type is CHAR (Character String) with field length 8
  • VER_NO : Version Number
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • USER_ID : User ID
    Its data type is CHAR (Character String) with field length 8
  • TIMESTAMP : Time Stamp
    Its data type is CHAR (Character String) with field length 14
  • ERROR_1_CD : JE posting Validation Error Code
    Its data type is CHAR (Character String) with field length 5
  • ERROR_2_CD : JE posting Validation Error Code
    Its data type is CHAR (Character String) with field length 5
  • ERROR_3_CD : JE posting Validation Error Code
    Its data type is CHAR (Character String) with field length 5
  • ERROR_4_CD : JE posting Validation Error Code
    Its data type is CHAR (Character String) with field length 5
  • ERROR_5_CD : JE posting Validation Error Code
    Its data type is CHAR (Character String) with field length 5

    • OIUCI_JE related tables

    • OIUCI_PTLOCK : Incoming Check Usage of Property/Product translation data
    • OIUCI_RULESLOCK : Incoming Check Usage of Process Rules
    • OIUCI_SPC_DIST : Purchaser DOI Cross Reference
    • OIUCI_HEADER : Incoming Check Header information
    • OIUCI_NOTES : Notes for Suspended Line item of Incoming Check
    • OIUCI_MESG : Contains warning, error message pertaining to a Line item(s)
    • OIUCI_CDEX_PRDX : CDEX Product Xref
    • OIUCI_CDEXD : CDEX Detail
    • OIUCI_DOC_CIREJ : Contains VL/RD rejects to be reported to Check Input
    • OIUCI_PDX : Purchaser DOI Cross Reference
    • OIUCI_CDEXH : CDEX Header
    • OIUCI_PDXLOCK : Incoming Check Usage of Property/DOI xref master data
    • OIUCI_DOCS : Incoming Checks – Generated/Booked Documents
    • OIUCI_CDEX_REMX : CDEX Remitter Xref
    • OIUCI_DETAIL : Incoming Check’s Detail Line information
    • OIUCI_JE : Incoming Check Journalized. Temporary hold
    • OIUCI_FIELDATTR : Check fields attributes

    OIUCI_JE related transaction codes under SAP package OIU_CI

    • O3UCI_ARVAR : Receivable and Price Variance
    • O3UCI_MASS : Processing Checks in Mass
    • O3UCI_PRDX : CDEX Comapny Product Cross Reference
    • O3UCI_REMX : CDEX Remitter Cross Reference
    • O3UCI_PPD : PRA Payment Posting Desktop
    • O3UCI_PDX : Purchaser to Property/DOI Xref
    • O3UCI_SUSP : Suspended Line Items messages
    • O3UCI_CDEX : CDEX Workplace

    Related References

    Related Tutorials

    OIU_CW_SUM_PAY SAP table for – Summarized Payable Table for Check Write

    OIU_CW_SUM_PAY table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUCW_PAYMENT SAP table for – Payment Details from Payment Run

    OIUCW_PAYMENT table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUH_RV_CHD SAP table for – Check Detail

    OIUH_RV_CHD table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUH_RV_MRC SAP table for – Manual Royalty Check

    OIUH_RV_MRC table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUX7_WY_4231 SAP table for – Tax 2.0 – WYGP 4231

    OIUX7_WY_4231 table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUCI_HEADER SAP table for – Incoming Check Header information

    OIUCI_HEADER table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUX7_WY_4201 SAP table for – Tax 2.0 – WYGP 4201

    OIUX7_WY_4201 table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    «
    »