OIUE2_ESCH_DTL

Proc 2.0 - Escheat - Owner Details | #transactional | Component: Revenue
Column Name Description
MANDT FK Client
RUN_ID Proc 2.0 - Run ID
OWN_NO Owner Number
OWN_SEQ_NO Owner Sequence Number
DOI_PR_NO Property / DOI
DOI_SEQ_NO Division of Interest (DOI) Number
PD_CD Full three char. product code (Major and Detail Products)
SA_DT Sales date
O_I_TYPE Owner Interest Type Code
O_I_SEQ_NO Owner Interest Sequence Number
ACCT_NO Account ID
O_DECM_QY Owner Disbursement (Balance) Decimal
LGND_CD Legend Code
Column Name Description
💲 Currency Key (T001.WAERS):
TRANS_AM LSSL Summary - Amount
GR_AM LSSL Summary - Amount
TXN_VAL_AM LSSL Summary - Amount
TAX_RMB_AM LSSL Summary - Amount
TAX_GR_RMB_AM LSSL Summary - Amount
DED_RMB_AM LSSL Summary - Amount
DED_GR_RMB_AM LSSL Summary - Amount
NET_TRANSP_AM LSSL Summary - Amount
NET_OTH_MK_AM LSSL Summary - Amount
GR_TRANSP_AM LSSL Summary - Amount
GR_OTH_MK_AM LSSL Summary - Amount
TAX_1_AM LSSL Summary - Tax Amount
TAX_2_AM LSSL Summary - Tax Amount
TAX_3_AM LSSL Summary - Tax Amount
TAX_4_AM LSSL Summary - Tax Amount
TAX_5_AM LSSL Summary - Tax Amount
TAX_6_AM LSSL Summary - Tax Amount
TAX_7_AM LSSL Summary - Tax Amount
TAX_8_AM LSSL Summary - Tax Amount
TAX_9_AM LSSL Summary - Tax Amount
TAX_10_AM LSSL Summary - Tax Amount
GR_TAX_1_AM LSSL Summary - Tax Amount
GR_TAX_2_AM LSSL Summary - Tax Amount
GR_TAX_3_AM LSSL Summary - Tax Amount
GR_TAX_4_AM LSSL Summary - Tax Amount
GR_TAX_5_AM LSSL Summary - Tax Amount
GR_TAX_6_AM LSSL Summary - Tax Amount
GR_TAX_7_AM LSSL Summary - Tax Amount
GR_TAX_8_AM LSSL Summary - Tax Amount
GR_TAX_9_AM LSSL Summary - Tax Amount
GR_TAX_10_AM LSSL Summary - Tax Amount
OTH_DED_01_AM LSSL Summary - Other Deduct Amount
OTH_DED_02_AM LSSL Summary - Other Deduct Amount
OTH_DED_03_AM LSSL Summary - Other Deduct Amount
OTH_DED_04_AM LSSL Summary - Other Deduct Amount
OTH_DED_05_AM LSSL Summary - Other Deduct Amount
OTH_DED_06_AM LSSL Summary - Other Deduct Amount
OTH_DED_07_AM LSSL Summary - Other Deduct Amount
OTH_DED_08_AM LSSL Summary - Other Deduct Amount
OTH_DED_09_AM LSSL Summary - Other Deduct Amount
OTH_DED_10_AM LSSL Summary - Other Deduct Amount
OTH_DED_11_AM LSSL Summary - Other Deduct Amount
OTH_DED_12_AM LSSL Summary - Other Deduct Amount
OTH_DED_13_AM LSSL Summary - Other Deduct Amount
OTH_DED_14_AM LSSL Summary - Other Deduct Amount
OTH_DED_15_AM LSSL Summary - Other Deduct Amount
OTH_DED_16_AM LSSL Summary - Other Deduct Amount
OTH_DED_17_AM LSSL Summary - Other Deduct Amount
OTH_DED_18_AM LSSL Summary - Other Deduct Amount
O_INT_1_AM Owner internal mkt amt 1
O_INT_2_AM Owner internal mkt amt 2
O_INT_3_AM Owner internal mkt amt 3
O_INT_4_AM Owner internal mkt amt 4
O_INT_5_AM Owner internal mkt amt 5
O_INT_6_AM Owner internal mkt amt 6
O_INT_7_AM Owner internal mkt amt 7
O_INT_8_AM Owner internal mkt amt 8
O_INT_9_AM Owner internal mkt amt 9
O_INT_10_AM Owner internal mkt amt10
O_EXT_1_AM Owner external mkt amt 1
O_EXT_2_AM Owner external mkt amt 2
O_EXT_3_AM Owner external mkt amt 3
O_EXT_4_AM Owner external mkt amt 4
O_EXT_5_AM Owner external mkt amt 5
O_EXT_6_AM Owner external mkt amt 6
O_EXT_7_AM Owner external mkt amt 7
O_EXT_8_AM Owner external mkt amt 8
O_EXT_9_AM Owner external mkt amt 9
O_EXT_10_AM Owner external mkt amt10
G_INT_1_AM Gross internal mkt amt 1
G_INT_2_AM Gross internal mkt amt 2
G_INT_3_AM Gross internal mkt amt 3
G_INT_4_AM Gross internal mkt amt 4
G_INT_5_AM Gross internal mkt amt 5
G_INT_6_AM Gross internal mkt amt 6
G_INT_7_AM Gross internal mkt amt 7
G_INT_8_AM Gross internal mkt amt 8
G_INT_9_AM Gross internal mkt amt 9
G_INT_10_AM Gross internal mkt amt10
G_EXT_1_AM Gross external mkt amt 1
G_EXT_2_AM Gross external mkt amt 2
G_EXT_3_AM Gross external mkt amt 3
G_EXT_4_AM Gross external mkt amt 4
G_EXT_5_AM Gross external mkt amt 5
G_EXT_6_AM Gross external mkt amt 6
G_EXT_7_AM Gross external mkt amt 7
G_EXT_8_AM Gross external mkt amt 8
G_EXT_9_AM Gross external mkt amt 9
G_EXT_10_AM Gross external mkt amt 10
Column Name Description
Column Name Description
SA_DT Sales date
Column Name Description
BTCH_TYP_CD Batch Type Show values
DO_NOT_ESCH_FL Proc 2.0 - Escheat - Do Not Escheat Flag Show values
Column Name Description Domain name
SYS_NO SYSTEM NUMBER OIUH_DO_SYS_NO
OR_LVL_1_NO Company Name Code CHAR3
ACCT_PERD_DT Accounting Period(YYYYMM01) CHAR8
BTCH_NO Batch ID CHAR4
LE_NO Journal Entry Line Number CHAR8
SYS_SRCE_CD GL Source Code CHAR2
VL_TYPE_CD Volume Type Code OIU_VL_TYPE_CD
PU_NO Purchaser ID CHAR6
PU_SEQ_NO Purchaser Sequence Number CHAR2
CT_NO Contract ID CHAR6
CT_TYPE_CD Contract Type OIU_CT_TYPE_CD
WL_NO Well Number CHAR6
WC_NO Well Completion Number CHAR2
SA_MP_NO Measurement Point OIUH_MP_NO
NWK_NO Delivery Network number H_DELIVERY_NWK
SUBNWK_NO Subnetwork Number H_SUBDN_NO
PAY_CD Pay Code CHAR2
STATE_CD State Code CHAR2
UNIT_PR_NO Unit Property Number CHAR8
AES_FL Actual / Entitled / Settlement Code CHAR1
PRDR_NO Producer ID CHAR6
PRDR_SEQ_NO Producer Sequence Number CHAR2
OWN_INT_DECM_QY Owner Interest Decimal Quantity OIUH_DEC9_8
UNIT_OF_MEAS_CD Unit of Measure Code CHAR3
SUS_RSN_CD Suspense Reason Code CHAR2
BTU_QY BTU Quantity OIUH_DEC7_3
BA_ST_CD State Code CHAR2
TRANS_QY LSSL Summary - Quantity OIUX3_SIGNED_DEC_11_2
GR_QY LSSL Summary - Quantity OIUX3_SIGNED_DEC_11_2
PLT_VL_GRED_AM LSSL Summary - Quantity OIUX3_SIGNED_DEC_11_2
PLT_VL_ORED_AM LSSL Summary - Quantity OIUX3_SIGNED_DEC_11_2
MMBTU_OVL_AM LSSL Summary - Quantity OIUX3_SIGNED_DEC_11_2
OIU_CRUSER Name of Person Responsible for Creating the Object USNAM
OIU_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Client OIUE2_ESCH_DTL.MANDT == T000.MANDT