OIUX3_TX_OOSTXN - Tax Reporting - Texas Out Of Statute Transactions

Tax Reporting - Texas Out Of Statute Transactions information is stored in SAP table OIUX3_TX_OOSTXN.
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_OOSTXN

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		OIUX3_REVERSE_BOOKING_ADJ_IND	CHAR	2
.INCLUDE				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
.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