SAP ABAP Table OIUX3_TX_RPODT (Tax Reporting - Texas Oil Report Details)
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 | TRANSP | Transparent table |
Transparent table | OIUX3_TX_RPODT | Table Relationship Diagram |
Short Description | Tax Reporting - Texas Oil Report Details |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | .INCLUDE | 0 | 0 | Tax Reporting - Texas Oil Report Details Key Fields | |||||
3 | .INCLUDE | 0 | 0 | Tax Reporting - Texas Oil Report Summary Key Fields | |||||
4 | RUN_ID | OIUX3_RUN_ID | NUMC10 | NUMC | 10 | 0 | Tax Reporting - Run ID | ||
5 | PROD_PURC_IND | OIUX3_PRODUCER_PURCHASER_IND | OIUX3_PRODUCER_PURCHASER_IND | CHAR | 1 | 0 | Tax Reporting - Producer/Purchaser Indicator | ||
6 | TAXPAYER_NUMBER | OIUX3_TX_TAXPAYER_NUMBER | NUMC | 11 | 0 | Tax Reporting - Texas Taxpayer Number | |||
7 | FILING_PERIOD | OIUX3_TX_FILING_PERIOD | NUMC | 4 | 0 | Tax Reporting - Texas Filing Period (YYMM) | |||
8 | COUNTY | OIUX3_TX_COUNTY | NUMC3 | NUMC | 3 | 0 | Tax Reporting - Texas County | * | |
9 | LEASE_NUMBER | OIUX3_TX_LEASE_NUMBER | CHAR7 | CHAR | 7 | 0 | Tax Reporting - Texas Lease | * | |
10 | EXEMPTION_TYPE | OIUX3_TX_EXEMPTION_TYPE | NUMC2 | NUMC | 2 | 0 | Tax Reporting - Texas Exemption Type | ||
11 | API_WELL_NUMBER | OIUX3_TX_API_WELL_NUMBER | CHAR8 | CHAR | 8 | 0 | Tax Reporting - Texas API Well Number | ||
12 | OTHER_PARTY_NO | OIUX3_TX_OTHER_PARTY_NUMBER | TEXT11 | CHAR | 11 | 0 | Tax Reporting - Texas Other Party Taxpayer Number | ||
13 | INCR_EXCEPT_IND | OIUX3_TX_INCR_EXCEPTION_IND | OIUX3_TX_INCR_EXCEPTION_IND | CHAR | 1 | 0 | Tax Reporting - Texas Incremental Exception Indicator | ||
14 | TAX_LIABILITY | OIUX3_TX_TAX_LIABILITY_IND | OIUX3_TX_TAX_LIABILITY_IND | CHAR | 1 | 0 | Tax Reporting - Texas Tax Liability Indicator | ||
15 | .INCLUDE | 0 | 0 | Tax Reporting - Texas Oil Report Details Non Key Fields | |||||
16 | DRILL_PERMIT | OIUX3_TX_DRILL_PERMIT | YESNO | CHAR | 1 | 0 | Tax Reporting - Texas Drill Permit? | ||
17 | LEASE_OPERATOR | OIUX3_TX_LEASE_OPERATOR_IND | OIUX3_TX_LEASE_OPERATOR_IND | CHAR | 1 | 0 | Tax Reporting - Texas Lease Operator Indicator | ||
18 | GRAVITY | OIUH_GRAVITY | OIUH_DEC3_1 | DEC | 3 | 1 | Gravity | ||
19 | GROSS_VOL | OIUX3_GROSS_BARRELS | OIUX3_SIGNED_DEC_11_2 | DEC | 11 | 2 | Tax Reporting - Gross Barrels | ||
20 | EXEMPT_VOL | OIUX3_EXEMPT_BARRELS | OIUX3_SIGNED_DEC_11_2 | DEC | 11 | 2 | Tax Reporting - Exempt Barrels | ||
21 | TAX_VOL | OIUX3_TAXABLE_BARRELS | OIUX3_SIGNED_DEC_11_2 | DEC | 11 | 2 | Tax Reporting - Taxable Barrels | ||
22 | GROSS_VAL | OIUX3_GROSS_VALUE | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Gross Value | ||
23 | EXEMPT_VAL | OIUX3_EXEMPT_VALUE | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Tax Reporting - Exempt Value | ||
24 | MKT_COST | OIUX3_TRUCKING_MARKETING_COST | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Tax Reporting - Trucking (Marketing) Cost | ||
25 | TAX_VAL | OIUX3_NET_TAXABLE_VALUE | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Tax Reporting - Net Taxable Value | ||
26 | TAXPAYER_NAME | OIUX3_TAXPAYER_NAME | TEXT100 | CHAR | 100 | 0 | Taxpayer Name | ||
27 | LEASE_NAME | OIUX3_TX_LEASE_NAME | TEXT50 | CHAR | 50 | 0 | Tax Reporting - Texas Lease Name | ||
28 | COUNTY_NAME | OIUX3_TX_COUNTY_NAME | TEXT30 | CHAR | 30 | 0 | Tax Reporting - Texas County Name | ||
29 | OTHER_PARTY_NAME | OIUCM_BA_NAME | CHAR38 | CHAR | 38 | 0 | Business Associate Name | ||
30 | TAX_RATE_VAL | OIUVL_VAL_TAX_RAT | OIUVL_PERCENT76 | DEC | 7 | 6 | Value tax rate | ||
31 | ST_TAX_AMT_DUE | OIUX3_STATE_TAX_AMOUNT_DUE | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Tax Reporting - State Tax Amount Due | ||
32 | .INCLUDE | 0 | 0 | Creator and date/time created | |||||
33 | OIU_CRUSER | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
34 | OIU_TIMESTAMP | TZNTSTMPS | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
35 | EDIT_ERROR | OIUX3_REPORT_EDIT_ERROR | YESNO | CHAR | 1 | 0 | Tax 2.0 - Report Edit Error |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | OIUX3_TX_RPODT | MANDT | T000 | MANDT | KEY |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 46C |