SAP ABAP Table ROIUX3_TX_PRDT (Tax Reporting - Texas PRA Detail)
Hierarchy
☛
IS-OIL (Software Component) IS-OIL
⤷ IS-OIL-PRA-REP-TAX (Application Component) Tax Reporting
⤷ OIU_X3 (Package) Tax 2.0
⤷ IS-OIL-PRA-REP-TAX (Application Component) Tax Reporting
⤷ OIU_X3 (Package) Tax 2.0
Basic Data
Table Category | INTTAB | Structure |
Structure | ROIUX3_TX_PRDT | Table Relationship Diagram |
Short Description | Tax Reporting - Texas PRA Detail |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | PRDT | OIUX3_TX_PRDTN | STRU | 0 | 0 | ||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | ||
3 | RUN_ID | OIUX3_RUN_ID | NUMC10 | NUMC | 10 | 0 | Tax Reporting - Run ID | ||
4 | .INCLUDE | 0 | 0 | Tax Reporting - Texas Tax Transactions Key Fields | |||||
5 | .INCLUDE | 0 | 0 | Tax Reporting - Texas Tax Transactions Reversal Key Fields | |||||
6 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | ||
7 | SALES_DT | OIU_SALE_DT | DATUM | DATS | 8 | 0 | Sales Date / Month | ||
8 | PDCD | OIU_FULL_PD_CD | OIU_FULL_PD_CD | CHAR | 3 | 0 | Full three char. product code (Major and Detail Products) | ||
9 | WL_NO | OIU_WL_NO | OIU_WL_NO | CHAR | 15 | 0 | Well ID number | ||
10 | WC_NO | OIU_WC_NO | OIU_WC_NO | CHAR | 5 | 0 | Well Completion Number | ||
11 | MP_NO | OIU_MP_NO | OIU_MP_NO | CHAR | 20 | 0 | Measurement point number | ||
12 | VNAME | JV_NAME | JV_NAME | CHAR | 6 | 0 | Joint venture | ||
13 | DOI_NO | OIU_DOI_NO | OIU_DOI_NO | CHAR | 5 | 0 | Division of interest (DOI) | ||
14 | DN_NO | OIU_DN_NO | OIU_DN_NO | CHAR | 20 | 0 | Delivery network number | ||
15 | CT_NO | OIU_CT_NO | OIUCM_CONTRACT_NUMBER | CHAR | 10 | 0 | Contract Number | ||
16 | VL_TYPE_CD | OIU_VT_CD | OIU_VL_TYPE_CD | CHAR | 2 | 0 | Volume type code | ||
17 | TAX_CLS | OIU_TAX_CLS | OIU_TAX_CLS | CHAR | 4 | 0 | Tax Class | ||
18 | TAX_TYPE | OIU_SEVT_TAX_TY | OIU_SEVT_TAX_TY | CHAR | 2 | 0 | Severance Tax Type | ||
19 | REV_BOOK_ADJ_IND | OIUX3_REVERSE_BOOKING_ADJ_IND | OIUX3_REVERSE_BOOKING_ADJ_IND | CHAR | 1 | 0 | Tax Reporting - Reversal/Booking/Adjustment Indicator | ||
20 | OUT_OF_STATUTE | OIUX3_OUT_OF_STATUTE | YESNO | CHAR | 1 | 0 | Tax Reporting - Out Of Statute Flag | ||
21 | .INCLUDE | 0 | 0 | Tax Reporting - Texas Tax Transactions Non-Key Fields | |||||
22 | PROD_PURC_IND | OIUX3_PRODUCER_PURCHASER_IND | OIUX3_PRODUCER_PURCHASER_IND | CHAR | 1 | 0 | Tax Reporting - Producer/Purchaser Indicator | ||
23 | UNIT_VNAME | JV_NAME | JV_NAME | CHAR | 6 | 0 | Joint venture | ||
24 | PAY_FL | OIU_SEVT_PAY_FL | OIU_SEVT_PAY_FL | CHAR | 1 | 0 | Tax Severance Tax Calculation Payment Obligations Types | ||
25 | RPT_FL | OIU_SEVT_RPT_FL | CHAR1 | CHAR | 1 | 0 | State Severance Tax Reporting Indicators | ||
26 | UOM | OIU_MEAS_U | MEINS | UNIT | 3 | 0 | Measurement unit | ||
27 | LEASE_GROSS_VOL | OIUX3_LEASE_GROSS_VOLUME | OIUX3_SIGNED_DEC_11_2 | DEC | 11 | 2 | Tax Reporting - Lease Gross Volume | ||
28 | GROSS_VOL | OIUX3_GROSS_VOLUME | OIUX3_SIGNED_DEC_11_2 | DEC | 11 | 2 | Gross Volume | ||
29 | GROSS_VAL | OIUX3_GROSS_VALUE | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Gross Value | ||
30 | TAX_VOL | OIUX3_TAXABLE_VOLUME | OIUX3_SIGNED_DEC_11_2 | DEC | 11 | 2 | Taxable Volume | ||
31 | TAX_VAL | OIUX3_TAXABLE_VALUE | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Taxable Value | ||
32 | EXEMPT_VOL | OIUX3_EXEMPT_VOLUME | OIUX3_SIGNED_DEC_11_2 | DEC | 11 | 2 | Tax Reporting - Exempt Volume | ||
33 | EXEMPT_VAL | OIUX3_EXEMPT_VALUE | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Tax Reporting - Exempt Value | ||
34 | MKT_COST | OIUX3_MARKETING_COST | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Marketing Cost | ||
35 | MKT_COST_REIMB | OIUX3_MARKETING_COST_REIMB | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Marketing Cost Reimbursement | ||
36 | TAX_AMT | OIUX3_TAX_AMOUNT | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Tax Reporting - Tax Amount | ||
37 | TAX_REIMB | OIUX3_TAX_REIMBURSEMENT | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Tax Reporting - Tax Reimbursement | ||
38 | TAX_RATE_VOL | OIUVL_VL_TAX_RAT | OIUVL_PERCENT76 | DEC | 7 | 6 | Volume tax rate | ||
39 | TAX_RATE_VAL | OIUVL_VAL_TAX_RAT | OIUVL_PERCENT76 | DEC | 7 | 6 | Value tax rate | ||
40 | GRAVITY | OIUH_GRAVITY | OIUH_DEC3_1 | DEC | 3 | 1 | Gravity | ||
41 | .INCLUDE | 0 | 0 | Tax Reporting - Texas Master Data Nonkey Fields | |||||
42 | API_WELL_NUMBER | OIUX3_TX_API_WELL_NUMBER | CHAR8 | CHAR | 8 | 0 | Tax Reporting - Texas API Well Number | ||
43 | COUNTY | OIUX3_TX_COUNTY | NUMC3 | NUMC | 3 | 0 | Tax Reporting - Texas County | ||
44 | LEASE_NUMBER | OIUX3_TX_LEASE_NUMBER | CHAR7 | CHAR | 7 | 0 | Tax Reporting - Texas Lease | ||
45 | OFF_LEASE_CD | OIUX3_TX_OFF_LEASE_CODE | OIUX3_TX_OFF_LEASE_CODE | CHAR | 1 | 0 | Tax Reporting - Texas On/Off Lease Code | ||
46 | MASTER_LEVEL | OIUX3_TX_MASTER_LEVEL | OIUX3_TX_MASTER_LEVEL | CHAR | 1 | 0 | Tax Reporting - Texas Master Level | ||
47 | .INCLUDE | 0 | 0 | Tax Reporting - Texas Other Party Structure | |||||
48 | OTHER_NO | OIUCM_BUS_ASSOC | OIUCM_BUS_ASSOC | CHAR | 6 | 0 | Business Associate | ||
49 | OTHER_SEQ_NO | OIUCM_SEQ_NO | OIUCM_SEQ_NO | CHAR | 2 | 0 | Sequence Number | ||
50 | OTHER_PARTY_NO | OIUX3_TX_OTHER_PARTY_NUMBER | TEXT11 | CHAR | 11 | 0 | Tax Reporting - Texas Other Party Taxpayer Number | ||
51 | COMMODITY_TYPE | OIUX3_TX_COMMODITY_TYPE | OIUX3_TX_COMMODITY_TYPE | CHAR | 3 | 0 | Tax Reporting - Texas Commodity Type | ||
52 | EXEMPTION_TYPE | OIUX3_TX_EXEMPTION_TYPE | NUMC2 | NUMC | 2 | 0 | Tax Reporting - Texas Exemption Type | ||
53 | TAXPAYER_NUMBER | OIUX3_TX_TAXPAYER_NUMBER | NUMC | 11 | 0 | Tax Reporting - Texas Taxpayer Number | |||
54 | TAXPAYER_NAME | OIUX3_TAXPAYER_NAME | TEXT100 | CHAR | 100 | 0 | Taxpayer Name | ||
55 | OPTION1 | CHAR | 1 | 0 | |||||
56 | OPTION2 | CHAR | 1 | 0 | |||||
57 | OPTION3 | CHAR | 1 | 0 | |||||
58 | .INCLUDE | 0 | 0 | Creator and date/time created | |||||
59 | OIU_CRUSER | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
60 | OIU_TIMESTAMP | TZNTSTMPS | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
61 | TIER_TAX_IND | OIUX3_TIER_TAX_INDICATOR | OIUX3_TIER_TAX_INDICATOR | CHAR | 1 | 0 | Tax Reporting - Tier Tax Indicator | ||
62 | PERCENT | DEC | 5 | 2 |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 46C |