| |
EDI Viewer - Column Definitions |
Here is a list of columns that you will see on
EDI Viewer Crown Royalty Annual Invoice reports or
listed as columns to use with the Filter
function.
The following table has four columns:
Column Name - the name of the column on the report or on the Filter dialog box.
Description - a description of what the column is used for.
Sample Data - the type of data typically found in the column.
Sample Filter - how to use this column in the Filter dialog box.
| Column Name | Description | Sample Data | Sample Filter |
|---|---|---|---|
| AC2 Distribution Percent | the percentage of CCA to be reallocated; reported on AC3 report. | 50.00000 | ac2_distribution_percent = 50.00000 |
| AC5 Custom Processign Fees Paid | the amount of custom fees paid, as reported on AC5 report. | 3,500 3000, 3500 |
ac5_cp_fees_paid =3,500 ac5_cp_fees_paid > 3000 and ac5_cp_fees_paid < 3500 |
| AC5 Processed Volume | the amount of processed volume as reported on the AC5 report. | 1,500.0 | ac5_processed_volume > 3000 and ac5_processed_volume < 5000 |
| Average Spare Parts Inventory | number representing the value of average spare parts inventory. | 1000 | avg_spare_parts_inv > 1000 |
| Capital Additions | capital additions. | 2,000 | capital_additions > 2000 |
| Closing Capital Costs Distribution | percentage of the CCA that the client claims | 55 | cca_distribution = 55 |
| Cca recalculation indicator | identifies fcc that have been recalculated | * | cca_recalculation_ind = '*' |
| Closing Capital Costs | closing capital costs. | 2,000 | closing_capital_costs > 12000 |
| Client Code | the code assigned by a Regulatory Agency which identifies the company or individual charged with the royalty obligation. | 0TT9 | client_code = '0TT9' client_code like '0T%' |
| Client Name | the legal name of the company or individual. | Now! Technology Inc. | client_name = 'Now! Technology Inc.' |
| Client Volumetric Quantity | number representing clint volume. | 500 | client_volumetric_qty > 500 |
| Compression | one of the delayered rates a product. | 3.00 | compression = 3.00 |
| Corporate Cycling | corporate_cycling | ||
| Corporate Value | number representing the corporate value. | 300,000 | corporate_value > 300000 |
| Crown Royalty Quantity | crown_royalty_qty | ||
| Crown Royalty Value | number representing the Crown Royalty value. | 1,000,000 | crown_royalty_value > 1000000 |
| Cycling Crq | 1 | cycling_crq > 1 | |
| Depreciation | the depreciation amount for a FCC. | 10,000 | depreciation <10000 |
| Energy Adjustment Gas Equivalant Factor | number used to calculate gas equivalant volumes. | 1 | energy_adj_gas_equiv_factor = 1 |
| Energy Adjustment Gas Equivalant Volume | common unit of measure for gas and gas products in their gaseous form. | 30000 | energy_adj_gas_equiv_volume > 30000 |
| Ex Ab Production | ex_ab_production | ||
| Facility Code | the facility code as assigned by the EUB. | 1002 | facility_code = '1002' facility_code like '10%' |
| Facility Name | the facility name as assigned by the EUB. | Facility 1 | facility_name = 'Facility 1'
facility_name like 'F%' |
| Facility Production | number that identifies facility production | 1000 | facility_production > 1000 |
| Facility Province | the province where the facility is located. | AB | facility_province = 'AB' |
| Facility Type | the type of facility. | GP | facility_type = 'GP' |
| FCC Code | code that identifies a facility cost center. | 022057 | fcc_code = '022057' fcc_code like '022%' |
| From Client Code | 0945 | from_client_code = '0945' | |
| Gathering | 2 | gathering > 2 | |
| Invoice Number | number that identifies an invoice. | 92214 | invoice_number = '92214' invoice_number like '92%' |
| Issue Date | the date the invoice was issued. | 1997-May-01 | string ( issue_date, "yyyy-mm-dd" ) = '1998-05-01' |
| Land | number representing land value. | 20,000 | land > 20000 |
| Net Corporate Production | number representing the Corporate production after deductions. | 10,000 | net_corporate_production > 10000 |
| Net CCA | the net capital cost allowance amount. | 12345.67 | net_cca > 12345.67 |
| Net Crq | number value | 0 | net_crq > 0 |
| Net Reallocation Percent | 5 % | net_reallocation_percent > 5 | |
| Number of Months | number value indicating months | 12 | no_of_months < 12 |
| Opening Capital Costs | number indicating capital costs prior to adjustments | 200,000 | opening_capital_costs > 200000 |
| Operating Cost Reduction | number indicating | 30,000 | operating_cost_reduction > 30000 |
| Percent from Client | number indicating percent | 10 % | percent_from_client > 10 |
| Percent To Client | number indicating percent | 5% | percent_from_client > 5 |
| Processing | number indicating the processing values | 100 | processing > 100 |
| 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%' |
| Product Unit Value | 5 | product_unit_value < 5 | |
| Production Month | the production month. | June | production_month |
| Production Year | the production year. | 1997 | production_year >= 1994 and production_year < 1997 |
| Purchased Quanity | number idicating purchased quanity. | 1000 | purchased_qty > 1000 |
| Remaining Useful Life | number representing years of useful life. | 10 | remaining_useful_life > 10 |
| Retirements | 4000 | retirements > 4000 | |
| Royalty Exemption | royalty_exemption > 1 | ||
| Unit Operating Cost Rate | uocr_ind = '' |