OIUX3_TX_TAXTXN - Tax Reporting - Texas Tax Transactions
Tax Reporting - Texas Tax Transactions information is stored in SAP table OIUX3_TX_TAXTXN.
It is part of development package OIU_X3 in software component IS-OIL-PRA-REP-TAX. This development package consists of objects that can be grouped under "Tax 2.0".
It is part of development package OIU_X3 in software component IS-OIL-PRA-REP-TAX. This development package consists of objects that can be grouped under "Tax 2.0".
Fields for table OIUX3_TX_TAXTXN
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| .INCLUDE | ROIUX3_TX_TAXTXN_KEY | X | ROIUX3_TX_TAXTXN_KEY | 0 | ||
| .INCLUDE | ROIUX3_TX_TAXREV_KEY | X | ROIUX3_TX_TAXREV_KEY | 0 | ||
| BUKRS | Company Code | X | BUKRS | CHAR | 8 | OIU_CM_COMPC |
| SALES_DT | Sales Date / Month | X | OIU_SALE_DT | DATS | 16 | |
| PDCD | Full three char. product code (Major and Detail Products) | X | OIU_FULL_PD_CD | CHAR | 6 | OIUX3_PDCD |
| WL_NO | Well ID number | X | OIU_WL_NO | CHAR | 30 | OIU_PR_WELL |
| WC_NO | Well Completion Number | X | OIU_WC_NO | CHAR | 10 | OIU_PR_WC |
| MP_NO | Measurement point number | X | OIU_MP_NO | CHAR | 40 | OIU_PR_MP |
| VNAME | Joint venture | X | JV_NAME | CHAR | 12 | OIU_DO_JV |
| DOI_NO | Division of interest (DOI) | X | OIU_DOI_NO | CHAR | 10 | OIU_DO_DI |
| DN_NO | Delivery network number | X | OIU_DN_NO | CHAR | 40 | OIU_PR_DN |
| CT_NO | Contract Number | X | OIU_CT_NO | CHAR | 20 | OIU_RV_CT |
| VL_TYPE_CD | Volume type code | X | OIU_VT_CD | CHAR | 4 | OIU_PR_VLTYP |
| TAX_CLS | Tax Class | X | OIU_TAX_CLS | CHAR | 8 | OIU_CM_TAXCLS |
| TAX_TYPE | Severance Tax Type | X | OIU_SEVT_TAX_TY | CHAR | 4 | OIU_CM_SEVTTY |
| TIER_TAX_IND | Tier Tax | X | OIUX3_TIER_TAX_INDICATOR | CHAR | 2 | |
| REV_BOOK_ADJ_IND | Reversal/Booking/Adjustment | X | OIUX3_REVERSE_BOOKING_ADJ_IND | CHAR | 2 | |
| .INCLUDE | ROIUX3_TX_TAXTXN_NONKEY | ROIUX3_TX_TAXTXN_NONKEY | 0 | |||
| PROD_PURC_IND | Producer or Purchaser | OIUX3_PRODUCER_PURCHASER_IND | CHAR | 2 | ||
| UNIT_VNAME | Joint venture | JV_NAME | CHAR | 12 | OIU_DO_JV | |
| PAY_FL | Tax Severance Tax Calculation Payment Obligations Types | OIU_SEVT_PAY_FL | CHAR | 2 | ||
| RPT_FL | State Severance Tax Reporting Indicators | OIU_SEVT_RPT_FL | CHAR | 2 | ||
| UOM | Measurement unit | OIU_MEAS_U | UNIT | 6 | T006 | |
| LEASE_GROSS_VOL | Lease Gross Volume | OIUX3_LEASE_GROSS_VOLUME | DEC | 6 | ||
| GROSS_VOL | Gross Volume | OIUX3_GROSS_VOLUME | DEC | 6 | ||
| GROSS_VAL | Gross Value | OIUX3_GROSS_VALUE | CURR | 6 | ||
| TAX_VOL | Taxable Volume | OIUX3_TAXABLE_VOLUME | DEC | 6 | ||
| TAX_VAL | Taxable Value | OIUX3_TAXABLE_VALUE | CURR | 6 | ||
| EXEMPT_VOL | Exempt Volume | OIUX3_EXEMPT_VOLUME | DEC | 6 | ||
| EXEMPT_VAL | Exempt Value | OIUX3_EXEMPT_VALUE | CURR | 6 | ||
| MKT_COST | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
| MKT_COST_REIMB | Marketing Cost Reimbursement | OIUX3_MARKETING_COST_REIMB | CURR | 6 | ||
| TAX_AMT | Tax Amount | OIUX3_TAX_AMOUNT | CURR | 6 | ||
| TAX_REIMB | Tax Reimbursement | OIUX3_TAX_REIMBURSEMENT | CURR | 6 | ||
| TAX_RATE_VOL | Volume tax rate | OIUVL_VL_TAX_RAT | DEC | 4 | ||
| TAX_RATE_VAL | Value tax rate | OIUVL_VAL_TAX_RAT | DEC | 4 | ||
| GRAVITY | Gravity | OIUH_GRAVITY | DEC | 2 | ||
| .INCLUDE | ROIUX3_TX_MASTER_NONKEY | ROIUX3_TX_MASTER_NONKEY | 0 | |||
| API_WELL_NUMBER | API Well Number | OIUX3_TX_API_WELL_NUMBER | CHAR | 16 | ||
| COUNTY | Texas County Identifier | OIUX3_TX_COUNTY | NUMC | 6 | OIUX3_TX_CNTXRF | |
| LEASE_NUMBER | Texas Lease Number | OIUX3_TX_LEASE_NUMBER | CHAR | 14 | OIUX3_TX_LEASE_M | |
| OFF_LEASE_CD | Texas On-/Off-Lease Sale Code | OIUX3_TX_OFF_LEASE_CODE | CHAR | 2 | ||
| EOR_PROJECT | Texas Tax - Project Number | OIUX3_TX_PROJECT | CHAR | 18 | ||
| STATEWIDE | TX Tax 2.0 - Statewide Lease | OIUX3_TX_STATEWIDE | CHAR | 2 | ||
| MASTER_LEVEL | Texas Master Data Level | OIUX3_TX_MASTER_LEVEL | CHAR | 2 | ||
| .INCLUDE | ROIUX3_TX_OTHER_PARTY | ROIUX3_TX_OTHER_PARTY | 0 | |||
| OTHER_NO | Business Associate | OIUCM_BUS_ASSOC | CHAR | 12 | OIUCM_BA_LINK | |
| OTHER_SEQ_NO | Sequence Number | OIUCM_SEQ_NO | CHAR | 4 | OIUCM_BA_LINK | |
| OTHER_PARTY_NO | Texas Taxpayer Number of Other Party | OIUX3_TX_OTHER_PARTY_NUMBER | CHAR | 22 | ||
| .INCLUDE | ROIUX3_TX_OTHER_PARTY_NUMBER | ROIUX3_TX_OTHER_PARTY_NUMBER | 0 | |||
| OTHER_PARTY | Master Record | OIUCM_MASTER | CHAR | 20 | ||
| COMMODITY_TYPE | Texas Commodity Type | OIUX3_TX_COMMODITY_TYPE | CHAR | 6 | ||
| EXEMPTION_TYPE | Texas Exemption Type | OIUX3_TX_EXEMPTION_TYPE | NUMC | 4 | ||
| TAXPAYER_NUMBER | Texas Taxpayer Number | OIUX3_TX_TAXPAYER_NUMBER | NUMC | 22 | ||
| TAXPAYER_NAME | Taxpayer Name | OIUX3_TAXPAYER_NAME | CHAR | 200 | ||
| OPTION1 | CHAR | 2 | ||||
| OPTION2 | PPN Flag | CHAR | 2 | |||
| OPTION3 | CHAR | 2 | ||||
| REJ_SUSP_IND | Rejection-Suspension Status | OIUX3_REJECT_SUSPEND_IND | CHAR | 2 | ||
| REJ_CD | Rejection Code | OIUX3_REJECT_CODE | CHAR | 4 | OIUX3_TX_REJ | |
| .INCLUDE | OIU_CREATION | 0 | ||||
| OIU_CRUSER | Name of Person Responsible for Creating the Object | ERNAM | CHAR | 24 | ||
| OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC | 8 |