SAP ABAP Table OIUX3_TX_OOSTXN (Tax Reporting - Texas Out Of Statute Transactions)
Hierarchy
IS-OIL (Software Component) IS-OIL
   IS-OIL-PRA-REP-TAX (Application Component) Tax Reporting
     OIU_X3 (Package) Tax 2.0
Basic Data
Table Category TRANSP    Transparent table 
Transparent table OIUX3_TX_OOSTXN   Table Relationship Diagram
Short Description Tax Reporting - Texas Out Of Statute Transactions    
Delivery and Maintenance
Pool/cluster      
Delivery Class L   Table for storing temporary data, delivered empty 
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 MANDT MANDT MANDT CLNT 3   0   Client T000
2 .INCLUDE       0   0   Tax Reporting - Texas Tax Transactions Key Fields  
3 .INCLUDE       0   0   Tax Reporting - Texas Tax Transactions Reversal Key Fields  
4 BUKRS BUKRS BUKRS CHAR 4   0   Company Code OIU_CM_COMPC
5 SALES_DT OIU_SALE_DT DATUM DATS 8   0   Sales Date / Month  
6 PDCD OIU_FULL_PD_CD OIU_FULL_PD_CD CHAR 3   0   Full three char. product code (Major and Detail Products) OIUX3_PDCD
7 WL_NO OIU_WL_NO OIU_WL_NO CHAR 15   0   Well ID number OIU_PR_WELL
8 WC_NO OIU_WC_NO OIU_WC_NO CHAR 5   0   Well Completion Number OIU_PR_WC
9 MP_NO OIU_MP_NO OIU_MP_NO CHAR 20   0   Measurement point number OIU_PR_MP
10 VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture OIU_DO_JV
11 DOI_NO OIU_DOI_NO OIU_DOI_NO CHAR 5   0   Division of interest (DOI) OIU_DO_DI
12 DN_NO OIU_DN_NO OIU_DN_NO CHAR 20   0   Delivery network number OIU_PR_DN
13 CT_NO OIU_CT_NO OIUCM_CONTRACT_NUMBER CHAR 10   0   Contract Number OIU_RV_CT
14 VL_TYPE_CD OIU_VT_CD OIU_VL_TYPE_CD CHAR 2   0   Volume type code OIU_PR_VLTYP
15 TAX_CLS OIU_TAX_CLS OIU_TAX_CLS CHAR 4   0   Tax Class OIU_CM_TAXCLS
16 TAX_TYPE OIU_SEVT_TAX_TY OIU_SEVT_TAX_TY CHAR 2   0   Severance Tax Type OIU_CM_SEVTTY
17 TIER_TAX_IND OIUX3_TIER_TAX_INDICATOR OIUX3_TIER_TAX_INDICATOR CHAR 1   0   Tax Reporting - Tier Tax Indicator  
18 REV_BOOK_ADJ_IND OIUX3_REVERSE_BOOKING_ADJ_IND OIUX3_REVERSE_BOOKING_ADJ_IND CHAR 1   0   Tax Reporting - Reversal/Booking/Adjustment Indicator  
19 .INCLUDE       0   0   Tax Reporting - Texas Tax Transactions Non-Key Fields  
20 PROD_PURC_IND OIUX3_PRODUCER_PURCHASER_IND OIUX3_PRODUCER_PURCHASER_IND CHAR 1   0   Tax Reporting - Producer/Purchaser Indicator  
21 UNIT_VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture OIU_DO_JV
22 PAY_FL OIU_SEVT_PAY_FL OIU_SEVT_PAY_FL CHAR 1   0   Tax Severance Tax Calculation Payment Obligations Types  
23 RPT_FL OIU_SEVT_RPT_FL CHAR1 CHAR 1   0   State Severance Tax Reporting Indicators  
24 UOM OIU_MEAS_U MEINS UNIT 3   0   Measurement unit T006
25 LEASE_GROSS_VOL OIUX3_LEASE_GROSS_VOLUME OIUX3_SIGNED_DEC_11_2 DEC 11   2   Tax Reporting - Lease Gross Volume  
26 GROSS_VOL OIUX3_GROSS_VOLUME OIUX3_SIGNED_DEC_11_2 DEC 11   2   Gross Volume  
27 GROSS_VAL OIUX3_GROSS_VALUE OIUX3_SIGNED_CURR_11_2 CURR 11   2   Gross Value  
28 TAX_VOL OIUX3_TAXABLE_VOLUME OIUX3_SIGNED_DEC_11_2 DEC 11   2   Taxable Volume  
29 TAX_VAL OIUX3_TAXABLE_VALUE OIUX3_SIGNED_CURR_11_2 CURR 11   2   Taxable Value  
30 EXEMPT_VOL OIUX3_EXEMPT_VOLUME OIUX3_SIGNED_DEC_11_2 DEC 11   2   Tax Reporting - Exempt Volume  
31 EXEMPT_VAL OIUX3_EXEMPT_VALUE OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax Reporting - Exempt Value  
32 MKT_COST OIUX3_MARKETING_COST OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost  
33 MKT_COST_REIMB OIUX3_MARKETING_COST_REIMB OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost Reimbursement  
34 TAX_AMT OIUX3_TAX_AMOUNT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax Reporting - Tax Amount  
35 TAX_REIMB OIUX3_TAX_REIMBURSEMENT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax Reporting - Tax Reimbursement  
36 TAX_RATE_VOL OIUVL_VL_TAX_RAT OIUVL_PERCENT76 DEC 7   6   Volume tax rate  
37 TAX_RATE_VAL OIUVL_VAL_TAX_RAT OIUVL_PERCENT76 DEC 7   6   Value tax rate  
38 GRAVITY OIUH_GRAVITY OIUH_DEC3_1 DEC 3   1   Gravity  
39 .INCLUDE       0   0   Tax Reporting - Texas Master Data Nonkey Fields  
40 API_WELL_NUMBER OIUX3_TX_API_WELL_NUMBER CHAR8 CHAR 8   0   Tax Reporting - Texas API Well Number  
41 COUNTY OIUX3_TX_COUNTY NUMC3 NUMC 3   0   Tax Reporting - Texas County OIUX3_TX_CNTXRF
42 LEASE_NUMBER OIUX3_TX_LEASE_NUMBER CHAR7 CHAR 7   0   Tax Reporting - Texas Lease OIUX3_TX_LEASE
43 OFF_LEASE_CD OIUX3_TX_OFF_LEASE_CODE OIUX3_TX_OFF_LEASE_CODE CHAR 1   0   Tax Reporting - Texas On/Off Lease Code  
44 MASTER_LEVEL OIUX3_TX_MASTER_LEVEL OIUX3_TX_MASTER_LEVEL CHAR 1   0   Tax Reporting - Texas Master Level  
45 .INCLUDE       0   0   Tax Reporting - Texas Other Party Structure  
46 OTHER_NO OIUCM_BUS_ASSOC OIUCM_BUS_ASSOC CHAR 6   0   Business Associate OIUCM_BA_LINK
47 OTHER_SEQ_NO OIUCM_SEQ_NO OIUCM_SEQ_NO CHAR 2   0   Sequence Number OIUCM_BA_LINK
48 OTHER_PARTY_NO OIUX3_TX_OTHER_PARTY_NUMBER TEXT11 CHAR 11   0   Tax Reporting - Texas Other Party Taxpayer Number  
49 COMMODITY_TYPE OIUX3_TX_COMMODITY_TYPE OIUX3_TX_COMMODITY_TYPE CHAR 3   0   Tax Reporting - Texas Commodity Type  
50 EXEMPTION_TYPE OIUX3_TX_EXEMPTION_TYPE NUMC2 NUMC 2   0   Tax Reporting - Texas Exemption Type  
51 TAXPAYER_NUMBER OIUX3_TX_TAXPAYER_NUMBER   NUMC 11   0   Tax Reporting - Texas Taxpayer Number  
52 TAXPAYER_NAME OIUX3_TAXPAYER_NAME TEXT100 CHAR 100   0   Taxpayer Name  
53 OPTION1     CHAR 1   0    
54 OPTION2     CHAR 1   0    
55 OPTION3     CHAR 1   0    
56 .INCLUDE       0   0   Creator and date/time created  
57 OIU_CRUSER ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
58 OIU_TIMESTAMP TZNTSTMPS TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 OIUX3_TX_OOSTXN BUKRS OIU_CM_COMPC BUKRS KEY    
2 OIUX3_TX_OOSTXN COUNTY OIUX3_TX_CNTXRF COUNTY REF    
3 OIUX3_TX_OOSTXN CT_NO OIU_RV_CT CT_NO KEY    
4 OIUX3_TX_OOSTXN DN_NO OIU_PR_DN DN_NO KEY    
5 OIUX3_TX_OOSTXN DOI_NO OIU_DO_DI DOI_NO KEY    
6 OIUX3_TX_OOSTXN LEASE_NUMBER OIUX3_TX_LEASE LEASE_NUMBER REF    
7 OIUX3_TX_OOSTXN MANDT T000 MANDT KEY    
8 OIUX3_TX_OOSTXN MP_NO OIU_PR_MP MP_NO KEY    
9 OIUX3_TX_OOSTXN OTHER_NO OIUCM_BA_LINK BA_NO REF    
10 OIUX3_TX_OOSTXN OTHER_SEQ_NO OIUCM_BA_LINK BA_SEQ REF    
11 OIUX3_TX_OOSTXN PDCD OIUX3_PDCD PDCD KEY    
12 OIUX3_TX_OOSTXN TAX_CLS OIU_CM_TAXCLS TAX_CLS KEY    
13 OIUX3_TX_OOSTXN TAX_TYPE OIU_CM_SEVTTY SEVT_TAX_TY    
14 OIUX3_TX_OOSTXN UNIT_VNAME OIU_DO_JV VNAME REF    
15 OIUX3_TX_OOSTXN UOM T006 MSEHI REF    
16 OIUX3_TX_OOSTXN VL_TYPE_CD OIU_PR_VLTYP VL_TYPE_CD KEY    
17 OIUX3_TX_OOSTXN VNAME OIU_DO_JV VNAME KEY    
18 OIUX3_TX_OOSTXN WC_NO OIU_PR_WC WC_NO KEY    
19 OIUX3_TX_OOSTXN WL_NO OIU_PR_WELL WL_NO KEY    
History
Last changed by/on SAP  20130529 
SAP Release Created in 46C