1 |
.INCLUDE |
|
|
|
|
0 |
0 |
Tax 2.0 - Oklahoma Gross Prod Report Detail |
|
2 |
MANDT |
|
MANDT |
MANDT |
CLNT |
3 |
0 |
Client |
T000 |
3 |
.INCLUDE |
|
|
|
|
0 |
0 |
Tax 2.0 - Oklahoma Gross Prod Report Detail Key Fields |
|
4 |
.INCLUDE |
|
|
|
|
0 |
0 |
Tax 2.0 - Oklahoma Gross Prod Report Summary Key Fields |
|
5 |
RUN_ID |
|
OIUX3_RUN_ID |
NUMC10 |
NUMC |
10 |
0 |
Tax Reporting - Run ID |
|
6 |
TAXPAYER_NUMBER |
|
OIUX5_OK_COMPANY_REPORTING_NO |
|
NUMC |
5 |
0 |
Tax 2.0 - Oklahoma Company Reporting Number |
|
7 |
PRODUCTION_DATE |
|
OIUX5_OK_PRODUCTION_DATE |
|
NUMC |
4 |
0 |
Tax 2.0 - Oklahoma Production Date (YYMM) |
|
8 |
OK_PRODUCT_CODE |
|
OIUX5_OK_PRODUCT_CODE |
OIUX5_OK_PRODUCT_CODE |
NUMC |
1 |
0 |
Tax 2.0 - Oklahoma Product Code |
|
9 |
COUNTY |
|
OIUX5_OK_COUNTY |
OIU_SEC_GEO_LOC |
CHAR |
3 |
0 |
Tax 2.0 - Oklahoma County |
* |
10 |
PROD_PURC_IND |
|
OIUX3_PRODUCER_PURCHASER_IND |
OIUX3_PRODUCER_PURCHASER_IND |
CHAR |
1 |
0 |
Tax Reporting - Producer/Purchaser Indicator |
|
11 |
PUN |
|
OIUX5_OK_PRODUCTION_UNIT_NO |
|
CHAR |
11 |
0 |
Tax 2.0 - Oklahoma Production Unit Number |
* |
12 |
PROD_PURCH_NO |
|
OIUX5_OK_PROD_PURCH_NUMBER |
|
NUMC |
5 |
0 |
Tax 2.0 - Oklahoma Prod/Purch Number |
|
13 |
GAS_CODE |
|
OIUX5_OK_GAS_CODE |
OIUX5_OK_GAS_CODE |
NUMC |
1 |
0 |
Tax 2.0 - Oklahoma Gas Code |
|
14 |
TIER_CATEGORY |
|
OIUX5_OK_TIER_CATEGORY |
OIUX5_OK_TIER_CATEGORY |
NUMC |
1 |
0 |
Tax 2.0 - Oklahoma Tier Category |
|
15 |
OIL_CLASS |
|
OIUX5_OK_OIL_CLASSIFICATION |
OIUX5_OK_OIL_CLASSIFICATION |
NUMC |
1 |
0 |
Tax 2.0 - Oklahoma Oil Classification |
|
16 |
NGPA_CD |
|
OIUX5_OK_NGPA_CD |
OIUX5_OK_NGPA_CD |
CHAR |
3 |
0 |
Tax 2.0 OKGP - NGPA Code (Tax Incentive Rate Code) |
|
17 |
REV_BOOK_ADJ_IND |
|
OIUX5_REV_BOOK_REVADJ_ADJ_IND |
OIUX5_REV_BOOK_REVADJ_ADJ_IND |
CHAR |
1 |
0 |
Tax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustment |
|
18 |
.INCLUDE |
|
|
|
|
0 |
0 |
Tax 2.0 - Oklahoma Gross Prod Report Detail Non-Key Fields |
|
19 |
GROSS_VOL |
|
OIUX3_GROSS_VOLUME |
OIUX3_SIGNED_DEC_11_2 |
DEC |
11 |
2 |
Gross Volume |
|
20 |
GROSS_VAL |
|
OIUX3_GROSS_VALUE |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Gross Value |
|
21 |
BTU |
|
OIUX5_BTU |
OIUH_DEC7_3 |
DEC |
7 |
3 |
Tax 2.0 - BTU |
|
22 |
GRAVITY |
|
OIUH_GRAVITY |
OIUH_DEC3_1 |
DEC |
3 |
1 |
Gravity |
|
23 |
TAX_REIMB |
|
OIUX3_TAX_REIMBURSEMENT |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Tax Reporting - Tax Reimbursement |
|
24 |
EXEMPT_CODE_1 |
|
OIUX5_OK_EXEMPT_CODE_1 |
OIUX5_OK_EXEMPT_CODE |
NUMC |
2 |
0 |
Tax 2.0 - Oklahoma Exempt Code 1 |
|
25 |
EXE_DEC_EQUIV_1 |
|
OIUX5_OK_EXEMPT_DEC_EQUIV_1 |
|
DEC |
9 |
8 |
Tax 2.0 - Oklahaoma Exempt Decimal Equivalent 1 |
|
26 |
EXE_ENTTYPE1_VOL |
|
OIUX5_EXEMPT_ENTITY_TYPE_1_VOL |
OIUX3_SIGNED_DEC_11_2 |
DEC |
11 |
2 |
Tax 2.0 - Exempt Entity Type 1 Volume |
|
27 |
EXE_ENTTYPE1_VAL |
|
OIUX5_EXEMPT_ENTITY_TYPE_1_VAL |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Tax 2.0 - Exempt Entity Type 1 Value |
|
28 |
EXEMPT_CODE_2 |
|
OIUX5_OK_EXEMPT_CODE_2 |
OIUX5_OK_EXEMPT_CODE |
NUMC |
2 |
0 |
Tax 2.0 - Oklahoma Exempt Code 2 |
|
29 |
EXE_DEC_EQUIV_2 |
|
OIUX5_OK_EXEMPT_DEC_EQUIV_2 |
|
DEC |
9 |
8 |
Tax 2.0 - Oklahaoma Exempt Decimal Equivalent 2 |
|
30 |
EXE_ENTTYPE2_VOL |
|
OIUX5_EXEMPT_ENTITY_TYPE_2_VOL |
OIUX3_SIGNED_DEC_11_2 |
DEC |
11 |
2 |
Tax 2.0 - Exempt Entity Type 2 Volume |
|
31 |
EXE_ENTTYPE2_VAL |
|
OIUX5_EXEMPT_ENTITY_TYPE_2_VAL |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Tax 2.0 - Exempt Entity Type 2 Value |
|
32 |
EXEMPT_CODE_3 |
|
OIUX5_OK_EXEMPT_CODE_3 |
OIUX5_OK_EXEMPT_CODE |
NUMC |
2 |
0 |
Tax 2.0 - Oklahoma Exempt Code 3 |
|
33 |
EXE_DEC_EQUIV_3 |
|
OIUX5_OK_EXEMPT_DEC_EQUIV_3 |
|
DEC |
9 |
8 |
Tax 2.0 - Oklahaoma Exempt Decimal Equivalent 3 |
|
34 |
EXE_ENTTYPE3_VOL |
|
OIUX5_EXEMPT_ENTITY_TYPE_3_VOL |
OIUX3_SIGNED_DEC_11_2 |
DEC |
11 |
2 |
Tax 2.0 - Exempt Entity Type 3 Volume |
|
35 |
EXE_ENTTYPE3_VAL |
|
OIUX5_EXEMPT_ENTITY_TYPE_3_VAL |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Tax 2.0 - Exempt Entity Type 3 Value |
|
36 |
EXEMPT_CODE_4 |
|
OIUX5_OK_EXEMPT_CODE_4 |
OIUX5_OK_EXEMPT_CODE |
NUMC |
2 |
0 |
Tax 2.0 - Oklahoma Exempt Code 4 |
|
37 |
EXE_DEC_EQUIV_4 |
|
OIUX5_OK_EXEMPT_DEC_EQUIV_4 |
|
DEC |
9 |
8 |
Tax 2.0 - Oklahaoma Exempt Decimal Equivalent 4 |
|
38 |
EXE_ENTTYPE4_VOL |
|
OIUX5_EXEMPT_ENTITY_TYPE_4_VOL |
OIUX3_SIGNED_DEC_11_2 |
DEC |
11 |
2 |
Tax 2.0 - Exempt Entity Type 4 Volume |
|
39 |
EXE_ENTTYPE4_VAL |
|
OIUX5_EXEMPT_ENTITY_TYPE_4_VAL |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Tax 2.0 - Exempt Entity Type 4 Value |
|
40 |
EXEMPT_CODE_5 |
|
OIUX5_OK_EXEMPT_CODE_5 |
OIUX5_OK_EXEMPT_CODE |
NUMC |
2 |
0 |
Tax 2.0 - Oklahoma Exempt Code 5 |
|
41 |
EXE_DEC_EQUIV_5 |
|
OIUX5_OK_EXEMPT_DEC_EQUIV_5 |
|
DEC |
9 |
8 |
Tax 2.0 - Oklahaoma Exempt Decimal Equivalent 5 |
|
42 |
EXE_ENTTYPE5_VOL |
|
OIUX5_EXEMPT_ENTITY_TYPE_5_VOL |
OIUX3_SIGNED_DEC_11_2 |
DEC |
11 |
2 |
Tax 2.0 - Exempt Entity Type 5 Volume |
|
43 |
EXE_ENTTYPE5_VAL |
|
OIUX5_EXEMPT_ENTITY_TYPE_5_VAL |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Tax 2.0 - Exempt Entity Type 5 Value |
|
44 |
EXEMPT_09_VAL |
|
OIUX5_EXEMPT_TYPE_09_VAL |
OIUX3_SIGNED_DEC_11_2 |
DEC |
11 |
2 |
Tax 2.0 - Exempt Entity Type 09 Value |
|
45 |
TAX_VOL |
|
OIUX3_TAXABLE_VOLUME |
OIUX3_SIGNED_DEC_11_2 |
DEC |
11 |
2 |
Taxable Volume |
|
46 |
TAX_VAL |
|
OIUX3_TAXABLE_VALUE |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Taxable Value |
|
47 |
GP_TAX_AMT |
|
OIUX5_GROSS_PROD_TAX_AMOUNT |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Tax 2.0 - Gross Production Tax Amount |
|
48 |
PE_TAX_AMT |
|
OIUX5_PETRO_EXCISE_TAX_AMOUNT |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Tax 2.0 - Petroleum Excise Tax Amount |
|
49 |
SEC_GEO_DESC |
|
OIUX5_OK_COUNTY_NAME |
CHAR30 |
CHAR |
30 |
0 |
Tax 2.0 - Oklahoma County Name |
|
50 |
TAXPAYER_NAME |
|
OIUX5_OKLAHOMA_COMPANY_NAME |
TEXT30 |
CHAR |
30 |
0 |
Tax 2.0 - Oklahoma Company Name |
|
51 |
FEIN_SSN |
|
OIUX3_FEIN_SSN |
|
NUMC |
9 |
0 |
Tax 2.0 - FEIN/SSN |
|
52 |
MULTI_COUNTIES |
|
OIUX5_MULTIPLE_COUNTIES |
YESNO |
CHAR |
1 |
0 |
Tax 2.0 - Multiple Counties? |
|
53 |
.INCLUDE |
|
|
|
|
0 |
0 |
Creator and date/time created |
|
54 |
OIU_CRUSER |
|
ERNAM |
USNAM |
CHAR |
12 |
0 |
Name of Person who Created the Object |
|
55 |
OIU_TIMESTAMP |
|
TZNTSTMPS |
TZNTSTMPS |
DEC |
15 |
0 |
UTC Time Stamp in Short Form (YYYYMMDDhhmmss) |
|
56 |
SEL |
|
FLAG |
FLAG |
CHAR |
1 |
0 |
General Flag |
|
57 |
GROSS_VAL_DELTA |
|
OIUX3_GROSS_VALUE |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Gross Value |
|
58 |
GP_TAX_AMT_DELTA |
|
OIUX5_GROSS_PROD_TAX_AMOUNT |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Tax 2.0 - Gross Production Tax Amount |
|
59 |
PE_TAX_AMT_DELTA |
|
OIUX5_PETRO_EXCISE_TAX_AMOUNT |
OIUX3_SIGNED_CURR_11_2 |
CURR |
11 |
2 |
Tax 2.0 - Petroleum Excise Tax Amount |
|