SAP ABAP Table OIUX3_JEINTF (Tax Reporting - JE Interface Table)
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 TRANSP    Transparent table 
Transparent table OIUX3_JEINTF   Table Relationship Diagram
Short Description Tax Reporting - JE Interface Table    
Delivery and Maintenance
Pool/cluster      
Delivery Class L   Table for storing temporary data, delivered empty 
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 MANDT MANDT MANDT CLNT 3   0   Client T000
2 .INCLUDE       0   0   Tax Reporting - JE Interface Key Fields  
3 RUN_ID OIUX3_RUN_ID NUMC10 NUMC 10   0   Tax Reporting - Run ID  
4 OR_LVL_1_NO OIUH_COMPANY CHAR3 CHAR 3   0   Company Name Code  
5 ACCT_PERD_DT OIUH_ACCOUNTING_PERIOD8 CHAR8 CHAR 8   0   Accounting Period(YYYYMM01)  
6 BTCH_NO OIUH_BATCH_ID CHAR4 CHAR 4   0   Batch ID  
7 LE_NO OIUH_JELINENO CHAR8 CHAR 8   0   Journal Entry Line Number  
8 .INCLUDE       0   0   Tax Reporting - JE Interface Non Key Fields  
9 ACCT_NO OIUH_ACCTID CHAR10 CHAR 10   0   Account ID OIUH_RV_COA
10 ACCT_CAT_NO OIU_ACCT_CAT_CD OIU_ACCT_CAT_CD CHAR 4   0   Account category code  
11 BTCH_TYP_CD OIUH_BATCH_TYPE OIUH_BATCH_TYPE CHAR 2   0   Batch Type  
12 SYS_SRCE_CD OIUH_SUB_SYSTEM_SOURCE CHAR2 CHAR 2   0   PRA application component source  
13 TRANS_AM OIUX3_TRANS_AMT OIUX3_SIGNED_DEC_11_2 DEC 11   2   JE Transaction Amount  
14 TRANS_QY OIUH_TRANS_QUANTITY OIUH_DEC11_2 DEC 11   2   JE Transaction Quantity  
15 GR_AM OIUH_GROSS_AMOUNT OIUH_CURR11_2 CURR 11   2   Gross Amount (Value)  
16 GR_QY OIUH_GROSS_QTY OIUH_DEC11_2 DEC 11   2   Gross Quantity  
17 PD_CD OIU_FULL_PD_CD OIU_FULL_PD_CD CHAR 3   0   Full three char. product code (Major and Detail Products) OIUX3_PDCD
18 VL_TYPE_CD OIUH_VOLTYPE CHAR2 CHAR 2   0   Volume Type  
19 PU_NO OIUH_PU_NO CHAR6 CHAR 6   0   Purchaser Number  
20 PU_SEQ_NO OIUH_PURCHASER_SEQUENCE_NUMBER CHAR2 CHAR 2   0   Purchaser Sequence Number  
21 PRDR_NO OIUH_PRODUCER CHAR6 CHAR 6   0   Producer ID  
22 PRDR_SEQ_NO OIUH_PRODUCER_SEQUENCE_NUMBER CHAR2 CHAR 2   0   Producer Sequence Number  
23 RVRS_RSN_CD OIUH_RVRS_REASON_CODE CHAR2 CHAR 2   0   Reversal Reason Code  
24 UNIT_OF_MEAS_CD OIUH_UNIT_OF_MEASURE CHAR3 CHAR 3   0   Unit of Measure Code  
25 CT_NO OIUH_CONTRACT_ID CHAR6 CHAR 6   0   Contract ID  
26 CT_TYPE_CD OIUH_CONTRACT_TYPE_CODE CHAR2 CHAR 2   0   Contract Type code  
27 DOI_PR_NO OIUH_PR_NO CHAR8 CHAR 8   0   Property  
28 DOI_SEQ_NO OIUH_DOI_NO CHAR5 CHAR 5   0   Division of Interest (DOI) Number  
29 WL_NO OIUH_WELL_NO CHAR6 CHAR 6   0   Well ID Number  
30 WC_NO OIUH_WELL_COMPLETION_ID CHAR2 CHAR 2   0   Well Completion ID  
31 ORIG_MP OIUH_ORIGINATING_MP_NO CHAR6 CHAR 6   0   Originating Measurement Point Number  
32 SA_MP_NO OIUH_SALES_MP_NUMBER CHAR6 CHAR 6   0   Sales Measurement Point Number  
33 SA_DT OIUH_SALES_DATE CHAR10 CHAR 10   0   Sales Date  
34 STATE_CD OIUH_STATE_CODE CHAR2 CHAR 2   0   State Code  
35 UNIT_PR_NO OIUH_UNIT_PROPERTY_NUMBER CHAR8 CHAR 8   0   Unit Property Number  
36 PROC_CO OIUH_PROCESSING_COMPANY_CODE CHAR3 CHAR 3   0   Processing Company code  
37 TAX_CD OIUH_TAX_CODE CHAR2 CHAR 2   0   Tax Code  
38 REF_NO OIUH_REFERENCE_NUMBER CHAR10 CHAR 10   0   Reference Number  
39 NWK_NO OIUH_DN_NO H_DELIVERY_NWK CHAR 4   0   Delivery Network number  
40 SUBNWK_NO OIUH_SUBNWK_NO H_SUBDN_NO CHAR 4   0   Subnetwork Number  
41 CHV_RPT_CD RKOSTL KOSTL CHAR 10   0   Template cost center *
42 .INCLUDE       0   0   Royalty Reporting - JE Interface Non Key Fields  
43 BTU_QY OIUH_BTU_QUANTITY OIUH_DEC7_3 DEC 7   3   BTU Quantity  
44 PS_BASE_QY OIUH_PRESSURE_BASE OIUH_DEC6_3 DEC 6   3   Pressure Base Quantity  
45 GRV_QY OIUH_GRAVITY OIUH_DEC3_1 DEC 3   1   Gravity  
46 OWN_NO OIUH_OWNER CHAR6 CHAR 6   0   Owner Number  
47 OWN_SEQ_NO OIUH_OWNER_SEQUENCE_NUMBER CHAR2 CHAR 2   0   Owner Sequence Number  
48 OWN_INT_DECM_QY OIUH_OWN_INTEREST_DECIMAL_QTY OIUH_DEC9_8 DEC 9   8   Owner Interest Decimal Quantity  
49 OWN_INT_TYPE_CD OIUH_OWN_INTEREST_TYPE_CODE CHAR2 CHAR 2   0   Owner Interest Type Code  
50 OWN_INT_SEQ_NO OIUH_OWN_INTEREST_SEQ_NUMBER CHAR2 CHAR 2   0   Owner Interest Sequence Number  
51 PAY_CD OIUH_PAY_CODE CHAR2 CHAR 2   0   Pay Code  
52 OWN_BAL_DECM_QY OIUH_OWNER_DISBUR_DECIMAL OIUH_DEC9_8 DEC 9   8   Owner Disbursement (Balance) Decimal  
53 MMBTU_OVL_AM OIUH_OWNER_MMBTU OIUH_DEC11_2 DEC 11   2   Owner MMBTU  
54 NET_TRANSP_AM OIUH_TRANSPORTATION_AMT OIUH_CURR11_2 CURR 11   2   Net Transportation Amount  
55 NET_OTH_MK_AM OIUH_NET_OTH_MARKETING_AMOUNT OIUH_CURR11_2 CURR 11   2   Net Other Marketing Amount  
56 TXN_VAL_AM OIUH_TRAN_OWNER_AMOUNT OIUH_CURR11_2 CURR 11   2   Transaction Owner Amount  
57 DED_RMB_AM OIUH_DED_REIMB_AMOUNT OIUH_CURR11_2 CURR 11   2   Deduction/Reimbursement Amount  
58 TAX_RMB_AM OIUH_TAX_REIMBURSEMENT_AMT OIUH_CURR11_2 CURR 11   2   Tax Reimbursement Amount  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 OIUX3_JEINTF ACCT_NO OIUH_RV_COA COA_ACCT_NO REF    
2 OIUX3_JEINTF MANDT T000 MANDT KEY    
3 OIUX3_JEINTF PD_CD OIUX3_PDCD PDCD REF    
History
Last changed by/on SAP  20130529 
SAP Release Created in 46C