/PRA/TA_IOOSHST

Tax 2.0 CO - Out-of-Statute Income Transaction Hst (21PD) | #transactional | Component: Production and Revenue Accounting
Column Name Description
MANDT Client
BUKRS FK Company Code
SALES_DT Sales Date / Month
PDCD FK Full three char. product code (Major and Detail Products)
WL_NO FK Well ID number
WC_NO FK Well Completion Number
MP_NO FK Measurement point number
VNAME FK Joint venture
DOI_NO FK Division of interest (DOI)
DN_NO FK Delivery network number
CT_NO FK Contract Number
VL_TYPE_CD FK Volume type code
OWNER_IDENTIFIER Tax 2.0 CO - Owner Identifier
REV_BOOK_ADJ_IND Reversal/Booking/Adjustment Show values
Column Name Description
💲 Currency Key (T001.WAERS):
TRANS_AM Tax 2.0 CO - Transaction Amount
MKT_AMT_1 Marketing Cost
MKT_AMT_2 Marketing Cost
MKT_AMT_3 Marketing Cost
MKT_AMT_4 Marketing Cost
MKT_AMT_5 Marketing Cost
MKT_AMT_6 Marketing Cost
MKT_AMT_7 Marketing Cost
MKT_AMT_8 Marketing Cost
MKT_AMT_9 Marketing Cost
MKT_AMT_10 Marketing Cost
AV_TAX_AMT Tax 2.0 CO - Ad Valorem Tax amount
TRANSPORTATION Tax 2.0 CO - Transportation Cost
PROC_MANU Tax 2.0 CO - Processing and Manuf. Costs
Column Name Description
📏 Unit of Measurement (T006.MSEHI):
PVR_AM Tax 2.0 CO - PVR Amount
TOTAL_VOLUME Total Gross Volume
Column Name Description
SALES_DT Sales Date / Month
Column Name Description
REV_BOOK_ADJ_IND Reversal/Booking/Adjustment Show values
EXEMPT_FLAG Tax 2.0 CO - Exempt Flag Show values
OOS_FL Out of Statute Show values
REV_PRCS_CD Revenue Process Code Show values
REJ_SUSP_IND Rejection-Suspension Status Show values
OIL_GAS_IND Tax 2.0 CO - Oil/Gas Indicator Show values
INT_CAT_CD Interest Category Show values
Column Name Description Domain name
ACCT_PERD Tax 2.0 CO - Accounting Period
UNIT_VNAME Joint venture JV_NAME
DOC_NO Val. document number OIU_MP_NO
DOC_YEAR Document year GJAHR
OPTION1 Single-Character Flag CHAR1
OPTION2 Single-Character Flag CHAR1
OPTION3 Single-Character Flag CHAR1
INTERFACE_FL Single-Character Flag CHAR1
OWNERSHIP_PERC Tax 2.0 CO - Net Revenue Interest percent
TRANS_QY Tax 2.0 CO - Transaction Quantity OIUH_DEC13_2
CO_ACCT_NO Tax 2.0 CO Sev - Colorado Account Number
SOURCE Tax 2.0 CO - Source of Income /PRA/TA_SOURCE_OF_INCOME
API_NUMBER Tax 2.0 CO - API Number
REFERENCE_RUN_ID Proc 2.0 - Run ID
CHANGE_USER Last Changed By USNAM
CHANGE_TIMESTAMP Last Changed Timestamp /PRA/TZNTSTMPS
Master Data Relations Join Conditions
Company Code
Contract Number
Delivery network number
Division of interest (DOI)
  • Joint venture
  • Division of interest (DOI)
  • Company Code
Cost Center
  • ?
  • Cost Center
  • ?
  • /PRA/TA_IOOSHST.MANDT == CSKS.MANDT
  • /PRA/TA_IOOSHST.[column in domain "DATBI"] == CSKS.DATBI
  • /PRA/TA_IOOSHST.KOSTL == CSKS.KOSTL
  • /PRA/TA_IOOSHST.[column in domain "KOKRS"] == CSKS.KOKRS
Measurement point number
Full three char. product code (Major and Detail Products) /PRA/TA_IOOSHST.PDCD == OIUX3_PDCD.PDCD
Tax 2.0 CO - Reject Code
G/L Account Number
  • ?
  • Client
  • G/L Account Number
  • /PRA/TA_IOOSHST.[column in domain "KTOPL"] == SKA1.KTOPL
  • /PRA/TA_IOOSHST.MANDT == SKA1.MANDT
  • /PRA/TA_IOOSHST.SAKNR == SKA1.SAKNR
Base Unit of Measure
  • /PRA/TA_IOOSHST.MANDT == T006.MANDT
  • /PRA/TA_IOOSHST.UOM == T006.MSEHI
Volume type code /PRA/TA_IOOSHST.VL_TYPE_CD == OIU_PR_VLTYP.VL_TYPE_CD
Joint venture
  • Joint venture
  • Company Code
Well Completion Number
  • Well ID number
  • Well Completion Number
Well ID number