SAP ABAP Table ROIUX3_JEINTF_NON_KEY (Tax Reporting - JE Interface Non Key Fields)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-TAX (Application Component) Tax Reporting
     ⤷ OIU_X3 (Package) Tax 2.0

Basic Data

Table Category	INTTAB	Structure
Structure	ROIUX3_JEINTF_NON_KEY	Table Relationship Diagram
Short Description	Tax Reporting - JE Interface Non Key Fields

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	ACCT_NO	☐	OIUH_ACCTID	CHAR10	CHAR	10	0	Account ID
2	ACCT_CAT_NO	☐	OIU_ACCT_CAT_CD	OIU_ACCT_CAT_CD	CHAR	4	0	Account category code
3	BTCH_TYP_CD	☐	OIUH_BATCH_TYPE	OIUH_BATCH_TYPE	CHAR	2	0	Batch Type
4	SYS_SRCE_CD	☐	OIUH_SUB_SYSTEM_SOURCE	CHAR2	CHAR	2	0	PRA application component source
5	TRANS_AM	☐	OIUX3_TRANS_AMT	OIUX3_SIGNED_DEC_11_2	DEC	11	2	JE Transaction Amount
6	TRANS_QY	☐	OIUH_TRANS_QUANTITY	OIUH_DEC11_2	DEC	11	2	JE Transaction Quantity
7	GR_AM	☐	OIUH_GROSS_AMOUNT	OIUH_CURR11_2	CURR	11	2	Gross Amount (Value)
8	GR_QY	☐	OIUH_GROSS_QTY	OIUH_DEC11_2	DEC	11	2	Gross Quantity
9	PD_CD	☐	OIU_FULL_PD_CD	OIU_FULL_PD_CD	CHAR	3	0	Full three char. product code (Major and Detail Products)
10	VL_TYPE_CD	☐	OIUH_VOLTYPE	CHAR2	CHAR	2	0	Volume Type
11	PU_NO	☐	OIUH_PU_NO	CHAR6	CHAR	6	0	Purchaser Number
12	PU_SEQ_NO	☐	OIUH_PURCHASER_SEQUENCE_NUMBER	CHAR2	CHAR	2	0	Purchaser Sequence Number
13	PRDR_NO	☐	OIUH_PRODUCER	CHAR6	CHAR	6	0	Producer ID
14	PRDR_SEQ_NO	☐	OIUH_PRODUCER_SEQUENCE_NUMBER	CHAR2	CHAR	2	0	Producer Sequence Number
15	RVRS_RSN_CD	☐	OIUH_RVRS_REASON_CODE	CHAR2	CHAR	2	0	Reversal Reason Code
16	UNIT_OF_MEAS_CD	☐	OIUH_UNIT_OF_MEASURE	CHAR3	CHAR	3	0	Unit of Measure Code
17	CT_NO	☐	OIUH_CONTRACT_ID	CHAR6	CHAR	6	0	Contract ID
18	CT_TYPE_CD	☐	OIUH_CONTRACT_TYPE_CODE	CHAR2	CHAR	2	0	Contract Type code
19	DOI_PR_NO	☐	OIUH_PR_NO	CHAR8	CHAR	8	0	Property
20	DOI_SEQ_NO	☐	OIUH_DOI_NO	CHAR5	CHAR	5	0	Division of Interest (DOI) Number
21	WL_NO	☐	OIUH_WELL_NO	CHAR6	CHAR	6	0	Well ID Number
22	WC_NO	☐	OIUH_WELL_COMPLETION_ID	CHAR2	CHAR	2	0	Well Completion ID
23	ORIG_MP	☐	OIUH_ORIGINATING_MP_NO	CHAR6	CHAR	6	0	Originating Measurement Point Number
24	SA_MP_NO	☐	OIUH_SALES_MP_NUMBER	CHAR6	CHAR	6	0	Sales Measurement Point Number
25	SA_DT	☐	OIUH_SALES_DATE	CHAR10	CHAR	10	0	Sales Date
26	STATE_CD	☐	OIUH_STATE_CODE	CHAR2	CHAR	2	0	State Code
27	UNIT_PR_NO	☐	OIUH_UNIT_PROPERTY_NUMBER	CHAR8	CHAR	8	0	Unit Property Number
28	PROC_CO	☐	OIUH_PROCESSING_COMPANY_CODE	CHAR3	CHAR	3	0	Processing Company code
29	TAX_CD	☐	OIUH_TAX_CODE	CHAR2	CHAR	2	0	Tax Code
30	REF_NO	☐	OIUH_REFERENCE_NUMBER	CHAR10	CHAR	10	0	Reference Number
31	NWK_NO	☐	OIUH_DN_NO	H_DELIVERY_NWK	CHAR	4	0	Delivery Network number
32	SUBNWK_NO	☐	OIUH_SUBNWK_NO	H_SUBDN_NO	CHAR	4	0	Subnetwork Number
33	CHV_RPT_CD	☐	RKOSTL	KOSTL	CHAR	10	0	Template cost center	*
34	.INCLUDE	☐				0	0	Royalty Reporting - JE Interface Non Key Fields
35	BTU_QY	☐	OIUH_BTU_QUANTITY	OIUH_DEC7_3	DEC	7	3	BTU Quantity
36	PS_BASE_QY	☐	OIUH_PRESSURE_BASE	OIUH_DEC6_3	DEC	6	3	Pressure Base Quantity
37	GRV_QY	☐	OIUH_GRAVITY	OIUH_DEC3_1	DEC	3	1	Gravity
38	OWN_NO	☐	OIUH_OWNER	CHAR6	CHAR	6	0	Owner Number
39	OWN_SEQ_NO	☐	OIUH_OWNER_SEQUENCE_NUMBER	CHAR2	CHAR	2	0	Owner Sequence Number
40	OWN_INT_DECM_QY	☐	OIUH_OWN_INTEREST_DECIMAL_QTY	OIUH_DEC9_8	DEC	9	8	Owner Interest Decimal Quantity
41	OWN_INT_TYPE_CD	☐	OIUH_OWN_INTEREST_TYPE_CODE	CHAR2	CHAR	2	0	Owner Interest Type Code
42	OWN_INT_SEQ_NO	☐	OIUH_OWN_INTEREST_SEQ_NUMBER	CHAR2	CHAR	2	0	Owner Interest Sequence Number
43	PAY_CD	☐	OIUH_PAY_CODE	CHAR2	CHAR	2	0	Pay Code
44	OWN_BAL_DECM_QY	☐	OIUH_OWNER_DISBUR_DECIMAL	OIUH_DEC9_8	DEC	9	8	Owner Disbursement (Balance) Decimal
45	MMBTU_OVL_AM	☐	OIUH_OWNER_MMBTU	OIUH_DEC11_2	DEC	11	2	Owner MMBTU
46	NET_TRANSP_AM	☐	OIUH_TRANSPORTATION_AMT	OIUH_CURR11_2	CURR	11	2	Net Transportation Amount
47	NET_OTH_MK_AM	☐	OIUH_NET_OTH_MARKETING_AMOUNT	OIUH_CURR11_2	CURR	11	2	Net Other Marketing Amount
48	TXN_VAL_AM	☐	OIUH_TRAN_OWNER_AMOUNT	OIUH_CURR11_2	CURR	11	2	Transaction Owner Amount
49	DED_RMB_AM	☐	OIUH_DED_REIMB_AMOUNT	OIUH_CURR11_2	CURR	11	2	Deduction/Reimbursement Amount
50	TAX_RMB_AM	☐	OIUH_TAX_REIMBURSEMENT_AMT	OIUH_CURR11_2	CURR	11	2	Tax Reimbursement Amount

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C