SAP ABAP Table OIUX8_NM_TAXSTG (Tax 2.0 - NM - Tax Transactions (Staging))
Hierarchy
☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-TAX (Application Component) Tax Reporting
     ⤷ OIU_X8 (Package) Tax 2.0 - New Mexico
Basic Data
Table Category TRANSP    Transparent table 
Transparent table OIUX8_NM_TAXSTG   Table Relationship Diagram
Short Description Tax 2.0 - NM - Tax Transactions (Staging)    
Delivery and Maintenance
Pool/cluster      
Delivery Class L   Table for storing temporary data, delivered empty 
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 2.0 - NM - Tax Transactions Key Fields  
3 .INCLUDE       0   0   Tax 2.0 - NM - Tax Reversal Key Fields  
4 BUKRS BUKRS BUKRS CHAR 4   0   Company Code OIU_CM_COMPC
5 SALES_DT OIU_SALE_DT DATUM DATS 8   0   Sales Date / Month  
6 PDCD OIU_FULL_PD_CD OIU_FULL_PD_CD CHAR 3   0   Full three char. product code (Major and Detail Products) OIUX3_PDCD
7 WL_NO OIU_WL_NO OIU_WL_NO CHAR 15   0   Well ID number OIU_PR_WELL
8 WC_NO OIU_WC_NO OIU_WC_NO CHAR 5   0   Well Completion Number OIU_PR_WC
9 MP_NO OIU_MP_NO OIU_MP_NO CHAR 20   0   Measurement point number OIU_PR_MP
10 VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture OIU_DO_JV
11 DOI_NO OIU_DOI_NO OIU_DOI_NO CHAR 5   0   Division of interest (DOI) OIU_DO_DI
12 DN_NO OIU_DN_NO OIU_DN_NO CHAR 20   0   Delivery network number OIU_PR_DN
13 CT_NO OIU_CT_NO OIUCM_CONTRACT_NUMBER CHAR 10   0   Contract Number OIU_RV_CT
14 VL_TYPE_CD OIU_VT_CD OIU_VL_TYPE_CD CHAR 2   0   Volume type code OIU_PR_VLTYP
15 TAX_CLS OIU_TAX_CLS OIU_TAX_CLS CHAR 4   0   Tax Class OIU_CM_TAXCLS
16 SUFFIX OIUX8_NM_SUFFIX CHAR5 CHAR 5   0   Tax 2.0 - New Mexico Suffix for School Dist Code  
17 REV_BOOK_ADJ_IND OIUX8_REV_BOOK_REVADJ_ADJ_IND OIUX8_REV_BOOK_REVADJ_ADJ_IND CHAR 1   0   Tax 2.0 - NM Reversal/Booking/Reversal Adjustment/Adjustment  
18 .INCLUDE       0   0   Tax 2.0 - NM - Tax Transactions Non-Key Fields  
19 UNIT_VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture OIU_DO_JV
20 PAY_FL OIU_SEVT_PAY_FL OIU_SEVT_PAY_FL CHAR 1   0   Tax Severance Tax Calculation Payment Obligations Types  
21 RPT_FL OIU_SEVT_RPT_FL CHAR1 CHAR 1   0   State Severance Tax Reporting Indicators  
22 UOM OIU_MEAS_U MEINS UNIT 3   0   Measurement unit T006
23 GROSS_VOL OIUX3_GROSS_VOLUME OIUX3_SIGNED_DEC_11_2 DEC 11   2   Gross Volume  
24 GROSS_VAL OIUX3_GROSS_VALUE OIUX3_SIGNED_CURR_11_2 CURR 11   2   Gross Value  
25 TAX_VOL OIUX3_TAXABLE_VOLUME OIUX3_SIGNED_DEC_11_2 DEC 11   2   Taxable Volume  
26 TAX_VAL OIUX3_TAXABLE_VALUE OIUX3_SIGNED_CURR_11_2 CURR 11   2   Taxable Value  
27 EXEMPT_VOL OIUX3_EXEMPT_VOLUME OIUX3_SIGNED_DEC_11_2 DEC 11   2   Tax Reporting - Exempt Volume  
28 EXEMPT_VAL OIUX3_EXEMPT_VALUE OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax Reporting - Exempt Value  
29 MKT_COST_01 OIUX3_MARKETING_COST OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost  
30 MKT_COST_02 OIUX3_MARKETING_COST OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost  
31 MKT_COST_03 OIUX3_MARKETING_COST OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost  
32 MKT_COST_04 OIUX3_MARKETING_COST OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost  
33 MKT_COST_05 OIUX3_MARKETING_COST OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost  
34 MKT_COST_06 OIUX3_MARKETING_COST OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost  
35 MKT_COST_07 OIUX3_MARKETING_COST OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost  
36 MKT_COST_08 OIUX3_MARKETING_COST OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost  
37 MKT_COST_09 OIUX3_MARKETING_COST OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost  
38 MKT_COST_10 OIUX3_MARKETING_COST OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost  
39 MKT_COST_REIMB01 OIUX3_MARKETING_COST_REIMB OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost Reimbursement  
40 MKT_COST_REIMB02 OIUX3_MARKETING_COST_REIMB OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost Reimbursement  
41 MKT_COST_REIMB03 OIUX3_MARKETING_COST_REIMB OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost Reimbursement  
42 MKT_COST_REIMB04 OIUX3_MARKETING_COST_REIMB OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost Reimbursement  
43 MKT_COST_REIMB05 OIUX3_MARKETING_COST_REIMB OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost Reimbursement  
44 MKT_COST_REIMB06 OIUX3_MARKETING_COST_REIMB OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost Reimbursement  
45 MKT_COST_REIMB07 OIUX3_MARKETING_COST_REIMB OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost Reimbursement  
46 MKT_COST_REIMB08 OIUX3_MARKETING_COST_REIMB OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost Reimbursement  
47 MKT_COST_REIMB09 OIUX3_MARKETING_COST_REIMB OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost Reimbursement  
48 MKT_COST_REIMB10 OIUX3_MARKETING_COST_REIMB OIUX3_SIGNED_CURR_11_2 CURR 11   2   Marketing Cost Reimbursement  
49 SV_TAX_AMT OIUX8_NM_SEVERANCE_TAX_AMOUNT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - NM - Severance Tax Amount  
50 CN_TAX_AMT OIUX8_NM_CONSERVATION_TAX_AMT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - NM - Conservation Tax Amount  
51 ES_TAX_AMT OIUX8_NM_EMERGENCY_TAX_AMOUNT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - NM - Emergency School Tax Amount  
52 AV_TAX_AMT OIUX8_NM_AD_VALOREM_TAX_AMT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - NM - Ad Valorem Tax Amount  
53 XX_TAX_AMT OIUX8_NM_XX_TAX_AMOUNT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - NM - XX Tax Amount  
54 TAX_REIMB OIUX3_TAX_REIMBURSEMENT OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax Reporting - Tax Reimbursement  
55 BLPS_GROSS_VOL OIUX8_NM_BLPS_GROSS_VOLUME OIUX3_SIGNED_DEC_11_2 DEC 11   2   Tax 2.0 - NM Before Lease Plant Split Gross Volume  
56 BLPS_GROSS_VAL OIUX8_NM_BLPS_GROSS_VALUE OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - NM Before Lease Plant Split Gross Value  
57 RET_LSE_PC OIUCA_RET_LSE_PC OIU_PERCENT63 DEC 6   3   Percent Returned to Lease  
58 PLANT_PROC_ALLOW OIUX8_NM_PLANT_PROC_ALLOWANCE OIUX3_SIGNED_CURR_11_2 CURR 11   2   Tax 2.0 - NM Plant Processing Allowance  
59 .INCLUDE       0   0   Tax 2.0 - NM - Master Data Nonkey Fields  
60 PUN OIUX8_NM_PUN   NUMC 7   0   Tax 2.0 - NM - PUN  
61 AFF_BY_AUDIT OIUX8_NM_AFFECTED_BY_AUDIT_FL YESNO CHAR 1   0   Tax 2.0 - NM - Affected By Audit Flag (TC 55)  
62 MASTER_LEVEL OIUX3_TX_MASTER_LEVEL OIUX3_TX_MASTER_LEVEL CHAR 1   0   Tax Reporting - Texas Master Level  
63 OPER_PURCH_IND OIUX8_OPERATOR_PURCHASER_IND OIUX8_OPERATOR_PURCHASER_IND CHAR 1   0   Tax 2.0 - NM - Operator/Purchaser Indicator  
64 SPEC_TAX_RATE_CD OIUX8_NM_SPECIAL_TAX_RATE_CODE   CHAR 3   0   Tax 2.0 - NM - Special Tax Rate Code  
65 NM_PRODUCT_CODE OIUX8_NM_PRODUCT_CODE OIUX8_NM_PRODUCT_CODE CHAR 2   0   Tax 2.0 - NM - Product Code  
66 AFFILIATION_CODE OIUX8_NM_AFFILIATION_CODE OIUX8_NM_AFFILIATION_CODE CHAR 2   0   Tax 2.0 - NM - Affilication Code  
67 TRANSACTION_CODE OIUX8_NM_TRANSACTION_CODE OIUX8_NM_TRANSACTION_CODE CHAR 2   0   Tax 2.0 - NM - Transaction Code  
68 OGRID OIUX8_NM_OGRID   NUMC 6   0   Tax 2.0 - NM - Oil & Gas Reporting Identification Number  
69 DOC_NO OIURV_DOCNR OIU_MP_NO CHAR 20   0   Val. document number *
70 DOC_YEAR OIU_DOC_YEAR GJAHR NUMC 4   0   Document year  
71 INTERFACE_FL OIUX8_NM_INTERFACE_FL OIUX8_NM_EXT_UPDATE CHAR 1   0   Tax 2.0 - NM - Interface Flag  
72 OPTION1     CHAR 1   0    
73 OPTION2     CHAR 1   0    
74 OPTION3     CHAR 1   0    
75 REJ_SUSP_IND OIUX3_REJECT_SUSPEND_IND OIUX3_REJECT_SUSPEND_IND CHAR 1   0   Tax Reporting - Reject/Suspend Indicator  
76 REJ_CD OIUX8_NM_REJECT_CODE OIUX8_NM_REJECT_CODE CHAR 2   0   Tax 2.0 - NM - Reject Code OIUX8_NM_REJ
77 .INCLUDE       0   0   Creator and date/time created  
78 OIU_CRUSER ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
79 OIU_TIMESTAMP TZNTSTMPS TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 OIUX8_NM_TAXSTG BUKRS OIU_CM_COMPC BUKRS KEY    
2 OIUX8_NM_TAXSTG CT_NO OIU_RV_CT CT_NO KEY    
3 OIUX8_NM_TAXSTG DN_NO OIU_PR_DN DN_NO KEY    
4 OIUX8_NM_TAXSTG DOI_NO OIU_DO_DI DOI_NO KEY    
5 OIUX8_NM_TAXSTG MANDT T000 MANDT KEY    
6 OIUX8_NM_TAXSTG MP_NO OIU_PR_MP MP_NO KEY    
7 OIUX8_NM_TAXSTG PDCD OIUX3_PDCD PDCD KEY    
8 OIUX8_NM_TAXSTG REJ_CD OIUX8_NM_REJ REJ_CD REF    
9 OIUX8_NM_TAXSTG TAX_CLS OIU_CM_TAXCLS TAX_CLS KEY    
10 OIUX8_NM_TAXSTG UNIT_VNAME OIU_DO_JV VNAME REF    
11 OIUX8_NM_TAXSTG UOM T006 MSEHI REF    
12 OIUX8_NM_TAXSTG VL_TYPE_CD OIU_PR_VLTYP VL_TYPE_CD KEY    
13 OIUX8_NM_TAXSTG VNAME OIU_DO_JV VNAME KEY    
14 OIUX8_NM_TAXSTG WC_NO OIU_PR_WC WC_NO KEY    
15 OIUX8_NM_TAXSTG WL_NO OIU_PR_WELL WL_NO KEY    
History
Last changed by/on SAP  20130529 
SAP Release Created in 100