OIUCW_PAYMENT - Payment Details from Payment Run

Payment Details from Payment Run information is stored in SAP table OIUCW_PAYMENT.
It is part of development package OIU_CW in software component IS-OIL-PRA-REV-CW. This development package consists of objects that can be grouped under "PRA Revenue: Payment Processing".

Fields for table OIUCW_PAYMENT

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
RUN_ID	Run ID	X	OIUCW_RUN_ID	CHAR	20	OIUCW_RUN_PARMS
RUN_DATE	Run Date	X	OIUCW_RUN_DATE	DATS	16
OWN_NO	Owner (Business Associate)	X	OIUH_OWN	CHAR	12
OWN_SEQ_NO	Business Associate Sequence Nr.	X	OIUH_BASEQNR	CHAR	4
LINE_NO	Line Number	X	OIUCW_LINE_NO	NUMC	16
ORG_LVL_1	Organization level 1 number (Company Code)		OIUH_OR_LVL_1_NO	CHAR	6
TRACE_CO_NO	Organization level 1 number (Company Code)		OIUH_OR_LVL_1_NO	CHAR	6
BTCH_TYPE_CD	Batch Type		OIUH_BATCH_TYPE	CHAR	4
ACCT_NO	Account ID		OIUH_ACCTID	CHAR	20
PD_CD	Product Code		OIUH_PRODUCT_CODE	CHAR	6
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
MMBTU_DET_CD	MMBTU Determination Code		OIUH_MMBTU_DET_CODE	CHAR	2
SA_DT	Date of Char type for compatabiliy with dats stored as Char		OIUCW_CHARDATE	CHAR	16
STATE_CD	State Code		OIUH_STATE_CODE	CHAR	4
PAY_CD	Pay Code		OIUH_PAY_CODE	CHAR	4
LGND_CD	Legend Code		OIUH_LEGEND_CODE	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_BAL_DECM_QY	Owner Disbursement (Balance) Decimal		OIUH_OWNER_DISBUR_DECIMAL	DEC	5
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
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
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
UNIT_PR_NO	Unit Property Number		OIUH_UNIT_PROPERTY_NUMBER	CHAR	16
NWK_NO	Delivery Network number		OIUH_DN_NO	CHAR	8
SUBNWK_NO	Subnetwork Number		OIUH_SUBNWK_NO	CHAR	8
SA_MP_NO	Sales Measurement Point Number		OIUH_SALES_MP_NUMBER	CHAR	12
WL_NO	Well ID Number		OIUH_WELL_NO	CHAR	12
WC_NO	Well Completion ID		OIUH_WELL_COMPLETION_ID	CHAR	4
PHASE_NO	Phase number		OIUVL_PHASE_NO	CHAR	2
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
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_CD	Tax Code		OIUH_TAX_CODE	CHAR	4
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
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
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
TXN_VAL_AM	Transaction Owner Amount		OIUH_TRAN_OWNER_AMOUNT	CURR	6
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
MMBTU_OVL_AM	Owner MMBTU		OIUH_OWNER_MMBTU	DEC	6
MMBTU_GRVL_AM	MMBTU Gross Volume		OIUH_MMBTU	DEC	6
PLT_PTR_GRED_AM	Gross Plant Thermal Reduction amount		OIUH_GR_PLANT_THERMAL_RED	DEC	6
PLT_PTR_ORED_AM	Owner Plant Thermal Reduction amount		OIUH_OWN_PLANT_THERMAL_RED	DEC	6
.INCLUDE				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