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 |
![]() |
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 | ![]() |
JV_NAME | JV_NAME | CHAR | 6 | 0 | Joint venture | * | |
2 | ![]() |
OIUH_ACCTID | CHAR10 | CHAR | 10 | 0 | Account ID | ||
3 | ![]() |
RKOSTL | KOSTL | CHAR | 10 | 0 | Template cost center | * | |
4 | ![]() |
OIU_MEAS_U | MEINS | UNIT | 3 | 0 | Measurement unit | T006 | |
5 | ![]() |
OIUH_PRESSURE_BASE | OIUH_DEC6_3 | DEC | 6 | 3 | Pressure Base Quantity | ||
6 | ![]() |
OIUH_GRAVITY | OIUH_DEC3_1 | DEC | 3 | 1 | Gravity | ||
7 | ![]() |
OIUH_PAY_CODE | CHAR2 | CHAR | 2 | 0 | Pay Code | ||
8 | ![]() |
OIUY3_TX_OWNER_NRI | OIU_PERCENT98 | DEC | 9 | 8 | Royalty 2.0 - TX GLO - Owner NRI | ||
9 | ![]() |
OIUH_OWNER_DISBUR_DECIMAL | OIUH_DEC9_8 | DEC | 9 | 8 | Owner Disbursement (Balance) Decimal | ||
10 | ![]() |
OIUH_PURCHASER | CHAR6 | CHAR | 6 | 0 | Purchaser ID | ||
11 | ![]() |
OIUH_PURCHASER_SEQUENCE_NUMBER | CHAR2 | CHAR | 2 | 0 | Purchaser Sequence Number | ||
12 | ![]() |
OIUY3_TX_AFFILIATED_SALE_IND | YESNO | CHAR | 1 | 0 | Royalty 2.0 - TX GLO - Affiliated Sale Indicator | ||
13 | ![]() |
0 | 0 | Royalty 2.0 - TX GLO - Royalty Transactions Non-Key Vol/Val | |||||
14 | ![]() |
OIUX3_GROSS_VOLUME | OIUX3_SIGNED_DEC_11_2 | DEC | 11 | 2 | Gross Volume | ||
15 | ![]() |
OIUX3_GROSS_VALUE | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Gross Value | ||
16 | ![]() |
OIUY3_TX_OWNER_GROSS_VALUE | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Royalty 2.0 - TX GLO - Owner Gross Value | ||
17 | ![]() |
OIUX3_TRANS_AMT | OIUX3_SIGNED_DEC_11_2 | DEC | 11 | 2 | JE Transaction Amount | ||
18 | ![]() |
OIUH_TRANS_QUANTITY | OIUH_DEC11_2 | DEC | 11 | 2 | JE Transaction Quantity | ||
19 | ![]() |
OIUH_OWNER_MMBTU | OIUH_DEC11_2 | DEC | 11 | 2 | Owner MMBTU | ||
20 | ![]() |
OIUH_GROSS_PLANT_VOLUME_RED_AM | OIUH_DEC11_2 | DEC | 11 | 2 | Gross Plant Volume Reduction amount | ||
21 | ![]() |
OIUH_OWNER_PLANT_VOLUME_RED_AM | OIUH_DEC11_2 | DEC | 11 | 2 | Owner Plant Volume Reduction amount | ||
22 | ![]() |
OIUH_DED_REIMB_AMOUNT | OIUH_CURR11_2 | CURR | 11 | 2 | Deduction/Reimbursement Amount | ||
23 | ![]() |
OIUX3_MARKETING_COST | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Marketing Cost | ||
24 | ![]() |
OIUX3_MARKETING_COST | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Marketing Cost | ||
25 | ![]() |
OIUH_TAX_REIMBURSEMENT_AMT | OIUH_CURR11_2 | CURR | 11 | 2 | Tax Reimbursement Amount | ||
26 | ![]() |
OIUH_BTU_QUANTITY | OIUH_DEC7_3 | DEC | 7 | 3 | BTU Quantity | ||
27 | ![]() |
0 | 0 | Royalty 2.0 - TX GLO - Royalty Transactions Non-Key Validate | |||||
28 | ![]() |
OIUY3_TX_ORIGINAL_REPORT | OIUY3_TX_ORIGINAL_REPORT | CHAR | 1 | 0 | Royalty 2.0 - TX GLOTAMU - Original Report | ||
29 | ![]() |
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 | ![]() |
OIUY3_TX_MASTER_LEVEL | CHAR | 1 | 0 | Royalty 2.0 - TX GLO - Master Level | |||
31 | ![]() |
OIUY3_TX_RRC_LEVEL | CHAR | 1 | 0 | Royalty 2.0 - TX GLO - RRC Master Level | |||
32 | ![]() |
OIUY3_TX_PURCHASER_ID | NUMC | 11 | 0 | Royalty 2.0 - Texas GLO/TAMU - Purchaser ID | |||
33 | ![]() |
OIUY3_TX_OPERATOR_ID | OIUY3_TX_ID | CHAR | 10 | 0 | Royalty 2.0 - TX GLO - Operator ID | ||
34 | ![]() |
0 | 0 | Royalty 2,.0 - TX GLO/TAMU - Master Sub Key | |||||
35 | ![]() |
OIUY3_TX_GLO_LEASE | OIUY3_TX_GLO_LEASE | NUMC | 6 | 0 | Royalty 2.0 - TX GLO/TAMU Lease | OIUY3_TX_LEASE | |
36 | ![]() |
OIUY3_TX_GLO_UNIT_NO | CHAR | 4 | 0 | Royalty 2.0 - Texas GLO/TAMU - Unit Number | OIUY3_TX_UNIT | ||
37 | ![]() |
OIUY3_TX_ROYALTY_DECIMAL | OIU_PERCENT98 | DEC | 9 | 8 | Royalty 2.0 - Texas GLO - Royalty Decimal | ||
38 | ![]() |
OIUY3_TX_UNIT_VNAME | YESNO | CHAR | 1 | 0 | Roy 2.0 - Texas GLO/TAMU - Unit Venture | ||
39 | ![]() |
0 | 0 | Royalty 2.0 - TX GLO/TAMU - Master Non-Key Fields | |||||
40 | ![]() |
OIUY3_TX_ALLOCATION_PERCENT | OIU_PERCENT98 | DEC | 9 | 8 | Royalty 2.0 - TX GLO/TAMU - Allocation Percent | ||
41 | ![]() |
OIUY3_TX_TRACT_PART_FACTOR | OIU_PERCENT98 | DEC | 9 | 8 | Royalty 2.0 - Texas GLO - Tract Participation Factor | ||
42 | ![]() |
0 | 0 | Royalty 2.0 - TX GLO/TAMU - RRC Master Non-Key Fields | |||||
43 | ![]() |
OIUY3_TX_GLO_DISTRICT_NO | CHAR | 2 | 0 | Royalty 2.0 - TX GLO/TAMU - District Number | |||
44 | ![]() |
OIUY3_TX_GLO_RRC_OIL_LEASE_NO | CHAR | 5 | 0 | Royalty 2.0 - TX GLO/TAMU - RRC Oil Lease Number | |||
45 | ![]() |
OIUY3_TX_GLO_RRC_GAS_WELL_ID | CHAR | 6 | 0 | Royalty 2.0 - TX GLO/TAMU - RRC Gas Well ID | |||
46 | ![]() |
OIUY3_TX_GLO_RRC_DRILLING_PERM | CHAR | 6 | 0 | Royalty 2.0 - TX GLO/TAMU - RRC Drilling Permit | |||
47 | ![]() |
OIUY3_TX_GLO_RRC_FIELD_NAME | CHAR | 32 | 0 | Royalty 2.0 - TX GLO/TAMU - RRC Field Name | |||
48 | ![]() |
OIUY3_TX_GLO_RRC_LEASE_NAME | CHAR | 32 | 0 | Royalty 2.0 - TX GLO/TAMU - RRC Lease Name | |||
49 | ![]() |
OIUY3_TX_GLO_PROP_ALIAS_NAME | CHAR | 32 | 0 | Royalty 2.0 - TX GLO/TAMU - Property Alias Name | |||
50 | ![]() |
OIUY3_OPERATOR_NUMBER | OIUCM_BUS_ASSOC | CHAR | 6 | 0 | Royalty 2.0 - TX GLO/TAMU - Operator Number | OIUH_CM_BA | |
51 | ![]() |
OIUY3_OPERATOR_SEQUENCE_NUMBER | OIUCM_SEQ_NO | CHAR | 2 | 0 | Royalty 2.0 - TX GLO - Operator Sequence Number | ||
52 | ![]() |
OIUY3_TX_PAY_REPORT_FLAG | OIUY3_TX_PAY_REPORT_FLAG | CHAR | 1 | 0 | Royalty 2.0 - TX GLO/TAMU - Pay/Report Flag | ||
53 | ![]() |
OIURV_DOCNR | OIU_MP_NO | CHAR | 20 | 0 | Val. document number | * | |
54 | ![]() |
OIU_DOC_YEAR | GJAHR | NUMC | 4 | 0 | Document year | ||
55 | ![]() |
OIUY3_TX_INTERFACE_FL | OIUY3_TX_EXT_UPDATE | CHAR | 1 | 0 | Royalty 2.0 - TX GLO - Interface Flag | ||
56 | ![]() |
CHAR | 1 | 0 | |||||
57 | ![]() |
CHAR | 1 | 0 | |||||
58 | ![]() |
CHAR | 1 | 0 | |||||
59 | ![]() |
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 | ![]() |
![]() |
|||
2 | ROIUY3_TX_ROYTXN_NONKEY | GLO_UNIT_NO | ![]() |
![]() |
KEY | ||
3 | ROIUY3_TX_ROYTXN_NONKEY | OPERATOR_NO | ![]() |
![]() |
|||
4 | ROIUY3_TX_ROYTXN_NONKEY | UOM | ![]() |
![]() |
REF |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 100 |