Navigating the Detail Report

Navigation:  Revenue Views > Account Detail > Detail Report Page >

Navigating the Detail Report

Previous pageReturn to chapter overviewNext page
Show/Hide Hidden Text

The Detail Report is the grid within the Detail Report Page. The report lets you view individual detail records.

 

The Detail Report works much like other grids in TexRev, with features such as sorting, filtering and selecting. See the Using Grids in the Appendix for a detailed explanation of how TexrRev's Grids work. Features unique to the Lease Revenue Report are described below.

tog_minusRestrictions

TexRev limits the contents of the grid to records your group is authorized to view; that is, any detail record that contains one of your Taxpayer IDs as the primary or secondary taxpayer.

 

TexRev may also limit the contents of the grid depending on the referring page.

 

For example, if you navigated here from the Account Detail Report Page, which was configured to only show revenue for the commodity raw gas in Chambers County, the Detail Report will also only show raw gas records reported in Chambers County.

 

However, if you arrived here by clicking on the DLN field of a Detail Record Subreport, the filters will be removed to facilitate adjustment tracking.

tog_minusDetail Report Fields

Each record in the Detail Report represents a a detail record. There are forty fields available for each record:

 

Loc Num - The seven digit locator number reported on the summary record. Locator numbers are unique by Taxpayer, Tax Sub Type and Filing Period

TaxPayId - Primary Taxpayer ID

TaxPayName - Primary Taxpayer Name

TaxSubTyp - The record's tax subtype, one of two values:

oProducer Reported (49)

oPurchaser Reported (37)

FilPd - Production Period

DLN - Document Locator Number

Postmark - Postmark date of filing

ProcDate - Processing Date

T-Code - Transaction Code

File - The filing method of the transaction entry

o'E' - Electronic Filing

o'R' - RCS Return

o'S' - System Generated

o'T' - Telefile

oblank (' ') - manual adjustment by State

CM# - Commodity code

CM - Abbreviation of the commodity being reported. See the Commodities Section in the Appendix for definitions

Cnt# - County Number

County - County Name

Typ - Lease Type Code, 1 for Oil, 2 for Gas

RRC - Lease ID

Chk - Check digit

Lease Name - name of the lease

Dis - district in which this lease exists

LsEndDate - Lease End Date

DrlPmt - Permit Number

API - 8 digit API number

WellNum - Well Number

Ex - Two digit Exemption Type Code. See the Exemptions Section in the Appendix for code definitions

ExErr - Exemption Error Code

Sec Tax ID - Secondary Taxpayer ID

Sec Tax Name - Secondary Taxpayer Name

OffLse - Off Lease Sale Indicator, 1 for Yes, 2 for No

Reim - Indicates whether tax reimbursement is included in calculating the value on this lease. Value is 1 for Yes or 2 for No

TXBL - Indicates whether the reporting Taxpayer is liable for tax, 1 for Yes, 2 for No

lsVOL - Gross Lease Volume reported on the commodity, M.C.F for gas, barrels for condensate

yourVOL - Volume of gas not subject to tax because of a governmental exempt status

yourVAL - Value associated with yourVol

exVOL - The number of adjustment records in the transaction

exVAL - Value associated with exVOL

COST - Reported marketing costs incurred

NetTaxVal - Net taxable value of the product sold

Rate - The tax rate applied against the net taxable value. Only used with Exemption 05 (High Cost) records

TxDue05 - Tax Due on High Cost Record

Errors - Error Codes, if any, tripped by this latest amendment

tog_minusViewing a Detail Record's Summary History

To view the detail adjustment's summary record history, click on the detail record's Locator Number. TexRev will retrieve the summary record's Full Revenue History Page.