SAP ABAP Table ROIUY3_TX_ROYTXN_NONKEY (Royalty 2.0 - TX GLO - Royalty Transactions Non-Key Fields)
Hierarchy
IS-OIL (Software Component) IS-OIL
   IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
     OIU_Y3 (Package) Royalty 2.0 - Texas GLO/TAMU
Basic Data
Table Category INTTAB    Structure 
Structure ROIUY3_TX_ROYTXN_NONKEY   Table Relationship Diagram
Short Description Royalty 2.0 - TX GLO - Royalty Transactions 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 UNIT_VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture *
2 ACCT_NO OIUH_ACCTID CHAR10 CHAR 10   0   Account ID  
3 CHV_RPT_CD RKOSTL KOSTL CHAR 10   0   Template cost center *
4 UOM OIU_MEAS_U MEINS UNIT 3   0   Measurement unit T006
5 PS_BASE_QY OIUH_PRESSURE_BASE OIUH_DEC6_3 DEC 6   3   Pressure Base Quantity  
6 GRV_QY OIUH_GRAVITY OIUH_DEC3_1 DEC 3   1   Gravity  
7 PAY_CD OIUH_PAY_CODE CHAR2 CHAR 2   0   Pay Code  
8 OWN_INT_DECM_QY OIUY3_TX_OWNER_NRI OIU_PERCENT98 DEC 9   8   Royalty 2.0 - TX GLO - Owner NRI  
9 OWN_BAL_DECM_QY OIUH_OWNER_DISBUR_DECIMAL OIUH_DEC9_8 DEC 9   8   Owner Disbursement (Balance) Decimal  
10 PU_NO OIUH_PURCHASER CHAR6 CHAR 6   0   Purchaser ID  
11 PU_SEQ_NO OIUH_PURCHASER_SEQUENCE_NUMBER CHAR2 CHAR 2   0   Purchaser Sequence Number  
12 AFFILIATED_SALE OIUY3_TX_AFFILIATED_SALE_IND YESNO CHAR 1   0   Royalty 2.0 - TX GLO - Affiliated Sale Indicator  
13 .INCLUDE       0   0   Royalty 2.0 - TX GLO - Royalty Transactions Non-Key Vol/Val  
14 GR_QY OIUX3_GROSS_VOLUME OIUX3_SIGNED_DEC_11_2 DEC 11   2   Gross Volume  
15 GR_AM OIUX3_GROSS_VALUE OIUX3_SIGNED_CURR_11_2 CURR 11   2   Gross Value  
16 TXN_VAL_AM OIUY3_TX_OWNER_GROSS_VALUE OIUX3_SIGNED_CURR_11_2 CURR 11   2   Royalty 2.0 - TX GLO - Owner Gross Value  
17 TRANS_AM OIUX3_TRANS_AMT OIUX3_SIGNED_DEC_11_2 DEC 11   2   JE Transaction Amount  
18 TRANS_QY OIUH_TRANS_QUANTITY OIUH_DEC11_2 DEC 11   2   JE Transaction Quantity  
19 MMBTU_OVL_AM OIUH_OWNER_MMBTU OIUH_DEC11_2 DEC 11   2   Owner MMBTU  
20 PLT_VL_GRED_AM OIUH_GROSS_PLANT_VOLUME_RED_AM OIUH_DEC11_2 DEC 11   2   Gross Plant Volume Reduction amount  
21 PLT_VL_ORED_AM OIUH_OWNER_PLANT_VOLUME_RED_AM OIUH_DEC11_2 DEC 11   2   Owner Plant Volume Reduction amount  
22 DED_RMB_AM OIUH_DED_REIMB_AMOUNT OIUH_CURR11_2 CURR 11   2   Deduction/Reimbursement Amount  
23 NET_TRANSP_AM OIUX3_MARKETING_COST OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost  
24 NET_OTH_MK_AM OIUX3_MARKETING_COST OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost  
25 TAX_RMB_AM OIUH_TAX_REIMBURSEMENT_AMT OIUH_CURR11_2 CURR 11   2   Tax Reimbursement Amount  
26 BTU_QY OIUH_BTU_QUANTITY OIUH_DEC7_3 DEC 7   3   BTU Quantity  
27 .INCLUDE       0   0   Royalty 2.0 - TX GLO - Royalty Transactions Non-Key Validate  
28 ORIGINAL_REPORT OIUY3_TX_ORIGINAL_REPORT OIUY3_TX_ORIGINAL_REPORT CHAR 1   0   Royalty 2.0 - TX GLOTAMU - Original Report  
29 GAS_DISP_CODE OIUY3_TX_GLO_ROY_GAS_DISP_CODE OIUY3_TX_GLO_ROY_GAS_DISP_CODE NUMC 2   0   Royalty 2.0 - TX GLO/TAMU - Royalty Gas Disposition Code  
30 MASTER_LEVEL OIUY3_TX_MASTER_LEVEL   CHAR 1   0   Royalty 2.0 - TX GLO - Master Level  
31 RRC_LEVEL OIUY3_TX_RRC_LEVEL   CHAR 1   0   Royalty 2.0 - TX GLO - RRC Master Level  
32 PURCHASER_ID OIUY3_TX_PURCHASER_ID   NUMC 11   0   Royalty 2.0 - Texas GLO/TAMU - Purchaser ID  
33 OPERATOR_ID OIUY3_TX_OPERATOR_ID OIUY3_TX_ID CHAR 10   0   Royalty 2.0 - TX GLO - Operator ID  
34 .INCLUDE       0   0   Royalty 2,.0 - TX GLO/TAMU - Master Sub Key  
35 GLO_LEASE OIUY3_TX_GLO_LEASE OIUY3_TX_GLO_LEASE NUMC 6   0   Royalty 2.0 - TX GLO/TAMU Lease OIUY3_TX_LEASE
36 GLO_UNIT_NO OIUY3_TX_GLO_UNIT_NO   CHAR 4   0   Royalty 2.0 - Texas GLO/TAMU - Unit Number OIUY3_TX_UNIT
37 ROYALTY_DECIMAL OIUY3_TX_ROYALTY_DECIMAL OIU_PERCENT98 DEC 9   8   Royalty 2.0 - Texas GLO - Royalty Decimal  
38 UNIT_VNAME_FLAG OIUY3_TX_UNIT_VNAME YESNO CHAR 1   0   Roy 2.0 - Texas GLO/TAMU - Unit Venture  
39 .INCLUDE       0   0   Royalty 2.0 - TX GLO/TAMU - Master Non-Key Fields  
40 ALLOC_PERCENT OIUY3_TX_ALLOCATION_PERCENT OIU_PERCENT98 DEC 9   8   Royalty 2.0 - TX GLO/TAMU - Allocation Percent  
41 TRACT_PART_FACT OIUY3_TX_TRACT_PART_FACTOR OIU_PERCENT98 DEC 9   8   Royalty 2.0 - Texas GLO - Tract Participation Factor  
42 .INCLUDE       0   0   Royalty 2.0 - TX GLO/TAMU - RRC Master Non-Key Fields  
43 RRC_DISTRICT_NO OIUY3_TX_GLO_DISTRICT_NO   CHAR 2   0   Royalty 2.0 - TX GLO/TAMU - District Number  
44 RRC_OIL_LEASE_NO OIUY3_TX_GLO_RRC_OIL_LEASE_NO   CHAR 5   0   Royalty 2.0 - TX GLO/TAMU - RRC Oil Lease Number  
45 RRC_GAS_WELL_ID OIUY3_TX_GLO_RRC_GAS_WELL_ID   CHAR 6   0   Royalty 2.0 - TX GLO/TAMU - RRC Gas Well ID  
46 RRC_DRILL_PERMIT OIUY3_TX_GLO_RRC_DRILLING_PERM   CHAR 6   0   Royalty 2.0 - TX GLO/TAMU - RRC Drilling Permit  
47 RRC_FIELD_NAME OIUY3_TX_GLO_RRC_FIELD_NAME   CHAR 32   0   Royalty 2.0 - TX GLO/TAMU - RRC Field Name  
48 RRC_LEASE_NAME OIUY3_TX_GLO_RRC_LEASE_NAME   CHAR 32   0   Royalty 2.0 - TX GLO/TAMU - RRC Lease Name  
49 PROP_ALIAS_NAME OIUY3_TX_GLO_PROP_ALIAS_NAME   CHAR 32   0   Royalty 2.0 - TX GLO/TAMU - Property Alias Name  
50 OPERATOR_NO OIUY3_OPERATOR_NUMBER OIUCM_BUS_ASSOC CHAR 6   0   Royalty 2.0 - TX GLO/TAMU - Operator Number OIUH_CM_BA
51 OPERATOR_SEQ_NO OIUY3_OPERATOR_SEQUENCE_NUMBER OIUCM_SEQ_NO CHAR 2   0   Royalty 2.0 - TX GLO - Operator Sequence Number  
52 PAY_REPORT_FLAG OIUY3_TX_PAY_REPORT_FLAG OIUY3_TX_PAY_REPORT_FLAG CHAR 1   0   Royalty 2.0 - TX GLO/TAMU - Pay/Report Flag  
53 DOC_NO OIURV_DOCNR OIU_MP_NO CHAR 20   0   Val. document number *
54 DOC_YEAR OIU_DOC_YEAR GJAHR NUMC 4   0   Document year  
55 INTERFACE_FL OIUY3_TX_INTERFACE_FL OIUY3_TX_EXT_UPDATE CHAR 1   0   Royalty 2.0 - TX GLO - Interface Flag  
56 OPTION1     CHAR 1   0    
57 OPTION2     CHAR 1   0    
58 OPTION3     CHAR 1   0    
59 REFERENCE_RUN_ID OIUX3_RUN_ID NUMC10 NUMC 10   0   Tax Reporting - Run ID  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 ROIUY3_TX_ROYTXN_NONKEY GLO_LEASE OIUY3_TX_LEASE GLO_LEASE    
2 ROIUY3_TX_ROYTXN_NONKEY GLO_UNIT_NO OIUY3_TX_UNIT GLO_UNIT_NO KEY    
3 ROIUY3_TX_ROYTXN_NONKEY OPERATOR_NO OIUH_CM_BA BA_BA_NO    
4 ROIUY3_TX_ROYTXN_NONKEY UOM T006 MSEHI REF    
History
Last changed by/on SAP  20130529 
SAP Release Created in 100