Import Field Specifications |
  
|
Import Field Specifications |
|
Below is a description of the destination fields available during a CSV Import. Each field may have different Requirement options; see the Table C2 for Required Code definitions.
Table C1
CSV Import Field Name |
Description |
Valid Value Examples |
Req Code |
Tax_ID |
Reporting Taxpayer ID |
12345678901 |
RQ |
TaxSubType |
Reporter is Producer (49) or Purchaser (37) |
49 |
TO |
LsTyp |
Oil Lease (1) or Gas Lease (2) |
2 |
RQ |
OffLeaseSale |
Purchase occurs Off Lease (1) or On Lease (2) |
2 |
AP |
Sec_Tax_Num |
Secondary Taxpayer ID |
12345678901 |
RQ |
Cnt |
123 |
RQ |
|
RRC |
Lease Number |
000321 |
RQ |
Drilling_Perm_Ind |
RRC is a permit number (1) or a lease number (2) |
2 |
AP |
Exemption_Type |
Applied Exemption Code |
05 |
RQ |
Taxpayer |
Reporter is Liable for Tax (1) or Not Liable (2) |
1 |
RQ |
CMnum |
1, RG |
RQ |
|
API |
8 digit API number |
12733291 |
RQ |
Tax_Reim |
Tax Reimbursement is embedded in value (1) or not (2) |
2 |
RQ |
Date |
Production Date |
1/1/2010, 1001, 2010-01 |
RQ |
LsVol |
Reported Gross Lease Volume |
1000 |
RQ |
Your_Vol |
Reported Your Volume |
100 |
RQ |
Your_Val |
Reported Your Value |
500.00 |
RQ |
Exempt_Vol |
Reported Royalty Volume |
10 |
RQ |
Exempt_Val |
Reported Royalty Value |
50.00 |
RQ |
Cost |
Reported Post Production Cost |
50.00 |
RQ |
Net_Taxable_Val |
Reported Net Taxable Value |
400.00 |
RQ |
TaxDueOn05 |
Reported Tax Due On Type 05 |
12 |
05 |
ToBe_LsVol |
To Be Gross Lease Volume |
500 |
TB |
ToBe_Your_Vol |
To Be Your Volume |
50 |
TB |
ToBe_Your_Val |
To Be Your Value |
250.00 |
TB |
ToBe_Exempt_Vol |
To Be Royalty Volume |
5 |
TB |
ToBe_Exempt_Val |
To Be Royalty Value |
25.00 |
TB |
ToBe_Cost |
To Be Post Production Cost |
25.00 |
TB |
ToBe_Net_Taxable_Val |
To Be Net Taxable Value |
200.00 |
TB |
ToBe_TaxDueOn05 |
To Be Tax Due On Type 05 |
6 |
05 |
Tax_Rate |
Tax Rate on Type 05 |
0.03 |
05 |
Locator Number* |
Locator Number |
0000785 |
OP |
TransactionID |
Out of Use |
n/a |
|
Req Code |
Description |
RQ |
Required |
OP |
Optional |
TO |
Overridable by TaxSubType Option |
AP |
Overridable by Auto Populate Fields Options |
05 |
Only When Exemption_Type = '05' (High Cost). Overridable by Auto Populate Field Options |
TB |
Only When Volume And Values Option is set to Original and To Be Values |