SAP ABAP Table ROIUX5_OK_RPDT_TC (Tax 2.0 - Oklahoma Gross Production Report Detail Structure)
Hierarchy
IS-OIL (Software Component) IS-OIL
   IS-OIL-PRA-REP-TAX (Application Component) Tax Reporting
     OIU_X5 (Package) Tax 2.0 - Oklahoma Tax
Basic Data
Table Category INTTAB    Structure 
Structure ROIUX5_OK_RPDT_TC   Table Relationship Diagram
Short Description Tax 2.0 - Oklahoma Gross Production Report Detail Structure    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
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  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 ROIUX5_OK_RPDT_TC MANDT T000 MANDT KEY    
History
Last changed by/on SAP  20130529 
SAP Release Created in 100