OIUCI_JE - Incoming Check Journalized. Temporary hold

Incoming Check Journalized. Temporary hold information is stored in SAP table OIUCI_JE.
It is part of development package OIU_CI in software component IS-OIL-PRA-REV-CI. This development package consists of objects that can be grouped under "Check Input Enhancements for Apache".

Fields for table OIUCI_JE

Field Name	Description	Is Key	Data Element	Data Type	Length
MANDT	Client	X	MANDT	CLNT	6
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
REC_TYPE	PRA Journal Entry Record Type (0=Control, 1= Line item)		OIUH_RECORD_TYPE	CHAR	2
VOU_NO	Voucher Number		OIUH_VOUCHER_NUMBER	CHAR	12
REJ_FL	Line item Reject Flag (Y=Yes, N=No)		OIUH_REJECT_FLAG	CHAR	2
ACCT_NO	Account ID		OIUH_ACCTID	CHAR	20
ACCT_TYPE_CD	Account Type		OIUH_ACCTYPE	CHAR	4
ACCT_CAT_NO	Account category code		OIU_ACCT_CAT_CD	CHAR	8
BTCH_TYP_CD	Batch Type		OIUH_BATCH_TYPE	CHAR	4
LE_PRCS_ST_CD	Journal Entry Line Status		OIUH_JELINEST	CHAR	2
SYS_SRCE_CD	PRA application component source		OIUH_SUB_SYSTEM_SOURCE	CHAR	4
TRANS_AM	JE Transaction Amount		OIUH_TRANS_AMT	CURR	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	Product Code		OIUH_PRODUCT_CODE	CHAR	6
CK_NO	Check Number		OIUH_CHECK_NUMBER	CHAR	20
CK_DT	Check Date		OIUH_CHECKDATE	CHAR	20
VL_TYPE_CD	Volume Type		OIUH_VOLTYPE	CHAR	4
VL_CLASS_CD	Volume Class Code		OIUH_VOL_CLASS_CODE	CHAR	2
VL_SRCE_CD	Volume source code		OIUH_VOL_SOURCE_CODE	CHAR	2
VL_FRQ_CD	Volume Frequency code		OIUH_VOL_FREQUENCY_CODE	CHAR	2
BTU_QY	BTU Quantity		OIUH_BTU_QUANTITY	DEC	4
MMBTU_DET_CD	MMBTU Determination Code		OIUH_MMBTU_DET_CODE	CHAR	2
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
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
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
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
CASH_RCPT_DT	Cash Receipt Date		OIUH_CASH_RECEIPT_DATE	CHAR	20
SUS_RSN_CD	Suspense Reason Code		OIUH_SUSPENSE_REASON_CODE	CHAR	4
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
SECT_PR_NO	Section Property Number		OIUH_SECTION_PROP_NUMBER	CHAR	16
SECT_SEQ_NO	Section Sequence Number		OIUH_SECTION_SEQ_NUMBER	CHAR	10
TRACE_CO_NO	Company Name Code		OIUH_COMPANY	CHAR	6
TRACE_APRD_DT	Accounting Period(YYYYMM01)		OIUH_ACCOUNTING_PERIOD8	CHAR	16
TRACE_ACCT_NO	Account ID		OIUH_ACCTID	CHAR	20
TRACE_BTCH_NO	Batch ID		OIUH_BATCH_ID	CHAR	8
TRACE_VOUC_NO	Voucher Number		OIUH_VOUCHER_NUMBER	CHAR	12
TRACE_LE_NO	Journal Entry Line Number		OIUH_JELINENO	CHAR	16
TRACE_BTCH_TY	Batch Type		OIUH_BATCH_TYPE	CHAR	4
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
ORIG_MP_TYPE	Originating Measurement Point Type		OIUH_ORIGINATING_MP_TYPE	CHAR	4
DED_RMB_AM	Deduction/Reimbursement Amount		OIUH_DED_REIMB_AMOUNT	CURR	6
DED_GR_RMB_AM	Gross Deduction/Reimbursement amount		OIUH_DED_GR_REIMB_AMOUNT	CURR	6
TAX_1_AM	Tax amount		OIUH_TAX_AMOUNT	CURR	6
TAX_2_AM	Tax amount		OIUH_TAX_AMOUNT	CURR	6
TAX_3_AM	Tax amount		OIUH_TAX_AMOUNT	CURR	6
TAX_4_AM	Tax amount		OIUH_TAX_AMOUNT	CURR	6
TAX_5_AM	Tax amount		OIUH_TAX_AMOUNT	CURR	6
TAX_6_AM	Tax amount		OIUH_TAX_AMOUNT	CURR	6
TAX_7_AM	Tax amount		OIUH_TAX_AMOUNT	CURR	6
TAX_8_AM	Tax amount		OIUH_TAX_AMOUNT	CURR	6
TAX_9_AM	Tax amount		OIUH_TAX_AMOUNT	CURR	6
TAX_10_AM	Tax amount		OIUH_TAX_AMOUNT	CURR	6
TAX_RMB_AM	Tax Reimbursement Amount		OIUH_TAX_REIMBURSEMENT_AMT	CURR	6
TAX_GR_RMB_AM	Gross Tax Reimbursement Amount		OIUH_GROSS_TAX_REIMB_AMT	CURR	6
INV_NO	Invoice Number		OIUH_INVOICE_NUMBER	CHAR	12
INV_DT	Invoice Date		OIUH_INVOICE_DATE	CHAR	20
INV_TYPE_CD	Invoice Type code		OIUH_INVOICE_TYPE_CODE	CHAR	4
PAY_CD	Pay Code		OIUH_PAY_CODE	CHAR	4
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
TAX_AUTH_NO	Tax Authority Number		OIUH_TAX_AUTHORITY_NUMBER	CHAR	12
TAX_AUTH_SEQ_NO	Tax Authority Sequence Number		OIUH_TAX_AUTHORITY_SEQ_NUMBER	CHAR	4
OWN_BAL_DECM_QY	Owner Disbursement (Balance) Decimal		OIUH_OWNER_DISBUR_DECIMAL	DEC	5
PR_TYPE_CD	Property Type Code		OIUH_PROPERTY_TYPE_CODE	CHAR	4
OP_NON_OP_FL	Operated Flag		OIUH_OPERATED_FLAG	CHAR	2
PU_PR_NO	Purchaser Property Number		OIUH_PURCHASER_PROPERTY_NUMBER	CHAR	36
PU_PD_CD	Purchaser Product Code		OIUH_PURCHASER_PRODUCT_CODE	CHAR	6
UNIT_PR_NO	Unit Property Number		OIUH_UNIT_PROPERTY_NUMBER	CHAR	16
ARMT_LVL_1_CD	A/R Remittance Level 1 code		OIUH_AR_REMIT_LVL_1_CODE	CHAR	16
ARMT_LVL_2_CD	A/R Remittance Level 2 code		OIUH_AR_REMIT_LVL_2_CODE	CHAR	10
TRANS_DE	Descriptive Text for financial transaction		OIUH_DESCRIPTION	CHAR	120
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
GR_TRANSP_AM	Gross Transportation Amount		OIUH_GROSS_TRANP_AMOUNT	CURR	6
GR_OTH_MK_AM	Gross Other Marketing Amount		OIUH_GROSS_OTH_MARKETING_AMT	CURR	6
OTH_DED_01_AM	Other Deductions Amount		OIUH_OTHER_DEDUCTION_AMOUNT	CURR	6
OTH_DED_02_AM	Other Deductions Amount		OIUH_OTHER_DEDUCTION_AMOUNT	CURR	6
OTH_DED_03_AM	Other Deductions Amount		OIUH_OTHER_DEDUCTION_AMOUNT	CURR	6
OTH_DED_04_AM	Other Deductions Amount		OIUH_OTHER_DEDUCTION_AMOUNT	CURR	6
OTH_DED_05_AM	Other Deductions Amount		OIUH_OTHER_DEDUCTION_AMOUNT	CURR	6
OTH_DED_06_AM	Other Deductions Amount		OIUH_OTHER_DEDUCTION_AMOUNT	CURR	6
OTH_DED_07_AM	Other Deductions Amount		OIUH_OTHER_DEDUCTION_AMOUNT	CURR	6
OTH_DED_08_AM	Other Deductions Amount		OIUH_OTHER_DEDUCTION_AMOUNT	CURR	6
OTH_DED_09_AM	Other Deductions Amount		OIUH_OTHER_DEDUCTION_AMOUNT	CURR	6
OTH_DED_10_AM	Other Deductions Amount		OIUH_OTHER_DEDUCTION_AMOUNT	CURR	6
OTH_DED_11_AM	Other Deductions Amount		OIUH_OTHER_DEDUCTION_AMOUNT	CURR	6
OTH_DED_12_AM	Other Deductions Amount		OIUH_OTHER_DEDUCTION_AMOUNT	CURR	6
OTH_DED_13_AM	Other Deductions Amount		OIUH_OTHER_DEDUCTION_AMOUNT	CURR	6
OTH_DED_14_AM	Other Deductions Amount		OIUH_OTHER_DEDUCTION_AMOUNT	CURR	6
OTH_DED_15_AM	Other Deductions Amount		OIUH_OTHER_DEDUCTION_AMOUNT	CURR	6
OTH_DED_16_AM	Other Deductions Amount		OIUH_OTHER_DEDUCTION_AMOUNT	CURR	6
OTH_DED_17_AM	Other Deductions Amount		OIUH_OTHER_DEDUCTION_AMOUNT	CURR	6
OTH_DED_18_AM	Other Deductions Amount		OIUH_OTHER_DEDUCTION_AMOUNT	CURR	6
PROC_CO	Processing Company code		OIUH_PROCESSING_COMPANY_CODE	CHAR	6
AES_FL	Actual / Entitled / Settlement Code		OIU_AES_CD	CHAR	2
TAX_CD	Tax Code		OIUH_TAX_CODE	CHAR	4
GRP_GROUP_NO	Group Number		OIUH_GROUP_NUMBER	CHAR	16
INT_SYMBOL	Interest Symbol		OIUH_INTEREST_SYMBOL	CHAR	4
TXN_VAL_AM	Transaction Owner Amount		OIUH_TRAN_OWNER_AMOUNT	CURR	6
TXN_DT	Transaction Date		OIUH_TRANS_DATE	CHAR	20
GAS_PLANT_NO	Gas Plant Property Number		OIUH_GAS_PLANT_PROPERTY_NUMBER	CHAR	16
GAS_PLANT_DOI	Gas Plant DOI Number		OIUH_GAS_PLANT_DOI_NUMBER	CHAR	10
REF_NO	Reference Number		OIUH_REFERENCE_NUMBER	CHAR	20
SELLER_NO	Seller Number		OIUH_SELLER_NUMBER	CHAR	12
SELLER_SEQ_NO	Seller Sequence Number		OIUH_SELLER_SEQUENCE_NUMBER	CHAR	4
NWK_NO	Delivery Network number		OIUH_DN_NO	CHAR	8
SUBNWK_NO	Subnetwork Number		OIUH_SUBNWK_NO	CHAR	8
AUDIT_BTCH_NO	Audit Batch Number		OIUH_AUDIT_BATCH_NUMBER	CHAR	8
JDI_PR_NO	JDI Expense Property Number		OIUH_JDI_PROPERTY_NUMBER	CHAR	16
JDI_NO	JDI Expense Property Sequence Number		OIUH_JDI_PROPERTY_SEQ_NUMBER	CHAR	10
DI_PR_NO	Expense Property Number		OIUH_DI_PROPERTY_NUMBER	CHAR	16
DI_NO	Expense Property Sequence Number		OIUH_DI_PROPERTY_SEQ_NUMBER	CHAR	10
REMT_NO	Remitter ID		OIUH_REMITTER_ID	CHAR	12
REMT_SEQ_NO	Remitter Sequence Number		OIUH_REMITTER_SEQUENCE_NUMBER	CHAR	4
RCV_GL_WL_NO	Off Lease Well Number		OIUH_OFF_LEASE_WELL_NUMBER	CHAR	12
RCV_GL_WC_NO	Off Lease Well Completion Number		OIUH_OFF_LEASE_WELL_COMPLETION	CHAR	4
REL_CT_NO	REL Contract Number		OIUH_REL_CONTRACT_NUMBER	CHAR	12
PLT_VL_GRED_AM	Gross Plant Volume Reduction amount		OIUH_GROSS_PLANT_VOLUME_RED_AM	DEC	6
PLT_VL_ORED_AM	Owner Plant Volume Reduction amount		OIUH_OWNER_PLANT_VOLUME_RED_AM	DEC	6
INT_PAID_FL	Interest Paid Flag		OIUH_INTEREST_PAID_FLAG	CHAR	2
MMBTU_OVL_AM	Owner MMBTU		OIUH_OWNER_MMBTU	DEC	6
MMBTU_GRVL_AM	MMBTU Gross Volume		OIUH_MMBTU	DEC	6
PHASE_NO	Phase number		OIUVL_PHASE_NO	CHAR	2
PD_CD_SUM_IND	Product Code Summarize Indicator		OIUH_PRODUCT_CODE_SUMMARIZE_IN	CHAR	2
VL_LEVEL_CD	Valuation Level Code		OIUH_VALUATION_LEVEL_CODE	CHAR	4
CHV_RPT_CD	Template Cost Center		RKOSTL	CHAR	20
GR_TAX_1_AM	Gross Tax Amount		OIUH_GROSS_TAX_AMOUNT	CURR	7
GR_TAX_2_AM	Gross Tax Amount		OIUH_GROSS_TAX_AMOUNT	CURR	7
GR_TAX_3_AM	Gross Tax Amount		OIUH_GROSS_TAX_AMOUNT	CURR	7
GR_TAX_4_AM	Gross Tax Amount		OIUH_GROSS_TAX_AMOUNT	CURR	7
GR_TAX_5_AM	Gross Tax Amount		OIUH_GROSS_TAX_AMOUNT	CURR	7
GR_TAX_6_AM	Gross Tax Amount		OIUH_GROSS_TAX_AMOUNT	CURR	7
GR_TAX_7_AM	Gross Tax Amount		OIUH_GROSS_TAX_AMOUNT	CURR	7
GR_TAX_8_AM	Gross Tax Amount		OIUH_GROSS_TAX_AMOUNT	CURR	7
GR_TAX_9_AM	Gross Tax Amount		OIUH_GROSS_TAX_AMOUNT	CURR	7
GR_TAX_10_AM	Gross Tax Amount		OIUH_GROSS_TAX_AMOUNT	CURR	7
SPEC_PYMNT_CD	Special Payment Code		OIUH_SPECIAL_PAYMENT_CODE	CHAR	2
LGND_CD	Legend Code		OIUH_LEGEND_CODE	CHAR	4
RBUR_DEC	Royalty Burden Decimal		OIUH_ROYALTY_BURDEN_DECIMAL	DEC	5
ESCH_FL	Escheat Flag		OIUH_ESCHEAT_FLAG	CHAR	2
CMT_SYS_NO	Comment System Number		OIUH_COMMENT_SYSTEM_NUMBER	DEC	10
OVRD_OWN_CD	Override Owner code		OIU_OVRD_OWN_CD	CHAR	4
BRD_CD	Brand Code		OIUH_BRAND_CODE	CHAR	8
RCPTN_PT_NO	Reception Point Number		OIUH_RECEPTION_POINT_NUMBER	CHAR	12
TRNSP_NO	Transporter Number		OIUH_TRANSPORTER_NUMBER	CHAR	12
TRNSP_SEQ_NO	Transporter Sequence Number		OIUH_TRANSPORTER_SEQ_NUMBER	CHAR	4
OR_LVL_2_NO	Region Code (Org. Lvl 2)		OIUH_REGION_CODE	CHAR	2
MK_TYPE_NO	Marketing Type Number		OIUH_MARKETING_TYPE_NUMBER	CHAR	4
ORIG_PR_NO	Originating Property Number		OIUH_ORGINATING_PROPERTY_NO	CHAR	16
INJ_DT	Injection Date		OIUH_INJECTION_DATE	CHAR	20
GR_APC_RMB	Gross APC Reimbursement		OIUH_GROSS_APC_REIMBURSEMENT	CURR	7
NET_APC_RMB	Net APC Reimbursement Amount		OIUH_NET_APC_REIMBURSEMENT	CURR	7
JI_OWN_NO	JI Owner Number		OIUH_JI_OWNER_NUMBER	CHAR	12
JI_OWN_SEQ_NO	JI Owner Sequence Number		OIUH_JI_OWNER_SEQUENCE_NUMBER	CHAR	4
DEAL_I_NO	Deal I Number		OIUH_DEAL_I_NUMBER	CHAR	24
CUSA_TRSPK_NO	CUSA Transportation Number		OIUH_CUSA_TRANSPORTATION_NO	CHAR	16
VER_NO	Version Number		OIUH_TT_VER_NO	DEC	3
USER_ID	User ID		OIUH_USER_ID	CHAR	16
TIMESTAMP	Time Stamp		OIUH_TT_TIMESTAMP	CHAR	28
ERROR_1_CD	JE posting Validation Error Code		OIUH_ERROR_CODE	CHAR	10
ERROR_2_CD	JE posting Validation Error Code		OIUH_ERROR_CODE	CHAR	10
ERROR_3_CD	JE posting Validation Error Code		OIUH_ERROR_CODE	CHAR	10
ERROR_4_CD	JE posting Validation Error Code		OIUH_ERROR_CODE	CHAR	10
ERROR_5_CD	JE posting Validation Error Code		OIUH_ERROR_CODE	CHAR	10