SAP ABAP Table ROIUY3_TX_PRDT_TC (Royalty 2.0 - TX GLO/TAMU - PRA Detail Transactions Struct)
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
⤷ 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_PRDT_TC | Table Relationship Diagram |
Short Description | Royalty 2.0 - TX GLO/TAMU - PRA Detail Transactions Struct |
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 | .INCLUDE | 0 | 0 | Royalty 2.0 - TX GLO - Royalty PRA Details | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | RUN_ID | OIUX3_RUN_ID | NUMC10 | NUMC | 10 | 0 | Tax Reporting - Run ID | ||
4 | .INCLUDE | 0 | 0 | Royalty 2.0 - TX GLO - Royalty Transactions Key Fields | |||||
5 | .INCLUDE | 0 | 0 | Royalty 2.0 - TX GLO - Royalty Reversal Key Fields | |||||
6 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | OIU_CM_COMPC | |
7 | SALES_DT | OIU_SALE_DT | DATUM | DATS | 8 | 0 | Sales Date / Month | ||
8 | PDCD | OIU_FULL_PD_CD | OIU_FULL_PD_CD | CHAR | 3 | 0 | Full three char. product code (Major and Detail Products) | OIUX3_PDCD | |
9 | WL_NO | OIU_WL_NO | OIU_WL_NO | CHAR | 15 | 0 | Well ID number | OIU_PR_WELL | |
10 | WC_NO | OIU_WC_NO | OIU_WC_NO | CHAR | 5 | 0 | Well Completion Number | OIU_PR_WC | |
11 | MP_NO | OIU_MP_NO | OIU_MP_NO | CHAR | 20 | 0 | Measurement point number | OIU_PR_MP | |
12 | VNAME | JV_NAME | JV_NAME | CHAR | 6 | 0 | Joint venture | OIU_DO_JV | |
13 | DOI_NO | OIU_DOI_NO | OIU_DOI_NO | CHAR | 5 | 0 | Division of interest (DOI) | OIU_DO_DI | |
14 | DN_NO | OIU_DN_NO | OIU_DN_NO | CHAR | 20 | 0 | Delivery network number | OIU_PR_DN | |
15 | CT_NO | OIU_CT_NO | OIUCM_CONTRACT_NUMBER | CHAR | 10 | 0 | Contract Number | OIU_RV_CT | |
16 | VL_TYPE_CD | OIU_VT_CD | OIU_VL_TYPE_CD | CHAR | 2 | 0 | Volume type code | OIU_PR_VLTYP | |
17 | OWNER_IDENTIFIER | OIUYC_OWNER_IDENTIFIER | CHAR | 22 | 0 | Royalty 2.0 - Owner Identifier | |||
18 | REV_BOOK_ADJ_IND | OIUY3_REV_BOOK_REVADJ_ADJ_IND | OIUY3_REV_BOOK_REVADJ_ADJ_IND | CHAR | 1 | 0 | Royalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjs | ||
19 | OUT_OF_STATUTE | OIUX3_OUT_OF_STATUTE | YESNO | CHAR | 1 | 0 | Tax Reporting - Out Of Statute Flag | ||
20 | .INCLUDE | 0 | 0 | Royalty 2.0 - TX GLO - Royalty Transactions Non-Key Fields | |||||
21 | UNIT_VNAME | JV_NAME | JV_NAME | CHAR | 6 | 0 | Joint venture | * | |
22 | ACCT_NO | OIUH_ACCTID | CHAR10 | CHAR | 10 | 0 | Account ID | ||
23 | CHV_RPT_CD | RKOSTL | KOSTL | CHAR | 10 | 0 | Template cost center | * | |
24 | UOM | OIU_MEAS_U | MEINS | UNIT | 3 | 0 | Measurement unit | T006 | |
25 | PS_BASE_QY | OIUH_PRESSURE_BASE | OIUH_DEC6_3 | DEC | 6 | 3 | Pressure Base Quantity | ||
26 | GRV_QY | OIUH_GRAVITY | OIUH_DEC3_1 | DEC | 3 | 1 | Gravity | ||
27 | PAY_CD | OIUH_PAY_CODE | CHAR2 | CHAR | 2 | 0 | Pay Code | ||
28 | OWN_INT_DECM_QY | OIUY3_TX_OWNER_NRI | OIU_PERCENT98 | DEC | 9 | 8 | Royalty 2.0 - TX GLO - Owner NRI | ||
29 | OWN_BAL_DECM_QY | OIUH_OWNER_DISBUR_DECIMAL | OIUH_DEC9_8 | DEC | 9 | 8 | Owner Disbursement (Balance) Decimal | ||
30 | PU_NO | OIUH_PURCHASER | CHAR6 | CHAR | 6 | 0 | Purchaser ID | ||
31 | PU_SEQ_NO | OIUH_PURCHASER_SEQUENCE_NUMBER | CHAR2 | CHAR | 2 | 0 | Purchaser Sequence Number | ||
32 | AFFILIATED_SALE | OIUY3_TX_AFFILIATED_SALE_IND | YESNO | CHAR | 1 | 0 | Royalty 2.0 - TX GLO - Affiliated Sale Indicator | ||
33 | .INCLUDE | 0 | 0 | Royalty 2.0 - TX GLO - Royalty Transactions Non-Key Vol/Val | |||||
34 | GR_QY | OIUX3_GROSS_VOLUME | OIUX3_SIGNED_DEC_11_2 | DEC | 11 | 2 | Gross Volume | ||
35 | GR_AM | OIUX3_GROSS_VALUE | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Gross Value | ||
36 | TXN_VAL_AM | OIUY3_TX_OWNER_GROSS_VALUE | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Royalty 2.0 - TX GLO - Owner Gross Value | ||
37 | TRANS_AM | OIUX3_TRANS_AMT | OIUX3_SIGNED_DEC_11_2 | DEC | 11 | 2 | JE Transaction Amount | ||
38 | TRANS_QY | OIUH_TRANS_QUANTITY | OIUH_DEC11_2 | DEC | 11 | 2 | JE Transaction Quantity | ||
39 | MMBTU_OVL_AM | OIUH_OWNER_MMBTU | OIUH_DEC11_2 | DEC | 11 | 2 | Owner MMBTU | ||
40 | PLT_VL_GRED_AM | OIUH_GROSS_PLANT_VOLUME_RED_AM | OIUH_DEC11_2 | DEC | 11 | 2 | Gross Plant Volume Reduction amount | ||
41 | PLT_VL_ORED_AM | OIUH_OWNER_PLANT_VOLUME_RED_AM | OIUH_DEC11_2 | DEC | 11 | 2 | Owner Plant Volume Reduction amount | ||
42 | DED_RMB_AM | OIUH_DED_REIMB_AMOUNT | OIUH_CURR11_2 | CURR | 11 | 2 | Deduction/Reimbursement Amount | ||
43 | NET_TRANSP_AM | OIUX3_MARKETING_COST | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Marketing Cost | ||
44 | NET_OTH_MK_AM | OIUX3_MARKETING_COST | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Marketing Cost | ||
45 | TAX_RMB_AM | OIUH_TAX_REIMBURSEMENT_AMT | OIUH_CURR11_2 | CURR | 11 | 2 | Tax Reimbursement Amount | ||
46 | BTU_QY | OIUH_BTU_QUANTITY | OIUH_DEC7_3 | DEC | 7 | 3 | BTU Quantity | ||
47 | .INCLUDE | 0 | 0 | Royalty 2.0 - TX GLO - Royalty Transactions Non-Key Validate | |||||
48 | ORIGINAL_REPORT | OIUY3_TX_ORIGINAL_REPORT | OIUY3_TX_ORIGINAL_REPORT | CHAR | 1 | 0 | Royalty 2.0 - TX GLOTAMU - Original Report | ||
49 | 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 | ||
50 | MASTER_LEVEL | OIUY3_TX_MASTER_LEVEL | CHAR | 1 | 0 | Royalty 2.0 - TX GLO - Master Level | |||
51 | RRC_LEVEL | OIUY3_TX_RRC_LEVEL | CHAR | 1 | 0 | Royalty 2.0 - TX GLO - RRC Master Level | |||
52 | PURCHASER_ID | OIUY3_TX_PURCHASER_ID | NUMC | 11 | 0 | Royalty 2.0 - Texas GLO/TAMU - Purchaser ID | |||
53 | OPERATOR_ID | OIUY3_TX_OPERATOR_ID | OIUY3_TX_ID | CHAR | 10 | 0 | Royalty 2.0 - TX GLO - Operator ID | ||
54 | .INCLUDE | 0 | 0 | Royalty 2,.0 - TX GLO/TAMU - Master Sub Key | |||||
55 | GLO_LEASE | OIUY3_TX_GLO_LEASE | OIUY3_TX_GLO_LEASE | NUMC | 6 | 0 | Royalty 2.0 - TX GLO/TAMU Lease | OIUY3_TX_LEASE | |
56 | GLO_UNIT_NO | OIUY3_TX_GLO_UNIT_NO | CHAR | 4 | 0 | Royalty 2.0 - Texas GLO/TAMU - Unit Number | OIUY3_TX_UNIT | ||
57 | ROYALTY_DECIMAL | OIUY3_TX_ROYALTY_DECIMAL | OIU_PERCENT98 | DEC | 9 | 8 | Royalty 2.0 - Texas GLO - Royalty Decimal | ||
58 | UNIT_VNAME_FLAG | OIUY3_TX_UNIT_VNAME | YESNO | CHAR | 1 | 0 | Roy 2.0 - Texas GLO/TAMU - Unit Venture | ||
59 | .INCLUDE | 0 | 0 | Royalty 2.0 - TX GLO/TAMU - Master Non-Key Fields | |||||
60 | ALLOC_PERCENT | OIUY3_TX_ALLOCATION_PERCENT | OIU_PERCENT98 | DEC | 9 | 8 | Royalty 2.0 - TX GLO/TAMU - Allocation Percent | ||
61 | TRACT_PART_FACT | OIUY3_TX_TRACT_PART_FACTOR | OIU_PERCENT98 | DEC | 9 | 8 | Royalty 2.0 - Texas GLO - Tract Participation Factor | ||
62 | .INCLUDE | 0 | 0 | Royalty 2.0 - TX GLO/TAMU - RRC Master Non-Key Fields | |||||
63 | RRC_DISTRICT_NO | OIUY3_TX_GLO_DISTRICT_NO | CHAR | 2 | 0 | Royalty 2.0 - TX GLO/TAMU - District Number | |||
64 | RRC_OIL_LEASE_NO | OIUY3_TX_GLO_RRC_OIL_LEASE_NO | CHAR | 5 | 0 | Royalty 2.0 - TX GLO/TAMU - RRC Oil Lease Number | |||
65 | RRC_GAS_WELL_ID | OIUY3_TX_GLO_RRC_GAS_WELL_ID | CHAR | 6 | 0 | Royalty 2.0 - TX GLO/TAMU - RRC Gas Well ID | |||
66 | RRC_DRILL_PERMIT | OIUY3_TX_GLO_RRC_DRILLING_PERM | CHAR | 6 | 0 | Royalty 2.0 - TX GLO/TAMU - RRC Drilling Permit | |||
67 | RRC_FIELD_NAME | OIUY3_TX_GLO_RRC_FIELD_NAME | CHAR | 32 | 0 | Royalty 2.0 - TX GLO/TAMU - RRC Field Name | |||
68 | RRC_LEASE_NAME | OIUY3_TX_GLO_RRC_LEASE_NAME | CHAR | 32 | 0 | Royalty 2.0 - TX GLO/TAMU - RRC Lease Name | |||
69 | PROP_ALIAS_NAME | OIUY3_TX_GLO_PROP_ALIAS_NAME | CHAR | 32 | 0 | Royalty 2.0 - TX GLO/TAMU - Property Alias Name | |||
70 | OPERATOR_NO | OIUY3_OPERATOR_NUMBER | OIUCM_BUS_ASSOC | CHAR | 6 | 0 | Royalty 2.0 - TX GLO/TAMU - Operator Number | OIUH_CM_BA | |
71 | OPERATOR_SEQ_NO | OIUY3_OPERATOR_SEQUENCE_NUMBER | OIUCM_SEQ_NO | CHAR | 2 | 0 | Royalty 2.0 - TX GLO - Operator Sequence Number | ||
72 | 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 | ||
73 | DOC_NO | OIURV_DOCNR | OIU_MP_NO | CHAR | 20 | 0 | Val. document number | * | |
74 | DOC_YEAR | OIU_DOC_YEAR | GJAHR | NUMC | 4 | 0 | Document year | ||
75 | INTERFACE_FL | OIUY3_TX_INTERFACE_FL | OIUY3_TX_EXT_UPDATE | CHAR | 1 | 0 | Royalty 2.0 - TX GLO - Interface Flag | ||
76 | OPTION1 | CHAR | 1 | 0 | |||||
77 | OPTION2 | CHAR | 1 | 0 | |||||
78 | OPTION3 | CHAR | 1 | 0 | |||||
79 | REFERENCE_RUN_ID | OIUX3_RUN_ID | NUMC10 | NUMC | 10 | 0 | Tax Reporting - Run ID | ||
80 | .INCLUDE | 0 | 0 | Creator and date/time created | |||||
81 | OIU_CRUSER | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
82 | OIU_TIMESTAMP | TZNTSTMPS | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
83 | SEL | FLAG | FLAG | CHAR | 1 | 0 | General Flag |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ROIUY3_TX_PRDT_TC | BUKRS | OIU_CM_COMPC | BUKRS | KEY | ||
2 | ROIUY3_TX_PRDT_TC | CT_NO | OIU_RV_CT | CT_NO | KEY | ||
3 | ROIUY3_TX_PRDT_TC | DN_NO | OIU_PR_DN | DN_NO | KEY | ||
4 | ROIUY3_TX_PRDT_TC | DOI_NO | OIU_DO_DI | DOI_NO | KEY | ||
5 | ROIUY3_TX_PRDT_TC | GLO_LEASE | OIUY3_TX_LEASE | GLO_LEASE | |||
6 | ROIUY3_TX_PRDT_TC | GLO_UNIT_NO | OIUY3_TX_UNIT | GLO_UNIT_NO | KEY | ||
7 | ROIUY3_TX_PRDT_TC | MANDT | T000 | MANDT | KEY | ||
8 | ROIUY3_TX_PRDT_TC | MP_NO | OIU_PR_MP | MP_NO | KEY | ||
9 | ROIUY3_TX_PRDT_TC | OPERATOR_NO | OIUH_CM_BA | BA_BA_NO | |||
10 | ROIUY3_TX_PRDT_TC | PDCD | OIUX3_PDCD | PDCD | KEY | ||
11 | ROIUY3_TX_PRDT_TC | UOM | T006 | MSEHI | REF | ||
12 | ROIUY3_TX_PRDT_TC | VL_TYPE_CD | OIU_PR_VLTYP | VL_TYPE_CD | KEY | ||
13 | ROIUY3_TX_PRDT_TC | VNAME | OIU_DO_JV | VNAME | KEY | ||
14 | ROIUY3_TX_PRDT_TC | WC_NO | OIU_PR_WC | WC_NO | KEY | ||
15 | ROIUY3_TX_PRDT_TC | WL_NO | OIU_PR_WELL | WL_NO | KEY |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 100 |