/PRA/T9_TAXSTG - Tax 2.0 LA - Tax Transaction (Staging)
Tax 2.0 LA - Tax Transaction (Staging) information is stored in SAP table /PRA/T9_TAXSTG.
It is part of development package /PRA/TAX_LA in software component IS-OIL-PRA. This development package consists of objects that can be grouped under "Tax 2.0 - Louisiana".
It is part of development package /PRA/TAX_LA in software component IS-OIL-PRA. This development package consists of objects that can be grouped under "Tax 2.0 - Louisiana".
Fields for table /PRA/T9_TAXSTG
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| .INCLUDE | /PRA/S_T9_TAXTXN_KEY | X | /PRA/S_T9_TAXTXN_KEY | 0 | ||
| .INCLUDE | /PRA/S_T9_REVTXN_KEY | X | /PRA/S_T9_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 | OIUCM_CONTRACT |
| 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 |
| REV_BOOK_ADJ_IND | Reversal/Booking/Adjustment | X | /PRA/REVERSE_BOOKING_ADJ_IND | CHAR | 2 | |
| .INCLUDE | /PRA/S_T9_TAXTXN_NONKEY | /PRA/S_T9_TAXTXN_NONKEY | 0 | |||
| UNIT_VNAME | Unit venture | /PRA/UNIT_JV | CHAR | 12 | OIU_DO_JV | |
| PROD_PURC_IND | Producer or Purchaser | OIUX3_PRODUCER_PURCHASER_IND | CHAR | 2 | ||
| OTHER_NO | Customer / Vendor Number | /PRA/CM_CUSTOMER_VENDOR_NUMBER | CHAR | 20 | ||
| VL_TAX_RAT | Volume tax rate | OIUVL_VL_TAX_RAT | DEC | 4 | ||
| VAL_TAX_RAT | Value tax rate | OIUVL_VAL_TAX_RAT | DEC | 4 | ||
| 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 | Base Unit of Measure | MEINS | UNIT | 6 | T006 | |
| 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 | /PRA/S_T9_TAXTXN_NUMERIC | /PRA/S_T9_TAXTXN_NUMERIC | 0 | |||
| GROSS_VOL | Total Gross Volume | /PRA/GROSS_VOL | QUAN | 7 | ||
| WET_LESS_RESIDUE | Wet-less-residue volume | OIUVL_WLR_VL | QUAN | 7 | ||
| EXEMPT_VOL | Exempt Volume | /PRA/EXEMPT_VOL | QUAN | 7 | ||
| TAX_VOL | Taxable Volume | /PRA/TAX_VOL | QUAN | 7 | ||
| GROSS_VAL | Gross value | /PRA/GROSS_VAL | CURR | 7 | ||
| EXEMPT_VAL | Exempt Value | /PRA/EXEMPT_VAL | CURR | 7 | ||
| MKT_COST | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
| FIXED_MKT_COST | Tax 2.0 LA - Fixed Marketing Cost | /PRA/T9_FIXED_MARKETING_COST | CURR | 6 | ||
| MKT_COST_REIMB | Marketing Cost Reimbursement | OIUX3_MARKETING_COST_REIMB | CURR | 6 | ||
| TAX_VAL | Taxable Value | /PRA/TAX_VAL | CURR | 7 | ||
| SV_TAX_AMT | Tax 2.0 LA - Severance Tax amount | /PRA/T9_SEVERANCE_TAX_AMOUNT | CURR | 6 | ||
| RF_TAX_AMT | Tax 2.0 LA - Oil Field Restoration Fee | /PRA/T9_RESTORATION_FEE | CURR | 6 | ||
| INTEREST | Tax 2.0 LA - Interest | /PRA/T9_INTEREST | CURR | 6 | ||
| .INCLUDE | /PRA/S_T9_TAXTXN_DERIVED | /PRA/S_T9_TAXTXN_DERIVED | 0 | |||
| RPT_COMPANY_NO | Tax 2.0 LA - Reporting Company Number | /PRA/T9_REPORTING_COMPANY_NO | CHAR | 10 | * | |
| REVENUE_ACCT_NO | Tax 2.0 LA - Tax ID | /PRA/T9_TAX_ID | NUMC | 20 | ||
| MASTER_LEVEL | Texas Master Data Level | OIUX3_TX_MASTER_LEVEL | CHAR | 2 | ||
| .INCLUDE | /PRA/S_T9_MASTER_SUBNONKEY | /PRA/S_T9_MASTER_SUBNONKEY | 0 | |||
| LEASE_NO | Tax 2.0 LA - Lease Number | /PRA/T9_LEASE_NO | NUMC | 12 | /PRA/T9_LEASE | |
| PARISH | Tax 2.0 LA - Parish | /PRA/T9_PARISH | NUMC | 4 | ||
| PLANT_ID | Tax 2.0 LA - Plant ID | /PRA/T9_PLANT_ID | CHAR | 6 | /PRA/C_T9_PLT | |
| REPORTING_NAME | Tax 2.0 LA - Reporting Name | /PRA/T9_REPORTING_NAME | CHAR | 76 | ||
| MULTI_PARISH | Tax 2.0 LA - Multiple Parish | /PRA/T9_MULTIPLE_PARISHS | CHAR | 2 | ||
| .INCLUDE | /PRA/S_T9_LEASE_SUBNONKEY | /PRA/S_T9_LEASE_SUBNONKEY | 0 | |||
| FIELD_ID | Tax 2.0 LA - Field ID | /PRA/T9_FIELD_ID | CHAR | 8 | /PRA/C_T9_FLD | |
| PROD_CD | Tax 2.0 LA - Producer Code | /PRA/T9_PRODUCER_CD | CHAR | 10 | * | |
| OPERATED_FL | Operated flag | OIU_OPERATOR_FL | CHAR | 2 | ||
| OTHER_CD | Tax 2.0 LA - Producer/Transporter Code | /PRA/T9_PROD_TRANSP_CD | CHAR | 10 | * | |
| .INCLUDE | /PRA/S_T9_PDCXRF_NONKEY | /PRA/S_T9_PDCXRF_NONKEY | 0 | |||
| KIND_CD | Tax 2.0 LA - Kind Code | /PRA/T9_KIND_CD | NUMC | 2 | ||
| .INCLUDE | /PRA/S_T9_TRCXRF_NONKEY | /PRA/S_T9_TRCXRF_NONKEY | 0 | |||
| TAX_RATE_CD | Tax 2.0 LA - Tax Rate Code | /PRA/T9_TAX_RATE_CODE | CHAR | 4 | /PRA/C_T9_TRC | |
| DEEP_OR_HORIZ_WL | Tax 2.0 LA - Deep or Horizontal Well | /PRA/T9_DEEP_OR_HORIZONTAL_WL | CHAR | 2 | ||
| .INCLUDE | /PRA/S_T9_REJECT_SUSPEND | /PRA/S_T9_REJECT_SUSPEND | 0 | |||
| REJ_SUSP_IND | Rejection-Suspension Status | OIUX3_REJECT_SUSPEND_IND | CHAR | 2 | ||
| REJ_CD | Tax 2.0 LA - Reject Code | /PRA/T9_REJECT_CODE | CHAR | 4 | /PRA/C_T9_REJ | |
| REFERENCE_RUN_ID | Proc 2.0 - Run ID | OIUE2_RUN_ID | NUMC | 20 | ||
| TAXPAYER_CD | Tax 2.0 LA - Taxpayer Code | /PRA/T9_TAXPAYER_CD | CHAR | 10 | ||
| .INCLUDE | /PRA/LAST_CHANGED | /PRA/LAST_CHANGED | 0 | |||
| CHANGE_USER | Last Changed By | OIUX3_LAST_CHANGED_USER | CHAR | 24 | ||
| CHANGE_TIMESTAMP | Last Changed Timestamp | /PRA/LAST_CHANGED_TZNTSTMPS | DEC | 8 |