EDI Viewer - GL Upload Reports Column Definitions

Here is a list of columns that you will see on the GL reports: Batch History, Batch Details, Batch Summary, and Stream without Cost Centers.

The table below describes:

 
Column Name Description Sample Data Sample Filter
Account GL account as set up by you the user account 994 (stream with out projects gl_account = '994' 
Charge Type description of royalty or charge types assessed on a invoice statement. CR=CROWN ROYALTY 
IJ = INJECTION CREDIT
RPB=ROYALTY PAID BANKS
RDI=ROYALTY DUE INVENTORY
EOR=EOR ADJUSTMENT		 charge_type = 'CROWN ROYALTY'

charge_type = 'INJECTION CREDIT'
Company Code code used internally to identify company 001 n/a
Facility code code assigned by a Regulatory Agency which identifies a facility. GP-1000 facility = 'GP-1000'
facility like 'GP-10%'
Production period year and month the activities occurred. 1998-06 production_period = '1998-06'
Product a standard abbreviation to describe the type of product that attracts royalty as assigned by a Regulatory Agency. C2-SP
C2-MX
GAS		 product_code = 'C2-SP'
product_code like 'C5%'
Project or Cost Center an account for accumilating the opperating costs. Medicine River project = 'Medicine River'
Project Percent percentage of opperating costs allocated to a project. 70% project_percent > 70
Charge Type charge type description. 996 (unit operating cost) charge_type = 996
Stream ID code code used to identify the stream origin as assigned by a Regulatory Agency. Injection Facility = IF-1000
Injection Scheme = IS-1000
Well Group = WG-1000
Unit = UN-1001
Well = WI-100134502317W600		 stream_id_code = 'IF-1000'
stream_id_code = 'IS-1000'
stream_id_code = 'WG-1000'
stream_id_code = 'WI-100134502317W600'
Volume Crown Royalty volume: the portion of the allocated quantity which belongs to the Crown. 10000 crown_volume > 10000