OIUE2_ESCH_DTL - Proc 2.0 - Escheat - Owner Details

Proc 2.0 - Escheat - Owner Details information is stored in SAP table OIUE2_ESCH_DTL.
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_ESCH_DTL

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
RUN_ID	Proc 2.0 - Run ID	X	OIUE2_RUN_ID	NUMC	20
OWN_NO	Owner Number	X	OIUH_OWNER	CHAR	12
OWN_SEQ_NO	Owner Sequence Number	X	OIUH_OWNER_SEQUENCE_NUMBER	CHAR	4
.INCLUDE	ROIUE1_LSSL_SUM_KEY	X		ROIUE1_LSSL_SUM_KEY	0
DOI_PR_NO	Property / DOI	X	OIUH_PROPERTY_DOI	CHAR	16
DOI_SEQ_NO	Division of Interest (DOI) Number	X	OIUH_DOI_NO	CHAR	10
PD_CD	Full three char. product code (Major and Detail Products)	X	OIU_FULL_PD_CD	CHAR	6
SA_DT	Sales date	X	OIU_SA_DT	DATS	16
O_I_TYPE	Owner Interest Type Code	X	OIUH_OWN_INTEREST_TYPE_CODE	CHAR	4
O_I_SEQ_NO	Owner Interest Sequence Number	X	OIUH_OWN_INTEREST_SEQ_NUMBER	CHAR	4
ACCT_NO	Account ID	X	OIUH_ACCTID	CHAR	20
O_DECM_QY	Owner Disbursement (Balance) Decimal	X	OIUH_OWNER_DISBUR_DECIMAL	DEC	5
LGND_CD	Legend Code	X	OIUH_LEGEND_CODE	CHAR	4
.INCLUDE	ROIUE1_LSSL_SUM_NONKEY			ROIUE1_LSSL_SUM_NONKEY	0
SYS_NO	SYSTEM NUMBER		OIUH_DO_SYS_NO	DEC	10
OR_LVL_1_NO	Company Name Code		OIUH_COMPANY	CHAR	6
ACCT_PERD_DT	Accounting Period(YYYYMM01)		OIUH_ACCOUNTING_PERIOD8	CHAR	16
BTCH_NO	Batch ID		OIUH_BATCH_ID	CHAR	8
LE_NO	Journal Entry Line Number		OIUH_JELINENO	CHAR	16
BTCH_TYP_CD	Batch Type		OIUH_BATCH_TYPE	CHAR	4
SYS_SRCE_CD	GL Source Code		OIUREP_GL_SYS_SRCE_CD	CHAR	4
VL_TYPE_CD	Volume Type Code		OIU_VL_TYPE_CD	CHAR	4	*
PU_NO	Purchaser ID		OIUH_PURCHASER	CHAR	12
PU_SEQ_NO	Purchaser Sequence Number		OIUH_PURCHASER_SEQUENCE_NUMBER	CHAR	4
CT_NO	Contract ID		OIUH_CONTRACT_ID	CHAR	12
CT_TYPE_CD	Contract Type		OIU_CT_TYPE_CD	CHAR	4	*
WL_NO	Well Number		OIUH_WL_NO	CHAR	12
WC_NO	Well Completion Number		OIUH_WC_NO	CHAR	4
SA_MP_NO	Measurement Point		OIUH_MP_NO	CHAR	12
NWK_NO	Delivery Network number		OIUH_DN_NO	CHAR	8
SUBNWK_NO	Subnetwork Number		OIUH_SUBNWK_NO	CHAR	8
PAY_CD	Pay Code		OIUH_PAY_CODE	CHAR	4
STATE_CD	State Code		OIUH_STATE_CODE	CHAR	4
UNIT_PR_NO	Unit Property Number		OIUH_UNIT_PROPERTY_NUMBER	CHAR	16
AES_FL	Actual / Entitled / Settlement Code		OIU_AES_CD	CHAR	2
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
UNIT_OF_MEAS_CD	Unit of Measure Code		OIUH_UNIT_OF_MEASURE	CHAR	6
SUS_RSN_CD	Suspense Reason Code		OIUH_SUSPENSE_REASON_CODE	CHAR	4
BTU_QY	BTU Quantity		OIUH_BTU_QUANTITY	DEC	4
BA_ST_CD	State Code		OIUH_STATE_CODE	CHAR	4
.INCLUDE	ROIUE1_LSSL_SUM_SUMMED			ROIUE1_LSSL_SUM_SUMMED	0
TRANS_AM	LSSL Summary - Amount		OIUE1_SIGNED_CURR_11_2	CURR	6
TRANS_QY	LSSL Summary - Quantity		OIUE1_SIGNED_DEC_11_2	DEC	6
GR_AM	LSSL Summary - Amount		OIUE1_SIGNED_CURR_11_2	CURR	6
GR_QY	LSSL Summary - Quantity		OIUE1_SIGNED_DEC_11_2	DEC	6
TXN_VAL_AM	LSSL Summary - Amount		OIUE1_SIGNED_CURR_11_2	CURR	6
TAX_RMB_AM	LSSL Summary - Amount		OIUE1_SIGNED_CURR_11_2	CURR	6
TAX_GR_RMB_AM	LSSL Summary - Amount		OIUE1_SIGNED_CURR_11_2	CURR	6
DED_RMB_AM	LSSL Summary - Amount		OIUE1_SIGNED_CURR_11_2	CURR	6
DED_GR_RMB_AM	LSSL Summary - Amount		OIUE1_SIGNED_CURR_11_2	CURR	6
NET_TRANSP_AM	LSSL Summary - Amount		OIUE1_SIGNED_CURR_11_2	CURR	6
NET_OTH_MK_AM	LSSL Summary - Amount		OIUE1_SIGNED_CURR_11_2	CURR	6
GR_TRANSP_AM	LSSL Summary - Amount		OIUE1_SIGNED_CURR_11_2	CURR	6
GR_OTH_MK_AM	LSSL Summary - Amount		OIUE1_SIGNED_CURR_11_2	CURR	6
PLT_VL_GRED_AM	LSSL Summary - Quantity		OIUE1_SIGNED_DEC_11_2	DEC	6
PLT_VL_ORED_AM	LSSL Summary - Quantity		OIUE1_SIGNED_DEC_11_2	DEC	6
MMBTU_OVL_AM	LSSL Summary - Quantity		OIUE1_SIGNED_DEC_11_2	DEC	6
TAX_1_AM	LSSL Summary - Tax Amount		OIUE1_TAX_AMOUNT	CURR	6
TAX_2_AM	LSSL Summary - Tax Amount		OIUE1_TAX_AMOUNT	CURR	6
TAX_3_AM	LSSL Summary - Tax Amount		OIUE1_TAX_AMOUNT	CURR	6
TAX_4_AM	LSSL Summary - Tax Amount		OIUE1_TAX_AMOUNT	CURR	6
TAX_5_AM	LSSL Summary - Tax Amount		OIUE1_TAX_AMOUNT	CURR	6
TAX_6_AM	LSSL Summary - Tax Amount		OIUE1_TAX_AMOUNT	CURR	6
TAX_7_AM	LSSL Summary - Tax Amount		OIUE1_TAX_AMOUNT	CURR	6
TAX_8_AM	LSSL Summary - Tax Amount		OIUE1_TAX_AMOUNT	CURR	6
TAX_9_AM	LSSL Summary - Tax Amount		OIUE1_TAX_AMOUNT	CURR	6
TAX_10_AM	LSSL Summary - Tax Amount		OIUE1_TAX_AMOUNT	CURR	6
GR_TAX_1_AM	LSSL Summary - Tax Amount		OIUE1_TAX_AMOUNT	CURR	6
GR_TAX_2_AM	LSSL Summary - Tax Amount		OIUE1_TAX_AMOUNT	CURR	6
GR_TAX_3_AM	LSSL Summary - Tax Amount		OIUE1_TAX_AMOUNT	CURR	6
GR_TAX_4_AM	LSSL Summary - Tax Amount		OIUE1_TAX_AMOUNT	CURR	6
GR_TAX_5_AM	LSSL Summary - Tax Amount		OIUE1_TAX_AMOUNT	CURR	6
GR_TAX_6_AM	LSSL Summary - Tax Amount		OIUE1_TAX_AMOUNT	CURR	6
GR_TAX_7_AM	LSSL Summary - Tax Amount		OIUE1_TAX_AMOUNT	CURR	6
GR_TAX_8_AM	LSSL Summary - Tax Amount		OIUE1_TAX_AMOUNT	CURR	6
GR_TAX_9_AM	LSSL Summary - Tax Amount		OIUE1_TAX_AMOUNT	CURR	6
GR_TAX_10_AM	LSSL Summary - Tax Amount		OIUE1_TAX_AMOUNT	CURR	6
OTH_DED_01_AM	LSSL Summary - Other Deduct Amount		OIUE1_OTHER_DEDUCT_AMOUNT	CURR	6
OTH_DED_02_AM	LSSL Summary - Other Deduct Amount		OIUE1_OTHER_DEDUCT_AMOUNT	CURR	6
OTH_DED_03_AM	LSSL Summary - Other Deduct Amount		OIUE1_OTHER_DEDUCT_AMOUNT	CURR	6
OTH_DED_04_AM	LSSL Summary - Other Deduct Amount		OIUE1_OTHER_DEDUCT_AMOUNT	CURR	6
OTH_DED_05_AM	LSSL Summary - Other Deduct Amount		OIUE1_OTHER_DEDUCT_AMOUNT	CURR	6
OTH_DED_06_AM	LSSL Summary - Other Deduct Amount		OIUE1_OTHER_DEDUCT_AMOUNT	CURR	6
OTH_DED_07_AM	LSSL Summary - Other Deduct Amount		OIUE1_OTHER_DEDUCT_AMOUNT	CURR	6
OTH_DED_08_AM	LSSL Summary - Other Deduct Amount		OIUE1_OTHER_DEDUCT_AMOUNT	CURR	6
OTH_DED_09_AM	LSSL Summary - Other Deduct Amount		OIUE1_OTHER_DEDUCT_AMOUNT	CURR	6
OTH_DED_10_AM	LSSL Summary - Other Deduct Amount		OIUE1_OTHER_DEDUCT_AMOUNT	CURR	6
OTH_DED_11_AM	LSSL Summary - Other Deduct Amount		OIUE1_OTHER_DEDUCT_AMOUNT	CURR	6
OTH_DED_12_AM	LSSL Summary - Other Deduct Amount		OIUE1_OTHER_DEDUCT_AMOUNT	CURR	6
OTH_DED_13_AM	LSSL Summary - Other Deduct Amount		OIUE1_OTHER_DEDUCT_AMOUNT	CURR	6
OTH_DED_14_AM	LSSL Summary - Other Deduct Amount		OIUE1_OTHER_DEDUCT_AMOUNT	CURR	6
OTH_DED_15_AM	LSSL Summary - Other Deduct Amount		OIUE1_OTHER_DEDUCT_AMOUNT	CURR	6
OTH_DED_16_AM	LSSL Summary - Other Deduct Amount		OIUE1_OTHER_DEDUCT_AMOUNT	CURR	6
OTH_DED_17_AM	LSSL Summary - Other Deduct Amount		OIUE1_OTHER_DEDUCT_AMOUNT	CURR	6
OTH_DED_18_AM	LSSL Summary - Other Deduct Amount		OIUE1_OTHER_DEDUCT_AMOUNT	CURR	6
.INCLUDE	OIU_MKTG_DTL			OIU_MKTG_DTL	0
O_INT_1_AM	Owner internal mkt amt 1		OIU_O_INT_1_AM	CURR	6
O_INT_2_AM	Owner internal mkt amt 2		OIU_O_INT_2_AM	CURR	6
O_INT_3_AM	Owner internal mkt amt 3		OIU_O_INT_3_AM	CURR	6
O_INT_4_AM	Owner internal mkt amt 4		OIU_O_INT_4_AM	CURR	6
O_INT_5_AM	Owner internal mkt amt 5		OIU_O_INT_5_AM	CURR	6
O_INT_6_AM	Owner internal mkt amt 6		OIU_O_INT_6_AM	CURR	6
O_INT_7_AM	Owner internal mkt amt 7		OIU_O_INT_7_AM	CURR	6
O_INT_8_AM	Owner internal mkt amt 8		OIU_O_INT_8_AM	CURR	6
O_INT_9_AM	Owner internal mkt amt 9		OIU_O_INT_9_AM	CURR	6
O_INT_10_AM	Owner internal mkt amt10		OIU_O_INT_10_AM	CURR	6
O_EXT_1_AM	Owner external mkt amt 1		OIU_O_EXT_1_AM	CURR	6
O_EXT_2_AM	Owner external mkt amt 2		OIU_O_EXT_2_AM	CURR	6
O_EXT_3_AM	Owner external mkt amt 3		OIU_O_EXT_3_AM	CURR	6
O_EXT_4_AM	Owner external mkt amt 4		OIU_O_EXT_4_AM	CURR	6
O_EXT_5_AM	Owner external mkt amt 5		OIU_O_EXT_5_AM	CURR	6
O_EXT_6_AM	Owner external mkt amt 6		OIU_O_EXT_6_AM	CURR	6
O_EXT_7_AM	Owner external mkt amt 7		OIU_O_EXT_7_AM	CURR	6
O_EXT_8_AM	Owner external mkt amt 8		OIU_O_EXT_8_AM	CURR	6
O_EXT_9_AM	Owner external mkt amt 9		OIU_O_EXT_9_AM	CURR	6
O_EXT_10_AM	Owner external mkt amt10		OIU_O_EXT_10_AM	CURR	6
G_INT_1_AM	Gross internal mkt amt 1		OIU_G_INT_1_AM	CURR	6
G_INT_2_AM	Gross internal mkt amt 2		OIU_G_INT_2_AM	CURR	6
G_INT_3_AM	Gross internal mkt amt 3		OIU_G_INT_3_AM	CURR	6
G_INT_4_AM	Gross internal mkt amt 4		OIU_G_INT_4_AM	CURR	6
G_INT_5_AM	Gross internal mkt amt 5		OIU_G_INT_5_AM	CURR	6
G_INT_6_AM	Gross internal mkt amt 6		OIU_G_INT_6_AM	CURR	6
G_INT_7_AM	Gross internal mkt amt 7		OIU_G_INT_7_AM	CURR	6
G_INT_8_AM	Gross internal mkt amt 8		OIU_G_INT_8_AM	CURR	6
G_INT_9_AM	Gross internal mkt amt 9		OIU_G_INT_9_AM	CURR	6
G_INT_10_AM	Gross internal mkt amt10		OIU_G_INT_10_AM	CURR	6
G_EXT_1_AM	Gross external mkt amt 1		OIU_G_EXT_1_AM	CURR	6
G_EXT_2_AM	Gross external mkt amt 2		OIU_G_EXT_2_AM	CURR	6
G_EXT_3_AM	Gross external mkt amt 3		OIU_G_EXT_3_AM	CURR	6
G_EXT_4_AM	Gross external mkt amt 4		OIU_G_EXT_4_AM	CURR	6
G_EXT_5_AM	Gross external mkt amt 5		OIU_G_EXT_5_AM	CURR	6
G_EXT_6_AM	Gross external mkt amt 6		OIU_G_EXT_6_AM	CURR	6
G_EXT_7_AM	Gross external mkt amt 7		OIU_G_EXT_7_AM	CURR	6
G_EXT_8_AM	Gross external mkt amt 8		OIU_G_EXT_8_AM	CURR	6
G_EXT_9_AM	Gross external mkt amt 9		OIU_G_EXT_9_AM	CURR	6
G_EXT_10_AM	Gross external mkt amt 10		OIU_G_EXT_10_AM	CURR	6
.INCLUDE	OIU_CREATION			OIU_CREATION	0
OIU_CRUSER	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
OIU_TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TZNTSTMPS	DEC	8
DO_NOT_ESCH_FL	Proc 2.0 - Escheat - Do Not Escheat Flag		OIUE2_DO_NOT_ESCHEAT_FL	CHAR	2