OIUT5_OOSTXNP - Tax 2.0 OK - Out-of-Statute Tax Transactions (PUN Level)
Tax 2.0 OK - Out-of-Statute Tax Transactions (PUN Level) information is stored in SAP table OIUT5_OOSTXNP.
It is part of development package OIU_T5 in software component IS-OIL-PRA-REP-TAX. This development package consists of objects that can be grouped under "Oklahoma Tax Reporting SLA".
It is part of development package OIU_T5 in software component IS-OIL-PRA-REP-TAX. This development package consists of objects that can be grouped under "Oklahoma Tax Reporting SLA".
Fields for table OIUT5_OOSTXNP
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
.INCLUDE | ROIUX5_OK_TAXTXN_KEY | X | ROIUX5_OK_TAXTXN_KEY | 0 | ||
.INCLUDE | ROIUX5_OK_REVTXN_KEY | X | ROIUX5_OK_REVTXN_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 |
PUN | Tax 2.0 - OKGP15 - Production Unit Number | X | OIUT5_PRODUCTION_UNIT_NO | NUMC | 28 | |
REV_BOOK_ADJ_IND | Tax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustment | X | OIUX5_REV_BOOK_REVADJ_ADJ_IND | CHAR | 2 | |
ALLOC_PERCENT | Tax 2.0 - Allocation Percentage | OIUX5_ALLOCATION_PERCENTAGE | DEC | 5 | ||
.INCLUDE | ROIUT5_TAXTXN_NONKEY | ROIUT5_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 | |
VAL_TAX_RAT | Value tax rate | OIUVL_VAL_TAX_RAT | DEC | 4 | ||
OTHER_PARTY | Master Record | OIUCM_MASTER | CHAR | 20 | ||
DOC_NO | Val. document number | OIURV_DOCNR | CHAR | 40 | * | |
DOC_YEAR | Document year | OIU_DOC_YEAR | NUMC | 8 | ||
OPTION1 | Single-Character Flag | CHAR1 | CHAR | 2 | ||
OPTION2 | Single-Character Flag | CHAR1 | CHAR | 2 | ||
OPTION3 | Single-Character Flag | CHAR1 | CHAR | 2 | ||
INTERFACE_FL | Single-Character Flag | CHAR1 | CHAR | 2 | ||
OOS_FL | Out of Statute | OIUX3_OUT_OF_STATUTE | CHAR | 2 | ||
.INCLUDE | ROIUT5_TAXTXN_NONKEY_NUMERIC | ROIUT5_TAXTXN_NONKEY_NUMERIC | 0 | |||
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 | ||
EXE_ENTTYPE1_VOL | Tax 2.0 - Exempt Entity Type 1 Volume | OIUX5_EXEMPT_ENTITY_TYPE_1_VOL | DEC | 6 | ||
EXE_ENTTYPE1_VAL | Tax 2.0 - Exempt Entity Type 1 Value | OIUX5_EXEMPT_ENTITY_TYPE_1_VAL | CURR | 6 | ||
EXE_ENTTYPE2_VOL | Tax 2.0 - Exempt Entity Type 2 Volume | OIUX5_EXEMPT_ENTITY_TYPE_2_VOL | DEC | 6 | ||
EXE_ENTTYPE2_VAL | Tax 2.0 - Exempt Entity Type 2 Value | OIUX5_EXEMPT_ENTITY_TYPE_2_VAL | CURR | 6 | ||
EXE_ENTTYPE3_VOL | Tax 2.0 - Exempt Entity Type 3 Volume | OIUX5_EXEMPT_ENTITY_TYPE_3_VOL | DEC | 6 | ||
EXE_ENTTYPE3_VAL | Tax 2.0 - Exempt Entity Type 3 Value | OIUX5_EXEMPT_ENTITY_TYPE_3_VAL | CURR | 6 | ||
EXE_ENTTYPE4_VOL | Tax 2.0 - Exempt Entity Type 4 Volume | OIUX5_EXEMPT_ENTITY_TYPE_4_VOL | DEC | 6 | ||
EXE_ENTTYPE4_VAL | Tax 2.0 - Exempt Entity Type 4 Value | OIUX5_EXEMPT_ENTITY_TYPE_4_VAL | CURR | 6 | ||
EXE_ENTTYPE5_VOL | Tax 2.0 - Exempt Entity Type 5 Volume | OIUX5_EXEMPT_ENTITY_TYPE_5_VOL | DEC | 6 | ||
EXE_ENTTYPE5_VAL | Tax 2.0 - Exempt Entity Type 5 Value | OIUX5_EXEMPT_ENTITY_TYPE_5_VAL | CURR | 6 | ||
EOR_VOL | EOR Volume | OIU_EOR_VL | QUAN | 7 | ||
EOR_VAL | EOR Value | OIU_EOR_VAL | CURR | 8 | ||
MKT_COST | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
MKT_COST_REIMB | Marketing Cost Reimbursement | OIUX3_MARKETING_COST_REIMB | CURR | 6 | ||
GP_TAX_AMT | Tax 2.0 - Gross Production Tax Amount | OIUX5_GROSS_PROD_TAX_AMOUNT | CURR | 6 | ||
PE_TAX_AMT | Tax 2.0 - Petroleum Excise Tax Amount | OIUX5_PETRO_EXCISE_TAX_AMOUNT | CURR | 6 | ||
RF_TAX_AMT | Tax 2.0 - Revolving Fund Tax Amount | OIUX5_REVOLVE_FUND_TAX_AMOUNT | CURR | 6 | ||
MP_TAX_AMT | Tax 2.0 - Marginally Producing Tax Amount | OIUX5_MARGINAL_PROD_TAX_AMOUNT | CURR | 6 | ||
KW_TAX_AMT | Tax 2.0 - Kiowa Tax Amount | OIUX5_KIOWA_TAX_AMOUNT | CURR | 6 | ||
CA_TAX_AMT | Tax 2.0 - Cheyenne/Arapaho Tax Amount | OIUX5_CHEYENNE_ARAPAHO_TAX_AMT | CURR | 6 | ||
XX_TAX_AMT | Tax 2.0 - XX Tax Amount | OIUX5_XX_TAX_AMT | CURR | 6 | ||
.INCLUDE | ROIUT5_TAXTXN_NONKEY_DERIVED | ROIUT5_TAXTXN_NONKEY_DERIVED | 0 | |||
EXEMPT_CODE_1 | Tax 2.0 OKGP - Entity Type 01 Exempt Code | OIUT5_EXEMPT_CODE_1 | NUMC | 4 | OIUT5_EXCD | |
EXEMPT_CODE_2 | Tax 2.0 OKGP - Entity Type 02 Exempt Code | OIUT5_EXEMPT_CODE_2 | NUMC | 4 | OIUT5_EXCD | |
EXEMPT_CODE_3 | Tax 2.0 OKGP - Entity Type 03 Exempt Code | OIUT5_EXEMPT_CODE_3 | NUMC | 4 | OIUT5_EXCD | |
EXEMPT_CODE_4 | Tax 2.0 OKGP - Entity Type 04 Exempt Code | OIUT5_EXEMPT_CODE_4 | NUMC | 4 | OIUT5_EXCD | |
EXEMPT_CODE_5 | Tax 2.0 OKGP - Entity Type 05 Exempt Code | OIUT5_EXEMPT_CODE_5 | NUMC | 4 | OIUT5_EXCD | |
MASTER_LEVEL | Tax 2.0 - Master Level | OIUX5_MASTER_LEVEL | CHAR | 2 | ||
PROD_PURCH_NO | Tax 2.0 - Oklahoma Producer/Purchaser Number | OIUX5_OK_PROD_PURCH_NUMBER | NUMC | 10 | ||
OK_PRODUCT_CODE | Tax 2.0 - Oklahoma Product Code | OIUX5_OK_PRODUCT_CODE | NUMC | 2 | ||
TAXPAYER_NUMBER | Tax 2.0 - Oklahoma Taxpayer Number | OIUX5_OK_TAXPAYER_NUMBER | NUMC | 10 | ||
FEIN_SSN | Tax 2.0 - FEIN/SSN | OIUX3_FEIN_SSN | NUMC | 18 | ||
REFERENCE_RUN_ID | Run ID of Tax Report | OIUX3_RUN_ID | NUMC | 20 | ||
PRODUCTION_DATE | Tax 2.0 OK - Production Date (YYYYMM) | OIUT5_PRODUCTION_DATE | ACCP | 12 | ||
.INCLUDE | OIU_CREATION | 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 |