| 1 | MANDT | Client | MANDT | | CLNT | 000003 | 000000 | |
| 2 | LESSOR_CD | ONRR-2014 - Lessor Code | /PRA/FP_LESSOR_CODE | | CHAR | 000001 | 000000 | |
| | |
|
| 3 | PRODUCT_CD | ONRR-2014 - Product Code | /PRA/FP_PRODUCT_CODE | | CHAR | 000002 | 000000 | |
| Possible Values | 65 | Yello Wax | | 38 | Geothermal - Commercially Demineralized H2O | | 22 | Helium | | 39 | Coalbed Methane | | 01 | Oil | | 36 | Geothermal - Direct Utilitzation, Hundreds of Gallons | | 17 | Carbon Dioxide Gas (CO2) | | 63 | Asphaltic | | 25 | Geothermal - Hot Water | | 12 | Flash Gas | | 62 | Sour | | 34 | Geothermal - Electrical Generation, Other | | 02 | Condensate | | 26 | Geothermal - Effluent Disposal | | 13 | Fuel Oil | | 33 | Geothermal - Electrical Generation, Millions of BTUs | | 37 | Geothermal - Direct Utilitzation, Other | | 03 | Processed (Residue) Gas | | 35 | Geothermal - Direct Utilitzation, Millions of BTUs | | 61 | Sweet | | 04 | Unprocessed (Wet) Gas | | 20 | Other Liquid Hydrocarbons | | 09 | Nitrogen | | 32 | Geothermal - Electrical Generation, Thousands of Pounds | | 27 | Geothermal - Steam | | 06 | Inlet Scrubber | | 07 | Gas Plant Products | | 15 | Fuel Gas | | 16 | Gas Lost - Flared or Vented | | 19 | Sulfur | | 31 | Geothermal - Electrical Generation, Kilowatt Hours | | 05 | Drip or Scrubber Condensate | | 64 | Black Wax | | 14 | Oil Lost |
| |
|
| 4 | SALES_TYPE_CD | ONRR-2014 - Sales Type Code | /PRA/FP_SALES_TYPE_CODE | OIUREP_SALESTY | CHAR | 000004 | 000000 | |
| 5 | SALE_DT | Sales Date / Month | OIU_SALE_DT | | DATS | 000008 | 000000 | |
| 6 | TRANSACTION_CD | ONRR-2014 - Transaction Code | /PRA/FP_TRANSACTION_CODE | | CHAR | 000002 | 000000 | |
| Possible Values | 11 | Transportation Allowance | | 06 | Royalty In Kind Transaction - No Cash Payment to MMS | | 01 | Royalty Due | | 42 | Net Revenue Share Lease, Allot. for Operating Cost | | 33 | Recoup Advance Royalty (Solids Only) | | 67 | Bonus Rental | | 25 | Recoup Advance Rental Credit | | 39 | Net Profit Share - Unprofitable | | 03 | Estimated Royalty Due | | 04 | Rental Payment | | 12 | Tax Cedit | | 40 | Net Profit - Profitable | | 21 | Interest Amount Due MMS | | 02 | Minimum Royalty Due | | 51 | Indian Recoupable Taken (Indian Leases Only) | | 31 | Contract Settlements Payment | | 38 | Additional Royalties Due for 6A9 Leases | | 14 | Tax Reimbursement Payment | | 13 | RIK Quality Bank and Gravity Bank Adjustment | | 60 | Strategic Petroleum Reserve (SPR) | | 66 | Bonus Rental | | 17 | Gas Storage Agreement - Flat Fee | | 08 | Royalty In Kind | | 19 | Gas Storage Agreement - Withdrawal Fee | | 22 | Interest Amount Owed to Payor | | 18 | Gas Storage Agreement - Injection Fee | | 70 | Bonus Rental | | 50 | Indian Recoupable Balance (Indian Leases Only) | | 20 | No Sales (Solids Only) | | 15 | Processing Allowance | | 44 | Shallow Water Deep Gas Royalty Relief | | 37 | Royalties Due In Lieu of Severance Tax | | 10 | Compensatory Royalty Payment | | 05 | Advance Rental Credit | | 41 | Offshore Deep Water Royalty Relief | | 55 | Deep Water Royalty Relief | | 53 | Effluent Injection Payment or Reimburse (Geothermal Leases) | | 07 | MMS Settlement Agreement | | 16 | Well Fees | | 32 | Advance Royalty (Solids Coal Leases Only) | | 52 | Recoup Minimum Royalty Paid In Advance (Navajo Leases) | | 54 | Geothermal Field Operations Payment or Reimbursement |
| |
|
| 7 | ROY_RATE | ONRR-2014 - Royalty Rate | /PRA/FP_ROYALTY_RATE | | CHAR | 000010 | 000000 | |
| 8 | PAY_METHOD_CD | ONRR-2014 - Payment Method Code | /PRA/FP_PAYMENT_METHOD_CODE | | CHAR | 000001 | 000000 | |
| Possible Values | 2 | Indian Direct Pay | | 3 | EFT Payment | | 5 | Checks to MMS for BIA | | 1 | Checks to MMS | | 4 | Royalty-In-Kind | | 6 | Other (reserved for future use) | | 7 | Indian Lockbox |
| |
|
| 9 | REF_TRANS_CD | ONRR-2014 - Reference Transaction Code | /PRA/FP_REF_TRANSACTION_CODE | | CHAR | 000002 | 000000 | |
| Possible Values | 11 | Transportation Allowance | | 06 | Royalty In Kind Transaction - No Cash Payment to MMS | | 01 | Royalty Due | | 42 | Net Revenue Share Lease, Allot. for Operating Cost | | 33 | Recoup Advance Royalty (Solids Only) | | 67 | Bonus Rental | | 25 | Recoup Advance Rental Credit | | 39 | Net Profit Share - Unprofitable | | 03 | Estimated Royalty Due | | 04 | Rental Payment | | 12 | Tax Cedit | | 40 | Net Profit - Profitable | | 21 | Interest Amount Due MMS | | 02 | Minimum Royalty Due | | 51 | Indian Recoupable Taken (Indian Leases Only) | | 31 | Contract Settlements Payment | | 38 | Additional Royalties Due for 6A9 Leases | | 14 | Tax Reimbursement Payment | | 13 | RIK Quality Bank and Gravity Bank Adjustment | | 60 | Strategic Petroleum Reserve (SPR) | | 66 | Bonus Rental | | 17 | Gas Storage Agreement - Flat Fee | | 08 | Royalty In Kind | | 19 | Gas Storage Agreement - Withdrawal Fee | | 22 | Interest Amount Owed to Payor | | 18 | Gas Storage Agreement - Injection Fee | | 70 | Bonus Rental | | 50 | Indian Recoupable Balance (Indian Leases Only) | | 20 | No Sales (Solids Only) | | 15 | Processing Allowance | | 44 | Shallow Water Deep Gas Royalty Relief | | 37 | Royalties Due In Lieu of Severance Tax | | 10 | Compensatory Royalty Payment | | 05 | Advance Rental Credit | | 41 | Offshore Deep Water Royalty Relief | | 55 | Deep Water Royalty Relief | | 53 | Effluent Injection Payment or Reimburse (Geothermal Leases) | | 07 | MMS Settlement Agreement | | 16 | Well Fees | | 32 | Advance Royalty (Solids Coal Leases Only) | | 52 | Recoup Minimum Royalty Paid In Advance (Navajo Leases) | | 54 | Geothermal Field Operations Payment or Reimbursement |
| |
|
| 10 | LINE_TYPE | ONRR-2014 - Line Type | /PRA/FP_LINE_TYPE | | CHAR | 000001 | 000000 | |
| | |
|
| 11 | ADJUSTMENT_CD | ONRR-2014 - Adjustment Code | /PRA/FP_ADJUSTMENT_CODE | | NUMC | 000002 | 000000 | |
| Possible Values | 10 | Adjustment | | 16 | Major Portion/Dual Accounting | | 49 | Index Zone/Dual Accounting Price Adjustment | | 26 | Change Valuation Method (Geothermal Lease Only) | | 88 | Small Royalty Write-Off | | 17 | MMS-Initiated Compliance Adjustment | | 20 | DOE Strategic Petroleum Reserve (SPR) RIK With Royalty Value | | 71 | Estimate Underpayment/Overpayment Interest | | 25 | Netback Costs True Up (Geothermal Lease Only) | | 99 | MRM-Prepared Entry | | 21 | DOE SPR Without Royalty Value | | 32 | Estimate Adjustment | | 72 | Audit Underpayment/Overpaymenr Interest | | 35 | Unit Particpating Area/Communitiazation Agr. Adjustment | | 15 | Marginal Property True Up | | 31 | Retroactive Manadatory Price Adj. (Geothermal Lease Only) |
| |
|
| 12 | SALES_MONTH | ONRR-2014 - Sales Month | /PRA/FP_SALES_MONTH | | ACCP | 000006 | 000000 | |
| 13 | DISTRIBUTEE_CD | ONRR-2014 - Distributee Code | /PRA/FP_DISTRIBUTEE_CODE | /PRA/C_FP_DIS_CD | NUMC | 000003 | 000000 | |
| 14 | TRIBAL_ALLOTTEE | ONRR-2014 - Tribal / Allottee Indicator | /PRA/FP_TRIBAL_ALLOTTEE_IND | | CHAR | 000001 | 000000 | |
| | |
|
| 15 | INDEX_ZONE | ONRR-2014 - Index Zone | /PRA/FP_INDEX_ZONE | | CHAR | 000003 | 000000 | |
| 16 | VOL_UOM | Base Unit of Measure | MEINS | T006 | UNIT | 000003 | 000000 | |
| 17 | ENERGY_UOM | Base Unit of Measure | MEINS | T006 | UNIT | 000003 | 000000 | |
| 18 | WAERS | Currency Key | WAERS | TCURC | CUKY | 000005 | 000000 | |
| 19 | BUKRS | Company Code | BUKRS | OIU_CM_COMPC | CHAR | 000004 | 000000 | |
| 20 | RPDT_AC_IND | Proc 2.0 - Amended/Current Indicator | OIUE2_AC_IND | | CHAR | 000001 | 000000 | |
| | |
|
| 21 | LEASE_NAME | ONRR-2014 - Lease Name | /PRA/FP_LEASE_NAME | | CHAR | 000020 | 000000 | |
| 22 | SALES_VOL | ONRR-2014 - Sales Volume | /PRA/FP_SALES_VOL | | QUAN | 000013 | 000003 | |
| 23 | GAS_ENERGY | ONRR-2014 - Gas Energy | /PRA/FP_GAS_ENERGY | | QUAN | 000013 | 000003 | |
| 24 | SALES_VAL | ONRR-2014 - Sales Value | /PRA/FP_SALES_VAL | | CURR | 000013 | 000002 | |
| 25 | ROY_PRIOR_ALLOW | ONRR-2014 - Royalty Value Prior To Allowance | /PRA/FP_ROY_VAL_PRIOR_TO_ALLOW | | CURR | 000013 | 000002 | |
| 26 | TRANSPORTATION | ONRR-2014 - Transportation Allowance Deduction | /PRA/FP_TRANSPORTATION_DEDUCT | | CURR | 000013 | 000002 | |
| 27 | PROCESSING | ONRR-2014 - Processing Allowance Deduction | /PRA/FP_PROCESSING_DEDUCT | | CURR | 000013 | 000002 | |
| 28 | ROY_LESS_ALLOW | ONRR-2014 - Royalty Value Less Allowance | /PRA/FP_ROY_VAL_LESS_ALLOW | | CURR | 000013 | 000002 | |
| 29 | HEAT_VAL | Heating value | OIU_HEAT_VAL | | QUAN | 000013 | 000003 | |
| 30 | HEAT_VAL_UOM | Base Unit of Measure | MEINS | T006 | UNIT | 000003 | 000000 | |
| 31 | PRICE | ONRR-2014 - Price | /PRA/FP_PRICE | | DEC | 000009 | 000006 | |
| 32 | INDEX_PRICE | ONRR-2014 - Index Price | /PRA/FP_INDEX_PRICE | | DEC | 000009 | 000006 | |
| 33 | STATUS | ONRR-2014 - Status | /PRA/FP_STATUS | | CHAR | 000001 | 000000 | |
| Possible Values | R | Rejects Exist | | W | Warnings Exist |
| |
|
| 34 | MANUAL_2014_FL | ONRR-2014 - Manual 2014 Flag | /PRA/FP_MANUAL_2014_FL | | CHAR | 000001 | 000000 | |
| | |
|
| 35 | OVR_REJECT_FL | ONRR-2014 - Override Reject Flag | /PRA/FP_OVERRIDE_REJECT_FL | | CHAR | 000001 | 000000 | |
| | |
|
| 36 | OVR_ADJ_CD | ONRR-2014 - Override Adjustment Code | /PRA/FP_OVR_ADJUSTMENT_CODE | | NUMC | 000002 | 000000 | |
| Possible Values | 10 | Adjustment | | 16 | Major Portion/Dual Accounting | | 49 | Index Zone/Dual Accounting Price Adjustment | | 26 | Change Valuation Method (Geothermal Lease Only) | | 88 | Small Royalty Write-Off | | 17 | MMS-Initiated Compliance Adjustment | | 20 | DOE Strategic Petroleum Reserve (SPR) RIK With Royalty Value | | 71 | Estimate Underpayment/Overpayment Interest | | 25 | Netback Costs True Up (Geothermal Lease Only) | | 99 | MRM-Prepared Entry | | 21 | DOE SPR Without Royalty Value | | 32 | Estimate Adjustment | | 72 | Audit Underpayment/Overpaymenr Interest | | 35 | Unit Particpating Area/Communitiazation Agr. Adjustment | | 15 | Marginal Property True Up | | 31 | Retroactive Manadatory Price Adj. (Geothermal Lease Only) |
| |
|
| 37 | TRANS_DEDUCT_ADJ | ONRR-2014 - Transportation Allowance Deduction Adjustment | /PRA/FP_TRANS_DEDUCT_ADJ | | CURR | 000013 | 000002 | |
| 38 | PROC_DEDUCT_ADJ | ONRR-2014 - Processing Allowance Deduction Adjustment | /PRA/FP_PROC_DEDUCT_ADJ | | CURR | 000013 | 000002 | |
| 39 | ROYALTY_DUE_ADJ | ONRR-2014 - Royalty Due Adjustment | /PRA/FP_ROYALTY_DUE_ADJ | | CURR | 000013 | 000002 | |
| 40 | RECALCULATE_FL | ONRR-2014: Recalculate Sales Vol/Val | /PRA/FP_RECALC_SALES_VOL_VAL | | CHAR | 000001 | 000000 | |
| | |
|
| 41 | RY_DUE_ADJ_PS_FL | ONRR-2014: Persist Royalty Due Adjustment | /PRA/FP_ROY_DUE_ADJ_PS_FL | | CHAR | 000001 | 000000 | |
| | |
|
| 42 | ORG_TRANS_CD | ONRR-2014 - Transaction Code | /PRA/FP_TRANSACTION_CODE | | CHAR | 000002 | 000000 | |
| Possible Values | 11 | Transportation Allowance | | 06 | Royalty In Kind Transaction - No Cash Payment to MMS | | 01 | Royalty Due | | 42 | Net Revenue Share Lease, Allot. for Operating Cost | | 33 | Recoup Advance Royalty (Solids Only) | | 67 | Bonus Rental | | 25 | Recoup Advance Rental Credit | | 39 | Net Profit Share - Unprofitable | | 03 | Estimated Royalty Due | | 04 | Rental Payment | | 12 | Tax Cedit | | 40 | Net Profit - Profitable | | 21 | Interest Amount Due MMS | | 02 | Minimum Royalty Due | | 51 | Indian Recoupable Taken (Indian Leases Only) | | 31 | Contract Settlements Payment | | 38 | Additional Royalties Due for 6A9 Leases | | 14 | Tax Reimbursement Payment | | 13 | RIK Quality Bank and Gravity Bank Adjustment | | 60 | Strategic Petroleum Reserve (SPR) | | 66 | Bonus Rental | | 17 | Gas Storage Agreement - Flat Fee | | 08 | Royalty In Kind | | 19 | Gas Storage Agreement - Withdrawal Fee | | 22 | Interest Amount Owed to Payor | | 18 | Gas Storage Agreement - Injection Fee | | 70 | Bonus Rental | | 50 | Indian Recoupable Balance (Indian Leases Only) | | 20 | No Sales (Solids Only) | | 15 | Processing Allowance | | 44 | Shallow Water Deep Gas Royalty Relief | | 37 | Royalties Due In Lieu of Severance Tax | | 10 | Compensatory Royalty Payment | | 05 | Advance Rental Credit | | 41 | Offshore Deep Water Royalty Relief | | 55 | Deep Water Royalty Relief | | 53 | Effluent Injection Payment or Reimburse (Geothermal Leases) | | 07 | MMS Settlement Agreement | | 16 | Well Fees | | 32 | Advance Royalty (Solids Coal Leases Only) | | 52 | Recoup Minimum Royalty Paid In Advance (Navajo Leases) | | 54 | Geothermal Field Operations Payment or Reimbursement |
| |
|
| 43 | ORG_ADJ_CD | ONRR-2014 - Adjustment Code | /PRA/FP_ADJUSTMENT_CODE | | NUMC | 000002 | 000000 | |
| Possible Values | 10 | Adjustment | | 16 | Major Portion/Dual Accounting | | 49 | Index Zone/Dual Accounting Price Adjustment | | 26 | Change Valuation Method (Geothermal Lease Only) | | 88 | Small Royalty Write-Off | | 17 | MMS-Initiated Compliance Adjustment | | 20 | DOE Strategic Petroleum Reserve (SPR) RIK With Royalty Value | | 71 | Estimate Underpayment/Overpayment Interest | | 25 | Netback Costs True Up (Geothermal Lease Only) | | 99 | MRM-Prepared Entry | | 21 | DOE SPR Without Royalty Value | | 32 | Estimate Adjustment | | 72 | Audit Underpayment/Overpaymenr Interest | | 35 | Unit Particpating Area/Communitiazation Agr. Adjustment | | 15 | Marginal Property True Up | | 31 | Retroactive Manadatory Price Adj. (Geothermal Lease Only) |
| |
|
| 44 | ORG_PRICE | ONRR-2014 - Price | /PRA/FP_PRICE | | DEC | 000009 | 000006 | |
| 45 | ORG_HEAT_VAL | Heating value | OIU_HEAT_VAL | | QUAN | 000013 | 000003 | |
| 46 | RPDT_GUID | 16-byte UID in 32 chars (hexadecimal) | SYSUUID_C32 | | CHAR | 000032 | 000000 | |
| 47 | EXCLUDE_FRM_FILE | ONRR-2014 - Exclude From ASCII File | /PRA/FP_EXCLUDE_FROM_FILE | | CHAR | 000001 | 000000 | |
| | |
|
| 48 | MANUAL_REV_FL | ONRR-2014 - Manual Reversal Flag | /PRA/FP_MANUAL_REVERSAL_FL | | CHAR | 000001 | 000000 | |
| | |
|
| 49 | ALT_GROUP_KEY | ONRR-2014: Alternate Reporting Line Grouping Key | /PRA/FP_ALTERNATE_GROUPING_KEY | | NUMC | 000010 | 000000 | |
| 50 | OIU_CRUSER | Name of Person Responsible for Creating the Object | ERNAM | | CHAR | 000012 | 000000 | |
| 51 | OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | | DEC | 000015 | 000000 | |