1 |
MANDT |
|
MANDT |
MANDT |
CLNT |
3 |
0 |
Client |
T000 |
2 |
.INCLUDE |
|
|
|
|
0 |
0 |
Royalty 2.0 - WY - Royalty Transactions Key Fields |
|
3 |
.INCLUDE |
|
|
|
|
0 |
0 |
Royalty 2.0 - WY - Royalty Reversal Key Fields |
|
4 |
BUKRS |
|
BUKRS |
BUKRS |
CHAR |
4 |
0 |
Company Code |
OIU_CM_COMPC |
5 |
SALES_DT |
|
OIU_SALE_DT |
DATUM |
DATS |
8 |
0 |
Sales Date / Month |
|
6 |
PDCD |
|
OIU_FULL_PD_CD |
OIU_FULL_PD_CD |
CHAR |
3 |
0 |
Full three char. product code (Major and Detail Products) |
OIUX3_PDCD |
7 |
WL_NO |
|
OIU_WL_NO |
OIU_WL_NO |
CHAR |
15 |
0 |
Well ID number |
OIU_PR_WELL |
8 |
WC_NO |
|
OIU_WC_NO |
OIU_WC_NO |
CHAR |
5 |
0 |
Well Completion Number |
OIU_PR_WC |
9 |
MP_NO |
|
OIU_MP_NO |
OIU_MP_NO |
CHAR |
20 |
0 |
Measurement point number |
OIU_PR_MP |
10 |
VNAME |
|
JV_NAME |
JV_NAME |
CHAR |
6 |
0 |
Joint venture |
OIU_DO_JV |
11 |
DOI_NO |
|
OIU_DOI_NO |
OIU_DOI_NO |
CHAR |
5 |
0 |
Division of interest (DOI) |
OIU_DO_DI |
12 |
DN_NO |
|
OIU_DN_NO |
OIU_DN_NO |
CHAR |
20 |
0 |
Delivery network number |
OIU_PR_DN |
13 |
CT_NO |
|
OIU_CT_NO |
OIUCM_CONTRACT_NUMBER |
CHAR |
10 |
0 |
Contract Number |
OIU_RV_CT |
14 |
VL_TYPE_CD |
|
OIU_VT_CD |
OIU_VL_TYPE_CD |
CHAR |
2 |
0 |
Volume type code |
OIU_PR_VLTYP |
15 |
OWNER_IDENTIFIER |
|
OIUYC_OWNER_IDENTIFIER |
|
CHAR |
22 |
0 |
Royalty 2.0 - Owner Identifier |
|
16 |
REV_BOOK_ADJ_IND |
|
OIUY6_REV_BOOK_REVADJ_ADJ_IND |
OIUY6_REV_BOOK_REVADJ_ADJ_IND |
CHAR |
1 |
0 |
Royalty 2.0 - WY - Reversal/Booking/Reversal Adjustment/Adjs |
|
17 |
.INCLUDE |
|
|
|
|
0 |
0 |
Royalty 2.0 - WY - Royalty Transactions Non-Key Fields |
|
18 |
UNIT_VNAME |
|
JV_NAME |
JV_NAME |
CHAR |
6 |
0 |
Joint venture |
OIU_DO_JV |
19 |
ACCT_NO |
|
OIUH_ACCTID |
CHAR10 |
CHAR |
10 |
0 |
Account ID |
|
20 |
UOM |
|
OIU_MEAS_U |
MEINS |
UNIT |
3 |
0 |
Measurement unit |
T006 |
21 |
GR_QY |
|
OIUX3_GROSS_VOLUME |
OIUX3_SIGNED_DEC_11_2 |
DEC |
11 |
2 |
Gross Volume |
|
22 |
GR_AM |
|
OIUX3_GROSS_VALUE |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Gross Value |
|
23 |
DED_RMB_AM |
|
OIUH_DED_REIMB_AMOUNT |
OIUH_CURR11_2 |
CURR |
11 |
2 |
Deduction/Reimbursement Amount |
|
24 |
TAX_RMB_AM |
|
OIUH_TAX_REIMBURSEMENT_AMT |
OIUH_CURR11_2 |
CURR |
11 |
2 |
Tax Reimbursement Amount |
|
25 |
NET_TRANSP_AM |
|
OIUX3_MARKETING_COST |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Marketing Cost |
|
26 |
NET_OTH_MK_AM |
|
OIUX3_MARKETING_COST |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Marketing Cost |
|
27 |
MKT_COST_01 |
|
OIUX3_MARKETING_COST |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Marketing Cost |
|
28 |
MKT_COST_02 |
|
OIUX3_MARKETING_COST |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Marketing Cost |
|
29 |
MKT_COST_03 |
|
OIUX3_MARKETING_COST |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Marketing Cost |
|
30 |
MKT_COST_04 |
|
OIUX3_MARKETING_COST |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Marketing Cost |
|
31 |
MKT_COST_05 |
|
OIUX3_MARKETING_COST |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Marketing Cost |
|
32 |
MKT_COST_06 |
|
OIUX3_MARKETING_COST |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Marketing Cost |
|
33 |
MKT_COST_07 |
|
OIUX3_MARKETING_COST |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Marketing Cost |
|
34 |
MKT_COST_08 |
|
OIUX3_MARKETING_COST |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Marketing Cost |
|
35 |
MKT_COST_09 |
|
OIUX3_MARKETING_COST |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Marketing Cost |
|
36 |
MKT_COST_10 |
|
OIUX3_MARKETING_COST |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Marketing Cost |
|
37 |
TXN_VAL_AM |
|
OIUY6_WY_OWNER_GROSS_VALUE |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Royalty 2.0 - WY - Owner Gross Value |
|
38 |
OWN_INT_DECM_QY |
|
OIUY6_WY_OWNER_NRI |
OIU_PERCENT98 |
DEC |
9 |
8 |
Royalty 2.0 - Wyoming - Owner NRI |
|
39 |
TRANS_AM |
|
OIUX3_TRANS_AMT |
OIUX3_SIGNED_DEC_11_2 |
DEC |
11 |
2 |
JE Transaction Amount |
|
40 |
TRANS_QY |
|
OIUH_TRANS_QUANTITY |
OIUH_DEC11_2 |
DEC |
11 |
2 |
JE Transaction Quantity |
|
41 |
BTU_QY |
|
OIUH_BTU_QUANTITY |
OIUH_DEC7_3 |
DEC |
7 |
3 |
BTU Quantity |
|
42 |
PS_BASE_QY |
|
OIUH_PRESSURE_BASE |
OIUH_DEC6_3 |
DEC |
6 |
3 |
Pressure Base Quantity |
|
43 |
GRV_QY |
|
OIUH_GRAVITY |
OIUH_DEC3_1 |
DEC |
3 |
1 |
Gravity |
|
44 |
PAY_CD |
|
OIUH_PAY_CODE |
CHAR2 |
CHAR |
2 |
0 |
Pay Code |
|
45 |
OWN_BAL_DECM_QY |
|
OIUH_OWNER_DISBUR_DECIMAL |
OIUH_DEC9_8 |
DEC |
9 |
8 |
Owner Disbursement (Balance) Decimal |
|
46 |
MMBTU_OVL_AM |
|
OIUH_OWNER_MMBTU |
OIUH_DEC11_2 |
DEC |
11 |
2 |
Owner MMBTU |
|
47 |
OPERATED_FL |
|
OIUY6_OPERATED_FLAG |
YESNO |
CHAR |
1 |
0 |
Royalty 2.0 - WY - Operated Flag |
|
48 |
OPERATOR_NAME |
|
OIUY6_WY_OPERATOR_NAME |
CHAR38 |
CHAR |
38 |
0 |
Royalty 2.0 - WY - Operator Name |
|
49 |
.INCLUDE |
|
|
|
|
0 |
0 |
Royalty 2,.0 - WY - Master Sub Key |
|
50 |
STATE_LEASE_NO |
|
OIUY6_WY_STATE_LEASE_NO |
|
CHAR |
15 |
0 |
Royalty 2.0 - Wyoming - State Lease Number |
|
51 |
UNIQUE_ID |
|
OIUY6_WY_UNIQUE_IDENTIFIER |
|
CHAR |
20 |
0 |
Royalty 2.0 - Wyoming - PSA |
|
52 |
.INCLUDE |
|
|
|
|
0 |
0 |
Royalty 2.0 - Wyoming Master Non-Key Fields |
|
53 |
REPORT_ONLY |
|
OIUY6_WY_REPORT_ONLY_FL |
YESNO |
CHAR |
1 |
0 |
Royalty 2.0 - WY - Report Only Flag |
|
54 |
OVERRIDE_FL |
|
OIUY6_WY_OVERRIDE_OPERATED_FL |
OIUY6_WY_OVERRIDE_OPERATED_FL |
CHAR |
1 |
0 |
Royalty 2.0 - WY - Override Operated Flag |
|
55 |
TRACT_ALLOC_LSE |
|
OIUY6_WY_TRACT_ALLOC_TO_LEASE |
OIU_PERCENT98 |
DEC |
9 |
8 |
Royalty 2.0 - Wyoming - Tract Allocation to Lease |
|
56 |
ROYALTY_RATE |
|
OIUY6_WY_ROYALTY_RATE |
OIU_PERCENT98 |
DEC |
9 |
8 |
Royalty 2.0 - Wyoming - Royalty Rate |
|
57 |
ALLOC_PERCENT |
|
OIUY6_WY_ALLOCATION_PERCENT |
OIU_PERCENT98 |
DEC |
9 |
8 |
Royalty 2.0 - Wyoming - Allocation Percent |
|
58 |
REFERENCE_FIELD |
|
OIUY6_WY_REFERENCE_FIELD |
|
CHAR |
20 |
0 |
Royalty 2.0 - WY - Reference Field |
|
59 |
ALTERNATE_PSA |
|
OIUY6_WY_ALTERNATE_PSA |
|
CHAR |
20 |
0 |
Royalty 2.0 - Wyoming - Alternate PSA |
|
60 |
CTRACT_ALLOC_LSE |
|
OIUY6_WY_CALC_TRACT_ALLOC_LSE |
OIU_PERCENT98 |
DEC |
9 |
8 |
Royalty 2.0 - Wyoming - Calculated Tract Allocation to Lease |
|
61 |
MASTER_LEVEL |
|
OIUY6_WY_MASTER_LEVEL |
|
CHAR |
1 |
0 |
Royalty 2.0 - WY - Master Level |
|
62 |
WY_PDCD |
|
OIUY6_WY_PRODUCT_CODE |
OIUY6_WY_PRODUCT_CODE |
NUMC |
3 |
0 |
Royalty 2.0 - Wyoming - Product Code |
|
63 |
PAYER_CODE |
|
OIUY6_WY_PAYER_CODE |
OIUY6_WY_COMPANY_ID |
NUMC |
4 |
0 |
Royalty 2.0 - Wyoming - Payer Code |
|
64 |
ORIGINAL_REPORT |
|
OIUY6_WY_ORIGINAL_REPORT |
YESNO |
CHAR |
1 |
0 |
Royalty 2.0 - WY - Original Report |
|
65 |
DOC_NO |
|
OIURV_DOCNR |
OIU_MP_NO |
CHAR |
20 |
0 |
Val. document number |
* |
66 |
DOC_YEAR |
|
OIU_DOC_YEAR |
GJAHR |
NUMC |
4 |
0 |
Document year |
|
67 |
INTERFACE_FL |
|
OIUY6_WY_INTERFACE_FL |
OIUY6_WY_EXT_UPDATE |
CHAR |
1 |
0 |
Royalty 2.0 - WY - Interface Flag |
|
68 |
OPTION1 |
|
|
|
CHAR |
1 |
0 |
|
|
69 |
OPTION2 |
|
|
|
CHAR |
1 |
0 |
|
|
70 |
OPTION3 |
|
|
|
CHAR |
1 |
0 |
|
|
71 |
REJ_SUSP_IND |
|
OIUX3_REJECT_SUSPEND_IND |
OIUX3_REJECT_SUSPEND_IND |
CHAR |
1 |
0 |
Tax Reporting - Reject/Suspend Indicator |
|
72 |
REJ_CD |
|
OIUY6_WY_REJECT_CODE |
OIUY6_WY_REJECT_CODE |
CHAR |
2 |
0 |
Royalty 2.0 - WY - Reject Code |
OIUY6_WY_REJ |
73 |
.INCLUDE |
|
|
|
|
0 |
0 |
Creator and date/time created |
|
74 |
OIU_CRUSER |
|
ERNAM |
USNAM |
CHAR |
12 |
0 |
Name of Person who Created the Object |
|
75 |
OIU_TIMESTAMP |
|
TZNTSTMPS |
TZNTSTMPS |
DEC |
15 |
0 |
UTC Time Stamp in Short Form (YYYYMMDDhhmmss) |
|